PHP v_replace示例

示例#1

文件： field_post.php 项目： eddylin2015/sportdayPHPWebsite

$result = mysql_query("select lock_item from field_item where fi_id=" . $fiid, $con);
$flag = true;
while ($row = mysql_fetch_row($result)) {
    if ($row[0] == 1) {
        $flag = false;
        echo "Locked1";
    }
}
//ESDB::OpenConnUTF8();
if (flag) {
    foreach ($json as $key => $value) {
        list($f, $id) = split('_', $key);
        $sql = "update field_rc set {$f}=\"" . v_replace($value) . "\" where frc_id='{$id}' ";
        //and staf_ref='$regstafref';";
        if ($f == 'HJ') {
            $sql = "update field_item set {$id}=\"" . v_replace($value) . "\" where fi_id='{$fiid}' ";
            echo $sql;
        }
        mysql_query($sql, $con);
        if (mysql_affected_rows($con) == 1) {
            echo "({$key}) 1 µ§\n";
        }
        // print "$key => $value\n".$sql;
    }
}
mysql_close($con);
//ESDB::CloseConn();
?>

示例#2

文件： race_post.php 项目： eddylin2015/sportdayPHPWebsite

}
$db_selected = mysql_select_db(cfg::$db, $con);
mysql_query("SET NAMES UTF8");
$result = mysql_query("select lock_item from sport_item where si_id=" . $_REQUEST['siid'], $con);
$flag = true;
while ($row = mysql_fetch_row($result)) {
    if ($row[0] == 1) {
        $flag = false;
        echo "Locked1";
    }
}
//ESDB::OpenConnUTF8();
if (flag) {
    foreach ($json as $key => $value) {
        list($f, $id) = split('_', $key);
        $sql = "update sport_rc set {$f}=\"" . v_replace($value) . "\" where rc_id='{$id}' ";
        //and staf_ref='$regstafref';";
        mysql_query($sql, $con);
        if (mysql_affected_rows($con) == 1) {
            echo "({$key}) 1 µ§\n";
        }
        // print "$key => $value\n".$sql;
    }
}
mysql_close($con);
//ESDB::CloseConn();
?>