Database Abstractions

MyJSON - Work with MySQL + JSON

MyJSON - Work with MySQL + JSON

MyJSON is a PHP5 Class, with it, you are now able to: Create JSON string from a MySQL Query Insert JSON content into a MySQL Table Create/Insert will work as export! So you is a new experience on backups: with JSON ! The JSON created can be indented or not, you choose Easy to get class-failure errors Examples of both functions are included Examples Creating JSON from MySQL query:echo $json->SQLtoJSON("SELECT * FROM your_table"); Creat...

MyXML - Work with MySQL+XML

MyXML - Work with MySQL+XML

With this PHP5 Class you are now able to: Create an XML file from MySQL Query Insert all XML Content into a MySQL table Create/Insert work as Export/Import! So you have php-friendly way to backup data of a table Create sitemap from a full MySQL table or just a query Easy way to get class-failure errors Easy way to display generated xml (with or without header) and save the data into .xml file Full examples included Examples Creating XML from...

Database Code Generator

Database Code Generator

Database Code Generator Version 5 is here! Updated to 5.1.0 on 8/2013 Updated to 5.0.4 on 6/2013 DBCG was built to save time when working with a database. It automatically creates all kinds of outputs for you at the click of a button! Even Ajax forms!! In a cliff-notes fashion here’s what this script does. It hooks into your database and generates HTML and PHP code that you can copy and paste into your project. Instead of having to write a f...

EazSQL - PHP MySQL Helper

EazSQL - PHP MySQL Helper

This is a PHP5 Class-Helper that will allow you to make MySQL actions more easy, without too much lines. You will use like only 70% of classic code, and the syntax is more easy. Here you can see some examples: $mysql = new EazSQL('host', 'username', 'password', 'database'); // VS Old (classic) method: $mysql = mysql_connect('host', 'username', 'password') or die ('Mysql error, connection'); mysql_select_db('datababse', $mysql) or die ('Mysql...

Peek - Database Manager

Peek - Database Manager

Peek is a PHP based MySQL and SQLite Database Manager. With Peek you are able to interact with tables and run queries all from within a web browser. You can View, Export and Drop Tables. You can Export to CSV or XML . Peek uses AJAX so all changes are done live in the browser window. Updated to v1.1.1 – User Accounts, MySQL Support, Table Filtering and more.. Features Easy to configure View, Edit, Export and Drop SQLite Tables Export to CS...

PHP Data Validator

PHP Data Validator

A quick and easy to use utility to validate all sorts of data for your PHP website. All validation methods are static thus dramatically improving validation speed and performance: Validation Features Include: Is Alphanumeric Value Is Alpha Value Is Upper Case String Is Numeric Value Is Floating Point Value Is Date/Time String Is Email String Is Phone Number String Is UTF8 String Is Social Security Number Is Valid URL Is ...

Basic PHP Data Formatting

Basic PHP Data Formatting

Format your data with ease! We all need to format our data before entering the database, and this helps to keep your database clean. Format The Following: Provinces, Strings, Text Truncating, Numbers, Money, File Sizes, Dates, Phone Numbers, URLs, S.I.N Number It’s not rocket science but it helps to simplify your daily database tasks.

PHP MySql Caching Class

PHP MySql Caching Class

MySQL caching class is a lightweight PHP 5 class that allows individual query file caching without the need of server extensions. Features: Easy to install Lightweight single file (8kb) PHP 5 OOP makes it easy to extend Only connects to the database when the cache has expired or doesn’t exist Caches query data to json encoded files Set cache lifespan and filename individually Ability to manually delete cache files Requirements Supports P...

SQLite Object Oriented Framework

SQLite Object Oriented Framework

This is a professionnal grade SQLite database framework. It enables you to avoid writing and re-writing all the repetitive SQL queries and all the fetch arrays, help protect you against SQL injections, and offer you a very robust, but simple way to interact with your SQLite2 databases. This Framework is inspired from our MySQL framework, that have been used and improved for years. You can get the MySQL framework on this page. Feature...

MySQL database Auto Framework

MySQL database Auto Framework

This is a professionnal grade MySQL database framework that we have developped and improved for years. It enables you to avoid writing and re-writing all the repetitive SQL queries and all the fetch arrays, help protect you against SQL injections, and offer you a very robust, but simple way to interact with your MySQL 5 databases. Features: - Fully object oriented (use classes) - Use one class file per database table - Automatically ...