Class Model1

$column_and_value

init Model Field

get generated table name. always in plural of model form. e.g User Mode turns to users Child = children

$addMethod

$sortColumnName

$sortColumnName

$asFriendly

$func

$params

$id

$idField

: id

$othersField

= ['full_name'=>'samson iyanu']

$fullType

$objectInstance

$query

$normalizeAndListAsArray

$makeArray_ArrayObject

Run Query and return Smart ArrayObject when result is array. So You can access Each Property either ways E.g User::find(1)->full_name User::find(1)['full_name'] User::find(1)->update(['full_name', 'samson iyanu'])

 Enable ( static::$FLAG_EXEC_AS_QUERY = true ) to see code to run
 E.g
     User::$FLAG_EXEC_AS_QUERY = true;

Console1::println( User::findAll(['id'=>'1', 'user_name'=>'samson iyanu']) ); Output: SELECT * FROM users WHERE id = '1' OR user_name = 'samson iyanu' Instead of Running it

$otherTableNames

Laravel Like Query Builder Laravel Like Query Builder Use: User::query()->find(3);

Also $row = User::query()->find(3); $query = User::query()->where('name', '=', 'samson')->get(); ->select(array('mytable.myfield1', 'mytable.myfield2', 'another_table.myfield3'));

// WHERE User::query()

whereIn, orWhereIn, whereNotIn, orWhereNotIn, whereBetween, orWhereBetween, whereNull, orWhereNull, whereNotNull, orWhereNotNull

->limit(30), offset(10);

// JOIN User::query()->join('another_table', 'another_table.person_id', '=', 'my_table.id') OR ( More Criteria ) ->join('another_table', function($table) {

// GROUP

$visibleField

$invisibleField

$hiddenField

@default is ['id', 'created_at', 'updated_at', 'last_login_at'] Form Builder

$findModelById

$visibleField

$invisibleField

$hiddenField

$table_name

$order_by

$query

$textValues

$inColumn

$selectColumn

$logic

$operator

$otherQuery

$key_value_array

$findValue

$findColumn

$id_or_value

$inColumnName

$errorCallback

$id_or_value

$inColumnName

default is Primary Id

$andOtherQuery

$selectColumn

$convertToModel1

$column_and_value

$logic

$selectColumn

$operator

$logic

$selectColumn

$operator

$valueA

$valueB

$search_in_columnA_list

$search_in_columnB_list

$againstLogic

$logic

$operator

$selectColumn

Assign $valueA to all paramsArray or $columnA ( e.g ['user_name', 'email'] )

Assign $valueA to all paramsArray or $columnA ( e.g ['user_name', 'email'] )

Assign $valueB to all paramsArray or $columnB ( e.g ['password', 'api_secret'] )

Now, select datas Where $columnA[..$valueA...] $againstLogic ( AND ) $columnB[..$valueB...]

$column_and_value

$deleteFromModel1FileLocator

$id_or_value

$inColumnName

$deleteFromModel1FileLocator

$asAdd_orElseModify

$keyAndParameter

$update_column_and_value

$whereColumn_and_value

$logic

$operator

$column_and_value

$selectColumn

$logic

$operator

$columnSetSQLProperty

$initDefaultRowList

$silent

@destroy Crete Table

$count

$ignoreColumn

$fieldAndPossibleValueArrayList

$initField

$convertToModel

Generate Demo Text

$userInfo = ['user_name'=>'samtax', 'password'=>'1234', 'email'=>'samtax01@gmail.com', 'role'=>(new User())->role ]; $userAdmin = ['user_name'=>'samtax_admin', 'password'=>'1234', 'email'=>'samsoniyanu@hotmail.com', 'role'=>'admin']; User::insert(User::generateDemoData(1,null, null, $userInfo)[0], ['user_name', 'email']); User::insert(User::generateDemoData(1,null, null, $userAdmin), ['user_name', 'email']);

$insert

$count

$ignoreColumn

$fieldAndPossibleValueArrayList

$initField

@create Delete Table

$addBackupToSession

$backupAndRestore

$backupAndRestore

$addBackupToSession

