$val) { // read get request from web $ID = $val; } $servername = "localhost"; //connect db $username = "acc"; $password = "123"; $dbname = "acc"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM `device` WHERE `ID` = '$ID'"; // echo ($sql); if(!mysqli_query($conn, $sql)) { die('Error : ' . mysqli_error($conn)); } $result = $conn->query($sql); if ($result->num_rows > 0) { // output db while($row = $result->fetch_assoc()) { $TAG = $row["ID"]; $TIME = $row["有效期"]; $NAME = $row["设备名称"]; $SN = $row["型号"]; $Factory= $row["生产厂家"]; $N1= $row["备注"]; echo""; echo"

"; echo"

"; print ("Wellcome to QR Service"); echo"

"; echo"
"; echo"

"; echo"

"; print ("ID：".$ID); echo"
"; print ("设备名称：".$NAME); echo"
"; print ("型号：".$SN); echo"
"; print ("生产厂家：".$Factory); echo"
"; if($TIME != NULL){ print ("有效期：".$TIME); }else{ print ("Date：Unknow"); } echo"
"; print ("备注：".$N1); echo"
"; if($NOTE != NULL){ echo"
"; print ("INFO："); echo"

"; print ($NOTE); echo"

"; }else{ } if($N2 != NULL){ echo"
"; echo"

"; print ($N2); echo"

"; }else{ } echo"

"; echo"

"; echo"

"; echo""; } } else { echo "Not Found"; } $conn->close(); ?>