PHP Classes
Icontem

Class: PHP-MYSQL-MSSQL


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of henryi  >  PHP-MYSQL-MSSQL  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  
  • Supplied by:

    Picture of henryi
    Name: henryi <e-mail contact>
    Published packages: 2
    Country: Taiwan Taiwan - PHP jobs in Taiwan
    Home page: http://hsdn.net/
    Age: 30
    All time rank: 265
    Week rank: 420

    Browse this author's classes

  • Groups:

    Group folder image Databases Database management, accessing and searching View top rated classes
  • Detailed description:

    This class is an interface to be used with the PHP programming language to help you
    connect,disconnect,insert,update,delete,query,result and page_cut from MySQL or MSSQL
    more easy.

    You just change the setting.inc.php to suit your environment.
    ($sql_type,$sql_host,$sql_name,$sql_user,$sql_pass,$perpage)
    this file is independence so you can setup other variables at this file.

    If you already have a configuration file you can change the
    var $setting_file = "lib/setting.inc.php";
    to
    var $setting_file = "your configuration file name";


    The latest version of class is 2.0 (update at 2003-05-03 17:00 GMT+8)


    This new version change log as follow:
    1. Add error handling
    2. Modifing the new code format
    3. More useful page cut function
    4. Add the function about getting the ID generated from the previous INSERT operation

    Change Log
    2002-07
    1. Correct page_cut error.
    2. Improve the function nums and function objects these two functions.
    3. The new pgae_cut and show_page_cut functions can let you use these
    functions with your template

    At this version ,this class include follow functions
    1. connection --> Function connection()
    2. disconnect --> Function disconnect()
    3. insert --> Function insert($tb_name,$cols,$val,$astriction)
    4. update --> Function update($tb_name,$string,$astriction)
    5. delete --> Function del($tb_name,$astriction)
    6. query --> Function query($string)
    7. num_rows --> Function nums($string="",$qid="")
    8. object --> Function objects($string="",$qid="")
    9. insert_id --> Function insert_id($qid="");
    10. pagecut --> Function page_cut($tb_name,$astriction,$order,$nowpage="0")
    11. show_page_cut --> Function show_page_cut($query_string)

    Please see the example.php to get more detail about those functions.
  • User ratings:

    Ratings
    Utility
    Consistency
    Documentation
    Examples
    Tests
    Videos
    Overall
    Rank
    All time:
    Good (81.8%)
    Sufficient (77.3%)
    -
    Sufficient (70.5%)
    -
    -
    Not sure (55.7%)
    859
    Month:
    Not yet rated by the users
  • Applications that use this class:

    No application links were specified for this class.
    Add link image If you know an application of this package, send a message to the author to add a link here.
  • Files:

    File Role Description
    Plain text file example.php Example example of this class
    Plain text file mssql.inc.php Class mssql class
    Plain text file mysql.inc.php Class mysql class
    Plain text file setting.inc.php Conf. setting of this class
    Download all files: databases.tar.gz databases.zip
    NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products