<?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); } } } }