discvHello, hope someone would be so kind as to help me?
Although I am the webmaster for my company I have no html/php training but I'm a fairly quick learner
(With a little help from Google!).
I work for a magazine publisher and we have an extensive library of back issues that people are forever ringing up about with brilliant questions like:
"I appeared in your mag in 1978 or 79 can you find the issue and send me a copy?" ...Er, No!!!
So I decided to setup a database using Open Office that uses a MySQL database running on our Xserve to enter data.
Through various tutorials I have managed to create a webpage that displays all records in one great big table, now I want to create a webpage that allows the public to query the records and only display the relevant ones.
Here's what I've cobbled together so far:
PHP Code:
<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM archive_table";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
?>
<left>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Magazine</font></th>
<th><font face="Arial, Helvetica, sans-serif">Month</font></th>
<th><font face="Arial, Helvetica, sans-serif">Year</font></th>
<th><font face="Arial, Helvetica, sans-serif">Page No.</font></th>
<th><font face="Arial, Helvetica, sans-serif">Person/Subject</font></th>
<th><font face="Arial, Helvetica, sans-serif">Reg Col?</font></th>
<th><font face="Arial, Helvetica, sans-serif">Author</font></th>
<th><font face="Arial, Helvetica, sans-serif">Photo's?</font></th>
<th><font face="Arial, Helvetica, sans-serif">Colour?</font></th>
<th><font face="Arial, Helvetica, sans-serif">Cover?</font></th>
<th><font face="Arial, Helvetica, sans-serif">Comments</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$Magazine=mysql_result($result,$i,"Magazine");
$Year=mysql_result($result,$i,"Year");
$Month=mysql_result($result,$i,"Month");
$Page_No=mysql_result($result,$i,"Page_No");
$Person_Subject=mysql_result($result,$i,"Person_Subject");
$Regular_Col=mysql_result($result,$i,"Regular_Col");
$Author=mysql_result($result,$i,"Author");
$Photographs=mysql_result($result,$i,"Photographs");
$Colour_Pics=mysql_result($result,$i,"Colour_Pics");
$Front_Cover=mysql_result($result,$i,"Front_Cover");
$Comments=mysql_result($result,$i,"Comments");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Magazine"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Month"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Year"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Page_No"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Person_Subject"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Regular_Col"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Author"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Photographs"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Colour_Pics"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Front_Cover"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$Comments"; ?></font></td>
</tr>
<?
++$i;
}
echo "</table>";
?>
I have tried to use a couple of tutorials to help me but I can't get anything to work.
What I would like is a search field that query's all records and displays results so if somebody wants to find any articles that featured "Bruce Lee" the result would look like:-
Code:
Month Year Page No Person/Subject Reg Col? Author Photo? Colour? Cover?
May 1980 36 Bruce Lee Y A. Smith Y Y
April 2000 16 Bruce Lee Brian Jones Y Y Y
April 2002 3 Teaching Toddlers Bruce Lee Y Y
July 2003 34 History of Bruce Lee Dave Hughes Y Y
June 2008 36 Bruce Lee's Student Y Mr E. Nigma Y Y
Can anyone help?
Please!
