Adding data to a Database
In the first part you built the database and the table
to store your data and now we are going to show you
how to display this information .
The following script does the nitty gritty here , again
change the ("hostname" , "username"
, "password") to your own settings .
<?php
//make a connection with your details
$connection = mysql_connect("hostname" , "username"
, "password")
or die ("Cannot make the connection");
//connect to the sampldb database with our connection
details
$db = mysql_selectdb("sampledb" , $connection)
or die ("Cannot connect to the database");
//select all from sample table and store in $sql_query
$sql_query = "SELECT * FROM sample";
//store this in $result
$result = mysql_query($sql_query);
//if an entry exists
if(mysql_num_rows($result))
{
//loop through the fields
while($row = mysql_fetch_row($result))
{
//display the links $row[1] is the link , $row[0]
//is the id value
echo ("<a href=\"$row[1]\">$row[1]</a><br>");
}
}
//if no entry exists print a message
else
{
echo "no values in the database";
}
?>
|
