Проблем с include

pro12 · 13 Март 2015

PHP:

 <?php
/*
Text Counter by http://www.free-php-counter.com
You are allowed to remove advertising after you purchased a licence
*/

// settings

// ip-protection in seconds
$counter_expire = 600;

// ignore agent list
$counter_ignore_agents = array('bot', 'bot1', 'bot3');

// ignore ip list
$counter_ignore_ips = array('127.0.0.2', '127.0.0.3');


// datebase settings
$counter_host =  "mysql:host=sql.hostinger.co.uk";
$counter_user = "min";
$counter_password = "o321";
$counter_database = "9_admin";

// get basic information
$counter_agent = $_SERVER['HTTP_USER_AGENT'];
$counter_ip = $_SERVER['REMOTE_ADDR']; 
$counter_time = time();



// connect to database
$counter_connected = true;
$link = mysqli_connect($counter_host, $counter_user, $counter_password, $counter_database);
if (!$link) 
{
 	// can't connect to database
	$counter_connected = false;
	die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
	exit;
}

if ($counter_connected == true) 
{
   $ignore = false; 
   
   // get counter information
   $sql = "SELECT * FROM counter_values LIMIT 1";
   $res = mysqli_query($link, $sql);
   
   // fill when empty
   if (mysqli_num_rows($res) == 0)
   {	  
	  $sql = "INSERT INTO `counter_values` (`id`, `day_id`, `day_value`, `yesterday_id`, `yesterday_value`, `week_id`, `week_value`, `month_id`, `month_value`, `year_id`, `year_value`, `all_value`, `record_date`, `record_value`) VALUES ('1', '" . date("z") . "',  '1', '" . (date("z")-1) . "',  '0', '" . date("W") . "', '1', '" . date("n") . "', '1', '" . date("Y") . "',  '1',  '1',  NOW(),  '1')";
	  mysqli_query($link, $sql);

	  // reload with settings
	  $sql = "SELECT * FROM counter_values LIMIT 1";
      $res = mysqli_query($link, $sql);
	  
	  $ignore = true;
   }   
   $row = mysqli_fetch_assoc($res);
   
   $day_id = $row['day_id'];
   $day_value = $row['day_value'];
   $yesterday_id = $row['yesterday_id'];
   $yesterday_value = $row['yesterday_value'];
   $week_id = $row['week_id'];
   $week_value = $row['week_value'];
   $month_id = $row['month_id'];
   $month_value = $row['month_value'];
   $year_id = $row['year_id'];
   $year_value = $row['year_value'];
   $all_value = $row['all_value'];
   $record_date = $row['record_date'];
   $record_value = $row['record_value'];
   
   
   // check ignore lists
   $length = sizeof($counter_ignore_agents);
   for ($i = 0; $i < $length; $i++)
   {
	  if (substr_count($counter_agent, strtolower($counter_ignore_agents[$i])))
	  {
	     $ignore = true;
		 break;
	  }
   }
   
   $length = sizeof($counter_ignore_ips);
   for ($i = 0; $i < $length; $i++)
   {
	  if ($counter_ip == $counter_ignore_ips[$i])
	  {
	     $ignore = true;
		 break;
	  }
   }
   
      
   // delete free ips
   if ($ignore == false)
   {
      $sql = "DELETE FROM counter_ips WHERE unix_timestamp(NOW())-unix_timestamp(visit) >= $counter_expire"; 
      mysqli_query($link, $sql);	  
   }
      
   // check for entry
   if ($ignore == false)
   {
      $sql = "update counter_ips set visit = NOW() where ip = '$counter_ip'";
	  mysqli_query($link, $sql);
	  
	  if (mysqli_affected_rows($link) > 0)
	  {
		 $ignore = true;						   		 
	  }
	  else
	  {
		 // insert ip
	     $sql = "INSERT INTO counter_ips (ip, visit) VALUES ('$counter_ip', NOW())";
   	     mysqli_query($link, $sql); 
	  }	  	  
   }
   
   // online?
   $sql = "SELECT * FROM counter_ips";
   $res = mysqli_query($link, $sql);
   $online = mysqli_num_rows($res);
      
   // add counter
   if ($ignore == false)
   {     	  
      // yesterday
	  if ($day_id == (date("z")-1)) 
	  {
	     $yesterday_value = $day_value; 
	  }
	  else
	  {
	     if ($yesterday_id != (date("z")-1))
		 {
		    $yesterday_value = 0; 
		 }
	  }
	  $yesterday_id = (date("z")-1);
	  
	  // day
	  if ($day_id == date("z")) 
	  {
	     $day_value++; 
	  }
	  else 
	  {
	     $day_value = 1;
		 $day_id = date("z");
	  }
	  
	  // week
	  if ($week_id == date("W")) 
	  {
	     $week_value++; 
	  }
	  else 
	  { 
	     $week_value = 1;
		 $week_id = date("W");
      }
	  
      // month
	  if ($month_id == date("n")) 
	  {
	     $month_value++; 
	  }
	  else 
	  {
	     $month_value = 1;
		 $month_id = date("n");
      }
	  
	  // year
	  if ($year_id == date("Y")) 
	  {
	     $year_value++; 
	  }
	  else 
	  {
	     $year_value = 1;
		 $year_id = date("Y");
      }
	  
	  // all
	  $all_value++;
		 
	  // neuer record?
	  if ($day_value > $record_value)
	  {
	     $record_value = $day_value;
	     $record_date = date("Y-m-d H:i:s");
	  }
		 
	  // speichern und aufräumen
	  $sql = "UPDATE counter_values SET day_id = '$day_id', day_value = '$day_value', yesterday_id = '$yesterday_id', yesterday_value = '$yesterday_value', week_id = '$week_id', week_value = '$week_value', month_id = '$month_id', month_value = '$month_value', year_id = '$year_id', year_value = '$year_value', all_value = '$all_value', record_date = '$record_date', record_value = '$record_value' WHERE id = 1";
	  mysqli_query($link, $sql);  	  
   }	  
	  	
?>
<?php
}
?>

