|Anonymous | Login | Signup for a new account||2017-12-14 19:29 EST|
|My View | View Issues | Change Log | Roadmap | Repositories | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0005161||ATutor||- no cat -||public||2013-01-23 11:20||2013-12-28 12:49|
|Target Version||2.1.1||Fixed in Version||2.2|
|Summary||0005161: Using mysqli database extension|
|Description||MySQLi allows to use extra functionality as prepare() which will allow to check the syntax of the sql query before its execution as well as proper variable conversions passed into the query using MySQL engine. This conversion will allow to eliminate the case of SQL injections and custom built data normalizing functions in the project.|
Also with the use of prepare it will be possible to create one generic SQL query function to query the database by passing SQL string and an array of variables. This way SQL querying could be normalized to only one function call everywhere in the project instead of using different query styling. Using one function everywhere will also minimize chances of SQL injections.
|Tags||No tags attached.|
|SVN Revision#||a52c8a1..5c3eb12 master -> master|
I have experienced a problem that could be quite hard to debug. Be
careful if you are going to upgrade mysql to mysqli, one thing to note
is the use of "mysql_fetch_row" vs "mysqli_fetch_row".
mysql: "returns ...or FALSE if there are no more rows. "
mysqli: "returns ...or NULL if there are no more rows. "
This can take up to infinite hours to trace. It will only tell you it
has a memory exhaust if you are checking returned value as === false.
|At the moment it is hard to think if currently we have any issues but it might be something useful once we will do the upgrade.|
|Enabled mysqli db access functions (install still needs testing)|
|closed for ATutor 2.2|
|2013-01-23 11:20||anovak||New Issue|
|2013-02-06 09:04||greg||Note Added: 0005965|
|2013-02-06 09:24||anovak||Note Added: 0005966|
|2013-02-06 09:32||anovak||Note Deleted: 0005966|
|2013-02-06 09:34||anovak||Note Added: 0005968|
|2013-03-07 10:30||greg||Relationship added||related to 0003699|
|2013-12-22 10:51||greg||Relationship deleted||related to 0003699|
|2013-12-22 10:52||greg||SVN Revision#||=> a52c8a1..5c3eb12 master -> master|
|2013-12-22 10:52||greg||Note Added: 0006573|
|2013-12-22 10:52||greg||Status||new => resolved|
|2013-12-22 10:52||greg||Fixed in Version||=> 2.2|
|2013-12-22 10:52||greg||Resolution||open => fixed|
|2013-12-22 10:52||greg||Assigned To||=> greg|
|2013-12-28 12:49||greg||Note Added: 0006596|
|2013-12-28 12:49||greg||Status||resolved => closed|
|Copyright © 2000 - 2017 MantisBT Team|