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