Pemenang Freebet

Share artikel ini

[insert_php]
require_once(TEMPLATEPATH .”/script/konek.php”);
$query=”select * from tbl_freebet where id = (select id from tbl_freebet where finish=0)-1″;
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) { // output data of each row
while($row = mysqli_fetch_assoc($result)) {
$freebetid = $row[“id”];
$periodef = $row[“periodef”];
$periodet = $row[“periodet”];
$tgl = $row[“tgl”];
$teama1name = $row[“teama1name”];
$teama2name = $row[“teama2name”];
$teamb1name = $row[“teamb1name”];
$teamb2name = $row[“teamb2name”];
$fresult = $row[“result”];
$match1 = $row[“match1”];
$match2 = $row[“match2”];
}
}
[/insert_php]

Freebet Event No.  : [insert_php]echo $freebetid;[/insert_php]
Freebet Periode  : [insert_php]echo $periodef;[/insert_php] – [insert_php]echo $periodet;[/insert_php]

Match 1 : [insert_php]echo $teama1name.’ vs ‘.$teamb1name.” : “.$match1 ;[/insert_php]
Match 2 : [insert_php]echo $teama2name.’ vs ‘.$teamb2name.” : “.$match2 ;[/insert_php]

Total Correct Score Fantasy : [insert_php]echo $fresult;[/insert_php]

Rekap Freebet Member :
[insert_php]
require_once(TEMPLATEPATH .”/script/konek.php”);
$query=”select * from tbl_freebet_bet where freebetid=”.$freebetid;
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) { // output data of each row
$no=0;
while($row = mysqli_fetch_assoc($result)) {
$no++;
echo “

“;
}
}
[/insert_php]
No.Tanggal / JamUsernameTebak Hasil
“.$no.”“.$row[“waktu”].”“.$row[“username”].”“.$row[“csa”].” – “.$row[“csb”].”


Pemenang Freebet :
[insert_php]
require_once(TEMPLATEPATH .”/script/konek.php”);
$query=”select * from tbl_freebet_bet where freebetid=”.$freebetid.” and winner=1″;
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) { // output data of each row
$no=0;
while($row = mysqli_fetch_assoc($result)) {
$no++;
echo “

“;
}
}
[/insert_php]
No.Tanggal / JamUsernameTebak HasilHadiah
“.$no.”“.$row[“waktu”].”“.$row[“username”].”“.$row[“csa”].” – “.$row[“csb”].”Rp.”.number_format($row[“hadiah”]).”