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

0 vote184 views1 answer
Laravel controller create command in a folder
PHP Laravel
10 votes347 views3 answers
Php check weekday of date
PHP
0 vote164 views1 answer
Cidblike ci3
PHP
3 votes177 views6 answers
Convertir datetime a string en php
PHP
0 vote161 views1 answer
$product->product_type
PHP
2 votes146 views1 answer
Comments table example in laravel
PHP Laravel
0 vote187 views1 answer
Laravel firstorcreate usage
PHP
0 vote172 views1 answer
Codeigniter 4 radio button isset
PHP
3 votes161 views6 answers
Laravel cors
PHP
12 votes199 views4 answers
Laravel auth setup
PHP Laravel