In Progress

Update 300-400 MySQL queries to MySQLI

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.

Skills: CMS, MySQL, PHP

See more: update mysqli, update mysql, queries, mysqli, mysql pretty, php cms update, mysql php cms, return query database php, mysql update select query, 300 array, array 300, php application update, simple file cms, mysql file update, update database mysql file, cms simple update, cms simple mysql, update query, update queries mysql, update array mysql, simple php mysql query, simple cms file database, php mysql array, cms php mysql works, array update php

About the Employer:
( 7 reviews ) Prahran, Australia

Project ID: #4693121

Awarded to:

sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have experience in PHP, MySQL, Ajax, Javascript etc. You can see feedback against my profile they are always awes More

$250 AUD in 3 days
(71 Reviews)
6.0

57 freelancers are bidding on average $455 for this job

linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below [url removed, login to view] More

$824 AUD in 3 days
(752 Reviews)
8.3
seekdeveloper

Hi, Consider its done! I would love to get this opportunity of working with you. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. Thanks

$773 AUD in 7 days
(103 Reviews)
8.6
webqueue

We are ready to endow with the solution as per your [url removed, login to view] check your PMB to see our previous work. Thank You.

$721 AUD in 20 days
(352 Reviews)
8.4
morff

Hi, i'm professional developer and administrator, i have strong knowledge of geolocation and related technologies, and i would like to offer you my services. Basically what i offer is app based on google maps, or any o More

$398 AUD in 8 days
(269 Reviews)
7.3
tlchung

Skill in php and mysql I can do the mysqli sql query conversion for you

$250 AUD in 3 days
(371 Reviews)
7.3
neoconcepts

php , mysql expert. i can convert to mysqli query. let's start.

$515 AUD in 3 days
(150 Reviews)
7.5
coolguyinus2004

Expert here. can handle it no issues.

$386 AUD in 1 day
(338 Reviews)
7.6
drailean

Hello, please check the PM

$452 AUD in 7 days
(263 Reviews)
6.9
phpXpertbd

I specialize in similar projects. Please check PM for more details.

$460 AUD in 3 days
(51 Reviews)
6.8
ValueCoders

Hi, Experts team of CMS/PHP/Wordpress/Joomla/Cakephp/Drupal/SEO/AJAX/Codeigniter developers and designers. Thanks Gaurav Valuecoders

$639 AUD in 15 days
(124 Reviews)
7.1
C0RETECHIES

Hello Sir,We can easily complete your [url removed, login to view] check PMB

$526 AUD in 10 days
(89 Reviews)
7.4
USAGraphicPR0

**********************.. YOUR SEARCH ENDS HERE .. ********************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and More

$1030 AUD in 8 days
(39 Reviews)
7.4
ganeshbaid

Time bounded Delivery. Fast and Quick Response. Quality Assured. Lets do it. Check PMB for more details.

$800 AUD in 20 days
(147 Reviews)
7.2
phpwebsoft

I would like to work on the project.

$250 AUD in 3 days
(235 Reviews)
6.9
cheapexcell

Ready to start

$515 AUD in 3 days
(135 Reviews)
6.7
RITESHBATHWAL

I am ready to do this task. Project description is quite clear and I am confident to complete it soon.

$250 AUD in 4 days
(181 Reviews)
6.6
s17

I provide efficient, professional service.

$555 AUD in 11 days
(343 Reviews)
6.5
techwelfare

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$736 AUD in 12 days
(142 Reviews)
6.9
netquart

Hello, Expert Developer Here. Let's start. Thanks.

$250 AUD in 3 days
(65 Reviews)
6.3
ecartsolutions

PHP Mysql expert here. We can help you with the query changes. We can start right away and get it done in a 3 day period with complete testing done. Awaiting your reply, Hari

$368 AUD in 3 days
(267 Reviews)
6.4