How To Use MySQL
// Connect
$con = mysql_connect("localhost","root");
if(!$con){
echo 'Error When Connect SQL!<br />';
die('Could not connect: ' . mysql_error());
}
// Create Database
if(mysql_query("CREATE DATABASE Person_Lists",$con)){
echo "Database created";
}else{
echo "Error creating database: " . mysql_error();
}
// Select Database
mysql_select_db("Person_Lists", $con);
// Create table in Person_Lists database
$sql = "CREATE TABLE Persons
(
PersonID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";
//mysql_query($sql,$con);
mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'AA', '20')");
mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'BB', '40')");
mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'CC', '30')");
$result = mysql_query("SELECT * FROM Persons");
while($row = mysql_fetch_array($result)){
echo "Index: ".$row['PersonID']
." FirstName: ".$row['FirstName']
." LastName: ".$row['LastName']
." Age: ".$row['Age'];
echo "<br />";
}
// Insert
// => "INSERT INTO table_name VALUES (value1, value2,....)"
// => "INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)"
// => "INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Fisher', 'EE', '29')"
// Where
// => "SELECT column FROM table WHERE column operator value"
// => "SELECT * FROM Persons WHERE FirstName='Peter'"
// Order By
// => "SELECT column_name(s) FROM table_name ORDER BY column_name"
// => "SELECT * FROM Persons ORDER BY age"
// => "SELECT column_name(s) FROM table_name ORDER BY column_name DESC"
// => "SELECT column_name(s) FROM table_name ORDER BY column_name1, column_name2"
// Update
// => "UPDATE table_name SET column_name = new_value WHERE column_name = some_value"
// => "UPDATE Persons SET Age = '36' WHERE FirstName = 'Peter' AND LastName = 'Griffin'"
// Delete
// => "DELETE FROM table_name WHERE column_name = some_value"
// => "DELETE FROM Persons WHERE LastName='BB'"
// Close
mysql_close($con);
echo 'Database Closed!';
Easy To Use! -.-
Donot Be Afraid, Go Ahead, ,,