PHP LogSQLErr Examples

Example #1

File: race_lock.php Project: eddylin2015/sportdayPHPWebsite

function v_replace($source)
{
    $a = array("\\", '"', ",");
    $b = array('', "'", "'");
    $res = str_replace($a, $b, $source);
    return $res;
}
$siid = $_REQUEST['siid'];
$keycode = $_REQUEST['keycode'];
$regstafreg = $_REQUEST['regstafref'];
if ($keycode != '111233234577553311') {
    echo 'ERROR!ERROR! no right!';
    exit;
}
$errortxt = "";
LogSQLErr("lock" . $siid, $regstafreg);
$con = mysql_connect(cfg::$dbhost, cfg::$dbuser, cfg::$dbpwd);
if (!$con) {
    die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db(cfg::$db, $con);
mysql_query("SET NAMES UTF8");
mysql_query("update sport_item set lock_item=1  where si_id=" . $siid, $con);
if (mysql_affected_rows($con) == 1) {
    echo "lock 1 ��({$siid})\n";
}
mysql_close($con);
//ESDB::CloseConn();
?>

Example #2

File: field_post.php Project: eddylin2015/sportdayPHPWebsite

{
    $a = array("\\", '"', ",");
    $b = array('', "'", "'");
    $res = str_replace($a, $b, $source);
    return $res;
}
$json = $_REQUEST['datajson'];
$keycode = $_REQUEST['keycode'];
$regstafreg = $_REQUEST['regstafref'];
$fiid = $_REQUEST['siid'];
if ($keycode != '111233234577553311') {
    echo 'ERROR!ERROR! no right!';
    exit;
}
$errortxt = "";
LogSQLErr(print_r($json, true), $regstafreg);
include_once 'inc/config.php';
$con = mysql_connect(cfg::$dbhost, cfg::$dbuser, cfg::$dbpwd);
if (!$con) {
    die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db(cfg::$db, $con);
mysql_query("SET NAMES UTF8");
$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";
    }
}

Example #3

File: race_post.php Project: eddylin2015/sportdayPHPWebsite

function v_replace($source)
{
    $a = array("\\", '"', ",", "*", "-");
    $b = array('', "'", "'", "'", "'");
    $res = str_replace($a, $b, $source);
    return strtoupper($res);
}
$json = $_REQUEST['datajson'];
$keycode = $_REQUEST['keycode'];
$regstafreg = $_REQUEST['regstafref'];
if ($keycode != '111233234577553311') {
    echo 'ERROR!ERROR! no right!';
    exit;
}
$errortxt = "";
LogSQLErr("siid_" . $_REQUEST['siid'] . "_" . print_r($json, true), $_SERVER['PHP_AUTH_USER']);
$con = mysql_connect(cfg::$dbhost, cfg::$dbuser, cfg::$dbpwd);
if (!$con) {
    die('Could not connect: ' . mysql_error());
}
$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();