<?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); } }