want to do is this :
page (1) has a form that you fill in when you
want to add a record. page (2) displays all the records in a table,
I want to be able to click on a particular record i.e their personID (as a
hyperlink) which then loads that record in the original group of text
boxes,( i.e form) from where it was originally entered.
Any help please??
here is the code for when I display records:
Code: Select all
// config-------------------------------------
$host = "****"; //your database host
$user = "*****"; // your database user name
$pass = "*****"; // your database password
$db = "contact_management_system"; // your database name
$filename = "people.html"; // name of this file
$option = array (5, 10, 20, 50, 100, 200);
$default = 10; // default number of records per page
$action = $_SERVERї'PHP_SELF']; // if this doesn't work, enter the filename
$query = "SELECT *, DATE_FORMAT(`dateoflastcontact`, '%d/%m/%y')
AS `dateoflastcontact`, DATE_FORMAT(`datecontactagain`, '%d/%m/%y')
AS `datecontactagain` FROM `people` ORDER BY `firstname`";
// database query. Enter your query here
// end config---------------------------------
$opt_cnt = count ($option);
$go = $_GETї'go'];
// paranoid
if ($go == "") {
$go = $default;
}
elseif (!in_array ($go, $option)) {
$go = $default;
}
elseif (!is_numeric ($go)) {
$go = $default;
}
$nol = $go;
$limit = "0, $nol";
$count = 1;
echo "<form name="form1" id="form1" method="get" action="$action">\r\n";
echo "<select name="go" id="go">\r\n";
for ($i = 0; $i <= $opt_cnt; $i ++) {
if ($optionї$i] == $go) {
echo "<option value="".$optionї$i]."" selected="selected">".$optionї$i]."</option>\r\n";
} else {
echo "<option value="".$optionї$i]."">".$optionї$i]."</option>\r\n";
}
}
echo "</select>\r\n";
echo "<input type="submit" name="Submit" id="Submit" value="Go" />\r\n";
echo "</form>\r\n";
$connection = mysql_connect ($host, $user, $pass) or die ("Unable to connect");
mysql_select_db ($db) or die ("Unable to select database $db");
// control query------------------------------
/* this query checks how many records you have in your table.
I created this query so we could be able to check if user is
trying to append number larger than the number of records
to the query string.*/
$off_sql = mysql_query ("$query") or die ("Error in query: $off_sql".mysql_error());
$off_pag = ceil (mysql_num_rows($off_sql) / $nol);
//--------------------------------------------
$off = $_GETї'offset'];
//paranoid
if (get_magic_quotes_gpc() == 0) {
$off = addslashes ($off);
}
if (!is_numeric ($off)) {
$off = 1;
}
// this checks if user is trying to put something stupid in query string
if ($off > $off_pag) {
$off = 1;
}
if ($off == "1") {
$limit = "0, $nol";
}
elseif ($off <> "") {
for ($i = 0; $i <= ($off - 1) * $nol; $i ++) {
$limit = "$i, $nol";
$count = $i + 1;
}
}
// Query to extract records from database.
$sql = mysql_query ("$query LIMIT $limit") or die ("Error in query: $sql".mysql_error());
// Define your colors for the alternating rows
$color1 = "#ADD8E6";$color2 = "#E0FFFF";
$color = $color2;echo
"<table width="50%" border="0" cellpadding="2" cellspacing="2">
<tr>
<td><b><small>RecNo</small></b></td>
<td><b><small>ID</small></b></td>
<td><b><small>Title</small></b></td>
<td><b><small>First Name</small></b></td>
<td><b><small>Surname</small></b></td>
<td><b><small>Organisation</small></b></td>
<td><b><center><small>Role</small></center></b></td>
<td><b><small>Address(1)</small></b></td>
<td><b><small>Address(2)</small></b></td>
<td><b><small>City</small></b></td>
<td><b><small>Post Code</small></b></td>
<td><b><small>Telephone</small></b></td>
<td><b><small>Mobile</small></b></td>
<td><b><small>Fax</small></b></td>
<td><b><small>Last Contact</small></b></td>
<td><b><small>Contact Again</small></b></td>
<td><b><small>Notes</small></b></td>";
while ($row = mysql_fetch_object($sql))
{($color==$color2)? $color = $color1 : $color = $color2;
echo "<tr bgcolor="$color"><td>".$count . '</td><td> ' . $row->person_id .'</td><td>'.
$row->salutation .'</td><td>'.
'<a href=mailto:'.$row->email.'>'.$row->firstname .'</a></td><td>'.
'<a href=mailto:'.$row->email.'>'.$row->surname .'</a></td><td>'.
$row->organisation.'</td><td>'.
$row->role.'</td><td>'.
$row->address1 .'</td><td>'.
$row->address2 .'</td><td>'.
$row->city .'</td><td>'.
$row->postcode .'</td><td>'.
$row->telephone .'</td><td>'.
$row->mobile .'</td><td>'.
$row->fax .'</td><td>'.
$row->dateoflastcontact.'</td><td>'.
$row->datecontactagain .'</td><td>'.
$row->notes .'</td></tr>';
$count += 1;
}
echo "</table>";
echo "<br /><br />\r\n";
if ($off <> 1) {
$prev = $off - 1;
echo "ї < <a href="$filename?offset=$prev&go=$go">prev</a> ] \r\n";
}
for ($i = 1; $i <= $off_pag; $i ++) {
if ($i == $off) {
echo "ї<b> $i </b>] \r\n";
} else {
echo "ї <a href="$filename?offset=$i&go=$go">$i</a> ] \r\n";
}
}
if ($off < $off_pag) {
$next = $off + 1;
echo "ї <a href="$filename?offset=$next&go=$go">next</a> > ] \r\n";
}
echo "<br /><br />\r\n";
echo "Page $off of $off_pag<br />\r\n";
?>Code: Select all
?>
<form method="post" action="processpeople.html">
<table width="100%" border="0">
<tr>
<td width="17%"><font face="Times New Roman, Times, serif"><strong>Salutation</strong></font></td>
<td width="27%"><font face="Times New Roman, Times, serif">
<select name="salutation" style="color: #000000;
background-color: #ADD8E6">
<option>Mr</option>
<option>Mrs</option>
<option>Ms</option>
<option>Miss</option>
<option>Dr</option>
</select>
</font></td>
<td width="27%"><font face="Times New Roman, Times, serif"><strong>Telephone</strong></font></td>
<td width="29%"><input name="telephone" type="text"style="color: #000000;
background-color: #ADD8E6" size="11" maxlength="20">
</td>
</tr>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>First Name</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="firstname" type="text" size="20"style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"><strong>Mobile</strong></font></td>
<td><input name="mobile" type="text"style="color: #000000;
background-color: #ADD8E6" size="20" maxlength="20"></td>
</tr>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>Surname</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="surname" type="text" size="15"style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"><strong>Fax</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="fax" type="text"style="color: #000000;
background-color: #ADD8E6" size="20" maxlength="20">
</font></td>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>Organisation</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="organisation" type="text" size="20"style="color: #000000;
background-color: #ADD8E6">
<td><font face="Times New Roman, Times, serif"><strong>E-mail</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="email" type="text" size="15"style="color: #000000;
background-color: #ADD8E6">
</font></td>
</tr>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>Role</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="role" type="text" size="25"style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"><strong>Date of Last Contact</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="dateoflastcontact" type="text" value="yyyy-mm-dd" size="10"style="color: #000000;
background-color: #ADD8E6">
</font></td>
</tr>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>Address(1)</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="address1" type="text" size="20" style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"><strong>Date Contact Again</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="datecontactagain" type="text" value="yyyy-mm-dd "size="10"style="color: #000000;
background-color: #ADD8E6">
</font></td>
</tr>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>Address(2)</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="address2" type="text" size="20"style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"><strong>Notes</strong></font></td>
<td><textarea name="notes"style="color: #000000;
background-color: #ADD8E6"></textarea></td>
</tr>
<tr>
<td><font face="Times New Roman, Times, serif"><strong>City</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="city" type="text" size="20"style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"> </font></td>
<td> </td>
</tr>
<tr>
<td height="43"><font face="Times New Roman, Times, serif"><strong>Post
Code</strong></font></td>
<td><font face="Times New Roman, Times, serif">
<input name="postcode" type="text" size="7"style="color: #000000;
background-color: #ADD8E6">
</font></td>
<td><font face="Times New Roman, Times, serif"> </font></td>
<td> </td>
</tr>
</table>
<input type="submit" name="submit" value = "Enter Information">
</form>