On Wed, 21 Feb 2007 02:20:49 +0100, <fi************@gmail.comwrote:
Hi!
I'm a librarian with a little PHP knowledge.. I'm trying to make a
catalog from scratch for my library. I don't like the look of the
current catalog so I'm trying to make a custom PHP/MySQL
implementation.
I can do everything I need to do except, I don't completely understand
a detail. Ideally I could write this:
<a href="catalogrecord.php?recordnum=4">Tom Sawyer</a>
The idea would be to pass the number 4 to the catalogrecord.php page
when the hyperlink is clicked. Then it would know which number in the
catalog it should pull up and display on the next page. Is this
possible? And if so, how could I access the recordnum=4 on the next
php file?
The question is a bit vague, but to get you started:
You say MySQL, so I assume that number 4 is an index in the database where
the records are stored? A list of links could be made by:
<?php
mysql_connect('hostname','username','password');//of you mysql db
mysql_select_db('catalogue');
$books = mysql_query('SELECT `id`, `name` FROM `book`');
while($book = mysql_fetch_assoc($books)){
print '<a
href="catalogrecord.php?recordnum='.$book['id'].'">'.$book['name'].'</a><br>';
}
?>
And the receiving script would do something like this:
<?php
$book_id = intval($_GET['recordnum']);
mysql_connect('hostname','username','password');//of you mysql db
mysql_select_db('catalogue');
$bookresult = mysql_query('SELECT * FROM `book` WHERE `id` = '.$book_id);
if(mysql_num_rows($bookresult) 0){
$book = mysql_fetch_assoc($bookresult);
foreach($book as $key =$value){
print $key.':'.$value.'<br>';
}
} else {
echo 'Book not found in database.';
}
?>
--
Rik Wasmus