-
Notifications
You must be signed in to change notification settings - Fork 0
/
page.php
44 lines (36 loc) · 1.23 KB
/
page.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
<html>
<head>
<style>
tr:nth-of-type(odd) {
background-color:#F0FFFF;
}
tr:nth-of-type(even) {
background-color:#87CEFA;
}
</style>
</head>
<body>
<table class="alternate_color">
<?php
include('db.php');
//$conn = db_connect_scraper_100();
//$conn1 = db_connect_100();
$today = date('Y-m-d');
// $query1 = "SELECT `title`, `url`, `key_url` FROM `scraper`.`feed` WHERE `date` = '".$today."' AND `title` LIKE '%trump%';";
//echo "<a href='http://feeds.blue/topsearchword.php?search=google'>Try our search!</a><br>";
echo "<a href='http://feeds.blue/searchword.php?search=trump&date=".$today."'>RSS Feed Date Search</a><br>";
echo "<a href='http://feeds.blue/searchworddate.php?search=gene&date=2016-12-25&date1=2016-12-18'>RSS Feed Date RANGE Search</a><br>";
/*
if ($stmt1 = mysqli_prepare($conn1, $query1)) {
mysqli_stmt_execute($stmt1);
mysqli_stmt_bind_result($stmt1, $title, $fetch, $key);
while (mysqli_stmt_fetch($stmt1)) {
echo "<tr><td>".$title."</td>";
echo "<td><a href='".$fetch."'>a</a></td>";
echo "<td><a href='".$key."'>a</a></td></tr>
";
}
mysqli_stmt_close($stmt1);
}
*/
?>