GetList

//=============================================================================================
// 
//=============================================================================================
function GetList($grp = '') {
    $srv = 'xxx.xxx.xxx';
    $id  = 'xxx';
    $pwd = 'xxx';
    $dbn = 'xxx';
    $link = mysqli_connect($srv, $id, $pwd, $dbn);
    if (mysqli_connect_errno()) {
        die('Connect failed: ' . mysqli_connect_error());
    }
    if ($grp == '') {
        $sql = 'SELECT `id`,`name`,`exp` FROM `Links` ORDER BY `cnt` DESC';
    } else {
        $sql = 'SELECT `id`,`name`,`exp` FROM `Links` WHERE `grp` = "' . $grp . '" ORDER BY `cnt` DESC';
    }
    if ($rs = mysqli_query($link, $sql)) {
        $ret_list = array();
        while ($row = mysqli_fetch_array($rs, MYSQLI_ASSOC)) {
      	    $ret_list[] = array('id'=>$row['id'], 'name'=>$row['name'], 'exp'=>$row['exp']);
        }
     	mysqli_free_result($rs);
    }
    mysqli_close($db);
    return $ret_list;
}

コメントを残す

メールアドレスが公開されることはありません。