Hello
I am building a contact management system. When a phone number is searched by the user there are 2 available responses: 1. find and deliver the full recordset from the db, 2. deliver an empty form with the searched phone number in place. This is working vey well with the code below. What I would like to do now is to be able to submit the results from option 2. to the db.
Any help, very gratefully received.
Many thanks
<?php
$host="localhost"; // Host name
$username="yes"; // Mysql username
$password="yes"; // Mysql password
$db_name="yes"; // Database name
error_reporting(E_ALL);
$link = mysql_connect($host,$username,$password);
if ( ! $link ) {
die( "Couldn't connect to MySQL: ".mysql_error() );
}
mysql_select_db( $db_name, $link )
or die ( "Couldn't connect to database: ".mysql_error() );
if (!isset($_POST['submit']))
{
//Collect Form Data
$string = $_POST['search'];
//Issue SQL SELECT Statement
$query = "SELECT * FROM contacts WHERE telephone1 = '$string'";
$result = mysql_query($query) or die(mysql_error());
$mysql_num = mysql_num_rows($result );
if ($mysql_num == 0)
{
print "<table>";
print "<tr>";
print "<td>First Name:</td>";
print "<td><input name='firstname' type='text'></td></tr>";
print "<tr><td>Last Name:</td>";
print "<td><input name='lastname' type='text'></td></tr>";
print "<tr><td>Address 1:</td>";
print "<td><input name='address2' type='text'></td></tr>";
print "<tr><td>Address 2:</td>";
print "<td><input name='address2' type='text'></td></tr>";
print "<tr><td>Telephone 1:</td>";
print "<td><input name='telephone1' type='text' value='"; echo $string; print "'></td></tr>";
print "<tr><td>Telephone 2:</td>";
print "<td><input name='telephone2' type='text'></td></tr>";
print "<tr><td>Email:</td>";
print "<td><input name='email' type='text'></td></tr>";
print "</table>";
}
else
{
// enter your code here if your query finds a customer with the number your searching for
while($row = mysql_fetch_array($result))
{
print "<table>";
print "<tr>";
print "<td><b>First Name:</b></td><td>";
echo $row['firstname'];
print "</td></tr>";
print "<tr><td><b>Last Name:</b></td><td>";
echo $row['lastname'];
print "</td></tr>";
print "<tr><td><b>Address 1:</b></td><td>";
echo $row['address1'];
print "</td></tr>";
print "<tr><td><b>Address 2:</b></td><td>";
echo $row['address2'];
print "</td></tr>";
print "<tr><td><b>Telephone 1:</b></td><td>";
echo $row['telephone1'];
print "</td></tr>";
print "<tr><td><b>Telephone 2:</b></td><td>";
echo $row['telephone2'];
print "</td></tr>";
print "<tr><td><b>Email:</b></td><td>";
echo $row['email'];
print "</td></td>";
print "</table>";
}
}
}
?>
