php oop mysql query

Question

I received some help moments ago, but was never able to find out why this query is not working? How might I modify this to make it work?

class Posts {

  public static function multipleQuery() {

    $result = mysql_query("SELECT * FROM posts ORDER BY id DESC LIMIT 0, 3")
              , __CLASS__);

      while($object = mysql_fetch_object($result)) {
        $return[] = $object;
      }
      return $return;
  }
}


$array = Posts::multipleQuery();
foreach($array AS $row) {
   echo $row->title;
}

Unfortunately I am not getting anything back. The query works, I have tested that out.

Try var_dump($array). Also , __CLASS__) is misplaced. Please be more specific on what exactly doesn't work. — svens
– svens, Commented Mar 18, 2011 at 16:52
What happens, what doesn't work? EIther way, this looks wrong ), __CLASS__); — Pekka
– Pekka, Commented Mar 18, 2011 at 16:52
Are you missing the database connection or is it just not part of this snippet? — Matteo Riva
– Matteo Riva, Commented Mar 18, 2011 at 16:53
ini_set('error_reporting', E_ALL); and ini_set('display_errors', true); set at the top of your script will ensure that errors are displayed and should help you to debug this. — Treffynnon
– Treffynnon, Commented Mar 18, 2011 at 16:56
Looking at the code, you have invalid syntax on line 3. Remove , __CLASS__). — Richard Parnaby-King
– Richard Parnaby-King, Commented Mar 18, 2011 at 16:56

Johan · Accepted Answer · 2011-05-28 22:22:34Z

4

The second argument on mysql_query should be a mysql connection handle. Passing your classe's name is not such a handle, so you're trying to execute the query on a database connection which doesn't exist. As well, you have no error checking, which would've shown this problem:

public static function multipleQuery(){
    $result = mysql_query("SELECT * FROM posts ORDER BY id DESC LIMIT 0, 3") 
              or die(mysql_error());

    while($object = mysql_fetch_object($result)) {
        $return[] = $object;
    }
    return $return;
}

edited May 28, 2011 at 22:22

Johan

77.4k28 gold badges204 silver badges346 bronze badges

answered Mar 18, 2011 at 16:55

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

Teekin · Accepted Answer · 2011-03-18 17:08:11Z

1

I'm guessing you have error reporting turned off, and are thus not seeing the parse error that should result from this line:

$result = mysql_query("SELECT * FROM posts ORDER BY id DESC LIMIT 0, 3"), __CLASS__);

I see two parentheses closed but only one opened.

Also you shouldn't throw the class name in there anyway. If anything, you should put in the object for the database connection, not the name of the class.

answered Mar 18, 2011 at 17:08

Teekin

13.4k17 gold badges58 silver badges69 bronze badges

Collectives™ on Stack Overflow

php oop mysql query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related