EasyDatabase for PHP
EasyDatabase easy mysql server access!
EasyDatabase is a simple API for accessing a mysql database from php code. This software lets you easily without knowing sql reading/modify/delete data from a database.
Connecting to the database
$database = Database::connect("host", "user","password","db name");
Selecting data from the database
$result = $database->table("users")->selectAllFields()->where("id=5")->execute();
$array = $result->arrays();
$id = $array[0]["id"];
Inserting a new row
$database->table("users")->insert(array("id"=>6,"name"=>"user33"))->execute();
And more....
Features:
For those who don't know SQL
- Connecting to a database server.
- Access tables inside a database.
- Read, modify, delete a table's contents, this means you are able to:
- Delete rows
- Insert new rows (or automaticly update existing ones)
- Insert rows containing data from rows of other tables
- Reading rows from the database, and filter them.
- Change values of rows
For theose who know SQL
- Run custom queries on it.
- Create and call functions
- Do an expression
- Select data in database scope instead of selecting from a table