Вывод информации MySql в PHP.

Ferz666 · 9 Фев 2016

В общем весь день сегодня убил чтобы вывести информацию в php.
Прописал коннект к базе, выдергиваю из нее нужное:

PHP:

$BTC = json_decode(file_get_contents('https://btc-e.nz/api/3/ticker/btc_usd')); // - Это API
$BTC = $BTC->btc_usd->last; // - Это API

$C_I2 = mysqli_fetch_row(mysqli_query($CONNECT, 'SELECT COUNT(`id`) FROM `users`'));

$C_I3 = mysqli_fetch_row(mysqli_query($CONNECT, 'SELECT COUNT(`id`) FROM `users` WHERE `date` >= CURDATE()'));

Далее вставляю это туда, где мне бы хотелось это выводить:

PHP:

function Head($p1) {
if ($_SESSION['LOGIN_IN'] == 1) $DRAW = '<center>Send Bitcoins to: <b>'.$_SESSION['PAY'].'</b> (Min - <span class="affiliate">0.001 BTC</span>, max - <span class="affiliate">unlimited</span>) <center>';
else $DRAW = '<form action="/" method="post"><input type="text" class="wallet" pattern="[A-Za-z-0-9]{34,34}" title="34 characters" maxlength="34" name="wallet" placeholder="Enter your Bitcoin address" required><input type="submit" name="enter" value="DOUBLE BITCOINS"></form>';
echo '<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
<title>'.$p1.'</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="/resource/style/style.css" rel="stylesheet">
<link rel="icon" href="/resource/img/favicon.ico" type="image/x-icon">
<script type="text/javascript" src="/resource/jquery.min.js"></script>
</head>

<body>
<div class="wrapper">
<div class="header"><a class="Bar" href="/support">Support</a><a class="Bar" href="/faq">FAQ</a><a class="Bar" href="/terms">Terms</a><a class="Bar" href="/affiliate">Affiliate Program <span class="affiliate">'.REWARD.'%</span></a><a href="/"><div class="logo"></div></a></div>



<div class="content1"><div class="Start">
<div class="paid">


'.$DRAW.'

<br> Всего пользователей: <span>'.$C_I2[0].'</span>
Новых сегодня: <span>'.$C_I3[0].'</span>
Текущий курс BTC: <span>$ '.$BTC.'</span>
Paid deposits: <span>'.($C_I5 * 2).'</span> (<span> $ '.round(($C_I5 * 2) * $BTC, 2).' </span>)
Deposits payable: <span>'.($C_I6 * 2).'</span> (<span> $ '.round(($C_I6 * 2) * $BTC, 2).' </span>)
</div></div></div>';
}

Но ничего не показывает, просто пустое место.
Я с работой PHP и MySql пока совсем не соображаю, надеюсь вы поможете

Собственно весь код PHP:

PHP:

<?php

include_once 'setting.php';
session_start();

$CONNECT = mysqli_connect(HOST, USER, PASS, DB);





$BTC = json_decode(file_get_contents('https://btc-e.nz/api/3/ticker/btc_usd'));
$BTC = $BTC->btc_usd->last;

$C_I1 = mysqli_fetch_row(mysqli_query($CONNECT, 'SELECT COUNT(`id`) FROM `support`'));
$C_I2 = mysqli_fetch_row(mysqli_query($CONNECT, 'SELECT COUNT(`id`) FROM `users`'));

$C_I3 = mysqli_fetch_row(mysqli_query($CONNECT, 'SELECT COUNT(`id`) FROM `users` WHERE `date` >= CURDATE()'));
$C_I4 = mysqli_fetch_row(mysqli_query($CONNECT, "SELECT COUNT(`id`) FROM `users` WHERE `ref` != '0'"));



















if (!$_COOKIE['UNIQID']) setcookie('UNIQID', uniqid(), strtotime('+90 days'), '/');
if (!$_SESSION['USER_ANTIBOT']) $_SESSION['USER_ANTIBOT'] = date('Y-m-d H:i:s');

if ($_COOKIE['UNIQID'] and $_SESSION['LOGIN_IN'] == 0) {
$Row = mysqli_fetch_assoc(mysqli_query($CONNECT, "SELECT `adr`, `wallet` FROM `users` WHERE `uid` = '$_COOKIE[UNIQID]'"));
if (!$Row['adr'] or !$Row['wallet']) $_SESSION['LOGIN_IN'] = -1;
else {
$_SESSION['WALLET'] = $Row['wallet'];
$_SESSION['PAY'] = $Row['adr'];
$_SESSION['LOGIN_IN'] = 1;
}
}



if ($_SERVER['REQUEST_URI'] == '/') {
$Page = '/';
$Module = '/';
} else {
$URL_Path = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH);
$URL_Parts = explode('/', trim($URL_Path, ' /'));
$Page = array_shift($URL_Parts);
$Module = array_shift($URL_Parts);
}

if ($Page == 'ref' and $Module and !$_COOKIE['REF'] and $_COOKIE['UNIQID'] != $Module) {
setcookie('REF', $Module, strtotime('+90 days'), '/');
Location();
}

if ($Page != 'deposit' and !$_SESSION['DOS']) exit(include 'resource/page/dos.php');

if ($Page == '/' and $Module == '/' or $Page == 'ref' and $Module or $Page == 'all' or $Page == 'my' or $Page == 'payouts') include 'resource/page/home.php';
else if ($Page == 'affiliate') include 'resource/page/affiliate.php';
else if ($Page == 'faq') include 'resource/page/faq.php';
else if ($Page == 'terms') include 'resource/page/terms.php';
else if ($Page == 'support') include 'resource/page/support.php';
else if ($Page == 'deposit') include 'resource/page/deposit.php';
else if ($Page == 'loader') include 'resource/page/loader.php';
else if ($Page == 'admin' and $Module == ADMIN_KEY) include 'resource/page/admin.php';
else Message(1, 'Page not found.');

