$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."','"
<?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);
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(); }
$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."','"
<?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);
<?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);