如何将javascript数据添加到mysql? [英] How to add javascript data to mysql?

问题描述

我有问题如何将这个 javascript 数据添加到 mysql 数据库?

I have problem how to add this javascript data to mysql database?

<script type="text/javascript">    
var count = 0;

function countClicks() {    
 count = count +1 ;    
    document.getElementById("likes").innerHTML = count;     
}    
</script>


<input type="button" value="Like "onclick="javascript:countClicks();" alt="alt text"/>    
<div id="likes">0</div>

推荐答案

你需要使用 mysql-real-escape-string 同时将您的 js 代码插入 mysql db.将您的代码字符串分配给一个变量并在插入 db 时使用 mysql-real-escape-string.示例用法；

You need to use mysql-real-escape-string while inserting your js code to mysql db. Assign your code string to a variable and use mysql-real-escape-string while inserting db. Example usage;

HTML:

<form action="save_code.php" method="POST">
    <table>
    <tr>
        <td>Code</td>
        <td><textarea name="code"></textarea></td>
    </tr>
    <tr>
        <td>&nbsp;</td>
        <td><input type="submit" name="Save" value="Save"/></td>
    </tr>
    </table>
</form>

PHP: save_code.php

PHP: save_code.php

// Comment out this for real test
//$jsCode = $_POST['code'];

//Assign js code string to variable
$jsCode = '<script type="text/javascript">    
var count = 0;

function countClicks() {    
 count = count +1 ;    
    document.getElementById("likes").innerHTML = count;     
}    
</script>


<input type="button" value="Like "onclick="javascript:countClicks();" alt="alt text"/>    
<div id="likes">0</div>';

$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
    or die(mysql_error());

$query = "INSERT INTO your_table(id, code) VALUES('', mysql_real_escape_string($jsCode))";
mysql_query($query);

这篇关于如何将javascript数据添加到mysql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！