Download .zip |
Info | Example | View files (6) | Download .zip | Reputation | Support forum | Blog | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2016-07-28 (5 months ago) | Not enough user ratings | Total: 218 This week: 2 | All time: 7,726 This week: 493 |
Version | License | PHP version | Categories | |||
crudx 1.0.3 | MIT/X Consortium ... | 5.3 | PHP 5, Databases, Design Patterns |
Description | Author | ||||||||
This class can store and retrieve objects in MySQL using MySQLi. Recommendations What is the best PHP crud class? |
|
CRUDX is a PHP based library for mysql query builder. Its easy and simple.
To install this package go to terminal and run this command
composer require nahid/crudx
To use this package you have to include it. Include it from composer autoload
require_once 'vendor/autoload.php';
You can connect by using this process;
use Nahid\Crudx\Crudx;
$config = [
'host' => 'localhost',
'user' => 'root',
'password' => 'your_password',
'database' => 'database_name',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => 'table_prefix',
];
$crud = new Crudx($config);
Its too much important to inserting data in database table when you developing an application. Crudx make easy to inserting data in table. Crudx provide different type of insertion mechanism. First you can insert data with Laravel Eloquent style. Suppose you want to save name, username, email in users table. So what can you do?
$user=$crud->table('users');
$user->name='Nahid Bin Azhar';
$user->username='nahid';
$user->email='talk@nahid.co';
$user->save();
Its like a piece of cake.
The second procedure. Its traditional way. You may called it CodeIgniter Style. However see how can you inserting data with this way.
$data=[
'name'=>'Nahid Bin Azhar',
'username'=>'nahid',
'email'=>'talk@nahid.co'
];
$crud->table('users')->save($data);
What do you think? yes its Crudx, make easy development.
You may insert multiple records at once. Yes its true, just see what happend
$data=[
[
'name'=>'Nahid Bin Azhar',
'username'=>'nahid',
'email'=>'talk@nahid.co'
],
[
'name'=>'Naim',
'username'=>'naim',
'email'=>'naim@themebucket.net'
]
];
$crud->table('users')->insertMany($data);
Making update rocord is so easy.
$data=[
'name'=>'Nahid Bin Azhar',
'username'=>'nahid',
'email'=>'talk@nahid.co'
];
$crud->where('id', '=', 1)->save($data);
Sometimes you need to delete record from table. Crudx make it easy. Its just a single command
$crud->where('id', '=', 1)->delete();
Crudx provide you to differents type service to fetching record from table. Suppose you want to get all data of author role from table users
$crud->table('users')->where('role', '=', 'author')->all()->result();
//generated SQL String: SELECT * FROM users WHERE role='author'
But if you want to add multiple condition with AND
operator then follow the process
$crud->table('users')->where('role', '=', 'author')->where('age','>',17)->all()->result();
//generated SQL String: SELECT * FROM users WHERE role='author' AND age>17
you can use orWhere()
for OR operator and you can also use whereBetween()
`orBetween()
If you have to fetch specific table column then use get()
method and pass an array to specify table column
$crud->table('users')->where('role', '=', 'author')->get(['name', 'username'])->result();
//generated SQL String: SELECT name, username FROM users WHERE role='author'
Crudx provide you a simple joining method.
$crud->table('posts')->join('users', 'posts.user_id','=', 'users.id')->get(['post', 'name'])->result();
//generated SQL String: SELECT post, name FROM posts INNER JOIN users on posts.user_id=users.id
$crud->table('users')->save(['name'=>'Nahid']);
echo $crud->getId();
Sometimes you have to need which query string is generated by the last method. Crudx make it easy
$crud->table('users')->where('role', '=', 'author')->where('age','>',17)->all()->result();
echo $crud->getQueryString();
Files |
File | Role | Description | ||
---|---|---|---|---|
src (1 file, 1 directory) | ||||
composer.json | Data | Auxiliary data | ||
index.php | Example | Example script | ||
LICENSE | Data | Auxiliary data | ||
README.md | Doc. | Documentation |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
100% |
|
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.