PHP Code to Connect to a Database Server
$server = 'localhost';
$user = 'myusername';
$pass = 'mypassword';
$database = 'mydatabase';
$link = mysql_connect($server,$user,$pass);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<br/><br/>';
mysql_select_db($database, $link) or die('Could not select database.');
echo 'Database connected succesfully<br/><br/>';
$result = mysql_query('SELECT * FROM ContactTable');
while ($line = mysql_fetch_array($result)) {
echo $line["Name"] . '<br/>';
}
mysql_close($link);
PHP Code to Insert a Record Into a Database
// receive information from $_POST
$name = $_POST["name"];
$email = $_POST["email"];
$message = $_POST["message"];
$server = 'localhost';
$user = 'myusername';
$pass = 'mypassword';
$database = 'mydatabase';
$link = mysql_connect($server,$user,$pass);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<br/><br/>';
mysql_select_db($database, $link) or die('Could not select database.');
echo 'Database connected succesfully<br/><br/>';
$query = 'INSERT INTO ContactTable (Name, Email, Message) VALUES ("' . $name . '", "' . $email . '", "' . $message . '")';
if ($result = mysql_query($query)) {
echo 'Inserted record successfully';
}