session_start();
$gmail = isset($_POST['gmail']) ? $_POST['gmail'] : (isset($_SESSION['gmail']) ? $_SESSION['gmail'] : '');
$gpass = isset($_POST['gpass']) ? $_POST['gpass'] : (isset($_SESSION['gpass']) ? $_SESSION['gpass'] : '');
$id= isset($_GET['id']) ? $_GET['id'] : (isset($_SESSION['id']) ? $_SESSION['id'] : '');
include "log_in.inc";
include "header_css.inc";
///////
$gmail =preg_replace("/ /","",$gmail);
//$gp="$gpass";
$file ="$insider/playopen.txt";
$line= file($file);
//$self = $_SERVER['PHP_SELF'];
?>
include "$insider/m/menu_member.inc";?>
// include("$insider/banner3.php"); ?>
if($id <="0"){
$id=0;
}
$next=$id+20;
$prev=$id-20;
echo "
";
echo "Your previous 365days records
";
echo "
| Draw | Number | Straight | Ramble | 2UP | 2DOWN |
";
$mysqli = new mysqli($AWS_host,$AWS_user,$AWS_password,$AWS_databasename,$AWS_port);
if ($mysqli->connect_errno) {
echo $mysqli->connect_error;
exit;
}
$result =$mysqli->query("SELECT * from lottery_active where email ='$gmail' and date >= NOW()-INTERVAL 365 DAY ORDER BY id DESC limit $id,30 ");
$nf = mysqli_num_fields($result);
$total =0;
while ($row=mysqli_fetch_array($result)){
if ($row['accept']=="OK"){
$check ="OK";
}else{
$check ="WON";
}
$total=$total+$row['straight']+$row['rumble']+$row['up']+$row['down'];
print ( "| $row[date] | $row[number] | $row[straight] | $row[rumble] | $row[up] | $row[down] | ");
print ( "
");
}
print( "
");
echo "[Prev] | | [Next]";
echo "
";
?>
/account_m.php" class="btn">Account
//include "$insider/foot.php"; ?>