<?php
class User
{
protected $id;
public static function get()
{
global $db;
$q = $db->query("SELECT * FROM User WHERE `id` = 1");
$q->setFetchMode(PDO::FETCH_CLASS, 'User');
return $q->fetch();
}
public function load()
{
$q = $db->query("SELECT * FROM User WHERE `id` = 1");
$q->setFetchMode(PDO::FETCH_INTO, $this);
return $q->fetch();
}
}
$db = new PDO('sqlite::memory:');
$db->exec("CREATE TABLE User(id INTEGER PRIMARY KEY)");
$db->query("INSERT INTO User VALUES(1)");
// worko
var_dump(User::get());
// no-worko
$user = new User;
var_dump($user->load());
object(User)#3 (1) {
["id":protected]=>
int(1)
}
Warning: Undefined variable $db in /in/rIiNU on line 19
Fatal error: Uncaught Error: Call to a member function query() on null in /in/rIiNU:19
Stack trace:
#0 /in/rIiNU(35): User->load()
#1 {main}
thrown in /in/rIiNU on line 19
Process exited with code 255.
Output for 8.0.0 - 8.0.30
object(User)#3 (1) {
["id":protected]=>
string(1) "1"
}
Warning: Undefined variable $db in /in/rIiNU on line 19
Fatal error: Uncaught Error: Call to a member function query() on null in /in/rIiNU:19
Stack trace:
#0 /in/rIiNU(35): User->load()
#1 {main}
thrown in /in/rIiNU on line 19
Process exited with code 255.
object(User)#3 (1) {
["id":protected]=>
string(1) "1"
}
Notice: Undefined variable: db in /in/rIiNU on line 19
Fatal error: Uncaught Error: Call to a member function query() on null in /in/rIiNU:19
Stack trace:
#0 /in/rIiNU(35): User->load()
#1 {main}
thrown in /in/rIiNU on line 19
Process exited with code 255.
Output for 7.3.32 - 7.3.33, 7.4.26
object(User)#3 (1) {
["id":protected]=>
string(1) "1"
}
Fatal error: Uncaught Error: Call to a member function query() on null in /in/rIiNU:19
Stack trace:
#0 /in/rIiNU(35): User->load()
#1 {main}
thrown in /in/rIiNU on line 19
Process exited with code 255.
Output for 7.0.0 - 7.0.4
object(User)#3 (1) {
["id":protected]=>
string(1) "1"
}
Notice: Undefined variable: db in /in/rIiNU on line 19
Fatal error: Uncaught Error: Call to a member function query() on unknown in /in/rIiNU:19
Stack trace:
#0 /in/rIiNU(35): User->load()
#1 {main}
thrown in /in/rIiNU on line 19
Process exited with code 255.
Output for 5.6.7 - 5.6.21
object(User)#3 (1) {
["id":protected]=>
string(1) "1"
}
Notice: Undefined variable: db in /in/rIiNU on line 19
Fatal error: Call to a member function query() on null in /in/rIiNU on line 19
Process exited with code 255.
object(User)#3 (1) {
["id":protected]=>
string(1) "1"
}
Notice: Undefined variable: db in /in/rIiNU on line 19
Fatal error: Call to a member function query() on a non-object in /in/rIiNU on line 19
Process exited with code 255.
Output for 5.1.0 - 5.1.3, 5.2.0 - 5.2.17
object(User)#3 (1) {
["id:protected"]=>
string(1) "1"
}
Notice: Undefined variable: db in /in/rIiNU on line 19
Fatal error: Call to a member function query() on a non-object in /in/rIiNU on line 19
Process exited with code 255.
Output for 5.1.4 - 5.1.6
Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /in/rIiNU:26
Stack trace:
#0 /in/rIiNU(26): PDO->__construct('sqlite::memory:')
#1 {main}
thrown in /in/rIiNU on line 26
Process exited with code 255.
Output for 5.0.0 - 5.0.5
Fatal error: Class 'PDO' not found in /in/rIiNU on line 26
Process exited with code 255.
Output for 4.4.2 - 4.4.9
Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /in/rIiNU on line 5
Process exited with code 255.
Parse error: parse error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /in/rIiNU on line 5
Process exited with code 255.
Output for 4.3.2 - 4.3.4
Parse error: parse error, expecting `T_OLD_FUNCTION' or `T_FUNCTION' or `T_VAR' or `'}'' in /in/rIiNU on line 5
Process exited with code 255.