blocks|key|554837|text|使用jQuery，您可以将单击事件绑定到按钮并发出ajax请求。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|554838|JQuery+ajax文档|unordered-list-item|offset|length|554839|在服务器端，PHP页面应该更新SQL数据。遵循Javascript演示代码|554840|$(document).ready(function(){
++++$('button-selector').click(function(){
++++++++//use+jquery+ajax+call+to+call+php+server+page+that+update+SQL+data
++++++++$.ajax({
++++++++++++++url:+"updateClick.php",
+++++++++++++context:+document.body
+++++++++++++}).success(function()+{+
+++++++++++++++++++++//success+callback
+++++++++++++});
++++});
});|code-block|syntax|javascript|554841|entityMap|0|LINK|mutability|MUTABLE|url|http://api.jquery.com/jQuery.ajax/^0|0|0|D|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@$E|X|F|Y|1|Z]]|A|$]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|11|8|@]|9|@]|A|$L|M]]|$1|N|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

Using jQuery you could bind click event to your button and make ajax request.

<ul>
<li><a href="http://api.jquery.com/jQuery.ajax/" rel="nofollow">JQuery ajax doc</a></li>
</ul>

On server side your PHP page should update SQL data.
Follow Javascript demo code

<pre><code>$(document).ready(function(){
 $('button-selector').click(function(){
 //use jquery ajax call to call php server page that update SQL data
 $.ajax({
 url: "updateClick.php",
 context: document.body
 }).success(function() { 
 //success callback
 });
 });
});
</code></pre>

blocks|key|1128362|text|若要发送AJAX请求，请单击“使用”：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1128363|$('#button').click(function(){+//+when+user+`click`+element+with+`id="button"`+(#button)
+$.ajax({+//+Start+AJAX+call
++url:+'accept.php',+//+URL+to+send+AJAX+request
++success:+function(data)+{+//+Function+to+execute+on+SUCCESS+reply+(reply+data+as+paramenter)
++++var+cc+=+$('#clicks_count').html();+//+In+your+element+with+`id="clicks_count"`+you+store+your+click+count+(`<a+id="clicks_count">21</a>`).+Assign+to+`cc`+javascript+variable+value+of+clicls_count
++++$('#clicks_count').html(cc+%2B+1);+//+Increasing+clicls_count+on+1+and+write+it+to+`<a+id="clicks_count">22</a>`
++}
});
});|code-block|syntax|javascript|1128364|在accept.php使用脚本时，点击次数增加1。|1128365|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

to send AJAX request on clicking use:

<pre><code>$('#button').click(function(){ // when user `click` element with `id="button"` (#button)
 $.ajax({ // Start AJAX call
 url: 'accept.php', // URL to send AJAX request
 success: function(data) { // Function to execute on SUCCESS reply (reply data as paramenter)
 var cc = $('#clicks_count').html(); // In your element with `id="clicks_count"` you store your click count (`&lt;a id="clicks_count"&gt;21&lt;/a&gt;`). Assign to `cc` javascript variable value of clicls_count
 $('#clicks_count').html(cc + 1); // Increasing clicls_count on 1 and write it to `&lt;a id="clicks_count"&gt;22&lt;/a&gt;`
 }
});
});
</code></pre>

At accept.php use script increasing clicks counter by 1.