function Form($p1) {
return nl2br(htmlspecialchars(trim($p1), ENT_QUOTES), false);
}


function Secret($p1) {
return md5('SECRET'.md5(md5('KEY').$p1.md5('FOR')).'1'.md5('2').'3'.md5($p1 + 'PAY').'BTC');
}


function MKT($p1) {
$exp1 = explode(' ', $p1);
$D = explode('-', $exp1[0]);
$H = explode(':', $exp1[1]);
return mktime($H[0], $H[1], $H[2], $D[1], $D[2], $D[0]);
}


function TSP($p1, $p2) {
$razniza = ($p2 - $p1);
$razniza_2 = ($razniza / 60);
$Hour = floor($razniza_2 / 60);
$Minute = ($razniza_2 % 60);
$Second = ($razniza % 60);
if ($Hour <= 0 and $Minute <= 0 and $Second<=  0) return '<td><span class="st0">PENDING</span></td>';
if (strlen($Hour) == 1) $Hour  = '0'.$Hour;
if (strlen($Minute) == 1) $Minute  = '0'.$Minute;
if (strlen($Second) == 1) $Second = '0'.$Second;
return '<td class="countdown">'.$Hour.':'.$Minute.':'.$Second.'</td>';
}


function JQMessageShow() {
if ($_SESSION['MESSAGE']) {
$Message = explode('|', $_SESSION['MESSAGE']);
echo '<script>$(document).ready(function(){ModalOpen()}); function ModalOpen() {$("#window").fadeIn(500).delay(3000).fadeOut(500)}</script><div class="Message" id="window"><span class="Type'.$Message[0].'">'.$Message[1].'</span></div>';
}
$_SESSION['MESSAGE'] = array();
}


function Message($p1, $p2, $p3 = '') {
$_SESSION['MESSAGE'] = $p1.'|'.$p2;
if (!$p3) Location();
else exit(header('Location: '.$p3));
}


function Location() {
exit(header('Location: /'));
}


function Status($p1) {
if (!$p1) return '<span class="st0">PENDING</span>';
else return '<span class="st1">PAID</span>';
}


function AntiBot() {
$Date = date('Y-m-d H:i:s');
if (strtotime($Date) < strtotime($_SESSION['USER_ANTIBOT'])) Message(1, 'Limit exceeded activity. Please wait '.TIMEOUT.' seconds and try again.');
else $_SESSION['USER_ANTIBOT'] = date('Y-m-d H:i:s', strtotime('+'.TIMEOUT.' seconds'));
}


function ValidateBTC($address){
$decoded = decodeBase58($address);
$d1 = hash("sha256", substr($decoded,0,21), true);
$d2 = hash("sha256", $d1, true);
if(substr_compare($decoded, $d2, 21, 4)) Message(1, 'Invalid bitcoin waller adress.');
return true;
}


function decodeBase58($input) {
$alphabet = "123456789ABCDEFGHJKLMNPQRSTUVWXYZabcdefghijkmnopqrstuvwxyz";
$out = array_fill(0, 25, 0);
for($i=0;$i<strlen($input);$i++){
if(($p=strpos($alphabet, $input[$i])) === false)Message(1, 'Invalid bitcoin waller adress.');
$c = $p;
for ($j = 25; $j--; ) {
$c += (int)(58 * $out[$j]);
$out[$j] = (int)($c % 256);
$c /= 256;
$c = (int)$c;
}
if($c != 0) Message(1, 'Invalid bitcoin waller adress.');
}
$result = "";
foreach($out as $val) $result .= chr($val);
return $result;
}

function Head($p1) {
if ($_SESSION['LOGIN_IN'] == 1) $DRAW = '<center>Send Bitcoins to: <b>'.$_SESSION['PAY'].'</b> (Min - <span class="affiliate">0.001 BTC</span>, max - <span class="affiliate">unlimited</span>) <center>';
else $DRAW = '<form action="/" method="post"><input type="text" class="wallet" pattern="[A-Za-z-0-9]{34,34}" title="34 characters" maxlength="34" name="wallet" placeholder="Enter your Bitcoin address" required><input type="submit" name="enter" value="DOUBLE BITCOINS"></form>';
echo '<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
<title>'.$p1.'</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="/resource/style/style.css" rel="stylesheet">
<link rel="icon" href="/resource/img/favicon.ico" type="image/x-icon">
<script type="text/javascript" src="/resource/jquery.min.js"></script>
</head>

<body>
<div class="wrapper">
<div class="header"><a class="Bar" href="/support">Support</a><a class="Bar" href="/faq">FAQ</a><a class="Bar" href="/terms">Terms</a><a class="Bar" href="/affiliate">Affiliate Program <span class="affiliate">'.REWARD.'%</span></a><a href="/"><div class="logo"></div></a></div>



<div class="content1"><div class="Start">
<div class="paid">


'.$DRAW.'

<br> Всего пользователей: <span>'.$C_I2[0].'</span>
Новых сегодня: <span>'.$C_I3[0].'</span>
Текущий курс BTC: <span>$ '.$BTC.'</span>
Paid deposits: <span>'.($C_I5 * 2).'</span> (<span> $ '.round(($C_I5 * 2) * $BTC, 2).' </span>)
Deposits payable: <span>'.($C_I6 * 2).'</span> (<span> $ '.round(($C_I6 * 2) * $BTC, 2).' </span>)
</div></div></div>';
}
?>

AmdY · 9 Фев 2016

http://phpfaq.ru/debug

Вывод информации MySql в PHP.

Ferz666

Новичок

AmdY

Пью пиво