开发者

SQLITE corruption?- DELETE FROM toolList WHERE toolId=".$id

开发者 https://www.devze.com 2023-01-19 08:41 出处:网络
something is seriously wrong with my SQLITE I included echo $dbquery to see exactly what query is being run, and the statment seems correct - but when trying to view the db after, it comes up blank!

something is seriously wrong with my SQLITE

I included echo $dbquery to see exactly what query is being run, and the statment seems correct - but when trying to view the db after, it comes up blank! I've checked the actuall file, and theres still data in the db file, so maybe it corrupting it?

the query prints as: DELETE FROM toolList W开发者_开发技巧HERE toolId=1289

function Up($id){

global $dbhandle, $dbresult;

$dbquery = "DELETE FROM toolList WHERE toolId=".$id;

$dbresult = sqlite_query($dbhandle, $dbquery);

echo $dbquery;

}

< a href="'.Up($data['toolId']).'">DELETE!< /a>

Thanks


It is highly unlikely that you corrupted a sqlite db during normal operation. Your question is a bit unclear:

  • What happens if you run a select statement from the sqlite3 command line utility against your DB.
  • Keep in mind that sqlite does not shrink a DB file untill you issue a vaccum command.
  • Also it looks like you are running your function to display the href for the link, but the function does the delete! So if you ran this over a list of items once, then they would all be gone.
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号