以下为在MySQL数据库中查询数据通用的 SELECT 语法:
SELECT column_name,column_name
FROM table_name
[WHERE Clause]
[LIMIT N][ OFFSET M]
使用 mysqli_fetch_array MYSQLI_ASSOC 参数获取数据:
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT runoob_id, runoob_title,
runoob_author, submission_date
FROM runoob_tbl';
mysqli_select_db( $conn, 'RUNOOB' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '
菜鸟教程 mysqli_fetch_array 测试
';
echo '
教程 ID | 标题 | 作者 | 提交日期 |
while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))
{
echo "
{$row['runoob_id']} "."
{$row['runoob_title']} "."
{$row['runoob_author']} "."
{$row['submission_date']} "."
";}
echo '
';mysqli_close($conn);
?>
使用 mysqli_fetch_assoc 获取数据:
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT runoob_id, runoob_title,
runoob_author, submission_date
FROM runoob_tbl';
mysqli_select_db( $conn, 'RUNOOB' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '
菜鸟教程 mysqli_fetch_assoc 测试
';
echo '
教程 ID | 标题 | 作者 | 提交日期 |
while($row = mysqli_fetch_assoc($retval))
{
echo "
{$row['runoob_id']} "."
{$row['runoob_title']} "."
{$row['runoob_author']} "."
{$row['submission_date']} "."
";}
echo '
';mysqli_close($conn);
?>
使用 mysqli_fetch_array MYSQLI_NUM 参数获取数据:
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT runoob_id, runoob_title,
runoob_author, submission_date
FROM runoob_tbl';
mysqli_select_db( $conn, 'RUNOOB' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '
菜鸟教程 mysqli_fetch_array 测试
';
echo '
教程 ID | 标题 | 作者 | 提交日期 |
while($row = mysqli_fetch_array($retval, MYSQLI_NUM))
{
echo "
{$row[0]} "."
{$row[1]} "."
{$row[2]} "."
{$row[3]} "."
";}
echo '
';mysqli_close($conn);
?>
使用 mysqli_free_result 释放内存:
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT runoob_id, runoob_title,
runoob_author, submission_date
FROM runoob_tbl';
mysqli_select_db( $conn, 'RUNOOB' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '
菜鸟教程 mysqli_fetch_array 测试
';
echo '
教程 ID | 标题 | 作者 | 提交日期 |
while($row = mysqli_fetch_array($retval, MYSQLI_NUM))
{
echo "
{$row[0]} "."
{$row[1]} "."
{$row[2]} "."
{$row[3]} "."
";}
echo '
';// 释放内存
mysqli_free_result($retval);
mysqli_close($conn);
?>
标签:echo,教程,查询,MySQL,mysqli,array,php,fetch,row
来源: https://www.cnblogs.com/furuihua/p/11164368.html