I have written a php page and script, but I have a problem reloading the php script - my page draws a link from the database and inserts it into the element, but only once per page reload. What to do to get a link random every time you click on ?
It's html and php code:
<?php
$DEFAULT_LINK = "default.html";
// connect to DB
require_once "connect.php";
$conn = new mysqli($host, $db_user, $db_password, $db_name);
$sql = "SELECT link FROM pages ORDER BY RAND() LIMIT 1";
$result = mysqli_query($conn, $sql);
if ($result !== false)
$row = mysqli_fetch_assoc($result);
else
$row = false;
if ($row && isset($row["link"]))
$RANDOM_LINK = $row["link"];
else
$RANDOM_LINK = $DEFAULT_LINK;
?>
<!DOCTYPE html>
<html>
<head>
<title>Random it</title>
<meta charset="utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<header></header>
<div class="random">
<a href="<?php echo $RANDOM_LINK; ?>" target="_blank">Random</a>
</div>
<footer></footer>
</body>
</html>
</div>