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 vote128 views1 answer
Php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider
PHP
7 votes166 views4 answers
How get role of user in laravel spatie
PHP Laravel
0 vote149 views1 answer
Array filter php get first object
PHP
0 vote172 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
1 vote177 views1 answer
How convert the date and time to integer in laravel
PHP Laravel
3 votes172 views1 answer
Wordpress wp_head
PHP Wordpress
1 vote167 views1 answer
Check which database connect laravel
PHP
0 vote183 views1 answer
Enum artisan codwe
PHP
0 vote142 views1 answer
Laravel restrict route methods
PHP
3 votes163 views2 answers
Php remove cookie
PHP