SimpleDB – All In One MySql Database Library (Connections, Commands, Migrations, Crud Library)

Free download SimpleDB – All In One MySql Database Library (Connections, Commands, Migrations, Crud Library) Nulled. It is developed by ioscript on CodeCanyon. Download Nulled SimpleDB – All In One MySql Database Library (Connections, Commands, Migrations, Crud Library).

About SimpleDB

Hi dear Envato Community,

SimpleDB library aims to help you get rid of writing sql
queries and switching between your code editor and database management tool.
SimpleDb is a smart four-in-one library which assists you throught your project
development proccess in database layer. In simple words you can manage the process of;

Define New Database
Create MySql Connections using PHP’s PDO library
Run your queries with easily
Create Database migrations just writing a php variable
Run CRUD commands with just a single line.
Available Classes

Here is a short description about classes available on SimpleDB to help you to understand what class is for what.

ConnectionString class; This class aims to help you creating a valid connection string to use in SimpleDb database connections.

MySqlConnection class; This class is used to manage your database connections. Initialize a database connection and test if you are connected or not.

Database class; This class used in migrations. Define a database to run a migration command.

Migration class; This class is used to run a database migration (up/down) commands with the help of the Database class.

Database, Table, Field classes; You can use this 3 classes to create a database. Examples are available in this documentation file

SimpleCrud class; Run Create, Read, Update, Delete commands with a single line and get rid of complex queries.

SimpleDB class; This class is used to load the SimpleDB library hierarchically to your code base.

Documentation

SimpleDb has fully documented code and easy to read user manual. We strongly recommend downloading the user manual before buying our product to decide if this product is suitable for you.

Sample Code Snippets

Create a database connection and run a simple query;

require ‘simpledb.php’;
SimpleDB()::ImportAll();

$connection = new MySqlConnection(new ConnectionString(“localhost”, “username”, “password”, “db_name”));

$cmd = new MySqlCommand(“select * from users”, $connection->getConnection());
$data = $cmd->FetchAll();

Use CRUD Library to get the same result with code snippet above;

require ‘simpledb.php’;
SimpleDB()::ImportAll();

$connection = new MySqlConnection(new ConnectionString(“localhost”, “username”, “password”, “db_name”));

$crud = new SimpleCrud();
$crud->setConnection($connection);
$crud->setDatabase();
$data = $crud->Read(“users”, “*”);

Run a query with parameters

require ‘simpledb.php’;
SimpleDB()::ImportAll();

$connection = new MySqlConnection(new ConnectionString(“localhost”, “username”, “password”, “db_name”));

$cmd = new MySqlCommand(“insert into table(id, username) values(:id, :username);”, $connection->getConnection());
$cmd->bindParameter(“:id”, $_POST[“id”]);
$cmd->bindParameter(“:id”, $_POST[“username”]);
$cmd->Execute();