Version 1 (modified by 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