|
|
Posted by Jerry Stuckle on 11/14/07 13:31
Lloyd Harold wrote:
> I'm very new to PHP and attempting to put together a simple script for
> retrieving MySQL data of personal records.
>
> The MySQL table I'm using consists of:
>
> 0: id
> 1: name
> 2: location (an integer relating to a separate table of locations).
> 3: details
>
> I want the script to list results where, for example, name has a
> location of 4.
>
> Each result should be displayed in it's own paragraph.
>
> Each result should be within a link to open a new page (details.php ?)
> that will retrieve the details for that name.
>
> Ideally, but not essentially, the new page should contain a link back to
> the previous results.
>
> I've managed to cobble together something displays the initial results
> but, despite trawling Google, haven't managed to suss out the rest.
> (It's ugly and insecure so probably best to start from scratch.)
>
> Any pointers gratefully received.
>
> LH
>
Hi, Lloyd,
Sounds like a homework question?
This isn't too bad, once you get the hang of it.
First you need to execute the mysql query. Then, in a loop, retrieve
each result and do what you want with it. For instance (error checking
left out for clarity, but you should be checking the result of every
MySQL call except the mysql_fetch_array()):
$location = 4; // Assumed to be passed from somewhere & validated
$link = mysql_connect('localhost', 'userid', 'password');
mysql_select_db('mydb');
$result = mysql_select("SELECT id, name, details FROM mytable WHERE
location=$location"); // Sorry for the wrapping
if (mysql_num_rows($result) == 0)
echo "No results found<br>\n";
else {
while($data = mysql_fetch_array($result)) {
// $data is an array with elements ['id'], ['name'] and ['details']
echo
"<p><a href='/details.php?id=$data['id']'>$data['name']</a></p>\n";
// You could also display the details, here. Or, if you're not going to
// display the details on this page, just leave them out of the query
}
Then on your details.php page, retrieve the data for the specific ID you
want, and display them with code similar to the above (although you
won't need a loop as you'll only have one result).
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|