PHP Classes

ai_DB_table: Access and manipulation of MySQL table records

Recommend this page to a friend!
  Info   View files View files (13)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 40%Total: 2,435 This week: 1All time: 1,595 This week: 560Up
Version License Categories
ai_db_table 1.0GNU General Publi...HTML, Databases
Description 

Author

This class provides functionalities for dealing with MySQL DB tables hiding some complexities related with the use of SQL commands. It is based upon the PHPLIB MySQL class.

It abstracts record sets so you can easily select, insert, delete and modify rows into the table on a per row basis.

Data conversion support and some basic formatting are provided.

Since the class is Web-oriented, it also provide methods for HTML output generation.

Picture of Andrea Iacoponi
Name: Andrea Iacoponi <contact>
Classes: 1 package by
Country: Italy Italy
Age: 57
All time rank: 127450 in Italy Italy
Week rank: 411 Up18 in Italy Italy Up

Details

DESCRIPTION This class provides basic funcionalities for working with a MySQL database and HTML forms. INSTALLATION Unpack the library: the library is contained in the INC directory In the library there is a spy-ware code that collects statistical informations about the use of this class. You can disable it if you want; details are contained in the documentation. DOCUMENTATION The documentation of the class is contained in the TEST directory. To read it you should create a MySQL database named "aiTools", otherwise you can read it online from the http://phpdev.antitesi.it site. A trimmed version, not interactive, is contained in the <tt>manual.html"</tt> file. LICENSE This library is licensed under the GPL terms; you can read it in the Free Software Foundation site. COPYRIGHT Copyright (C) 2003: Andrea Iacoponi This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

  Files folder image Files  
File Role Description
Plain text file ai_datetime_fld.inc.php Class Field data type
Plain text file ai_date_fld.inc.php Class Field data type
Plain text file ai_DB_field.inc.php Class Field base class
Plain text file ai_DB_link.inc.php Class DB connection
Plain text file ai_DB_table.inc.php Class Main class file
Plain text file ai_enum_fld.inc.php Class Field data type
Plain text file ai_flag_fld.inc.php Class Field data type
Plain text file ai_numeric_fld.inc.php Class Field data type
Plain text file ai_text_fld.inc.php Class Field data type
Accessible without login Plain text file include.inc.php Aux. Conditional include of field data type
Accessible without login HTML file manual.html Doc. Developer manual
Plain text file phplib_mysql.inc.php Class PHPlib MySQL class
Accessible without login Plain text file README Doc. Informations

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,435
This week:1
All time:1,595
This week:560Up
User Ratings User Comments (1)
 All time
Utility:58%StarStarStar
Consistency:58%StarStarStar
Documentation:58%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:40%StarStarStar
Rank:3697
 
Good Job!!!
14 years ago (Henry Tejera)
55%StarStarStar