directed study: week 5 presentation

8/14/2019 Directed Study: Week 5 Presentation

1/17

roup 1roup 1Week 5


2/17

What have we been at?Down to tech stuff!Dan is building the MySQL database.

Brian is creating the HTML and CSS.Billy is working on the PHP.

Solid product due before final report.


3/17

Twitter Feed

PHP Parsing

MySQL Database

HTML WebsiteFrontend


4/17

aniel Beereaniel BeereIntroduction to Twitter and MySQL


5/17

TwitterWhy We Twitter: UnderstandingMicroblogging Usage and Communities.

Studies Twitters Social Network.Users talk about daily activities and

seek/share information.Users intentions and connections with other

users.


6/17

TwitterA Few Chirps About Twitter .Detailed characterization of Twitter.

Identifies different classes of Twitter users andtheir behaviours.Geographical patterns and growth.Current size of the network.


7/17

MySQLMySQL is a relational database managementsystem (RDBMS) that runs as a serverproviding multi-user access to a number of databases.

Relational: DBMS which data is stored in theform of tables and the relationship among thedata is also stored in the form of tables.


8/17

MySQL Features/ToolsVarchar : is a set of character data of indeterminate length. Refers to a data type of a field in a DBMS.

SELECT : Statement that returns a result set of records from one or more tables.

Unicode : computing industry standard for therepresentation of text expressed in writingsystems.


9/17

MySQL Features/ToolsCache/Query Caching : component thatimproves performance by storing datasuch that future requests for that data canbe served faster.

Database Trigger : automatically executedin response to certain events on a

particular table in a database. E.g. When anew record (representing a new worker) isadded to the employees table, newrecords should be created also in the

tables of the taxes, vacations, and


10/17

Code to Consider$host = "testweb2.csis.ul.ie";$user = "0867241";

$pass = "danbeere";$db = "0867241";

$connection = mysql_connect($host,$user, $pass) or die ("Unable toconnect!");

mysql_select_db($db) or die ("Unable

to select database!");


11/17

Code to Considerif ($tokenNo > 0) { $condition = "(tag1 = '$tags[0]') OR (tag2 =

'$tags[0]')OR (tag3 = '$tags[0]')OR (tag4 ='$tags[0]')OR (tag5 = '$tags[0]')";

for($i=1; $i


12/17

i l l iam Kennedyil l iam KennedyPHP and the Twitter API


13/17

Twitter API: Some

ExamplesUsing the tools jQuery, PHP and the Twitter APIit is possible to parse a twitter feed andreconstitute it into whatever form you wish.

The Twitter API (in our case) returns data as anRSS/Atom feed. This feed must be parsed intochunks of data which can be stored in ourMySQL database and presented on thewebsite.


14/17

API CodeTwitter Search API Method: searchPage history last edited by Raffi Krikorian 2 mos ago


15/17

01.

02.

03. tag:search.twitter.com,2005:search/twitter

04.

05.

06. twitter - Twitter Search

07.

08.

09. adjusted since_id, it was older than allowedsince_id removed for pagination.

10. 2009-05-20T03:54:29Z

11. 15

12. en

13.

14.

15. tag:search.twitter.com,2005:1855677271

16. 2009-05-20T03:54:29Z

17.

18. Respond to tgis twitter with a challenge u want to see accomplished in the next video!

19.www.youtube.com/fitzner123

20. Respond to tgis twitter with a challenge u want to see accomplished in the next video!

21.

22.www.youtube.com/fitzner123

23. 2009-05-20T03:54:29Z

24.

25. TwitterFon

26. en

27.
http://base.google.com/ns/1.0http://a9.com/-/spec/opensearch/1.1/http://www.w3.org/2005/Atomhttp://api.twitter.com/http://api.twitter.com/http://search.twitter.com/search?q=twitterhttp://search.twitter.com/search?q=twitterhttp://search.twitter.com/search.atom?q=twitter&http://search.twitter.com/search.atom?q=twitter&http://search.twitter.com/opensearch.xmlhttp://search.twitter.com/opensearch.xmlhttp://search.twitter.com/search.atom?lang=en&http://search.twitter.com/search.atom?lang=en&http://twitter.com/nihongotako/statuses/1855677271http://www.youtube.com/fitzner123http://s3.amazonaws.com/twitter_production/profile_images/217800128/Photo_13_normal.jpghttp://twitterfon.net/http://twitterfon.net/http://s3.amazonaws.com/twitter_production/profile_images/217800128/Photo_13_normal.jpghttp://www.youtube.com/fitzner123http://twitter.com/nihongotako/statuses/1855677271http://search.twitter.com/search.atom?lang=en&http://search.twitter.com/search.atom?lang=en&http://search.twitter.com/opensearch.xmlhttp://search.twitter.com/search.atom?q=twitter&http://search.twitter.com/search?q=twitterhttp://api.twitter.com/http://www.w3.org/2005/Atomhttp://a9.com/-/spec/opensearch/1.1/http://base.google.com/ns/1.0


16/17


17/17

Learning PHPNot much left to say as far as learning goes.I have a Lynda DVD ;D

On target so far.

directed study: week 5 presentation

Documents