format("Y/m/d"); $toTime =Explode(":", date('H:i:s')); $currentTime = date("H:i:s"); $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); $vPlate=$_POST['value']; $query = mysql_query("SELECT * FROM vts_vehicle_lists WHERE v_plate='".$vPlate."'"); //echo $vPlate; if(mysql_num_rows($query) > 0){ //echo "

".mysql_num_rows($query). " Record Found.

"; echo '

Vehicle Information:

'; while ($data = mysql_fetch_array($query)) { echo ''; $vStat=$data['v_in_out']; } echo ""; echo ""; echo ""; echo ""; echo ""; echo '

Plate: '.$data["v_plate"].'	Brand: '.$data["v_brand"].'	Model: '.$data["v_model"].'	Color: '.$data["v_color"].'
"; echo "Select Reason: "; echo "			Kilometer Reading:
"; echo " "; echo ""; echo ""; echo ""; echo "

'; }else{ echo "No Record Fountd."; } // IDS plate checkIn checkOut kmReading location ?>