 |  |  |  |  |  |  |  |
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 action apache api array beginner binary broken cakephp checkbox class classes cms code cron curl database date destroy display dynamic echo echo$_get[x]changingitintovariable... email encode error fcc file files folder form forms function functions google header howtowriteathesis href htaccess html if-else image images include insert ip javascript joomla limit link local login mail memberships menu mlm mod_rewrite multiple multipletables mysql mysqlquery neutrality oop open passwords paypal pdf php provider query radio random record remote rss script search server sessions sockets source space sql strip_tags syntax system table template thesishelp tutorial update upload url validator variable video voteup web window.onbeforeunload=closeme; youtube
