Login   Register  
PHP Classes
elePHPant
Icontem

PHP-MYSQL-MSSQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of henryi  >  PHP-MYSQL-MSSQL  >  Download .tar.gz .zip  >  Support forum Support forum (2)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: PHP-MYSQL-MSSQL
Base name: databases
Description: The Class for PHP2MYSQL or PHP2MSSQL
Related classes: , , , , , , ,
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 6824 users
All time rank: 228
Week users: 14 users
Week rank: 160
 

  Author  
Picture of henryi
Name: henryi <e-mail contact>
Packages: 2 Browse all classes by henryi Browse all classes by
Country: Taiwan Taiwan - PHP jobs in Taiwan
Age: 33
All time rank: 2912 in Taiwan Taiwan
Week rank: 186 Up1 in Taiwan Taiwan Up


  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.

  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (82.7%)
Sufficient (78.8%)
-
Sufficient (73.1%)
-
-
Not sure (56.5%)
1047
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 folder image 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.