php mysql显示排版_用PHP显示MySQL

到目前为止,我有这个程序将我的phpmyadmin数据库链接到我的PHP脚本.现在,我需要在表格中显示某些内容,例如“所有记录”,“姓氏以S开头的所有联系人”,“所有宠物主人”等等.我的问题是：是否有更简单的方法将代码插入我的php脚本显示来自我的数据库的信息.现在我有那个很长的echo语句来显示信息.有没有办法可以使用像SELECT *语句这样的东西来显示所有记录并简化我的代码？

$db_hostname='localhost';

$db_username='root';

$db_password='';

$db_database='Address Book';

$connection = new mysqli( $db_hostname,

$db_username,

$db_password,

$db_database);

if ($connection->connect_error) {

echo "Sorry";

} else {

echo "Connected!
";

$sql = "SELECT * FROM People";

$result = $connection->query($sql);

if (!$result) die ($connection->error);

$n = $result->num_rows;

for ($i=1; $i<=$n; $i++) {

$row = $result->fetch_array(MYSQLI_ASSOC);

echo "

ID	First Name	Last Name	Street Address	City	State	Zip Code	Email Address	Comment	Number of pets

echo "

" . $row['iD'] . "" . $row['First Name'] . "" .

$row['Last Name'] . "

" . $row['Street Address'] . "" .

$row['City'] . "

" . $row['State'] . "" .

$row['Zip Code'] . "

" . $row['Email Address'] . "" .

$row['Comment'] . "

" . $row['Number of pets'] . "";

}

echo "

";

}

?>

解决方法:

您应首先使用表结构,然后在结构中插入PHP代码.例如：

// Put your MYSQLI retrievals codes here

?>

FIELD_1	FIELD_2	FIELD_3

while ($rows = $result->fetch_array(MYSQLI_ASSOC))

{

?>

<?php echo $rows['field_1']; ?><?php echo $rows['field_2']; ?><?php echo $rows['field_3']; ?>

}

?>

标签：php,mysql,database,addressbook

来源： https://codeday.me/bug/20190708/1401168.html