Free Codecanyon PDOModel - Database abstraction and helper PHP class theme download

FREE DOWNLOAD links for PDOModel - Database abstraction and helper PHP class is BELOW - click on the RED BUTTON. Logged-in users can see links to download above the main picture.

Category: Codecanyon | PHP Scripts
Tags: Codecanyon | PHP Scripts | nulled | free download | theme | script | rip | PDOModel | Database | Abstraction | and | helper | PHP | Class
In archive: 2016 | April 2016 | 20.April 2016


Codecanyon PDOModel - Database abstraction and helper PHP class free download

Buy this item



PDOModel – Database abstraction and helper PHP class that helps to do insert, update, delete, select operation using PDO without writing any queries and with much lesser code. It supports Mysql, Postgres and SQlite database.
PDOModel provides a complete solution to perform CRUD operations on three different types of database (Mysql, Postgres and Sqlite). It provides various helper functions to export data directly to csv,excel,xml,pdf,html and many more useful functions.
More Detailshttp://demo.digitaldreamstech.com/PDOModel/
Documentationhttp://demo.digitaldreamstech.com/PDOModel/documentation/pdo/Example of how to write SQL select query using PDOModel$pdomodel = new PDOModel(); //create object of the PDOModel class$pdomodel->connect("localhost", "root", "", "pdocrud");//connect to database$result = $pdomodel->select("emp"); //select * from `emp`

That’s it, you need to write just 2-3 line of code. You can write very complex queries using PDOModel functions



PDOModel supports three type of database, Mysql, Postgres and Sqlite.

PDOModel script allows you to export data directly in various database formats.


