hiGridDB
public class hiGridDB
| Method Summary | |
|---|---|
| static void | |
| static void | prepare(mixed connhigrid, mixed sqlElement, mixed params, bool bind) |
| static void | limit(mixed sqlId, mixed dbtype, int nrows, int offset, str order, str sort) |
| static void | execute(mixed psql, mixed prm) |
| static void | query(mixed connhigrid, mixed sql) |
| static boolean | bindValues(resurce stmt, array binds, array types) Bind the values for CRUD using the PDO bindValue. |
| static void | beginTransaction(mixed connhigrid) |
| static void | commit(mixed connhigrid) |
| static void | rollBack(mixed connhigrid) |
| static number | lastInsertId(mixed connhigrid, mixed table, mixed IdCol, mixed dbtype) Return the last inserted id in a table in case when the serialKey is set to true |
| static void | fetch_object(mixed psql, mixed fetchall, mixed connhigrid) |
| static void | fetch_num(mixed psql) |
| static void | fetch_assoc(mixed psql, mixed connhigrid) |
| static void | closeCursor(mixed sql) |
| static void | columnCount(mixed rs) |
| static void | getColumnMeta(mixed index, mixed sql) |
| static string | MetaType(array t, string dbtype) Return the meta type of the field based on the underlayng db |
| protected static string | MetaPgsql(string native_type, integer max_length, int max_len) The meta types for PostgreSQL database |
| protected static string | MetaMysql(string native_type, integer max_length) The meta types for MySQL database |
| protected static string | MetaSqlite(string native_type, integer max_length) The meta types for SQLite database |
| protected static string | MetaSqlsrv(string native_type, integer max_length) The meta types for SQLite database |
| static mixed | getPrimaryKey(mixed table, mixed connhigrid, mixed dbtype) Try to get the primary key of the table automattically |
| static void | errorMessage(mixed connhigrid) Discover primary key column(s) for this table. |
public static void getInterface()
public static void prepare(mixed connhigrid, mixed sqlElement, mixed params, bool bind)
public static void limit(mixed sqlId, mixed dbtype, int nrows, int offset, str order, str sort)
public static void execute(mixed psql, mixed prm)
public static void query(mixed connhigrid, mixed sql)
public static boolean bindValues(resurce stmt, array binds, array types)
Bind the values for CRUD using the PDO bindValue. In case of table we use the type to bind the values accordantly. In case of custom SQL we use the default PDO::PARAM
public static void beginTransaction(mixed connhigrid)
public static void commit(mixed connhigrid)
public static void rollBack(mixed connhigrid)
public static number lastInsertId(mixed connhigrid, mixed table, mixed IdCol, mixed dbtype)
Return the last inserted id in a table in case when the serialKey is set to true
public static void fetch_object(mixed psql, mixed fetchall, mixed connhigrid)
public static void fetch_num(mixed psql)
public static void fetch_assoc(mixed psql, mixed connhigrid)
public static void closeCursor(mixed sql)
public static void columnCount(mixed rs)
public static void getColumnMeta(mixed index, mixed sql)
public static string MetaType(array t, string dbtype)
Return the meta type of the field based on the underlayng db
protected static string MetaPgsql(string native_type, integer max_length, int max_len)
The meta types for PostgreSQL database
protected static string MetaMysql(string native_type, integer max_length)
The meta types for MySQL database
protected static string MetaSqlite(string native_type, integer max_length)
The meta types for SQLite database
protected static string MetaSqlsrv(string native_type, integer max_length)
The meta types for SQLite database
public static mixed getPrimaryKey(mixed table, mixed connhigrid, mixed dbtype)
Try to get the primary key of the table automattically
public static void errorMessage(mixed connhigrid)
Discover primary key column(s) for this table.