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
Project Budget
$250 - $750 AUD
Completed In
3 days
Total Bids
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.

Completed by:
Skills Required

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