public function modifier_reclamation($id, $rep, $etat)
{
$select = DataBase::connect()->query("update reclamation set repense='{$rep}',etat='{$etat}' where id_rec='{$id}' ");
if ($select) {
return true;
}
}
public function supprimer_reclamtion($id)
{
$delete = DataBase::connect()->query("delete from reclamation where id_reclamation = '{$id}'");
if ($delete) {
return true;
}
}
public function supprimer_support($id)
{
$delete = DataBase::connect()->query("delete from support where id_support = '{$id}'");
if ($delete) {
return true;
}
}
public function supprimer_demande()
{
$delete = DataBase::connect()->query("delete from demande where id_demande = '{$this->id}'");
if ($delete) {
return true;
}
}
public function supprimer_certificat($id)
{
$delete = DataBase::connect()->query("delete from certificat where id_certificat = '{$id}'");
if ($delete) {
return true;
}
}
public function changer_pass($npass, $type)
{
$MODIFIER = DataBase::connect()->prepare('UPDATE responsable SET
pass=:pass where type=:type');
try {
$success = $MODIFIER->execute(array('pass' => $npass, 'type' => $type));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
public function modifier_panne($id, $date, $etat)
{
$up = DataBase::connect()->prepare('update panne SET
(date_p=:date,etat=:etat where id_panne=:id_panne)');
try {
$update = $up->execute(array('id_panne' => $id, 'date' => $date, 'etat' => $etat));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
public function liste_chaufeur_date($date)
{
$select = DataBase::connect()->query("select * from chaufeur where chaufeur.id_ch not in (select id_ch from sortie where date={$date})");
$row = array();
while ($donnees = $select->fetch(PDO::FETCH_OBJ)) {
echo "<option value='{$donnees->id_ch}'>";
echo $donnees->nom . " " . $donnees->prenom;
echo "</option>";
}
return true;
}
public function contact($email, $sujet, $texte)
{
$insert = DataBase::connect()->prepare('insert into contact
VALUES (NULL,:email,:sujet,:texte)');
try {
$success = $insert->execute(array('email' => $email, 'sujet' => $sujet, 'texte' => $texte));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
public function ajouter()
{
$insert = DataBase::connect()->prepare('insert into historique VALUES
(NULL,:date,:solde,:id_client)');
try {
$ins = $insert->execute(array('date' => $this->date, 'solde' => $this->solde, 'id_client' => $this->id_client));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
public function traiter_demande($id, $rep)
{
$up = DataBase::connect()->prepare('update demande SET
etat=:rep where id_demande=:id');
try {
$update = $up->execute(array('rep' => $rep, 'id' => $id));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
public function modifier_journaliste($nom, $prenom, $type, $login, $id)
{
$up = DataBase::connect()->prepare('update journaliste SET
nom=:nom,prenom=:prenom,type=:type,login=:login where id_jour=:id');
try {
$update = $up->execute(array('nom' => $nom, 'prenom' => $prenom, 'type' => $type, 'login' => $login, 'id' => $id));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
public function delete($noticia)
{
try {
$database = new DataBase();
$mdb = $database->connect();
$query = $mdb->prepare('DELETE FROM noticias WHERE idnoticia = ?');
$query->bindParam(1, $noticia->idNoticia);
return $query->execute();
} catch (PDOException $e) {
$e->getMessage();
}
}
public function delete($profesional)
{
try {
$database = new DataBase();
$mdb = $database->connect();
$query = $mdb->prepare('DELETE FROM profesionales WHERE matricula = ?');
$query->bindParam(1, $profesional->matricula);
return $query->execute();
} catch (PDOException $e) {
$e->getMessage();
}
}
public function total_heur($id_user)
{
$nbr_h = 0;
$select = DataBase::connect()->query("select *,sum(heur_s-heur_e) as nbr from pointage as p inner join personnel as pl on p.id_personnel=pl.id_personnel ORDER BY id_pointage DESC");
while ($donnees = $select->fetch(PDO::FETCH_OBJ)) {
$id_pointage = $donnees->id_pointage;
$date_t = $donnees->date_t;
$heur_e = $donnees->heur_e;
$heur_s = $donnees->heur_s;
$nbr = $donnees->nbr;
$mois = $donnees->mois;
}
}
public function option_client()
{
$select = DataBase::connect()->query("select * from client ORDER BY id_client DESC");
while ($donnees = $select->fetch(PDO::FETCH_OBJ)) {
$id_client = $donnees->id_client;
$nom = $donnees->nom;
$prenom = $donnees->prenom;
$ncin = $donnees->ncin;
$tel = $donnees->tel;
echo "<option value={$id_client}>";
echo $nom . " " . $prenom;
echo "</option>";
}
}
public function saveToDB($poiId, $componentId, $stageRating)
{
global $secKeys;
$now = date("Y-m-d H:i:s");
try {
DataBase::connect('localhost', $secKeys->cakeVars->{'dbUsr'}, $secKeys->cakeVars->{'dbPw'}, $secKeys->cakeVars->{'dbCake'});
$sql = "INSERT INTO stages (component_id, poi_id, created, modified, rating) VALUES (:component_id, :poi_id, :tstamp, :tstamp, :rating)";
$para = array('component_id' => $componentId, 'poi_id' => $poiId, 'tstamp' => $now, 'rating' => $stageRating);
DataBase::fire($sql, $para);
$this->savedStagesCount = DataBase::lastInsertId();
DataBase::close();
} catch (Exception $e) {
die('Fehler bei .... Fehler: ' . $e->getMessage());
}
}
public function saveToDB($filterdQueryData)
{
global $secKeys;
ControlFunctions::forDebug($filterdQueryData, "Gefilterte Pois");
// for ($i = 0; $i < 5; $i++) {
for ($i = 0; $i < count($filterdQueryData); $i++) {
$now = date("Y-m-d H:i:s");
try {
DataBase::connect('localhost', $secKeys->cakeVars->{'dbUsr'}, $secKeys->cakeVars->{'dbPw'}, $secKeys->cakeVars->{'dbCake'});
$sql = "INSERT INTO pois (created, modified, name, lat, lng, google_place, icon, rating, vicinity) VALUES (:tstamp, :tstamp, :name, :lat, :lng, :google_place, :icon, :rating, :vicinity)";
$para = array('tstamp' => $now, 'name' => $filterdQueryData[$i]->name, 'lat' => $filterdQueryData[$i]->geometry->location->lat, 'lng' => $filterdQueryData[$i]->geometry->location->lng, 'google_place' => $filterdQueryData[$i]->place_id, 'icon' => $filterdQueryData[$i]->icon, 'rating' => isset($filterdQueryData[$i]->rating) ? $filterdQueryData[$i]->rating : null, 'vicinity' => $filterdQueryData[$i]->vicinity);
DataBase::fire($sql, $para);
$lastPoisId = DataBase::lastInsertId();
echo ControlFunctions::tagIt("h1", "Letzter Eintrag: " . $lastPoisId);
foreach ($filterdQueryData[$i]->types as $tag) {
$tagId = null;
// Check if tag is already present
$sql = "SELECT EXISTS(SELECT 1 FROM tags WHERE title LIKE '%" . $tag . "%')";
$rows = DataBase::fire($sql);
$tagPresent = current(current($rows)) == "1" ? true : false;
ControlFunctions::forDebug($rows, "Ausgabe für Tag {$tag}");
echo $tagPresent ? "Wert für {$tag} ist: vorhanden" : "Wert für {$tag} ist: Nicht existent!";
if ($tagPresent) {
$sql = "SELECT id FROM tags WHERE title LIKE '%" . $tag . "%'";
$rows = DataBase::fire($sql);
$tagId = current(current($rows));
ControlFunctions::forDebug($rows, "Ausgabe für Tag {$tag}, tag ID: ");
echo ControlFunctions::tagIt("h1", "{$tag} ID: {$tagId}");
} else {
// Paste Tag
$sql = "INSERT INTO tags (title, created, modified) VALUES (:title, :tstamp, :tstamp)";
$para = array('title' => $tag, 'tstamp' => $now);
DataBase::fire($sql, $para);
// Save ID
$tagId = DataBase::lastInsertId();
}
// Paste Relation
$sql = "INSERT INTO pois_tags (poi_id, tag_id) VALUES (:poi_id, :tag_id)";
$para = array('poi_id' => $lastPoisId, 'tag_id' => $tagId);
DataBase::fire($sql, $para);
echo ControlFunctions::tagIt("h1", "Letzter Eintrag: " . DataBase::lastInsertId());
}
DataBase::close();
} catch (Exception $e) {
die('Fehler bei .... Fehler: ' . $e->getMessage());
}
}
}
public function iniciarSesion($usuarioNombre, $usuarioClave)
{
$database = new DataBase();
$mdb = $database->connect();
$usuario = null;
$mdb->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//preparo la sentencia
$sentencia = $mdb->prepare("SELECT usuario, clave, fechaActualizacion FROM usuarios\n WHERE usuario = :usuario AND clave = :clave");
//conformo un array con los parametros pasados a la sentencia preparada
$arrayParametro = array(':usuario' => $usuarioNombre, ':clave' => $usuarioClave);
//ejecuto la sentencia
$sentencia->execute($arrayParametro);
$arrayConstructor = array("usuario", "clave", "fechaActualizacion");
$sentencia->setFetchMode(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, 'Usuario', $arrayConstructor);
$usuario = $sentencia->fetchAll();
return $usuario;
}
public function calcul_salaire($id_user)
{
$select = DataBase::connect()->query("select * from personnel where id_user='******' ORDER BY id_personnel DESC");
while ($donnees = $select->fetch(PDO::FETCH_OBJ)) {
$id_personnel = $donnees->id_personnel;
$nom = $donnees->nom;
$prenom = $donnees->prenom;
$poste = $donnees->poste;
$select_poste = DataBase::connect()->query("select * from poste as p inner join salaire as s on p.id_poste=s.id_poste where p.poste='{$poste}'");
while ($donnees_poste = $select_poste->fetch(PDO::FETCH_OBJ)) {
$salaire = $donnees_poste->salaire;
}
$select_pointage = DataBase::connect()->query("select distinct*, count(date_t) as nbr from pointage where id_personnel='{$id_personnel}'");
while ($donnees_pointage = $select_pointage->fetch(PDO::FETCH_OBJ)) {
$mois = $donnees_pointage->mois;
$nbr = $donnees_pointage->nbr;
}
$total = $salaire * $nbr;
echo "<tr>";
echo "<td>";
echo $id_personnel;
echo "</td>";
echo "<td>";
echo $nom . " " . $prenom;
echo "</td>";
echo "<td>";
echo $poste;
echo "</td>";
echo "<td>";
echo $mois;
echo "</td>";
echo "<td>";
echo $total . " DT";
echo "</td>";
echo "</tr>";
}
}
public function ajouter_mail($sujet, $texte, $date, $editeur)
{
$insert = DataBase::connect()->prepare('insert into mail VALUES
(NULL,:sujet,:texte,:date,:vue,:editeur)');
try {
$ins = $insert->execute(array('sujet' => $sujet, 'texte' => $texte, 'date' => $date, 'vue' => 0, 'editeur' => $editeur));
} catch (Exception $e) {
echo 'Erreur de requète : ', $e->getMessage();
}
return true;
}
include_once "db_config.php";
include_once "database.php";
// first check if all parameters are set (else we have no need to proceed)
if (isset($_POST['db_lang_1'], $_POST['db_lang_2'], $_POST['sql_limit'], $_POST['search_term'], $_POST['sql_offset'])) {
// exit if the limit parameter is not numeric (possible sql injection)
if (!is_numeric($_POST['sql_limit']) || !is_numeric($_POST['sql_offset'])) {
$aReturnCode = array("code" => -1);
echo json_encode($aReturnCode);
return;
}
$sSqlLimit = intval($_POST['sql_limit'], 10);
$sSqlOffset = intval($_POST['sql_offset'], 10);
// get new db object
// (the parameters are stored in the db_config.php file)
$oDB = new DataBase($sHost, $sDbUser, $sDbPasswd, $sDatabase);
$oDB->connect();
// escape the search term
$sSearchTerm = mysql_real_escape_string($_POST['search_term']);
// extend the search term
$sSearchTerm = '%' . $sSearchTerm . '%';
// escape the db field names of the both languages
$sDbLang1 = mysql_real_escape_string($_POST['db_lang_1']);
$sDbLang2 = mysql_real_escape_string($_POST['db_lang_2']);
// now build the query
$sQuery = sprintf("SELECT %s, %s FROM voka WHERE %s LIKE '%s' OR %s LIKE '%s' LIMIT %d, %d", $sDbLang1, $sDbLang2, $sDbLang1, $sSearchTerm, $sDbLang2, $sSearchTerm, $sSqlOffset, $sSqlLimit);
$oResult = $oDB->query($sQuery);
$oDB->disconnect();
if (!$oResult) {
//echo "DB error: " . $oDB->getLastError();
$aReturnCode = array("code" => -1);
echo json_encode($aReturnCode);
public function select_agent($id)
{
$select = DataBase::connect()->query("select * from agent where id_agent={$id}");
$liste = $select->fetchAll(PDO::FETCH_ASSOC);
return $liste;
}
<?php
//test of git 2
require_once 'database_jobs.php';
session_start();
$con = new DataBase();
//creating opject
$con->connect();
if (isset($_POST['user_name'])) {
$user_name = $_POST['user_name'];
$password = $_POST['password'];
$query = "SELECT * FROM login WHERE user_name ='" . $user_name . "' AND password ='******'";
$result = mysql_query($query) or die("Unable to verify user because " . mysql_error());
$count = mysql_num_rows($result);
//$sql=("SELECT COUNT('id') as counter FROM login WHERE user_name ='".$user_name."' AND password ='******' ");
//$result=mysql_query($sql);
//$row=fetch_object($result);
//$row_cnt=$result->num_rows;
//echo $row_cnt;
if ($count == 1) {
$_SESSION['loggedIn'] = 1;
header("Location:index.php");
} else {
$_SESSION['loggedIn'] = 0;
echo 'false <br/>';
}
echo $_SESSION['loggedIn'];
}
public function select_sortie($id)
{
$select = DataBase::connect()->query("select * from sortie as s inner join vehicule as v inner join chaufeur as c on s.id_v=v.id_v and s.id_ch=c.id_ch");
$liste = $select->fetchAll(PDO::FETCH_ASSOC);
return $liste;
}
<?php require_once 'DataBase.class.php'; $MySQL = new DataBase($db_host, $db_name); $selectedDate = trim($_GET['date']); $TheDaysEvents = array(); // // MySQL date format is an 8 digit integer YYYYMMDD // $MySQL->connect($db_user, $db_pass)->getDay($selectedDate, $TheDaysEvents)->disconnect(); echo json_encode($TheDaysEvents);
public function liste_media()
{
$select = DataBase::connect()->query("select * from responsable_media ORDER BY id_media DESC");
while ($donnees = $select->fetch(PDO::FETCH_OBJ)) {
$id_media = $donnees->id_media;
$nom = $donnees->nom;
$prenom = $donnees->prenom;
$type = $donnees->type;
echo "<tr>";
echo "<td>";
echo $id_media;
echo "</td>";
echo "<td>";
echo $nom . " " . $prenom;
echo "</td>";
echo "<td>";
echo $type;
echo "</td>";
echo "<td>";
echo "<a href='consulter_personnel.php?id={$id_media}'>";
echo " <img src='img/chercher.png' width='30' height='30'></img> </a>";
echo "</td>";
echo "<td>";
echo "<a href='modifier_personnel.php?id={$id_media}'>";
echo " <img src='img/modif.jpg' width='30' height='30'></img> </a>";
echo "</td>";
echo "<td>";
echo "<a href='supprimer_personnel.php?id={$id_media}' onclick='if (confirm("Voulez vous vraiment supprimer le Personnel: " . $nom . " " . $prenom . " ?")) { return true; } return false;'>";
echo " <img src='img/del.png' width='30' height='30'></img> </a>";
echo "</td>";
echo "</tr>";
}
}
public function supprimer_video($id)
{
$delete = DataBase::connect()->query("delete from video where id_video = '{$id}'");
if ($delete) {
return true;
}
}
{
if ($this->db_name) {
if (@mysql_close()) {
echo 'closed';
$this->db_name = false;
return true;
} else {
return false;
}
}
}
public function escapeString($data)
{
return $this->myconn->real_escape_string($data);
}
public function getSql()
{
$val = $this->myQuery;
$this->myQuery = array();
return $val;
}
}
$con = new DataBase();
$con->connect("localhost", "root", "", "comunity_service");
//$con->disconnect()
$username = $_POST['username'];
$password = $_POST['password'];
$type = $_POST['type'];
$fields = array('ID', 'username', 'password', 'type');
$values = array('', $username, $password, $type);
$con->insert($fields, $values, 'login');
function get_ad_db()
{
global $g_ad_server_name;
global $g_ad_user_name;
global $g_ad_password;
global $g_ad_database_name;
global $g_ad_db;
if (is_resource($g_ad_db)) {
return $g_ad_db;
}
$g_ad_db = new DataBase();
$g_ad_db->connect($g_ad_server_name, $g_ad_database_name, $g_ad_user_name, $g_ad_password, $g_ad_code);
return $g_ad_db;
}
