Jump to content

Delete all data from table using PDO


alenphp

Recommended Posts

Hi guys. I have following code to delete particular row from a table based on the title. But how can I delete all data from the table?

 

<?php
require 'connpdo.php';
$naslov = $_POST['naslov'];
#DELETE DATA
//delete some data
$sqlInsert = 'DELETE FROM bloging WHERE title=:title';
$preparedStatement = $conn->prepare($sqlInsert);
$preparedStatement->execute(array(':title' => $naslov));


//REDIRECT TO HOME PAGE
header('Location: http://localhost/ITAPHP/index.php');
?>

So I would need something which would say DELETE * FROM bloging...Basically I have this table bloging with 3 fields id, title and text, and above code will identify specific post based on the title and delete that particular post. But I need button to delete all posts, to empty table.

 

Thank you in advance!

 

Link to comment
https://forums.phpfreaks.com/topic/285497-delete-all-data-from-table-using-pdo/
Share on other sites

 

quickest way is to run this query

TRUNCATE TABLE bloging

Would you be kind to put it in above code? I don't know how. I found following code using mysql not PDO and it works. But I need it in PDO. Or just tell me where exactly does it fit this line you wrote.  Thank you

 

$connection = mysql_connect("$host", "$username", "$password") or die ("Unable to connect to server");
mysql_select_db("$database") or die ("Unable to select database");
$sql = "TRUNCATE TABLE `$table`";
mysql_query($sql);
echo "Table Deleted";
mysql_close($connection);

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.