[RESOLVED] help with html forms and submit button

justintoo1

hello,

i have a page that helps create schedules.
it has 2 drop down lists that are populated from tables columns.

when i click the submit button - nothing happens. i atleast expect and error since i do not have a script called xxxprocessform.php.

can someone help with my logic flaw..?

index.php

<?php

/* Requires the header and the header
   requires config.php */

require("header.php");


if($_POST['submit']) {
   $db  = mysql_connect($dbhost, $dbuser, $dbpassword);
          mysql_select_db($dbdatabase, $db);
}
echo mysql_error();

?>


<br/>
<br/>

<div id="main">

<h3>Employee Search</h3>
<form action="XXXprocessform.php" method="post">
<?php

echo    "<br>";

$fieldavail = mysql_list_fields("sch", "avail", $db);
$colavail = mysql_num_fields($fieldavail);
echo    "<p>What day ?</p>";
echo    "<form action=xxxprocess.php method=POST><select name='$avail'>";
   for ($i = 1; $i < $colavail; $i++) {
   echo "<option value=$i>";
   echo mysql_field_name($fieldavail, $i);
   }

echo "</select></form>";
echo "<br>";

$fieldarea = mysql_list_fields("sch", "area", $db);
$colarea = mysql_num_fields($fieldarea);

echo "<p>What area ?</p>";
echo "<form action=xxxprocess.php method=POST><select name='$area'>";
   for ($i = 1; $i < $colarea; $i++) {
   echo "<option value =$i>";
   echo mysql_field_name($fieldarea, $i);
   }
echo "</select></form>";
?>

<br><br>
<input type="submit" name="submit" value="Search employees">

</select>
</form>
</div>
</body>

and this is what my header consists of...

<?php
require("config.php");

$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die(mysql_error());
mysql_select_db($dbdatabase, $db);
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML
4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
   <title><?php echo $config_sitename; ?></title>
   <link href="stylesheet.css" rel="stylesheet">



   <div id="header">
   <h1><?php echo $config_sitename; ?></h1>
   </div>

</head>
<body>

again nothing happens....i do no have that script avail yet. so i wouod expect an error. thanks - justin

johanafm

Vvalidate your code and it will work once you fix those issues.

justintoo1

Hello, I have fixed it.

All goes well, acts like I would expect it.

Except during the execution of process.php the results from gettype() is null;

What I am trying to do is get the selected [avail] from the avail drop down and pass it through to process.php and simply display it. I don't know how to get variables from my options. can you help ?

test2.php

<?

// Open <html> tag.
echo "<html>";
// Open <header> and <title> tags, close </title>.
echo "<head><title>PHP Info - test2.php</title>";

require("header.php");

//echo "</head>"; - Uneccessary, closed in [header.php]

//echo "<body>"; - Uneccessary, opened in the end of [header.php]

// Close php tag, straight into <html>, <body> was opened in [header.php]
?>

<!--HTML-->

<br><br>

<!-- Open main div -->
<div id="main">

<h3>Employee Search</h3>
<br>

<form action="process.php" method="post">

<!-- Create drop down for [avail] -->
<?php

$fieldavail = mysql_list_fields("sch", "avail", $db);
$colavail = mysql_num_fields($fieldavail);
echo 	"<p>What day ?</p>";
echo 	"<form action=process.php method=POST name='avail'>";
echo 	"<select name='AVAIL'>";
echo "<option value='deef'> Select an avail   </option>";	
for ($i = 1; $i < $colavail; $i++) {
echo "<option value=$i>";
echo mysql_field_name($fieldavail, $i);
}
echo "</select>";
echo "</form>";
echo "<br>";
?>	
<!-- Create drop down for [area] -->
<?
	$fieldarea = mysql_list_fields("sch", "area", $db);
	$colarea = mysql_num_fields($fieldarea);

echo "<p>What area ?</p>";
echo "<form action=test2.php method=POST name='area'>";
echo "<select name='$area_option'>";
echo "<option value='deeg'> Select an area   </option>";	
for ($i = 1; $i < $colarea; $i++) {
echo "<option value =$i>";
echo mysql_field_name($fieldarea, $i);
}
echo "</select>";
echo "</form>";
echo "<br><br>";
echo "<form id='goat' name='goat' action=process.php method=POST>";
echo "<input type='submit' name='submit' value='Search employees'>";
echo "<br><br>";

//echo "</div>";
?>

<!-- Close main div--> 
</div>

<?
// Close </body> tag.
echo "</body>";
// Close <html> tag.
echo "</html>";
// End.
?>

and here is my process.php file

<?

