PHP nullifの例

コード例 #1

ファイル: Service.php プロジェクト: jeevireddy/mega_hackathon

    $obj->EntryTime = date("Y-m-d H:i:s", time());
    $obj->ClickComment = nullif($_POST["ClickComment"]);
    $obj->CurrentPage = nullif($_POST["CurrentPage"]);
    $obj->clickContent = nullif($_POST["clickContent"]);
    $obj->Country = nullif($_POST["Country"]);
    $obj->City = nullif($_POST["City"]);
} else {
    $_SESSION["id"] = ClassSessions::sessionSettor();
    $obj->SessionID = nullif($_SESSION["id"]);
    $obj->clickType = nullif($_POST["clickType"]);
    $obj->EntryTime = date("Y-m-d H:i:s", time());
    $obj->ClickComment = nullif($_POST["ClickComment"]);
    $obj->CurrentPage = nullif($_POST["CurrentPage"]);
    $obj->clickContent = nullif($_POST["clickContent"]);
    $obj->Country = nullif($_POST["Country"]);
    $obj->City = nullif($_POST["City"]);
}
//print_r($obj);
function nullif($var)
{
    if (isset($var) && !empty($var)) {
        return $var;
    } else {
        return null;
    }
}
/*
$sql = "INSERT INTO  tbl_page_click_details".
"(session_id,ip_addr,curr_page_url,click_type,clicked_content,click_time,comments)".
" VALUES ('"
.$obj->SessionID."','".$obj->IPAddress."','".$obj->CurrentPage."','"

コード例 #2

ファイル: Service.php プロジェクト: jeevireddy/mega_hackathon

<?php

function nullif($var)
{
    if (isset($var) && !empty($var)) {
        return $var;
    } else {
        return null;
    }
}
$con = mysqli_connect("us-cdbr-iron-east-03.cleardb.net", "b5cc7e24bc5291", "4510e1e2", "ad_b0866641ccff844");
if (mysqli_connect_errno($con)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO  tbl_chathistory (Chat,Account_id,TimeStamp,Latitude,Longitude) VALUES ('" . nullif($_POST["Chat"]) . "',222115,sysdate(),40.91709,-72.709457)";
if (!mysqli_query($con, $sql)) {
    die('Error: ' . mysqli_error($con));
}
echo "1 record added";
mysqli_close($con);

コード例 #3

ファイル: TransactionService.php プロジェクト: sivavulli/mega_hackathon

     echo $obj->TransactionID;
     mysqli_close($con);
 } else {
     if (isset($_SESSION["id"]) && !empty($_SESSION["id"])) {
         $obj->SessionID = nullif($_SESSION["id"]);
         $obj->Comment = nullif($_POST["Comment"]);
         $obj->Status = nullif($_POST["Status"]);
         $obj->TransactionID = nullif($_POST["TransactionID"]);
         $obj->TransactionType = nullif($_POST["TransactionType"]);
     } else {
         $_SESSION["id"] = ClassSessions::sessionSettor();
         $obj->SessionID = nullif($_SESSION["id"]);
         $obj->Comment = nullif($_POST["Comment"]);
         $obj->Status = nullif($_POST["Status"]);
         $obj->TransactionID = nullif($_POST["TransactionID"]);
         $obj->TransactionType = nullif($_POST["TransactionType"]);
     }
     //print_r($obj);
     /*
     $sql = "INSERT INTO  tbl_page_click_details".
     "(session_id,ip_addr,curr_page_url,click_type,clicked_content,click_time,comments)".
     " VALUES ('"
     .$obj->SessionID."','".$obj->IPAddress."','".$obj->CurrentPage."','"
     .$obj->clickType."','".$obj->clickContent."','".$obj->EntryTime."','"
     .$obj->ClickComment."')";
     echo $sql;
     */
     $con = mysqli_connect("us-cdbr-iron-east-03.cleardb.net", "b5cc7e24bc5291", "4510e1e2", "ad_b0866641ccff844");
     if (mysqli_connect_errno($con)) {
         echo "Failed to connect to MySQL: " . mysqli_connect_error();
     }

