共两个文件:db.php test.php
db.php提供数据库连接函数,test.php对PHP的数据库连接函数及相关接口进行测试,具体内容如下:
db.php
<?PHP
function db_link( $db_name )
{
echo "begin to connect db, dbname=$db_name"."<br>";
global $db_ip;
global $db_user;
global $db_password;
$link = new mysqli($db_ip, $db_user, $db_password, $db_name);
if( !$link )
{
echo "create db connection failed, ip=$db_ip";
exit;
}
echo "connect db success, ip=$db_ip, user=$db_user, password=$db_password, dbname=$db_name"."<br>";
return $link;
}
?>
test.php
<?PHP
require_once('db.php');
echo "3 day save data, dbname=$db_parkour"."<br>";
$link = db_link($db_parkour);
$sql = "select count(*) from logs_2016_02_29";
$result = $link->query($sql);
$num = $result->num_rows;
echo "result row number $num"."<br>";
if( !$result )
{
echo "execute query failed, sql:$sql"."<br>";
exit;
}
echo "execute query success, sql:$sql"."<br>";
/*
$row = $result->fetch_row();
$count = $row[0];
echo "single row info, login count $count"."<br>";
*/
for($i = 0; $i<$num; $i++)
{
$this_row = $result->fetch_row();
$innercount = $this_row[0];
echo "login count $innercount"."<br>";
}
$sql = "select id, account, name from logs_2016_02_29 limit 3";
$result = $link->query($sql);
$num = $result->num_rows;
for($i=0; $i<$num; $i++)
{
$this_row = $result->fetch_row();
$id = $this_row[0];
$account = $this_row[1];
$name = $this_row[2];
echo "login detail info, id=$id, account=$account, name=$name"."<br>";
}
/*
mysql_free_result($result);
mysql_close($link);
*/
?>