mysql truncate table in php
<?php
$host="localhost";
$username="user";
$password="mysql_password";
$database="database_name";
$table="table_name";
$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);
?>