}); </script> <div class="clearfix"></div> </div> </div> </div> </div> </div> </div> <div class="container"> <section id="main"> <div class="content"> <div class="gallery">''' #Discover tab is to show all the tweet of all the users user = libw.getUser() cur = libw.sql_query("SELECT * from `tweets` ORDER BY timestamp DESC") for row in cur.fetchall(): print ''' <div class="twit t-wit"> <span class="line"></span> <i class="twit-icon"></i> <span class="line"></span> <div style="text-align: right;color:#fff">''' print str(row[3]) + '</div><p>' #timestamp print row[2] #tweet print "</p><small><a href='profile.py?q=" + str(row[1]) + "'>@" + str( row[1]) + "</a></small></div>" print ''' </div> </div>
}); }); </script> <div class="clearfix"></div> </div> </div> </div> </div> </div> </div> <div class="container"> <section id="main"> <div class="content"> <div class="gallery">''' #printing the tweets of all the following users in decreasing order of timestamp by inner joining three tables users, follows and tweets cur = libw.sql_query('select Distinct f.user, u.user, t.tweet, t.timestamp from users inner join follows f on (f.user = "******") inner join users u on (u.user= f.follow) inner join tweets t on (t.user = f.follow) ORDER BY t.timestamp DESC') for row in cur.fetchall(): print ''' <div class="twit t-wit"> <span class="line"></span> <i class="twit-icon"></i> <span class="line"></span> <div style="text-align: right;color:#fff">''' print str(row[3])+'</div><p>' #timestamp print row[2]#tweet print "</p><small><a href='profile.py?q="+str(row[1])+"'>@"+str(row[1])+"</a></small></div>" #following user print ''' </div> </div> </section> </div>
cgitb.enable() form = cgi.FieldStorage() ret = libw.auth_cookie() print "Content-type: text/html\n\n" #follow and unFollow a person if ret == 0: print '<meta http-equiv="refresh" content="0;url=http://localhost" />' else: if ("a" in form) and ("q" in form): q = cgi.escape(form["q"].value) if cgi.escape(form["a"].value) == "unfollow": query = "delete from `follows` where `user`='" + str( libw.getUser()) + "' and `follow` = '" + str(q) + "'" cur = libw.sql_query(query) print '<meta http-equiv="refresh" content="0;url=profile.py?q=' + str( q) + '" />' else: query = "insert into `follows` (`user`, `follow`) values ('" + str( libw.getUser()) + "','" + str(q) + "')" cur = libw.sql_query(query) print '<meta http-equiv="refresh" content="0;url=profile.py?q=' + str( q) + '" />' elif ("q" in form): q = cgi.escape(form["q"].value) query = "insert into `follows` (`user`, `follow`) values ('" + str( libw.getUser()) + "','" + str(q) + "')" cur = libw.sql_query(query) print '<meta http-equiv="refresh" content="0;url=profile.py?q=' + str(
#!/usr/bin/env python import cgi import sys import cgitb #import libw from one dir back sys.path.insert(0, '../') import lib_web as libw cgitb.enable() # adding tweet into the tweets table form = cgi.FieldStorage() print "Content-type: text/html\n\n" ret = libw.auth_cookie() if ret == 1: if ("q" not in form): print 'Failed to update status' else: cur = libw.sql_query( 'insert into `tweets` (`user`, `tweet`) values ("' + str(libw.getUser()) + '","' + str(cgi.escape(form["q"].value)) + '")') else: print 'Failed to update status'
#!/usr/bin/env python import sys import cgitb, cgi #import libw from one dir back sys.path.insert(0, '../') import lib_web as libw cgitb.enable() form=cgi.FieldStorage() if ("q" in form): user = cgi.escape(form["q"].value) else: user = libw.getUser() user = user.lower() ret = libw.auth_cookie() print "Content-type: text/html\n\n" if ret == 0: print '<meta http-equiv="refresh" content="0;url=http://localhost" />' else: print ''' <!DOCTYPE HTML> <html> <head> <title>Twitter Clone Profile</title> <link href="css/bootstrap.css" rel='stylesheet' type='text/css' media="all" /> <script src="js/jquery-1.11.0.min.js"></script>
</script> <div class="clearfix"></div> </div> </div> </div> </div> </div> </div> <div class="container"> <section id="main"> <div class="content"> <div class="gallery"> <p>''' #showing all the following users of the login user into boxes and you can click on the user handle to open his/her profile cur = libw.sql_query('select Distinct f.user, u.user from users inner join follows f on (f.user = "******") inner join users u on (u.user= f.follow)') for row in cur.fetchall(): print ''' <div class="twit t-wit-follows"> <span class="line"></span> <i class="twit-icon"></i> <span class="line"></span> <div style="text-align: right;color:#fff">''''</div><p>' print "</p><small><a href='profile.py?q="+str(row[1])+"'>@"+str(row[1])+"</a></small></div>" print ''' </div> </div> </section> </div> </body>