1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
<? @extract($_REQUEST); if(!isset($parm_user_mac)) $parm_user_mac = ""; #-------------- ½ÇÇà Á¤º¸ ------------------# if($parm_user_mac == ""){ //¸ÆÁÖ¼Ò°¡ ¾øÀ¸¸é ¾Æ¹«ÀÛ¾÷ ¾ÊÇÔ } else {
include("common.php"); //DBÁ¢¼Ó
$sql = "SELECT idx FROM macs WHERE mac_addr = '{$parm_user_mac}' AND app_code = '{$parm_app_code}'"; $result = mysql_query($sql); if( mysql_num_rows($result) > 0){ //°ªÀÌ ÀÖÀ¸¸é $row = mysql_fetch_array($result); $var_idx = $row['idx']; $usql = "UPDATE macs SET cnt_exec = cnt_exec + 1 WHERE idx = '{$var_idx}'"; //½ÇÇà Ä«¿îÆ® Áõ°¡ mysql_query($usql);
$isql = "INSERT INTO log_exec ( mac_idx ) values ('{$var_idx}')"; //½ÇÇà·Î±× Ãß°¡ mysql_query($isql); }
} ?>
|