Basics
Creating a Document
Head and Body Elements
Formatting Text
Creating Lists
Embedding Images
URLs Explained
Linking to Documents
Creating Tables
Forms Form Basics
Input and Textarea
Select Lists
Frames Framesets
The Frame Element
Nested Framesets
Targetting Frames
Inline Frames
Tips and Tricks Meta Tags
Transition Effects
HTML Generators Create a Document
Create a List
Create a Table
HTML
Basics
Implementing CSS
CSS Syntax
Pseudo Classes/Elements
CSS Classes
CSS Properties Font Properties
Color and Background
Text Properties
Border Properties
Margins and Padding
Size and Position
Tips and Tricks Menu Buttons
Special Effects
CSS
Basics
Running a Script
Variables
Expressions and Operators
Objects.Properties.Methods
The Date Object
Strings
Regular Expressions
Defining RegExp Patterns
Branches and Conditions
Loops
Arrays Array Basics
Array Methods
Sorting Arrays

User-Defined Functions
Cookies
Windows
Frames
Tips and Tricks Image Replacement
Using Includes
Form Validation
Debugging
JavaScript
Basics
Creating a Script
Running a Script
Variables
Expressions and Operators
Strings Strings Basics
Strings and Substrings
Replacing Substrings
Regular Expressions
Branches and Conditions
Loops
Arrays Array Basics
Array Functions
Sorting Arrays
User-Defined Functions
Include and Require
Uploading Files
File Functions
Session Variables
Tips and Tricks Page Templates
Form Reply Scripts
Form Validation
JavaScript to PHP
PHP
Basics
Create and Drop
Show and Describe
Insert, Update and Delete
Querying
Join Queries
Functions
Table Locking
PHP/MySQL Functions Accessing a Database
Querying with PHP
Create and Drop with PHP
Insert and Update with PHP
Frequently Used Functions MySQL
Basics
Layout and Navigation
Page Content Style
Web Page Copy
Graphics and Animation
HTML Forms
Accessibility
Legal Requirements
MySQL
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
©2010 www.webdesignworkmate.co.uk all rights reserved 
Design and Production by smallbizonline website design © 2000-2010
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