How validate and retrieve data from database?

Answer 1

It is better to validate the data going into the database for errors rather then data coming out. The data to be retrieved can be done using the $_REQUEST or mysql_fetch_array or PDO statements. I am giving 2 simple examples

// The connection string or function here to connect to database

// Put the name of your database in place of db_name

mysql_select_db("db_name");

// Enter the name of table in place of table_name

$query = mysql_query("SELECT * FROM table_name");

while($fetch = mysql_fetch_array($query))

{

// add your table column names in the square blocks

echo $fetch['Name']."
";

echo $fetch['email']."
";

}

?>

If you want a particular data that can be obtained by using the where clause

The ID would come from user input

$data = $_REQUEST['ID'];

// Enter the name of table in place of table_name

$query = mysql_query("SELECT * FROM table_name WHERE ID='$data'");

while($fetch = mysql_fetch_array($query))

{

// add your table column names in the square blocks

echo $fetch['Name']."
";

echo $fetch['email']."
";

}

?>