-
1925 total visitsmygrid extends the GtkListStore to display the results of a given MySQL query in the columns of the list.Custom names can be assigned to the list columns. Then mygrid traverses a given MySQL query result set and fills the list rows with data from the result set data.Requirements: PHP 5.1 or higher -
1831 total visitspgsql_dbconnect eases the connection process in pgsql via OOP.
-
1443 total visitsClasses for accessing databases, generating page output using templates, update pages without page reloading using AJAX, generate activity logs, are provided.Requirements: PHP 4.3.2 or higher
-
1678 total visitsSeveral types of common queries can be run with a single call by using eventual parameters to define queries that take variable values.Key Features of My One Line SQL:- SELECT what FROM tablename- SELECT what FROM tablename WHERE where_expression- SELECT what FROM tablename ORDER BY order_expression ASC/DESC- SELECT what FROM tablename WHERE where_expression ORDER BY order_text ASC/DESC- SELECT what FROM ...
-
1932 total visitsTable records can be inserted or updated using a list of table field values.Key Features of Flash SQL:- Delete table records that match a given condition- Retrieve a table field values of records that match a given condition- Create a table with a list of fields- Execute an SQL query and return results formatted in a suitable format for use ...
-
1617 total visitsSQL SELECT, INSERT, UPDATE and DELETE queries can be generated with the specified table name, arrays of fields and corresponding values and the additional clauses.Requirements: PHP 4.0 or higher
-
2005 total visitsMM::CDatabase is an abstract class that can be used to execute SQL queries with parameters. It allows loading queries defined in files.The query parameters are defined in arrays that associate parameter names with the respective values.To use MM::CDatabase there needs to be a sub-class that implements several functions that use database specific API calls. Those functions implement query execution, result ...
-
1864 total visitsezMySQL can read and display the list of tables and their fields, as well the stored procedures of a given MySQL database.The code of a given procedure can also be created, updated, dropped or listed.Requirements:PHP 3.0 or higher
-
2006 total visitsTrue MySQL class can connect to a specified MySQL host, execute SQL queries and retrieve the results into arrays or objects.Key Features of True MySQL class:- Seek SQL query result sets- Get the number of affected rows and the identifier of the last record inserted by a query- Retrieve the names of table fieldsRequirements: PHP 5.0 or higher
-
1560 total visitsSimple PHP SQL Class creates an object of a driver class and takes care of calling the appropriate driver class functions. A MySQL driver class is built in.Key Features of Simple PHP SQL Class:- Establish database connections- Access a given database- Execute SQL queries- Retrieve query results into an arrayRequirements: PHP 5.0 or higher
-
1927 total visitsMySQL_Control class allows you to manage various queries for a MySQL database. It is easy to use and also has advance features.MYSQL::Connect() connects. MYSQL::Run() runs a query. MYSQL::Select($tablename, $fields, $cond) runs a select query, MYSQL::SelectSet($tablename, $fields, $cond) returns the results as an array of hashes.MYSQL::Insert($tablename, $var) inserts values in a hash into the database or many different records if it ...
-
1505 total visitsThis class can be used to manipulate flat file databases.It uses the DBA extension to perform several types of operations like inserting new records. retrieve all records, retrieve a record with a given key, delete all records, and delete a record with a given key.The code and the comments are in Spanish.Requirements: PHP 4.0 or higher
-
1951 total visitsA MySQLi object that establishes the database connection is created. Pablosky MySQL executes SQL queries, retrieve results into arrays, retrieve the number of result rows, result column names and last inserted identifier.When an error occurs, Pablosky MySQL throws exceptions.Requirements: PHP 5.0 or higher
-
1939 total visitsQuick Non DB MySQL Alternative is suitable for environments or scenarios where an SQL-based database engine is not available.There are classese for managing Web page content and application users. They store and retrieve content and user records in files.Quick Non DB MySQL Alternative can perform basic operations of adding, retrieving, updating and deleting records.Requirements: PHP 5.0 or higher
-
1924 total visitsSPA Simple Paging Class can take a given SQL query or the name of a table to be queried and computes the total number of results that it would return.SPA Simple Paging Class takes the limit of query results to display and the number of the current listing page, and returns the SQL query string with a limit clause to ...
