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.-
1592 total visitsDatabase Queries package is an abstraction for executing database queries or stored procedures depending on the database.This class is based on factory design pattern that is used to choose which of the supported database interface classes it will use.Currently, the package comes with classes to execute MySQL and MS SQL server database queries or stored procedures. One can extend this ... -
1186 total visitsDBSync provides a way to synchronize the schema of one or more databases from the schema of a master database. Currently, the class only synchronizes the database schema, not data in the database tables.For now DBSync supports MySQL databases but the schema manipulation functions are implemented in a separate driver class. Therefore, support for other types of databases can be ...
-
1847 total visitsThis abstract wrapper class provides easy and simple class methods to access the most important db function. It implements the functionality for databases like MYSQL, POSTGRESQL or SQLITE.anyDB provides a wrapper for PEAR, PHPLIB, ADOdb and METABASE and enables you to switch between these db abstraction layers with only changing a single line of code. You gain the possibility to ...
-
1139 total visitsODBC Basic is a basic wrapper around ODBC API to retrieve information about the tables of a database.It can establish a connection to the database, retrieve the number of existing tables, retrieve the names of the table columns and retrieve the data in all the columns of a table.
-
1747 total visitsPHP Auth is meant to manage the records of a directory of users and provide users authentication services.It can create, edit, delete and search a directory of users with properties stored in records of a SQL database. It provides pre-built registration and user record editing HTML forms.PHP Auth may also authenticate a user presenting a login form and logout the ...
-
2104 total visitsMySQL Dump can be used to generate a dump of the structure and data contained in a given MySQL database.It generates a string that contains of SQL statements that when executed can recreate the structure of tables as well the contents of its rows.Therefore, MySQL Dump can be used to generate backup copies of a given MySQL database.
-
1433 total visitsMySQL Dialog is a simple MySQL database access wrapper to execute SQL queries and display results in HTML tables.The class connects to a MySQL Server, sends SQL statements and gets the results as an array. A table with the data from the result sets can be displayed too.MySQL Dialog may optionally returns error messages on failure based on the mysql_error() ...
-
1827 total visitsAdministrator module that uses a class file to add/edit/delete entries from a mysql database. Also has image support so you can upload an image with your entry as well. Auto-resizes image to a thumbnail as well.
-
2128 total visitsMySQL stored procedures emulates stored procedures for MySQL databases used (MySQL) client side files to define the SQL code of the procedures. It executes simple queries defined within a named block, known as "stored procedure".The query syntax within a stored procedure is compliant with standard SELECT, INSERT, DELETE and UPDATE MySQL queries, but it does not accept sub-select queries like ...
-
1605 total visitscDB is a class for easy access MySQL databases.cDB Class includes:- Internal timming for benchmarcks- isRsEmpty - checks if resultset is empty (fast)- getRows - similar to getRows of asp ADO (easy loop regs with foreach)- debugMode
-
1593 total visitsbase_mysql uses only methods avoiding a direct access to the internal variables (means no public variables).Features of base_mysql:- Debug messages (can be activate or not);- Error handling (can be activate or not);- Basic MySQL functions.The main idea of base_mysql is to use only methods avoiding a direct access to the internal variables (means no public variables).
-
1463 total visitsPerfect Database File is meant to manage a database that stores its tables in files.It uses only PHP file access functions, so it does not require special extensions. It may be useful if you do not want or you do not have access to database servers like MySQL or PostgreSQL.Perfect Database File provides SQL support to perform database queries: SELECT, ...
-
1804 total visitsAccess MySQL database is a simple wrapper to access MySQL databases.Access MySQL database provides functions to establish connections, execute select queries sorted by the primary key value, insert table rows using given values, retrieve the primary key of the last inserted record, delete table rows given the primary key value, retrieve the number of affected rows by a query, count ...
-
1652 total visitsMySQL backup class is an easy way to move, back up and restore you mysql databases. You can easily backup your mysql database in text files and restore them again.
-
1582 total visitspdbc implements a database abstraction interface to access databases very similar to Java JDBC. It provides separate classes for managing drivers, classes for managing connections, classes for executing queries with normal SQL statements or prepared statements, classes for retrieving the query results and also utility classes for managing string buffers and array vectors.Currently pdbc comes only with MySQL driver classes, ...
