set_charset("utf8"); if (!$link) { echo "Error: Unable to connect to MySQL." . PHP_EOL; echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL; echo "Debugging error: " . mysqli_connect_error() . PHP_EOL; exit; } ?> query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } function is_existing_user($data){ $codequery = "select count(id) cnt from xx_hr_national_day_draw where mbl = '$data'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id = $row['cnt']; } return $id; } function get_draw_users($data){ $codequery = "select * from xx_hr_national_day_draw where is_win = 'N' #and nationality = 'Saudi Arabia' #and city is not null and city COLLATE UTF8_GENERAL_CI LIKE '%Makkah%' and natid like '1%'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id[] = $row; } foreach($id as $idv) { $drawusn[] = $idv['name']."|".$idv['mbl']; } //$drawusn[] = '123'; //$arr = array('Hello','World!','Beautiful','Day!'); return '"'.implode('","',$drawusn).'"'; //return $id; } function add_winner($name,$empid,$mobile){ $codequery = "insert into xx_winners (name, emp_id, mobile, winning_date ) value ('$name', '$empid', '$mobile', now() )"; //echo $codequery; if ($GLOBALS["link"]->query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } function remove_winner_from_draw($data){ $codequery = "update xx_hr_national_day_draw set is_win = 'Y', prize_date = now() where mbl = '$data' "; //echo $codequery; if ($GLOBALS["link"]->query($codequery) === TRUE) { return '1'; }else{ return 'error'; } } ?>