Login   Register  
PHP Classes
elePHPant
Icontem

File: index.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sarfraz Ahmed  >  QuickDB  >  index.php  >  Download  
File: index.php
Role: Example script
Content type: text/plain
Description: example file
Class: QuickDB
Query MySQL using values passed pragmatically
Author: By
Last change: ++ Added fetch_value function to fetch a single value directly
++ last_query function now print last run query in a alert box
Date: 5 years ago
Size: 5,280 bytes
 

Contents

Class file image Download
<?php

    
// This file uses most of the functions of QuickDB MySQL wrapper.
    // It is very easy to use these funtions (methods), see below examples.
    // Once you know how to use this, i bet you are gonna use it in future as well :)

    
require_once "quickdb.class.php";
    
// Argumentd are: host, user, password, database, persistent connection, show errors on screen
    
$db = new QuickDB("localhost""root""""test"falsetrue);
    

    
## execute Method/Function
    // it can run any query whether select, insert, update or delete like mysql_query function
    
    // returns:
    // 1) resource identifier for "Select query" that can later be used with mysql_fetch_array or mysql_fetch_object
    // 2) number of rows affected for "insert, update or delete" queries        

                                                                                                            // Usage Of:
                                                                                                            // --------------------------

    
$result $db->execute("select * from quickdbtest order by catname");                                    // $db->execute
    // Or
    //         $result = $db->select("quickdbtest");                                                            // $db->select
                
    
while ($row mysql_fetch_array($result))
    {
        print 
$row["catname"] . "<br />";
    }

    print 
"<br />Number of rows selected from previous query : " $db->count_select();                        // $db->count_select()

    
$affected $db->execute("insert into quickdbtest set catname = 'New Category'");
    
// Or
    //        $affected = $db->insert("quickdbtest", "catname = 'New Category'");                                // $db->insert

    
print "<br />Number of rows affected are: $affected";
    
// Or
    
print "<br />Number of rows affected using class method: " $db->count_affected();                        // $db->count_affected()
    
$db->success_msg("Record was added successfully !!");

    
$affected $db->update("quickdbtest""catname = 'New Category 2'""catname = 'New Category'");        // $db->update
    
print "<br />Number of rows affected are: $affected";
    
    
$db->delete("quickdbtest""catid = " $db->last_insert_id());                                            // $db->last_insert_id(), $db->delete
    
print "<br />Number of rows affected using class method: " $db->count_affected();
    
    print 
"<br />Total records in table are: " $db->count_all("quickdbtest");                                // $db->count_all
    
    
print "<br />Counting records using 'count_rows' : " $db->count_rows("select * from quickdbtest");    // $db->count_rows
    
    // $db->insert_update will update if row exists, or insert data if it doesn't with catid=5
    
$affected $db->insert_update("quickdbtest""catname='Test Category'""catid=5");                    // $db->insert_update
    
print "<br />Number of rows affected are: $affected<br />";
    
    
$result $db->select_limited("quickdbtest"41);                                                        // $db->select_limited

    
while ($row mysql_fetch_array($result))
    {
        print 
$row["catname"] . "<br />";
    }

    
    if (
$db->has_rows("quickdbtest"))                                                                        // $db->has_rows
    
{
        print 
"This table is not empty, it has rows in it !!";
    }
    else
    {
        print 
"Oops, the table is empty !!!";
    }


    if (
$db->row_exists("select * from quickdbtest where catid = 5"))                                        // $db->row_exists
    
{
        print 
"<br />Yes, row exists";
    }
    else
    {
        print 
"<br />No, row does not exist";
    }

    
// fetch a single row from db
    
$row $db->fetch_row("select * from quickdbtest where catid = 1");                                        // $db->fetch_row
    
print "<br />The fetched values are: " $row->catid " " $row->catname ;

    
// fetch a single row from db
    
$catname $db->fetch_value("quickdbtest""catname""catid = 3");                                        // $db->fetch_value
    
print "<br />The fetched value is: " $catname;
    
    print 
"<br /> The date today is: " $db->get_date();                                                    // $db->get_date()
    
print "<br /> The current time is: " $db->get_time();                                                    // $db->get_time()
    
    // $db->last_query() gives the last run query, may be useful for debugging queries
    
print "<br /> The last run query was: <strong>" $db->last_query()  . "</strong><br /><br />";

    
// using very useful $db->load_data()
    
$db->select("quickdbtest");                                                                                // $db->select
    
$data $db->load_array();                                                                                // $db->load_array()
    
print_r($data);
    
/////////////////////////
    
    // using another very useful function that convert db table to a html table
    
$db->get_html("select * from quickdbtest order by catname" true'width = 50%, align="center"');        // $db->get_html
    
    
print "<br /><strong>Database Tables</strong><br />";
    
$db->list_tables();                                                                                        // $db->list_tables()

    
print "<br /><strong>Table Information</strong><br />";
    
$db->table_info("quickdbtest");                                                                            // $db->table_info
    
    
    
$db->success_msg("Wow, this is cool class !!");                                                            // $db->success_msg
    
    // just a wrong table to get that error
    
$db->count_rows("select * from NO_TABLE");
    
$db->display_errors();                                                                                    // $db->display_errros()
    
    
$db->failure_msg("Oops, i must have received the error !!");                                            // $db->failure_msg
    
    
$db->alert_msg("This is general alert message !!");                                                        // $db->alert_msg
    





    
print "<br /><br /><br />" $db->success_msg("<STRONG>REQUEST:</STRONG> IF YOU LIKE THIS THEN PLEASE GO AHEAD AND <a href='http://www.phpclasses.org/browse/package/5318.html'>RATE</a> THIS AT PHPCLASSES.ORG, THANKS :)") . "<br /><br />";



?>