Cannot use object of type mysqli_result as array in php Mysql [duplicate]

Question

I want to select the last row for my database and echo the columns titled s1 and s2 to the body of the web page, the following is my code. This gives an error.

<html>
<body>
<?php

$servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "mydb2";

            $conn = new mysqli($servername, $username, $password, $dbname);
            if ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);
            } 
$sql = "SELECT s1, s2 from reading ORDER BY id DESC LIMIT 1";
$row = array();
$row = mysqli_query($conn,$sql);
echo " cup 1". $row["s1"]. "CUP 2". $row["s2"];
 ?>



</body>
</html>

you skipped the fetch part, after the query execution, fetch the results — Kevin
– Kevin, Commented Apr 29, 2016 at 3:20

Mahesh Chavda · Accepted Answer · 2016-04-29 03:32:38Z

2

You have to use mysqli_fetch_assoc (that will loop through your resultset) as follows:

if ($result = mysqli_query($conn, $sql)) {

    while ($row = mysqli_fetch_assoc($result)) {
        echo " cup 1". $row["s1"]. "CUP 2". $row["s2"];
    }

    /* free result set */
    mysqli_free_result($result);
}

Without loop:

if ($result = mysqli_query($conn, $sql)) {

    $row = mysqli_fetch_assoc($result);
    if($row)
    {
       echo " cup 1". $row["s1"]. "CUP 2". $row["s2"];
    }

    /* free result set */
    mysqli_free_result($result);
}

edited Apr 29, 2016 at 3:32

answered Apr 29, 2016 at 3:26

Mahesh Chavda

5933 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sanzeeb Aryal Over a year ago

Why loop for just 1 row?

user3785693 · Accepted Answer · 2016-04-29 03:32:46Z

Your solution

<html>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydb2";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("MySQL Connection Error"); // Try not to output SQL error messages on the front-end, look into error_reporting()
}

$sqlQuery = "SELECT s1, s2 from reading ORDER BY id DESC LIMIT 1";
$results = mysqli_fetch_assoc(mysqli_query($conn, $sqlQuery));
echo " cup 1". $results["s1"]. "CUP 2". $results["s2"];
?>
</body>
</html>

In addition to that, I suggest not doing your SQL operations in both procedural style and object-oriented style, as this can lead to many complications in the future.

Santhy K · Accepted Answer · 2016-04-29 03:35:48Z

0

Use mysqli_fetch_assoc for fetching the result to array

$sql = "SELECT s1, s2 from reading ORDER BY id DESC LIMIT 1";
if ($result = mysqli_query($conn, $sql)) {
    $row = mysqli_fetch_assoc($result);
    echo " cup 1". $row["s1"]. "CUP 2". $row["s2"];
}

answered Apr 29, 2016 at 3:35

Santhy K

8041 gold badge7 silver badges12 bronze badges

Collectives™ on Stack Overflow

Cannot use object of type mysqli_result as array in php Mysql [duplicate]

3 Answers 3

1 Comment

Your solution

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Your solution

Comments

Comments

Linked

Related