douzi8548 2013-12-29 19:17
浏览 92
已采纳

使用JavaScript将数据发送到MySQL

I am looking for a simple way to send data from client to server database. I exept a simple piece of code in java that sends data from client to server in any way.

For example in this code I want to store in my database how many times the button was pressed by some user(with some id, we use id to find a row in database and increment value in second column).

<html>
  <head>
    <title>test</title>
    <script language="JavaScript">
      function count(form){
        form.games.value=eval(form.num.value)+1;
      }
    </script>
  </head>

  <body>
    <?php
      $con=new mysqli(mysql_host,mysql_user,mysql_password,mysql_database);
      $sql="select * from Users where ID='".$_POST['id']."'";
      $result=$con->query($sql);
      $arr=$result->fetch_row();
      $val=$arr[1];
      echo "
        <form name=\"display\">
        <textarea class=message readonly=true disabled=true name=\"num\">{$val}</textarea>
        <input type=button value=\"Hit\" onClick=\"count(this.form)\">
      ";
    ?>
  </body>
</html>

I hope my question is not too broad this time.

  • 写回答

1条回答 默认 最新

  • douchuo0730 2013-12-29 19:24
    关注

    First, it's called Javascript (one word), to make your questions more clear in the future. You could use jQuery's .get() function to send an HTTP GET request to a PHP page that would record the data onto the database. You can send along with it the data such as ID as the example on the jQuery page.

    Basic flow:

    1. User Clicks Button
    2. jQuery Sends Get request to PHP
    3. PHP Page Executes mysql command to record click
    4. PHP returns successful (you can use a json_encode for the return) or failure.
    5. Your Javascript tells the user that the command was sent successfully.
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值