<?php $sName = "***"; $conInfo = array( "Database"=>"***", "UID"=>"***", "PWD"=>"***"); $oconn = sqlsrv_connect( $sName, $conInfo); if( !$oconn ) { die( print_r( sqlsrv_errors(), true)); } if(isset($_POST['searchimput'])) { if(empty($_POST['coc_type'])){ echo 'Please Supply Policy type and search by field'; } else { $plateno = $_POST['searchimput']; $coc_type = $_POST['coc_type']; $searchBy =$_POST['filter']; echo'<span class="sr-paregister2">'; echo 'POLICY TYPE : '.$coc_type; echo "<br>\n"; switch ($searchBy) { case "PLATE_NO": echo "PLATE NUMBER : .".$plateno; break; case "SERIAL_NO": echo "CHASSIS NUMBER :".$plateno; break; case "MOTOR_NO": echo "MOTOR NUMBER :".$plateno; break; default: echo ""; } echo'</span>'; echo "<br>\n"; echo '<hr>'; $odsql =" select statement here "; $ostmt = sqlsrv_query( $oconn, $odsql); $row_count = sqlsrv_has_rows( $ostmt ); if ($row_count === false) echo "No record found"; else while( $value = sqlsrv_fetch_array( $ostmt,SQLSRV_FETCH_NUMERIC)) { (do this......) } sqlsrv_free_stmt( $ostmt); sqlsrv_close( $oconn); } } ?>
sqlsrv_close( $oconn);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)