PHP Database Tool
Free and open source PHP Database Tools Scripts. These Scripts included MySQL, Oracal, Access help you to make a simplified operation on database.-
MySQL RecordSet class provides automatic erase by ID, erase by Array, check SQL between other functions. The MySQL Connection is required.
-
Hybrid MySQL is a lightweight wrapper to access MySQL databases.Functions of Hybrid MySQL:- Open and close MySQL database connections- Execute SQL queries- Fetch the query results as array, associative arrays or objects- Get number of returned query result rows- Display failure error messages
-
mysqlRecordSet creates a MySQL connection and records set objects with support for error reporting.
-
Recordset is a recordset Class like ADO Recordset (plus DataBase Splitting feature) using ODBC functions.
-
Interprets database schemas which are written in XML. Takes the schema either directly or via a file, parses it, generates the SQL necessary and (optionally) executes the SQL.Works only with MySQL but could be ported to other RDBMS very easily.
-
The purpose of this class is to help in the updating of data stored in database tables. Tablemaint has functions to add, modify, delete and search for data in the database table rows.
-
Class to control the access the pages of a site. It is not necessary MySQL or other database. The class logs warnings and errors to files.
-
cbmysql is meant to let you create, query, alter and dropping MySQL database tables, data and so on. Starting in Version 4 you have both, mysql and mysqli support.After creating an object of this class you can query and modify a MySQL database easily.The select function can be configure the return query result arrays with one or two dimensions and ...
-
swemc can connect of a MySQL database, execute SQL query and output the query results in HTML tables.Functions of swemc:- Execute select, update, insert and delete SQL queries- Output query results in HTML tables that can have their presentation customized with CSS.- Output HTML tables also customizable with CSS with the results of queries that retrieve single database table records- ...
-
PHP-PGSQL class is a database management, accessing and searching tool.Functions of PHP-PGSQL:- connection --> Function connection()- query --> Function query($string)- num_rows --> Function nums($string="",$qid="")- object --> Function objects($string="",$qid="")- insert --> Function insert($tb_name,$cols,$val,$astriction)- update --> Function update($tb_name,$string,$astriction)- delete --> Function del($tb_name,$astriction)
-
memDB is a memory based database manager class that can also dump the information either in a file or a string that useful when you store a memDB in another database.
-
rs2csv can be used to convert a result set which has been generated by PHP's built-in MySQL functions to a comma separated values (CSV) file.
-
MySQL SP is meant to provide an emulation of stored procedures for MySQL.MySQL SP uses template files stored on the database client side that contain multiple SQL statements with special marks that identify placeholders that are replaced by procedure arguments when they are executed.The result of the execution of procedure is an array containing either the handles of the result ...
-
Database conversion is meant to process SQL code with syntax that is specific to certain databases and convert it to SQL code that is database neutral.The goal of Database conversion is to help avoiding the use of SQL code that is not compatible with all the supported databases.Currently Database conversion supports converting SQL code specific to Oracle, MySQL, Microsoft SQL ...
-
Meta Scanner is intended to retrieve metaData from any MySQL Server.It provides methods to retrieve information about all databases managed by a MySQL server including their tables and the respective table fields.Meta Scanner also provides a simple method called showAll that shows metaData in a simple table style representation.

