如何将表的代码放在customerID周围?另外,我该如何在PHP中排序?
<html>
<head>
</head>
<body>
<?
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND=> 'SET NAMES utf8',
);
$dsn = 'mysql:host=localhost;dbname=username';
$password = 'password';
$username = 'username';
$db = new PDO($dsn, $username, $password, $options);
$query = "SELECT * FROM customers";
$stmt = $db->prepare($query);
$stmt->execute();
while($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
$id =$row['customerid'];
$name =$row['name'];
echo "Customer ID: $customerid, Name: $name<br />";
}
?>
</body>
</html>
有人能帮我吗?
使用ORDER BY COLUMN_NAME
进行排序,默认顺序为升序。
使用<table border=1>
应用带边框的表结构。
请尝试以下代码。
<html>
<head>
</head>
<body>
<?php
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND=> 'SET NAMES utf8',
);
$dsn = 'mysql:host=localhost;dbname=username';
$password = 'password';
$username = 'username';
$db = new PDO($dsn, $username, $password, $options);
$query = "SELECT * FROM customers ORDER BY name";
$stmt = $db->prepare($query);
$stmt->execute();
echo "<table border=1>";
echo "<tr>";
echo "<th>Customer ID</th>";
echo "<th>Name</th>";
echo "</tr>";
while($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
echo "<tr>";
$id =$row['customerid'];
$name =$row['name'];
echo "<td>Customer ID: $customerid</td>";
echo "<td>Name: $name</td>";
echo "</tr>";
}
echo "</table>";
?>
</body>
</html>
是否要以表格格式显示客户ID和名称?
试试这个:
<table border="1">
<tr>
<th>Customer ID</th>
<th>Name</th>
</tr>
<?php
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND=> 'SET NAMES utf8',
);
/*Other code*/
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
?>
<tr>
<td><?php echo $row['customerid']; ?> </td>
<td><?php echo $row['name'] ?> </td>
</tr>
<?php } ?>
</table>
你没有解释你需要什么样的订单,所以我认为你按名称的顺序需要数据
更换这个
$query = "SELECT * FROM customers";
带有
$query = "SELECT * FROM customers order by name";
这里的名称是表列,您可以将客户表的任何列名放在那里
使用此$stmt->fetchAll(PDO::FETCH_ASSOC)
,因为fetch()
将只返回数据库中的一行。