Completed

Update 300-400 MySQL queries to MySQLI

This project was successfully completed by sunilexpert for $250 AUD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$250 - $750 AUD
Completed In
3 days
Total Bids
60
Project Description

We need all the MySQL queries in our CMS updated to MySQLI.

Most of the queries are pretty simple, so it's not a complicated job, just needs to be done one by one until they're all complete e.g

$query = "SELECT * FROM `gallery_category` WHERE `gallery_id` = '" . (int)$categoryId . "'";
if ($gallery = $this -> dbRow($query)) {

return $gallery;
}

would need to become:

$query = "SELECT * FROM `gallery_category` WHERE `gallery_id` = ?";
$parameters = array($categoryId);
if ($gallery = Database::dbRow($query, $parameters)) {

return $gallery;
}
-----------

This needs to be done to all queries in the application. I will provide a copy of the CMS and instructions on where to locate any queries as well as a database file so you can test it works with your changes.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online