function returnValue($argQuery) { $result = mysqli_query(DB_CONN(), $argQuery); //print_r($argQuery); while ($row = mysqli_fetch_array($result)) { $arrTemp[] = $row; } return $arrTemp; }
/** * Created by PhpStorm. * User: JongYoon * Date: 2015-11-16 * Time: 오후 10:21 */ function songInfo($argcode, $argStatus) { $sql = "select `곡 명`, `앨범`, `아티스트`, url, url_short, image_url from song_list where code = " . $argcode; $result = mysqli_query(DB_CONN(), $sql); if ($argStatus != "free" && $argStatus != "admin") { $duration = "url_short"; } else { $duration = "url"; } $cnt = 0; while ($row = mysqli_fetch_array($result)) { $arrTemp[$cnt] = $row; $arrTemp[$cnt]['url'] = $row[$duration]; } if ($argStatus) { $arrTemp['description'] = "{$argStatus}" . " 회원입니다"; } else { $arrTemp['description'] = "비 회원 입니다"; } echo $argStatus . "<br>" . $duration . "<br>" . $arrTemp[0]['url'] . "<br>"; return $arrTemp; }
function signOut($argID) { $query = "update member set ip_add = null where id = '" . $argID . "'"; mysqli_query(DB_CONN(), $query); session_destroy(); }
/** * Created by PhpStorm. * User: JongYoon * Date: 2015-11-04 * Time: ���� 2:29 */ function add_user($memInfo) { $query = "insert into member (id, password, nick, e_mail) values ('" . $memInfo['id'] . "','" . $memInfo['password'] . "','" . $memInfo['nick'] . "','" . $memInfo['mail'] . "')"; return mysqli_query(DB_CONN(), $query) or die("SignUP Failed"); }
function transmit_Query($argQuery) { return mysqli_query(DB_CONN(), $argQuery); }