sintret/freelancer

sintret project with simple pdo and autoloading simple

Freelancer

Generate PHP Application with single command and PDO wrapper, _(*1)

1. Create project via composer :

composer create-project -s dev sintret/freelancer your-directory

2. Bootstraping :

in your page you must to include autoload, _(*2)

require(__DIR__ . '/autoload.php');

3. Working with query pdo :

this is example to load model in folder models, you must to extends from sintret\pdo\Db, _(*3)

models/BaseModel.php, _(*4)

class BaseModel extends sintret\pdo\Db{
    public function __construct() {
        parent::__construct(HOST, DB_NAME, DB_USER, DB_PASS);
    }

} 

index.php, _(*5)

$db = new BaseModel;

$songs = $db->query("SELECT * FROM song");
echo "

<

pre>";print_r($songs);

Fetching Row:

This method always returns only 1 row., _(*6)

<?php
// Fetch a row
$ages     =  $db->row("SELECT * FROM song WHERE  id = :id", array("id"=>"1"));

Fetching Single Value:

This method returns only one single value of a record., _(*7)

<?php
// Fetch one single value
$db->bind("id","3");
$firstname = $db->single("SELECT title FROM song WHERE id = :id");

Result

|title , _(*8)

Fetching Column:

<?php
// Fetch a column
$names    =  $db->column("SELECT title FROM song");

### Delete / Update / Insert
When executing the delete, update, or insert statement by using the query method the affected rows will be returned.
```php
<?php

// Delete
$delete   =  $db->query("DELETE FROM song WHERE id = :id", array("id"=>"1"));

// Update
$update   =  $db->query("UPDATE song SET title = :f WHERE id = :id", array("f"=>"Jan","id"=>"2"));

// Insert
$insert   =  $db->query("INSERT INTO song(title,status) VALUES(:title,:status)", array("title"=>"Vivek","status"=>"20"));

// Do something with the data 
if($insert > 0 ) {
  return 'Succesfully created a new person !';
}

4. Working with model :

This example create simple class Song look like this following, _(*9)

class Song extends sintret\pdo\Crud {

    protected $table = 'song';

    # Primary Key of the table
    protected $pk = 'id';
    // ling to class db connection here 
    public $className = 'BaseModel';
}

5. Create / Save with model

Example for create new Song code will create new record song like these following code:, _(*10)

$model = new Song();
$model->title = 'Disaat Aku Tersakiti';
$model->artist = 'Dadali';
$model->album = ' Disaat Aku Tersakiti';
$model->createDate = date("Y-m-d H:i:s");
$model->status = 1;
$model->create();

6. Find with model

Example for find Song code will create new record song like these following code:, _(*11)

$model = new Song();
$model->find(1);

echo $model->title;
echo $model->artist;

or with multiple, _(*12)

$model = new Song();
$model->find(['artist '=>'Dadali','status'=>1]);

echo $model->title;
echo $model->artist;

7. Update where with model

Example for find Song code will create new record song like these following code:, _(*13)

$model = new Song();
$model->status = 2;
$model->rate = 66;
$model->save(3);

8. Delete with model

Example for delete Song code will create new record song like these following code:, _(*14)

$model = new Song();
$model->delete(1);

9. Find All with model

Example for delete Song code will create new record song like these following code:, _(*15)

$model = new Song();
$model->all();
echo "<pre>"; print_r($model);

10. Saving with array models

Example for save with array Song code will create new record song like these following code:, _(*16)

$model = new Song(['title' => 'I can teach you', 'artist' => 'bon jovi','status'=>1]);
$model->create();
echo "<pre>"; print_r($model);