Rewrite all occurances of mysql_query() to MySQLi/Prepared Statements
€30-250 EUR
Paid on delivery
I have a PHP project which has around 542 occurrences of the mysql_query function.
These need to be rewritten using 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.
To answer a common question:
The mysql_query function is used in 140 of the 288 PHP files.
I can provide a list with all occurrences (file name + line number).
I did a recount and it is actually 662 occurrences of the mysql_query function.
I used "grep -or 'mysql_query' . | wc -l" for the counting.
Sorry for the inconvenience.
Project ID: #12225759
About the project
Awarded to:
Hello! No need for list of file/occurrencies to be hones. There's not much that need discussing either. Can work on this as soon as you move forward with the project. Regards, Dobri
59 freelancers are bidding on average €166 for this job
Hello Sir., I am ready to start it.i am highly interested in your project But i have some questions for you. So kindly leave message for me, then i'll discuss it in depth.
Hello We will rewrite all 542 occurrences or more of of the mysql_query function to mysqli Rest be assured we have done this for lot of clients after webhosts have upgraded MySQL version 4.1.13 which uses MySQLi ex More
Hi there, I am interested in more details that you can provide for the project. Message me to discuss in details. Please take a look at our client's experience with us here https://www.freelancer.com/u/marchinga More
Greetings, We would like to avail required solution. And can start immediately. To start provide, code and db with sample data. Best Regards.
I am a skilled developer, I can update your site to use mysqli rather than mysql. let discuss more via private message, thanks.
Hi, Let’s start. Visit my profile and see the reviews. I am highly interested to work on this project. I understand your requirements. I am 100% sure I can complete within timeline with quality Regards Jui
Hi I have understand what you need. Please accept the bid and send me the files. I am ready to start it. Thanks Shihan
sir pm me i can do this .. sir pm me i can do this .. sir pm me i can do this .. sir pm me i can do this ..
PHP Program Developer 100% Satisfaction Guaranteed 7 Years Experienced Invite To Chat Discuss Further Details!
Hi there, I have read the project details. This is an easy job for me. 2 days are more than enough for me. Message me, we can discuss over chat.
Updated php?)) I was in the same situation ok. I can do it. I will copy code into my server, work with it and then give it to You. ------------------------------------------------------------------------------------- More
I am dedicated developer who believe in providing quality work within time frame. I will serve you in following PHP, Jquery, Javascript, Ajax, HTML,CSS, Joomla, Cakephp, Worpress, PSD to Responsive HTML5. I am looking More
I have done mysql to mysqli upgrade to many sites and php version updates to php scripts. I have good experience. Thanks, Suraj
Greetings I have read your job description and I want to talk about more that regards that I can do that project within the time frame I have more than 3 years’ experience in web development skills like PHP WordPre More
Hi there! I'm an experienced software developer working on both .net and php technologies. And I can help you doing this conversion from the deprecated mysql_* functions to the new recommended by php standards. I More
