Demo6.php
<?php
header ( 'Content-Type:text/html; charset=utf-8;' );
$_mysqli = new mysqli('localhost','root','123456','testguest');
//数据库连接时发生的错误
if (mysqli_connect_errno()) {
echo '数据库连接出现了错误.错误的信息是：'.mysqli_connect_error();
exit();
}
//设置一下编码
$_mysqli->set_charset('utf8');
//创建一句SQL,获取数据库的表的数据
$_sql = "SELECT * FROM tg_user";
//创建一个结果集
$_result = $_mysqli->query($_sql);
//使用索引数组取值
//print_r($_result->fetch_row());
$_row = $_result->fetch_row();
echo $_row[3];
//遍历,下标很难记[3]
while (!!$_row = $_result->fetch_row()) {
echo $_row[3].'<br />';
}
$_mysqli->close();
?>
Demo7.php
<?php
header ( 'Content-Type:text/html; charset=utf-8;' );
$_mysqli = new mysqli('localhost','root','123456','testguest');
//数据库连接时发生的错误
if (mysqli_connect_errno()) {
echo '数据库连接出现了错误.错误的信息是：'.mysqli_connect_error();
exit();
}
//设置一下编码
$_mysqli->set_charset('utf8');
//创建一句SQL,获取数据库的表的数据
$_sql = "SELECT * FROM tg_user";
//创建一个结果集
$_result = $_mysqli->query($_sql);
//使用关联数组取值
//print_r($_result->fetch_assoc());
$_assoc = $_result->fetch_assoc();
echo $_assoc['tg_username'];
//遍历
while (!!$_assoc = $_result->fetch_assoc()) {
echo $_assoc['tg_username'].'<br />';
}
$_mysqli->close();
?>
Demo8.php
<?php
header ( 'Content-Type:text/html; charset=utf-8;' );
$_mysqli = new mysqli('localhost','root','123456','testguest');
//数据库连接时发生的错误
if (mysqli_connect_errno()) {
echo '数据库连接出现了错误.错误的信息是：'.mysqli_connect_error();
exit();
}
//设置一下编码
$_mysqli->set_charset('utf8');
//创建一句SQL,获取数据库的表的数据
$_sql = "SELECT * FROM tg_user";
//创建一个结果集
$_result = $_mysqli->query($_sql);
//使用索引+关联数组取值
//print_r($_result->fetch_array());
$_array = $_result->fetch_array();
echo $_array[3];
echo $_array['tg_username'];
//遍历.....
$_mysqli->close();
?>
Demo9.php
<?php
header ( 'Content-Type:text/html; charset=utf-8;' );
$_mysqli = new mysqli('localhost','root','123456','testguest');
//数据库连接时发生的错误
if (mysqli_connect_errno()) {
echo '数据库连接出现了错误.错误的信息是：'.mysqli_connect_error();
exit();
}
//设置一下编码
$_mysqli->set_charset('utf8');
//创建一句SQL,获取数据库的表的数据
$_sql = "SELECT * FROM tg_user";
//创建一个结果集
$_result = $_mysqli->query($_sql);
//使用OOP的方法object
//print_r($_result->fetch_object());
echo $_result->fetch_object()->tg_username;
//使用OOP遍历
while (!!$_object = $_result->fetch_object()) {
echo $_object->tg_username.'<br />';
}
$_mysqli->close();
?>
