taylor-hawkes/tays-orm

Quick and easy ORM

TaysORM

This is a super simple class for saving/editing record in a mysql database. It really helps for quickly/easily updating single records., _(*1)

installation & usage

Install with composer:, _(*2)

composer require taylor-hawkes\easy-connect
composer require taylor-hawkes\tays-orm

Generate a new model with the generator script:, _(*3)

cd vendor/taylor-hawkes/tays-orm

```sh php generate_model.php --table="users" --host="database_ip" --user="db_user" --pass="db_pass" --database="db_name" --table="tablename", <sub>(*4)</sub>

``You can  hard code the database params in the generate_table script so you don't have to put them in as params everytime.``

``This script by default installs all new Models and Base Models three directories up (in a TModel folder) from the TaysORM installation directory. You can edit where the script installs your Models.``


# Usage Examples:
Create a new user:
```php
$user=new \TModel\Users();
$user->first_name="taylor";
$user->last_name="hawkes";
$user->save();

Edit a user:, <sub>(*5)</sub>

$user=new \TModel\Users();
$user->fetchRow("1");// 1 is the value of the tables primary key
$user->last_name="Malone"; // I got married and was forced to take my wifes name
$user->save();

You can also fetch a row like this:, <sub>(*6)</sub>

$user=new \TModel\Users();
$user->fetchRowWhere("first_name = 'taylor' and lastname ='hawkes'");
$user->last_name="Malone"; 
$user->save();

Selecting Multiple Records:, <sub>(*7)</sub>

$user=new \TModel\Users();
$all_users= $user->fetchAssoc("select * from users");

All Other Queries:, <sub>(*8)</sub>

$user=new \TModel\Users();
$do_something_else=$user->query("update users set ...");

Requirements

EasyConnect - [https://github.com/TaylorHawkes/EasyConnect], <sub>(*9)</sub>

License

MIT, <sub>(*10)</sub>