Putting the classes to work together: seeing the MVC schema in action - PHP

Are you a curious PHP developer, wanting to learn how to simulate a basic Model-View-Controller schema with PHP? Then, look no further, because you’re in the right place. Welcome to the final part of the series “Simulating the Model-View-Controller Schema in PHP.” In three tutorials, this series provides you with a comprehensive introduction, aimed at implementing a MVC-based relationship between PHP objects.

TABLE OF CONTENTS:

By: Alejandro Gervasio

Poor Best

Rating:

/ 14

August 21, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

As I expressed in the previous section, here is an example that shows how to use all the classes that I coded before, assuming that there's a database table called "users" populated with the following data:

ID: 1 Name: user1 Email: user1@domain.com
ID: 2 Name: user2 Email: user2@domain.com
ID: 3 Name: user3 Email: user3@domain.com
ID: 4 Name: user4 Email: user4@domain.com
ID: 5 Name: user5 Email: user5@domain.com

Now, pay attention to the code snippet below, which returns the previous data set as XHTML:

// return result set as XHTML
// connect to MySQL
$db=new MySQL(array
('host'=>'host','user'=>'user','password'=>'password',
'database'=>'database'));
// get a result set
$result=$db->query('SELECT * FROM users');
$resultController=new ResultController('xhtml');
$mysqlResult=new MySQLResult($resultController,$result);
$outputGenerator=new outputGenerator($mysqlResult);
echo $outputGenerator->generateOutput();
/*

displays the following:

Finally, here are the two scripts that return the previous MySQL result set as XML and plain text respectively:

// return result set as XML
// connect to MySQL
$db=new MySQL(array
('host'=>'host','user'=>'user','password'=>'password',
'database'=>'database'));
// get a result set
$result=$db->query('SELECT * FROM users');
$resultController=new ResultController('xml');
$mysqlResult=new MySQLResult($resultController,$result);
$outputGenerator=new outputGenerator($mysqlResult);
echo $outputGenerator->generateOutput();

/* displays the following:

<users>
    <user>
        <id>1</id>
        <name>user1</name>
        <email>user1@domain.com</email>
    </user>
    <user>
        <id>2</id>
        <name>user2</name>
        <email>user2@domain.com</email>
    </user>
    <user>
        <id>3</id>
        <name>user3</name>
        <email>usuario1@domain.com</email>
    </user>
    <user>
        <id>4</id>
        <name>user4</name>
        <email>usuario4@domain.com</email>
    </user>
    <user>
        <id>5</id>
        <name>user5</name>
        <email>usuario5@domain.com</email>
    </user>
</users>
*/

// return result set as plain text
// connect to MySQL
$db=new MySQL(array
('host'=>'host','user'=>'user','password'=>'password',
'database'=>'database'));
// get a result set
$result=$db->query('SELECT * FROM users');
$resultController=new ResultController('plain');
$mysqlResult=new MySQLResult($resultController,$result);
$outputGenerator=new outputGenerator($mysqlResult);
echo $outputGenerator->generateOutput();

/*
displays the following:

ID: 3 Name: user1 Email: user1@domain.com
ID: 4 Name: user2 Email: user2@domain.com
ID: 5 Name: user3 Email: user3@domain.com
ID: 6 Name: user4 Email: user4@domain.com
ID: 7 Name: user5 Email: user5@domain.com
ID: 8 Name: user6 Email: user6@domain.com
*/

Final thoughts

In this last part of this series, you've hopefully learned how to apply the MVC schema with PHP to handle MySQL data sets and generate different views or outputs from it. As I said before, this is only an introduction to this huge subject, therefore if you want to go deeper into it, there's plenty of information on the web. See you in the next PHP tutorial!