php getting data from mysql database

Question

I'm trying to get data fom a database, the problem is that I get a notice 'Array to string conversion', and $array returns 'Array'. the get_rows method gets all the rows using the current query. Any idea why this is happening? here's the code:

public function load_seat_by_number($seat_number)
    {
        $db = model_database::instance();
        $sql = "SELECT * FROM `seats` WHERE `seat_number` = '". intval($this->seat_number). "'";
        if (($array = $db->get_rows($sql)) > 0)
            return $array;
        else return FALSE;
    }

This intval($this->seat_number) should just be intval($seat_number), no? — ppeterka
– ppeterka, Commented Sep 19, 2013 at 12:35

aynber · Accepted Answer · 2013-09-19 12:37:20Z

1

This happens because $array is, well, an array. Use count instead. Otherwise, check your database model to see if there is a way to get the number of rows from the result.

$array = $db->get_rows($sql);
if(count($array) > 0)

answered Sep 19, 2013 at 12:37

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

5 Comments

icarus Over a year ago

I tried, but it still returns 'Array'. $array = $db->get_rows($sql); if(count($array) > 0) return $array; else return FALSE;

aynber Over a year ago

What do you expect it to return?

icarus Over a year ago

I want to return the data in the rows of the database. I'm sorry if I'm being noobish, but I'm really a beginner.

Funk Forty Niner Over a year ago

@icarus Then you need to echo what you need to come back, something to theh affect of echo $get_rows['seat_number']; --- return $array doesn't show the results in the array.

aynber Over a year ago

Your data is in the array. You'll need to iterate through the array to get the data. Use foreach (php.net/manual/en/control-structures.foreach.php) to iterate through the array, though each one of those will be another array with the columns of each row.

user1850534 · Accepted Answer · 2013-09-19 12:43:59Z

0

Use sizeof or count to get the number of elements in an array.

if (($array = sizeof($db->get_rows($sql))) > 0) //returns the integer value(total no. of elements in an array)
        return $array;

or

 if (($array = count($db->get_rows($sql))) > 0)  //returns the integer value(total no. of elements in an array)
            return $array;

answered Sep 19, 2013 at 12:43

user1850534

Comments

Adam · Accepted Answer · 2013-09-19 12:44:33Z

0

This should work

public function load_seat_by_number($seat_number)
{
    $db = model_database::instance();
    $sql = "SELECT * FROM `seats` WHERE `seat_number` = '". intval($this->seat_number). "'";
    if (count($db->get_rows($sql)) > 0)
        return $db->get_rows($sql);
    else return FALSE;
}

answered Sep 19, 2013 at 12:44

Adam

1,3712 gold badges11 silver badges12 bronze badges

Collectives™ on Stack Overflow

php getting data from mysql database

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related