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 vote151 views1 answer
Laravel ID Generator
PHP Laravel
1 vote126 views1 answer
Fixuphost
PHP
0 vote128 views1 answer
How to add logo in FPDF PHP
PHP
0 vote130 views1 answer
Prevent xss attack in laravel
PHP
12 votes142 views6 answers
Php round down
PHP
0 vote130 views1 answer
Alternatively, you may set the environment variables ONIG_CFLAGS and ONIG_LIBS to avoid the need to call pkg-config.
PHP
0 vote123 views1 answer
Laravel dateinterval not found
PHP
1 vote123 views1 answer
Php validate date format yyyy-mm-dd
PHP
0 vote112 views1 answer
Php insert char before each letter using regex
PHP
0 vote120 views1 answer
Ternary operator for three conditions in php
PHP