problem to add result in database with jquery

problem to add result in database with jquery

hello, i have a problem to add my result in my database, look at my code :

index2.php
  2. <!doctype html>
  3. <html lang="en">
  4. <head>
  5.     <meta charset="iso-8859-1">
  6.     <title>Calcul mental</title>
  7.     <link rel="stylesheet" href="css/normalize.css">
  8.     <link rel="stylesheet" href="css/foundation.min.css">
  9.     <script src="http://code.jquery.com/jquery-latest.min.js"></script>
  11. </head>
  12. <body>

  14. <div class="row">
  15. <h1>Calcul Mental</h1>
  16. <div class="columns large-12">
  17. <h2>Quel est le résultat de ? </h2>
  18. <div class="columns large-6">
  19. <form class="mental_form2" method="post" id="mental_form2" action="calcul.php">
  20. <div class="columns large-4">
  21. <input class="champ" type="text" name="n1" id="n1">
  22. </div>
  23. <div class="columns large-4">
  24. <input class="champ" type="text" name="si1" id="si1">
  25. </div>
  26. <div class="columns large-4">
  27. <input class="champ" type="text" name="n2" id="n2">
  28. </div>
  29. <div class="columns large-4">
  30. <label for="reponse">Votre réponse</label>
  31. </div>
  32. <div class="columns large-4">
  33. <input type="text" name="result" id="result">
  34. </div>
  35. <div class="columns large-4">
  36. <input type="submit"  id="validation" value="Valider" class="button small right">
  37. </div>
  38. </form>
  39. </div>
  40. <div class="columns large-6 res">
  42. </div>
  43. </div>
  44. </div>
  45. <span id="chronotime">0:00:00:00</span>
  46. <script src="js/api.js"></script>
  47. </body>
  48. </html>


api.js


  3. startTime = 0
  4. var start = 0
  5. var end = 0
  6. var diff = 0
  7. var timerID = 0
  8. function chrono(){
  9. end = new Date()
  10. diff = end - start
  11. diff = new Date(diff)
  12. var msec = diff.getMilliseconds()
  13. var sec = diff.getSeconds()
  14. var min = diff.getMinutes()
  15. var hr = diff.getHours()-1
  16. if (min < 10){
  17. min = "0" + min
  18. }
  19. if (sec < 10){
  20. sec = "0" + sec
  21. }
  22. if(msec < 10){
  23. msec = "00" +msec
  24. }
  25. else if(msec < 100){
  26. msec = "0" +msec
  27. }
  28. document.getElementById("chronotime").innerHTML = hr + ":" + min + ":" + sec + ":" + msec
  29. timerID = setTimeout("chrono()", 10)
  30. }

  32. function chronoStop(){
  33. clearTimeout(timerID)
  34. }
  35. function chronoContinue(){
  36. start = new Date()-diff
  37. start = new Date(start)
  38. chrono()
  39. }

  41. function chronoStart(){
  42. start = new Date()
  43. chrono()
  44. }

  46. function init(){
  47. var n1 = 1 + Math.floor(Math.random() * 10);
  48. var si1 = '+';
  49. var n2 = 1 + Math.floor(Math.random() * 10);
  50. $('#n1').val(n1);
  51. $('#si1').val(si1);
  52. $('#n2').val(n2);
  53. }
  54. function success(){
  55. $('.res').html('<div data-alert class="success alert-box">Bien joué ! <a href="#" class="close">&times;</a></div>');
  56. }
  57. function error(){
  58. $('.res').html('<div data-alert class="alert alert-box">Dommage ! même joueur joue encore ! <a href="#" class="close">&times;</a></div>');
  59. }


  62. function send(){
  64. $('#mental_form2').submit(function() {
  65. alert('jusque la ok');
  66. $.post('calcul.php', { 
  68. n1: $('#mental_form2 input[name=n1]').val(),
  69. si1: $('#mental_form2 input[name=si1]').val(),
  70. n2: $('#mental_form2 input[name=n2]').val(),
  71. result: $('#mental_form2 input[name=result]').val()
  72. }
  73. );
  74. return false; 
  75. });
  76. }
  77. function check(){
  78. var n1 = $('#n1').val();
  79. var si1 = $('#si1').val();
  80. var n2 = $('#n2').val();
  81. var r1 = parseInt(n1) + parseInt(n2);
  82. var r2 = $('#result').val();
  83. if( r1 == r2){
  84. send();
  85. success();
  86. }else{
  87. error();
  88. }
  89. $('#result').val('');
  90. }
  91. $(document).ready(function(){
  92. init();
  93. chronoStart();
  94. })
  95. $('#validation').click(function(){
  96. check();
  97. init();
  98. })


calcul.php

  2. <?php
  3. session_start();
  4. // set error reporting level
  5. if (version_compare(phpversion(), '5.3.0', '>=') == 1)
  6.   error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
  7. else
  8.   error_reporting(E_ALL & ~E_NOTICE);
  9.   
  10. require_once('classes/CMySQL.php');
  11. require_once('classes/Ccalcul.php');


  14. if ($_SESSION['member_id'] && $_SESSION['member_status'] == 'active' && $_SESSION['member_role'])

  16. {
  17. $sChi1 = $GLOBALS['MySQL']->escape($_POST['n1']);
  18. $sSi1 = $GLOBALS['MySQL']->escape($_POST['si1']);
  19. $sChi2 = $GLOBALS['MySQL']->escape($_POST['n2']);
  20. $sVotresultat_1 = $GLOBALS['MySQL']->escape($_POST['result']);
  22. if ($sChi1 && $sSi1 && $sChi2 && $sVotresultat_1) 
  24. {
  25. $Accept2 = $GLOBALS['Ccalcul']->acceptcalcul_1();
  26. }
  27. }
  28. echo (file_get_contents('templates/index2.php'));

  30. ?>

