Hello everyone, I just started coding php. I have a website on which is connected to my database by php file on server. but I had a problem, I need to check when my database changes then "do something". But my "Hosting" has counted my "query" and the problem is "maximum query per hour". Is there any way to check my database without running "query".
THANKS?
<?php
$table = $_GET["table"];
$col = $_GET["column"];
$db_connect = mysqli_connect("server", "user", "pass", "dbname");
if (!$db_connect) {
die('Could not connect: ' . mysqli_error());
}
else {
echo 'Connected successfully';
}
$sql = "SELECT $col FROM $table";
$result = mysqli_query($db_connect, $sql);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
echo "". $row[$col]."";
}
else {
echo "0 results";
}
mysqli_close($db_connect);
?>