Hi there,
I have created a form but I also need to make an option field. This field has to get its value out of a mysql colomn.
What is the best way for my problem. How do I fill the option list with this source code.
<?php
//common.php
//common functions
//generate the HTML header
function GenerateHTMLHeader($message) {
printf("<HEAD><TITLE>Moves on the Web</TITLE></HEAD>");
printf("<BODY TEXT=\"#000000\" BGCOLOR=\"#999999\" LINK=\"#0000ee\"
VLINK=\"#551a8b\" Alink=\"#ff0000\">\n");
printf("<H1><font size=+2>Moves 2002</FONT></H1><BR><BR>");
printf("<TABLE CELLPADDING=4 CELLSPACING=0 BORDER=0 WIDTH=600>");
printf("<TR BGCOLOR=\"#dcdcdc\"><TD><FONT FACE=arial><b>");
printf("<TD ALIGN=right>");
printf("</FONT></TD></TR>");
printf("</TABLE>");
printf("<BR>");
}
//generate the main page
function GenerateFrontPage() {
//generate a html form with actionscript
printf("<FORM METHOD=post ACTION=main.php>");
//generate a button with value search move
printf("<INPUT TYPE=\"submit\" NAME=\"choice\" VALUE=\"search move\">");
printf(" ");
//generate a button with value add a new entry
printf("<INPUT TYPE=\"submit\" NAME=\"choice\" VALUE=\"add new move\">");
printf("<BR>");
printf("<BR>");
//print info how to use it
printf("<UL>");
printf("<LI>search entries in the move database by clicking on
<I>search move</I> button</LI>");
printf("<LI>add new move to move database by clicking on
<I>add a new entry</I> button </LI>");
printf("<LI>modify an existing move by clicking <I>search move</I>
button first and then choosing the entry to modify</LI>");
printf("<LI>delete an existing entry by clicking <I>search move</I>
button first and then choosing the entry to delete</LI>");
printf("</UL>");
printf("</Form>");
}
//display error messages
function DisplayErrMsg ($message){
printf("<BLOCKQUOTE><BLOCKQUOTE><BLOCKQUOTE><H3><FONT COLOR=\"#cc0000\">
%s</font></h3></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE>\n", $message);
}
//Generate the HTML form for add/modify/search
function GenerateHTMLForm($formValues, $actionScript, $submitLabel) {
//generate html form
printf("<FORM METHOD=post ACTION=\"%s\"><PRE>\n", $actionScript);
printf("<TABLE>");
printf("<TR><TD>Name:</TD>");
printf("<TD> <OPTION VALUE=text SIZE=35 NAME=cn VALUE=\"%s\"></TD>
<BR>", ($formValues) ? $formValues["cn"] : "");
printf("<TD>E-mail:</TD>");
printf("<TD><INPUT TYPE=text SIZE=35 NAME=mail VALUE=\"%s\"></TD></TR>
<BR>", ($formValues) ? $formValues["mail"] : "");
printf("<TR><TD>City:</TD>");
printf("<TD> <INPUT TYPE=text SIZE=35 NAME=locality VALUE=\"%s\"></TD>
<BR>", ($formValues) ? $formValues["locality"] : "");
printf("<TD>Description:</TD>");
printf("<TD><INPUT TYPE=text SIZE=35 NAME=description VALUE=\"%s\"></TD></TR>
<BR>", ($formValues) ? $formValues["description"] : "");
printf("<TR><TD>Telephone:</TD>");
printf("<TD><TEXTAREA NAME=telephonenumber COLS=\"30\" ROWS=\"6\">%s</TEXTAREA></TD></TR>
<BR>", ($formValues) ? $formValues["telephonenumber"] : "" );
//generate a buton with value $submitlabel
printf("</TABLE>");
printf("<INPUT TYPE=submit VALUE=\"%s\">", $submitLabel);
printf("</PRE></FORM>");
}
//Generate the HTML form for add/modify/search
function GenerateHTMLForm1($formValues, $actionScript, $submitLabel) {
//generate html form
printf("<FORM METHOD=post ACTION=\"%s\"><PRE>\n", $actionScript);
printf("name:
<INPUT TYPE=text SIZE=35 NAME=cn VALUE=\"%s\">
<BR>\n", ($formValues) ? $formValues["cn"] : "");
printf("City:
<INPUT TYPE=text SIZE=35 NAME=locality VALUE=\"%s\">
<BR>\n", ($formValues) ? $formValues["locality"] : "");
printf("Telephone:
<INPUT TYPE=text SIZE=35 NAME=telephonenumber VALUE=\"%s\">
<BR>\n", ($formValues) ? $formValues["telephonenumber"] : "");
//generate a buton with value $submitlabel
printf("<INPUT TYPE=submit VALUE=\"%s\">", $submitLabel);
printf("</PRE></FORM>");
}
//returntomain function generates a footer and take user back
//to main page after add/modify/delete/search
function ReturnToMain(){
//generate an html form with main.php as action script
printf("<BR><FORM ACTION=\"main.php\" METHOD=post>\n");
//create a submit button with value "click"
printf("<INPUT TYPE=submit VALUE=\"Click\"> to return to main page\n");
}
?>
