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

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

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

[Download] SimpleDB – All In One MySql Database Library (Connections, Commands, Migrations, Crud Library) Free Nulled

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();

Database Migration

For creating migration with SimpleDB there is no need for third party tool and running a command line prompt every time you change your database schema. When production mode is disabled from the migration class every time the class checks for remote and current database version, if there is a new database version its created automatically when the page loaded(Index page is a good place to control your migrations).

Here is a flowchart which shows how SimpleDB migration works and a simple code snippet for creating a database called ‘simleblog’ and a table called ‘users’.

See Also

<?php
require 'includes'.DIRECTORY_SEPARATOR.'simpledb.php';
SimpleDB::ImportAll();
$connect = new MySqlConnection(new ConnectionString("localhost", "userx", "pass_x"));
$db = new Database("simpleblog");
$db->setVersion(1)
    ->setTables(
        new Table("users",
            new Field("userid", "int", "PRYMARY KEY AUTO_INCREMENT"),
            new Field("username", "varchar(20)", "unique"),
            new Field("password", "varchar(200)", "not null")
        ,
        new Table("posts",
            new Field("data1", "varchar(200)"),
            new Field("data2", "varchar(200)")
            )
        )
    )
    ->Create();
$migration = new Migration();
$migration->setConnection($connect)
        ->setDatabase($db)
        ->setProduction(false)
        ->Up();

TMDb Pro – Movie & TV Show Details Plugin For The Movie Database

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

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Why do we use it?

It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using Content here, content here, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for lorem ipsum will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).

Where does it come from?

Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of “de Finibus Bonorum et Malorum” (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, “Lorem ipsum dolor sit amet..”, comes from a line in section 1.10.32.

Where can I get some?

There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which dont look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isnt anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.

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

Download & Demo Links

Important Note:

We update new contents like WordPress Themes, WordPress Plugins, Templates & PHP Scripts everyday.But remember that you should never use this items in a commercial website. All the contents posted here for development & testing purpose only. We’re not responsible for any damage, use at your own RISK! We highly recommend to buy SaaSHub – Digital Product WordPress Theme from the Original Developer website. Thank you.

Preview: SimpleDB – All In One MySql Database Library (Connections, Commands, Migrations, Crud Library)
Download: simpledb-all-in-one-mysql-database-library-connections-commands-migrations-crud-library(full-version).zip

© 2020 Themeskorner. All Rights Reserved.

Scroll To Top