duanjiu1950 2013-09-19 16:35
浏览 61


I have successfully extracted tweets belonging to a certain hashtag.

For people interested in code,Its at the bottom.

This is what I have done:#Dhoom3teaser

But for some reasons I need to get every single tweet inserted in to my table.How do I keep inserting something at regular interval without repitition.(i.e tweet should be inserted according to their timestamp).How do I distinguish tweets?

I thought may be I will use setInterval.But then Thought there could be a better solution.

Hope I am clear?

ini_set('display_errors', 1);
include_once $_SERVER["DOCUMENT_ROOT"]."/includes/db/db_conn.php";

$settings = array(
    'oauth_access_token' => "",
    'oauth_access_token_secret' => "",
    'consumer_key' => "",
    'consumer_secret' => ""
$url = 'https://api.twitter.com/1.1/search/tweets.json';
$getfield = '?q=#Dhoom3Teaser';
$requestMethod = 'GET';

$twitter = new TwitterAPIExchange($settings);
$response = $twitter->setGetfield($getfield)
    ->buildOauth($url, $requestMethod)

$decoded = json_decode($response);

echo '<pre>';print_r($decoded);echo '<pre>';
  • 写回答

2条回答 默认 最新

  • dounieliang4712 2013-09-19 17:42

    You want a cron job. Here's an article on how to set it up: http://www.thesitewizard.com/general/set-cron-job.shtml

    What a cron job is, is just a standard way to run your script on a schedule. So, once a day, or once an hour, or at 2:15 on the 3rd Saturday of each month, etc. You're going to write the cron job so that it will run your tweet grabbing script, and then to make sure that there are no repeated tweets, you're going to check the table for duplicates before inserting a new tweet. I'm sure (but could be wrong) that each tweet has some sort of tweet id, so make sure that a tweet with that id doesn't exist in the table before inserting it.

    Edit: Actually, it would be better to make your table so that each row's ID is UNIQUE. You don't have to write any extra php that way.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥18 深度学习tensorflow1,ssdv1,coco数据集训练一个模型
  • ¥100 关于注册表摄像头和麦克风的问题
  • ¥30 代码本地运行正常,但是TOMCAT部署时闪退
  • ¥15 关于#python#的问题
  • ¥15 主机可以ping通路由器但是连不上网怎么办
  • ¥15 数据库一张以时间排好序的表中,找出多次相邻的那些行
  • ¥50 关于DynamoRIO处理多线程程序时候的问题
  • ¥15 kubeadm部署k8s出错
  • ¥15 Abaqus打不开cae文件怎么办?
  • ¥15 小程序准备上线,软件开发公司需要提供哪些资料给甲方