「20210104用PHP程式列出selldb資料庫的custs資料表的所有資料錄(a1.php)」:修訂間差異
跳至導覽
跳至搜尋
(建立內容為「<pre> <body bgcolor=lightyellow> <img src=dog.png width=50> <hr color=red> <?php $con = mysqli_connect('localhost', 'root', 'abc123abc123', 'selldb'); $sql= "sel…」的新頁面) |
無編輯摘要 |
||
行 1: | 行 1: | ||
==a1.php== | |||
<pre> | <pre> | ||
<body bgcolor=lightyellow> | <body bgcolor=lightyellow> | ||
<img src=dog.png width=50> | <img src=dog.png width=50> | ||
行 18: | 行 18: | ||
</body> | </body> | ||
</pre> | |||
==2== | |||
<pre> | |||
mysql> use selldb; | |||
Database changed | |||
mysql> desc custs; | |||
+--------+----------+------+-----+---------+-------+ | |||
| Field | Type | Null | Key | Default | Extra | | |||
+--------+----------+------+-----+---------+-------+ | |||
| id | char(10) | YES | | NULL | | | |||
| name | char(20) | YES | | NULL | | | |||
| amount | float | YES | | NULL | | | |||
| tel | char(20) | YES | | NULL | | | |||
+--------+----------+------+-----+---------+-------+ | |||
4 rows in set (0.07 sec) | |||
mysql> select * from custs; | |||
+-------+--------+--------+--------+ | |||
| id | name | amount | tel | | |||
+-------+--------+--------+--------+ | |||
| 10001 | 小狗 | 100 | 233111 | | |||
| 20002 | 小貓 | 200 | 233444 | | |||
| 30003 | 小牛 | 300 | 233777 | | |||
+-------+--------+--------+--------+ | |||
3 rows in set (0.00 sec) | |||
mysql> quit | |||
Bye | |||
C:\Users\user> | |||
</pre> | </pre> |
於 2021年1月4日 (一) 06:51 的修訂
a1.php
<body bgcolor=lightyellow> <img src=dog.png width=50> <hr color=red> <?php $con = mysqli_connect('localhost', 'root', 'abc123abc123', 'selldb'); $sql= "select id,name,amount,tel from custs"; $query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query)){ echo $row['id'] . ":" . $row['name'] . ":" . $row['amount'] . "<br>"; } mysqli_close ($con); ?> <hr color=green> <img src=cat.png width=50> </body>
2
mysql> use selldb; Database changed mysql> desc custs; +--------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+----------+------+-----+---------+-------+ | id | char(10) | YES | | NULL | | | name | char(20) | YES | | NULL | | | amount | float | YES | | NULL | | | tel | char(20) | YES | | NULL | | +--------+----------+------+-----+---------+-------+ 4 rows in set (0.07 sec) mysql> select * from custs; +-------+--------+--------+--------+ | id | name | amount | tel | +-------+--------+--------+--------+ | 10001 | 小狗 | 100 | 233111 | | 20002 | 小貓 | 200 | 233444 | | 30003 | 小牛 | 300 | 233777 | +-------+--------+--------+--------+ 3 rows in set (0.00 sec) mysql> quit Bye C:\Users\user>