public function testAutoReconnect()
{
global $config;
$dbh = new MyPDO($config['dsn'], $config['user'], $config['password']);
$dbh->exec('SET session wait_timeout = 1');
sleep(2);
$result = $dbh->query('SELECT 1');
}
public static function find_by_sql($sql = "")
{
$db = new MyPDO();
$result_set = $db->query($sql);
$db = null;
$object_array = array();
while ($row = $result_set->fetch()) {
$object_array[] = self::instantiate($row);
}
return $object_array;
}
<?php
ini_set('session.save_path', realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/temp'));
//
session_start();
if (!isset($_SESSION['admin'])) {
header("location:login.html");
}
include_once "config/MyPDO.class.php";
$connect = new MyPDO();
$connect->query("SET NAMES 'utf8'");
$id_lcommande = $_GET['id'];
$req2 = "select * from ligne_commande where id={$id_lcommande}";
$oPDOStatements2 = $connect->query($req2);
// Le résultat est un objet de la classe PDOStatement
$oPDOStatements2->setFetchMode(PDO::FETCH_ASSOC);
//retourne true on success, false otherwise.
while ($data = $oPDOStatements2->fetch()) {
$id = $data['id'];
$id_commande = $data['id_commande'];
$id_produit = $data['id_produit'];
$id_lit = $data['id_lit'];
$etat_louer = $data['etat_louer'];
}
$req3 = "UPDATE `ligne_commande` SET `etat_louer`=0 WHERE `id`={$id_lcommande} ";
$oPDOStatement3 = $connect->query($req3);
if ($id_lit == 0) {
$req4 = "UPDATE `produit` SET `qte_louer`=`qte_louer`-1 WHERE `id`={$id_produit} ";
$oPDOStatement4 = $connect->query($req4);
}
if ($id_lit != 0) {
<?php
include_once "config/MyPDO.class.php";
$connect = new MyPDO();
$connect->query("SET NAMES 'utf8'");
if (isset($_POST["contrat"])) {
$nom_client = "";
$adresse_client = "";
$tel_client = "";
$gsm_client = "";
$cin_client = "";
$date_cin = "";
$nom_ben = "";
$adresse_ben = "";
$tel_ben = "";
$cin_ben = "";
extract($_POST);
if ($etage == 2) {
$frais = $frais * 1.5;
} elseif ($etage == 3) {
$frais = $frais * 2;
} elseif ($etage == 4) {
$frais = $frais * 2.5;
} elseif ($etage == 5) {
$frais = $frais * 3;
} elseif ($etage >= 6) {
$frais = $frais * 3.5;
}
$transport = $transport * 0.6 + $frais;
}
<?php
/**
* Created by PhpStorm.
* User: Racem
* Date: 16/01/2016
* Time: 16:24
*/
$id_prod = $_GET["id"];
ini_set('session.save_path', realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/temp'));
session_start();
extract($_POST);
include_once "config/MyPDO.class.php";
$connect = new MyPDO();
$connect->query("SET NAMES 'utf8'");
$req1 = "SELECT * FROM `produit` WHERE `id`={$id_prod} ";
$oPDOStatement = $connect->query($req1);
// Le résultat est un objet de la classe PDOStatement
$oPDOStatement->setFetchMode(PDO::FETCH_OBJ);
while ($row = $oPDOStatement->fetch()) {
$id = $row->id;
$nom = $row->nom;
$ref = $row->ref;
$prix_semaine = $row->prix_semaine;
$prix_mois = $row->prix_mois;
$qte = $row->qte;
$qte_louer = $row->qte_louer;
$caution = $row->caution;
$tva_produit = $row->tva_produit;
$type = $row->type;
}
$today = date("d-m-Y");
$nom_client = "";
$adresse_client = "";
$tel_client = "";
$cin_client = "";
$date_cin = "";
$nom_ben = "";
$adresse_ben = "";
$tel_ben = "";
$cin_ben = "";
extract($_POST);
//**************************//
$id = $_GET['id'];
$gsm_client = "";
$req1 = "SELECT * FROM `commande` WHERE `id`={$id}; ";
$oPDOStatement = $connect->query($req1);
// Le résultat est un objet de la classe PDOStatement
$oPDOStatement->setFetchMode(PDO::FETCH_OBJ);
while ($row = $oPDOStatement->fetch()) {
$id = $row->id;
$ref = $row->ref;
$nom_client = $row->nom_client;
$date_commande = $row->date_commande;
$adresse_client = $row->adresse_client;
$tel_client = $row->tel_client;
$gsm_client = $row->gsm_client;
$cin_client = $row->cin_client;
$date_cin = $row->date_cin;
$nom_ben = $row->nom_ben;
$adresse_ben = $row->adresse_ben;
$tel_ben = $row->tel_ben;
$nb_result_total += $nb_result;
$total_global += $nb_result;
for ($i = 0; $i < $nb_result; $i++) {
$titre = trim($homepage->results[$i]->human_name);
$simple_titre = simple_format($titre);
$link = 'https://www.humblebundle.com/store/p/' . trim($homepage->results[$i]->machine_name);
$photo = 'https://www.humblebundle.com' . trim($homepage->results[$i]->storefront_featured_image_small);
$prix_avant = str_replace(',', '.', $homepage->results[$i]->full_price[0]);
$taux_full_price = @$taux[$homepage->results[$i]->full_price[1]];
if (!$taux_full_price) {
$taux_full_price = 1;
}
$prix_avant = number_format($prix_avant / $taux_full_price, 2, '.', '');
//conversion GBP/EUR
$prix_apres = str_replace(',', '.', $homepage->results[$i]->current_price[0]);
$taux_current_price = @$taux[$homepage->results[$i]->current_price[1]];
if (!$taux_current_price) {
$taux_current_price = 1;
}
$prix_apres = number_format($prix_apres / $taux_current_price, 2, '.', '');
//conversion GBP/EUR
$percent = round(($prix_avant - $prix_apres) / $prix_avant * 100);
if ($percent > 0) {
$data = array($titre, $simple_titre, $link, $photo, $prix_avant, $prix_apres, $percent);
$ret = $bdd->query($sql, $data);
}
}
$p++;
} while ($nb_result > 0);
echo $nb_result_total . ' promos ' . "\n";
echo "\nFin du script: " . date("H:i:s", microtime(true));
<?php
include_once "config/MyPDO.class.php";
$connect = new MyPDO();
//$connect->query("SET NAMES 'utf8'");
$req1 = "SELECT MAX(`ref_lit`)AS max_lit,MAX(`ref_moteur_p`)AS max_moteur_p, MAX(`ref_moteur_s`)AS max_moteur_s, MAX(`ref_telecommande`) AS max_telecommande FROM `lit`";
$oPDOStatement = $connect->query($req1);
// Le résultat est un objet de la classe PDOStatement
$oPDOStatement->setFetchMode(PDO::FETCH_OBJ);
while ($row = $oPDOStatement->fetch()) {
$max_lit = $row->max_lit + 1;
$max_moteur_p = $row->max_moteur_p + 1;
$max_moteur_s = $row->max_moteur_s + 1;
$max_telecommande = $row->max_telecommande + 1;
}
if ($max_lit < 10) {
$max_lit = "00" . $max_lit;
} elseif ($max_lit < 100 && $max_lit >= 10) {
$max_lit = "0" . $max_lit;
}
if ($max_moteur_p < 10) {
$max_moteur_p = "00" . $max_moteur_p;
} elseif ($max_moteur_p < 100 && $max_moteur_p >= 10) {
$max_moteur_p = "0" . $max_moteur_p;
}
if ($max_moteur_s < 10) {
$max_moteur_s = "00" . $max_moteur_s;
} elseif ($max_moteur_s < 100 && $max_moteur_s >= 10) {
$max_moteur_s = "0" . $max_moteur_s;
}
$myPost = $post;
$nb_display = 50;
/*$p=1;
if(isset($_GET["pagin"]) && is_numeric($_GET["pagin"])){
$p=$_GET["pagin"];
}*/
$p = (get_query_var('page')) ? get_query_var('page') : 1;
require 'wp-content/plugins/MyPlugin/class/MyPDO.php';
$bdd = new MyPDO();
$sql = 'SELECT SQL_CALC_FOUND_ROWS * from game where creato=? order by percent desc, prix_apres asc, titre LIMIT '.(($p-1)*$nb_display).','.$nb_display;
$param = date('Y-m-d');
$ret = $bdd->query($sql, array($param));
$ret_max = $bdd->query('SELECT FOUND_ROWS() as max_result');
$max = (int) $ret_max[0]->max_result;
if(count($ret)<$max){
$pagination = true;
$max_page = ceil($max/$nb_display);
}
?>
<div class="col1">
<?php if (have_posts()) : ?>
<div id="archivebox">
<meta charset="utf-8" />
<?php
echo "\n" . '--check_mail' . "\n\n";
echo "\nDebut du script: " . date("H:i:s", microtime(true)) . "\n";
require_once 'inc/functions.php';
require_once 'class/MyPDO.php';
$bdd = new MyPDO();
$ret = $bdd->query("select post_id, GROUP_CONCAT( concat(meta_key,':',meta_value) SEPARATOR ' ▬ ' ) as data from wpromo_postmeta where post_id in (SELECT post_id FROM `wpromo_postmeta` WHERE `meta_key`='_field_24' and `meta_value`='oui') AND meta_key in ('_field_18', '_field_20', '_field_19', '_field_21', '_field_17') GROUP BY post_id");
$nb_result = count($ret);
foreach ($ret as $toMail) {
echo 'q:' . $toMail->data . "\n";
preg_match('/_field_17:([^▬]+)/', $toMail->data, $matches);
$nom = trim($matches[1]);
preg_match('/_field_18:([^▬]+)/', $toMail->data, $matches);
$email = trim($matches[1]);
preg_match('/_field_20:([^▬]+)/', $toMail->data, $matches);
$tag = trim($matches[1]);
preg_match('/_field_19:([^▬]+)/', $toMail->data, $matches);
$euro = trim($matches[1]);
preg_match('/_field_21:([^▬]+)/', $toMail->data, $matches);
$percent = trim($matches[1]);
$id = $toMail->post_id;
echo $id . ' ' . $email . ' ' . $tag . ' ' . $euro . '€ ' . $percent . '%' . "\n";
if (!$id) {
continue;
}
$mot_cles = explode(' ', $tag);
$nb_result_total = 0;
foreach ($mot_cles as $mot_cle) {
$mot_cle = simple_format($mot_cle);
echo ' - recherche de ' . $mot_cle . "\n";
$nb_display = 50;
if(isset($_GET["pagin"]) && is_numeric($_GET["pagin"])){
$p=$_GET["pagin"];
}
$q = simple_format($_GET["q"]);
if(!$q){
$q='jeuxenpromotion';
}
$bdd = new MyPDO();
$sql ='SELECT SQL_CALC_FOUND_ROWS * from game where simple_titre like(\'%'.$q.'%\') order by creato desc, percent desc, prix_apres asc LIMIT '.(($p-1)*$nb_display).','.$nb_display;
$data = null;
$ret = $bdd->query($sql, $data );
$ret_max = $bdd->query('SELECT FOUND_ROWS() as max_result');
$max = (int) $ret_max[0]->max_result;
if(count($ret)<$max){
$pagination = true;
$max_page = ceil($max/$nb_display);
}
$s='';
if($max>1){
$s='s';
}
?>
<div class="col1">
} else {
$dbprefix = $_POST['prefix'] . '_';
}
$_POST['prefix'] = $dbprefix;
}
}
}
}
}
try {
$db = new MyPDO('mysql:host=' . $dbhost . ';dbname=' . $dbname, $dbuser, $dbpass, array(), $dbprefix);
} catch (PDOException $e) {
//echo $e->getMessage();
die(show_message($e->getMessage()));
}
$db->query('SET character_set_connection = ' . $sqlchar);
$db->query('SET character_set_client = ' . $sqlchar);
$db->query('SET character_set_results = ' . $sqlchar);
$db->query('SET SESSION wait_timeout = 60;');
if (isset($_GET['multi']) and preg_match("/[a-zA-Z0-9]{1,5}/i", $_GET['multi']) and strlen($_GET['multi']) <= 5) {
$tmp_prefix = $_GET['multi'] . '_';
$sql = "SELECT COUNT(id) FROM multiclan WHERE prefix = '" . $tmp_prefix . "';";
$q = $db->prepare($sql);
if ($q->execute() == TRUE) {
$multi = $q->fetchColumn();
} else {
die(show_message($q->errorInfo(), __LINE__, __FILE__, $sql));
}
if ($multi == 1) {
$db->change_prefix($tmp_prefix);
} else {
$stack = debug_backtrace();
if (!isset($stack[1])) {
return;
}
printf("%s(", $stack[1]['function']);
$args = '';
foreach ($stack[1]['args'] as $k => $v) {
$args .= sprintf("%s, ", var_export($v, true));
}
if ($args != '') {
printf("%s", substr($args, 0, -2));
}
printf(")\n");
}
}
$db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
$db->exec('DROP TABLE IF EXISTS test');
$db->exec('CREATE TABLE test(id INT)');
$db->exec('INSERT INTO test(id) VALUES (1), (2)');
$stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
var_dump($stmt->fetch());
$db->intercept_call();
} catch (PDOException $e) {
printf("[001] %s [%s] %s\n", $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
}
$db->exec('DROP TABLE IF EXISTS test');
print "done!\n";
require dirname(__FILE__) . '/mysql_pdo_test.inc';
$db = MySQLPDOTest::factory();
$db->exec('DROP TABLE IF EXISTS test');
<?php
ini_set('session.save_path', realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/temp'));
session_start();
include_once "config/MyPDO.class.php";
$connect = new MyPDO();
$connect->query("SET NAMES 'utf8'");
?>
<html xmlns="http://www.w3.org/1999/html">
<head>
<meta charset="utf-8">
<title>Free HTML5 Bootstrap Admin Template</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="Charisma, a fully featured, responsive, HTML5, Bootstrap admin template.">
<meta name="author" content="Muhammad Usman">
<!-- The styles -->
<link id="bs-css" href="css/bootstrap-cerulean.min.css" rel="stylesheet">
<link href="css/charisma-app.css" rel="stylesheet">
<link href='bower_components/chosen/chosen.min.css' rel='stylesheet'>
<link href='bower_components/colorbox/example3/colorbox.css' rel='stylesheet'>
<link href='bower_components/responsive-tables/responsive-tables.css' rel='stylesheet'>
<link href='bower_components/bootstrap-tour/build/css/bootstrap-tour.min.css' rel='stylesheet'>
<link href='css/jquery.noty.css' rel='stylesheet'>
<link href='css/noty_theme_default.css' rel='stylesheet'>
<link href='css/elfinder.min.css' rel='stylesheet'>
<link href='css/elfinder.theme.css' rel='stylesheet'>
<link href='css/jquery.iphone.toggle.css' rel='stylesheet'>
<link href='css/uploadify.css' rel='stylesheet'>
<?php
/**
* Template Name: Home
*/
$post_home = $post;
get_header();
$p=1;
$nb_display = 50;
if(isset($_GET["pagin"]) && is_numeric($_GET["pagin"])){
$p=$_GET["pagin"];
}
require 'wp-content/plugins/MyPlugin/class/MyPDO.php';
$bdd = new MyPDO();
$ret_max = $bdd->query('SELECT count(*) as max_result FROM `game` WHERE creato=?',date('Y-m-d'));
$max = (int) $ret_max[0]->max_result;
if(!$max){
include 'wp-content/plugins/MyPlugin/robot.php';
}
$ret = $bdd->query('SELECT SQL_CALC_FOUND_ROWS * from game where creato=? order by percent desc, prix_apres asc LIMIT '.($p-1).','.$nb_display, array(date('Y-m-d')));
$ret_max = $bdd->query('SELECT FOUND_ROWS() as max_result');
$max = (int) $ret_max[0]->max_result;
?>
<div class="col1">
<div id="archivebox">
<?php
ini_set('session.save_path', realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/temp'));
session_start();
if (!isset($_SESSION['admin'])) {
header("location:login.html");
}
include 'config.php';
include_once "config/MyPDO.class.php";
$connect = new MyPDO();
$connect->query("SET NAMES 'utf8'");
?>
<!DOCTYPE html>
<html lang="fr">
<head>
<!--
===
This comment should NOT be removed.
Charisma v2.0.0
Copyright 2012-2014 Muhammad Usman
Licensed under the Apache License v2.0
http://www.apache.org/licenses/LICENSE-2.0
http://usman.it
http://twitter.com/halalit_usman
===
-->
<meta charset="utf-8">
<title>MEDICA</title>
