Beispiel #1
0
 function showdemo()
 {
     $checknumber = array('id' => null);
     $con = mysql_connect(SAE_MYSQL_HOST_M . ':' . SAE_MYSQL_PORT, SAE_MYSQL_USER, SAE_MYSQL_PASS);
     if (!$con) {
         die('Could not connect:' . mysql_error());
     }
     mysql_query("set names utf8");
     mysql_select_db(SAE_MYSQL_DB, $con);
     $getusr = new demo();
     $username = $getusr->searchusername();
     $sql = "select * from demo order by id desc limit 10";
     $res = mysql_query($sql, $con);
     $result = array();
     $num = mysql_num_rows($res);
     if ($num) {
         while ($row = mysql_fetch_array($res)) {
             array_push($result, $row['filetitle'] . '------' . $row['username'] . '---' . $row[time]);
         }
         mysql_close($con);
         return $result;
     }
     mysql_close($con);
     return false;
 }