Search the Community
Showing results for tags 'passing value'.
Found 1 result
-
Hi Professionals I have the following 2 pages, in the welcome.php I am trying to retreive the TowerSelect drop downs value to echo in the page but it is only showing TowerSelect not the actual value. Where could I be going wrong thanks <html> </body> <form action="welcome.php" method="POST"> Please select the manufacturer you wish to report on. </br></br> <select name="TowerSelect"><option> Choose </option> <?php $server='d3licsql02'; $connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "SECRET"); //connect to DB $conn=sqlsrv_connect($server,$connectinfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true)); } $sql = "SELECT distinct software_manufacturer FROM softusecomp"; $sql1 = "SELECT distinct software_manufacturer, product,product_version,path FROM softusecomp"; $stmt = sqlsrv_query( $conn, $sql); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) ); } while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) { echo "<option value="; echo "'".$row['software_manufacturer']."'"; echo ">"; echo $row['software_manufacturer']; echo "</option>"; } sqlsrv_free_stmt( $stmt); ?> </select> <input type="submit" value="Search"> </br></br> </form> </body></html> -------------------------------------------------------------------------------------------- <html> </body> <form action="filter.php" method="POST"> Report for -Insert manufacturer name here-. </br></br> TowerSelect <?php $server='d3licsql02'; $connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "SECRET"); //connect to DB $conn=sqlsrv_connect($server,$connectinfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true)); } $manufacturer_name = $_GET['TowerSelect']; echo $manufacturer_name; $sql = "SELECT top 100 software_manufacturer, product,product_version,path FROM softusecomp where software_manufacturer = 'Microsoft Corporation'"; $stmt = sqlsrv_query( $conn, $sql); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) ); } while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) { echo $row['software_manufacturer'].", ".$row['product'].", ".$row['product_version'].", ".$row['path']."<br />"; } sqlsrv_free_stmt( $stmt); ?> <input type="submit" value="filter"> </br></br> </form> </body></html>
