using option value result in a select

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kford11
Forum Newbie
Posts: 5
Joined: Thu Mar 15, 2012 12:15 pm

using option value result in a select

Post by kford11 »

Hello, this is my first post so i apologize if i am doing something incorrect. i have listed spinets of my code. I have a select statement pulling data from a mysql DB this portion is pulling the data correctly. below that i have a query where i am trying to use the option value selection as the where criteria, but the result is blank. not sure what i am missing.

thanks
Kenny

Code: Select all

<?php
$order_num   = $_REQUEST['order_num'];
?>

<form name="get_order" action="testmeterlookup.php" method="postt">
	<table width="100%" border="0" cellpadding="0" cellspacing="0">
	<tr><td align="center"><table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
	<tr><td align="center" valign="center"><table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
	<tr><td valign="center"><font size="4"><b>Test Profile:&nbsp;</b></font></td><td align="right">
	<select name="order_num" tabindex="1">
	<?php
	include( "dev_db.php");
	$connection = mysqli_connect( $server, $user, $pass, "prover");
	$query = "SELECT test_profile_id, profile_name FROM test_profiles ORDER BY profile_name";
	$result = mysqli_query($connection, $query);
	for( $x = 0; $row = mysqli_fetch_assoc( $result); $x++)
	{?>
	<option value="<?php $row['test_profile_id']; ?>"><?php echo $row['profile_name']; ?></option>
	<?php}
	mysqli_close( $connection);?>
	</select>
	</td></tr>
	<tr><td colspan="2"><br></td></tr>
	<tr><td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm" onmouseover="javascript:document.btn_sbm.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_one();"></td>
	</tr>	</table></td></tr></table></td></tr></table>
	<input type="hidden" name="method" value="0">
	</form>
$query = "SELECT * FROM prover.test_meter_out WHERE test_meter_out.test_profile_id = '" . $order_num . "' ORDER BY test_meter_out.test_meter_out_id";
	$result = mysqli_query($connection, $query);
	}//if
	fclose( $fpA);
	<?php
	exit();}mysqli_close( $connection);
Last edited by califdon on Thu Mar 15, 2012 1:09 pm, edited 1 time in total.
Reason: Moderator added syntax=php tags to make code readable. Note to poster, please always do this.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: using option value result in a select

Post by califdon »

As you can see by the highlighting above when you use

Code: Select all

 tags, your second query is not within a <?php block, so it is not being parsed by PHP, thus nothing will happen except printing the PHP code in the browser. Move your <?php tag up about 4 lines, before the line that begins with $query =. Also, you don't need the last line you showed (exit();mysqli_close($connection);) because that happens automatically when the script ends. But you should have a closing php tag: ?> at the very end, even though it will work on most servers if you omit it.
kford11
Forum Newbie
Posts: 5
Joined: Thu Mar 15, 2012 12:15 pm

Re: using option value result in a select

Post by kford11 »

sorry, in my entire code i do have the <?php there so my $query is located ok. I just did not pull that into my example.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: using option value result in a select

Post by califdon »

