You can use a session array to store your records.
This is quite efficient because all records are stored in memory and the database is only queried when you add a record.
This will only allow you to view and add records.
You will have to add an update query to change an existing record.
PHP Code:
<?php
session_start();
$conn = mysql_connect('localhost', 'root', '')or die(mysql_error());
$create = mysql_query("CREATE DATABASE IF NOT EXISTS db1") or die(mysql_error());
mysql_select_db ("db1");
$testdb = 'CREATE TABLE IF NOT EXISTS testable(id int (11) NOT NULL auto_increment,
lname varchar(40) NOT NULL,
fname varchar(40) NOT NULL,
address varchar(40) NOT NULL,
address2 varchar(40) NOT NULL,
city varchar(15) NOT NULL,
state varchar(2) NOT NULL,
zip int(5) NOT NULL,
phone varchar(11) NOT NULL,
notes longtext NOT NULL,
PRIMARY KEY(id),
KEY testype(lname, fname))';
$result = mysql_query($testdb) or die(mysql_error());
$array_position = !empty($_POST["key"]) ? $_POST["key"] : 0;
if(!empty($_POST["next"]))
{
if(isset($_SESSION["fname"][$array_position]))
{
$array_position++;
}
}
if(!empty($_POST["prev"]))
{
$array_position--;
if($array_position<0){$array_position = 0;}
}
if(!empty($_POST["add"]))
{
$_SESSION["lname"][] = $_POST['lname'];
$_SESSION["fname"][] = $_POST['fname'];
$_SESSION["address"][] = $_POST['address'];
$_SESSION["address2"][]= $_POST['address2'];
$_SESSION["city"][] = $_POST['city'];
$_SESSION["state"][] = $_POST['state'];
$_SESSION["zip"][] = $_POST['zip'];
$_SESSION["phone"][] = $_POST['phone'];
$_SESSION["notes"][] = $_POST['notes'];
$insert = "INSERT INTO testable(lname,fname,address,address2,city,state,zip,phone,notes) VALUES('".$_POST['lname']."','".$_POST['fname']."','".$_POST['address']."','".$_POST['address2']."','".$_POST['city']."','".$_POST['state']."','".$_POST['zip']."','".$_POST['phone']."','".$_POST['notes']."')";
$results = mysql_query($insert) or die ("Couldn't insert into database because: " .mysql_error());
if(mysql_affected_rows()==1){echo 'Data inserted successfully!';}
}
?>
<form name="form" method="post" action="#">
<table>
<tr><td align="right">First Name: </td><td><input type="text" name="fname" value="<?php echo $_SESSION["fname"][$array_position]; ?>"></td><td align="right">Last Name: </td><td><input type="text" name="lname" value="<?php echo $_SESSION["lname"][$array_position]; ?>"></td></tr>
<tr><td align="right">address: </td><td><input type="text" name="address" value="<?php echo $_SESSION["address"][$array_position]; ?>"></td><td colspan=2></td></tr>
<tr><td align="right">address2: </td><td><input type="text" name="address2" value="<?php echo $_SESSION["address2"][$array_position]; ?>"></td><td colspan=2></td></tr>
<tr><td align="right">City: </td><td><input type="text" name="city" value="<?php echo $_SESSION["city"][$array_position]; ?>"></td><td colspan=2></td></tr>
<tr><td align="right">State: </td><td><input type="text" name="state" value="<?php echo $_SESSION["state"][$array_position]; ?>"></td><td colspan=2></td></tr>
<tr><td align="right">Zip: </td><td><input type="text" name="zip" value="<?php echo $_SESSION["zip"][$array_position]; ?>"></td><td colspan=2></td></tr>
<tr><td align="right">Phone: </td><td><input type="text" name="phone" value="<?php echo $_SESSION["phone"][$array_position]; ?>"></td><td colspan=2></td></tr>
<tr><td align="right">Notes: </td><td><textarea name="notes"><?php echo $_SESSION["notes"][$array_position]; ?></textarea></td><td colspan=2></td></tr>
<tr><td colspan=4><input type="submit" name="add" value="Add a record"><input type="submit" name="next" value="View next record"><input type="submit" name="prev" value="View previous record"></td></tr>
</table>
<input type="hidden" name="key" value="<?php echo $array_position; ?>">
</form>