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

49 votes359 views6 answers
Laravel when
PHP Laravel
2 votes295 views2 answers
Add hour minute in datetime in php
PHP
0 vote321 views1 answer
Combine 2 columns search query laravel
PHP
0 vote269 views1 answer
Long text in laravel migration
PHP
0 vote317 views1 answer
Php string plus string
PHP
1 vote334 views2 answers
Regular expression for strong password in php
PHP
11 votes303 views3 answers
Cast array to object php
PHP
0 vote338 views2 answers
Adminlte con laravel 8
PHP Laravel
2 votes318 views2 answers
Access json with php
PHP
0 vote306 views1 answer
Php pdo prepare doesn't work
PHP