Difference between revisions of "Database upgrade"

From OpenEMR Project Wiki
(Created page with "Upgrading ADODB to PDO. Remove all sqlFetchArray() calls. Example `$res2 = sqlStatement("select * from lang_languages where lang_description = ?",array($GLOBALS['language_defau...")
 
(Replaced content with "Upgrading ADODB to PDO. Todo: * Remove tables config & config_seq * Migrate category_to_document table")
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
Upgrading ADODB to PDO.
Upgrading ADODB to PDO.


Remove all sqlFetchArray() calls.
Todo:


Example
* Remove tables config & config_seq
`$res2 = sqlStatement("select * from lang_languages where lang_description = ?",array($GLOBALS['language_default']));
* Migrate category_to_document table
for ($iter = 0;$row = sqlFetchArray($res2);$iter++)
          $result2[$iter] = $row;`
 
Becomes
`$result2 = sqlStatement("select * from lang_languages where lang_description = ?",array($GLOBALS['language_default']));`

Latest revision as of 01:23, 3 November 2016

Upgrading ADODB to PDO.

Todo:

* Remove tables config & config_seq
* Migrate category_to_document table