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

Did you know?Explore Trending and Topic pages for more stories like this.

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}


</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

cURL proxy
Okay here is the thing... i know how to add proxys

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,

Displaying a record from mysql in a simple swf file
Hi,

I have a mysql database containing information I would like to display in my swf.

Post PHP form to non-existing page
The company that I work for host their PHP code on IIS on a Windows server, no Apache, so no mod_rew

Operator precedence assistance.
I did a quick Google search and couldn't quite find the answer I wanted in terms I could understand,

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Problem with Sending Mail by PHP 
hello all,
        I m new to php, can u plz provide me the code to send mail by php having CAPTC
how do I show what a user have selected from a checkbox? 
From my code below, how would i show which check boxes have been checked and which radio buttons sel
Check Date/Time in PHP 
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h
Basic Question about Threading and PHP... 
I have a page that I am working on and it is taking several hours to process.  The basics of what th
BAPI BBP_INB_DELIVERY_CREATE - material number missing in delivery 
Hi Experts,



I was able to successfully create an Inbound delivery with reference to a PO

Sign up to write

Sign up now if you have flare of writing..

Login | Register

Follow Us

Indyaspeak @ Facebook

Indyaspeak @ Twitter

Indyaspeak @ Pinterest

Follow @indyaspeak

Play Free Quiz and Win Cash