I'm sorry but that's not what your code shows. You ended a PHP block within which you closed your database connection (which you don't really need to do, by the way) and unless you omitted some lines of code, then there are about 7 or 8 lines of HTML, then you start trying to assign a value to a PHP variable, $query. That won't work. If you did omit some lines in that region, please show that entire region so that we can have some chance to explain what you did wrong.
kford11
Forum Newbie
Posts: 5
Joined: Thu Mar 15, 2012 12:15 pm

Re: using option value result in a select

Post by kford11 »

sorry i did omit some lines thought my entire code would be to long. I have now posted my entire code. the variable in question is $profile. thanks again for the help.

Code: Select all

<?php
	$method      = $_REQUEST['method'];
	$ive_waited  = $_REQUEST['ive_waited'];
	$address     = $_REQUEST['address'];
	$filename_A  = $_REQUEST['filename_A'];
	$filename_C  = $_REQUEST['filename_C'];
	$no_data     = $_REQUEST['no_data'];
	$profile	 = $_REQUEST['profile'];
	$meter_num   = $_REQUEST['meter_num'];
	$start_month = $_REQUEST['start_month'];
	$start_day   = $_REQUEST['start_day'];
	$start_year  = $_REQUEST['start_year'];
	$end_month   = $_REQUEST['end_month'];
	$end_day     = $_REQUEST['end_day'];
	$end_year    = $_REQUEST['end_year'];

	if( !isset( $method))
	{
		?>
			<html>
			<head>
				<title>Test Meter Data Lookup</title>

				<script language="javascript" type="text/javascript">
					function check_form_one()
					{
						document.get_order.submit();
					}
					function check_form_two()
					{
						if( document.meter_num.meter_num.value == "")
						{
							alert("Meter Number(s) is a required field.");
							document.meter_num.meter_num.focus();
							return;
						}
						document.meter_num.submit();
					}
					function check_form_thr()
					{
						document.meter_date.submit();
					}
				</script>
			</head>

			<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:document.get_order.profile.focus();">
				<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
					<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
				</table>
				<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td height="20" width="5"   background="images/all_strip.jpg"   ></td>
						<td height="20" width="637" background="images/all_strip.jpg"   ></td>
					</tr>
				</table>
				<br><br><br>
				<form name="get_order" action="testmeterlookup.php" method="post">
					<table width="100%" border="0" cellpadding="0" cellspacing="0">
						<tr>
							<td align="center">
								<table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
									<tr>
										<td align="center" valign="center">
											<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
												<tr>
													<td valign="center"><font size="4"><b>Test Profile:&nbsp;</b></font></td>
													<td align="right">
														<select name="profile" tabindex="1">
														<?php
																include( "dev_db.php");
																$connection = mysqli_connect( $server, $user, $pass, "prover");

																$query = "SELECT test_profile_id, profile_name FROM test_profiles ORDER BY profile_name";
																$result = mysqli_query($connection, $query);

																	for( $x = 0; $row = mysqli_fetch_assoc( $result); $x++)
																	{
																		?>
																		<option value="<?php $row['test_profile_id']; ?>"><?php echo $row['profile_name']; ?></option>
																		<?php
																	}
																mysqli_close( $connection);
															?>
														</select>
													</td>
												</tr>
												<tr><td colspan="2"><br></td></tr>
												<tr>
													<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm" onmouseover="javascript:document.btn_sbm.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_one();"></td>
												</tr>
											</table>
										</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
					<input type="hidden" name="method" value="0">
				</form>
				<br>
				<form name="meter_num" action="testmeterlookup.php" method="post">
					<table width="100%" border="0" cellpadding="0" cellspacing="0">
						<tr>
							<td align="center">
								<table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
									<tr>
										<td align="center" valign="center">
											<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
												<tr>
													<td align="center" valign="center" height="100%" colspan="2"><font size="4"><b>Meter Number(s):&nbsp;</b></font></td>
												</tr>
												<tr>
													<td align="center" colspan="2"><textarea cols="33" rows="5" tabindex="5" name="meter_num"><?php if( isset( $meter_num)){ echo $meter_num; } ?></textarea></td>
												</tr>
												<tr><td colspan="2"><br></td></tr>
												<tr>
													<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm2" onmouseover="javascript:document.btn_sbm2.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm2.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_two();"></td>
												</tr>
											</table>
										</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
					<input type="hidden" name="method" value="1">
				</form>
				<br>
				<form name="meter_date" action="testmeterlookup.php" method="post">
					<table width="100%" border="0" cellpadding="0" cellspacing="0">
						<tr>
							<td align="center">
								<table width="300" border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
									<tr>
										<td align="center" valign="center">
											<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
												<tr>
													<td valign="center"><font size="4"><b>Start&nbsp;Date:&nbsp;</b></font></td>
														<td align="right" valign="center">
															<select name="start_month" tabindex="7">
																<?php
																	for( $x = 1; $x < 13; $x++)
																	{
																		?>
																			<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $start_month)){ if( $start_month == $x){ echo " selected"; } } else{ if( $x == date( "m")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
																		<?php
																	}
																?>
															</select>
															/
															<select name="start_day" tabindex="8">
																<?php
																	for( $x = 1; $x < 32; $x++)
																	{
																		?>
																			<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $start_day)){ if( $start_day == $x){ echo " selected"; } } else{ if( $x == date( "d")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
																		<?php
																	}
																?>
															</select>
															/
															<select name="start_year" tabindex="9">
																<?php
																	for( $x = 0; $x <= 12; $x++)
																	{
																		?>
																			<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $start_year)){ if( $start_year == $x){ echo " selected"; } } else{ if( $x == date( "y")){ echo " selected"; } } ?>>20<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
																		<?php
																	}
																?>
															</select>
														</td>
												</tr>
												<tr>
													<td valign="center"><font size="4"><b>End&nbsp;Date:&nbsp;</b></font></td>
													<td align="right" valign="center">
														<select name="end_month" tabindex="10">
															<?php
																for( $x = 1; $x < 13; $x++)
																{
																	?>
																		<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $end_month)){ if( $end_month == $x){ echo " selected"; } } else{ if( $x == date( "m")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
																	<?php
																}
															?>
														</select>
														/
														<select name="end_day" tabindex="11">
															<?php
																for( $x = 1; $x < 32; $x++)
																{
																	?>
																		<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $end_day)){ if( $end_day == $x){ echo " selected"; } } else{ if( $x == date( "d")){ echo " selected"; } } ?>><?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
																	<?php
																}
															?>
														</select>
														/
														<select name="end_year" tabindex="12">
															<?php
																for( $x = 0; $x <= 12; $x++)
																{
																	?>
																		<option value="<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?>"<?php if( isset( $end_year)){ if( $end_year == $x){ echo " selected"; } } else{ if( $x == date( "y")){ echo " selected"; } } ?>>20<?php echo str_pad( $x, 2, "0", STR_PAD_LEFT); ?></option>
																	<?php
																}
															?>
														</select>
													</td>
												</tr>
												<tr><td colspan="2"><br></td></tr>
												<tr>
													<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm3" onmouseover="javascript:document.btn_sbm3.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm3.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_thr();"></td>
												</tr>
											</table>
										</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
					<input type="hidden" name="method" value="2">
				</form>
				<br>
			</body>
			</html>
		<?php
		exit();
	}
	if( !isset( $ive_waited))
	{
		?>
			<html>
			<head>
				<title>Test Meter Data Lookup</title>
			</head>
			<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:document.waiting.submit();">
				<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
					<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
				</table>
				<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td height="20" width="5"   background="images/all_strip.jpg"   ></td>
						<td height="20" width="637" background="images/all_strip.jpg"   ></td>
					</tr>
				</table>
				<br><br><br>
				<table width="100%" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td align="center">
							<table border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
								<tr>
									<td align="center" valign="center">
										<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
											<tr>
												<td align="center" valign="center"><br><b>Please Wait...<b><br><br><b>Depending&nbsp;on&nbsp;the&nbsp;number&nbsp;of&nbsp;meters&nbsp;in&nbsp;your<br>query&nbsp;this&nbsp;process&nbsp;could&nbsp;take&nbsp;several&nbsp;minutes.</b><br><br></td>
											</tr>
										</table>
									</td>
								</tr>
							</table>
						</td>
					</tr>
				</table>
				<form name="waiting" action="testmeterlookup.php" method="post">
					<input type="hidden" name="ive_waited" value="1">
					<input type="hidden" name="method"     value="<?php echo $method; ?>">
					<?php
						if( isset( $meter_num))
						{
							?>
								<input type="hidden" name="meter_num" value="<?php echo $meter_num; ?>">
							<?php
						}
						else if( isset( $profile))
						{
							?>
								<input type="hidden" name="profile" value="<?php echo strtoupper( $profile); ?>">
							<?php
						}
						else
						{
							?>
								<input type="hidden" name="start_month" value="<?php echo $start_month; ?>">
								<input type="hidden" name="start_day"   value="<?php echo $start_day;   ?>">
								<input type="hidden" name="start_year"  value="<?php echo $start_year;  ?>">
								<input type="hidden" name="end_month"   value="<?php echo $end_month;   ?>">
								<input type="hidden" name="end_day"     value="<?php echo $end_day;     ?>">
								<input type="hidden" name="end_year"    value="<?php echo $end_year;    ?>">
							<?php
						}
					?>
				</form>
			</body>
			</html>
		<?php
		exit();
	}
	if( $method == 1 && !isset( $filename_A))
	{
		$no_data = 1;

		$filename_A = 'MeterData_' . date( "His") . '.tmp';

		$string_position = 0;
		$string_length   = strlen( $meter_num);

		$meter_numbers[0] = "NA";

		for( $x = 0; FALSE !== ($string_position = strpos( $meter_num, "20", $string_position)); $x++)
		{
			$possible_meter_number = substr( $meter_num, $string_position, 10);

			if( is_numeric( $possible_meter_number))
			{
				$meter_numbers[$x] = $possible_meter_number;
				$string_position += 10;
			}
			else
			{
				$string_position++;
				$x--;
			}
		}

		if( $meter_numbers[0] != "NA")
		{
			include( "dev_db.php");
			$connection = mysqli_connect( $server, $user, $pass, "prover");

			$fpA = fopen( $filename_A, 'w');

			fputs( $fpA, "Prover Number, Test Meter Number, Test Profile ID, Test Type, Open Pass/Fail, Check Pass/Fail, Qmin Pass/Fail, Test Block, Temp Cont, Test Date, Test Time, Open 1, Open Diff. 1, Check 1, Check Diff. 1, Qmin 1, Qmin Diff. 1, Open 2, Open Diff. 2, Check 2, Check Diff. 2, Qmin 2, Qmin Diff. 2, Open 3, Open Diff. 3, Check 3, Check Diff. 3, Qmin 3, Qmin Diff. 3\n");

			for( $x = 0; $x < count( $meter_numbers); $x++)
			{
				unset( $meter_data);

				$query = "SELECT test_meter_out.prover_num, test_meter_out.test_meter_num, test_profiles.profile_name, test_meter_out.test_type, test_meter_out.pass_fail_open, test_meter_out.pass_fail_check, test_meter_out.pass_fail_qmin, test_meter_out.test_block, test_meter_out.temp_cont, test_meter_out.test_date, test_meter_out.test_time, test_meter_out.open_1, test_meter_out.open_diff_1, test_meter_out.check_1, test_meter_out.check_diff_1, test_meter_out.qmin_1, test_meter_out.qmin_diff_1, test_meter_out.open_2, test_meter_out.open_diff_2, test_meter_out.check_2, test_meter_out.check_diff_2, test_meter_out.qmin_2, test_meter_out.qmin_diff_2, test_meter_out.open_3, test_meter_out.open_diff_3, test_meter_out.check_3, test_meter_out.check_diff_3, test_meter_out.qmin_3, test_meter_out.qmin_diff_3 FROM prover.test_meter_out, prover.test_profiles WHERE test_meter_out.test_profile_id = test_profiles.test_profile_id and test_meter_out.test_meter_num = '" . $meter_numbers[$x] . "' ORDER BY test_meter_out.test_meter_out_id";
				
				$result = mysqli_query($connection, $query);

				if( mysqli_num_rows( $result) > 0)
				{
					for( $y = 0; $row = mysqli_fetch_assoc( $result); $y++)
					{
						$meter_data[$y]['prover_num'] = $row['prover_num'];
						$meter_data[$y]['test_meter_num'] = $row['test_meter_num'];
						$meter_data[$y]['profile_name'] = $row['profile_name'];
						$meter_data[$y]['test_type'] = $row['test_type'];
						$meter_data[$y]['pass_fail_open'] = $row['pass_fail_open'];
						$meter_data[$y]['pass_fail_check'] = $row['pass_fail_check'];
						$meter_data[$y]['pass_fail_qmin'] = $row['pass_fail_qmin'];
						$meter_data[$y]['test_block'] = $row['test_block'];
						$meter_data[$y]['temp_cont'] = $row['temp_cont'];
						$meter_data[$y]['test_date'] = $row['test_date'];
						$meter_data[$y]['test_time'] = $row['test_time'];
						$meter_data[$y]['open_1'] = $row['open_1'];
						$meter_data[$y]['open_diff_1'] = $row['open_diff_1'];
						$meter_data[$y]['check_1'] = $row['check_1'];
						$meter_data[$y]['check_diff_1'] = $row['check_diff_1'];
						$meter_data[$y]['qmin_1'] = $row['qmin_1'];
						$meter_data[$y]['qmin_diff_1'] = $row['qmin_diff_1'];
						$meter_data[$y]['open_2'] = $row['open_2'];
						$meter_data[$y]['open_diff_2'] = $row['open_diff_2'];
						$meter_data[$y]['check_2'] = $row['check_2'];
						$meter_data[$y]['check_diff_2'] = $row['check_diff_2'];
						$meter_data[$y]['qmin_2'] = $row['qmin_2'];
						$meter_data[$y]['qmin_diff_2'] = $row['qmin_diff_2'];
						$meter_data[$y]['open_3'] = $row['open_3'];
						$meter_data[$y]['open_diff_3'] = $row['open_diff_3'];
						$meter_data[$y]['check_3'] = $row['check_3'];
						$meter_data[$y]['check_diff_3'] = $row['check_diff_3'];
						$meter_data[$y]['qmin_3'] = $row['qmin_3'];
						$meter_data[$y]['qmin_diff_3'] = $row['qmin_diff_3'];
					}

					$total_meter_data = count( $meter_data);

					$no_data = 0;

					for( $y = 0; $y < $total_meter_data; $y++)
					{
						fputs( $fpA, $meter_data[$y]['prover_num'] . ", " . $meter_data[$y]['test_meter_num'] . ", " . $meter_data[$y]['profile_name'] . ", " . $meter_data[$y]['test_type'] . ", " .$meter_data[$y]['pass_fail_open'] . ", " .$meter_data[$y]['pass_fail_check'] . ", " .$meter_data[$y]['pass_fail_qmin'] . ", " . $meter_data[$y]['test_block'] . ", " . $meter_data[$y]['temp_cont'] . ", " . $meter_data[$y]['test_date'] . ", " . $meter_data[$y]['test_time'] . ", " . $meter_data[$y]['open_1'] . ", " . $meter_data[$y]['open_diff_1'] . ", " . $meter_data[$y]['check_1'] . ", " . $meter_data[$y]['check_diff_1'] . ", " . $meter_data[$y]['qmin_1'] . ", " . $meter_data[$y]['qmin_diff_1'] . ", " .$meter_data[$y]['open_2'] . ", " .$meter_data[$y]['open_diff_2'] . ", " .$meter_data[$y]['check_2'] . ", " . $meter_data[$y]['check_diff_2'] . ", " . $meter_data[$y]['qmin_2'] . ", " . $meter_data[$y]['qmin_diff_2'] . ", " . $meter_data[$y]['open_3'] . ", " . $meter_data[$y]['open_diff_3'] . ", " . $meter_data[$y]['check_3'] . ", " . $meter_data[$y]['check_diff_3'] . ", " . $meter_data[$y]['qmin_3'] . ", " . $meter_data[$y]['qmin_diff_3'] . "\n");
					}
				}//if
			}//for

			fclose( $fpA);
			
			if( mysqli_num_rows( $result) < 1)
			{
				mysqli_close( $connection);
				?>
					<html>
					<head>
						<title>Proof Layout -  San Diego</title>

						<script language="javascript" type="text/javascript">
							function error()
							{
								alert("No Data Found For Your Result.\nPlease try again.");
								window.location = 'testmeterlookup.php';
							}
						</script>
					</head>
					<body onload="javascript:error();"></body>
					</html>
				<?php
				exit();
			}

			mysqli_close( $connection);
		}
		else
		{
			?>
				<html>
				<head>
					<title>Test Meter Data Lookup</title>

					<script language="javascript" type="text/javascript">
						function error()
						{
							alert("The meter number(s) you entered are not valid.\nPlease try again.");
							document.bad.submit();
						}
					</script>
				</head>
				<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:error();">
					<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
						<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
					</table>
					<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td height="20" width="5"   background="images/all_strip.jpg"   ></td>
						<td height="20" width="637" background="images/all_strip.jpg"   ></td>
					</tr>
					</table>
					<form name="bad" action="testmeterlookup.php" method="post">
						<input type="hidden" name="meter_num" value="<?php echo $meter_num; ?>">
					</form>
				</body>
				</html>
			<?php
			exit();
		}
	}
	else if( $method == 0 && !isset( $filename_A))//Test Profile
	{
		include( "dev_db.php");
		$connection = mysqli_connect( $server, $user, $pass, "prover");

		$filename_A = 'MeterData_' . date( "His") . '.tmp';

		$fpA = fopen( $filename_A, 'w');

		fputs( $fpA, "Prover Number, Test Meter Number, Test Profile ID, Test Type, Open Pass/Fail, Check Pass/Fail, Qmin Pass/Fail, Test Block, Temp Cont, Test Date, Test Time, Open 1, Open Diff. 1, Check 1, Check Diff. 1, Qmin 1, Qmin Diff. 1, Open 2, Open Diff. 2, Check 2, Check Diff. 2, Qmin 2, Qmin Diff. 2, Open 3, Open Diff. 3, Check 3, Check Diff. 3, Qmin 3, Qmin Diff. 3\n");

		//$no_data = 1;
		
		$query = "SELECT test_meter_out.prover_num, test_meter_out.test_meter_num, test_profiles.profile_name, test_meter_out.test_type, test_meter_out.pass_fail_open, test_meter_out.pass_fail_check, test_meter_out.pass_fail_qmin, test_meter_out.test_block, test_meter_out.temp_cont, test_meter_out.test_date, test_meter_out.test_time, test_meter_out.open_1, test_meter_out.open_diff_1, test_meter_out.check_1, test_meter_out.check_diff_1, test_meter_out.qmin_1, test_meter_out.qmin_diff_1, test_meter_out.open_2, test_meter_out.open_diff_2, test_meter_out.check_2, test_meter_out.check_diff_2, test_meter_out.qmin_2, test_meter_out.qmin_diff_2, test_meter_out.open_3, test_meter_out.open_diff_3, test_meter_out.check_3, test_meter_out.check_diff_3, test_meter_out.qmin_3, test_meter_out.qmin_diff_3 FROM prover.test_meter_out, prover.test_profiles WHERE test_meter_out.test_profile_id = test_profiles.test_profile_id and test_meter_out.test_profile_id = '" . $profile . "' ORDER BY test_meter_out.test_meter_out_id";
		
		$result = mysqli_query($connection, $query);

		if( mysqli_num_rows( $result) > 0)
		{
					for( $y = 0; $row = mysqli_fetch_assoc( $result); $y++)
					{
						$meter_data[$y]['prover_num'] = $row['prover_num'];
						$meter_data[$y]['test_meter_num'] = $row['test_meter_num'];
						$meter_data[$y]['profile_name'] = $row['profile_name'];
						$meter_data[$y]['test_type'] = $row['test_type'];
						$meter_data[$y]['pass_fail_open'] = $row['pass_fail_open'];
						$meter_data[$y]['pass_fail_check'] = $row['pass_fail_check'];
						$meter_data[$y]['pass_fail_qmin'] = $row['pass_fail_qmin'];
						$meter_data[$y]['test_block'] = $row['test_block'];
						$meter_data[$y]['temp_cont'] = $row['temp_cont'];
						$meter_data[$y]['test_date'] = $row['test_date'];
						$meter_data[$y]['test_time'] = $row['test_time'];
						$meter_data[$y]['open_1'] = $row['open_1'];
						$meter_data[$y]['open_diff_1'] = $row['open_diff_1'];
						$meter_data[$y]['check_1'] = $row['check_1'];
						$meter_data[$y]['check_diff_1'] = $row['check_diff_1'];
						$meter_data[$y]['qmin_1'] = $row['qmin_1'];
						$meter_data[$y]['qmin_diff_1'] = $row['qmin_diff_1'];
						$meter_data[$y]['open_2'] = $row['open_2'];
						$meter_data[$y]['open_diff_2'] = $row['open_diff_2'];
						$meter_data[$y]['check_2'] = $row['check_2'];
						$meter_data[$y]['check_diff_2'] = $row['check_diff_2'];
						$meter_data[$y]['qmin_2'] = $row['qmin_2'];
						$meter_data[$y]['qmin_diff_2'] = $row['qmin_diff_2'];
						$meter_data[$y]['open_3'] = $row['open_3'];
						$meter_data[$y]['open_diff_3'] = $row['open_diff_3'];
						$meter_data[$y]['check_3'] = $row['check_3'];
						$meter_data[$y]['check_diff_3'] = $row['check_diff_3'];
						$meter_data[$y]['qmin_3'] = $row['qmin_3'];
						$meter_data[$y]['qmin_diff_3'] = $row['qmin_diff_3'];
					}

					$total_meter_data = count( $meter_data);

					$no_data = 0;

					for( $y = 0; $y < $total_meter_data; $y++)
					{
						fputs( $fpA, $meter_data[$y]['prover_num'] . ", " . $meter_data[$y]['test_meter_num'] . ", " . $meter_data[$y]['profile_name'] . ", " . $meter_data[$y]['test_type'] . ", " .$meter_data[$y]['pass_fail_open'] . ", " .$meter_data[$y]['pass_fail_check'] . ", " .$meter_data[$y]['pass_fail_qmin'] . ", " . $meter_data[$y]['test_block'] . ", " . $meter_data[$y]['temp_cont'] . ", " . $meter_data[$y]['test_date'] . ", " . $meter_data[$y]['test_time'] . ", " . $meter_data[$y]['open_1'] . ", " . $meter_data[$y]['open_diff_1'] . ", " . $meter_data[$y]['check_1'] . ", " . $meter_data[$y]['check_diff_1'] . ", " . $meter_data[$y]['qmin_1'] . ", " . $meter_data[$y]['qmin_diff_1'] . ", " .$meter_data[$y]['open_2'] . ", " .$meter_data[$y]['open_diff_2'] . ", " .$meter_data[$y]['check_2'] . ", " . $meter_data[$y]['check_diff_2'] . ", " . $meter_data[$y]['qmin_2'] . ", " . $meter_data[$y]['qmin_diff_2'] . ", " . $meter_data[$y]['open_3'] . ", " . $meter_data[$y]['open_diff_3'] . ", " . $meter_data[$y]['check_3'] . ", " . $meter_data[$y]['check_diff_3'] . ", " . $meter_data[$y]['qmin_3'] . ", " . $meter_data[$y]['qmin_diff_3'] . "\n");
					}
				}//if

		fclose( $fpA);
			
 			if( mysqli_num_rows( $result) < 1)
			{
				mysqli_close( $connection);
				?>
					<html>
					<head>
						<title>Test Meter Lookup</title>

						<script language="javascript" type="text/javascript">
							function error()
							{
								alert("No Data Found For Your Result.\nPlease try again.");
								window.location = 'testmeterlookup.php';
							}
						</script>
					</head>
					<body onload="javascript:error();"></body>
					</html>
				<?php
							
				exit();
			}

		mysqli_close( $connection);
	}
	else if( $method == 2 && !isset( $filename_A))//Date Range *****************************************************************
	{
		include( "dev_db.php");
		$connection = mysqli_connect( $server, $user, $pass, "prover");

		$filename_A = 'MeterData_' . date( "His") . '.tmp';

		$fpA = fopen( $filename_A, 'w');

		fputs( $fpA, "Prover Number, Test Meter Number, Test Profile ID, Test Type, Open Pass/Fail, Check Pass/Fail, Qmin Pass/Fail, Test Block, Temp Cont, Test Date, Test Time, Open 1, Open Diff. 1, Check 1, Check Diff. 1, Qmin 1, Qmin Diff. 1, Open 2, Open Diff. 2, Check 2, Check Diff. 2, Qmin 2, Qmin Diff. 2, Open 3, Open Diff. 3, Check 3, Check Diff. 3, Qmin 3, Qmin Diff. 3\n");

		//$no_data = 1;

		$query = "SELECT test_meter_out.prover_num, test_meter_out.test_meter_num, test_profiles.profile_name, test_meter_out.test_type, test_meter_out.pass_fail_open, test_meter_out.pass_fail_check, test_meter_out.pass_fail_qmin, test_meter_out.test_block, test_meter_out.temp_cont, test_meter_out.test_date, test_meter_out.test_time, test_meter_out.open_1, test_meter_out.open_diff_1, test_meter_out.check_1, test_meter_out.check_diff_1, test_meter_out.qmin_1, test_meter_out.qmin_diff_1, test_meter_out.open_2, test_meter_out.open_diff_2, test_meter_out.check_2, test_meter_out.check_diff_2, test_meter_out.qmin_2, test_meter_out.qmin_diff_2, test_meter_out.open_3, test_meter_out.open_diff_3, test_meter_out.check_3, test_meter_out.check_diff_3, test_meter_out.qmin_3, test_meter_out.qmin_diff_3 FROM prover.test_meter_out, prover.test_profiles WHERE test_meter_out.test_profile_id = test_profiles.test_profile_id and test_meter_out.test_date >= '" . $start_year . "-" . $start_month . "-" . $start_day . "' AND test_meter_out.test_date <= '" . $end_year . "-" . $end_month . "-" . $end_day . "' ORDER BY test_meter_out.test_meter_out_id";
		
		$result = mysqli_query($connection, $query);

				if( mysqli_num_rows( $result) > 0)
				{
					for( $y = 0; $row = mysqli_fetch_assoc( $result); $y++)
					{
						$meter_data[$y]['prover_num'] = $row['prover_num'];
						$meter_data[$y]['test_meter_num'] = $row['test_meter_num'];
						$meter_data[$y]['profile_name'] = $row['profile_name'];
						$meter_data[$y]['test_type'] = $row['test_type'];
						$meter_data[$y]['pass_fail_open'] = $row['pass_fail_open'];
						$meter_data[$y]['pass_fail_check'] = $row['pass_fail_check'];
						$meter_data[$y]['pass_fail_qmin'] = $row['pass_fail_qmin'];
						$meter_data[$y]['test_block'] = $row['test_block'];
						$meter_data[$y]['temp_cont'] = $row['temp_cont'];
						$meter_data[$y]['test_date'] = $row['test_date'];
						$meter_data[$y]['test_time'] = $row['test_time'];
						$meter_data[$y]['open_1'] = $row['open_1'];
						$meter_data[$y]['open_diff_1'] = $row['open_diff_1'];
						$meter_data[$y]['check_1'] = $row['check_1'];
						$meter_data[$y]['check_diff_1'] = $row['check_diff_1'];
						$meter_data[$y]['qmin_1'] = $row['qmin_1'];
						$meter_data[$y]['qmin_diff_1'] = $row['qmin_diff_1'];
						$meter_data[$y]['open_2'] = $row['open_2'];
						$meter_data[$y]['open_diff_2'] = $row['open_diff_2'];
						$meter_data[$y]['check_2'] = $row['check_2'];
						$meter_data[$y]['check_diff_2'] = $row['check_diff_2'];
						$meter_data[$y]['qmin_2'] = $row['qmin_2'];
						$meter_data[$y]['qmin_diff_2'] = $row['qmin_diff_2'];
						$meter_data[$y]['open_3'] = $row['open_3'];
						$meter_data[$y]['open_diff_3'] = $row['open_diff_3'];
						$meter_data[$y]['check_3'] = $row['check_3'];
						$meter_data[$y]['check_diff_3'] = $row['check_diff_3'];
						$meter_data[$y]['qmin_3'] = $row['qmin_3'];
						$meter_data[$y]['qmin_diff_3'] = $row['qmin_diff_3'];
					}

					$total_meter_data = count( $meter_data);

					$no_data = 0;

					for( $y = 0; $y < $total_meter_data; $y++)
					{
						fputs( $fpA, $meter_data[$y]['prover_num'] . ", " . $meter_data[$y]['test_meter_num'] . ", " . $meter_data[$y]['profile_name'] . ", " . $meter_data[$y]['test_type'] . ", " .$meter_data[$y]['pass_fail_open'] . ", " .$meter_data[$y]['pass_fail_check'] . ", " .$meter_data[$y]['pass_fail_qmin'] . ", " . $meter_data[$y]['test_block'] . ", " . $meter_data[$y]['temp_cont'] . ", " . $meter_data[$y]['test_date'] . ", " . $meter_data[$y]['test_time'] . ", " . $meter_data[$y]['open_1'] . ", " . $meter_data[$y]['open_diff_1'] . ", " . $meter_data[$y]['check_1'] . ", " . $meter_data[$y]['check_diff_1'] . ", " . $meter_data[$y]['qmin_1'] . ", " . $meter_data[$y]['qmin_diff_1'] . ", " .$meter_data[$y]['open_2'] . ", " .$meter_data[$y]['open_diff_2'] . ", " .$meter_data[$y]['check_2'] . ", " . $meter_data[$y]['check_diff_2'] . ", " . $meter_data[$y]['qmin_2'] . ", " . $meter_data[$y]['qmin_diff_2'] . ", " . $meter_data[$y]['open_3'] . ", " . $meter_data[$y]['open_diff_3'] . ", " . $meter_data[$y]['check_3'] . ", " . $meter_data[$y]['check_diff_3'] . ", " . $meter_data[$y]['qmin_3'] . ", " . $meter_data[$y]['qmin_diff_3'] . "\n");
					}
				}//if

		fclose( $fpA);
			
			if( mysqli_num_rows( $result) < 1)
			{
				mysqli_close( $connection);
				?>
					<html>
					<head>
						<title>Test Meter Lookup</title>

						<script language="javascript" type="text/javascript">
							function error()
							{
								alert("No Data Found For Your Result.\nPlease try again.");
								window.location = 'testmeterlookup.php';
							}
						</script>
					</head>
					<body onload="javascript:error();"></body>
					</html>
				<?php
							
				exit();
			}

		mysqli_close( $connection);
	}

	if( !isset( $address))
	{
		?>
			<html>
			<head>
				<title>Test Meter Data Lookup</title>

				<script language="javascript" type="text/javascript">
					function check_form_one()
					{
						if( document.get_email.address.value == "")
						{
							alert("Email Address is a required field.");
							document.get_email.address.focus();
							return;
						}
						document.get_email.submit();
					}
				</script>
			</head>
			<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="javascript:document.get_email.address.focus();">
				<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
					<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
				</table>
				<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td height="20" width="5"   background="images/all_strip.jpg"   ></td>
						<td height="20" width="637" background="images/all_strip.jpg"   ></td>
					</tr>
				</table>
				<br><br><br>
				<form name="get_email" action="testmeterlookup.php" method="post">
					<table width="100%" border="0" cellpadding="0" cellspacing="0">
						<tr>
							<td align="center">
								<table border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
									<tr>
										<td align="center" valign="center">
											<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
												<tr>
													<td valign="center"><b>Email&nbsp;Address:&nbsp;</b></td>
													<td align="center"><input type="text" tabindex="1" name="address" size="20"><b>@itron.com</b></td>
												</tr>
												<tr><td><b>Example:&nbsp;joe.smith@itron.com</td></tr>
												<tr><td colspan="2"><br></td></tr>
												<tr>
													<td align="center" valign="center" colspan="2"><img height="20" width="128" border="0" src="images/btn_all_sbm.jpg" name="btn_sbm" onmouseover="javascript:document.btn_sbm.src = 'images/btn_all_sbm_ovr.jpg';" onmouseout="javascript:document.btn_sbm.src = 'images/btn_all_sbm.jpg';" onclick="javascript:check_form_one();"></td>
												</tr>
											</table>
										</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
					<input type="hidden" name="ive_waited"  value="1">
					<input type="hidden" name="method"      value="<?php echo $method;     ?>">
					<input type="hidden" name="filename_A"  value="<?php echo $filename_A; ?>">
					<input type="hidden" name="no_data"     value="<?php echo $no_data;    ?>">
				</form>
			</body>
			</html>
		<?php
		exit();
	}
	else
	{
		$address .= "@itron.com";

		$email_txt = "";

		if( $no_data == 1)
		{
			$email_txt = "No Data Retrieved From Database.";
		}

		$semi_rand = md5(time());

		$headers  = "From: no-reply@itron.com";
		$headers .= "\nMIME-Version: 1.0\n";
		$headers .= "Content-Type: multipart/mixed;\n";
		$headers .= " boundary=\"==Multipart_Boundary_x" . $semi_rand . "x\"";

		$email_message  = "This is a multi-part message in MIME format.\n\n";
		$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x\n";
		$email_message .= "Content-Type:text/html; charset=\"iso-8859-1\"\n";
		$email_message .= "Content-Transfer-Encoding: 7bit\n\n" . $email_txt . "\n\n";

		if( $no_data == 1)
		{
			$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x--\n";
		}
		else
		{
			$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x\n";
		}

		if( $no_data == 0)
		{
			$fp = fopen( $filename_A, 'rb');

			$data = fread( $fp, filesize( $filename_A));

			fclose( $fp);

			$data = chunk_split( base64_encode( $data));

			$email_message .= "Content-Type: application/octet-stream;\n";
			$email_message .= " name=\"TestMeterData.csv\"\n";
			$email_message .= "Content-Transfer-Encoding: base64\n\n" . $data . "\n\n";
			$email_message .= "--==Multipart_Boundary_x" . $semi_rand . "x--\n";

		}

		mail( $address, "Meter Data", $email_message, $headers);

		unlink( $filename_A);

		?>
			<html>
			<head>
				<title>Test Meter Data Lookup</title>
			</head>
			<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
				<table width="1004" height="63" border="0" cellpadding="0" cellspacing="0">
					<tr><td align="center"><font size="25">Test Meter Data Lookup</font></td></tr>
				</table>
				<table width="1004" height="20" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td height="20" width="5"   background="images/all_strip.jpg"   ></td>
						<td height="20" width="637" background="images/all_strip.jpg"   ></td>
					</tr>
				</table>
				<br><br><br>
				<table width="100%" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td align="center">
							<table border="0" cellpadding="1" cellspacing="0" background="images/all_border.jpg">
								<tr>
									<td align="center" valign="center">
										<table height="100%" width="100%" border="0" cellpadding="4" cellspacing="0" background="images/all_orange.jpg">
											<tr>
												<td align="center" valign="center"><br><b>Meter&nbsp;Data&nbsp;has&nbsp;been&nbsp;emailed&nbsp;to:&nbsp;<?php echo $address; ?></b><br><br></td>
											</tr>
											<tr>
												<td align="center"><img height="20" width="128" border="0" src="images/btn_prf_cnt.jpg" name="btn_cnt" onmouseover="javascript:document.btn_cnt.src = 'images/btn_prf_cnt_ovr.jpg';" onmouseout="javascript:document.btn_cnt.src = 'images/btn_prf_cnt.jpg';" onclick="javascript:window.location = 'testmeterlookup.php';"></td>
											</tr>
										</table>
									</td>
								</tr>
							</table>
						</td>
					</tr>
				</table>
			</body>
			</html>
		<?php
	}
