Changes between Initial Version and Version 1 of support-team/mysql-mysqli-conversion


Ignore:
Timestamp:
Apr 17, 2014, 12:41:55 AM (10 years ago)
Author:
Ross
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • support-team/mysql-mysqli-conversion

    v1 v1  
     1= Step for converting red to use mysqli =
     2This page documents how to convert red to use mysqli instead of mysql.
     3
     4== Function changes ==
     5Since mysqli is not a drop in replacement for mysql, we need to determine the necessary function changes required by mysqli.
     6
     7Currently red uses 10 mysql functions, below is a description of each one and the comparable function in mysqli.
     8
     9=== mysql_connect ===
     10=== mysql_data_seek ===
     11=== mysql_error ===
     12=== mysql_fetch_array ===
     13=== mysql_fetch_assoc ===
     14=== mysql_fetch_row ===
     15=== mysql_insert_id ===
     16=== mysql_num_rows ===
     17=== mysql_query ===
     18=== mysql_select_db ===
     19
     20== These function occur in 22 different files ==
     21 * common/share/src/class.red_ado.inc.php
     22 * common/share/src/class.red_db.inc.php
     23 * common/share/src/red.utils.inc.php
     24 * docs/sql/2009-07-08.php
     25 * node/sbin/find-inactive
     26 * node/sbin/red-dump-db-list
     27 * node/sbin/red-node-update
     28 * node/sbin/red-set-mysql-connection-limits
     29 * node/share/src/modules/class.red_item_mysql_db_node_mysql.inc.php
     30 * node/share/src/modules/class.red_item_mysql_user_node_mysql.inc.php
     31 * ui/sbin/create-reverse-ip
     32 * ui/sbin/import-addresses
     33 * ui/sbin/import-dns
     34 * ui/sbin/import-users-and-email-addresses
     35 * ui/sbin/mv-server-name-and-alias
     36 * ui/sbin/populate-member-end-date
     37 * ui/sbin/print-invoice
     38 * ui/sbin/transfer-red-items-to-new-host
     39 * ui/share/src/class.red_api.inc.php
     40 * ui/share/src/functions.inc.php
     41 * ui/www/extras/change_password/index.php
     42 * ui/www/extras/reset_password/index.php