PHP application that Import twitter stream to a MS SQL Server
$30-250 USD
Closed
Posted over 9 years ago
$30-250 USD
Paid on delivery
Hi I have a emergency project. (Price max 50 dollar shall be confirmed that this work)
I want via application I can run on my Mac Server getting Twitter User streams (*) and the REST API import all that my Twitter account follow tweets and store them in a Microsoft SQL Soft
the code shall in the start have a config for both authorization and database access config.
- Tell me what data we can get? Minimum is @username timestamp text ( [login to view URL])
- Realtime or as close as possible.
If possible I want this up and working on Sunday.
(*) Hope this is the right API that can give me realtime access to what the user I am following posting.
Preferred language: PHP but Python work also.
database look like this today...
[ID] [int] IDENTITY(1,1) NOT NULL,
[PUBDATE] [datetime] NULL,
[TITLE] [varchar](200) NULL,
[RIC] [varchar](25) NULL,
[LINK] [varchar](300) NULL,
[NEWSTYPE] [varchar](25) NULL,
[CLEARED] [tinyint] NULL,
[SOURCE] [varchar](25) NULL,
[BODY] [varchar](8000) NULL,
---
string VLINK = "";
s = [login to view URL];
s = [login to view URL]("'", "");
VLINK = [login to view URL];
sql = "INSERT INTO [xxxxxx].[dbo].[NEWS] (TITLE,LINK,NEWSTYPE,CLEARED,SOURCE,BODY,RIC,PUBDATE) VALUES ('" + s + "','" + VLINK + "','TWEET'," + 0 + ",'" + [login to view URL] + "','TWITTER TEXT WILL COME HERE','NA','" + [login to view URL] + "')";
hi and thanks for the invitation.
I am PHP expert with 6 yrs of experience. I can deliver on sunday for sure.
when you are here, message me please to discuss it and get started.
Waiting for your answer and thanks.
Hi!
I have some experience developing PHP scripts. I have reviewed the project brief and I understand what needs to be done. I would love the opportunity to work on your project and I can begin right away. Please contact me for further discussion.
Thanks