Statements

MySqueaks is the short name for My Simplified Quality Expressions (SQX), a simple PHP class that generates SQL statements. This facilitates an easier understanding of the different parts and conditions of a SQL statement, making it more user-friendly for beginner programmers. The use of the...

classyPHP is a tiny web utility to create fully-fledged ready-to-use PHP classes from SQL CREATE TABLE statements. You must just paste your SQL code and click the "...THEN CLICK HERE..." button. The script is very easy to install, use and customize. It can be integrated in any website structure.

This class implements the RDQL language to query RDF documents stored in a MySQL database. The RDF documents can be stored, retrieved and deleted from the database using the RDQL_db class, documents can be stored from file paths or URLs Since RDF documents are parsed and stored in the database as...


Platforms: Windows, Mac, *nix, PHP, BSD Solaris

Tntdb is a c -class-library for easy database-access. It implements a simple database independent layer, which loads drivers at runtime. Currently drivers for postgresql, sqlite3, mysql and oracle are provided.The main goals are:- easy to use- safe - use prepared statements with named parameters-...


Platforms: C and C plus plus

This class can be used to generate a MySQL database backup using PDO.It can query the structure of a given MySQL database and generate SQL statements to recreate and insert the records of the tables in the database.The resulting SQL statements are returned as a single string that can be served...


Platforms: Matlab

dbf2mysql, the dbase extension functions are used to open and retrieve data from DBF files. The script generates a string with SQL statements to create tables in a MySQL database and insert rows with the data from the DBF files.The generated SQL statements maybe displayed in a HTML page, served...


Platforms: PHP

PHP REST SQL is a class used to open a HTTP REST interface to a MySQL database using PHP and a HTTP server.Using standard HTTP requests, the data in a database can be created, retrieved, modified and deleted.PHP REST SQL was built and tested using Apache 2.0.45, PHP 4.3.4, and MySQL 3.23,...


Platforms: PHP

Nested Sets DB Tree can be used to manipulate nested sets of database table records that form an hierarchical tree.Features of Nested Sets DB Tree:- It provides means to initialize the record tree, insert record nodes in specific tree positions, retrieve node and parent records, change position...


Platforms: PHP

tgcSqlBuilder is a very easy to install, use and customize PHP database tool script which allows you to build SQL-statements using an object-oriented interface instead of many string-concatenations.It can be implemented in any PHP application, and you can simply build your queries with methods...


Platforms: PHP

SQL Parse and Compile can take an SQL query and parse it to extract the different parts of the query like the type of command, fields, tables, conditions, etc. . It can also compose take different values and compose a SQL query from them .Key Features of SQL Parse and Compile:- Parser: . insert ....


Platforms: PHP

Script to handle your mysql database online. no installation required, just plug and play :-)Features of PHP MySQL Smart:- help- database/Table/Filed browsing- field description- table description- database description- all kind of queries- select * works also- error messages- number of affected...


Platforms: PHP

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

MySQL Transact is a simple class can queue several MySQL database queries and execute them all at once in a single transaction. It provides means to add SQL queries to a queue.Once all SQL statements are added, MySQL Transact can start a transaction, execute each statement and finishes the...


Platforms: PHP

SQL Backup classes can be used to provide a backup and restore solution of SQL databases that can work with multiple database types. It uses another database abstraction package to query the database table structure. It extracts the data in the tables to generate a database backup file that...


Platforms: PHP

This package can be used to generate backup copies of Web server directory files and MySQL databases. It uses a separate class to generate a backup archive in ZIP format of a given directory.Another class is used to take a backup of a given MySQL database into file with SQL statements that can be...


Platforms: PHP

This class can be used to populate a MySQL database with random data. It can scan the list of tables and fields of a MySQL database and generate SQL INSERT statements that will fill the tables with records with random data.The class tries to populate each record field with values that seem...


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

This PHP class can access MySQL databases from PHP code. It features a very simple and easy to understand PHP syntax, allowing it to easily be called from any PHP application.Here are some Key Features of PHP MySQL Connection Class:-Establish MySQL database server connections-Execute SQL queries...


Platforms: PHP

DAO classes is a SQL database access wrapper. It can establish database connections to one of several possible database server slaves.The class DAO classes can execute queries immediately or store the SQL statements in a queue file execute the queries all at once some time later. It also supports...


Platforms: PHP

MySQL Structure Magic can analyze the schema of a MySQL database and export it as a PHP array definition or in a XML format. Previously exported schema definitions can also be imported.With an initial and final schema definitions MySQL Structure Magic can compare them and determine the necessary...


Platforms: PHP