PHP Classes
elePHPant
Icontem

MARK_MYSQL: MySQL interface

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2002-12-18 (12 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 1,220 All time: 2,955 This week: 1,067Up
Version License Categories  
class_mysql 1.0GNU General Publi...Databases
Description Author  

A wrapper for MySQL queries. Easy to use.

Picture of Mark Quah
Name: Mark Quah <contact>
Classes: 7 packages by
Country: Singapore Singapore
Age: ???
All time rank: 2461 in Singapore Singapore
Week rank: 1493 Down3 in Singapore Singapore Down

Details provided by the author  
Another unpolished class. Those take time to polish it up please do inform me.

This class has been used extensively in my web project and I really find that it is very much convenient to use.

This is the way to use it:
------------------------------------------------
INITIALIZATION:
    include_once "class_mysql.php";
    $my_db = new MYSQL("server", "user", "passwd", "database to use");
------------------------------------------------
DO A QUERY EXPECTING INPUT
    $stmt = "SELECT * ....";
    $status = $my_db->RunDB($stmt);
    if ($status != "OK") { echo "FAIL"; die; }
now the number of records retreived is stored in
    $no_rec = $my_db->no_rows;
to retrieve individual fields, say field name is "A", "B", C"
    for ($i = 0; $i < $no_rec; $i ++)   // record number
    {    $fieldA=$my_db->row[$i]['A'];
         $fieldA=$my_db->row[$i]['B'];
         $fieldA=$my_db->row[$i]['C'];
         ... do your processing.
    }
IF you don't know about the field names, here's what you can do:
    for ($j = 0; $j < $my_db->no_fields; $j ++)
       $field_name[j] = $my_db->field[$j];
no_fields contains no of fields within a record. each field name is contained in $my_db->field[$j]

---------------------------------------------------
DO A SQL STATEMENT NOT EXPECTING OUTPUT

If you do a insert or update, you do not expect the array $my_db->row to be filled, so you specify a 0 after the RunDB statement:
    
      $stmt="INSERT INTO table (a,b,c) VALUES(1,2,3);";
      $status = $my_db->RunDB($stmt, 0);
      if ($status != "OK") { echo "FAILED: $status"; die; }

------------------------------------------------------
USE THE BUILT IN HTML OUTPUT

Pretty but seldom used function. This is for me to displayed an unknown SQL table data.

    $status = $my_db->RunDB("select * from user;");
    if ($status != "OK")
    {   echo "<HR>DB Error: $status.<HR>";
        die;
    }
    $mysql->ShowHTML("table_header","row header","cell header");

The HTML output will be something like:
   <TABLE table_header>
   <TR row_header>
   <TD cell_header> value ....









  Files folder image Files  
File Role Description
Plain text file class_mysql.php Class MySQL wrapper
Accessible without login Plain text file class_mysql_sample.php Example Sample script
Accessible without login Plain text file README.TXT Doc. Readme

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,220All time:2,955
 This week:0This week:1,067Up