所以我需要简单的事情,我需要在我的网站中创建按钮,单击按钮后,它应该截断数据库表,但我自己无法成功完成。那么你能帮我一下吗?
我在这里尝试创建按钮:
<input type="button" id='delete' class='delete' value='Truncate' onClick="$truncate">
</input>
我知道这是在 HTML 中使用 PHP 变量的错误方法,但我不知道如何正确执行。
这是我的 PHP 变量:
$truncate= "TRUNCATE TABLE myTable";
连接数据库就可以了:
$mysqli = new mysqli("localhost","database","password","asd");
那么也许这里是为截断数据库表创建按钮的更好方法?谢谢。
UPDATED:
这也不起作用,单击按钮后什么也没有发生。
if(isset($_POST['delete'])){
$delete= "TRUNCATE TABLE myTable";
}
?>
<input type="button" id='delete' class='delete' name="delete" value='Truncate' onClick="delete">
</input>
在这里,尝试一下。
PHP(删除表.php)
<?php
// CONNECT TO THE DATABASE
$DB_HOST = "your_host";
$DB_NAME = "your_DB_name";
$DB_USER = "username";
$DB_PASS = "password";
$dbc = mysqli_connect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME)
or die('Error connecting to MySQL server');
if(isset($_POST['delete'])){
$query = "TRUNCATE TABLE `yourTable` "; // replace yourTable with one to delete
$result = mysqli_query($dbc,$query)
or die('Error deleting table.');
}
else {
echo "Sorry";
}
?>
HTML 表单
<form method="post" action="delete_table.php">
<input type="submit" id='delete' class='delete' name="delete" value='Truncate'></input>
</form>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)