<?php
$vp=$_GET['vp'];
$vp2=$_GET['vp2'];
$conn = mysqli_connect("localhost","admin","admin","graami"); // Check connection
mysql_connect("localhost","admin","admin");
mysql_select_db("graami");
$result = mysqli_query($conn,"SELECT * FROM gipam_control where vplant_code = '$vp'");
while($row = mysqli_fetch_array($result)){
$cb1_on_sel = $row['cb1_on_sel'];
$cb1_on_op = $row['cb1_on_op'];
}
$result1 = mysqli_query($conn,"SELECT * FROM gipam_control where vplant_code = '$vp2'");
while($row = mysqli_fetch_array($result1)){
$cb1_on_sel1 = $row['cb1_on_sel'];
$cb1_on_op1 = $row['cb1_on_op'];
}
if($cb1_on_sel == 1) {
mysqli_query($conn, "UPDATE gipam_control set cb1_on_op='1' WHERE vplant_code='$vp'");
}
if($cb1_on_sel1 == 1) {
mysqli_query($conn, "UPDATE gipam_control set cb1_on_op='1' WHERE vplant_code='$vp2'");
}
////////////////////////////////////////////////10초뒤 리셋///////////////////////////////////////
if($cb1_on_sel == 1 && $cb1_on_op ==1) {
*타이머를 넣고싶은 부분
mysqli_query($conn, "UPDATE gipam_control set cb1_on_op='0', cb1_on_sel='0' WHERE vplant_code='$vp'");
}
if($cb1_on_sel1 == 1 && $cb1_on_op1 ==1) {
*타이머를 넣고싶은 부분
mysqli_query($conn, "UPDATE gipam_control set cb1_on_op='0', cb1_on_sel='0' WHERE vplant_code='$vp2'");
}
?>
안드로이드에서 버튼을 클릭했을때 php로 넘어가서 쿼리문 실행이 되는데
*타이머를 넣고싶은 부분에 10초를 주어서 DB쿼리가 실행되게 하려면 어떤방법으로 해야하나여?