Дава това

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'mysql:host=sql.hostinger.co.uk' (-3) in /home/u873363251/public_html/admin/statistic/counter.php on line 34
Connect Error (2005) Unknown MySQL server host 'mysql:host=sql.hostinger.co.uk' (-3)
Как да оправя проблема?

uphero · 13 Март 2015

Създай база данни и потребител към нея и попълни полетата за връзка.

stoqnski · 14 Март 2015

// datebase settings
$counter_host = "sql.hostinger.co.uk";
$counter_user = "min";
$counter_password = "o321";
$counter_database = "9_admin";

пробвай така

pro12 · 14 Март 2015

Пак нищо не стана.
Смених брояча с др но имам пробблем с извеждането ето кода

PHP:

  <?php 
ob_start(); 
include("conf.php"); 

$ip=$_SERVER["REMOTE_ADDR"]; 
$time=time(); 
$dnes=0; 
$v4era=0; 
$last6=0; 
$sred_dnevno=0; 
$rekord_date=time(); 
$den_na4=mktime(0,0,0,date('m'),date('d'),date('Y')); 
$den_krai=mktime(0,0,0,date('m'),date('d')+1,date('Y')); 
$v4era_na4=mktime(0,0,0,date('m'),date('d')-1,date('Y')); 
$before6=mktime(0,0,0,date('m'),date('d')-6,date('Y')); 

$query2="select * from poseten where timestamp>=$v4era_na4 and timestamp<$den_krai"; 
$result2=mysqli_query($conn, $query2); 

while($row=mysqli_fetch_array($result2)) 

{ 

if($row["timestamp"]<$den_na4) 
{ 
$v4era++; 
} 

else 
{ 
$dnes++; 
} 

} 



$query3="select count(distinct ip) from poseten where timestamp>=$before6 and timestamp<$den_na4"; 
$result3=mysqli_query($conn, $query3); 
$broi=mysqli_num_rows($result3); 

if($broi>0) 
{ 
list($last6)=mysqli_fetch_array($result3); 
} 



$query4="select * from poseten where timestamp>=$before6 and timestamp<$den_na4"; 
$result4=mysqli_query($conn, $query4); 
$sred_dnevno=substr(mysqli_num_rows($result4)/6,0,4); 


for($i=-1;$i<6;$i++) 

{ 

$a[$i+1]=array(); 

$na4=mktime(0,0,0,date('m'),date('d')-($i+1),date('Y')); 
$krai=mktime(0,0,0,date('m'),date('d')-$i,date('Y')); 

$query5="select ip,timestamp from poseten where timestamp>=$na4 and timestamp<$krai"; 
$result5=mysqli_query($conn, $query5); 

$a[$i+1][0]=mysqli_num_rows($result5); 

if($a[$i+1][0]>0) 
{ 
$tek_time=mysqli_result($result5,0,'timestamp'); 
$a[$i+1][1]=date("j F Y",$tek_time); 
} 

else 

{ 
$a[$i+1][1]=0; 
} 

} 

$rekord_mas=max($a[0],$a[1],$a[2],$a[3],$a[4],$a[5],$a[6]); 
$rekord=$rekord_mas[0]; 
$rekord_date=$rekord_mas[1]; 

if($rekord==$a[0][0]) 
{ 
$rekord_date=$rekord_date."(днес)"; 
} 


echo "<font color='red' size='4'>Уникални посещения днес:$dnes<br>Уникални посещения вчера:$v4era<br>"; 
echo "Общо уникални посещения за последните 6 дни(без днешния):$last6<br>"; 
echo "Уникални посещения средно на ден през последните 6 дни(без днешния): $sred_dnevno<br>Рекорд за последната седмица: ".$rekord." уникални посещения на ".$rekord_date."</font>"; 

?> 
  Дава това 
Fatal error: Call to undefined function mysqli_result() in /home/u873363251/public_html/admin/statistics.php on line 70
Незнам ккакво не е ннаред. Как да оправя проблема?

uphero · 14 Март 2015

Първо кажи точно какво искаш да направиш, че кодовете които вадиш са пълен боклук.

pro12 · 14 Март 2015

Трябва ми брояч с база дани който да е с два фаила за да може извеждат даните в админ панелла.

Проблем с include

pro12

Registered

uphero

Registered

stoqnski

Registered

pro12

Registered

uphero

Registered

pro12

Registered