com doc/ja: Simplify mysqli select db examples: reference/mysqli/mysqli/select-db.xml
[email protected] (Yoshinari Takaoka) Mon, 22 Mar 2021 18:35:39 +0000
| Newsgroups | php.doc.ja |
|---|---|
| Message-ID | <[email protected]> |
Commit: 2ec4ab8194991f9e334ebaf54de9b787c51b924a=0AAuthor: Yoshinari = Takaoka <[email protected]> Tue, 23 Mar 2021 03:35:39 +0900=0AParen= ts: c01b860bee7374e9acc6b344d12b14dad18aec38=0ABranches: master=0A=0ALin= k: http://git.php.net/?p=3Ddoc/ja.git;a=3Dcommitdiff;h=3D2ec4ab819499= 1f9e334ebaf54de9b787c51b924a=0A=0ALog:=0ASimplify mysqli select db examples= =0A=0AChanged paths:=0A M reference/mysqli/mysqli/select-db.xml=0A=0A=0AD= iff:=0Adiff --git a/reference/mysqli/mysqli/select-db.xml b/reference/mysql= i/mysqli/select-db.xml=0Aindex 8307367c6b..f44b0942ea 100644=0A--- a/refere= nce/mysqli/mysqli/select-db.xml=0A+++ b/reference/mysqli/mysqli/select-db.x= ml=0A@@ -1,6 +1,6 @@=0A <?xml version=3D"1.0" encoding=3D"utf-8"?>=0A <!-- = $Revision$ -->=0A-<!-- EN-Revision: 7e5d0d1bb69180c9de1992edf9613215c975fa5= 7 Maintainer: takagi Status: ready -->=0A+<!-- EN-Revision: 34ec8e992f4ac2c= 6abb35e58452842cdaff975bc Maintainer: takagi Status: ready -->=0A <!-- Cred= its: mumumu -->=0A <refentry xml:id=3D"mysqli.select-db" xmlns=3D"http://do= cbook.org/ns/docbook">=0A <refnamediv>=0A@@ -67,66 +67,44 @@=0A <progra= mlisting role=3D"php">=0A <![CDATA[=0A <?php=0A-$mysqli =3D new mysqli("loc= alhost", "my_user", "my_password", "test");=0A =0A-/* =E6=8E=A5=E7=B6=9A= =E7=8A=B6=E6=B3=81=E3=82=92=E3=83=81=E3=82=A7=E3=83=83=E3=82=AF=E3=81=97= =E3=81=BE=E3=81=99 */=0A-if (mysqli_connect_errno()) {=0A- printf("Conne= ct failed: %s\n", mysqli_connect_error());=0A- exit();=0A-}=0A+mysqli_re= port(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);=0A+$mysqli =3D new mysqli= ("localhost", "my_user", "my_password", "test");=0A =0A-/* =E7=8F=BE= =E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=87= =E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=E8=BF=94= =E3=81=97=E3=81=BE=E3=81=99 */=0A-if ($result =3D $mysqli->query("SELECT DA= TABASE()")) {=0A- $row =3D $result->fetch_row();=0A- printf("Default = database is %s.\n", $row[0]);=0A- $result->close();=0A-}=0A+/* =E7=8F= =BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83= =87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=E5=8F= =96=E5=BE=97=E3=81=97=E3=81=BE=E3=81=99 */=0A+$result =3D $mysqli->query("S= ELECT DATABASE()");=0A+$row =3D $result->fetch_row();=0A+printf("Default da= tabase is %s.\n", $row[0]);=0A =0A /* =E3=83=87=E3=83=BC=E3=82=BF=E3=83= =99=E3=83=BC=E3=82=B9=E3=82=92 world =E3=81=AB=E5=A4=89=E6=9B=B4=E3=81= =97=E3=81=BE=E3=81=99 */=0A $mysqli->select_db("world");=0A =0A-/* = =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88= =E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92= =E8=BF=94=E3=81=97=E3=81=BE=E3=81=99 */=0A-if ($result =3D $mysqli->query("= SELECT DATABASE()")) {=0A- $row =3D $result->fetch_row();=0A- printf(= "Default database is %s.\n", $row[0]);=0A- $result->close();=0A-}=0A-=0A= -$mysqli->close();=0A-?>=0A+/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87= =E3=83=95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99= =E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92=E5=8F=96=E5=BE=97=E3=81=97=E3=81=BE= =E3=81=99 */=0A+$result =3D $mysqli->query("SELECT DATABASE()");=0A+$row = =3D $result->fetch_row();=0A+printf("Default database is %s.\n", $row[0]);= =0A ]]>=0A </programlisting>=0A <para>&style.procedural;</para>=0A = <programlisting role=3D"php">=0A <![CDATA[=0A <?php=0A-$link =3D mysqli_co= nnect("localhost", "my_user", "my_password", "test");=0A =0A-/* =E6=8E= =A5=E7=B6=9A=E7=8A=B6=E6=B3=81=E3=82=92=E3=83=81=E3=82=A7=E3=83=83=E3=82= =AF=E3=81=97=E3=81=BE=E3=81=99 */=0A-if (mysqli_connect_errno()) {=0A- p= rintf("Connect failed: %s\n", mysqli_connect_error());=0A- exit();=0A-}= =0A+mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);=0A+$link =3D= mysqli_connect("localhost", "my_user", "my_password", "test");=0A =0A-/* = =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83=AB=E3=83=88= =E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90=8D=E3=82=92= =E8=BF=94=E3=81=97=E3=81=BE=E3=81=99 */=0A-if ($result =3D mysqli_query($li= nk, "SELECT DATABASE()")) {=0A- $row =3D mysqli_fetch_row($result);=0A- = printf("Default database is %s.\n", $row[0]);=0A- mysqli_free_result(= $result);=0A-}=0A+/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82= =A9=E3=83=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82= =B9=E5=90=8D=E3=82=92=E5=8F=96=E5=BE=97=E3=81=97=E3=81=BE=E3=81=99 */=0A+$r= esult =3D mysqli_query($link, "SELECT DATABASE()");=0A+$row =3D mysqli_fetc= h_row($result);=0A+printf("Default database is %s.\n", $row[0]);=0A =0A /* = =E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E3=82=92 world = =E3=81=AB=E5=A4=89=E6=9B=B4=E3=81=97=E3=81=BE=E3=81=99 */=0A mysqli_select_= db($link, "world");=0A =0A-/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83= =95=E3=82=A9=E3=83=AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83= =BC=E3=82=B9=E5=90=8D=E3=82=92=E8=BF=94=E3=81=97=E3=81=BE=E3=81=99 */=0A-if= ($result =3D mysqli_query($link, "SELECT DATABASE()")) {=0A- $row =3D m= ysqli_fetch_row($result);=0A- printf("Default database is %s.\n", $row[0= ]);=0A- mysqli_free_result($result);=0A-}=0A-=0A-mysqli_close($link);=0A= -?>=0A+/* =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=83=87=E3=83=95=E3=82=A9=E3=83= =AB=E3=83=88=E3=83=87=E3=83=BC=E3=82=BF=E3=83=99=E3=83=BC=E3=82=B9=E5=90= =8D=E3=82=92=E5=8F=96=E5=BE=97=E3=81=97=E3=81=BE=E3=81=99 */=0A+$result =3D= mysqli_query($link, "SELECT DATABASE()");=0A+$row =3D mysqli_fetch_row($re= sult);=0A+printf("Default database is %s.\n", $row[0]);=0A ]]>=0A </prog= ramlisting>=0A &examples.outputs;=0A