// Open <html> tag.
echo "<html>";
// Open <header> and <title> tags, close </title>.
echo "<head><title>PHP Info - [Schedule Assistant] - process.php</title>";

require("process_header.php");

//echo "</head>"; - Uneccessary, closed in [process_header.php]

//echo "<body>"; - Uneccessary, opened in the end of [process_header.php]

// Close php tag, straight into <html>, <body> was opened in [process_header.php]
?>

<!--HTML-->

<br><br>

<!-- Open main div -->
<div id="main">

<h3>Hello, results.</h3>
<br>

<?

$avail = ($_POST['AVAIL']);
echo $avail . '  ';
echo $AVAIL;
echo gettype($avail);
echo "<br>";


echo "<br>";
$area = ($_POST[$area_option]);
echo $area . '  ';
echo gettype($area);
echo "<br>";
?>

<!-- Close main div--> 
</div>

<?
// Close </body> tag.
echo "</body>";
// Close <html> tag.
echo "</html>";
// End.
?>

thank you for helping - justin

halojoy

    for ($i = 1; $i < $colavail; $i++) {
    echo "<option value=$i>";
    echo mysql_field_name($fieldavail, $i);
    }

should be:

    for ($i = 1; $i < $colavail; $i++) {
    echo "<option value=$i>";
    echo mysql_field_name($fieldavail, $i);
    echo "</option>";
    }

justintoo1

hello,

i am making some progress, but something is still wrong. I used gettype to tell me what my POST vari are ending up to be set.

I take the selected options and send them through to POST using avail_option and area_option.

When I process it - I assign the post variables to my variables ($area,$avail) but when I gettype them they are returned as numbers but strings.
I would like them to be assigned one of the options names, (availmon, availtue, availwed, etc..)

So I have created a way arond for the mean time...can anyone help me simplfy my processing ?
My code is a bit messy, pardon me.

test2.php

<?

// Open <html> tag.
echo "<html>";
// Open <header> and <title> tags, close </title>.
echo "<head><title>PHP Info - test2.php</title>";

require("header.php");

//echo "</head>"; - Uneccessary, closed in [header.php]

//echo "<body>"; - Uneccessary, opened in the end of [header.php]

// Close php tag, straight into <html>, <body> was opened in [header.php]
?>

<!--HTML-->

<br><br>

<!-- Open main div -->
<div id="main">

<h3>Employee Search</h3>
<br>

<!--<form method="post" action="process.php">-->

<!-- Create drop down for [avail] -->
<?php

   $fieldavail = mysql_list_fields("sch", "avail", $db);
   $colavail = mysql_num_fields($fieldavail);

   echo    "<p>What day ?</p>";
   echo    "<form action=process.php method=POST>";
   echo    "<select name='avail_option'>";
   for ($i = 1; $i < $colavail; $i++) {
   echo "<option value=$i>";
   echo mysql_field_name($fieldavail, $i);
   echo "</option>";
   }
   echo "</select>";
//   $avail = $_POST['avail_option'];
//   echo "</form>";
   echo "<br>";
?>   

<!-- Create drop down for [area] -->
<?
   $fieldarea = mysql_list_fields("sch", "area", $db);
   $colarea = mysql_num_fields($fieldarea);

   echo    "<p>What area ?</p>";
   echo    "<form action=process.php method=POST>";
   echo    "<select name='area_option'>";   

   for ($i = 1; $i < $colarea; $i++) {
   echo "<option value =$i>";
   echo mysql_field_name($fieldarea, $i);
   echo "</option>";   

   }   

   echo "</select>";
//   $area = $_POST['area_option'];
//   echo "</form>";
   echo "<br>";
?>

<form action=process.php method=POST>
<!--
echo "<input type='submit' name='submit' value='Search employees'>";
echo "<br><br>";
//echo "</div>";
?>-->

<input type='submit' name ='submit' value='Search'>

<!-- Close main div-->
</div>

<!--<?
// Close </body> tag.
echo "</body>";
// Close <html> tag.
echo "</html>";
// End.
?>-->
</body>
</html>

and this is what my process.php looks like..

<?

// Open <html> tag.
echo "<html>";
// Open <header> and <title> tags, close </title>.
echo "<head><title>PHP Info - [Schedule Assistant] - process.php</title>";

require("process_header.php");

//echo "</head>"; - Uneccessary, closed in [process_header.php]

//echo "<body>"; - Uneccessary, opened in the end of [process_header.php]

// Close php tag, straight into <html>, <body> was opened in [process_header.php]
?>

<!--HTML-->

<br><br>

<!-- Open main div -->
<div id="main">

<h3>Hello, results.</h3>
<br>