blocks|key|556717|text|要让它发挥作用是非常简单的。您需要为将来的div提供一些html，您想在其中放置童子军：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|556718|<div+id="counting"></counting>|code-block|syntax|javascript|556719|然后，在生成器()函数的末尾添加以下内容：|556720|function+generator(){
++++/*your+code+here...*/++++
++++var+element+=+document.createElement("div");
++++element.setAttribute("id",+"result");
++++element.appendChild(document.createTextNode(name));
++++document.getElementById("placeholder").appendChild(element);
++++/*the+ajax+code+here*/
++++var+url='urltophpfile/phpfile.php';
++++$.get(url,function(data){
++++++++$('#counting').html(data%2B'+Word+combinations+have+been+generated+so+far.');
++++});
+}|556721|现在，在您的phpfile.php文件中，您将需要代码来增加计数。如果现在我也能帮上忙的话，我想你知道该怎么做了。我将在这里添加一些示例代码，这样您就有了一个想法。|556722|<?php
++mysql_connect('localhost',+'db-sgg',+'password')+or+die('Cannot+connect+to+database+server');
++mysql_select_db('db1152127-sgg')+or+die('Cannot+select+database');
++$databasecall+=+mysql_query("SELECT+counter+FROM+sggcount+WHERE+counter+>+1");
++/*so+here+you+select+the+already+stored+value+and+then+you+make+an+update+to+increment+it*/
++mysql_query("UPDATE+sggcount+SET+counter=counter%2B1");
++$count+=+mysql_fetch_assoc($databasecall);
++echo+$count['counter']%2B1;
?>|556723|通过执行上面的回显操作，您将返回递增的值，ajax将显示它。|556724|更新1|556725|添加了更全面的php代码|556726|注意:如果添加jquery脚本，请将生成器函数更改为使用jquery。|556727|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

To get this to work is very simple. You need some html for the future div where you want to place the couting:
<pre><code>&lt;div id=&quot;counting&quot;&gt;&lt;/counting&gt;
</code></pre>
Then right at the end of the generator() function you add this:
<pre><code>function generator(){
 /*your code here...*/ 
 var element = document.createElement(&quot;div&quot;);
 element.setAttribute(&quot;id&quot;, &quot;result&quot;);
 element.appendChild(document.createTextNode(name));
 document.getElementById(&quot;placeholder&quot;).appendChild(element);
 /*the ajax code here*/
 var url='urltophpfile/phpfile.php';
 $.get(url,function(data){
 $('#counting').html(data+' Word combinations have been generated so far.');
 });
 }
</code></pre>
Now in your phpfile.php file you will need the code to increment the count. I guess you know how to do this part if now i can help with it too. I'll add some sample code here so you have an idea.
<pre><code>&lt;?php
 mysql_connect('localhost', 'db-sgg', 'password') or die('Cannot connect to database server');
 mysql_select_db('db1152127-sgg') or die('Cannot select database');
 $databasecall = mysql_query(&quot;SELECT counter FROM sggcount WHERE counter &gt; 1&quot;);
 /*so here you select the already stored value and then you make an update to increment it*/
 mysql_query(&quot;UPDATE sggcount SET counter=counter+1&quot;);
 $count = mysql_fetch_assoc($databasecall);
 echo $count['counter']+1;
?&gt;
</code></pre>
By doing the echo above you will return the incremented value and the ajax will display it.
<h1>Update 1</h1>
Added more comprehensive php code
NOTE: if you add the jquery script please change the generator function to use jquery.

Here is what I want to accomplish on <a href="http://geheimprojekt.nomachines.org/" rel="nofollow">http://geheimprojekt.nomachines.org/</a>

<ol>
<li>User clicks on "Nochmal!" Button (New word combination is generated)</li>
<li>Send the click to my MySQL database (withou reloading the page), increase "clicked" row by 1</li>
<li>Update the text in a paragraph "n Word combinations have been generated so far."</li>
</ol>

This is my first attempt to work with AJAX.
I have jQuery knowledge but i can't connect the dots it seems.

The SQL

<pre><code>CREATE TABLE IF NOT EXISTS `sggcount` (
 `counter` bigint(20) NOT NULL DEFAULT '2'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

--
-- Dumping data for table `sggcount`
--

INSERT INTO `sggcount` (`counter`) VALUES
(2);
</code></pre>

Count clicks on one button, save it to MYSQL and then display the current value (AJAX, PHP)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

下面是我想在上完成的任务用户点击"Nochmal!“按钮(生成新单词组合)将单击发送到我的MySQL数据库(在重新加载页面时)，将“单击”行增加1更新段落中的文本“到目前为止已经生成了n个单词组合”。这是我第一次尝试使用AJAX。我有jQuery的知识，但我似乎不能把这些点联系起来。SQLCREATE TABLE IF...

问计数单击一个按钮，保存到MYSQL，然后显示当前值(AJAX，PHP)
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问计数单击一个按钮，保存到MYSQL，然后显示当前值(AJAX，PHP)EN