|
 |
|
สอบถามเรื่อง Counter PHP ทำไมถึงบันทึกข้อมูลลงในตารางไม่ได้คะ |
|
 |
|
|
 |
 |
|
Code (PHP)
<?php
include("connect/connect_db.php");
$date =date("d-m-Y");
$ip = $_SERVER['REMOTE_ADDR'];
$sql="INSERT INTO counter(date_visit,ip_visit,visit)VALUES
('$date', '$ip', '1')";
mysql_query($sql);
/*----------------------OPEN PAGE----------------------*/
$today = date('d-m-Y');
$sql="Select count(ip_visit) as visit From counter" ;
$result= mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$id_visit = $row[id_vist];
$openpage = str_pad($visit,6,0,str_pad_left);
/*----------------------TODAY BY IP----------------------*/
$today = date('d-m-Y');
$sql="Select count(DISTINCT(ip_visit)) as visit From counter
where date_visit = '$today'" ;
$result= mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$id_visit = $row[id_vist];
$today = str_pad($visit,6,0,str_pad_left);
/*----------------------TOTAL IP-----------------------*/
$sql="Select count(DISTINCT(ip_visit)) as visit From counter";
$result= mysql_query($sql);
$row = mysql_fetch_array($result);
$visit = $row[visit];
$total = str_pad($visit,6,0,str_pad_left);
?>
<center>
<table>
<tr><td>Open Page : </td><td id="counter"bgcolor="#0252A1">
<?=$openpage?></td></tr>
<tr><td>Today : </td><td id="counter"bgcolor="#1BAFD5">
<?=$today?></td></tr>
<tr><td>Total : </td><td id="counter"bgcolor="#D96003">
<?=$total?></td></tr>
</table>
</center>
Tag : PHP

|
|
 |
 |
 |
 |
Date :
2011-05-23 22:15:37 |
By :
ส้ม |
View :
1024 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ขอดู error หน่อยครับ
|
 |
 |
 |
 |
Date :
2011-05-23 22:42:23 |
By :
prach_kp |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
นี่คือ error ค่ะ
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fashions/public_html/counter.php on line 22
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fashions/public_html/counter.php on line 33
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fashions/public_html/counter.php on line 41
Open Page : 000000
Today : 000000
Total : 000000
|
 |
 |
 |
 |
Date :
2011-05-24 06:59:10 |
By :
ส้ม |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|
|

|
Load balance : Server 00
|