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 vote163 views1 answer
Laravel api cors localhost issue
PHP Laravel
2 votes139 views2 answers
Laravel custom model primary Key
PHP Laravel
0 vote117 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP
1 vote143 views2 answers
Loop through values of hash php
PHP
3 votes148 views1 answer
Laravel send post request from controller
PHP
0 vote105 views1 answer
Php array extract value
PHP
4 votes129 views2 answers
Php move file
PHP
8 votes130 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
16 votes120 views5 answers
Php compare two dates
PHP
1 vote128 views1 answer
Merge two objects in php
PHP