Navigation?

zenix · #1 (**permalink**) 07-02-09, 06:37 AM

Hello, I am making some progress on this database I am building for practice...I am new to programming...and was wondering if there is any way to add navigation functionality using buttons or links under the fields being displayed to go to the next or previous record.

I Also am trying to figure out how to display the table information in editable fields on a form so updating it can be more simple, trying to learn that one on my own, but if anyone has any advice i would certainly appreciate it.

Thank you in advance! This is an awesome forum!

soloWebDev · #2 (**permalink**) 07-10-09, 09:37 AM

I googled: php mysql next previous
php mysql next previous - Google Search
the first link is good and should give you a good direction.

the second part would be done by having something like this.

PHP Code:


			
<?php
//connect to db
include("connection.php");
if($update == 'Update'){
    $upd = "UPDATE table SET name = '".$name."', fColor = '".$fColor."' WHERE x = '".$yID."'";
    mysql_query($upd);
    unset($upd)
    $desLoc = 'thankYou.php';
    header('Location: '.$desLoc);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>demo</title>
</head>

<body>
<?php
    $sql = "SELECT yID, name, fColor FROM table WHERE x = '".$y."'";
    $res = mysql_query($sql);
    $row = mysql_fetch_row($res);
    $yID = $row[0];
    $name = $row[1];
    $favColor = $row[2];
?>
<table width="500">
<form name="f1" action="" method="post">
<input type="hidden" name="yID" value="<?=$yID?>" />
    <tr>
        <td colspan="2">Form</td>
    </tr>
    <tr>
        <td>Name</td>
        <td><input type="text" name="name" value="<?=$name?>" />
    </tr>
    <tr>
        <td>Fav Color</td>
        <td><input type="text" name="fColor" value="<?=$favColor?>" /></td>
    </tr>
    <tr>
        <td colspan="2"><input type="submit" name="update" value="Update" /></td>
    </tr>
</form>
</table>
</body>
</html>