How to randomly select database rows in MySQLi

I am making this tutorial for randomly select database rows in Mysql. This is my number ten article. I am create first a HTML page then write Custom CSS and use additional bootstrap CSS and JS. After create HTML page then converted PHP page then create MySql database.

Four rows in my database. Please make this database carefully and I’m create a video tutorial below how to insert data in Mysql database. Download this code. Download option is below end of the article. Try Now.

Making Database

CREATE TABLE `rand` (
`id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`address` varchar(100) NOT NULL,
`ph` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `rand` (

`id` int(11) NOT NULL,

`name` varchar(100) NOT NULL,

`address` varchar(100) NOT NULL,

`ph` varchar(100) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `rand` (`id`, `name`, `address`, `ph`) VALUES
(1, 'Jon Tab', 'Malaysia', '963258745'),
(2, 'Sur Bharda', 'Island', '56326587'),
(3, 'Samresh Kumar', 'Kochi', '2458745214'),
(4, 'Duo Falla', 'Muka', '326587452'),
(5, 'Solly Han', 'Tubatu', '4569875214'),
(6, 'Silli Tand', 'Paru', '78563215478');

INSERT INTO `rand` (`id`, `name`, `address`, `ph`) VALUES

(1, 'Jon Tab', 'Malaysia', '963258745'),

(2, 'Sur Bharda', 'Island', '56326587'),

(3, 'Samresh Kumar', 'Kochi', '2458745214'),

(4, 'Duo Falla', 'Muka', '326587452'),

(5, 'Solly Han', 'Tubatu', '4569875214'),

(6, 'Silli Tand', 'Paru', '78563215478');

index.php

This PHP page showing our result. This code handling large volumes of data to randomly select.

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>How to randomly select database rows in MySQLi</title>
 	 	 	<link href="style.css" rel="stylesheet" type="text/css">
<script src="bootstrap.min.js"></script>
 	 	 	<link rel="stylesheet" href="bootstrap.min.css">  






<div class="area1">



<div align="center"><strong>



<h1>How to randomly select database rows in MySQLi</h1>



  </strong></div>


<strong>



<div align="center">
  			<form method="POST" class="form-inline" style="margin-top:10px;">
        
			<input type="text" class="form-control" name="val">
            
			<input type="submit" name="more" value="View Query" class="btn btn-primary">
			<input type="submit" name="data" value="Show All" class="btn btn-success">
		</form>
</div>



</strong></div>


<strong>



<div class="container" style="margin-top:20px;">
fetch_assoc()) {
					
						?&gt;



 [PHP] [PHP]


<table class="table table-bordered table-striped" border="1">



<tbody>


<tr>



<td width="5%">Sl No</td>






<td width="24%">Name</td>






<td width="24%">Address</td>






<td width="47%">Phone No</td>



</tr>

<!--?php
					$conn = mysqli_connect("localhost","root","password","database nmae");
                    if (!$conn) {
					die("Connection failed: " . mysqli_connect_error());
					}
				    $find="";
					if(isset($_POST['more'])){
						$num=$_POST['val'];

						$find='limit '.$num;
					}

					if(isset($_POST['data'])){
						$find='';
					}

					$query=mysqli_query($conn,"select * from rand order by id asc $find");
					
					while($row = $query>


<tr>



<td><?php echo $row['id']; ?></td>






<td><!--?php echo $row['name']; ?></td>






<td><?php echo $row['address']; ?></td>






<td><?php echo $row['ph']; ?></td>



</tr>



						<!--?php
					}
                 
				?-->
</tbody></table>
</div>

</strong>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

<title>How to randomly select database rows in MySQLi</title>

<h1>How to randomly select database rows in MySQLi</h1>

</strong></div>

</form>

</div>

</strong></div>

fetch_assoc()) {

[PHP] [PHP]

<tbody>

<tr>

<td width="24%">Address</td>

<td width="47%">Phone No</td>

</tr>

<!--?php

$conn = mysqli_connect("localhost","root","password","database nmae");

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

$find="";

if(isset($_POST['more'])){

$num=$_POST['val'];

$find='limit '.$num;

}

if(isset($_POST['data'])){

$find='';

}

$query=mysqli_query($conn,"select * from rand order by id asc $find");

while($row = $query>

<tr>

</tr>

<!--?php

}

?-->

</tbody></table>

</div>

</strong>

Download