Question

A table in MySQL names users has 3 String fields including firstname, lastname and username. Write a complete PHP class that would allow for constructing a users object and getting and setting values for each of the fields

Answer 1

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource valid, or FALSE on error.

<?php

$firstname = 'fred';

$lastname  = 'fox';

$query = sprintf("SELECT firstname, lastname, address, age FROM friends
    WHERE firstname='%s' AND lastname='%s'",
    mysql_real_escape_string($firstname),
    mysql_real_escape_string($lastname));

$result = mysql_query($query);

if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

while ($row = mysql_fetch_assoc($result)) {
    echo $row['firstname'];
    echo $row['lastname'];
    echo $row['address'];
    echo $row['age'];
}
mysql_free_result($result);
?>

PHP will internally create a new object from scratch ,execute __construct() in the Foo class, and assign this object to the variable $object.

class Foo {

    public function __construct() {

    }

}

class Bar extends Foo {

    public function __construct(ArrayObject $arrayObj, $number = 0) {

}

}

class Baz extends Bar {

    public function __construct(Bar $bar) {

}

}