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

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado Pagado a la entrega

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

Nº del proyecto: #12149583

Sobre el proyecto

28 propuestas Proyecto remoto Activo hace 7 años

28 freelancers están ofertando un promedio de €329 por este trabajo

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 en 7 días
(1301 comentarios)
9.6
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 Más

€250 EUR en 10 días
(419 comentarios)
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 en 6 días
(391 comentarios)
8.4
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 en 0 días
(1019 comentarios)
8.0
vickycolt

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

€250 EUR en 10 días
(244 comentarios)
7.4
zahidsaeed96

Hello there! That's good that you are migrating to PDO which obviously is more secure and advanced so allow me to do this job for you. Working with PDO is almost my daily job. Your work will be completed by tomorrow n Más

€250 EUR en 1 día
(67 comentarios)
6.4
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 Más

€777 EUR en 15 días
(16 comentarios)
5.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 Más

€260 EUR en 2 días
(22 comentarios)
5.1
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 en 4 días
(26 comentarios)
4.4
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 Más

€250 EUR en 5 días
(5 comentarios)
4.3
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 Más

€277 EUR en 3 días
(9 comentarios)
3.5
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 en 4 días
(6 comentarios)
3.4
eshwarprithvi

I already did this in my academic project. So i am pretty sure i can help you sir. I am good at mysql in OOPS

€250 EUR en 10 días
(0 comentarios)
0.0
shiznit213

I find your advertisement, when I noticed that you are looking for a software developer in Java language with experience and Object-oriented view. I don't like to talk too much about my carrier, I think the present and Más

€277 EUR en 4 días
(0 comentarios)
0.0
m1pko

It's a rather repetetive task although, if one uses the right tools, it may be somewhat simplified. I estimate 1 day to anslyse the queries and the other 5 to perform the required changes.

€500 EUR en 6 días
(0 comentarios)
0.0