
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;
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.
How to randomly select database rows in MySQLi %MINIFYHTMLdb69baaf2c14c088dd92d1c2a955066d15%How to randomly select database rows in MySQLi
fetch_assoc()) { ?> [PHP] [PHP]
Sl No Name Address Phone No