Github visitors counter

index.php

<?php

function createImage($content)
{
	$font1 = 5;
	$width1 = imagefontwidth($font1) * strlen($content);
	$img_w = 240;
	$img_h = 64;
	$image = imagecreatetruecolor($img_w, $img_h);
	$white = imagecolorallocate($image, 255, 255, 255);
	$black = imagecolorallocate($image, 0, 0, 0);
	imagefill($image, 0, 0, $white);

	imagestring($image, 12, ($img_w / 2) - ($width1 / 2), 20, $content, $black);

	imagepng($image);
	imagedestroy($image);
}

//$db = new \PDO('sqlite:'.__DIR__.'/db.sqlite');
$db = new \SQLite3(__DIR__.'/db.sqlite');
$db->query('CREATE TABLE IF NOT EXISTS "visits" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    "referrer" TEXT,
    "time" DATETIME
)');

$statement = $db->prepare('INSERT INTO "visits" ("referrer", "time") VALUES (:url, :time)');
$statement->bindValue(':url', $_SERVER['HTTP_REFERER'] ?? null);
$statement->bindValue(':time', date('Y-m-d H:i:s'));
$statement->execute();

$result = $db->prepare('SELECT count(*) FROM "visits"')->execute();

$count = $result->fetchArray()[0];
header("Content-type: image/png");
createImage($count);

Nice suggestions. feel free to make a PR https://github.com/ahmedash95/github-views