connect();
$this->read_stocks();
}
private function connect(){
try{
// On se connecte à MySQL
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$this->pdo = new PDO('mysql:host=localhost;dbname=tykayn', 'tykayn', 'plopplop01', $pdo_options);
}
catch(Exception $e){
die('Erreur : '.$e->getMessage());
}
}
private function read_stocks(){
$reponse = $this->pdo->query("SELECT * FROM qzine_stocks");
while( $data = $reponse->fetch()){
$this->stocks[$data['article']]['qte'] =$data['qte'];
$this->stocks[$data['article']]['prix'] =$data['prix']."€";
$this->stocks[$data['article']]['reserved'] =$data['reserved'];
$this->stocks[$data['article']]['type'] =$data['type'];
$this->stocks[$data['article']]['id'] =$data['id'];
}
}
public function prix($article){
echo $this->stocks[$article]['prix'];
}
public function prix_v($article){
return $this->stocks[$article]['prix'];
}
public function articles(){
foreach ($this->stocks as $k => $v){
echo "
". $this->stocks[$k]['type'] .", $k , ". $this->stocks[$k]['prix'] ."";
}
}
public function qte($article){
echo ''.$this->stocks[$article]['qte'].'';
}
}
function makegal($dossiers_a_scanner){
//récolte des images thumb
$gal_thumb=""; //là où seront les images thumb liées aux grandes avec script lightbox
$analyse = $dossiers_a_scanner;
$table_scandir = scandir($analyse);//scan du répertoire
if ($table_scandir == FALSE){return " ...FALSE";}
$table_thumbs_scandir = scandir($analyse."/t");
$tableau_images[0]=NULL;
// thumbs liés
foreach ($table_thumbs_scandir AS $k2 => $v2){
//si c'est pas . ou ..
if ($v2 != "." AND $v2 != '..' AND $v2 != 'Thumbs.db'){
$gal_thumb .= ' '.'
';
}
}
$nouvelle_galerie = "$gal_thumb
";
echo $nouvelle_galerie;
}
?>