forked from iSimar/Twitter-Like-System-PHP
-
Notifications
You must be signed in to change notification settings - Fork 0
/
hashtag.php
84 lines (82 loc) · 2.88 KB
/
hashtag.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php
session_start();
$user_id = $_SESSION['user_id'];
?>
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=425px, user-scalable=no">
<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">
<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap-theme.min.css">
<link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
<script src="//netdna.bootstrapcdn.com/bootstrap/3.1.1/js/bootstrap.min.js"></script>
<title>Twitter-like-system-PHP</title>
</head>
<body style="margin-left:20px;width:300px;zoom:125%;">
<h3>Twitter-Like-System-PHP</h3>
<a href='..'>Go Home</a>
<?php
function getTime($t_time){
$pt = time() - $t_time;
if ($pt>=86400)
$p = date("F j, Y",$t_time);
elseif ($pt>=3600)
$p = (floor($pt/3600))."h";
elseif ($pt>=60)
$p = (floor($pt/60))."m";
else
$p = $pt."s";
return $p;
}
if(!$user_id){
echo "<a href='../register.php' class='btn btn-info btn-xs' style='float:right;'>Signup</a>";
}
if($_GET['hashtag']!=""){
$hashtag = $_GET['hashtag'];
echo "<div style='font-size:20px;'>Tweets with <a>#".$hashtag."</a></div>";
include "connect.php";
$tweets = mysql_query("SELECT username, tweet, timestamp
FROM tweets
WHERE tweet REGEXP '^#$hashtag' OR tweet REGEXP ' #$hashtag'
ORDER BY timestamp DESC
LIMIT 0, 10
");
if(mysql_num_rows($tweets)>0){
while($tweet = mysql_fetch_array($tweets)){
echo "<div class='well well-sm' style='padding-top:4px;padding-bottom:8px; margin-bottom:8px; overflow:hidden;'>";
echo "<div style='font-size:10px;float:right;'>".getTime($tweet['timestamp'])."</div>";
echo "<table>";
echo "<tr>";
echo "<td valign=top style='padding-top:4px;'>";
echo "<img src='../default.jpg' style='width:35px;'alt='display picture'/>";
echo "</td>";;
echo "<td style='padding-left:5px;word-wrap: break-word;' valign=top>";
echo "<a style='font-size:12px;' href='../".$tweet['username']."'>@".$tweet['username']."</a>";
$new_tweet = preg_replace('/@(\\w+)/','<a href=../$1>$0</a>',$tweet['tweet']);
$new_tweet = preg_replace('/#(\\w+)/','<a href=./$1>$0</a>',$new_tweet);
echo "<div style='font-size:10px; margin-top:-3px;'>".$new_tweet."</div>";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</div>";
}
}
else{
echo "<h5><i>No tweets found.</i><br> Be the first one to use <a href='..'>#$hashtag</a></h5>";
}
mysql_close($conn);
}
else{
echo "<div class='alert alert-danger'>Sorry, invalid hashtag.</div>";
echo "<a href='.' style='width:300px;' class='btn btn-info'>Go Home</a>";
}
?>
<br>
<div class="jumbotron" style="padding:3px;">
<div class="container">
<h5>Made by <a href="http://simarsingh.com">Simar</a></h5>
<h5>This is Open Source - Fork it on <i class="fa fa-github"></i> <a href="https://github.com/iSimar/Twitter-Like-System-PHP">GitHub</a></h5>
</div>
</div>
</body>
</html>