Ziyaretçi yenileme alanı güncelleştirmek zaman sayfası yapmak

0 Cevap php

Ben mysql sorgusu ile ilgili bir sorun var ..

Ben veri bir tablo var .. adı (Info_website) olan, alan (NumVisitor) 'dir ..

ziyaretçim açtı (NumVisitor + 1) istediğiniz sayfayı yenileyin ama 2 infact sorun ..

bu kodu ..

$sql2 = "UPDATE `Info_website` SET `NumVisitor` = `NumVisitor`+1 WHERE `Id`=1 LIMIT 1";
$query = mysqli_query($connect, $sql2) or die (mysqli_error());

çok teşekkür ederim ..

// New Comment

<?php
require("startsession.php");
require("config.php");
include "../include/header.php";
echo '<title>'.$setting['websit_title'].' - Main Page </title>';
?>
<br />
<br />
<table align="center" width="65%">
<tr>
    <td class="head_title" colspan="4">Information</td>
</tr>
<tr>
    <td width="35%">Number of New Book:</td>
    <td>
        <?php
            $sql = "SELECT IDkalemat FROM main_kalemat";
            $query = mysqli_query ($connect , $sql) or die (mysqli_error());
            $num = mysqli_num_rows($query);
            echo $num;
        ?>      
    </td>

    <td width="35%">Number of Users:</td>
    <td>
        <?php
            $sql = "SELECT IDUser FROM user_kalemat";
            $query = mysqli_query ($connect , $sql) or die (mysqli_error());
            $num = mysqli_num_rows($query);
            echo $num;
        ?>
    </td>
</tr>
        <tr>
        <td width="35%">Number Of Visitors:</td>
    <td>
        <?php
            $sql = "SELECT NumVisitor FROM Info_website";
            $query = mysqli_query ($connect , $sql) or die (mysqli_error());
            $num = mysqli_fetch_array($query);
            echo $num['NumVisitor'];
        ?>
    </td>
</tr>

</table>

<br />
<br />
<?php

//-------- from here the number of visitor

//--------- the end
$sql2 = "UPDATE Info_website SET NumVisitor = NumVisitor+1 WHERE Id=1 LIMIT 1"; 
$query = mysqli_query($connect, $sql2) or die (mysqli_error());
if ($query)
{
    echo '1';
}else{
    echo '0';
}
include ("../include/footer.php");
?>

0 Cevap