I have table (media) having 20 record with 5 columns (id,name,phone,email,address) i need to show this 20 records in my php file how to do this?
See Question&Answers more detail:osI have table (media) having 20 record with 5 columns (id,name,phone,email,address) i need to show this 20 records in my php file how to do this?
See Question&Answers more detail:osLearn how to query a database using PHP, then get data from the database using a query like:
SELECT * FROM media;
Expanded solution:
$db = new mysqli('localhost', 'user', 'pass', 'demo');
if($db->connect_errno > 0){
die('Unable to connect to database [' . $db->connect_error . ']');
}
$sql = "SELECT * FROM media;";
if(!$result = $db->query($sql)){
die('There was an error running the query [' . $db->error . ']');
}
while($row = $result->fetch_assoc()){
echo $row['id'] . ', ' . $row['name'] . ', ' . $row['phone'] . ', ' . $row['email'] . ', ' . $row['address'] . '<br />';
}
Each field will be available in the $row
array for earch result row.