//=============================================================================================
//
//=============================================================================================
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;
}