PHP comerceDAO Exemples

Exemple #1

Fichier : affiche_pc.php Projet : hichour2/ecommerce

    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
if ($_GET['pc'] == "sony") {
    $res = comerceDAO::affiche_cate_marque("pc", "sony");
    echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
if ($_GET['pc'] == "toshiba") {
    $res = comerceDAO::affiche_cate_marque("pc", "toshiba");
    echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
if ($_GET['pc'] == "acer") {
    $res = comerceDAO::affiche_cate_marque("pc", "acer");
    echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
?>
<script type="text/javascript" src="js/pirobox_extended_feb_2011.js"></script>

Exemple #2

Fichier : aficher_etat_comm.php Projet : hichour2/ecommerce

<?php

include "menu.php";
require_once 'comerceDAO.php';
$num = $_POST['num'];
$res = comerceDAO::chercher_commande($num);
echo '</br></br></br></br></br><table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Nom produit</th><th bgcolor="orange">date de commande</th><th bgcolor="orange">Etat</th>';
while ($enr = $res->fetch()) {
    echo "<tr><td>" . $enr[2] . "</td><td>" . $enr[3] . "</td><td bgcolor='yellow'>" . $enr[4] . "</td>";
}
echo '</table>';
echo '</table>';

Exemple #3

Fichier : autre.php Projet : hichour2/ecommerce

<?php

include "menu.php";
require_once 'comerceDAO.php';
$res = comerceDAO::affiche_cate_autre("imprimante");
echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
while ($enr = $res->fetch()) {
    echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><img alt='img' src=" . $enr[8] . " width='100' height='100'/></td><td bgcolor='magenta'></a><input type='button' value='Ajouter au Panier' bgcolor='green'></a></td></tr>";
}
echo '</table>';

Exemple #4

Fichier : affiche_tv.php Projet : hichour2/ecommerce

</head>
<body>
<?php 
include "menu.php";
require_once 'comerceDAO.php';
if ($_GET['tv'] == "samsung") {
    $res = comerceDAO::affiche_cate_marque("tv", "samsung");
    echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
if ($_GET['tv'] == "sony") {
    $res = comerceDAO::affiche_cate_marque("tv", "sony");
    echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
if ($_GET['tv'] == "lg") {
    $res = comerceDAO::affiche_cate_marque("tv", "lg");
    echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
    while ($enr = $res->fetch()) {
        echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
    }
    echo '</table>';
}
?>
<script type="text/javascript" src="js/pirobox_extended_feb_2011.js"></script>

Exemple #5

Fichier : imprimante_canon.php Projet : hichour2/ecommerce

<head>
<link rel="stylesheet" type="text/css" media="all" href="css/style.css" />
<link href="css_pirobox/style_5/style.css" rel="stylesheet" type="text/css" />

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
<title>Bienvenu au !|E-commerce</title>
</head>
<body>
<?php 
include "menu.php";
require_once 'comerceDAO.php';
$res = comerceDAO::affiche_cate_marque("imprimante", "canon");
echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
while ($enr = $res->fetch()) {
    echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\n<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\n\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
}
echo '</table>';
?>
<script type="text/javascript" src="js/pirobox_extended_feb_2011.js"></script>
<script type="text/javascript">
$(document).ready(function() {
	$.piroBox_ext({
	piro_speed :700,
	bg_alpha : 0.5,
	piro_scroll : true,
	piro_drag :false,
	piro_nav_pos: 'bottom'
});
});
</script>
</body>

Exemple #6

Fichier : chercher_produit.php Projet : hichour2/ecommerce

<head>
<link rel="stylesheet" type="text/css" media="all" href="css/style.css" />
<link href="css_pirobox/style_5/style.css" rel="stylesheet" type="text/css" />
<title>Bienvenu au !|E-commerce</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
</head>
<body>
<?php 
include "menu.php";
require_once 'comerceDAO.php';
$nom = $_POST['chercher'];
$res = comerceDAO::chercher_produit($nom);
echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
while ($enr = $res->fetch()) {
    echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page='panier''>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
}
echo '</table>';
echo '</table>';
?>
<script type="text/javascript" src="js/pirobox_extended_feb_2011.js"></script>
<script type="text/javascript">
$(document).ready(function() {
	$.piroBox_ext({
	piro_speed :700,
	bg_alpha : 0.5,
	piro_scroll : true,
	piro_drag :false,
	piro_nav_pos: 'bottom'
});
});
</script>

Exemple #7

Fichier : affiche_produit_promotion.php Projet : hichour2/ecommerce

<head>
<link rel="stylesheet" type="text/css" media="all" href="css/style.css" />
<link href="css_pirobox/style_5/style.css" rel="stylesheet" type="text/css" />
<title>Bienvenu au !|E-commerce</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
</head>
<body>
<?php 
include "menu.php";
require_once 'comerceDAO.php';
$res = comerceDAO::produit_promotion();
echo '<table width="700"  border="1"bordercolor="black" align="center"><tr><th bgcolor="orange">Categorie</th><th bgcolor="orange">Nom</th><th bgcolor="orange">Marque</th><th bgcolor="orange">Caracteriqtique</th><th bgcolor="orange">Nombre d\'exemplaires</th><th bgcolor="orange">Prix</th><th bgcolor="orange">Promotion</th><th bgcolor="orange">image</th><th bgcolor="magenta">Ajouter Au Panier</th></tr>';
while ($enr = $res->fetch()) {
    echo "<tr><td>" . $enr[1] . "</td><td>" . $enr[2] . "</td><td bgcolor='yellow'>" . $enr[3] . "</td><td>" . $enr[4] . "</td><td>" . $enr[5] . "</td><td>" . $enr[6] . "</td><td>" . $enr[7] . "</td><td><a href=" . $enr[8] . " rel='gallery' class='pirobox_gall'><img alt='img' src=" . $enr[8] . " width='100' height='150'/></a></td><td bgcolor='magenta'>\r<a href='panier.php?action=ajout&&l=" . $enr[2] . "&&p=" . $enr[6] . "&&q=1&&page=promo'>\r\t\t\t<img src='images/ajou_panier.jpg'></a></td>";
}
echo '</table>';
echo '</table>';
?>
<script type="text/javascript" src="js/pirobox_extended_feb_2011.js"></script>
<script type="text/javascript">
$(document).ready(function() {
	$.piroBox_ext({
	piro_speed :700,
	bg_alpha : 0.5,
	piro_scroll : true,
	piro_drag :false,
	piro_nav_pos: 'bottom'
});
});
</script>
</body>

Exemple #8

Fichier : passer_commande.php Projet : hichour2/ecommerce

<?php

include "menu.php";
require_once 'comerceDAO.php';
require_once 'connect2.php';
if (!isset($_SESSION['clientLogin'])) {
    die("Connecter vous ... pour Confirmer le Commande... !!!!!!!!!!");
}
$action = $_GET['action'];
$qte = $_GET['qte'];
$date = date("Y-m-d");
$res = comerceDAO::chercher_produit($action);
while ($enr = $res->fetch()) {
    $q = "insert into commande VALUES('','" . $enr[0] . "','" . $enr[2] . "','{$date}','Encour')";
    if ($bdd->query($q)) {
        print 'votre Numero de commande est :' . $bdd->lastInsertId() . '<br>';
        $req_up = "update produit set nbr = nbr-{$qte} where nom like '" . $enr[2] . "'";
        $req_upp = "update client set nbr_point =nbr_point+100 where login like '" . $_SESSION['clientLogin'] . "'";
        $bdd->query($req_up);
        $bdd->query($req_upp);
        echo "Commande passé avec Succés..<td>\n\t         <a href='panier.php?action=suppression&l=" . rawurlencode($action) . "&&page='panier'\"'> Retour</a>";
    } else {
        echo 'erreur d\'insertion';
    }
}