wiki:support-team/mysql-mysqli-conversion

Version 1 (modified by Ross, 10 years ago) (diff)

--

Step for converting red to use mysqli

This page documents how to convert red to use mysqli instead of mysql.

Function changes

Since mysqli is not a drop in replacement for mysql, we need to determine the necessary function changes required by mysqli.

Currently red uses 10 mysql functions, below is a description of each one and the comparable function in mysqli.

mysql_connect

mysql_data_seek

mysql_error

mysql_fetch_array

mysql_fetch_assoc

mysql_fetch_row

mysql_insert_id

mysql_num_rows

mysql_query

mysql_select_db

These function occur in 22 different files

  • common/share/src/class.red_ado.inc.php
  • common/share/src/class.red_db.inc.php
  • common/share/src/red.utils.inc.php
  • docs/sql/2009-07-08.php
  • node/sbin/find-inactive
  • node/sbin/red-dump-db-list
  • node/sbin/red-node-update
  • node/sbin/red-set-mysql-connection-limits
  • node/share/src/modules/class.red_item_mysql_db_node_mysql.inc.php
  • node/share/src/modules/class.red_item_mysql_user_node_mysql.inc.php
  • ui/sbin/create-reverse-ip
  • ui/sbin/import-addresses
  • ui/sbin/import-dns
  • ui/sbin/import-users-and-email-addresses
  • ui/sbin/mv-server-name-and-alias
  • ui/sbin/populate-member-end-date
  • ui/sbin/print-invoice
  • ui/sbin/transfer-red-items-to-new-host
  • ui/share/src/class.red_api.inc.php
  • ui/share/src/functions.inc.php
  • ui/www/extras/change_password/index.php
  • ui/www/extras/reset_password/index.php