关闭

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

该项目收到36 来自天才威客的竞标,平均竞标价格为€334 EUR

为像这样的项目获取免费报价
雇主工作
项目预算
€250 - €750 EUR
全部竞标
36
项目描述

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.

需要技能

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online