資料庫中有資料表hacker，現在我們要將hacker表中的資料查詢出來并在頁面上顯示，代碼如下：
<?php
// 連接資料庫
$mysqli = mysqli_connect("localhost","root","123",'student'); //mysqli_close($con);
$mysqli ? print 'yes!<br>':print "no!<br>";
$sql = $mysqli -> query('use student');
$sql = $mysqli -> query('set name utf8');
// 創建資料表
$sql = $mysqli -> query("create table hacker(
id char(6) not null,
name char(8) not null,
chinese float not null,
math float not null,
english float not null
)");
if($sql == true){
echo '成功創建hacker表！<br>';
}else{
echo '創建hacker表失敗！'.$mysqli->error.'<br>';
}
// 添加資料——hacker
// $sql = "insert into hacker values('1','張三','10','20','30');";
// $sql .= "insert into hacker values('2','李四','66','77','88');";
// $sql .= "insert into hacker values('3','王二','55','44','33');";
// $sql .= "insert into hacker values('4','麻子','22','55','77')";
// $rows = $mysqli->affected_rows;
// if($rows == 3){
// echo "添加資料成功，<br>";
// }else{
// echo '添加失敗，'.$mysqli->error."<br>";
// }
$sql = $mysqli -> query("insert into hacker
values('2','李四','66','77','88')
");
$rows = $mysqli->affected_rows;
if($rows == 1){
echo "添加資料成功，<br>";
}else{
echo '添加失敗，'.$mysqli->error."<br>";
}
$sql = $mysqli -> query("insert into hacker
values('3','王二','55','44','33')
");
$rows = $mysqli->affected_rows;
if($rows == 1){
echo "添加資料成功，<br>";
}else{
echo '添加失敗，'.$mysqli->error."<br>";
}
$sql = $mysqli -> query("insert into hacker
values('4','麻子','22','55','77')
");
$rows = $mysqli->affected_rows;
if($rows == 1){
echo "添加資料成功，<br>";
}else{
echo '添加失敗，'.$mysqli->error."<br>";
}
// 資料查詢
$sql = $mysqli->query("select * from hacker");
if($sql){
// echo '有資料！<br>';
$rows = $sql->num_rows;
echo '查詢結果共有'.$rows.'條記錄<br>';
echo "<table>
<tr>
<th>序號</th>
<th>姓名</th>
<th>語文</th>
<th>數學</th>
<th>英語</th>
<tr>
";
if($rows){
while($row = $sql->fetch_assoc()){
// echo 'id = '.$row['id'].'<br>name = '.$row['name'].'<br>chinese = '.$row['chinese'].'<br>math = '.$row['math'].'<br>english = '.$row['english'].'<br>';
echo "<tr>
<td>".$row['id']."</td>
<td>".$row['name']."</td>
<td>".$row['chinese']."</td>
<td>".$row['math']."</td>
<td>".$row['english']."</td>
</tr>
";
}
echo "</table>";
}else{
echo '沒有您要找的資料，<br>';
}
}else{
echo 'MySQL陳述句有誤，<br>'.$mysqli->error.'<br>';
}
?>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/246913.html
標籤：其他
上一篇：不同型別的事實表匯入操作總結