Calcul.php

  2. <?php
  3.   
  4. class Ccalcul {
  5.   
  6.     function Ccalcul() {}
  7.       
  8.     // Accept votresultat
  9.       
  10.     function acceptcalcul_1() 
  11.         {
  12.               
  13.             $sChi1 = $GLOBALS['MySQL']->escape($_POST['n1']);
  14.             $sSi1 = $GLOBALS['MySQL']->escape($_POST['si1']);
  15.             $sChi2 = $GLOBALS['MySQL']->escape($_POST['n2']);
  16.             $sVotresultat_1 = $GLOBALS['MySQL']->escape($_POST['result']);
  17.   
  18.         if ($sChi1 && $sSi1 && $sChi2 && $sVotresultat_1) 
  19.       
  20.             {
  21.                 $bRf = $GLOBALS['MySQL']->res("INSERT INTO `addition` SET 
  22.                     `chiffre1` = '{$sChi1}',
  23.                     `signe1` = '{$sSi1}',
  24.                     `chiffre2` = '{$sChi2}',
  25.                     `votresultat` = '{$sVotresultat_1}'
  27. ");
  28.                       
  29.             }
  30.         }
  31.           
  32. }
  33. $GLOBALS['Ccalcul'] = new Ccalcul();

CMysql.php

  2. <?php

  4. class CMySQL {

  6.     // variables
  7.     var $sDbName;
  8.     var $sDbUser;
  9.     var $sDbPass;

  11.     var $vLink;

  13.     // constructor
  14.     function CMySQL() {
  15.         $this->sDbName = 'site3';
  16.         $this->sDbUser = 'root';
  17.         $this->sDbPass = '';

  19.         // create db link
  20.         $this->vLink = mysql_connect("localhost", $this->sDbUser, $this->sDbPass);

  22.         //select the database
  23.         mysql_select_db($this->sDbName, $this->vLink);

  25.         mysql_query("SET names ISO-8859-1");
  26.     }

  28.     // return one value result
  29.     function getOne($query, $index = 0) {
  30.         if (! $query)
  31.             return false;
  32.         $res = mysql_query($query);
  33.         $arr_res = array();
  34.         if ($res && mysql_num_rows($res))
  35.             $arr_res = mysql_fetch_array($res);
  36.         if (count($arr_res))
  37.             return $arr_res[$index];
  38.         else
  39.             return false;
  40.     }

  42.     // executing sql
  43.     function res($query, $error_checking = true) {
  44.         if(!$query)
  45.             return false;
  46.         $res = mysql_query($query, $this->vLink);
  47.         if (!$res)
  48.             $this->error('Database query error', false, $query);
  49.         return $res;
  50.     }

  52.     // return table of records as result in pairs
  53.     function getPairs($query, $sFieldKey, $sFieldValue, $arr_type = MYSQL_ASSOC) {
  54.         if (! $query)
  55.             return array();

  57.         $res = $this->res($query);
  58.         $arr_res = array();
  59.         if ($res) {
  60.             while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
  61.                 $arr_res[$row[$sFieldKey]] = $row[$sFieldValue];
  62.             }
  63.             mysql_free_result($res);
  64.         }
  65.         return $arr_res;
  66.     }

  68.     // return table of records as result
  69.     function getAll($query, $arr_type = MYSQL_ASSOC) {
  70.         if (! $query)
  71.             return array();

  73.         if ($arr_type != MYSQL_ASSOC && $arr_type != MYSQL_NUM && $arr_type != MYSQL_BOTH)
  74.             $arr_type = MYSQL_ASSOC;

  76.         $res = $this->res($query);
  77.         $arr_res = array();
  78.         if ($res) {
  79.             while ($row = mysql_fetch_array($res, $arr_type))
  80.                 $arr_res[] = $row;
  81.             mysql_free_result($res);
  82.         }
  83.         return $arr_res;
  84.     }

  86.     // return one row result
  87.     function getRow($query, $arr_type = MYSQL_ASSOC) {
  88.         if(!$query)
  89.             return array();
  90.         if($arr_type != MYSQL_ASSOC && $arr_type != MYSQL_NUM && $arr_type != MYSQL_BOTH)
  91.             $arr_type = MYSQL_ASSOC;
  92.         $res = $this->res ($query);
  93.         $arr_res = array();
  94.         if($res && mysql_num_rows($res)) {
  95.             $arr_res = mysql_fetch_array($res, $arr_type);
  96.             mysql_free_result($res);
  97.         }
  98.         return $arr_res;
  99.     }

  101.     // escape
  102.     function escape($s) {
  103.         return mysql_real_escape_string(strip_tags($s));
  104.     }

  106.     // get last id
  107.     function lastId() {
  108.         return mysql_insert_id($this->vLink);
  109.     }

  111.     // display errors
  112.     function error($text, $isForceErrorChecking = false, $sSqlQuery = '') {
  113.         echo $text; exit;
  114.     }
  115. }

  117. $GLOBALS['MySQL'] = new CMySQL();
Thanks to answer