SQLから結果の取得する方法。

###やりたいこと
最大値が取得し、表示したい。
###分からないこと
取得したあとの、表示の方法

宜しくお願いします。

###SQL文

php
1
2$mysqli = new mysqli($server, $user, $password,$dbName);
3 
4if ($mysqli->connect_error){
5	echo $mysqli->connect_error;
6	exit();
7}else{
8	$mysqli->set_charset("utf-8");
9}
10 
11 $sql = "SELECT MAX(id) FROM URL";
12
13//ここからがわかりません。
14
15
16//クエリー失敗
17if(!$result) {
18	echo $mysqli->error;
19	exit();
20}

行動規範の内容に同意します

回答2件

ベストアンサー

Caution!:
I didn't test codes below and nowadays I didn't use PHP neither DB. So, this is unguaranteed.

PHP
1$sql = "SELECT MAX(id) FROM URL";
2
3//ここからがわかりません。
4
5/* Execute your query. You could get records 'array' that contains 'mysqli_result' object(s) as $result. */
6$result = $mysqli->query($sql);
7
8//クエリー失敗 that means you couldn't get it.
9if(!$result) {
10    echo $mysqli->error;
11    exit();
12}
13
14/* So, now, You have gotten records. Let's show it as most general easiest way. */
15while ($row = $result->fetch_assoc())
16{
17    echo $row["id"] . "<br>\n";
18}
19//
20// Perhaps, you may display it as simply like below if you use PHP 5.4 or later...
21//
22// echo $result->fetch_assoc()[0]["id"] . "<br>\n";   // Ah, maybe... $result->fetch_assoc()["id"] will be right....
23
24/* You should better to purge your records that you got. */
25$result->close();
26
27/* You should better to close your connection. */
28$mysqli->close();
29