Login   Register  
PHP Classes
elePHPant
Icontem

File: 01_mysql_listing_sample.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of J.B.  >  Simple Object  >  01_mysql_listing_sample.php  >  Download  
File: 01_mysql_listing_sample.php
Role: Example script
Content type: text/plain
Description: SimpleObject in use: list MySQL table records in three lines of code
Class: Simple Object
Base class with common variable access functions
Author: By
Last change: Changed require_once('mysqlresultiterator.php'); to require_once('simplemysqlresultiterator.php');
Date: 10 years ago
Size: 1,621 bytes
 

Contents

Class file image Download
<?php
    
#    This script shows how use of SimpleObject and its child classes
    #    may ease your programming
    
    #    TASK 1 - List all mysql table records
    
    #    include all required classes
    
require_once('simpleobject.php');
    require_once(
'simpleiterator.php');
    require_once(
'simplemysqlresultiterator.php');
    require_once(
'simpletemplate.php');
    require_once(
'listtemplate.php');
    
    
#    Connect to mysql
    
mysql_connect('localhost','root','');
    
mysql_select_db('dbname');
    
    
#    Write down your SQL query:
    
$query "SELECT * FROM my_table";
    
    
#    Create an instance of list template:
    #    Send an instance of MysqlResultIterator as argument
    
$list_tpl =& new ListTemplate(new SimpleMysqlResultIterator($query));
    
    
#    Set title (variable in template) to list
    
$list_tpl->set('list_title','What a Simple List!');
    
    
#    Display the list of items:
    
$list_tpl->display('list_template.html','item_template.html');
    
    
#    That's it!
    
    #    Don't forget to make list_template.html and item_template.html
    #    files such that they have markers like <!--$field_name--> in
    #    item_template.html and <!--$list--> and <!--$list_title-->
    #    in list_template.html. <!--$list--> will be replaced by output
    #    of item listing:
    
    /*
        list_template.html:
        
        <h1><!--$list_title--></h1>
        <p>Here are the records from table:</p>
        <table>
        <tr>
            <th>record id</th>
            <th>record title</th>
        </tr>
        <!--$list-->
        </table>
        
        
        item_template.html:
        
        <tr>
            <td><!--$id--></td>
            <td><!--$title--></td>
        </tr>
        
        
        !! modify id and title to names of fields in your mysql table
    */
?>