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

5 votes164 views3 answers
Laravel destroy session
PHP Laravel
1 vote158 views1 answer
Laravel use references in other tables
PHP
104 votes299 views6 answers
Php add to array
PHP
8 votes170 views4 answers
Php get object class
PHP
15 votes179 views3 answers
Pass data to blade laravel
PHP Laravel
1 vote205 views1 answer
Insert into wp table
PHP
0 vote138 views1 answer
Open a file in a new window phpstorm
PHP
11 votes181 views3 answers
Remove package in laravel
PHP Laravel
48 votes167 views6 answers
Php find in array
PHP
0 vote162 views1 answer
Multi file delete in php
PHP