MySQL tutorial on create and drop using PHP Free Web Design Tutorials
Home   HTML CSS JavaScript PHP MySQL Usability Glossary
MySQLBasicsCreate and DropShow and DescribeInsert, Update and DeleteQueryingJoin QueriesFunctionsTable LockingPHP/MySQL FunctionsAccessing a DatabaseQuerying with PHPMySQL Create and Drop using PHPCreate and Drop with PHPInsert & Update with PHPFrequently Used Functions

Home > MySQL > Create and Drop with PHPprinter version

MySQL Create and Drop with PHP

As mentioned in the Querying with PHP Tutorial, any query that can be used with the MySQL command prompt can be passed as a string variable to the PHP library function mysql_query().

Therefore creating or dropping a table uses the same syntax as that covered in the Create and Drop Tutorial.

As long as the PHP rules on single and double quoted strings are observed, the code is straightforward.

Example of Creating and Dropping a Table
<?php
$query = "CREATE TABLE persons (
id int(6) DEFAULT '0' NOT NULL auto_increment,
firstname varchar(30) NOT NULL,
lastname varchar(30) NOT NULL,
address varchar(100) NOT NULL,
county varchar(40),
country varchar(30) DEFAULT 'UK',
age int(3),
PRIMARY KEY (id) );";

$result = mysql_query($query, $connection) or exit(mysql_error());

$query = "DROP TABLE persons";

$result = mysql_query($query, $connection) or exit(mysql_error());
?>


Note: When you DROP a table all data within the table is lost and is not recoverable.


Previous - MySQL Querying with PHP Previous - Querying with PHP     Next - Insert and Update with PHP Next - MySQL Insert and Update with PHP


Privacy | Terms | Contact | Links | Sitemap | RSS Feeds RSS and JavaScript Feeds
©2009 www.webdesignworkmate.co.uk all rights reserved 
Design and Production by smallbizonline website design © 2000-2009
Valid HTML 4.01! Level Double-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0Valid CSS!
Recommended Reading
PHP6 and MySQL5

PHP and MySQL Web Development

Build Your Own Database Driven Website using PHP and 

MySQL

How to do Everything with PHP and MySQL