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

FREE DOWNLOAD links for Mega Class Database (MYSQL) v 1.0 is BELOW - click on the RED BUTTON. Logged-in users can see links to download above the main picture.

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


Codecanyon Mega Class Database (MYSQL) v 1.0 free download

Buy this item



Mega Class Database (MYSQL) v 1.0
Use every feature of MySQL in PHP .

Main Features:1. MySQL Compatible with:MySQL 3.23+, MySQL 4.0+, MySQL 4.1+, MySQL 5.0+.
2. Easy to Use, clean, easy to understand code.
3. Access MySQL Database without any knowledge of MySQL or SQL .
4. Uses Associative array of data to insert and update rows in the database table.
5. Optional escape string feature to avoid SQL Injections.
6. Automatically Creates Prepared Statements.
7. Select Rows, Columns, Variables with one-liners.
8. Easy Select, Insert, Update, Delete, filtered
9. Properly documented with examples and comments.
10. Small Size.
11. Attach Fully Documented.


Functions
// Connect to serversql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false);//-----------------------------------------------------------------+sql_query($query = '');// Build sql statement from array for select and select distinct statements//-----------------------------------------------------------------+// Build LIMIT querysql_query_limit($query, $total, $offset = 0);//-----------------------------------------------------------------+// Fetch current rowsql_fetchrow($query_id);//-----------------------------------------------------------------+//Possible query values: SELECT, SELECT_DISTINCTfunction sql_build_query($query, $array);//-----------------------------------------------------------------+// Run more than one insert statement.sql_multi_insert($table, &$sql_ary);//-----------------------------------------------------------------+// Escape string used in sql querysql_escape();//-----------------------------------------------------------------+// Gets some information about the specified table.get_table_status($table_name);//-----------------------------------------------------------------+// Gets the exact number of rows in a specified table.get_row_count($table_name);//-----------------------------------------------------------------+//Gets the estimated number of rows in a specified table.get_estimated_row_count($table_name);//-----------------------------------------------------------------+// display sql error pagesql_error();//-----------------------------------------------------------------+// Build IN or NOT IN sql comparison string, uses <> or = on single elementsql_in_set($field, $array, $negate = false, $allow_empty_set = false);//-----------------------------------------------------------------+// Correctly adjust LIKE expression for special characterssql_like_expression($expression);//-----------------------------------------------------------------+// Version information about used databasesql_server_info();//-----------------------------------------------------------------+// Return number of affected rowssql_affectedrows();//-----------------------------------------------------------------+// Seek to given row numbersql_rowseek($rownum, &$query_id);//-----------------------------------------------------------------+// Get last inserted id after insert statementsql_nextid();//-----------------------------------------------------------------+// Free sql resultsql_freeresult($query_id = false);//-----------------------------------------------------------------+// close sql connectionsql_close();//-----------------------------------------------------------------+

Usage
// define class file in your script.define('IN_MEGA_DB', true);// Include class file in your script.include('mega.class.database.php');$dbhost      = 'localhost';$dbport      = '';$dbname      = 'database';$dbuser      = 'db_username';$dbpasswd    = 'db_password';$tableprefix = '';//ex table [email protected]('USERS_TABLE', $tableprefix . 'users');//New Class$db     = new dbal_mysql();// connect Database$con = sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport);//-----------------------------------------------------------------+// SELECT, INSERT, UPDATE, DELETE with prepared statements://-----------------------------------------------------------------+// SELECT$sql = $db->sql_query("SELECT * FROM ".USERS_TABLE."");$row = $db->sql_fetchrow($sql);// OR whilewhile($row = $db->sql_fetchrow($sql)){// While code}//-----------------------------------------------------------------+// INSERT$sql_ins = array('id'          => (int)'','username'    => 'username','password'    => '123456','email'       => [email protected]','status'      => (int)'1',);$sql    = 'INSERT INTO ' . USERS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ins);$result = $db->sql_query($sql);//-----------------------------------------------------------------+// UPDATE$db->sql_query("UPDATE " . USERS_TABLE . " SET `password`='123456' WHERE `id` = '1'");//-----------------------------------------------------------------+// DELETE$db->sql_query("DELETE " . USERS_TABLE . " WHERE `id` = '1'");//-----------------------------------------------------------------+// LIMIT QUERYif(!isset($_GET['page'])){$page = 1;}else{$page = intval($_GET['page']);}$sql_limit     = '10';$sql_start     = ( $sql_limit * $page ) - $sql_limit;$sql           = "SELECT * FROM ".USERS_TABLE." ORDER BY date DESC";$result        = $db->sql_query_limit($sql,$sql_limit, $sql_start);while ($row = $db->sql_fetchrow($result)){// While code}//-----------------------------------------------------------------+// Num Rowsecho $db->get_row_count(USERS_TABLE);echo $db->get_estimated_row_count(USERS_TABLE);


Version History
v1.0Initial version.

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-&gt;active();// Save session info to a variable$session_info = $sess-&gt;raw();// destroy the session$sess-&gt;destroy();
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-&gt;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-&gt;sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport);Version Historyv1.0Initial version.
Free download Codecanyon MySQL Database Navigation and Pagination

Free Codecanyon MySQL Database Navigation and Pagination theme download

Category: Codecanyon | PHP Scripts
Tags: Codecanyon | HTML5 | nulled | free download | theme | script | rip | MySQL | Database | Navigation | and | Pagination
Archives: 2016 | April 2016 | 20.April 2016

NEW: Full Featured Reports &amp; Dashboards Builder Tool for MySQLAvailable now, free trial version available for downloading:http://...hboard for MySQLBuild visual dashboard for MySQL available now: http://dashboard.dbface.com and will available on codecanyon in the future.
Free download Codecanyon PDOModel - Database abstraction and helper PHP class

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

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

PDOModel – Database abstraction and helper PHP class that helps to do insert, update, delete, select operation using PDO without writing any ...iptPHP Version 5.3 and aboveMust have write access for download folderCredits:TcpdfphpExcelOur other popular script


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 Backup and Restore

Free Codecanyon MySQL Database Backup and Restore theme download

Category: Codecanyon | Apps
Tags: Backup | Copy | Database | databases | failsafe | Local | MySQL | Plugin | Prestashop | Remote | Safe | Server | SQL | WooCommerce | WordPress | Codecanyon | Apps | nulled | free download | theme | script | rip | MySQL | Database | Backup | restore
Archives: 2016 | June 2016 | 17.June 2016

Tiny application to automatically backup and restore MySQL databases from local/remote server. Backup unlimited databases simultaneously thanks to multithreading.Need a new function?, ask us!
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 MySQL database Auto Framework

Free Codecanyon MySQL database Auto Framework theme download

Category: Codecanyon | PHP Scripts
Tags: database abstraction | database framework | MySQL | MySQL 5 | mysql database | Codecanyon | PHP Scripts | nulled | free download | theme | script | rip | MySQL | Database | Auto | Framework
Archives: 2016 | October 2016 | 01.October 2016

This is a professionnal grade MySQL database framework that we have developped and improved for years. It enables you to avoid writing and re...methods that you need (to select, update, insert, delete and provide custom queries…)Full documentation provided with the source code.

Login Free register

Search Free Themes Download

Free Themes Download Archives

  • Mon
  • Tue
  • Wed
  • Thu
  • Fri
  • Sat
  • Sun