<?


   $avail = $_POST[avail_option];
   $area = $_POST[area_option];


echo "<h2> Avail </h2>";
echo "<br>";

switch ($avail)
{
   case '1':
   $sel_av = 'Monday';
   break;
   case '2':
   $sel_av = 'Tuesday';
   break;
   case '3':
   $sel_av = 'Wednesday';
   break;
   case '4':
   $sel_av = 'Thursday';
   break;
   case '5':
   $sel_av = 'Friday';
   break;
   case '6':
   $sel_av = 'Saturday';
   break;
   case '7':
   $sel_av = 'Sunday';
   break;
}

echo $sel_av;
echo "<br><br>";


echo $avail;

echo gettype($avail);
echo "<br>";

echo "<h2> Area </h2>";
echo "<br>";
switch ($area)
{
   case '1':
   $sel_ar = 'Bakery';
   break;
   case '2':
   $sel_ar = 'Dining Room';
   break;
   case '3':
   $sel_ar = 'Dishes';
   break;
   case '4':
   $sel_ar = 'Line';
   break;
   case '5':
   $sel_ar = 'Register';
   break;
}

echo $sel_ar;
echo $area;

echo gettype($area);
echo "<br>";

//echo "$fieldavail";
//echo $colavail;
//echo $fieldarea;
//echo $colarea;

echo 'right here....<br>';
var_dump($_POST);

?>

<!-- Close main div-->
</div>

<?
// Close </body> tag.
echo "</body>";
// Close <html> tag.
echo "</html>";
// End.
?>

good day. - justin

halojoy

Your form is a bit messy
I dont think it can work at all as is.

This is how you should have it bascially
I show only a few points.

You should only have one form.

So, you should only have one form opening tag.
Somewhere before select 'avail':
<form method="post" action="process.php">

and you should have one form closing tag
After one submit button:
</form>

I have left out a lot. You should add it.
This is only to show the basic elements arrangement.

<!-- Open main div -->
<div id="main">

<form action="process.php" method="POST">

<?php

   echo    "<select name='avail_option'>";
   for ($i = 1; $i < $colavail; $i++) {
   echo "<option value=$i>";
   echo mysql_field_name($fieldavail, $i);
   echo "</option>";
   }
   echo "</select>";


   echo    "<select name='area_option'>";   

   for ($i = 1; $i < $colarea; $i++) {
   echo "<option value =$i>";
   echo mysql_field_name($fieldarea, $i);
   echo "</option>";   

   }   

   echo "</select>"; 
?>

<input type='submit' name='submit' value='Search employees'>

</form>

<!-- Close main div-->
</div>

halojoy

About getting fieldnames instead of numbers in $_POST
this is easy to fix.
We set each option value="fieldname"

    echo    "<select name='avail_option'>";
   for ($i = 1; $i < $colavail; $i++) {

   $fieldname = mysql_field_name($fieldavail, $i);

   echo "<option value=$fieldname>";
   echo   $fieldname;
   echo "</option>";

}
echo "</select>";

justintoo1

Ok I have cleaned it up a bit and implemented some of your suggestions.

I have dabbled around and checked some docs and I think I have successfully configured my processing.

have a look...

<?
echo "<html>";
echo "<head><title>PHP Info - [Schedule Assistant] - process.php</title>";
require("process_header.php");
?>

<!--HTML-->

<br><br>

<!-- Open main div -->
<div id="main">
<br><br>
<h3>Hello, results.</h3>

<!-- Open PHP -->
<?

// Assign POST varis to my varis.
$avail = $_POST[avail_option];
$area = $_POST[area_option];

echo 	"<h1> Avail </h1>" .
	"<br>" .
	"<h2>" . $avail . "</h2>" .
	"<br>";

echo 	"<h1> Area </h1>" .
	"<br>" . 
	"<h2>" . $area . "</h2>" .
	"<br><br>";

$query = "select empname from emp
	 join area a using (areaid)
	 join avail b using (availid)
	 where a.$area = 'y'
	 and b.$avail = 'y'";

$result = mysql_query($query)
or die ('Query error in : $query ' . mysql_error());

if (mysql_num_rows($result) > 0) {
	while($row = mysql_fetch_row($result)) {
		echo $row[0];
		echo "<br>---<br>";
		echo $row[1];
	}
}
else {
	echo 'No rows found!!';
}

//<!-- Close main div--> 
echo "</div></body></html>";
?>

...I have done what I set to do, and here is the output that I wanted and recieved...

 Avail

availmon

Area

areadish


Justin
---
Phil
---
Dee
---

thanks for your help I apperciate it! - justin..

halojoy

Nice!
Glad it works.