|
OpenSencillo
2015.009
Long live the simplicity of PHP
|
Public Member Functions | |
| newColumn ($name, $type="INT") | |
| prepareTable ($name) | |
| uniqueKey ($keyName) | |
string $name | |
Create table (use after newColumn function) | |
| createTable ($name) | |
| openTable ($name) | |
| insert ($values) | |
| set ($column, $value) | |
| update ($if, $sets=null) | |
| delete ($if) | |
| output ($if="`id`>0", $order="`id` ASC", $limit=1000) | |
Public Member Functions inherited from mysql | |
| __construct ($DBHost=null, $DBName=null, $DBUser=null, $DBPass=null) | |
| query ($sql) | |
| write ($sql) | |
| close () | |
| test () | |
| integrity ($type) | |
Additional Inherited Members | |
Data Fields inherited from mysql | |
| $DBHost | |
| $DBName | |
| $DBUser | |
| $DBPass | |
| $con | |
Definition at line 124 of file core_sql.php.
| newColumn | ( | $name, | |
$type = "INT" |
|||
| ) |
Create new column with type
| string | $name | column |
| string | $type | column |
Definition at line 144 of file core_sql.php.
| openTable | ( | $name | ) |
Open table and read all column names
| string | $name |
Definition at line 182 of file core_sql.php.
| prepareTable | ( | $name | ) |
| set | ( | $column, | |
| $value | |||
| ) |
Use befor update - edit value in the column
| string | $column | |
| string | $value |
Definition at line 211 of file core_sql.php.
| uniqueKey | ( | $keyName | ) |
Create unique key. Use after prepareTable.
| string | $keyName |
Definition at line 162 of file core_sql.php.