-
Notifications
You must be signed in to change notification settings - Fork 0
/
install.php
153 lines (117 loc) · 3.3 KB
/
install.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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Attempt create database query execution
$sql = "CREATE DATABASE Stibco";
if(mysqli_query($link, $sql)){
echo "Database Stibco created successfully";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "stibco");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Attempt create table query execution
$sql = "
CREATE TABLE btcedata(
id INT(4) NOT NULL PRIMARY KEY AUTO_INCREMENT,
btctime CHAR(30) NOT NULL,
btcprice CHAR(30) NOT NULL,
btcvolume CHAR(30) NOT NULL,
btcvolumec CHAR(30) NOT NULL,
btcbuy CHAR(30) NOT NULL,
btcsell CHAR(30) NOT NULL,
btclow CHAR(30) NOT NULL,
btchigh CHAR(30) NOT NULL,
btcopen CHAR(30) NOT NULL,
btcavg CHAR(30) NOT NULL
)
";
if (mysqli_query($link, $sql)){
echo "<br>"."Table btcedata created successfully";
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$sql = "
CREATE TABLE bitfinexdata(
id INT(4) NOT NULL PRIMARY KEY AUTO_INCREMENT,
btctime CHAR(30) NOT NULL,
btcprice CHAR(30) NOT NULL,
btcvolumec CHAR(30) NOT NULL,
btcbuy CHAR(30) NOT NULL,
btcsell CHAR(30) NOT NULL,
btclow CHAR(30) NOT NULL,
btchigh CHAR(30) NOT NULL,
btcopen CHAR(30) NOT NULL,
btcavg CHAR(30) NOT NULL
)
";
if (mysqli_query($link, $sql)){
echo "<br>"."Table bitfinexdata created successfully";
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$sql = "
CREATE TABLE btcstats(
id INT(4) NOT NULL PRIMARY KEY AUTO_INCREMENT,
btcmarkprice CHAR(30) NOT NULL,
btchashrate CHAR(30) NOT NULL,
btctotalfees CHAR(30) NOT NULL,
btcnmined CHAR(30) NOT NULL,
btcblocksmined CHAR(30) NOT NULL,
btctotalblocks CHAR(30) NOT NULL,
btctradevol CHAR(30) NOT NULL,
btctransvol CHAR(30) NOT NULL,
btcblocksize CHAR(30) NOT NULL,
btcminersrev CHAR(30) NOT NULL,
btcdifficulty CHAR(30) NOT NULL,
btctradevolbtc CHAR(30) NOT NULL,
minutesblocks CHAR(30) NOT NULL
)
";
if (mysqli_query($link, $sql)){
echo "<br>"."Table bitstats created successfully";
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$sql = "
CREATE TABLE btcfiat(
id INT(4) NOT NULL PRIMARY KEY AUTO_INCREMENT,
btcusd CHAR(30) NOT NULL,
btceur CHAR(30) NOT NULL,
btcgbp CHAR(30) NOT NULL,
btccad CHAR(30) NOT NULL,
btcchf CHAR(30) NOT NULL,
btccny CHAR(30) NOT NULL,
btcaud CHAR(30) NOT NULL,
btcsgd CHAR(30) NOT NULL,
btcjpy CHAR(30) NOT NULL,
btcnzd CHAR(30) NOT NULL,
btcrub CHAR(30) NOT NULL,
btctwd CHAR(30) NOT NULL,
btcsek CHAR(30) NOT NULL,
btcthb CHAR(30) NOT NULL,
btcpln CHAR(30) NOT NULL,
btcisk CHAR(30) NOT NULL,
btcavg24 CHAR(30) NOT NULL
)
";
if (mysqli_query($link, $sql)){
echo "<br>"."Table btcfiat created successfully";
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>