Convert all occurances of mysql_query() to corresponding MySQLi/Prepared Statements

已关闭

描述

I have a PHP project which has around 550 occurrences of the mysql_query function.

These need to be replaced by the corresponding MySQLi methods and prepared statements.

To give an example ($dbh is a PDO object that is available to you in every file):

Rewrite this:

$sql = "SELECT * FROM users WHERE id LIKE '$id' LIMIT 1";

$result = mysql_query($sql) or die(mysql_error());

$row = mysql_fetch_array($result);

To this:

$sql = "SELECT * FROM users WHERE id LIKE :id LIMIT 1";

$stmt = $dbh->prepare($sql);

$stmt->execute(array(':id' => $id));

$row = $stmt->fetch();

If you have any questions let me know.

技能: MySQL, PHP, SQL

查看更多: convert query mssql mysql, convert query sql mysql, ms sql query mysql convert, mysql convert query csv shell, mysql convert hash password, mysql convert md5 hash, mysql convert sql asp, mysql convert utf php, send query remote mysql, mysql convert xls, mysql convert database utf, mysql convert xml, mysql convert latin2 utf, mysql convert database utf8, convert file mysql

Project ID: #12149583

31 freelancers are bidding on average €328 for this job

rinsadsl

Hello Good Day We are experts in mysql to PDO conversion. We can convert all 500+ mysql usages to PDO. Looking forward to work with you. Thanks Rinsad

€368 EUR 在7天内
(764条评论)
8.2
searchtechnow

Hi mate, I understand your problem mysql is deprecated now mysqli is using instead of mysql. It will take approx 6-7 days to change and test all the pages. Please initiate chat to discuss more. Regards

€300 EUR 在6天内
(292条评论)
7.9
vickycolt

Hi sir,I have read the description and understood the requirements. I can start right away.Thanks....................

€250 EUR 在10天内
(165条评论)
6.8
webXpart

I have gone through the details you have provided in your project details. Please check below links for my Freelancer profile and my work profile. If you interested please let me know so we can discuss in details a 更多

€355 EUR 在5天内
(45条评论)
6.6
ineedWorkJob

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/b 更多

€250 EUR 在5天内
(102条评论)
6.3
€555 EUR 在10天内
(43条评论)
5.9
€555 EUR 在5天内
(3条评论)
5.7
RubyOnRail

Hello, Its a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work upon customization part, if we can proceed towards more discussion. I have gone through your project 更多

€777 EUR 在15天内
(5条评论)
5.5
€250 EUR 在10天内
(28条评论)
5.0
tmawebsolut

I’m an experienced PHP, ASP, JavaScript, HTML5 developer and web designer so I can replace all the occurrences you need. I have developed e-commerce websites, custom content management systems, web applications, w 更多

€277 EUR 在7天内
(16条评论)
4.9
sr33raj

hello sir the php mysql_query is deprecated so i can change all your mysql_query to mysqli or PDO within few hours

€250 EUR 在0天内
(44条评论)
4.9
multimas

Hi there!! Sir i am ready to start working on your project. I have more than 3 year experience in web development. I will provide you quality work as per your requirements. I am waiting your positive response. I will d 更多

€260 EUR 在2天内
(12条评论)
4.0
kartickkoley1995

Greetings! I’m an expert, having very magnificent expertise on WordPress and Search Engine Optimization, various kinds of Administrative support, Graphics Design like Logo, Banner, Brochure, Business Cards and so on re 更多

€388 EUR 在6天内
(15条评论)
4.1
€250 EUR 在10天内
(14条评论)
3.8
cmitexperts

Hi there! Did go through your Job Description and glad to share that I have experience in working with wordpress platform. I have more than four years of industry experience and have been the part of diverse industr 更多

€250 EUR 在10天内
(22条评论)
3.5
Grunty

Hi there, I've done very similar work to convert a large VB5 project to VB.NET. I built a tool to convert all database commands from old DAO Access to ADO.NET. I can do the same in your source files -- adjusting to 更多

€250 EUR 在5天内
(2条评论)
3.4
MrSabir

Hey there :-) I can start working on this right away :-) Drop me a PM and we can start. Should be done in about 4-6 days :-) Thanks, Sabir

€250 EUR 在4天内
(12条评论)
3.3
chungchichai

Hi Sir, I am very experience in PHP and I just completed a similar project for a client: https://www.freelancer.com/projects/php/Fix-extension/ The mysql for php is deprecated and we need to replace all to mysql 更多

€250 EUR in 1 day
(7条评论)
3.3
caglard

Hello, I've developed many applications with php and mysql. Sure I have enough experience to complete this job. Currently I am available and ready to start to work. Contact me, thanks...

€250 EUR 在4天内
(3条评论)
2.6
nehulagrawal05

i am READY..............i am READY..............i am READY..............i am READY..............i am READY..............i am READY..............i am READY..............i am READY..............i am READY..............i 更多

€277 EUR 在3天内
(4条评论)
2.7