- urlencode: documentation ( source)
- session_start: documentation ( source)
<?php
$db = mysqli_connect('localhost','root','','DBsito');
if (!$db)
{
die('Could not connect to database: ' . mysqli_error());
}
$db_select = mysqli_select_db($db, 'DBsito');
session_start();
$username = $_SESSION['username'];
$categorie = mysqli_query($db, "SELECT * FROM categoria WHERE BINARY categoria.user_utente = BINARY '$username'");
/* fetch associative array */
while ($row = mysqli_fetch_assoc($categorie)) {
echo '
<a href="categoria.php?categoria='.urlencode($row["categoria"]).'">
<li class="list-item"><img class="card-icone" shadow-lg p-3 mb-5 src="img/upload/'. $row["icona"] . '" >
</li>
</a>';
}
?>
<script type="text/javascript" src="js/home.js">
</script>