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

Recode Abap Dynpro into Web Dynpro
Hi All,
A client has asked us to look at rearchitecting a custom transaction that was developed

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

Not showing whole name with mail () script
I sent up a simple mail form with the PHP mail() script. One problem is when it sends an email with

my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they

Need help making a script that moves data into acrhive table
Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a b

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

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