在过去的几天里,我一直在努力理解使用php脚本作为保存按钮的简单概念。当从网页上按下按钮时,将从table A
插入数据到table B
,然后删除table A
并重定向到我的主index.html
。
<?php
try {
$db = new PDO('sqlite:/srv/db/data.db');
}
$db->exec("INSERT * INTO Archive FROM resultstbl");
$db->exec("DELETE * FROM resultstbl")
unset($db);
?>
到目前为止,我可以使用一些帮助这个PHP查询,以及任何指导。
我会这样做:
<?
if(isset($_POST['but1'])) // this checks if the button is clicked
{
$db = new PDO('sqlite:/srv/db/data.db'); // I assume this is working fine
$db->exec("INSERT INTO Archive SELECT * FROM resultstbl"); // tables must be equivalent in terms of fields
$db->exec("DELETE FROM resultstbl") // You want to delete the records on this table or the table itself? This deletes the records
header("Location: index.php?page=home"); // This will only work if you didn't output anything to the screen yet. If you displayed something it will fail
die();
}
?>
<form action="sql.php" method="POST"> <!-- Assuming this page is sql.php -->
<input type="submit" name="but1" value="GO!"/>
</form>
您可以在这里查看SQLite中插入和删除语句的语法:
http://www.sqlite.org/lang_insert.html http://www.sqlite.org/lang_delete.html