-
1306 total visitsphpMyAuth is an easy to use class based on MySQL for developing sites that require the users to login. -
1466 total visitsmysearch class allows you to search MySQL with many options like: Search All Databases, or just one Database, a set the Tables to search or search all tables, etc..
-
1864 total visitsPHP MySQL Error reporting is a simple class that can be used to process errors that occur during an access to a MySQL database.PHP MySQL Error reporting can establish a MySQL database server connection using given database connection parameters. It also provides means to process any errors of execution of failed MySQL database access operations that use the connection established ...
-
1628 total visitsbetter_field_search class is a generalized, flexible class to search a MySQL DB.Features of better_field_search:- You can specify fields to search or display in results.- Allows multiple search terms.- Has a sample form to implement the class.- Easy to implement.- Recently added ability to format results independant of class, modify and/or or search, and search multiple tables (via joins).
-
1533 total visitsphpFormGenerator is a class that can generate scripts to output and process Web forms for entering data to insert as a new row of a given MySQL table.The class takes the resource handle of the result of a query to retrieve the names of the fields of a MySQL database table. Then it uses the result set field names to ...
-
2152 total visitsSimple SQL classprovides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs.ADVANTAGES:- This PHP class file will eliminate nearly all code from the built in std mysql PHP functions.- Speed, it will dramatically ...
-
1464 total visitsMysql Locker can safely manage the locking and unlocking of MySQL tables. The table locks are created when an object of the class is created, and are automatically released when the object is destroyed.The table unlocking occurs when the object is no longer referenced, or when it goes out of scope. The latter also occurs when a PHP script dies ...
-
2096 total visitsai_DB_table provides functionalities for dealing with MySQL DB tables hiding some complexities related with the use of SQL commands. It is based upon the PHPLIB MySQL class.It abstracts record sets so you can easily select, insert, delete and modify rows into the table on a per row basis. Data conversion support and some basic formatting are provided.Since ai_DB_table is Web-oriented, ...
-
1829 total visitsMy Db is a SQL database wrapper supporting MySQL, Interbase and MS SQL server.It can establish database server connections, execute SQL queries, retrieve query results into arrays and display query results as HTML tables.
-
1730 total visitsPaging Class can retrieve and display MySQL database query results split in multiple pages.The paging class generates the HTML for all the navigation links to go to the first, last, next and previous pages, given the total number of records in the result set and the limit number of records to display per page.
-
1553 total visitsMySQL Paginator can be used execute MySQL database SQL queries and display the results split in multiple HTML pages. It can connect to a given MySQL database and execute an SQL table.Then MySQL Paginator can display a limited number of results in an HTML table with links to navigate between the pages that show other parts of the query results.
-
1814 total visitscrosstab is a PHP class which helps you display mysql data in cross-tabular format.All you have to do is :- Alter the connection string provided in crosstab.inc.- Insert the piece of code (provided in try.php) into your program. Change the four parameters according toyour requirements.
-
1018 total visitsAL's simple MySQL record control class is a simple wrapper to create and manipulate MySQL database table records.AL's simple MySQL record control class uses the class variables to store the table key and data column names and values and provides functions to insert new records, update or delete existing records, and check whether a record with the given values already ...
-
2254 total visitsMySql To Excel class is used for exporting the data from a MySql to spreadsheet files in the Excel format. The class executes a given database query and extract the result set data to generate the Excel spreadsheet.The generated Excel spreadsheet can be stored in a given file or be made available immediately for download.
-
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 ...
