com doc/ja: Simplify mysqli select db examples: reference/mysqli/mysqli/select-db.xml
| From: | Yoshinari Takaoka | Date: | Mon, 22 Mar 2021 18:35:39 +0000 |
| Subject: | com doc/ja: Simplify mysqli select db examples: reference/mysqli/mysqli/select-db.xml | ||
| Groups: | php.doc.ja | ||
| Request: | Send a blank email to doc-ja+get-6273@lists.php.net to get a copy of this message | ||
Commit: 2ec4ab8194991f9e334ebaf54de9b787c51b924a
Author: Yoshinari Takaoka <mumumu@mumumu.org> Tue, 23 Mar 2021 03:35:39 +0900
Parents: c01b860bee7374e9acc6b344d12b14dad18aec38
Branches: master
Link: http://git.php.net/?p=doc/ja.git;a=commitdiff;h=2ec4ab8194991f9e334ebaf54de9b787c51b924a
Log:
Simplify mysqli select db examples
Changed paths:
M reference/mysqli/mysqli/select-db.xml
Diff:
diff --git a/reference/mysqli/mysqli/select-db.xml b/reference/mysqli/mysqli/select-db.xml
index 8307367c6b..f44b0942ea 100644
--- a/reference/mysqli/mysqli/select-db.xml
+++ b/reference/mysqli/mysqli/select-db.xml
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
<!-- $Revision$ -->
-<!-- EN-Revision: 7e5d0d1bb69180c9de1992edf9613215c975fa57 Maintainer: takagi Status: ready
-->
+<!-- EN-Revision: 34ec8e992f4ac2c6abb35e58452842cdaff975bc Maintainer: takagi Status: ready
-->
<!-- Credits: mumumu -->
<refentry xml:id="mysqli.select-db" xmlns="http://docbook.org/ns/docbook">
<refnamediv>
@@ -67,66 +67,44 @@
<programlisting role="php">
<![CDATA[
<?php
-$mysqli = new mysqli("localhost", "my_user", "my_password",
"test");
-/* 接続状況をチェックします */
-if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
-}
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$mysqli = new mysqli("localhost", "my_user", "my_password",
"test");
-/* 現在のデフォルトデータベース名を返します */
-if ($result = $mysqli->query("SELECT DATABASE()")) {
- $row = $result->fetch_row();
- printf("Default database is %s.\n", $row[0]);
- $result->close();
-}
+/* 現在のデフォルトデータベース名を取得します */
+$result = $mysqli->query("SELECT DATABASE()");
+$row = $result->fetch_row();
+printf("Default database is %s.\n", $row[0]);
/* データベースを world に変更します */
$mysqli->select_db("world");
-/* 現在のデフォルトデータベース名を返します */
-if ($result = $mysqli->query("SELECT DATABASE()")) {
- $row = $result->fetch_row();
- printf("Default database is %s.\n", $row[0]);
- $result->close();
-}
-
-$mysqli->close();
-?>
+/* 現在のデフォルトデータベース名を取得します */
+$result = $mysqli->query("SELECT DATABASE()");
+$row = $result->fetch_row();
+printf("Default database is %s.\n", $row[0]);
]]>
</programlisting>
<para>&style.procedural;</para>
<programlisting role="php">
<![CDATA[
<?php
-$link = mysqli_connect("localhost", "my_user", "my_password",
"test");
-/* 接続状況をチェックします */
-if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
-}
+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
+$link = mysqli_connect("localhost", "my_user", "my_password",
"test");
-/* 現在のデフォルトデータベース名を返します */
-if ($result = mysqli_query($link, "SELECT DATABASE()")) {
- $row = mysqli_fetch_row($result);
- printf("Default database is %s.\n", $row[0]);
- mysqli_free_result($result);
-}
+/* 現在のデフォルトデータベース名を取得します */
+$result = mysqli_query($link, "SELECT DATABASE()");
+$row = mysqli_fetch_row($result);
+printf("Default database is %s.\n", $row[0]);
/* データベースを world に変更します */
mysqli_select_db($link, "world");
-/* 現在のデフォルトデータベース名を返します */
-if ($result = mysqli_query($link, "SELECT DATABASE()")) {
- $row = mysqli_fetch_row($result);
- printf("Default database is %s.\n", $row[0]);
- mysqli_free_result($result);
-}
-
-mysqli_close($link);
-?>
+/* 現在のデフォルトデータベース名を取得します */
+$result = mysqli_query($link, "SELECT DATABASE()");
+$row = mysqli_fetch_row($result);
+printf("Default database is %s.\n", $row[0]);
]]>
</programlisting>
&examples.outputs;