posting data to a form

jsims

I have a form that works fine:

Here is the form:

<HTML>
<HEAD>
<TITLE>Insert Form</TITLE>
</HEAD>
<BODY>
<?php
// Set the page title and include the HTML header.
$page_title = 'Wireless Neighborhoods';
include_once ('include/header.html');
?>

<FORM ACTION="insert_basicinfo.php" METHOD=POST>
<title>Basic Information</title>
<fieldset>
<legend>Enter your information in the form below:</legend>
<table width="990" height="206" border="1">
<tr>
<th width="467" scope="col" bgcolor="#CCFFFF"><b>Student ID:</b>
<input type="text" name="student_id" size="15" maxlength="15" </th>
<th width="507" scope="col" bgcolor="#CCFFFF">

Input Date: <input type="text" name="insert_date" size="15" maxlength="15" </th><br>
<?php
//Prints something like: Monday 15th of January 2003 05:51:38 AM
echo date("l dS of F Y -- h:i:s A");//Prints something like: Monday the 15th
?>
</tr>
<tr>
<td><p><i><strong>Enter Name: First, Last</strong></i><br>
<input type="text" name="fname" size="15" maxlength="15"> 
<input type="text" name="lname" size="30" maxlength="30">  
<br><b>Address:</b> <br>
<input type="text" name="address" size="40" maxlength="40">
</p>
<p><b>City, State, Zip Code</b> <br>
<input type="text" name="city" size="15" maxlength="15">,
<input type="text" name="state" size="4" maxlength="4">
<input type="text" name="zip" size="10" maxlength="20">
<br>
</p></td>
<td><b>CTC Organization:</b><br>
<select size="1" name="ctcorg">
<option selected>Select One</option>
<option>Bloomfield Garfield Corp.</option>
<option>East End Cooperative Ministry</option>
<option>Mt. Ararat Community Activity Center</option>
<option>Parental Stress Center</option>
<option>YouthPlaces</option>
</select> <br><br>

  <b>Case Manager :</b> <br>
   <input type="text" name="cmanager" size="40" maxlength="40">

	<p><b>Neighborhood:<br>
	<select size="1" name="neighborhood">
	<option selected>Select One</option>
	<option>Bloomfield</option>
	<option>Garfield</option>
	<option>East Liberty</option>
	<option>Lincoln/Larmar</option>
	<option>Shadyside</option>
	<option>South Point Breeze</option>
	<option>North Point Breeze</option>
	</select></b></p>
<p>&nbsp;</td>

</tr>
<tr>
<td valign="top"><p><b>Home Phone:</b> <br>
<input type="text" name="hphone" size="40" maxlength="40">
</p>
<p><b>Mobil Phone:</b> <br>
<input type="text" name="mphone" size="40" maxlength="40">
</p>
<p><b>Email Address:</b></p>

  </p>
      <input type="text" name="email" size="40" maxlength="40">
  </p>
  </td>
<td>
<p><b>Notes:<br>
</b><textarea rows="5" name="notes" cols="48"></textarea><br>
      &nbsp;</td>

</tr>
</table>
</fieldset>
<p><input type=submit name="submit" value="Insert Record"></p>
</p>
</div>
</form>

<?php
include_once ('include/footer.html');
?>

As I said this form works fine for putting data into the database.

Now I would like to use it to view the results of the database.

How do I go about shifting the job of the form to show data rather that post data.

Here is the .php script I am using to post the data.

<?php
// open the connection
//connect to server and select database
$conn = mysql_connect("db.wireless-neighborhoods.org", "scfn", "scfn75") or die(mysql_error());
mysql_select_db("scfn",$conn) or die(mysql_error());
$sql = "INSERT INTO client values ('', '$POST[student_id]', NOW(), '$POST[fname]', '$POST[lname]', '$POST[address]', '$POST[city]', '$POST[state]', '$POST[zip]', '$POST[hphone]', '$POST[mphone]', '$POST[email]', '$POST[ctcorg]', '$POST[cmanager]', '$POST[neighborhood]', '$POST[notes]', NOW() )";
// execute the SQL statement
if (mysql_query($sql, $conn)) {
echo "<P>Your entry has been added.<br> Would you like to
<a href=\"basicinfo_form.php\">add another</a>or return <a href=\"indexdata.php\">Home</a>?</p>";
} else {
echo "something went wrong";
}
?>

Can anyone help.

pete_bisby

Does the "client" table have an auto_increment value? If it does, use mysql_insert_id() straight after your INSERT query to retrieve this id.

Then, have a query at the top of the form to retrieve the data you have just inserted:

$qry = "SELECT * FROM client WHERE clientID=$clientID";

Within each input tag in your form will be the "value" attribute, which will have the relevant information from the data you have retrieved:

...
...
<input type="text" name="fname" size="15" maxlength="15" value="<?php echo $row["fname"]; ?>">
<input type="text" name="lname" size="30" maxlength="30" value="<?php echo $row["lname"]; ?>">
...
...

If there is now $row present, it will simply enter no data. You can do a simple check, so if a client ID is passed to your form you run a SELECT query and the form is populated for viewing purposes; if not, then the form is blank for data-entry purposes.

jsims

Thank you for your response.

Yes my table has a id column.

Here is a copy of my table:

CREATE TABLE client (
id int(11) NOT NULL auto_increment,
student_id int(11) default NULL,
input_date datetime default NULL,
fname varchar(30) default NULL,
lname varchar(15) default NULL,
address varchar(30) default NULL,
city varchar(12) default NULL,
state varchar(4) default NULL,
zip varchar(12) default NULL,
hphone varchar(15) default NULL,
mphone varchar(15) default NULL,
email varchar(40) default NULL,
ctcorg varchar(40) default NULL,
cmanager varchar(20) default NULL,
neighborhood varchar(50) default NULL,
notes varchar(250) default NULL,
registration_date datetime default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

after I connect to the database, I understand that I would generate a sql line:

$query = "SELECT * FROM client WHERE id=$clientID";

is this correct?

do I need anything else like:

 $get_names_res = mysql_query($get_names) or die(mysql_error());

or something similar?

Thank you

John😃

pete_bisby

Nope, that's it. So each of your input tags would have, for example:

...
<input .... value="<?php echo $get_names_res["fname"]; ?>" ... >
...