How do you fetch the data from already stored database by using php code?

Answer 1

Use the Select statement. As in

<?php

// If you want all of the data

$select = mysql_query("SELECT * FROM table_name"); // where table_name is name of your table

// If you want selected data

$select = mysql_query("SELECT id, username, password FROM table_name");

// If you want a particular data as in salary of employee named John from table employees

$select = mysql_query("SELECT salary FROM employee WHERE Name='john'");

// Remember This only selects the data. Now the fetch part

while($fetch = mysql_fetch_array($select))

{

// replace the column_name with name of the column fields in database

echo $fetch['column_name];

echo $fetch['column_name'];

}

?>