I am new to PHP and Mysql programming and I am having problems populating my tables in my mysql database. I have tried to correct this on my own by reading various books, but I cannot figure this out. Any help would be appreciated
Here is the code for the second page which is supposed to populate the table. The error message states
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /users/web/ggalvin1/web/action2.php on line 20 (LINE 20 is HIGHLIGHTED)
The error point to this line
$db = mysql_select_db("ggalvin1", $connection) or die (Couldn't select the database,");
The code for the execution page is below and the page which the user enters text is pasted later in the document.
<html>
<head>
<title>Adding Record to MYSQL</title>
</head>
<body>
<?php
$sql = "INSERT INTO Phonebook (First_Name, Last_Name, Address1, City, State, Zip_Code, Home_Phone, Work_Phone, Email_Address, Webaddress) values ('$First_Name', '$Last_Name', '$Address1', '$City', '$State', '$Zip_Code', '$Home_Phone', '$Work_Phone', '$Email_Address', '$Webaddress')";
$connection = mysql_connect("localhost","test","test") or die ("Couldn't Connect to the Server,");
$db = mysql_select_db("ggalvin1", $connection) or die (Couldn't select the database,");
if (!$sql_result) {
echo "<P>Couldn't add record!";
) else (
echo "
<P>Record Added!</p>
<table cellspacing=5 cellpadding=5>
<tr>
<td valign=top><strong>Item ID:</strong></td>
td valign=top>$First_Name</td>
</tr>
<tr>
<td valign=top><strong>Item ID:</strong></td>
td valign=top>$Last_Name</td>
</tr>
";
)
?>
</body>
</html>
HERE IS THE FIRST WEBPAGE
<?
if (!isset($PHP_AUTH_USER)) {
header('WWW-Authenticate: Basic realm="INVALID LOGIN"');
header('HTTP/1.0 401 Unauthorized');
echo 'Authorization Required.';
exit;
} else if (isset($PHP_AUTH_USER)) {
if (($PHP_AUTH_USER != "Greg") || ($PHP_AUTH_PW != "Rowing")) {
header('WWW-Authenticate: Basic realm="Welcome to 32 Ford"');
header('HTTP/1.0 401 Unauthorized');
echo 'Authorization Required.';
exit;
} else {
echo "
<HTML>
<HEAD>
<TITLE>Phonebook: Add a name</TITLE>
</HEAD>
<BODY>
<h1>Phonebook</h1>
<FORM method=\"POST\"action=\"action2.php\">
<table cellspacing=5 cellpadding=5>
<tr>
<td valign=top><strong>First Name:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$First_Name\" size=35 maxlength=25>
</td>
</tr>
<tr>
<td valign=top><strong>Last Name:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$Last_Name\" size=35 maxlength=150>
</td>
</tr>
<tr>
<td valign=top><strong>Address:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$Address1\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td valign=top><strong>City:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$City\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td valign=top><strong>State:</strong></td>
<td valign=top>
<SELECT name=\"category\">
<OPTION value=\"\">-- Select One --</OPTION>
<OPTION value=\"$State\">Alabama</OPTION>
<OPTION value=\"$State\">Alaska</OPTION>
<OPTION value=\"$State\">Arizona</OPTION>
<OPTION value=\"$State\">California</OPTION>
<OPTION value=\"$State\">Colorado</OPTION>
<OPTION value=\"$State\">New York</OPTION>
<OPTION value=\"$State\">Connecticut</OPTION>
<OPTION value=\"$State\">Delaware</OPTION>
<OPTION value=\"$State\">Florida</OPTION>
<OPTION value=\"$State\">Georgia</OPTION>
<OPTION value=\"$State\">Hawaii</OPTION>
<OPTION value=\"$State\">Idaho</OPTION>
<OPTION value=\"$State\">Illinois</OPTION>
<OPTION value=\"$State\">Indiana</OPTION>
<OPTION value=\"$State\">Iowa</OPTION>
<OPTION value=\"$State\">Kansas</OPTION>
<OPTION value=\"$State\">Kentucky</OPTION>
<OPTION value=\"$State\">Louisiana</OPTION>
<OPTION value=\"$State\">Maine</OPTION>
<OPTION value=\"$State\">Maryland</OPTION>
<OPTION value=\"$State\">Massachusetts</OPTION>
<OPTION value=\"$State\">Michigan</OPTION>
<OPTION value=\"$State\">Minnesota</OPTION>
<OPTION value=\"$State\">Mississippi</OPTION>
<OPTION value=\"$State\">Missouri</OPTION>
<OPTION value=\"$State\">Montana</OPTION>
<OPTION value=\"$State\">Nebraska</OPTION>
<OPTION value=\"$State\">Nevada</OPTION>
<OPTION value=\"$State\">New Hampshire</OPTION>
<OPTION value=\"$State\">New Jersey</OPTION>
<OPTION value=\"$State\">New Mexico</OPTION>
<OPTION value=\"$State\">New York/OPTION>
<OPTION value=\"$State\">North Carolina</OPTION>
<OPTION value=\"$State\">North Dakota</OPTION>
<OPTION value=\"$State\">Ohio</OPTION>
<OPTION value=\"$State\">Oklahoma</OPTION>
<OPTION value=\"$State\">Oregon</OPTION>
<OPTION value=\"$State\">Pennsylvania</OPTION>
<OPTION value=\"$State\">Rhode Island</OPTION>
<OPTION value=\"$State\">South Carolina</OPTION>
<OPTION value=\"$State\">South Dakota</OPTION>
<OPTION value=\"$State\">Tennessee</OPTION>
<OPTION value=\"$State\">Texas</OPTION>
<OPTION value=\"$State\">Utah</OPTION>
<OPTION value=\"$State\">Vermont</OPTION>
<OPTION value=\"$State\">Virginia</OPTION>
<OPTION value=\"$State\">Washington</OPTION>
<OPTION value=\"$State\">West Virginia</OPTION>
<OPTION value=\"$State\">Wisconsin</OPTION>
<OPTION value=\"$State\">Wyoming</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td valign=top><strong>Zip Code:</strong></td>
<td valign=top>
<INPUT type=\"text\" Zip Code=\"$Zip_Code\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td valign=top><strong>Home Phone:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$Home_Phone\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td valign=top><strong>Work Phone:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$Work_Phone\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td valign=top><strong>Email Address:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$Email_Address\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td valign=top><strong>WebAddress:</strong></td>
<td valign=top>
<INPUT type=\"text\" name=\"$WebAddress\" size=35 maxlength=75>
</td>
</tr>
<tr>
<td align=center colspan=2>
<INPUT type=\"submit\" value=\"Add New Contact\">
</td>
</tr>
</table>
</FORM>
</BODY>
</HTML>
";
}
}
?>
