function voteRESULT($length) { $con = mysqli_connect("localhost", "u242089643_jucy", "gksdid1!"); if (!$con) { die('연결 안됨: ' . mysqli_error()); } else { mysqli_select_db($con, "u242089643_tdc"); } $resultset = mysqli_query($con, "select * from diet_war where vote_count != 0 order by vote_count desc limit " . $length); if (MYSQLI_NUM_rows($resultset) < 1) { mysqli_close($con); return array(array("empty")); } else { $result = array(); $row = array(); while ($row = mysqli_fetch_array($resultset, MYSQLI_NUM)) { array_push($result, $row); } mysqli_close($con); return $result; } }
function dietwar_status() { $con = mysqli_connect("202.150.213.206", "u242089643_jucy", "gksdid1!"); if (!$con) { die('연결 안됨: ' . mysqli_error()); } else { mysqli_select_db($con, "u242089643_tdc"); } $resultset = mysqli_query($con, "select vote from user_info where id = 'admin'"); if (MYSQLI_NUM_rows($resultset) < 1) { mysqli_close($con); return array(array("empty")); } else { $result = array(); $row = array(); while ($row = mysqli_fetch_array($resultset, MYSQLI_NUM)) { array_push($result, $row); } mysqli_close($con); return $result; } }