<?php
include_once $_SERVER['DOCUMENT_ROOT'] . "/tnfraceapp/src/Utility/Constant.php";
include_once ROOT_DIR . "/src/Database/DBHandler.php";
if (isset($_POST) && $_SERVER['REQUEST_METHOD'] == 'POST') {
$db = new DBHandler();
$db->connect();
if ($db->isConnected()) {
if ($_POST['id']) {
$d = $db->retrieveEntryById($_POST['id']);
if ($d) {
$ctr = $d['views'];
$ctr++;
$db->updatePromoContestantViews($_POST['id'], $ctr);
echo json_encode($ctr);
exit;
} else {
echo json_encode(0);
exit;
}
} else {
echo json_encode(-1);
exit;
}
} else {
exit;
}
} else {
if (isset($_SERVER['HTTP_REFERER'])) {
header('Location: ' . $_SERVER['HTTP_REFERER']);
} else {
<?php
namespace directory;
require 'DBHandler.php';
require 'vendor/autoload.php';
//if (session_status() === PHP_SESSION_ACTIVE) ? TRUE : FALSE;
session_start();
$_SESSION['id'] = $_GET['userID'];
$servername = 'localhost';
$dbname = 'directory';
$dBUsername = '******';
$dBPassword = '';
$dbConn = new DBHandler("mysql:host={$servername};dbname={$dbname}", $dBUsername, $dBPassword);
$dbConn->connect();
$command = "SELECT * from Employee where User_Name LIKE :username";
$params = array(":username" => $_GET['userID']);
$result = $dbConn->executeWithReturn($command, $params);
foreach ($result as $res) {
}
$command = "SELECT Name, Family_Name, User_Name, Photo from Employee";
$params = array();
$result2 = $dbConn->executeWithReturn($command, $params);
foreach ($result2 as $res2) {
}
$command = "SELECT * from Social_Network where UserID LIKE :userID";
$params = array(":userID" => $_GET['userID']);
$result3 = $dbConn->executeWithReturn($command, $params);
foreach ($result3 as $res3) {
}
$command = "SELECT * from Membership where Username LIKE :userID";
public function saveOutbox($lead, $data, $txnId)
{
if ($data) {
$db = new DBHandler();
$db->connect();
$pdo = $db->getConnection();
$msg_type = isset($data["msg_type"]) ? $data["msg_type"] : "";
$mobile = isset($data["mobile"]) ? $data["mobile"] : "";
$network = isset($data["network"]) ? $data["network"] : "";
$shortcode = isset($data["shortcode"]) ? $data["shortcode"] : "";
$date_received = isset($data["date_received"]) ? $data["date_received"] : "";
$channel = isset($data["channel"]) ? $data["channel"] : "";
$message_id = isset($data["message_id"]) ? $data["message_id"] : "";
$message = isset($data["message"]) ? $data["message"] : "";
$full_msg = isset($data["full_msg"]) ? $data["full_msg"] : "";
$msg_status = isset($data["msg_status"]) ? $data["msg_status"] : "";
$status = isset($data["status"]) ? $data["status"] : "";
$id = $lead ? $lead['id'] : 0;
$query = "INSERT INTO `sms_outbox` ( message_type, mobile_number, network, shortcode, date_received, channel, message_id, message, full_msg, msg_status, status)\n VALUES ( :message_type, :mobile_number, :network, :shortcode, :date_received, :channel, :message_id, :message, :full_msg, :msg_status, :status);";
$sql = $pdo->prepare($query);
$result = $sql->execute(array(":message_type" => $msg_type, ":mobile_number" => $mobile, ":network" => $network, ":shortcode" => $shortcode, ":date_received" => $date_received, ":channel" => $channel, ":message_id" => $message_id, ":message" => $message, ":full_msg" => $full_msg, ":msg_status" => $msg_status, ":status" => $status));
$sql1 = "UPDATE `tnf_leads`\n SET contact=?\n WHERE transaction_id=?";
$query1 = $pdo->prepare($sql1);
$query1->execute(array($mobile, $txnId));
return $result;
}
}
<?php
include_once "../php/DBHandler.php";
include_once "../php/Scheduler.php";
include_once "../php/ProcessHandler.php";
/*Haendler inizialesierung*/
$bts_handler = new DBHandler();
$bts_handler->connect();
$bts_handler->delete_old();
$bts_scheduler = new Scheduler();
$bts_ProcessHandler = new ProcessHandler();
$bts_ProcessHandler->setDummyProcessArray($bts_handler->get_processes());
/*Fuer Fehlerabfrage benoetigte Member*/
$fehlerDummy = '';
$fehlerRandom = '';
$fehlerRR = '';
$fehlerScheduler = '';
$fehler = false;
$openTab = 1;
/*Standart ueberpruefung erleichtern*/
function ueberpruefung($value)
{
return isset($_POST[$value]) && !is_array($_POST[$value]) && $_POST[$value] != '';
}
if (isset($_POST['senden'])) {
if ($_POST['senden'] == 'Speichern') {
if (!(ueberpruefung('name') && strlen($_POST['name']) > 0 && strlen($_POST['name']) < 11)) {
$fehlerDummy .= '<a>Bitte geben Sie einen Namen ein.</a><br />';
$fehler = true;
}
if (!(ueberpruefung('cpulaufzeit') && $_POST['cpulaufzeit'] + 0 > 0 && $_POST['cpulaufzeit'] + 0 < 501)) {
function getAllAppointments($id)
{
$db = new DBHandler();
$db->connect();
$data = $db->getAllAppointmentsApproved($id);
$return = array();
if (!empty($data)) {
$i = 0;
foreach ($data as $d) {
$preferred_date = substr($d['preferred_date'], 6, 4) . '-' . substr($d['preferred_date'], 0, 2) . '-' . substr($d['preferred_date'], 3, 2);
$preferred_time = $d['preferred_time'];
$return[$i]['preferred_date'] = $preferred_date;
$return[$i]['preferred_time'] = $preferred_time;
}
}
return $return;
}
public function processPromoContestant($post, $request, $server, $files)
{
if (isset($post) && isset($files) && isset($request) && $server['REQUEST_METHOD'] == 'POST') {
//LOCAL
$uploadDirectory = ROOT_DIR . 'web/tnf100app/uploads/';
if (!file_exists($uploadDirectory)) {
mkdir($uploadDirectory, 0777);
}
$filename = $files['upload']['name'];
$ext = explode(".", $filename);
$type = $files['upload']['type'];
$tmpName = $files['upload']['tmp_name'];
$size = $files['upload']['size'];
$now = new DateTime();
$newfilename = $now->format('YmdGis') . "_" . $post['first_name'] . "_" . $post['last_name'] . "_" . $filename;
$target = $uploadDirectory . $newfilename;
if (!file_exists($target)) {
if (move_uploaded_file($tmpName, $target)) {
$db = new DBHandler();
$db->connect();
$data = array('fname' => $post['first_name'], 'lname' => $post['last_name'], 'contact' => $post['contact'], 'email' => $post['email'], 'address' => $post['address'], 'raceBib' => $post['raceBib'], 'caption' => $post['caption'], 'video' => $newfilename);
$db->addPromoContestant($data);
}
}
}
}
