Open Sencillo  2014.008
 All Data Structures Files Functions Variables Pages
mysqlEdit Class Reference
Inheritance diagram for mysqlEdit:
mysql logMan

Public Member Functions

 newColumn ($name, $type="INT")
 
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 ()
 

Additional Inherited Members

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

Detailed Description

Definition at line 117 of file core_sql.php.

Member Function Documentation

createTable (   $name)

Definition at line 145 of file core_sql.php.

delete (   $if)

Definition at line 212 of file core_sql.php.

insert (   $values)

Definition at line 173 of file core_sql.php.

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

Create new column with type

Parameters
string$namecolumn
string$typecolumn

Definition at line 136 of file core_sql.php.

openTable (   $name)

Open table and read all column names

Parameters
string$name

Definition at line 155 of file core_sql.php.

output (   $if = "`id`>0",
  $order = "`id` ASC",
  $limit = 1000 
)

Definition at line 231 of file core_sql.php.

set (   $column,
  $value 
)

Use befor update - edit value in the column

Parameters
string$column
string$value

Definition at line 183 of file core_sql.php.

update (   $if,
  $sets = null 
)

Definition at line 201 of file core_sql.php.


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