Hey all,
Trying to get variables from my HTML form into my URL using PHP. In which case the action page will use the variables from the URL to perform a query into mysql database. Any idea why the TERMVAL variable isn't getting posted into my URL?
I'm banging my head on this one and I just can't seem to get it.
Thanks!
Search Page
View Page
You can probably tell I steal alot from w3schools 
For some reason the TERM variable from the view page loads fine but not the TERMVAL.
Ideas? Suggestions? Constructive Criticism? Thanks a bunch!
The echo's are for my own diagnostics, when I submit a search heres what I get...
Trying to get variables from my HTML form into my URL using PHP. In which case the action page will use the variables from the URL to perform a query into mysql database. Any idea why the TERMVAL variable isn't getting posted into my URL?
I'm banging my head on this one and I just can't seem to get it.
Thanks!
Search Page
Code:
<?php
if(isset($_POST['SUB1']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB2']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB3']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB4']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB5']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB6']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB7']))
$TERMVAL = $_POST["TERMVAL"];
if(isset($_POST['SUB8']))
$TERMVAL = $_POST["TERMVAL"];
$url1 = "view.php?TERMVAL=";
$url2 = $TERMVAL;
$urlfin = $url1 . $url2;
?>
<form method="post" action="<?php echo $urlfin . "&TERM=DATE"?>">
All records by date:
<input type="text" size="8" maxlength="8" name="TERMVAL">
<input type="Submit" value="Submit" name="SUB1">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=OFFICER"?>">
All records by badge number:
<select name="TERMVAL">
<option value="--">--</option>
<option value="101">101</option>
<option value="102">102</option>
<option value="103">103</option>
<option value="104">104</option>
<option value="105">105</option>
<option value="108">108</option>
<option value="109">109</option>
<option value="135">135</option>
<option value="136">136</option>
<option value="138">138</option>
<option value="150">150</option>
<option value="155">155</option>
<option value="160">160</option>
<option value="161">161</option>
<option value="162">162</option>
<option value="163">163</option>
<option value="164">164</option>
<option value="167">167</option>
<option value="169">169</option>
<option value="171">171</option>
<option value="172">172</option>
<option value="174">174</option>
<option value="176">176</option>
<option value="177">177</option>
<option value="178">178</option>
<option value="179">179</option>
</select>
<input type="Submit" value="Submit" name="SUB2">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=SQUAD"?>">
All records by squad:
<select name="TERMVAL">
<option value="11">11</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="27">27</option>
<option value="28">28</option>
</select>
<input type="Submit" value="Submit" name="SUB3">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=SGT"?>">
All records by SGT:
<select name="TERMVAL">
<option value="104">104</option>
<option value="105">105</option>
<option value="108">108</option>
<option value="109">109</option>
</select>
<input type="Submit" value="Submit" name="SUB4">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=LT"?>">
All records by LT:
<select name="TERMVAL">
<option value="102">102</option>
<option value="103">103</option>
</select>
<input type="Submit" value="Submit" name="SUB5">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=SIT"?>">
All records by SI type: (not implemented)
<input type="text" size="5" maxlength="4" name="TERMVAL">
<input type="Submit" value="Submit" name="SUB6">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=CN"?>">
All records by case number: (not implemented)
<input type="text" size="5" maxlength="4" name="TERMVAL">
<input type="Submit" value="Submit" name="SUB7">
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
</form>
<form method="post" action="<?php echo $urlfin . "&TERM=SHIFT"?>">
All records by shift:
<select name="TERMVAL">
<option value="D">D</option>
<option value="EP">EP</option>
<option value="A">A</option>
<option value="LP">LP</option>
<option value="M">M</option>
</select>
<input type="Submit" value="Submit" name="SUB8">
<br />
</form>
Code:
<?php
$TERM = $_GET["TERM"];
$TERMVAL = $_GET["TERMVAL"];
$con = mysql_connect("localhost:3307","root","SUPERSECRETPASSWORD");
mysql_select_db("COMOARS", $con);
$res1 = "mysql_query(";
$res2 = '"SELECT * FROM ';
$res3 = $TERM . '")';
$result = $res1 . $res2 . $res3;
echo "<table border='1'>
<tr>
<th>Value1</th>
<th>Value2</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Value'] . "</td>";
echo "<td>" . $row['Value'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
<br />
<center><IMG SRC="blackbar600x12.jpg"></center>
<br />
DIAGNOSTICS:
<?php
echo "<br />";
echo $TERMVAL;
echo "<br />";
echo $TERM;
echo "<br />";
echo $con;
echo "<br />";
echo $res1;
echo "<br />";
echo $res2;
echo "<br />";
echo $res3;
echo "<br />";
echo $result;
echo "<br />";
echo $url1;
echo "<br />";
echo $url2;
echo "<br />";
echo $urlfin;
echo "<br />";
?>
For some reason the TERM variable from the view page loads fine but not the TERMVAL.
Ideas? Suggestions? Constructive Criticism? Thanks a bunch!
The echo's are for my own diagnostics, when I submit a search heres what I get...
Code:
DIAGNOSTICS:
<-----THIS IS WHERE THE TERMVAL SHOULD BE ----->
LT
Resource id #2
mysql_query(
"SELECT * FROM
LT")
mysql_query("SELECT * FROM LT")