Login
|
Webmail
|
Support
|
480-388-3777
Let's Chat
Infrastructure As A Service (IaaS)
Managed Hosting Overview
High Availability & Load Balancing
Data Storage
Disaster Recovery & Backup
All-In-One/DDOS Attack Protection
Security
Management Services
Email Solutions
Hosted / Encrypted Email
Enterprise / Encrypted Email
Partners Overview
Preferred Partners
Managed Hosting Overview
Managed Servers
Self-Managed Servers
Shared Website Hosting
Hosted / Encrypted Email
Domain Names
Company Overview
Leadership Team
Brinkster News
Careers
Data Center
Network
Legal
Corporate Social Responsibility
Contact Brinkster
MySQL Create Table Insert
Added By:
deanschaefer
Rated:
(3 of 5) by 3.
Rate Snippet:
1
2
3
4
5
Description:
Create a MySQL Table and Insert the first record
Language:
PHP
Save to web space
E-mail Link
Code Snippet:
<?php // I have always found it difficult to: // SELECT anything // FROM a table // THAT does not yet exist; // $username = 'Your Brinkster User-Name'; $password = 'Your Brinkster Password'; $hostname = 'Your MySQL Server, identified in website settings'; $SQL = 'CREATE TABLE Me ( Id smallint(5) unsigned NOT NULL auto_increment, FirstName varchar(25) default NULL, LastName varchar(25) default NULL, Notes text default NULL, PRIMARY KEY (Id) ); '; $link = mysql_connect($hostname, $username, $password); $theDB = mysql_select_db($username); $result = mysql_query($SQL); $fName = "something"; $lName = "something else"; $myNote = "whatever"; $SQL = "insert into Me set "; // Single quoates insed of double quoates always=> FirstName = ' + $fName + ', $SQL = $SQL."FirstName = '".$fName."', "; $SQL = $SQL."LastName = '".$lName."', "; $SQL = $SQL."Notes = '".$myNote."';"; $result = mysql_query($SQL); mysql_close($link); ?>
Toll free:
1 (800) 345-7084