-
1692 total visitsGenerator of the code can generate scripts to present forms for manipulate MySQL database table records.It can retrieve the list of fields of a given MySQL database table to generate a PHP script that can execute SQL queries to insert, update or delete records of that table. -
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 ...
-
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.
-
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).
-
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.
-
1924 total visitsDBBackup can generate a dump of the definition and contents of a MySQL database.The dump contains SQL statements that can be used to rebuild the database in the state that it is when the dump is generated, so it can be used as a backup that can be restored later.
-
1725 total visitsSession Handler classes implements a session but does not use MySQL as its storage mechanism like other session handling classes do. Instead it uses a directory structure where the session is identified as a directory and keys are files inside of that directory. Each file contains the value assoiciated with the key identified by the file name.This session handler requires ...
-
1630 total visitsMySQL Table Abstraction Class can be used to wrap the access to individual MySQL database table rows in class objects. Each object of the class stores the values of the fields of a given row of a given table. The class provides means to store and retrieve the values of the row fields in the specified table.MySQL Table Abstraction Class ...
-
1646 total visitsMySQL Collection provides you a set of functions to use with your MySQL database.Functions of Log:- log() // Create a log file- addLog() // Append one line in the log file- show() // Show de log content in HTML formatProperties of Connection:- application // Name of application- host // IP or Name of MySQL Server- login // Login MySql- senha ...
-
1709 total visitsA simple class component that creates and fills a listbox from a MySQL database. Assuming ID as the fist field and listbox data as the second. ID will be set as the option (value).
-
1623 total visitsRequest flood protection can be used to detect access floods using a MySQL database to keep track of accesses of site users. It stores in a MySQL database table records of the time and IP address of each access.Request flood protection can detects floods if the last access from the current user IP address occurred in a period less than ...
-
1807 total visitscUser is meant to add, remove and authenticate users with records stored in a database.It comes with module class to manage the storage of users in a MySQL database but it can be replaced with modules to store in other databases.
