function maintain_angry() { $pdo = PDO2::getInstance(); $query = $pdo->prepare("UPDATE tbl_rabbit_skill SET skill_angry = skill_angry - :maintain_value"); $query->bindValue(":maintain_value", 10); return $pdo->execute(); }
function ajouter_user_dans_bd($firstname, $lastname, $username, $password, $repassword, $email) { $bdd = PDO2::getInstance(); $bothSame = $bdd->prepare("SELECT nom_utilisateur FROM membres WHERE nom_utilisateur = ':user'"); $bothSame->bindParam(':user', $username); $bothSame->execute(); if ($bothSame->rowCount() > 0) { echo 'Désolé l\'utilisateur que vous essayer de prendre est déjàutilisé dans la base de données' . 'Veuillez en choisir un autre.'; } else { $req = $bdd->prepare('INSERT INTO membres(prenom, nom_famille, nom_utilisateur, mot_de_passe, adresse_email, date_inscription) VALUES(:firstname,:lastname,:utilisateur, :password, :email, NOW()'); $req->bindValue(':firstname', $firstname); $req->bindValue(':lastname', $lastname); $req->bindValue(':utilisateur', $username); $req->bindValue(':password', $password); $req->bindValue(':email', $email); //$req->bindValue(':date', date('Y-m-d H:i:s')); if ($req->execute()) { return $pdo->lastInsertId(); } $select = $bdd->query('SELECT * FROM membres'); while ($donnees = $select->fetch()) { $_SESSION['utilisateur'] = $donnees['nom_utilisateur']; } $select->closeCursor(); } }
function lire_infos_utilisateur($id_utilisateur) { $pdo = PDO2::getInstance(); $requete = $pdo->prepare("SELECT nom_utilisateur, mot_de_passe, adresse_email, date_inscription, hash_validation\n FROM membres\n WHERE\n id = :id_utilisateur"); $requete->bindValue(':id_utilisateur', $id_utilisateur); return $requete->execute() ? $requete->fetch(PDO::FETCH_ASSOC) : false; }
public function retrouver_mess_forum($forum) { $connexion = PDO2::getInstance(); $requete_select_forum = $requete_tous_message = "SELECT * FROM message WHERE forum_ForumID = {$id_forum}"; $db = $connexion->query($requete_tous_titres); $resultat = $db->fetchAll(PDO::FETCH_ASSOC); return $resultat; }
function ajouter_membre_dans_bdd($nom_utilisateur, $mdp, $adresse_email, $hash_validation) { $pdo = PDO2::getInstance(); $requete = $pdo->prepare("INSERT INTO membres SET\n nom_utilisateur = :nom_utilisateur,\n mot_de_passe = :mot_de_passe,\n adresse_email = :adresse_email,\n hash_validation = :hash_validation,\n date_inscription = NOW()"); $requete->bindValue(':nom_utilisateur', $nom_utilisateur); $requete->bindValue(':mot_de_passe', $mdp); $requete->bindValue(':adresse_email', $adresse_email); $requete->bindValue(':hash_validation', $hash_validation); return $requete->execute() ? $pdo->lastInsertId() : $requete->errorInfo(); }
public static function getInstance() { if (!isset(self::$_instance)) { try { self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD); } catch (PDOException $e) { echo $e; } } return self::$_instance; }
public static function getInstance() { if (!isset(self::$_instance)) { try { self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); } catch (PDOException $e) { echo $e; } } return self::$_instance; }
function user_has_nabz($usr_nabz) { $pdo = PDO2::getInstance(); $query = $pdo->prepare("SELECT rabbit_id FROM tbl_rabbit WHERE rabbit_usr_id = :user_id"); $query->bindValue(":user_id", $usr_nabz); $query->execute(); if ($result = $query->fetch(PDO::FETCH_ASSOC)) { $query->closeCursor(); return $result['rabbit_id']; } return false; }
public static function getInstance() { if (!isset(self::$_instance)) { try { self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); } catch (Exception $e) { echo 'Problem connecting to the database.'; exit; } } return self::$_instance; }
/** * Permet d'acquérir l'objet PDO. * S'il n'existe pas il sera créé. * * @return PDO2, le seul objet de la présente classe. */ public static function getInstance() { if (!isset(self::$_instance)) { try { // constants disponible dans le fichier ./global/config.php self::$_instance = new PDO(SQL_DSN, SQL_USERNAME, SQL_PASSWORD); } catch (PDOException $e) { // TODO attention il ne faudrait pas afficher d'info ici echo $e; } } return self::$_instance; }
function get_serial_and_token($id_nabz) { $pdo = PDO2::getInstance(); $query = $pdo->prepare("SELECT rabbit_serial, rabbit_token FROM tbl_rabbit WHERE rabbit_id = :id_nabz", array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL)); $query->bindValue(":id_nabz", $id_nabz); $query->execute(); $tbx = array(); while ($row = $query->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) { $tbx['rabbit_serial'] = $row[0]; $tbx['rabbit_token'] = $row[1]; } //$tbx is an array with all the informations of a product return $tbx; }
public static function getInstance() { if (!isset(self::$_instance)) { try { self::$_instance = new PDO('mysql:host=localhost;dbname=a-bime', 'root', 'root'); //self::$_instance = new PDO('mysql:host=5.39.82.228;dbname=bde', 'alex', 'lameretrappe'); self::$_instance->exec('SET NAMES utf8'); self::$_instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo $e; } } return self::$_instance; }
function add_member_in_db($username, $password, $email_addr, $hash_validation) { $pdo = PDO2::getInstance(); $query = $pdo->prepare("INSERT INTO tbl_user SET user_pseudo = :username, user_pass = :password, user_mail = :email_addr, hash_validation = :hash_validation, user_balance = :CASH_START, user_lastconnect = NOW()"); $query->bindValue(":username", $username); $query->bindValue(":password", $password); $query->bindValue(":email_addr", $email_addr); $query->bindValue(":hash_validation", $hash_validation); $query->bindValue(":CASH_START", CASH_START); if ($query->execute()) { return $pdo->lastInsertId(); } print_r($query->errorInfo()); return $query->errorInfo(); }
function buy_ticket($id_user, $number, $ticket_price) { $pdo = PDO2::getInstance(); //Change usr_id column in number row in the table tbl_numbers $query = $pdo->prepare("UPDATE tbl_numbers SET usr_id = :usr_id WHERE id = :number"); $query->bindValue(":usr_id", $id_user); $query->bindValue(":number", $number); $query->execute(); print_r($query->errorInfo()); //Update the balance of the account $query = $pdo->prepare("UPDATE tbl_user SET user_balance = :new_balance WHERE user_id = :id_user"); $query->bindValue(":new_balance", user_balance($id_user) - $ticket_price); $query->bindValue(":id_user", $id_user); $query->execute(); print_r($query->errorInfo()); update_jackpot(); }
public function get_tous_mess_dans_forum($id_forum) { $bdd = PDO2::getInstance(); if ($id_forum == 1) { $req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=1'); $forum = $req->fetchAll(); } else { if ($id_forum == 2) { $req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=2'); $forum = $req->fetchAll(); } else { if ($id_forum == 3) { $req = $bdd->query('SELECT * FROM message WHERE forum_ForumID=3'); $forum = $req->fetchAll(); } } } return $forum; }
protected function UpdateQuery($table, $data) { $pdo = PDO2::getInstance(); $params = []; $fields = []; $id = []; foreach ($data as $key => $val) { $params[':' . $key . ''] = $val; array_push($fields, $key . '=:' . $key); if ($key[0]) { array_push($id, $key . '=:' . $key); } } $id = array_slice($fields, 0, 1); $fields = array_slice($fields, 1); $sql = "UPDATE " . $table . " SET " . implode(', ', $fields) . " WHERE " . implode('', $id) . ""; $stmt = $pdo->prepare($sql); $stmt = $stmt->execute($params); return $stmt; }
function widget($args, $instance) { extract($args); /** This filter is documented in wp-includes/default-widgets.php */ $title = apply_filters('widget_title', empty($instance['title']) ? '' : $instance['title'], $instance, $this->id_base); /* $text = apply_filters( 'widget_text', empty( $instance['text'] ) ? '' : $instance['text'], $instance ); echo $before_widget; if ( !empty( $title ) ) { echo $before_title . $title . $after_title; } */ ?> <!-- <div class="textwidget"><?php /*echo !empty( $instance['filter'] ) ? wpautop( $text ) : $text; */ ?> </div> --><?php /* echo $after_widget;*/ include WP_PLUGIN_URL . '/manage-maps/PDO.php'; ?> <style> html, body { height: 100%; margin: 0px; padding: 0px } #map-canvas { height: 254px !important; width: 352px !important; } #panel { position: absolute; top: 5px; left: 50%; margin-left: -180px; z-index: 5; background-color: #fff; padding: 5px; border: 1px solid #999; } </style> <?php echo $title; ?> <script src="https://maps.googleapis.com/maps/api/js?v=3.exp"></script> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.0/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.0/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> var directionsDisplay; var directionsService = new google.maps.DirectionsService(); var map; function initialize() { directionsDisplay = new google.maps.DirectionsRenderer(); var chicago = new google.maps.LatLng(-23.6824124, -46.5952992); var mapOptions = { zoom: 6, center: chicago } map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions); <?php $pdo = new PDO2(); $conn = $pdo->conn(); $object = $pdo->showlist($conn); while ($data = mysql_fetch_array($object)) { ?> jQuery.get( "http://maps.googleapis.com/maps/api/geocode/json", { address: "<?php echo utf8_decode($data['endereco']); ?> , <?php echo $data['numero']; ?> - <?php echo utf8_decode($data['bairro']); ?> - <?php echo utf8_decode($data['estado']); ?> " }, function(data){ console.log(data); var marker = new google.maps.Marker({ position: data.results[0].geometry.location, map: map, title: data.results[0].formatted_address }); google.maps.event.addListener(marker, 'click', function () { jQuery("#end").val(data.results[0].formatted_address); }); }); <?php } ?> directionsDisplay.setMap(map); } function calcRoute() { var start = document.getElementById('start').value; var end = document.getElementById('end').value; var waypts = []; var checkboxArray = document.getElementById('waypoints'); for (var i = 0; i < checkboxArray.length; i++) { if (checkboxArray.options[i].selected == true) { waypts.push({ location:checkboxArray[i].value, stopover:true}); } } var request = { origin: start, destination: end, waypoints: waypts, optimizeWaypoints: true, travelMode: google.maps.TravelMode.DRIVING }; directionsService.route(request, function(response, status) { if (status == google.maps.DirectionsStatus.OK) { directionsDisplay.setDirections(response); var route = response.routes[0]; var summaryPanel = document.getElementById('directions_panel'); summaryPanel.innerHTML = ''; // For each route, display summary information. jQuery('#end').css('color','#000') for (var i = 0; i < route.legs.length; i++) { var routeSegment = i + 1; summaryPanel.innerHTML += '<b>Route Segment: ' + routeSegment + '</b><br>'; summaryPanel.innerHTML += route.legs[i].start_address + ' to '; summaryPanel.innerHTML += route.legs[i].end_address + '<br>'; for(var x=0; x < route.legs[i].steps.length; x++) { summaryPanel.innerHTML += route.legs[i].steps[x].instructions +' '+ route.legs[i].steps[x].distance.text + '<br />' } summaryPanel.innerHTML += route.legs[i].distance.text + '<br><br>'; } } else { jQuery('#end').css('color','red')} }); } google.maps.event.addDomListener(window, 'load', initialize); </script> </head> <body> <div id="map-canvas"></div> <div id="control_panel" style="float:right;width:30%;text-align:left;padding-top:20px"> <div style="margin-left: -215px;border-width:2px;"> <b>Filial:</b> <select id="start" style="width: 100%;"> <option value="">Selecione...</option> <?php $pdo = new PDO2(); $conn = $pdo->conn(); $object = $pdo->showlist($conn); while ($data = mysql_fetch_array($object)) { echo '<option value="' . utf8_decode($data['endereco']) . ', ' . utf8_decode($data['numero']) . ' - ' . utf8_decode($data['bairro']) . ' - ' . utf8_decode($data['cidade']) . ' ">' . utf8_decode($data['endereco']) . ', ' . utf8_decode($data['numero']) . ' - ' . utf8_decode($data['bairro']) . ' - ' . utf8_decode($data['cidade']) . '</option>'; } ?> </select> <br> <!-- <b>Waypoints:</b> <br>--> <!-- <i>(Ctrl-Click for multiple selection)</i> <br>--> <select multiple id="waypoints" style="display: none; width: 100%;"> <option value="montreal, quebec">Montreal, QBC</option> <option value="toronto, ont">Toronto, ONT</option> <option value="chicago, il">Chicago</option> <option value="winnipeg, mb">Winnipeg</option> <option value="fargo, nd">Fargo</option> <option value="calgary, ab">Calgary</option> <option value="spokane, wa">Spokane</option> </select> <br> <b>End:</b> <!-- <select id="end"> <option value="R. Lucimar Fernandes Dantas - Jardim Santa Rosa, Ferraz de Vasconcelos - SP, República Federativa do Brasil">Rua Lucimar Fernandes Dantas</option> <option value="Seattle, WA">Seattle, WA</option> <option value="San Francisco, CA">San Francisco, CA</option> <option value="Los Angeles, CA">Los Angeles, CA</option> </select> --> <input type="text" name="end" id="end" value="" style="width: 100%; margin-bottom: 3px;"/> <br> <input type="submit" onclick="calcRoute();"> </div> <div id="directions_panel" style="margin-left:-215px;background-color:#FFEE77;"></div> </div> </body> <script type="text/javascript"> jQuery(function() { function carregarNoMapa(endereco) { jQuery.get( "http://maps.googleapis.com/maps/api/geocode/json", { address: endereco }, function(data){ console.log(data); } ); } $("#end").blur(function() { if($(this).val() != "") carregarNoMapa($(this).val()); }); // var availableTags = [ // "ActionScript", // "AppleScript", // "Asp", // "BASIC", // "C", // "C++", // "Clojure", // "COBOL", // "ColdFusion", // "Erlang", // "Fortran", // "Groovy", // "Haskell", // "Java", // "JavaScript", // "Lisp", // "Perl", // "PHP", // "Python", // "Ruby", // "Scala", // "Scheme" // ]; // jQuery( "#end" ).autocomplete({ // source: availableTags // }); }); </script> <?php }
function up_lastconnect($id_user) { $pdo = PDO2::getInstance(); $query = $pdo->prepare("UPDATE tbl_user SET user_lastconnect = NOW() WHERE user_id = :id_user"); $query->bindValue(":id_user", $id_user); return $query->execute(); }
function delete_product_incart($id_product) { $pdo = PDO2::getInstance(); $quantity = display_quantity($id_product, $_SESSION['id']); $query = $pdo->prepare("DELETE FROM tbl_cart WHERE product_id = :id_product"); $query->bindValue(':id_product', $id_product); $query->execute(); return $query->rowCount() == 1; }
public function getEntityPosition(array $filterClauses = array(), array $orderClauses = array()) { $pdo = PDO2::getInstance(); $requete = $pdo->prepare("\n\t\t\t\tSET @rownum=0\n\t\t\t\t"); $requete->execute(); $where = ""; if (count($filterClauses) > 0) { foreach ($filterClauses as $key => $value) { $where[] = $value[0] . "= :" . $value[0]; } $where = implode(" AND ", $where); $where = " WHERE " . $where; } $order = ""; if (count($orderClauses) > 0) { foreach ($orderClauses as $key => $value) { $order[] = $value[0] . " " . $value[1]; } $order = implode(", ", $order); $order = " ORDER BY " . $order; } $requete = $pdo->prepare("\n\t\t\t\tSELECT num\n\t\t\t\tFROM(\n\t\t\t\tSELECT @rownum:=@rownum+1 as num, id\n\t\t\t\tFROM " . static::getTable() . "\n\t\t\t\t" . $where . "\n\t\t\t\t" . $order . "\n\t\t) e\n\t\t\t\tWHERE id=:id\n\t\t"); $requete->bindValue(':id', $this->getId(), PDO::PARAM_STR); if (count($filterClauses) > 0) { foreach ($filterClauses as $key => $value) { $requete->bindValue(":" . $value[0], $value[1]); } } $requete->execute(); if ($position = $requete->fetch()) { return $position['num']; } else { return false; //print_r($requete->errorInfo()); } }
public static function deleteSkillForProject($skill_id, $project_id) { $pdo = PDO2::getInstance(); $requete = $pdo->prepare("\n\t\t\t\tDELETE FROM asso_projects_skills\n\t\t\t\tWHERE id_project=:id_project\n\t\t\t\tAND id_skill= :id_skill\n\t\t\t\t"); $requete->bindValue(':id_project', $project_id); $requete->bindValue(':id_skill', $skill_id); if ($requete->execute()) { return true; } else { return false; //print_r($requete->errorInfo()); } }
function uniq_prdct_in_cart($prdct_id, $usr_id) { $pdo = PDO2::getInstance(); $query = $pdo->prepare("SELECT cart_id FROM tbl_cart WHERE user_id = :id_user AND product_id = :id_product"); $query->bindValue(":id_user", $usr_id); $query->bindValue(":id_product", $prdct_id); $query->execute(); if ($result = $query->fetch(PDO::FETCH_ASSOC)) { $query->closeCursor(); return $result['cart_id']; } return false; }
function main_manage_maps() { $pdo = new PDO2(); $conn = $pdo->conn(); if (isset($_POST['endereco']) && isset($_POST['action']) == 'add') { $get = $_POST; $message = $pdo->insert($conn, $get); if ($message != '') { echo $message = "<h1>Inserido com sucesso</h1>"; } else { echo $message; } } else { if ($_GET['action'] == 'delete') { $pdo->delete($_GET['id'], $conn); echo "<h1>Deletado com sucesso</h1>"; } } echo "\n <h1>Cadastro de Endereços</h1>\n <form action='admin.php?page=manage-maps' method='post'>\n <div class='admin_manage_maps'>\n <table>\n <tr>\n <th>Cep</th>\n <th>Endereço</th>\n <th>Numero</th>\n </tr>\n <tr>\n <td><input type='text' value='' name='cep'/></td>\n <td><input type='text' value='' name='endereco'/></td>\n <td><input type='text' value='' name='numero' /></td>\n </tr>\n <tr>\n <th>Bairro</th>\n <th>Cidade</th>\n <th>Estado</th>\n </tr>\n <tr>\n <td><input type='text' value='' name='bairro' /></td>\n <td><input type='text' value='' name='cidade' /></td>\n <td><input type='text' value='' name='estado'/></td>\n </tr>\n <tr>\n <td><input type='submit' value='Cadastrar'/></td>\n <input type='hidden' name='action' value='add' />\n <input type='hidden' name='page' value='manage-maps' />\n </tr>\n </table>\n </div>\n </form>\n "; //show list data in base $object = $pdo->showlist($conn); ?> <table width='100%'> <tr> <th>Cep</th> <th>Endereço</th> <th>Número</th> <th>Bairro</th> <th>Cidade</th> <th>Estado</th> <th>Deletar</th> </tr> <?php while ($data = mysql_fetch_array($object)) { ?> <tr> <td class="row-title"><?php echo utf8_decode($data['cep']); ?> </td> <td class="row-title"><?php echo utf8_decode($data['endereco']); ?> </td> <td class="row-title"><?php echo utf8_decode($data['numero']); ?> </td> <td class="row-title"><?php echo utf8_decode($data['bairro']); ?> </td> <td class="row-title"><?php echo utf8_decode($data['cidade']); ?> </td> <td class="row-title"><?php echo utf8_decode($data['estado']); ?> </td> <td class="row-title"><a href='admin.php?page=manage-maps&action=delete&id=<?php echo utf8_decode($data['id']); ?> '>[X]</a></td> </tr> <?php } //endwhile echo "</table>"; }
<?php require_once 'pdo2.class.php'; $bdd = PDO2::getInstance(); $query = "INSERT INTO " . PREFIX_TABLE . "_lines VALUES(:nom, :prix, :qte, :tva)";
/** * Va chercher tous les messages de la table message qui sont du membre * qui détient l'id idMembre. * @param $idMembre - l'id du membre * @return array - un array d'objets messages du membre qui a l'id $idMembre */ function getMessagesMembre($idMembre) { $pdo = PDO2::getInstance(); $requete = $pdo->prepare("SELECT * FROM message WHERE membres_id = :idMembre ORDER BY forum_ForumID, horoDate DESC"); $requete->bindValue(':idMembre', $idMembre); $requete->execute(); if ($reponse = $requete->fetchAll(PDO::FETCH_ASSOC)) { $requete->closeCursor(); } $arrayMessages = array(); foreach ($reponse as $message) { $messageObj = new Message($message['messageID'], $message['texte'], $message['horoDate'], NULL, $message['parent_messageID'], $idMembre, $message['forum_ForumID']); $arrayMessages[] = $messageObj; } return $arrayMessages; }
function init_bingo() { $pdo = PDO2::getInstance(); $query = $pdo->prepare("UPDATE tbl_numbers SET usr_id = 0 WHERE usr_id >0"); $query->execute(); //Init jackpot on the txt_file update_bingo_jackpot(0); }