タグ別アーカイブ: db

get_meigen

投稿日時: 投稿者:
返信 
//
// get_meigen by KMF (2015.Sep.02)
//
function get_meigen() {
  $srv = 'xxx.xxx.xxx';
  $id  = 'xxx';
  $pwd = 'xxx';
  $dbn = 'xxx';
  $link = mysqli_connect($srv, $id, $pwd, $dbn);
  mysqli_set_charset($link, 'utf8') or die('Charset failed');
  if (mysqli_connect_errno()) {
    die('Connect failed: ' . mysqli_connect_error());
  }
  $sql = 'SELECT `meigen`,`namae` FROM `meigen2` ORDER BY RAND() LIMIT 1';
  $rs = mysqli_query($link, $sql) or die('Query failed [' $sql . ']';
  $ret = mysqli_fetch_array($rs, MYSQLI_ASSOC);
  mysqli_free_result($rs);
  mysqli_close($db);
  return $ret_list;
}

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