PHP

SQL Commands

Using PHP to work with MySQL comes down to sending SQL commands to MySQL using the mysql_query() function.

Command	Description
CREATE	Creates a database or table
DELETE	Deletes records from a table
DROP	Deletes a database or table
INSERT	Adds records to a table
SELECT	Retrieves records from a table
UPDATE	Updates records in a table

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="EN" lang="EN">
<head>
<title>Adding Parameters to a Cookie</title>
<meta Name="Author" Content="Hann So">
</head>
<body>
<p>
<?php
$hello = "Hello World!";
$year = 2008;
echo $hello;
echo $year;
?>
</p>
</body>
</html>

View the effect