$linkcount=0;
$mysqli = new mysqli ("localhost", "halem3_halem3", "jeremiah2911", "halem3_internetgoldpages") or die ('I cannot connect to the database because: ' . mysql_error());
$uresult = $mysqli->query("SELECT * FROM company WHERE ID='89546'", MYSQLI_USE_RESULT);
if ($uresult)
{
while ($data = $uresult->fetch_assoc())
{
$Page_Views=$data["Page_Views"];
}
}
$Page_Views = $Page_Views + 1;
mysqli_close($mysqli);
$mysqli = new mysqli(localhost, halem3_halem3, jeremiah2911, halem3_internetgoldpages);
if($mysqli->connect_errno)
{
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$sql = "UPDATE company SET Page_Views='$Page_Views' where ID='89546' ";
if (mysqli_query($mysqli, $sql))
{
//echo "Updated Company
";
}
else
{
//echo "Error updating Company
" . $mysqli->connect_error;
}
mysqli_close($mysqli);
$Page_Views = number_format($Page_Views);
echo "
 $Page_Views pageviews since 1/1/2024 |
";
?>