Select randomly from mysqli php

<?php
	require'conn.php';
 
	$query=mysqli_query($conn, "SELECT * FROM `person` ORDER BY rand() LIMIT 6") or die(mysqli_error());
	while($fetch=mysqli_fetch_array($query)){
		echo"<tr>";	
		echo"<td>".$fetch['p_id']."</td>";
		echo"<td>".$fetch['firstname']."</td>";
		echo"<td>".$fetch['lastname']."</td>";
		echo"</tr>";
	}
?>

Source: sourcecodester.com

Similar codes

15 votes180 views3 answers
Pass data to blade laravel
PHP Laravel
15 votes247 views6 answers
Transaction laravel
PHP
1 vote112 views1 answer
The iso 8601 date format php
PHP
6 votes193 views6 answers
Php return a json response
PHP
0 vote146 views1 answer
Dateinterval php
PHP
2 votes192 views2 answers
Laravel has table
PHP Laravel
7 votes153 views6 answers
Disable cors
PHP
0 vote164 views1 answer
Long text in laravel migration
PHP
7 votes151 views1 answer
Php configuration
PHP
2 votes157 views3 answers
Laravel migration drop foreign keys
PHP