public function getAdwordsData()
{
$targetingIdeaService = $this->user->GetService('TargetingIdeaService', ADWORDS_VERSION);
$selector = new TargetingIdeaSelector();
$selector->requestType = 'STATS';
$selector->ideaType = 'KEYWORD';
$selector->requestedAttributeTypes = array('SEARCH_VOLUME', 'COMPETITION');
$selector->paging = new Paging(0, AdWordsConstants::RECOMMENDED_PAGE_SIZE);
$selector->localeCode = 'fr_FR';
$selector->currencyCode = 'EUR';
$language = new Language();
$language->id = '1002';
$selector->searchParameters[] = new LanguageSearchParameter($language);
$relatedToQuerySearchParameter = new RelatedToQuerySearchParameter();
$relatedToQuerySearchParameter->queries = $this->keyword['keyword'];
$selector->searchParameters[] = $relatedToQuerySearchParameter;
$page = $targetingIdeaService->get($selector);
if (sizeof($page->entries) > 0) {
$vol = $page->entries[0]->data[0]->value->value == 0 ? 5 : $page->entries[0]->data[0]->value->value;
$comp = (double) round($page->entries[0]->data[1]->value->value, 2);
Connexion::getInstance()->query("UPDATE keyword SET search = '" . $vol . "', competition = '" . round($comp, 2) . "' WHERE id_keyword = '" . $this->keyword['id_keyword'] . "' ");
} else {
Connexion::getInstance()->query("UPDATE keyword SET search = '5', competition = '0' WHERE id_keyword = '" . $this->keyword['id_keyword'] . "' ");
}
}
public function __construct($host, $dbName, $login, $password)
{
$this->host = $host;
$this->dbName = $dbName;
$this->login = $login;
$this->password = $password;
$this->dbpdo = Connexion::getInstance($host, $dbName, $login, $password)->getConnexion();
}
public function __construct($idTerrain)
{
$bdd = Connexion::getInstance();
$query = $bdd->getData('SELECT * FROM terrain WHERE idTerrain=' . $idTerrain);
$data = $query->fetch(PDO::FETCH_ASSOC);
$this->_idTerrain = $data['idTerrain'];
$this->_emplacement = $data['emplacementTerrain'];
}
public function identification()
{
Connexion::getInstance()->query("SELECT name FROM user\r\n WHERE mail = '" . $this->login . "'\r\n AND password = '******' ");
$nom = Connexion::getInstance()->result();
if ($nom) {
return true;
}
return false;
}
public function __construct($idMatch)
{
$bdd = Connexion::getInstance();
$query = $bdd->getData('SELECT * FROM matchs WHERE idMatchs=' . $idMatch);
$data = $query->fetch(PDO::FETCH_ASSOC);
$this->_idMatch = $data['idMatchs'];
$this->_equipe1 = new Equipe($data['idEquipe1']);
$this->_equipe2 = new Equipe($data['idEquipe2']);
$this->_date = date_format(date_create($data['dateMatchs']), "d/m - H:i");
$this->_terrain = new Terrain($data['idTerrain']);
}
public function __construct($idEquipe)
{
$bdd = Connexion::getInstance();
$query = $bdd->getData('SELECT * FROM equipe WHERE idEquipe=' . $idEquipe);
$data = $query->fetch(PDO::FETCH_ASSOC);
$this->_idEquipe = $data['idEquipe'];
$this->_joueur1 = new Joueur($data['idJoueur1']);
if ($data['idJoueur2'] != null) {
$this->_joueur2 = new Joueur($data['idJoueur2']);
}
}
public function __construct($idJoueur)
{
$bdd = Connexion::getInstance();
$query = $bdd->getData('SELECT * FROM personnes WHERE idPersonne=' . $idJoueur);
$data = $query->fetch(PDO::FETCH_ASSOC);
$this->_idJoueur = $data['idPersonne'];
$this->_nom = $data['nomPersonne'];
$this->_prenom = $data['prenomPersonne'];
$this->_sexe = $data['sexePersonne'];
$this->_nationalite = $data['nationalitePersonne'];
$this->_classementATP = $data['classementJoueur'];
}
public function __construct()
{
$bdd = Connexion::getInstance();
$this->_listeMatchs = array();
$query = $bdd->getData('SELECT idMatchs FROM matchs');
$i = 0;
while ($data = $query->fetch(PDO::FETCH_ASSOC)) {
$match = new Match($data['idMatchs']);
$this->_listeMatchs[$i] = $match;
$i = $i + 1;
}
}
protected function IndexAction()
{
$this->data->keywords = Keyword::getKeywords($this->user->user['id']);
Connexion::getInstance()->query("SELECT gg, delay, url, frequency FROM user WHERE id = '" . $this->user->user['id'] . "' ");
$this->data->parameters = Connexion::getInstance()->fetch();
$numbers = array('0' => 0, '1' => 0, '2' => 0, '3' => 0);
foreach ($this->data->keywords as $keyword) {
if ($keyword['position'] > 0 && $keyword['position'] < 11) {
$numbers[0]++;
} elseif ($keyword['position'] >= 11 && $keyword['position'] < 31) {
$numbers[]++;
} elseif ($keyword['position'] >= 31 && $keyword['position'] < 51) {
$numbers[2]++;
} else {
$numbers[3]++;
}
}
$this->data->numbers = $numbers;
}
public function getposition()
{
Connexion::getInstance()->query("SELECT id_keyword, keyword FROM keyword WHERE id_keyword NOT IN (SELECT id_keyword FROM position) AND id_user = '******'id'] . "' LIMIT 0,1 ");
$keyword = Connexion::getInstance()->fetch();
if (isset($keyword['id_keyword'])) {
$keyword['url'] = $this->user['url'];
$keyword['gg'] = $this->user['gg'];
$keyword['delay'] = $this->user['delay'];
echo json_encode($keyword);
} else {
$date = new DateTime();
$date->modify('- ' . ($this->user['frequency'] - 1) . ' days');
Connexion::getInstance()->query("SELECT id_keyword, keyword FROM keyword WHERE id_keyword NOT IN (SELECT id_keyword FROM position WHERE date BETWEEN '" . $date->format('Y-m-d') . "' AND '" . date('Y-m-d') . "') AND id_user = '******'id'] . "' LIMIT 0,1 ");
$keyword = Connexion::getInstance()->fetch();
if (isset($keyword['id_keyword'])) {
$keyword['url'] = $this->user['url'];
$keyword['gg'] = $this->user['gg'];
$keyword['delay'] = $this->user['delay'];
echo json_encode($keyword);
}
}
exit;
}
public function __construct($mail)
{
Connexion::getInstance()->query("SELECT * FROM user WHERE mail = '" . $mail . "' ");
$this->user = Connexion::getInstance()->fetch();
return $this->user;
}
<?php
require_once '../Model/Connexion.php';
require_once '../Model/Equipe.php';
require_once '../Model/Joueur.php';
require_once '../Model/Terrain.php';
require_once '../Model/Match.php';
require_once '../Model/ListeMatchs.php';
$bdd = Connexion::getInstance();
$prix = $_POST['prix'];
if ($prix < 0) {
$prix = 0;
}
$query = $bdd->setData('UPDATE matchs SET prixMatchs="' . $prix . '" WHERE idMatchs=' . $_POST['match']);
require_once '../View/view_pageDeValidation.php';
public function getConcurrents($keyword)
{
Connexion::getInstance()->query("SELECT max(date) FROM position WHERE id_keyword = '" . $keyword['id_keyword'] . "' ");
$date = Connexion::getInstance()->result();
Connexion::getInstance()->query("SELECT u.*, p.position FROM position p LEFT JOIN url u ON p.id_url = u.id_url WHERE p.id_keyword = '" . $keyword['id_keyword'] . "' AND date = '" . $date . "' ");
return Connexion::getInstance()->fetchAll();
}
<?php
session_start();
header('Content-Type: application/json');
require './liste_include_ajax.php';
require '../classes/connexion.class.php';
require '../classes/produits_m.class.php';
require '../classes/produits_m_manager.class.php';
$db = Connexion::getInstance($dsn, $user, $pass);
try {
$mg = new produits_m_manager($db);
if ($_SESSION['lignedf'] == 0) {
$_SESSION['test'] = $mg->addFacture($_POST['id_utilisateur']);
$_SESSION['lignedf'] = 1;
}
if ($_SESSION['test'] != 0) {
$retour = $mg->addDetail($_SESSION['test'], $_POST['id_prod'], $_POST['quantite']);
if ($retour != 0) {
$_SESSION['choix'] = "default";
$_SESSION['valeur'] = "default";
} else {
$_SESSION['choix'] = "default";
}
}
print json_encode(array("retour" => $retour));
} catch (PDOException $e) {
print "Echec de la connexion" . $e;
}
public function __construct()
{
$this->dbpdo = Connexion::getInstance()->getConnexion();
}
private function getSQLQueryToImport($sql_host, $sql_db, $sql_login, $sql_pwd, $mysql_version)
{
$file = 'database.zip';
$toFile = BASE . 'data/' . $file;
if (!is_file($toFile)) {
return '';
}
$fileName = str_replace('.zip', '', $file);
$positionBigQueries = 0;
$bigQueries = array();
$bigQuery = '';
// Récupération du fichier de configuration doorgets.php
$zip = new ZipArchive();
if ($res = $zip->open($toFile)) {
// Extraction des données de la databse vers un dossier Temp
$nameDirTemp = BASE . 'data/_temp/';
if (!is_dir($nameDirTemp)) {
@mkdir($nameDirTemp, 0777, true);
}
if (!is_dir($nameDirTemp . $fileName . '/')) {
@mkdir($nameDirTemp . $fileName . '/', 0777, true);
}
$dirTempDatabase = $nameDirTemp . $fileName . '/';
$dirToCopyAllDatas = BASE . '';
$zip->extractTo($dirTempDatabase);
$zip->close();
$sql_query_install = '';
$dirDatabase = 'database/';
$contents = file_get_contents($dirTempDatabase . 'database/doorgets.php');
$configData = unserialize($contents);
if (!empty($configData) && is_array($configData)) {
$sql_query_install = '';
$dirDatabase = 'database/';
$bigQueries['create'] = '';
try {
$db = Connexion::getInstance($sql_host, $sql_db, $sql_login, $sql_pwd)->getConnexion();
// $default_charset = 'utf8';
// $default_collation = 'utf8_general_ci';
// if ($mysql_version > '5.5.3') {
// $default_charset = 'utf8mb4';
// $default_collation = 'utf8mb4_general_ci';
// }
//$db->query("SET NAMES '$default_charset' COLLATE '$default_collation';");
// Installation de la base de données
$queries = '';
foreach ($configData as $k => $v) {
if (!empty($v['sql_create_table'])) {
$query = str_replace("\n", ' ', $v['sql_create_table']);
$query = str_replace("\t", '', $query);
$query = str_replace("\r", '', $query);
//$bigQueries['create'] .= $query;
$queries .= $query;
}
}
$db->exec($queries);
// Installation de la base de données
foreach ($configData as $k => $v) {
$dirDatabaseName = $dirTempDatabase . 'database/' . $k . '/';
$allFiles = $this->files($dirDatabaseName);
foreach ($allFiles as $nameFile) {
if (!empty($queries)) {
$db->exec(file_get_contents($dirDatabaseName . $nameFile));
}
}
}
} catch (PDOException $e) {
//echo "DataBase Errorz: " .$e->getMessage() .'<br>'; exit();
} catch (Exception $e) {
//echo "General Errorz: ".$e->getMessage() .'<br>'; exit();
}
// Suppression des données temporaire
if (is_dir($nameDirTemp)) {
$this->destroy_dir($nameDirTemp);
}
}
}
}
<?php
$out = array();
$x = exec('ps -ef | grep -v grep | grep ' . $_SERVER['PHP_SELF'] . ' | awk \'{print $2}\' ', $out);
if (sizeof($out) > 2) {
echo 'Already launched';
exit;
}
require_once dirname(__FILE__) . '/bootstrap.php';
Connexion::getInstance()->query("SELECT keyword, id_keyword\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM keyword\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE search = 0 ");
$keywords = Connexion::getInstance()->fetchAll();
foreach ($keywords as $keyword) {
new Adwords($keyword);
}
protected function RecordAction()
{
Connexion::getInstance()->query("UPDATE user SET gg = '" . addslashes($this->post_data['gg']) . "', delay = '" . addslashes($this->post_data['delay']) . "', url = '" . addslashes($this->post_data['url']) . "', frequency = '" . addslashes($this->post_data['frequency']) . "' WHERE id = '" . $this->user->user['id'] . "' ");
header('location:/parameters');
exit;
}
