1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

<?php
// MySQL Tutorial 4 - Inserting Data Into A Database
 
/* Syntax:
INSERT INTO tableName (field1, field2, field3, ...)
VALUES (value1, value2, value3, ...)
*/
 
include("config.php"); // connect to database
 
mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber, zipCode)
VALUES ('Tom', 'Green', '5559870123', 40344)")
    or die('Could not add new contact');
 
echo "New Contact Added";
 
?>

<?php // MySQL Tutorial 4 - Inserting Data Into A Database /* Syntax: INSERT INTO tableName (field1, field2, field3, ...) VALUES (value1, value2, value3, ...) */ include("config.php"); // connect to database mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber, zipCode) VALUES ('Tom', 'Green', '5559870123', 40344)") or die('Could not add new contact'); echo "New Contact Added"; ?>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

<?php
// MySQL Tutorial 3 - Connecting To A Database
 
// CREATE CONNECTION TO DATABASE
 
$user = "root";
$pass = "";
$database = "phoneBook";
$server = "localhost";
 
// Syntax: mysql_connect("servername","username","password");
$connect = mysql_connect($server, $user, $pass)
                or die ('Connection To Server Failed');
 
// Syntax: mysql_select_db("databaseName", $connect);
mysql_select_db("$database", $connect)
                or die ('Connection To Database Failed');
 
// CLOSE CONNECTION
//mysql_close($connect);
?>

<?php // MySQL Tutorial 3 - Connecting To A Database // CREATE CONNECTION TO DATABASE $user = "root"; $pass = ""; $database = "phoneBook"; $server = "localhost"; // Syntax: mysql_connect("servername","username","password"); $connect = mysql_connect($server, $user, $pass) or die ('Connection To Server Failed'); // Syntax: mysql_select_db("databaseName", $connect); mysql_select_db("$database", $connect) or die ('Connection To Database Failed'); // CLOSE CONNECTION //mysql_close($connect); ?>

1
2
3
4
5
6
7

<form action="addContact.php" method="post">
First Name: <input type="text" name="firstName">
Last Name: <input type="text" name="lastName">
Phone Number: <input type="text" name="phoneNumber">
Zip Code: <input type="text" name="zipCode">
<input type="submit">
</form>

<form action="addContact.php" method="post"> First Name: <input type="text" name="firstName"> Last Name: <input type="text" name="lastName"> Phone Number: <input type="text" name="phoneNumber"> Zip Code: <input type="text" name="zipCode"> <input type="submit"> </form>

1
2
3
4
5
6
7
8
9

<?php
include("config.php"); // connect to database
 
mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber, zipCode)
VALUES ('$_POST[firstName]', '$_POST[lastName]', '$_POST[phoneNumber]', $_POST[zipCode])")
    or die(mysql_error());
 
echo "New Contact Added";
?>

<?php include("config.php"); // connect to database mysql_query("INSERT INTO contacts (firstName, lastName, phoneNumber, zipCode) VALUES ('$_POST[firstName]', '$_POST[lastName]', '$_POST[phoneNumber]', $_POST[zipCode])") or die(mysql_error()); echo "New Contact Added"; ?>