-
2501 total visitsPHP DataGrid can be used to display a 2-dimensions array of data as a grid. Bi-dimensional arrays are traversed and the data is displayed in an HTML table. The columns names in the table header row are configurable. The listing may be sorted when the user clicks on the header row cells. Custom columns may be added at the start ... -
1795 total visitsThe common connection and database access functionality is provided by a base class with postgreSQL.Key Features of postgreSQL:- Establish connections- Execute SQL queries- Traverse and retrieve query results- Manage transactions- Access sequences- Execute SELECT, INSERT, UPDATE and DELETE statements using values passed programmatically.Requirements: PHP 5.0 or higher
-
1870 total visitsPHP bans and trap can list, add, update and delete records of a MySQL database table with information about banned IP addresses. Forms that allow creating or updating records of banned IP addresses can be generated.PHP bans and trap can also look up the database to check whether a given IP or host address are banned. The class can issue ...
-
1779 total visitsDatabase servers down alarm can check one or more database servers by connecting to them to see if they are up or down.Database servers down alarm can send an alert e-mail or SMS message to the systems administrators when a database server is down. When the database server is up, another alert message is sent.MySQL, Mini-SQL, Microsoft SQL Server, IBM ...
-
1551 total visitsThere is a base class that provides abstract range calculation based on the number of page and number of result rows per page to retrieve. The iterator interface is also implemented to traverse query result rows. Limit Result Set Iterator also comes with an implementation class to execute and retrieve result set rows from MySQL databases. Requirements:PHP 5.0 or higher
-
1943 total visitsSQL Parse Convert to Tree Array takes a given SQL query and parse it to extract the structure or queries and sub-queries. The resulting structure is returned as an array. SELECT, INSERT, UPDATE and DELETE queries are currently supported. Requirements: PHP 4.4 or higher
-
1404 total visitsA primary class handles the basic functionality like connecting to the MySQL database, executing queries, retrieving results and managing transactions. A sub-class can insert, update, delete and retrieve database records given parameters that define tables, fields, field values and conditions. Requirements: PHP 3.0 or higher
-
1789 total visitsImages can be read from files and stored in a MySQL database and vice-versa with Easy Image DB Management. The main class can also convert images between GIF, JPEG and PNG formats, as well resize the images to create thumbnails. Requirements: PHP 3 or higher
-
1793 total visitsbackup & restore database can generate a backup file that contain SQL statements to create all the database tables and insert its table record data. Previously generated SQL backup files can be read and executed to restore the database tables and records. Requirements: PHP 5.0 or higher
-
2137 total visitsDba Wrapper can perform multiple operations and optimize a flat file database file. Key Features of Dba Wrapper:- Open a given flat file database- Insert a new record with a given key- Get a record with a given key- Replace the value of a record with a given key- Delete the record with a given key Requirements: PHP 4.0 or ...
-
1980 total visitsMpQuery can parse a query string to locate % marks that define where parameter values should be inserted. The script uses the printf function format parameter syntax, so the characters following the % marks define the types of the parameters. The MpQuery can also be executed by replacing the marks and properly escaping the query parameter values, depending on their ...
-
1988 total visitsAll tables and text fields are retrieved from a MySQL database with Search DB. The script can execute SQL queries that search for records in all tables and all their text fields that contain the given word in their values. Search DB displays the value of the first table field of all records that were found as result of the ...
-
1829 total visitsUltimate DB Access Wrapper can create table indexes. Key Features of Ultimate DB Access Wrapper:- Establish database connections- Validate SQL queries- Execute SQL queries and fetch result rows into arrays or objects- Build SQL queries from lists of parameters- Manage transactions- Display query results in HTML tables made of DIV tags Requirements: PHP 4 or higher
-
1976 total visitsConvert MySQL tables to PHP class retrieves the list of tables and information about their fields from a specified MySQL database. It can generate code for classes that can be used to access the respective MySQL table records as if they were objects. The generated classes can have getter and setter functions for each table field, functions to insert or ...
-
1813 total visitsPHP Scaffolder generates a PHP script that can be used to insert, list, update and delete records in a given MySQL table. Separate classes are used by the script to generate and validate forms, as well as display table records in paginated listings. Requirements: PHP 4 or higher
