PHP Classes
elePHPant
Icontem

ai_DB_table: Access and manipulation of MySQL table records

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 (13)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2003-11-27 (11 years ago) RSS 2.0 feedStarStarStar 40%Total: 2,413 All time: 1,519 This week: 1,201Up
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: 48
All time rank: 118943 in Italy Italy
Week rank: 1554 Down67 in Italy Italy Down

Details provided by the author  
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,413All time:1,519
 This week:0This week:1,201Up
User Ratings User Comments (1)  
 All time
Utility:58%StarStarStar
Consistency:58%StarStarStar
Documentation:58%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:40%StarStarStar
Rank:2200
 
Good Job!!!
5 years ago (Henry Tejera)
55%StarStarStar