Drop mySQL Table using PHP

Drop mySQL Table using PHP

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

  1. Mamp or xampp with phpMyAdmin install into your Computer , check out here
  2.  A Sample Database created Check out Here
  3.  New User Created . Check out Here
  4. A New table created , check out Here

 

Step 1

Start your My SQL and Apache Server

mysql and Apache Initialised Success
mysql and Apache Initialised Success

 

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";
}


?>

&nbsp;

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”

table deleted
table deleted

 

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + nine =