PHP Dynamic Pages
Posted: Mon Mar 08, 2010 12:15 pm
Hi All
I am new to PHP and i am trying to create a dynamicaly generated page for a localhost site i am making.
I have the databases working fine but i would like to be able to click on a button eg View and have it take me to a different page
Below is the code i have so far please help (IF YOU NEED MORE INFO PLEASE JUST ASK)
Thanks in advance
Database Page (Section)
{
echo "<tr>";
echo "<td><center>" . $row['ID'] . "</td>";
echo "<td>" . $row['Title'] . "</td>";
echo "<td><center>" . $row['Certificate'] . "</td>";
echo "<td>" . $row['Director'] . "</td>";
echo "<td><center>" . $row['Released'] . "</td>";
echo "<td><center>" . $row['Notes'] . "</td>";
echo "<td><a href=\"View.php?id=".$row[ID]."\">View</a>";
echo "</tr>";
}
Dynamic Page
<?php
$db = mysql_connect("", "", "");
mysql_select_db("",$db);
$result = mysql_query("SELECT * FROM WHERE id=$ID",$db);
$row = mysql_fetch_array($result);
echo "Title: ".$row["Title"];
?>
I have removed the Database details
My Columns are - Title , Director, Certficate, Released and Notes
Please Help Guys
Thank you
I am new to PHP and i am trying to create a dynamicaly generated page for a localhost site i am making.
I have the databases working fine but i would like to be able to click on a button eg View and have it take me to a different page
Below is the code i have so far please help (IF YOU NEED MORE INFO PLEASE JUST ASK)
Thanks in advance
Database Page (Section)
{
echo "<tr>";
echo "<td><center>" . $row['ID'] . "</td>";
echo "<td>" . $row['Title'] . "</td>";
echo "<td><center>" . $row['Certificate'] . "</td>";
echo "<td>" . $row['Director'] . "</td>";
echo "<td><center>" . $row['Released'] . "</td>";
echo "<td><center>" . $row['Notes'] . "</td>";
echo "<td><a href=\"View.php?id=".$row[ID]."\">View</a>";
echo "</tr>";
}
Dynamic Page
<?php
$db = mysql_connect("", "", "");
mysql_select_db("",$db);
$result = mysql_query("SELECT * FROM WHERE id=$ID",$db);
$row = mysql_fetch_array($result);
echo "Title: ".$row["Title"];
?>
I have removed the Database details
My Columns are - Title , Director, Certficate, Released and Notes
Please Help Guys
Thank you