php forms and database navigatio


Posted on 16th Feb 2014 07:03 pm by admin

Hello,
I'm new to php and i'd like to post the following.
I have written code to get records from a DB and i need one record at a time to be filled in a form i created. Then the next record should be displayed after the user hits the "press any ket button". It does not work

PLEASE HELP !

code is following

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"


<?php

$labels = array( "user_name" => "User Name", "create_date" => "Creation Date", "password" => "Password",
"last_name" => "Last Name",
"first_name" => "First Name",
"street" => "Street",
"city" => "City",
"state" => "State",
"zip" => "Zip",
"email" => "Email",
"phone" => "Phone",
"fax" => "Fax");

$submit = "Press any key";
include("dbstuff.inc");
$cxn = mysqli_connect($host,$user,$passwd,$databname);
if (!cxn) {
printf("Can't connect to localhost. Errorcode: %dn", mysqli_connect_errno ());
}
else { echo "connection successful !";
}
/* or die ("could not connect to server");*/
$query = "SELECT * FROM customer ";
$result = mysqli_query ($cxn,$query) or die ("could not execute query");
/*$customer = mysqli_fetch_assoc($result);*/

?>

<html>
<head><title>Customer Record</title>
<style type='text/css'>

/*div {background-color:#b0c4de}*/
body {color:blue}
body {background-color:#b0c4de}

<!--
#form {margin: 1.5em 0 0 0;
padding: 15;
}
#field {padding-bottom: 1em;}
label {
font-weight: bold;
float: left;
width: 10%;
margin-right: 1em;
text-align: right;
}
-->
</style>

</head>
<body>
<h3> Customer Details</h3>

<?php
/* Loop that displays the form fields */
/* print_r ($customer);*/


while ($customer = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

echo "<form action = '$_SERVER[PHP_SELF]' method = 'POST'>
<div id='form'>";

foreach($labels as $field => $label)
{
echo "<div id='field'><label for='$field'>$label</label>

<input id='$field' name='$field' type='text'
size='50%' maxlength='65' value = {$customer[$field]} />

</div>n";

} /* foreach*/
echo "<input style='margin-left: 33%' type='submit' value='$submit' />n";

} /*while*/
/*echo "</div>n";*/


/* free result set */
mysqli_free_result($result);
/* close connection */
mysqli_close($cxn);

?>
</form></body></html>

No comments posted yet

Your Answer:

Login to answer
262 Like 7 Dislike
Previous forums Next forums
Other forums

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the strin

$action = "insert"; //$action = $_GET['action'];
$action = "insert";
//$action = $_GET['action'];

why is this invalid type? I am

How to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

Get dump of MySQL DB from Live Site
I'm after an easy, but secure way of generating and importing a MySQL dump from a remote server.

newbie question
Hi out thereIm totaly new in this forum and to .net and vb so here is a totaly newbie question.I wan

help with calculations on a flat text file
hello,
I have this code below that is attached to a flat file like this:
Email:LastName:FirstN

Firewall / visited websites logger
Hi. I have a firewall implementation and I want to log all the websites visited on the machine. S

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash