Database Class

[timtamboy63]

Wow thats really complicated, maybe I'll get it once I do a bit more PHP, I've only been doing it for a week now

Also I didnt particularly get the fetchObject thing, are there any links to explain it? I havent encountered the as keyword before.

Also yeah, I noticed that I was escaping the whole string :\
Luckily I realised and split it into different functions

Anyway, thanks for taking the time to post such a lengthy reply

[litewarez]

Fetch object is simple

think of an object as a class

class User
{
    var $name = "Litewarez";
    var $rank = "Administrator";
} 

Then when you do Fetch object it returns the values in a class, so

$Object = $database->fetchObject();
$Array = $database->fetchArray();

echo $Array['name'];// Litewarez
echo $Object->name;// Litewarez 

so the names are the database colums,

so if i had a db table users with 3 columns (id,name,pass) i can use $Object->pass for example.

Heres some more examples that isn't really DB related

$Object = new stdClass(); //Blank class that can be used like an array

//Slandered variables
$Object->IAmTheChosenOne = true;
$Object->MyFatherIsABasterd = false;
$Object->MyMotherSucksYouKNowWhat = "?";

//Inner Array
$Object->array = array("hello" => "helloValue");
$Object->array['hello'];

//Inner Object
$Object->AnotherObject = new StdClass();
$Object->AnotherObject->key = "value"; 

[timtamboy63]

Hm, I think I get it, but I don't really get the advantage it has over fetch_array?

Also when you said so i can do:

foreach($phonebook->fetchArray() as $Object)
{
    echo $Object->ColumnName;
} 

is that fetcharray meant to be fetch Object()? because you told me to replace it?
Anyway, I will be doing some more research into it, thanks

[litewarez]

yea FetchObject();

the advantage is the style of coding, you become naturally to Object Using adn help you grow with OOP.

also take this idea:

Lets say i have a table called users with the columns (id,username,password,hash,reg_date)

and i created a class called GeneralUser

class GeneralUser
{
    var $id;
    var $username;
    var $password;
    var $hash;
    var $regdate;


    public function UpdateName($new_username)
    {
         //Run Query To Update Id
    }
} 

This object can be used as a fetchObject so an example

$resource = mysql_query("SELECT * FROM users");

while($user = mysql_fetch_object($resource,"GeneralUser"))
{
    if($user->id > 200)
    {
        $user->UpdateName("new username");
    }
} 

this allows us to apply "methods" as such specifically for table rows.

Most programmers would normally code a username update block a few times but by created an OOP version you only have to code it once and use it when needed, this is what OOP is about, creating code that can be used over and over again in multiple formats as such.

[timtamboy63]

Ah I see, thanks