Drop mySQL Table using PHP
Drop mySQL Table using PHP, in this article i will step through how to drop / delete a mySQL table using PHP.
The Example will delete “mytable1 from “janedb”
Prior to that you need to complete the items listed Below
- Mamp or xampp with phpMyAdmin install into your Computer , check out here
- A Sample Database created Check out Here
- New User Created . Check out Here
- A New table created , check out Here
Step 1
Start your My SQL and Apache Server
Step 2
Create a new Script
(1) First to connect to the Database
(2) Delete the table call “mytable” from “janedb “ database
<?php
/* Declare User connecting Credential*/
$hostName ="localhost";
$userName ="jane";
$userPassword ="jane";
$dataBaseName = "janedb";
/* return connection status through $dbConnectionStatus Boolean Variable*/
/* using mysqli Object*/
$dbConnectionStatus = new mysqli($hostName, $userName, $userPassword,$dataBaseName);
/* Check whether the User Succesfully connect to localhost and mydata Database*/
/* -> Access the instance "$dbConnectionStatus" variable property "connect_error " boolean */
if ($dbConnectionStatus->connect_error){
die("Connection failed: " . $dbConnectionStatus->connect_error);
}else{
echo " Database Connected " ;
echo "<br>";
}
$sql = "DROP TABLE mytable1 ";
/* Execute query to delete " mytable1 " table*/
$deleteStatus =$dbConnectionStatus->query($sql);
/*Check Whether Data Base Successuly Deleted*/
if($deleteStatus){
echo"Table deleted \n";
}else {
echo"Table delete Unsuccessful \n";
}
?>
Step 3
Save this File as “.php” extension in
C:\xampp\htdocs
If you want to change the root Location of the mySQL file check out this article at step 3
Step 4
Test it
(1)Click Admin
(2) Click the PHP File you have just created in this example i name it ” dropTable.php”
