How To Get Data From Html Table?

[darkfox]

so this is the scenario, i am creating an admin page using php and html and i do have an HTML table that is being populated dynamically, so what i want to do is, when i click the table row, i will be redirected to another page and print the details of the product i clicked from the table.

i really got lost here.. i dont really need the whole code/answer, i just need to know how to extract the text that is clicked from the table

 

thanks in advance guys!

[Muddy_Funster]

to answer that we would need an example of the data that is in the table

[darkfox]

this is the table it self,

 

product id product name quantity amount

 

50 mouse 3 1000

50 cpu 45 800

50 sticker 5 50

50 keyboard 3 200

 

 

so how can i get the product id that was clicked? thank you sir

[PFMaBiSmAd]

Your would form a link with a GET parameter on the end of it, something like ?id=123, where the 123 is the product id and is dynamically put into each link as you loop through the data to output the html table.

[Muddy_Funster]

Yeah, exactly what he said, just tell us you don't actualy have 4 products with the same product id....

[darkfox]

ahm sir can you elaborate further? i dont really get it.. sorry im still newbie in web programming

[Muddy_Funster]

ok, lets take it back to the start, how does the info get into the HTML table and where does it come from?

[PFMaBiSmAd]

There's nothing to elaborate on. As you are looping to dynamically make the existing html table, you produce a link with the indicated get parameter on it. If you can echo the product id in the that column of the html table, you can echo it in the link.

[darkfox]

ahm from my database sir.. ahm i am using MySQL..

[darkfox]

sir my main problem is that, i cant get the product id that was clicked by the user..

[Muddy_Funster]

what he's saying is that then you are echoing out the table contents make a lint that includes the product id as a url variable that the recieving page can then lookup.

while($row = mysql_fetch_assoc($result)){
echo "<tr><td><a href=\"path_name/filename.php?pid={$row['product id']}\">{$row['product id']}</td><td>{$row['product name']}</td><td>{$row['quantity']}</td><td>{$row['ammount']}</td></tr>
}

That will then pass the product id through to the receiving page which can access it through the $_GET['pid'] call.

 

Does that make more sense?

[darkfox]

oh.. ok sir, now that make sense! thanks alot sir! i owe you one and sir btw, how can i make it as a javascript code? coz i made an onclick function on <tr> so that i will not be using the '<a>' link to make it more presentable and make all columns clickable sir , do you have any idea? sorry for lots of questions sir.. thanks again )

[Christian F.]

Use both, that way you know it'll work regardless of what browser your users use. I also recommend doing the page without the JS methods first, so that you don't try to do too much at the same time. JS can easily be added into the mix after everything's up and running, after all.

 

Lastly, I'd probably look into jQuery for this, if I were you; It'll help make things easier for you in the long run, but only if you've read up on basic Javascript syntax first.