function gettwofieldscategories($params) { $query = "SELECT * FROM twofieldtypes"; $result = parent::execute($query, 'json'); if ($result) { echo $result; } else { echo false; } }
function updateSubCategory($params) { $obj = $params['data']; if ($obj['id']) { $query = "UPDATE two_field_subcategory SET category_id='" . $obj['category_id'] . "',description='" . $obj['description'] . "',bundle='" . $obj['bundle'] . "',status='" . $obj['status'] . "' WHERE id='" . $obj['id'] . "'"; } else { //$query = "INSERT into two_field_subcategory (category_id, description, bundle, status) VALUES //('".$obj['category_id']."','".$obj['description']."','".$obj['bundle']."','".$obj['status']."')"; } $result = parent::execute1($query); if ($result) { echo $result; } else { echo false; } }
function loginuser($params) { if (!$params) { echo "required username and password"; return; } //$query = "SELECT * FROM users"; $query = "SELECT * FROM user WHERE user_name = '" . $params['user'] . "' AND password ='******'pass'] . "'"; $this->result = parent::execute($query, 'json'); if ($this->result) { session_start(); $_SESSION['sid'] = session_id(); $response = array('code' => 1, 'success' => true, 'data' => $this->result); echo json_encode($response); } else { echo "Please check Username and password"; } }
function checkuser($params) { session_start(); if ($_SESSION['sid'] == session_id()) { if (!$params) { session_destroy(); return false; } return true; $query = "SELECT * FROM user WHERE user_name = '" . $params['user'] . "' AND password ='******'pass'] . "'"; $this->result = parent::execute($query, 'json'); if ($this->result) { return true; } else { session_destroy(); return false; } } else { session_destroy(); echo "error:1000,message:authentication failed,success:false"; return false; } }
Bring a job entry into editable forms. Coded Jan. 18th, 2002. (c) 2002 Adam Drake adam@brainrub.com */ // require_once __DIR__."/lib/KLogger.php"; // Include KLogger first so config sets log dir // Database connection object (Which auto-loads all the site configuration.) require_once __DIR__ . "/data/DBConnector.php"; $css = "bio.css"; $p_jobid = ""; if (isset($_REQUEST["p_jobid"]) && $_REQUEST["p_jobid"] != "") { $p_jobid = $_REQUEST["p_jobid"]; } $job_query = "SELECT ALL a.job_id,a.from_date,a.to_date,a.jobtitle,a.company,\n a.comp_type,a.street,a.city,a.stprv,a.country,\n a.postcode,a.notes,a.co_workers,\n DATE_FORMAT(a.from_date, '%b. %Y') AS fmtfromdt,\n DATE_FORMAT(a.to_date, '%b. %Y') AS fmttodt\n FROM my_jobs a\n WHERE (a.job_id = {$p_jobid})\n LIMIT 1;"; // connect to the database $db = dbconnector::connect(); // print($job_query); // Prepare $stmt = $db->prepare($job_query); // Execute $retVal = $stmt->execute(); // Row count... $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); $rs1 = $db->query('SELECT FOUND_ROWS()'); $row_count = (int) $rs1->fetchColumn(); // If row count > 0, do stuff... $stmt = null; $ctr = 0; $pagetitle = "My Job: Edit"; // default html header with comments include "elements/header.php";
<?php require_once 'database.php'; if (isset($_SESSION['login_user'])) { $login = $_SESSION['login_user']; } else { include 'login.php'; } $db = new dbconnector(); ?> <!DOCTYPE html> <head> <meta charset="utf-8"> <title>The Auction House</title> <link media="all" rel="stylesheet" type="text/css" href="css/all.css" /> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script type="text/javascript">window.jQuery || document.write('<script type="text/javascript" src="js/jquery-1.7.2.min.js"><\/script>');</script> <script type="text/javascript" src="js/jquery.main.js"></script> <!--[if lt IE 9]><link rel="stylesheet" type="text/css" href="css/ie.css" /><![endif]--> </head> <body> <div id="wrapper"> <div id="content"> <div class="c1"> <div class="controls"> <?php if ($error != "") { echo "<ul class='states'><li class='error'>{$error}</li></ul>"; } ?>
<?php session_start(); require 'database.php'; $error = ""; if (isset($_POST['login']) && isset($_POST['password'])) { if (empty($_POST['login']) || empty($_POST['password'])) { $error = "Username or Password is invalid"; } else { $login = $_POST['login']; $password = $_POST['password']; //COMPROBACION POR BASE DE DATOS $db = new dbconnector(); $id = $db->login($login, $password); if ($id != 0) { $_SESSION['id'] = $id; header("location: index.php"); } else { $error = "Username or Password is Wrong"; } /* //PLACEHOLDER if (($login == "hastur")&&($password == "logitech")){ $_SESSION['login'] = $login; header ("location: index.php"); }else{ $error = "Username or Password is Wrong"; }*/ } } ?>
<?php //require 'database.php'; session_start(); require 'database.php'; if (isset($_SESSION['id'])) { $id = $_SESSION['id']; $db = new dbconnector(); } else { header("location:login.php"); } if (isset($_GET['id'])) { $_SESSION['otherid'] = $_GET['id']; } //$db = new dbconnector(); //CHECK MESSAGES AS READ $db->checkmessages($_SESSION['id'], $_SESSION['otherid']); //CONTROL NEW MESSAGE POSTED if (isset($_POST['addcomment'])) { $addcomment = $_POST['addcomment']; $addcomment = preg_replace("/\n/", "<br/>", $addcomment); $db->postchat($_SESSION['id'], $_SESSION['otherid'], $addcomment); } ?> <!DOCTYPE html> <head> <meta charset="utf-8"> <title>The Project</title> <link media="all" rel="stylesheet" type="text/css" href="css/styles.css" /> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css">
<?php session_start(); $error = ""; if (isset($_POST['username']) && isset($_POST['password'])) { if (empty($_POST['username']) || empty($_POST['password'])) { $error = "Username or Password is invalid"; } else { //Define $username and $password $username = $_POST['username']; $password = $_POST['password']; $db = new dbconnector(); $result = $db->login($username, $password); if ($result == 1) { $_SESSION['login_user'] = $username; //INITIALIZING SESSION header("location: index.php"); } else { $error = "Username or Password is invalid"; } } }
<?php if (session_status() == PHP_SESSION_NONE) { session_start(); } require_once 'database.php'; if (isset($_SESSION['id'])) { $id = $_SESSION['id']; if (!isset($db)) { $db = new dbconnector(); } } else { header("location:login.php"); } if (isset($_SESSION['otherid'])) { $otherid = $_SESSION['otherid']; } $chats = $db->getchats($id, $otherid, 0); $size = sizeof($chats); $i = 0; echo "<div id='messages'>"; while ($i < $size) { if ($chats[$i]['idsender'] == $id) { $name = $db->getnickname($chats[$i]['idsender']); echo "<div class='chatbox'>"; echo "<div class='rightside avatar'>"; echo "<img src='images/avatar.png'>"; echo "</div>"; echo "<div class='rightside bubble'>"; echo "<span class='medieval' style='text-align:right; float:right;'><strong>{$name}</strong></span>"; echo "<br>";
<?php //require 'database.php'; session_start(); require 'database.php'; if (isset($_SESSION['id'])) { $id = $_SESSION['id']; $db = new dbconnector(); } else { header("location:login.php"); } //$db = new dbconnector(); ?> <!DOCTYPE html> <head> <meta charset="utf-8"> <title>The Project</title> <link media="all" rel="stylesheet" type="text/css" href="css/styles.css" /> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css"> <link href='https://fonts.googleapis.com/css?family=MedievalSharp' rel='stylesheet' type='text/css'> <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script> </head> <body onload='showmessages()'> <div id="wrapper">
<?php require_once 'database.php'; if (isset($_SESSION['id'])) { $id = $_SESSION['id']; if (!isset($db)) { $db = new dbconnector(); } } else { header("location:login.php"); } $chats = $db->getchats($id, $id, 1); //SEPARATE DIFERENT USERS CHATS $diferentusers = array(); $diferentusersmessage = array(); $size = sizeof($chats); $i = 0; while ($i < $size) { if ($chats[$i]['idsender'] == $id) { $user = $chats[$i]['idreceiver']; } else { $user = $chats[$i]['idsender']; } if (!in_array($user, $diferentusers)) { $diferentusers[] = $user; $diferentusersmessage[$user] = $chats[$i]['id']; } $i = $i + 1; } //PAINT DIFFERENT CHATS $size = sizeof($diferentusers);