how to save html table data to mysql database using php

[leo.calimutan]

Im, a beginner and i just wanna know how to save html table data to mysql database using php..please help..thank you

 

 

[Ingolme]

Normally you don't extract the data from an HTML table, you feed it to the database through a form. I'd suggest learning about PHP and MySQL first.

[leo.calimutan]

Actually sir, I already tried to insert record using textboxes using php and mysql. I already try to display data from mysql to table.

 

# First Name Last Name City 1 Karthikeyan K Chennai 2 Facebook Inc California 3 W3lessons Blog Chennai, India

 

just like this figure. I want to save this column to database: id,firstnam,lastname,city

 

 

 

 

[Ingolme]

Why do you want to take data from an HTML table instead of using a form?

[leo.calimutan]

I have to get the record from the database then I will display it to the html table. HTML table is editable. After editing i will save that data back to the database. My problem is that how to get that data to html table.

 

[leo.calimutan]

On vb.net 2008 using datagridview: for i as integer 0 to datagridview.rows count

 

 

 

 

[leo.calimutan]

Actualy sir im newbie to php and i dont know how to manipulate html table. But im okay to mysql database just because I already use it for almost 5 years in vb.net programming. Actually the syntax in sql query statement are almost the same. I need help sir on this table. I really appreciated your help..thank you