?>
Last edited by califdon on Thu Mar 15, 2012 6:39 pm, edited 1 time in total.
Reason: Moderator added syntax=php tags to make code readable. Note to poster, please always do this.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: using option value result in a select

Post by califdon »

Now I'm really confused. This code doesn't look anything at all like the partial code you posted earlier. Where is your problem?? Is it in this section?

Code: Select all

$query = "SELECT test_profile_id, profile_name FROM test_profiles ORDER BY profile_name";
$result = mysqli_query($connection, $query);
for( $x = 0; $row = mysqli_fetch_assoc( $result); $x++)
{
?>
<option value="<?php $row['test_profile_id']; ?>"><?php echo $row['profile_name']; ?></option>
<?php
}
I can't tell what you are trying to do with that for loop. I think you mean:

Code: Select all

$query = "SELECT test_profile_id, profile_name FROM test_profiles ORDER BY profile_name";
$result = mysqli_query($connection, $query);
while($row=mysqli_fetch_assoc($result))
{
   echo "<option value=".$row['test_profile_id'].">".$row['profile_name']."</option>";
}
kford11
Forum Newbie
Posts: 5
Joined: Thu Mar 15, 2012 12:15 pm

Re: using option value result in a select

Post by kford11 »

My option value is pulling and displaying everything correctly. my problem is when i make the selection the result is not being passed to my query later in my code. So when i execute the result is empty. if you search code for $profile you will see the later select statement. That being said, do you think using a for statement instead of a while statement could be causing my result from my option value not working correctly.

thanks
kford11
Forum Newbie
Posts: 5
Joined: Thu Mar 15, 2012 12:15 pm

Re: using option value result in a select

Post by kford11 »

issue has been resolved. By changing my FOR statement into a WHILE statement has resolved my issue. Thanks you very much for your help.
Post Reply