<?php

    session_start();
    require_once("twitter/twitteroauth/twitteroauth.php");

    $username="root";
    $password = "root";
    $database="xx";
    mysql_connect('localhost',$username,$password);
    $db_selected = mysql_select_db($database);

    if ( !$db_selected ) {
        die( "Unable to select database");
    }
    $queryy = "SELECT * FROM 'twitter'";
    $resultt = mysql_query($queryy);

        while ($row = mysql_fetch_object($resultt)) {
        $accesstoken=$row['twit_email'];
        $accesstokensecret=$row['password'];

        }
               $cursor = -1;
                    $followers = array();

              do {
            $json = file_get_contents('https://api.twitter.com/1.1/search/tweets.json?cursor=' . $cursor);
            $accounts = json_decode($json);
            foreach ($accounts->users as $account)
                $followers[$account->id_str] = $account->screen_name;

            $cursor = $accounts->next_cursor;

        } while ($cursor > 0);

        // Now save in the database
        foreach($followers as $key => $value) {

            // Do we update or do we insert?
            $res = $this-> $database->prepare('SELECT COUNT(*) FROM `twit_contacts` WHERE twitID = :id');
            $res->execute(array('id' => $key));
            $rows = $res->fetch(PDO::FETCH_NUM);

            if (!$rows[0])
                $this->$database->prepare('INSERT INTO `twit_contacts` SET twitID = :id, contactName = :name, dateContactFrom = NOW()')
                        ->execute(array(':id' => $key, ':name' => $value));
            else
                $this->$database->prepare('UPDATE `twit_contacts` SET contactName = :name, dateContactFrom = NOW() WHERE twitID = :id')
                        ->execute(array(':id' => $key, ':name' => $value));
        }









    $query = "SELECT * FROM 'twit_contacts'";
    $result = mysql_query($query);

    $oldFollowers = array();

    while ($row = mysql_fetch_object($result)) {
        $oldFollowers[$row->contactID] = array('screen_name'=>$row->screen_name, 'contactName'=>$row->username);
        echo $oldFollowers['screen_name'];
    }


    mysql_close();
?>