|
|
Posted by Lennart Anderson on 03/20/07 14:02
"Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
news:ye6dnfGwJsnek2LYnZ2dnUVZ_sDinZ2d@comcast.com...
> Lennart Anderson wrote:
>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>> news:wvSdnUTGP722TWPYnZ2dnUVZ_rylnZ2d@comcast.com...
>>> Lennart Anderson wrote:
>>>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>>>> news:0oGdneT-v7svMmPYnZ2dnUVZ_s3inZ2d@comcast.com...
>>>>> Lennart Anderson wrote:
>>>>>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>>>>>> news:ybqdnXJcAfixAmDYnZ2dnUVZ_vPinZ2d@comcast.com...
>>>>>>> Lennart Anderson wrote:
>>>>>>>> "Jerry Stuckle" <jstucklex@attglobal.net> skrev i meddelandet
>>>>>>>> news:xtCdnUF-VpfLF2DYnZ2dnUVZ_rbinZ2d@comcast.com...
>>>>>>>>> Lennart Anderson wrote:
>>>>>>>>>> I'm having a MySQl table wih a lot of information. I want to
>>>>>>>>>> present some main fields in a table on one page. Each record do,
>>>>>>>>>> of course, have a unique ID. The presnted table will have one
>>>>>>>>>> field as a linked field. I want to be able to click this link,
>>>>>>>>>> retreive the ID information for that record and then present
>>>>>>>>>> detailed data for that record on the next page.
>>>>>>>>>> How do I retreive the ID?
>>>>>>>>>> Any hints are very much appreciated.
>>>>>>>>>> Thanks
>>>>>>>>> Put the id in the link itself.
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> ==================
>>>>>>>>> Remove the "x" from my email address
>>>>>>>>> Jerry Stuckle
>>>>>>>>> JDS Computer Training Corp.
>>>>>>>>> jstucklex@attglobal.net
>>>>>>>>> ==================
>>>>>>>> I think I get the idea but I don't know how to doo that. Can you
>>>>>>>> give me an aidea of how such a link with, I guess, embedded ID
>>>>>>>> would look like?
>>>>>>> Do you know how to do it in html? Same idea - just generated with a
>>>>>>> PHP echo statement instead.
>>>>>>>
>>>>>>> --
>>>>>>> ==================
>>>>>>> Remove the "x" from my email address
>>>>>>> Jerry Stuckle
>>>>>>> JDS Computer Training Corp.
>>>>>>> jstucklex@attglobal.net
>>>>>>> ==================
>>>>>> No, I do not know how to do that in HTML.
>>>>>> But, once again, the problem is that I have a number of records
>>>>>> presented in a table. All records do have unique ID. When preseneted
>>>>>> by the hTML page they are parsed into "hard-coded" HTML and although
>>>>>> I can have a field to act as a link I can't get the ID for the
>>>>>> special record I am selecting. Only the ID for the last presented
>>>>>> record will come through since that ID is still present in the array.
>>>>>> Any hint of how to get the ID from any selected record?
>>>>> OK, posting the code you're using would help a lot.
>>>>>
>>>>> --
>>>>> ==================
>>>>> Remove the "x" from my email address
>>>>> Jerry Stuckle
>>>>> JDS Computer Training Corp.
>>>>> jstucklex@attglobal.net
>>>>> ==================
>>>> Here is the essential part of the code with the presneted table where
>>>> one of the records field will be a link. I want to retreive the ID for
>>>> any selefted record from, say, 25 presented.
>>>>
>>>> mysql_select_db('db2') or die ('Unable to select database!');
>>>> // create and execute query
>>>> $query = "SELECT ID, DATE_FORMAT(addate, '%m-%d') AS adday,
>>>> DATE_FORMAT(addate, '%H:%i')as adtime, addate, adnamn, adcat,
>>>> adheader,adtext,adprice,adcats.catname FROM ads, adcats where ads.adcat
>>>> = adcats.catid order by ID DESC";
>>>> $result = mysql_query($query)
>>>> or die ('Error in query: $query. ' . mysql_error());
>>>> // check if records were returned
>>>> if (mysql_num_rows($result) > 0)
>>>> {
>>>> // iterate over record set
>>>> // print each field
>>>>
>>>> echo '<h2>Test on data retrieval from the data base</h2></br>';
>>>> echo '<table border=0 cellpadding=2 width = 100% bgcolor="#FFFF99"
>>>> bordercolor="#FFFFFF">';
>>>> echo '<tr>
>>>> <td>Ad-No.</td>
>>>> <td>Day</td>
>>>> <td>Time</td>
>>>> <td>Ad-header</td>
>>>> <td>Price CI$</td>
>>>> <td>Category</td>
>>>>
>>>> </tr>';
>>>>
>>>> while($row = mysql_fetch_object($result))
>>>>
>>>> {
>>>> echo '<tr>';
>>>> echo '<td width=5% bgcolor="#FFFFFF" align = "right">' . ($row->ID) .
>>>> '</td>';
>>>> echo '<td width=4% bgcolor="#FFFFFF">' . ($row->adday) . '</td>';
>>>> echo '<td width=5% bgcolor="#FFFFFF">' . ($row->adtime) . '</td>';
>>>> echo '<td width=40% bgcolor="#FFFFFF">' . '<a href= "advertinfo.php" >'
>>>> . ($row->adheader) . '</td>';
>>>> echo '<td width = 6% bgcolor="#FFFFFF" align = "right">' .
>>>> ($row->adprice) . '</td>';
>>>> echo '<td width = 18% bgcolor="#FFFFFF">' . ($row->catname) . '</td>';
>>>> echo '</tr>';
>>>>
>>>>
>>>> }
>>>>
>>>> echo '</table>';
>>>>
>>>> }
>>>> else
>>>> {
>>>> // print error message
>>>> echo 'No rows found!';
>>>> }
>>>>
>>>>
>>> OK, if you're going to make it a link, you have to pass the id as a
>>> parameter in the link, i.e.
>>>
>>> echo '<td width=40% bgcolor="#FFFFFF">' . '<a href= "advertinfo.php?id='
>>> . $row['id'] . " >' . ($row->adheader) . '</td>';
>>>
>>> This will pass the link as "advertinfo.php?id=3", for example.
>>>
>>> Then in advertinfo.php you use access it with $_GET['id'].
>>>
>>> Be sure to use isset($_GET['id']) in case someone comes to this page
>>> without an id being passed.
>>>
>>>
>>>
>>> --
>>> ==================
>>> Remove the "x" from my email address
>>> Jerry Stuckle
>>> JDS Computer Training Corp.
>>
>> Thanks. This seems most promising but don't I need to have some kind of
>> form method to pass the $_GET variable. Just now the table is presented
>> without any kind of form tags.
>>> jstucklex@attglobal.net
>>> ==================
>>
>>
>
> You need a form to pass values via POST. But GET values can be passed in
> the href. Check alt.html for more info on this.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
No way I can get this to work. The only way I can get the link to reat is by
using:
'<a href= "advertinfo.php?id=$row->ID" >' . ($row->adheader).
But then the id is not parsed in the right way o by looking at th HTML-code
in the browser View source the link is still: <a href=
"advertinfo.php?id=$row->ID" >. When I click and use the $_GET on the linked
page I just get: $row->ID as the answer.
HOw do I get the link to interprete the ID-number and to use that as the
link-parameter.
I admit that I am not too experienced in php but have the intention to learn
but this thing is going to drive me more crazy than usual.
Navigation:
[Reply to this message]
|