Login   Register  
PHP Classes
elePHPant
Icontem

PHP-MYSQL-MSSQL: The Class for PHP2MYSQL or PHP2MSSQL

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 (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2003-05-08 (11 years ago) RSS 2.0 feedStarStarStar 57%Total: 7,146 This week: 1All time: 244 This week: 1,319Down
Version License Categories  
databases 1.0.0GNU General Public Lice...Databases
Description Author  

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.

Picture of henryi
Name: henryi <contact>
Classes: 2 packages by
Country: Taiwan Taiwan
Age: 36
All time rank: 3142 in Taiwan Taiwan
Week rank: 1043 Down3 in Taiwan Taiwan Down

  Files folder image Files  
File Role Description
Accessible without login 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
Accessible without login Plain text file setting.inc.php Conf. setting of this class

 Version Control Unique User Downloads Download Rankings  
 0%Total:7,146All time:244
 This week:1This week:1,319Down
User Ratings User Comments (1)  
 All time
Utility:85%StarStarStarStarStar
Consistency:78%StarStarStarStar
Documentation:-
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:57%StarStarStar
Rank:1063
 
very nice work.
5 months ago (Ashok kumar kashyap)
70%StarStarStarStar