コード例 #4

ファイル: PerformaceService.php プロジェクト: nanu146/mega_hackathon

    $obj->EntryTime = date("Y-m-d H:i:s", time());
    $obj->CurrentPage = nullif($_POST["CurrentPage"]);
    $obj->PageLoadTime = nullif($_POST["PageLoadTime"]);
    $obj->Country = nullif($_POST["Country"]);
    $obj->City = nullif($_POST["City"]);
    $obj->referrer = nullif($_POST["referrer"]);
} else {
    $_SESSION["id"] = ClassSessions::sessionSettor();
    $obj->SessionID = nullif($_SESSION["id"]);
    $obj->TimeSpent = nullif($_POST["TimeSpent"]);
    $obj->EntryTime = date("Y-m-d H:i:s", time());
    $obj->CurrentPage = nullif($_POST["CurrentPage"]);
    $obj->PageLoadTime = nullif($_POST["PageLoadTime"]);
    $obj->Country = nullif($_POST["Country"]);
    $obj->City = nullif($_POST["City"]);
    $obj->referrer = nullif($_POST["referrer"]);
}
//print_r($obj);
function nullif($var)
{
    if (isset($var) && !empty($var)) {
        return $var;
    } else {
        return null;
    }
}
/*
 $sql = "INSERT INTO  tbl_page_performance_details".
		"(session_id,ip_addr,entrytime,curr_page_url,country ,city ,time_spent ,page_load_time )".
		" VALUES ('"
		.$obj->SessionID."','".$obj->IPAddress."','".$obj->EntryTime."','"

コード例 #5

ファイル: Service.php プロジェクト: jeevireddy/aura

<?php

ini_set("error_reporting", E_ALL);
ini_set("display_errors", 1);
function nullif($var)
{
    if (isset($var) && !empty($var)) {
        return $var;
    } else {
        return null;
    }
}
function clean($string)
{
    $string = str_replace('\\n', '', $string);
    return preg_replace("/[^ \\w]+/", "", $string);
    //return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
}
$con = mysqli_connect("us-cdbr-iron-east-03.cleardb.net", "bee1e683ba77e3", "ad803f31", "ad_463a2c81da5e2c0");
if (mysqli_connect_errno($con)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = " INSERT INTO  tbl_chathistory (Chat,Account_id,chat_ts,Latitude,Longitude,user_id,chat_group) VALUES ('" . clean(nullif($_POST["Chat"])) . "',222115,sysdate(),40.91709,-72.709457,'" . nullif($_POST["nickname"]) . "','nfl')";
if (!mysqli_query($con, $sql)) {
    die('Error: ' . mysqli_error($con));
}
echo "1 record added";
mysqli_close($con);

コード例 #6

ファイル: TransactionTimeSpent.php プロジェクト: sivavulli/mega_hackathon

<?php

session_start();
ini_set("error_reporting", E_ALL);
ini_set("display_errors", 1);
date_default_timezone_set('America/New_York');
function nullif($var)
{
    if (isset($var) && !empty($var)) {
        return $var;
    } else {
        return null;
    }
}
$con = mysqli_connect("us-cdbr-iron-east-03.cleardb.net", "b5cc7e24bc5291", "4510e1e2", "ad_b0866641ccff844");
if (mysqli_connect_errno($con)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO  tbl_transaction_timespent_details" . "(TransactionID,Date,Status,TimeSpent)" . " VALUES ('" . nullif($_POST["TransactionID"]) . "',sysdate(),'" . nullif($_POST["Status"]) . "'," . nullif($_POST["TimeSpent"]) . ")";
if (!mysqli_query($con, $sql)) {
    die('Error: ' . mysqli_error($con));
}
mysqli_close($con);