 |  |  |  |  |  |  |  |
Populating a fields on a form base on a selected item from a droplist.
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I am a second year IT student who is working on a project using PHP(frontend) and MySQL(backend). I am brand new to these softwares which are not being touch in class. I have 2 questions:
1. How do I populate fields (textboxes) in a html form from a selected item in a droplist. The droplist and fields in the form are from the same table. I have spend hours on this but seem to get no where.
2. How do I integrate the the above query into my code where I have add, update, and delete button on one page. The name of the page is add_event2.php
Table: events
-------------
event_code
title
duration
grade
type
desc_short
desc_long
<html>
<head><title>(Event Form)</title></head>
<body>
<?php
// db connectivity works
include 'db.php';
$tablename = 'events';
$value = "";
if (isset($_POST['submit'])){
$value = $_POST['submit'];
}
// create SQL statement
$sql = "SELECT event_code FROM $tablename ORDER BY event_code ASC";
// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");
// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {
$event_code = $row["event_code"];
// line gives an error but still copiles the list.
$option_block .= "<OPTION value=\"$event_code\"> $event_code</OPTION>";
}
switch($value){
case "Add":
print "Added..........<P>";
break;
case "Update":
print "Updated..........<P>";
break;
case "Delete":
print "Deleted..........<P>";
break;
case "": //first time to open this form.
//should populate fields in the form with the last record in the table event
print "First time to open this form .......<p>";
break;
}
?>
<form method="post" action="add_event2.php" ID="event_form">
<P><STRONG><U>Events</U></STRONG></P>
<P>Event Code: <br>
<SELECT name="$event_code">
<? echo "$option_block"; ?>
</SELECT>
<P>Title: <INPUT type="text" name="title"></P>
<P>Duration: <INPUT type="text" name="duration"></P>
<P>Grade: <INPUT type="text" name="grade"></P>
<P>Type: <INPUT type="text" name="type"></P>
<P>Short Description: <INPUT type="text" name="desc_short"></P>
<P>Long Description: <INPUT type="text" name="desc_long"></P>
<P>Road End Number: <INPUT type="text" name="road_end_id"></P>
<p><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Add"
<p><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Update"
<p><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Delete"
</form>
<?
// mysql_close($connection);
?>
</body>
</html>
Note that the above codes produce this error meassage but still seems to work:
Notice: Undefined variable: option_block in :\inetpub\wwwroot\add_event2.php on line 25
I would appreciate help urgently. If there is a better way of writing the codes, pls feel free to show me.
Thanks
tip
1. How do I populate fields (textboxes) in a html form from a selected item in a droplist. The droplist and fields in the form are from the same table. I have spend hours on this but seem to get no where.
2. How do I integrate the the above query into my code where I have add, update, and delete button on one page. The name of the page is add_event2.php
Table: events
-------------
event_code
title
duration
grade
type
desc_short
desc_long
<html>
<head><title>(Event Form)</title></head>
<body>
<?php
// db connectivity works
include 'db.php';
$tablename = 'events';
$value = "";
if (isset($_POST['submit'])){
$value = $_POST['submit'];
}
// create SQL statement
$sql = "SELECT event_code FROM $tablename ORDER BY event_code ASC";
// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");
// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {
$event_code = $row["event_code"];
// line gives an error but still copiles the list.
$option_block .= "<OPTION value=\"$event_code\"> $event_code</OPTION>";
}
switch($value){
case "Add":
print "Added..........<P>";
break;
case "Update":
print "Updated..........<P>";
break;
case "Delete":
print "Deleted..........<P>";
break;
case "": //first time to open this form.
//should populate fields in the form with the last record in the table event
print "First time to open this form .......<p>";
break;
}
?>
<form method="post" action="add_event2.php" ID="event_form">
<P><STRONG><U>Events</U></STRONG></P>
<P>Event Code: <br>
<SELECT name="$event_code">
<? echo "$option_block"; ?>
</SELECT>
<P>Title: <INPUT type="text" name="title"></P>
<P>Duration: <INPUT type="text" name="duration"></P>
<P>Grade: <INPUT type="text" name="grade"></P>
<P>Type: <INPUT type="text" name="type"></P>
<P>Short Description: <INPUT type="text" name="desc_short"></P>
<P>Long Description: <INPUT type="text" name="desc_long"></P>
<P>Road End Number: <INPUT type="text" name="road_end_id"></P>
<p><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Add"
<p><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Update"
<p><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Delete"
</form>
<?
// mysql_close($connection);
?>
</body>
</html>
Note that the above codes produce this error meassage but still seems to work:
Notice: Undefined variable: option_block in :\inetpub\wwwroot\add_event2.php on line 25
I would appreciate help urgently. If there is a better way of writing the codes, pls feel free to show me.
Thanks
tip
I have solve the following error by declaring $option_block = ''; at the top.
Note that the above codes produce this error meassage but still seems to work:
Notice: Undefined variable: option_block in :\inetpub\wwwroot\add_event2.php on line 25
Note that the above codes produce this error meassage but still seems to work:
Notice: Undefined variable: option_block in :\inetpub\wwwroot\add_event2.php on line 25
•
•
Join Date: Nov 2003
Posts: 360
Reputation: 
Solved Threads: 5
PHP/vBulletin Guru
To turn off notices, you should set error_reporting() to something else; check www.php.net/error_reporting for more info 
Your level is probably way too low; you should NEVER see Notice messages, they are only if you really want to debug things but about literally 95% of the time, notices are worthless.
Your level is probably way too low; you should NEVER see Notice messages, they are only if you really want to debug things but about literally 95% of the time, notices are worthless. These parts of my code produce a droplist which is populated by event_code field from the events table. But how do I populate the rest of the data on the form which an event_code is selected from droplist?
// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {
$event_code = $row["event_code"];
// line gives an error but still copiles the list.
$option_block .= "<OPTION value=\"$event_code\"> $event_code</OPTION>";
}
.
.
.
<FORM...............>
.
.
<P>Event Code: <br>
<SELECT name="$event_code">
<? echo "$option_block"; ?>
</SELECT>
.
.
</FORM>
SOS ta
tip
// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {
$event_code = $row["event_code"];
// line gives an error but still copiles the list.
$option_block .= "<OPTION value=\"$event_code\"> $event_code</OPTION>";
}
.
.
.
<FORM...............>
.
.
<P>Event Code: <br>
<SELECT name="$event_code">
<? echo "$option_block"; ?>
</SELECT>
.
.
</FORM>
SOS ta
tip
|
Similar Threads
- Saving ListBox selected Item in Cookies (ASP.NET)
- Multiple DDLs populating different fields in a form (ASP.NET)
Other Threads in the PHP Forum
- Previous Thread: Get the name of the current php file
- Next Thread: Converting Access Forms to PHP Forms
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
# 5.2.10 access alexa apache api array beginner binary broken cakephp checkbox class clean clients cms code convert cron curl database date directory display dissertation dropdown dynamic echo echo$_get[x]changingitintovariable... email encode error fairness file files folder form forms function functions google href htaccess html image images include indentedsubcategory ip javascript joomla legislation limit link local login mail memberships menu mlm multiple multipletables mysql mysqlquery network newsletters oop open passwords paypal pdf persist php provider query radio random redirect script search secure server sessions simple sockets source space spam sql system table tutorial upload url user variable video voteup web youtube