Ejemplo n.º 1
0
function isConnected()
{
    if (isset($_COOKIE['email']) && isset($_COOKIE['pwd'])) {
        $bdd = Connect_db();
        $query = $bdd->prepare('SELECT email, password FROM Membre');
        $query->execute();
        while ($line = $query->fetch()) {
            if ($line['email'] == $_COOKIE['email'] && $line['password'] == $_COOKIE['pwd']) {
                return true;
            }
        }
    }
    return false;
}
Ejemplo n.º 2
0
<?php

include "begin.php";
require 'html_table.php';
$bdd = Connect_db();
$SQL_Query = 'insert into Facture values(null)';
$query = $bdd->prepare($SQL_Query);
$query->execute();
$SQL_Query = 'select max(idFacture) as m from Facture';
$query = $bdd->prepare($SQL_Query);
$query->execute();
$idFacture = 0;
while ($line = $query->fetch()) {
    $idFacture = $line["m"];
}
$pdf = new PDF();
$pdf->AddPage();
$pdf->SetFont('Arial', '', 12);
$html = '<table border="1">
<tr>
<td width="200" height="30">cell 1</td><td width="200" height="30" bgcolor="#D0D0FF">cell 2</td>
</tr>
<tr>
<td width="200" height="30">cell 3</td><td width="200" height="30">cell 4</td>
</tr>
</table>';
$pdf->WriteHTML($html);
$pdf->Output("F", "./factures/Facture n" . $idFacture . ".pdf");
?>
<a href=<?php 
echo '"pdf.php?pdf=' . $idFacture . '"';
Ejemplo n.º 3
0
function connectAdmin($id, $pwd)
{
    $bdd = Connect_db();
    $SQL_Query = "select * from Admin where id = ? and pwd = ?";
    $query = $bdd->prepare($SQL_Query);
    $query->bindParam(1, $id);
    $query->bindParam(2, $pwd);
    $i = 0;
    $query->execute();
    if ($query->fetch()) {
        session_start();
        $_SESSION['id'] = $id;
        $_SESSION['pwd'] = $pwd;
        return true;
    } else {
        return false;
    }
}
Ejemplo n.º 4
0
function getPrixPlaces($idMatch)
{
    $array[0] = 0;
    $bdd = Connect_db();
    $SQL_Query = 'SELECT prix as p, emplacement as e
                        From Place
                        WHERE idMatch = ' . $idMatch . '
                        GROUP BY e, p';
    $query = $bdd->prepare($SQL_Query);
    $query->execute();
    $i = 0;
    while ($nb = $query->fetch()) {
        $array[$i] = $nb["p"];
        $i++;
    }
    return $array;
}