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.
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 有人会搭建GPT-J-6B框架吗?有偿
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名