MySQL的。 HTML按钮被点击后 - TRUNCATE数据库表 [英] MySql. After HTML button is clicked - TRUNCATE database table

问题描述

所以，我需要简单的事情，我需要在我的网站创建按钮，点击按钮后，它应该截断数据库表，但我无法自己做成功。所以，能不能帮我，好吗？

在这里，我想creeate按钮：

 ＆LT;输入类型=按钮ID =删除类='删除'值='截断的onClick =$截断＆GT;
＆LT; /输入＆GT;
 

我知道这是用PHP变量HTML错误的方式，但我不知道该怎么做是正确的。

下面是我的PHP变量：

$截断=TRUNCATE表mytable;

通过连接到数据库是所有权利：

$ = mysqli的新的mysqli（本地主机，数据库，密码，ASD）;

所以也许这里是更好的方法来创建数据库截断的桌子按钮？谢谢你。

更新：

这不会工作过，按钮被点击后没有任何反应。

 如果（使用isset（$ _ POST ['删除']））{
    $删除=TRUNCATE表mytable
    }
？＆GT;
＆LT;输入类型=按钮ID =删除类=删除NAME =删除价值='截断的onClick =删除＆GT;
＆LT; /输入＆GT;
 

解决方案

下面，试试这个。

PHP（delete_table.php）

 ＆LT; PHP
//连接到数据库
$ DB_HOST =your_host;
$ DB_NAME =your_DB_name;
$ DB_USER =用户名;
$ DB_PASS =密码;$ DBC = mysqli_connect（$ DB_HOST，DB_USER $，$ DB_PASS，$ DB_NAME）
或死亡（错误连接到MySQL服务器'）;如果（使用isset（$ _ POST ['删除']））{
$查询=TRUNCATE TABLE`yourTable` //一个替代yourTable删除
$结果= mysqli_query（$ DBC，$查询）
或死亡（错误删除表。'）;
}
其他{
回声对不起;
}
？＆GT;
 

HTML表单

 ＆LT;形式方法=邮报行动=delete_table.php＆GT;
＆LT;输入类型=提交ID =删除类=删除NAME =删除价值='截断'＆GT;＆LT; /输入＆GT;
＆LT; /表及GT;
 

So I need simple thing, I need to create button in my website, after button is clicked, It should truncate database table, but I can't do It successfully by myself. So could you help me, please?

Here I'm trying to creeate button:

<input type="button" id='delete' class='delete' value='Truncate' onClick="$truncate">
</input>

I know this is wrong way to use PHP variable in HTML, but I don't know how to do It correctly.

Here is my PHP variable:

$truncate= "TRUNCATE TABLE myTable";

With connection to database is all right:

$mysqli = new mysqli("localhost","database","password","asd");

So maybe here is better method to create button for truncate database's table? Thank you.

UPDATED:

This won't work too, nothing happens after button is clicked.

    if(isset($_POST['delete'])){
    $delete= "TRUNCATE TABLE myTable";
    }
?>
<input type="button" id='delete' class='delete' name="delete" value='Truncate' onClick="delete">
</input>

解决方案

Here, give this a try.

PHP (delete_table.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

<form method="post" action="delete_table.php">
<input type="submit" id='delete' class='delete' name="delete" value='Truncate'></input>
</form>

这篇关于MySQL的。 HTML按钮被点击后 - TRUNCATE数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！