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

1 vote300 views1 answer
Enable extensions in php.ini
PHP
1 vote357 views4 answers
Create json laravel
PHP Laravel
9 votes322 views5 answers
How to extract data from json in php
PHP
2 votes343 views1 answer
Php chunk array
PHP
0 vote306 views1 answer
Meyfa/phpunit-assert-gd[v2.0.0, ..., v2.x-dev, v3.0.0] require ext-gd * -> it is missing from your system. Install or enable PHP's gd extension
PHP
0 vote293 views1 answer
Twig superglobal post
PHP
9 votes285 views4 answers
Laravel soft delete example
PHP
0 vote315 views3 answers
Run phpstan terminal
PHP
7 votes352 views3 answers
Laravel - Query Builder Left join
PHP Laravel
0 vote279 views1 answer
Laravel routes options
PHP