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>