PHP Classes

File: aguencyentries.cls.php

Recommend this page to a friend!
  Packages of Duy A. Nguyen   Small MySQL Connection   aguencyentries.cls.php   Download  
File: aguencyentries.cls.php
Role: Application script
Content type: text/plain
Description: sample class
Class: Small MySQL Connection
MySQL database access wrapper
Author: By
Last change:
Date: 20 years ago
Size: 1,192 bytes
 

Contents

Class file image Download
<?php
class AguEncyEntries extends MagicObject implements IRenderHTML
{
    private $table_name;
    
      function __construct() 
    {
          global $g_config;
        
        $this->table_name = $g_config['table_prefix'] . 'entries';
       }
    
    public function loadByName($cond_name)
    {
          $sql = "select id, name, description, screenshoot, iscat, parentid from $this->table_name where name like ?";
          
          $db = MySQLConnection::init();
        
        $ret = $db->executeQuery($sql, $cond_name . '%');
        
        if( $ret )
        {
            $count = count($ret);
            
            for( $i = 0 ; $i < $count; $i++ )
            {
                $this->data[$i] = new AguEncyEntry();
                $o = &$this->data[$i];
                
                $o->id = $ret[$i]['id'];
                $o->name = $ret[$i]['name'];
                $o->description = $ret[$i]['description'];
                $o->screenshoot = $ret[$i]['screenshoot'];
                $o->iscat = $ret[$i]['iscat'];
                $o->parentid = $ret[$i]['parentid'];
                
            }
            
            return $count;
        }
        
        return false;
    }
    
    public function outputHTML()
    {
//          $count = count($this->data);
//          foreach($this->data as $key => $row)
//              $row->outputHTML();
        echo('<pre>');

        var_dump($this->data);
        echo('</pre>');
    }
}

?>