Syntax error How can we delete an existing MySQL table by using PHP script?

How can we delete an existing MySQL table by using PHP script?

As we know that PHP provides us the function named mysql_query to delete an existing MySQL table.

Example

To illustrate this we are deleting a table named ‘Tutorials_tbl’ with the help of PHP script in the following example −

<html>
   <head>
      <title>Creating MySQL Tables</title>
   </head>
   <body>
      <?php
         $dbhost = 'localhost:3036';
         $dbuser = 'root';
         $dbpass = 'rootpassword';
         $conn = mysql_connect($dbhost, $dbuser, $dbpass);
         
         if(! $conn ) {
            die('Could not connect: ' . mysql_error());
         }
         echo 'Connected successfully<br />';
         $sql = "DROP TABLE tutorials_tbl";
         mysql_select_db( 'TUTORIALS' );
         $retval = mysql_query( $sql, $conn );
         
         if(! $retval ) {
             die('Could not delete table: ' . mysql_error());
         }
         echo "Table deleted successfully
";
         mysql_close($conn);
      ?>
   </body>
</html>
Updated on: 2020-06-22T13:43:01+05:30

235 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements