Executed

Tables, table fields can be added or joined, as well as search conditions.Relevant Search in MySQL can assemble the SQL query that is returned as a single string ready to be executed.

A connection to a MySQL database is opened and several types of SQL queries are built and executed.Key Features of MYDB Class:- SELECT queries given the table, list of fields and an optional condition clause- INSERT or UPDATE queries given the table, list of fields and values and an optional...

MySQL DB Backup can be used to create backup files of MySQL databases in the form of lists of SQL statements that can be executed to restore the database.MySQL DB Backup can store the backup data in compressed or uncompressed files directly, instead of concatenating the whole data in a text...


Platforms: PHP

This PHP script provides a simplified database access interface by extending PEAR::DB class. DB factory extension can be used to establish connections returning a boolean success value instead of PEAR error object.The script executes queries automatically connecting to a database before executing...


Platforms: PHP

SQL Engine can execute SELECT, INSERT, UPDATE and DELETE queries. It takes care of emulating auto-increment fields if these are not supported, using sequences.SQL Engine can also create a new database table or alter its fields if the table already exists. A separate class can be used to log the...


Platforms: PHP

MpQuery 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...


Platforms: PHP

A connection to a specified MySQL server is established and SQL queries are executed.Key Features of WG DB Class:- Retrieve query results into arrays- Retrieve the result set number of rows, last inserted identifier or the number of affected rows- Check if a database table record exists matching...


Platforms: PHP

sqlCache API Library is a free PHP cache script created to increase database application performance by avoided to access databases to retrieve the results of queries being executed repeatedly. It can be used to cache the results of SQL database query results in file.This script provides an API...


Platforms: PHP

This class can be used to execute MySQL queries read from files.It can open a given text file and read its lines with SQL statements to be executed.


Platforms: PHP

Entire Class/Functions is a connection to a MySQL server can be established and SQL queries can be executed.Here are some key features of Entire Class/Functions:- Retrieve query results into single value variables or arrays- Execute queries to retrieve and display paginated listings


Platforms: PHP

backup & 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.


Platforms: PHP

Reduced MySQLi is composed by two classes:- one class is handling the MySQL database access and makes sure that only one connection is active during the script execution.- Another class implements other database access functions like executing queries with prepared queries, measuring the time the...


Platforms: PHP

kisDB, a list of database tables can be retrieved.Key Features of kisDB:- Establish MySQL database server connections- Execute SQL queries from lists of parameters- Display debug output of the executed queries


Platforms: PHP

MySQL DB Management Class can access a MySQL database and execute SQL queries retrieving the results into arrays in a single call.MySQL DB Management Class can also show links to browse the query results split among multiple pages.INSERT and UPDATE can be executed from lists of parameters.


Platforms: PHP

db_bibivu is a simple MySQL database access wrapper. It provides functions for connecting to a MySQL database server, select the database to access, execute queries, retrieve query results rows in arrays, execute a query to return a single result row in a single call, etc...db_bibivu may...


Platforms: PHP

IdealMySQL Class, a connection can be established to a MySQL server and SQL queries can be executed.Key Features of IdealMySQL Class:- Return the affected rows for manipulation queries like INSERT, DELETE. UPDATE, REPLACE and DROP- Return query result set handles for data retrieval queries like...


Platforms: PHP

A connection to a specified MySQL database can be established and a given SQL query can be executed.DB Connect with XML can retrieve the query results and generate a XML document that contains the total number of result set rows, as well the actual result set data.The generated XML document is...


Platforms: PHP

Simple MySQL DB Class can connect to a MySQL server and execute SQL queries.Key Features of Simple MySQL DB Class:- Execute SQL queries and retrieve single value results or return result rows into arrays- Return the last inserted table row identifier, the number of result rows and the number of...


Platforms: PHP

A connection can be established to a MySQL database server and several types of general purpose queries and functions can be executed.Key Features of All PHP:- Executing SELECT, INSERT, UPDATE and DELETE queries from lists of parameters- Retrieve query results into arrays- Generate query results...


Platforms: PHP

k-mysql is a simple MySQL database access wrapper. It can establish MySQL database connection, execute SQL queries and retrieve the query result sets into arrays.k-mysql also counts the number of queries that are executed and measures the time that each query takes to execute.The number of...


Platforms: PHP