<?php
    //connect to your database
    $host = "hostname";
    $user = "username";
    $password = "password";
    $dbname = "dbname";
    $con = mysqli_connect($host, $user, $password, $dbname);
    if (!$con) {
        die("Connection failed: " . mysqli_connect_error());
    }
    
    //query to count the number of visitors
    $query = "SELECT count(*) as visitors FROM visitors";
    $result = mysqli_query($con, $query);
    if (mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);
        echo $row["visitors"];
    } else {
        echo "0";
    }

    //close the connection
    mysqli_close($con);
?>