Skip to main content

Fetch data from database using PHP

PHP program to fetch records from the table in Database.


<?php

$conn = mysqli_connect('servername','username','password','databasename');

if(!$conn)
{ 
die('Connection failed!'.mysqli_error($conn));
}
$sql = "SELECT * FROM tablename"; 

 $data = mysqli_query($conn,$sql);   while($rec = mysqli_fetch_row($data))
{
echo "$rec[0]<br>";
echo "$rec[1]<br>";
echo "$rec[2]<br>";
}
?>
 ------------------------------------------------------------- Note: When we are using XAMPP or WAMP, servername = localhost, username = root, password is empty.
Labels:

Comments

Post a Comment

Popular posts from this blog

Temperature Calculator using PHP

This is a PHP script to calculate and display average temperature, five lowest and highest temperatures. <?php $month_temp = "78, 60, 62, 68, 71, 68, 73, 85, 66, 64, 76, 63, 81, 76, 73, 68, 72, 73, 75, 65, 74, 63, 67, 65, 64, 68, 73, 75, 79, 73"; $temp_array = explode(',', $month_temp); $tot_temp = 0; $temp_array_length = count($temp_array); foreach($temp_array as $temp) {  $tot_temp += $temp; }  $avg_high_temp = $tot_temp/$temp_array_length;  echo "Average Temperature is : ".$avg_high_temp."; sort($temp_array); echo " List of five lowest temperatures :"; for ($i=0; $i< 5; $i++) { echo $temp_array[$i].", "; } echo "List of five highest temperatures :"; for ($i=($temp_array_length-5); $i< ($temp_array_length); $i++) { echo $temp_array[$i].", "; } ?>
Post a Comment
Read more

PHP program to convert word to digit

<?php function word_digit($word) {     $warr = explode(';',$word);     $result = '';     foreach($warr as $value){         switch(trim($value)){             case 'zero':                 $result .= '0';                 break;             case 'one':                 $result .= '1';                 break;             case 'two':                 $result .= '2'; ...
Post a Comment
Read more