PHP Classes
elePHPant
Icontem

mysqlix: Manage MySQL database tables

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 (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2007-07-29 (8 years ago) RSS 2.0 feedNot enough user ratingsTotal: 633 All time: 4,690 This week: 1,420Up
Version License PHP version Categories  
mysqlix 1.0Public Domain5.0PHP 5, Databases
Description Author  

This class can be used to manage MySQL database tables.

It extends the MySQLi base class to add new functionality like:

- Inserting, updating and retrieving MySQL table rows from a list of parameters
- Creating and dropping databases, tables and triggers
- Adding table columns
- Retrieving table comments

Picture of Anton Rifco
Name: Anton Rifco <contact>
Classes: 1 package by
Country: Indonesia Indonesia
Age: 28
All time rank: 272248 in Indonesia Indonesia
Week rank: 1493 Up22 in Indonesia Indonesia Up

Details provided by the author  
mysqlix extended mysql improved
===================================

Version 1.0
Copyleft Anton Rifco Susilo

Send bug reports, patches, feature requests, complaints & hate mail (no spam
thanks) to <anton.rifco@gmail.com>

##### See INSTALL for installation instructions. #####


Table of Contents:

1. Overview
2. Features
3. Requirements
4. Limitations (Known Issues)
5. Usage
6. Todo

Overview
--------
mysqlix is extended class of mysqli predefined class. It add some valuable function that will save your work.


Features
--------

* Creating and dropping trigger

* Creating and dropping database

* Creating and dropping table

* Simple insert and update on a table of database

* Semi-advanced php-mySQL select

* Retrieve comment on a table, or all tables in a database

* Function to make multi query secure, by combine commit and rollback

Requirements
------------

* PHP 5.0.0+


Limitations (Known Issues)
--------------------------


Usage
-----

Read class documentation and example (file example.php) to experience usage on this class


Todo
----

I will add more function to this class, perhaps like 
- create_view to create a mySQL view,
- dump database/table 
- source/load sql file
- create_function to create a mySQL stored function / procedure
- improve function create_table
- a function to select data from multi table
- improve insert and update function
- Adding LOCK and UNLOCK to mySQL script



That's it!  Have fun!


Send questions, problems, bug reports, etc to:

Anton Rifco Susilo <anton.rifco@gmail.com>


  Files folder image Files  
File Role Description
Plain text file mysqlix.class.php Class Class mysqlix extends mysqli
Accessible without login Plain text file example.php Example example how to use mysqlix class
Accessible without login Plain text file INSTALL Doc. describe how to use this class to your project
Accessible without login Plain text file README Doc. readme file

 Version Control Unique User Downloads Download Rankings  
 0%Total:633All time:4,690
 This week:0This week:1,420Up