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 | 21.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 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 Themeforest Helper - Knowledge Base / Support WordPress Theme

    Free Themeforest Helper - Knowledge Base / Support WordPress Theme theme download

    Category: Themeforest | WordPress
    Tags: bbPress | drag & drop | FAQ | Forum | help desk | HelpDesk | knowledge base | live search | Responsive | Support | Wiki | Themeforest | eCommerce | nulled | free download | theme | script | rip | helper | Knowledge | Base | Support | WordPress | theme
    Archives: 2016 | May 2016 | 21.May 2016

    Meet Helper, your best solution when it comes to creating knowledge base system running on top of WordPress platform.Helper comes with a ...splay advanced search in every page using page-home.php- Update Visual Composer 4.6.1June 15th, 2015 -- Version 1.0.0- Theme is released
    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 | 05.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 Rebeloper Store - The Ultimate In-app Purchase Helper for  iOS 10 and Swift 3

    Free Codecanyon Rebeloper Store - The Ultimate In-app Purchase Helper for iOS 10 and Swift 3 theme download

    Category: Codecanyon | Mobile
    Tags: Ads | auto-renewable subscriptions | Coins | Consumables | flat style | IAP | in app purchases | ios10 | ipad pro | iPhone | Rebeloper Store | sprite kit | swift 3 | virtual currency | xcode 8 | Codecanyon | Mobile | nulled | free download | theme | script | rip | Rebeloper | Store | Ultimate | inapp | PURCHASE | helper | Swift
    Archives: 2016 | October 2016 | 12.October 2016

    Watch intro video here: https://vimeo.com/185853827This item comes with a 2,5 half hours of video documentation.Apples Subscripti...on Pricing and profit from being an early adopter.Take a look at the free preview lectures below, and I will see you inside the course!

    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