-
Notifications
You must be signed in to change notification settings - Fork 1
/
performanceAggregate.php
49 lines (32 loc) · 1.01 KB
/
performanceAggregate.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
<?php
//echo 'HELLOOOO';
include('config.php');
include('model.php');
if (isset($_GET['stock']) && isset($_GET['year']) && isset($_GET['website'])){
$symbol = $_GET['stock'];
$year = $_GET['year'];
$website = $_GET['website'];
$tableName = $symbol.$year.$website;
echo $symbol. " ". $year. " ". $website;
/* $search = ".";
$replace = "_";
$tableName = str_replace($search, $replace, $tableName);
$maxPage = 1000;
getAllPerformances($symbol, $year, $website, $tableName, $maxPage);
$queryString = "SELECT * FROM ".$tableName." ";
$query = mysql_query($queryString, $localDB);
if(!$query) die(mysql_error()."\n");
while($result = mysql_fetch_array($query)) {
echo $result['symbol'].", ";
echo $result['url'].", ";
echo $result['date'].", ";
echo $result['direction'].", ";
echo $result['1d'].", ";
echo $result['5d'].", ";
echo $result['30d'].", ";
echo $result['365d']."<br />";
}
*/
}
//echo "HELLOOOO2";
?>