Clase para realizar consultas en la base de datos.
| package | db |
|---|---|
| license | MIT License |
| link | http://jharo.net |
| author | Juan Haro |
createDb(\type $dbName)
\type
createTable(\type $tableName, \fieldSet $fieldSet)
dbExists(\type $dbName) : boolean
\type
booleandelete(string $table, string $conditions) : \type
DELETE FROM $table WHERE $conditions
string
string
\typedeleteTable(\type $tableName)
\type
describe(string $table) : \type
string
\typeexecute(string $query) : \type
getLastId() : \type
\typeinsert(string $table, array $fields) : \type
INSERT INTO $table ($fields) VALUES ($values)
string
array
\typerenameTable(\type $oldTableName, \type $newTableName)
select(string $fields, string $table, string $conditions) : \$result_query;
SELECT $fields FROM $table $conditions
string
string
string
\$result_query;tableExists(\type $tableName) : boolean
\type
booleanupdate(string $table, array $fields, string $conditions) : \type
UPDATE $table SET $field=$value ... WHERE $conditions
string
array
string
\type