PHP数据库操作

来源：互联网发布：win7一拖二软件编辑：程序博客网时间：2024/04/19 13:24

共两个文件：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"." ";
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"." ";
return $link;
}

test.php

<?PHP
require_once('db.php');
echo "3 day save data, dbname=$db_parkour"." ";

$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"." ";
if( !$result )
{
echo "execute query failed, sql:$sql"." ";
exit;
}
echo "execute query success, sql:$sql"." ";

/*
$row = $result->fetch_row();
$count = $row[0];
echo "single row info, login count $count"." ";
*/

for($i = 0; $i<$num; $i++)
{
$this_row = $result->fetch_row();
$innercount = $this_row[0];
echo "login count $innercount"." ";
}

$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"." ";
}

/*
mysql_free_result($result);
mysql_close($link);
*/
?>

0 0