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

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

PHP script to delete a specific value from an array using array_filter() function

< ?php $colors = array('key1' => 'Red', 'key2' => 'Green', 'key3' => 'Black'); $given_value = 'Black'; print_r($colors); $new_filtered_array = array_filter($colors, function ($element) use ($given_value) {      return ($element != $given_value); }       print_r($filtered_array);       print_r($new_filtered_array); ?>
Post a Comment
Read more

PHP program to generate an array with a range taken from a string

<?php function string_range($str1)  {   preg_match_all("/([0-9]{1,2})-?([0-9]{0,2}) ?,?;?/", $str1, $a);   $x = array ();   foreach ($a[1] as $k => $v)    {     $x  = array_merge ($x, range ($v, (empty($a[2][$k])?$v:$a[2][$k])));   }   return ($x); } $test_string = '1-2 18-20 9-11'; print_r(string_range($test_string)); ?> @php_program
Post a Comment
Read more