Open Sencillo  2015.003
Long live the simplicity of PHP
 All Data Structures Namespaces Functions
mysqlEdit Class Reference
Inheritance diagram for mysqlEdit:
mysql logMan mysqlInterface

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, $DBName, $DBUser, $DBPass)
 
 query ($sql)
 
 write ($sql)
 
 close ()
 
 test ()
 
 integrity ($type)
 

Additional Inherited Members

- Data Fields inherited from mysql
 $DBHost
 
 $DBName
 
 $DBUser
 
 $DBPass
 
 $con
 

Detailed Description

Definition at line 118 of file core_sql.php.

Member Function Documentation

newColumn (   $name,
  $type = "INT" 
)

Create new column with type

Parameters
string$namecolumn
string$typecolumn

Definition at line 138 of file core_sql.php.

openTable (   $name)

Open table and read all column names

Parameters
string$name

Definition at line 176 of file core_sql.php.

prepareTable (   $name)

Light alternative to openTable

Parameters
string$name

Definition at line 147 of file core_sql.php.

set (   $column,
  $value 
)

Use befor update - edit value in the column

Parameters
string$column
string$value

Definition at line 205 of file core_sql.php.

uniqueKey (   $keyName)

Create unique key. Use after prepareTable.

Parameters
string$keyName

Definition at line 156 of file core_sql.php.


The documentation for this class was generated from the following file: