alanl1 Posted May 3, 2013 Share Posted May 3, 2013 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> Link to comment https://forums.phpfreaks.com/topic/277568-passing-and-retriving-a-dropdown-box-value-to-another-page/ Share on other sites More sharing options...
DaveyK Posted May 3, 2013 Share Posted May 3, 2013 Please put your code in code blocks (identified by the "<>" icon on the top) and seperate them by file. Also, please only show relevant code. Looking at your code real quickly I noticed there is a difference in methods. Both <forms> have method="POST" but you are using $_GET['towerSelect']. might I suggest that you perform most of your PHP (including ESPECIALLY queries) above the HTML. This code is really hard to read. Also, is error reporting turned on? Link to comment https://forums.phpfreaks.com/topic/277568-passing-and-retriving-a-dropdown-box-value-to-another-page/#findComment-1427889 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.