Rewrite all occurances of mysql_query() to MySQLi/Prepared Statements
€30-250 EUR
S-au achitat serviciile după ce au fost prestate
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.
ID Proiect: #12225759
Detalii despre proiect
Acordat lui:
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 freelanceri plasează o ofertă medie de 166€ pentru proiect
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 Mai multe
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 Mai multe
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. ------------------------------------------------------------------------------------- Mai multe
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 Mai multe
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 Mai multe
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 Mai multe