Examples$pdomodel = new PDOModel();//create object$pdomodel->connect("localhost", "root", "", "pdocrud");//connect to database - three different database type available/* INSERT , UPDATE AND DELETE OPERATION */$pdomodel->insert("emp", array("firstName" => "John", "lastName" => "Jonathan", "gender" => "male"));$pdomodel->where("orderId", 7);$pdomodel->update("order", array("orderNumber"=>"44", "customerName"=>"BKG", "address"=>"140 shakti nagar"));$pdomodel->where("orderId", 7);$pdomodel->delete("order");/* SELECT */$result = $pdomodel->select("emp");/* WHERE, AND, OR, BETWEEN, GROUP BY, ORDER BY, LIKE , HAVING */$pdomodel->where("orderNumber", "5", "!=");$pdomodel->openBrackets ="(";$pdomodel->where("city", "Indore", "=");$pdomodel->andOrOperator="OR";$pdomodel->closedBrackets =")";$pdomodel->groupByCols = array("orderId");$pdomodel->orderByCols = array("orderId desc", "state asc");$pdomodel->havingCondtion = array("sum(orderId)>2");$pdomodel->limit = "0,5";$pdomodel->where("empId", array(36,37), "BETWEEN");$pdomodel->where("firstName", '%P%', "LIKE");$pdomodel->where("empId", array(36,37,39,40), "IN");/* subquery/inner query */$pdomodel->subQuery("select empId from emp where empId=?","empId",array(34));/* where subquery */$pdomodel->where_subquery("orderId", "select orderId from `order` where orderId=?", "IN",array(10));/*rename, trucate, drop table, column name, primary key, tablefield info*/$pdomodel->truncateTable("wp_postmeta");$pdomodel->renameTable("states","state");$pdomodel->dropTable("empleave");$records = $pdomodel->columnNames("order");$records = $pdomodel->primaryKey("order");$records = $pdomodel->tableFieldInfo("order");/*execute sql*/$result = $pdomodel->executeQuery("select * from emp where empId = ?", array(39));
Main Features:
  • Perform Insert, update, delete and select operations using simple functions
  • Three different types of database support (Mysql, PGSql and SQLite)
  • Complex queries support with use of multiple “and” and “or”
  • Multiple table join Operation using simple functions
  • Table related operations like get all tables from database, truncate table, delete table, rename table etc.
  • Subquery/inner query can be embedded
  • Column based operation like getting all columns of table, primary key of table etc
  • Export functions to export data in CSV, PDF, Excel, HTML, XML Format
  • Helper functions like pagination, random password generation
  • Best practices using PDO with use of prepared statements
  • Support for PDO Transactions
  • Support for batch operations for insert, update and delete
  • Execute query directly with parameter binding
  • Various debugging options like get last query, get rows inserted, error messages etc
  • Support for order by, group by, like, between, in, not in, having etc
  • Well documented and demo codes to make things easier to understand
  • Supports method chaining
  • Batch operations for faster result


  • Min requirement for the script
    PHP Version 5.3 and aboveMust have write access for download folder


    Credits:Tcpdf
    phpExcel


    Our other popular scriptWordpress awesome import and export plugin

    Source: codecanyon.net
    Report this item


    Free download

    Show FREE DOWNLOAD links



    Related free downloads

    Free download Codecanyon PHP Invoice - PHP Class For Beautiful PDF Invoices

    Free Codecanyon PHP Invoice - PHP Class For Beautiful PDF Invoices theme download

    Category: Codecanyon | PHP Scripts
    Tags: Themeforest | Site Templates | nulled | free download | theme | script | rip | PHP | Invoice | Class | for | Beautiful | PDF | Invoices
    Archives: 2016 | April 2016 | 20.April 2016

    PHP Invoice is a simple object oriented PHP class to generate beautifully designed invoices, quotes or Sale/Purchase orders with just a few l...e prices. use "setCurrenyDirection()"- Added support for adding html special charactors as well in currency like for EURO ( & #8364; )
    Free download Codecanyon PHP Database Session Class

    Free Codecanyon PHP Database Session Class theme download

    Category: Codecanyon | PHP Scripts
    Tags: Photodune | Misc | nulled | free download | theme | script | rip | PHP | Database | Session | Class
    Archives: 2016 | April 2016 | 20.April 2016

    Create user sessions with this easy to use class.Each session is stored in a database and is locked to the current browser and ip addre...k1 = $sess->active();// Save session info to a variable$session_info = $sess->raw();// destroy the session$sess->destroy();
    Free download Codecanyon Mega Class Database (MYSQL) v 1.0

    Free Codecanyon Mega Class Database (MYSQL) v 1.0 theme download

    Category: Codecanyon | PHP Scripts
    Tags: Photodune | Misc | nulled | free download | theme | script | rip | Mega | Class | Database | (MYSQL) | 1.0
    Archives: 2016 | April 2016 | 20.April 2016

    Mega Class Database (MYSQL) v 1.0Use every feature of MySQL in PHP .Main Features:1. MySQL Compatible with:MySQL 3.23+, MySQL 4.0+, ...cho $db->get_row_count(USERS_TABLE);echo $db->get_estimated_row_count(USERS_TABLE);Version Historyv1.0Initial version.
    Free download Codecanyon Mega Class Database (Oracle) v 1.0

    Free Codecanyon Mega Class Database (Oracle) v 1.0 theme download

    Category: Codecanyon | PHP Scripts
    Tags: Photodune | Misc | nulled | free download | theme | script | rip | Mega | Class | Database | (Oracle) | 1.0
    Archives: 2016 | April 2016 | 20.April 2016

    Mega Class Database (Oracle) v 1.0Use every feature of Oracle in PHP .Main Features:1. Oracle Compatible.2. Easy to Use, clean,...connect Database$con = $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport);Version Historyv1.0Initial version.
    Free download Codecanyon Mega Class Database (MYSQLI) v 1.0

    Free Codecanyon Mega Class Database (MYSQLI) v 1.0 theme download

    Category: Codecanyon | PHP Scripts
    Tags: Photodune | Misc | nulled | free download | theme | script | rip | Mega | Class | Database | (MYSQLI) | 1.0
    Archives: 2016 | April 2016 | 20.April 2016

    Mega Class Database (MYSQLi) v 1.0Use every feature of MySQLi in PHP .Main Features:1. MySQLi Compatible with:MySQL MySQL 4.0+, MySQL...onnect Database$con = $db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport);Version Historyv1.0Initial version.


    Free download Codecanyon Simple Database Abstraction for PHP and MySQL

    Free Codecanyon Simple Database Abstraction for PHP and MySQL theme download

    Category: Codecanyon | PHP Scripts
    Tags: active record | database abstraction | database driver | mysql abstraction | mysql class | php mysql driver | Codecanyon | PHP Scripts | nulled | free download | theme | script | rip | Simple | Database | Abstraction | MySQL
    Archives: 2016 | May 2016 | 20.May 2016

    Manipulate with your data using simple methodsPowerful actions in simple Active Record style. No any SQL writing. Fast and low-memory usa...get_one() and fields() methods fixed.Added new method distinct().Suggestions and comments are welcome.Documentation
    Free download Codecanyon MySQL Database Admin and Reports - Manage Database and Data Made Easy with PHP

    Free Codecanyon MySQL Database Admin and Reports - Manage Database and Data Made Easy with PHP theme download

    Category: Codecanyon | PHP Scripts
    Tags: Application | Database | database abstraction | Edit | Interface | Library | Management | Method | MySQL | PHP | prefix | Recursion | Table | Web | Codecanyon | PHP Scripts | nulled | free download | theme | script | rip | MySQL | Database | Admin | reports | Manage | Data | Made | Easy | with
    Archives: 2016 | July 2016 | 15.July 2016

    MySQL DB Admin is a complete solution for a MySQL Database management managing database table structures to generating reports written in PHP...eneral Servers (PHP 5.5 or less)Demo for mysqli_connectio() PDO (PHP 7)Help:Documentation is available with package.View it Online
    Free download Codecanyon Censoring Database and Class

    Free Codecanyon Censoring Database and Class theme download

    Category: Codecanyon | PHP Scripts
    Tags: bad word filter | Blacklist | censoring | censorship | curse | cursing | cursing filter | Filter | Filtering | mysql class | Codecanyon | PHP Scripts | nulled | free download | theme | script | rip | censoring | Database | Class
    Archives: 2016 | August 2016 | 04.August 2016

    What you got here is a fully functional class giving you the ability to setup your own censoring system.This can be helpful for chats, ...oring type can be changed on the flywords can be managed:added, updated, deletedSQL class includedexample PHP file included
    Free download Codecanyon Ultimate PHP Helper Class

    Free Codecanyon Ultimate PHP Helper Class theme download

    Category: Codecanyon | PHP Scripts
    Tags: Class | generate qr | gravatar | helpful class | keygen | password generator | php class | social count | social stats | Vimeo | YouTube | Codecanyon | PHP Scripts | nulled | free download | theme | script | rip | Ultimate | helper | Class
    Archives: 2016 | September 2016 | 08.September 2016

     A very helpful class for people that just start in PHP and want some head start with some helpful functions or you have already s...t LinkedIn CountGet Pinterest CountKeygeneratorEncrypt PasswordBbcodeIP to CountryCheck statsCensor wordsValidate IP
    Free download Codecanyon C#.NET Helper to Get Client IP and Country

    Free Codecanyon C#.NET Helper to Get Client IP and Country theme download

    Category: Codecanyon | .NET
    Tags: c sharp | Country | helper | ip | Library | Net | Codecanyon | .NET | nulled | free download | theme | script | rip | CNET | helper | Client | Country
    Archives: 2017 | January 2017 | 14.January 2017

    This is a C # .NET service class for use in Web projects. It allows to know the public IP of the client, and to determine to which country it...ow the public IP of the clientGetLand: Allows you to determine to which country a public IP belongsUpdateDataBase: Updates the IP data base

    Login Free register

    Search Free Themes Download

    Free Themes Download Archives

    • Mon
    • Tue
    • Wed
    • Thu
    • Fri
    • Sat
    • Sun
    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13
    • 14
    • 15
    • 16
    • 17
    • 18
    • 19
    • 20
    • 21
    • 22
    • 23
    • 24
    • 25
    • 26
    • 27
    • 28
    • 29
    • 30
    • 31