PHP Validation with select Boxes and queries

Trackignis

Hello This is my first post so sorry if its in the wrong place i have the below code;

<? include("header.inc.php"); ?>


<?
echo"
			<form name=resp_gen method=post action=require_access_master.php>
				<table>		
					<tr>
                   	<td>Username to be Checked (*):</td>
                    <td>
                    <select name=username_to_be_checked>	
                    <option value=>--- User Name ---</option>	";		

				$ORACLE_CONNECT = OCILogon($ORACLE_USERNAME, $ORACLE_PASSWORD, $ORACLE_SID);
				$query_username_to_be_checked = "
				SELECT DISTINCT USER_NAME, START_DATE
				FROM FND_USER
				WHERE (END_DATE IS NULL
				OR END_DATE > SYSDATE)
				AND START_DATE >= '01-FEB-2009'
				ORDER BY  USER_NAME 
				";
				$ORACLE_STATIC = OCIParse($ORACLE_CONNECT, $query_username_to_be_checked);
				OCIExecute($ORACLE_STATIC, OCI_DEFAULT);



				while ($PRINT_RECORD = oci_fetch_array ($ORACLE_STATIC, OCI_BOTH))
				{
					echo  "<option value=" . $PRINT_RECORD[0] . ">" . $PRINT_RECORD[0] . "</option>";
				}				

				echo "
				</select>
				  <input type=submit name=Submit_The_Data value=Select /> 
				</form>
				";?>

This is only a snippet of the code.

I need it to validate so if a user isnt selected it comes up with error saying please select a user. But i cant get my head round it. I cant seem to get each option to give an id.

Thanks

djjjozsi

after you send the form, check:

if(empty($_POST["username_to_be_checked"]))
print("Lets select a user!");

Trackignis

That isnt working 🙁

It just prints the lets select user all the time

djjjozsi

when you create the dropdown list, use "

<select name="username_to_be_checked">
if its needed, escape the quote-marks.

See the source code to check if the value-options pairs has a value.

This is the same when you build the form, a form should looks like this:

echo "<form name=\"resp_gen\" method=\"post\" action=\"require_access_master.php\">\r";

Trackignis

well i have it to work but it shows once the page is loaded, i want the writing to appear after its been submitted so if user hasnt choose a username it errors. But as soon as the page loads it shows the error.

djjjozsi

This is an example, how should you code this program.

<?php

while ( $PRINT_RECORD = oci_fetch_array ( $ORACLE_STATIC, OCI_BOTH ) )
{
		echo "<option value=\"" . $PRINT_RECORD[0] . "\">" . $PRINT_RECORD[0] . "</option>";
} 

echo "
					</select>
					  <input type=\"submit\" name=\"Submit_The_Data\" value=\"Select\" /> 
					</form>
					";

if ( !empty( $_POST["username_to_be_checked"] ) )
{
		echo "The selected user is " . $_POST["username_to_be_checked"];

	/*further codes come here*/
} 

?>