-
Notifications
You must be signed in to change notification settings - Fork 0
/
levelLoad4.php
33 lines (26 loc) · 1002 Bytes
/
levelLoad4.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
<?php
$dbhost = 'us-cdbr-iron-east-01.cleardb.net';
$dbuser = 'bfee5fabd369bb';
$dbpass = 'd131311b';
$dbdata = "heroku_3c0e2eb533d6f40";
$one7="SELECT * FROM 1_7x7";
$two7="SELECT * FROM 2_7x7";
$three7="SELECT * FROM 3_7x7";
$one13="SELECT * FROM 1_13x13";
$two13="SELECT * FROM 2_13x13";
$three13="SELECT * FROM 3_13x13";
$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbdata);//connect
//if(! $conn ) die('Could not connect: \n' . mysqli_error()); //else echo 'Connected successfully <br>';
$retval = mysqli_query( $conn, $one13 );
$data = array();
//$data=mysqli_fetch_array($retval);//json_encode ($retval);
//$data=mysqli_fetch_assoc($retval);//json_encode ($retval);
while($row=mysqli_fetch_assoc($retval)) {
$data[] = $row;
}
$tmp = json_encode($data);
//echo $tmp . "<br>";
echo $tmp;
/*if($retval) echo("query success <br>"); else echo 'query failed';*/
mysqli_close($conn);
?>