|
Server IP : 172.16.15.8 / Your IP : 18.227.190.231 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/grpatillo/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-----
p.169
Drop a table with PHP
------>
<TITLE>
Create Table
</TITLE>
<BODY>
<?php
$server = 'localhost';
$user = 'grpatillo';
$pass = 'cs480';
$mydb = 'grpatillo';
$table_name = 'Products';
$connect = mysql_connect($server, $user, $pass);
if (!$connect)
{
die ("Cannot connect to $server using $user");
}
else
{
$SQLcmd = "DROP TABLE $table_name";
mysql_select_db($mydb);
if (mysql_query($SQLcmd, $connect))
{
echo "<p style='font-size:12px;color:blue'>Drop Table</p>";
echo "<p style='font-style:italic'>$table_name</p> in database
<p style='font-style:italic'>$mydb</p><BR>";
echo "<BR>SQLcmd=$SQLcmd";
}
else
{
die ("Table Drop Failed SQLcmd=$SQLcmd");
}
mysql_close($connect);
}
?>
</BODY>
</HTML>