439
edits
Module CustomFields Dev: Difference between revisions
Jump to navigation
Jump to search
→General purpose SQL methods
| Line 214: | Line 214: | ||
* executeMultiSQL($sql, $eventname) to execute multiple SQL queries | * executeMultiSQL($sql, $eventname) to execute multiple SQL queries | ||
* fetchFieldStruct($id=null, $nohide=false, $table=null, $cachepath=null) allows you to fetch the field's SQL structure of not only custom fields, but of any database's column using the $table variable. Eg: fetchFieldStruct('mycolumn', true, 'mytable'); | * fetchFieldStruct($id=null, $nohide=false, $table=null, $cachepath=null) allows you to fetch the field's SQL structure of not only custom fields, but of any database's column using the $table variable. Eg: fetchFieldStruct('mycolumn', true, 'mytable'); | ||
* probeTable($table) helps you to check if a table exists in the database | |||
* fetch_object($resource) will return a PHP object from a $resource, similarly to mysql_fetch_object() but with two advantages: it works on several DBMS (not only mysql), and it always return lowercase properties names (else depending on the configuration of the DBMS, the request can return uppercase or mixed case properties names). | |||
* escape() and reverse_escape() are similare to mysql_real_escape but is reversible and DBMS-independent (so you can use it with other DBMSes). | |||
== Managing CustomFields structure == | == Managing CustomFields structure == | ||