$optionalBackupFilePath

Where to save backup json data

$fromFilePath

Load JSON Data from FilePath

$clearExistingData

$saveToFilePath

Save JSON Data to FilePath

$addBackupToSession

$limitRowToClone

Clone or Duplicate table data Clone or Duplicate table data

$column_and_value

$uniqueColumnKey

$uniqueColumnLogic

$replaceOldEqualRow

[Delete any row with equal inserting data. Note... Use to Care, to avoid lost of valued data]

$column_and_value

$insertUniqueColumnKey

$insertUniqueColumnLogic

$primary_key_name_to_find_exists_model

$asArrayObject

$whereRawClause

( e.g 'where id = 1')

$selectColumn

$where

$selectColumnName

$where

$keyColumnName

( Option of Combo Box)

$valueColumnName

( $keyForValue)

$where

$columnQuery

E.G ['count(*)as data'], ['sum(amount)as data'],

$returnAsSingleColumn

$arr

$columnKeyName

$column_and_value

$logic

$myForeignReferenceKeyName

id i declared for table i wanted to reference

$foreignTableName

Example 'users'

$foreignTablePrimaryId

'users' primary key ( usually id )

$deleteCascade

should associated data be deleted on 'users' account deleted

$column_and_value

This Verify the input "$column_and_value" with models column dat exists, and $column_and_value that does not exists in Model

$column_and_value

$removeEmptyData

$uniqueColumnKey

$logic

Return Update Query Return Update Query

$variableEqualValueArrayList

$optionalName

$optionalName

$asFullModel

$optionalName

$update_column_and_value

$where_column_and_value

$logic

$operator

Return Update Query Return Update Query

$columnsToSearchFrom

$textToSearch

$logic

$operator

Run Many Where Query Against Columns(s) E.G function search($text){ echo static::whereValuesInColumns($columns = ['title', 'body'], $values = ["%$text%", "$text"], $logic = 'OR', $operator = ' LIKE ') } OUTPUT : where title LIKE "%text%" OR title LIKE "text" OR body LIKE "%text%" OR body LIKE "text"

Use to SelectMany $builder = Book::selectMany(false, ' WHERE '.MySql1::toWhereValuesInColumnsQuery(['title', 'body'], $searchBreak, 'OR', ' LIKE ').' ORDER BY updated_at desc', Book::$COMMON_FIELD_LITE);

$columns

$query

$values

$columns

$logic

$values

$operator

$logic

$query

$operator

Run Many Where Query Against Columns(s) E.G function search($text){ echo static::whereValuesInColumns($columns = ['title', 'body'], $values = array_merge(["%$text%"] explode(' ', $text)), $logic = 'OR', $operator = ' LIKE ') }

     OUTPUT :  title LIKE "%text%" OR title LIKE "text" OR body LIKE "%text%" OR body LIKE "text"
         OR
     ["query" => " title  LIKE  ?  OR  body  LIKE  ? ",       "value" =>  ["%fff%",  "%fff%"] ]

$query

$columns

$values

$logic

$operator

$column_and_its_value

$logic

$operator

$keyWrap

$valueWrap

$column_and_value

( to add to Database)

Return Insert Query Return Insert Query

Convert Any Model Table to Sql CRUD Query

TIMESTAMP: any null variable ends with _at or _date TEXT: any null variable varchar(250): string (any variable initialized to '' (string) ) INTEGER: number (any variable initialized to 0 (number), float ) BOOLEAN: true, false (any variable initialized to true or false )

$uploadMainDirectory

$file_name

$uploadMainDirectory

$onlyIfExists

$uploadMainDirectory

$uploadMainDirectory

$source_url

$file_name

$addUrlToModel1FileLocator

$compress

$uploadMainDirectory

(full_path) Upload File to Resources/assets/uploads/{$model}/{$model_id}/file_name

$file_name

$orDemoPictureUrl

$uploadMainDirectory

$file_name

$uploadMainDirectory

$filterExtensionList

$recursive

$fromModel1FileLocator

$filterExtensionList

$recursive

$file_name

$uploadMainDirectory