<?php
/**
* Created by PhpStorm.
* User: kevin
* Date: 23/01/16
* Time: 21:34
*/
include_once 'db_wrap.php';
include "/home/aaron-aaron/www/src/class/Twitter.php";
$bd = new \db\db_handler();
$bd->init();
$sql = "DELETE FROM TWEET";
$bd->query($sql);
$sql = "SELECT * FROM TWITTER";
$stmt = $bd->query($sql);
while ($result = $stmt->fetch()) {
$newFlux = new Twitter($result['ID'], $result['NAME']);
$newFlux->refresh();
}
$bd->close();
public function searchTwitter($name)
{
$sql = "SELECT COUNT(*) FROM TWITTER WHERE NAME = \"" . $name . "\"";
$result = $this->pdo->query($sql)->fetch();
if ($result[0] == 0) {
$sql = "INSERT INTO TWITTER(NAME) VALUES(\"" . $name . "\")";
$this->pdo->query($sql);
$idTwitter = $this->pdo->lastInsertId();
$sql = "INSERT INTO TWITTER_ASSOC(IDTWITTER,IDUSER) VALUES(" . $idTwitter . "," . $_SESSION['ID'] . ")";
$this->pdo->query($sql);
$twitter = new Twitter($idTwitter, $name);
$twitter->refresh();
} else {
$sql = "SELECT ID FROM TWITTER WHERE NAME = \"" . $name . "\"";
$result = $this->pdo->query($sql)->fetch();
$sql = "INSERT INTO TWITTER_ASSOC(IDTWITTER,IDUSER) VALUES(" . $result[0] . "," . $_SESSION['ID'] . ")";
$this->pdo->query($sql);
}
}
