[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-doc-cvs
Subject:    [DOC-CVS] com doc/en: Simplify mysqli select db examples: reference/mysqli/mysqli/select-db.xml
From:       Christoph Michael Becker <cmb () php ! net>
Date:       2021-03-22 16:01:43
Message-ID: php-mail-172ab9741ce0cf718360a1eaca0b88492100880270 () git ! php ! net
[Download RAW message or body]

Commit:    34ec8e992f4ac2c6abb35e58452842cdaff975bc
Author:    Kamil Tekiela <tekiela246@gmail.com>         Sat, 20 Mar 2021 15:41:29 +0100
Committer: Christoph M. Becker <cmbecker69@gmx.de>      Mon, 22 Mar 2021 17:01:43 +0100
Parents:   4bf7d10a44468767e7715fdd17f80a4a41478c22
Branches:  master

Link:       http://git.php.net/?p=doc/en.git;a=commitdiff;h=34ec8e992f4ac2c6abb35e58452842cdaff975bc

Log:
Simplify mysqli select db examples

Closes GH-496.

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 7cd0682606..48cbdbe79a 100644
--- a/reference/mysqli/mysqli/select-db.xml
+++ b/reference/mysqli/mysqli/select-db.xml
@@ -65,66 +65,44 @@
    <programlisting role="php">
 <![CDATA[
 <?php
-$mysqli = new mysqli("localhost", "my_user", "my_password", "test");
 
-/* check connection */
-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");
 
-/* return name of current default database */
-if ($result = $mysqli->query("SELECT DATABASE()")) {
-    $row = $result->fetch_row();
-    printf("Default database is %s.\n", $row[0]);
-    $result->close();
-}
+/* get the name of the current default database */
+$result = $mysqli->query("SELECT DATABASE()");
+$row = $result->fetch_row();
+printf("Default database is %s.\n", $row[0]);
 
-/* change db to world db */
+/* change default database to "world" */
 $mysqli->select_db("world");
 
-/* return name of current default database */
-if ($result = $mysqli->query("SELECT DATABASE()")) {
-    $row = $result->fetch_row();
-    printf("Default database is %s.\n", $row[0]);
-    $result->close();
-}
-
-$mysqli->close();
-?>
+/* get the name of the current default database */
+$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");
 
-/* check connection */
-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");
 
-/* return name of current default database */
-if ($result = mysqli_query($link, "SELECT DATABASE()")) {
-    $row = mysqli_fetch_row($result);
-    printf("Default database is %s.\n", $row[0]);
-    mysqli_free_result($result);
-}
+/* get the name of the current default database */
+$result = mysqli_query($link, "SELECT DATABASE()");
+$row = mysqli_fetch_row($result);
+printf("Default database is %s.\n", $row[0]);
 
-/* change db to world db */
+/* change default database to "world" */
 mysqli_select_db($link, "world");
 
-/* return name of current default database */
-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);
-?>
+/* get the name of the current default database */
+$result = mysqli_query($link, "SELECT DATABASE()");
+$row = mysqli_fetch_row($result);
+printf("Default database is %s.\n", $row[0]);
 ]]>
    </programlisting>
    &examples.outputs;


--
PHP Documentation Commits Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]