mysql/php/html

[Anon]

I have written a database in mysql and a .php that calls the database. I have searched everywhere and asked everywhere for help.

The company I work for, wants me to write an html form that will actually add that data to the database table.

Is this possible, if so please help

Thanks
tbaby

[amcgrath]

Umm, yea... (man, this is a tough question to answer without sounding trite) ....

OK, say you have a table with one column called NAME. If you create an html file with an input type of text, called "name", you can post this information to a php script and have the variable called $name equal to whatever the person entered in the field.

Then create an sql string that looks like this (very simplified):

$sql = "insert in table (name) values('$name')";
$res = msql_query($sql,$conn); with $conn being your connection to the database...

and that's pretty much it. Your question though, really begs that you should do some serious reading before getting to work...

[Anon]

thanks

And I have been reading and reading.. Guess being a newbie it's gonna take sometime..

:-)

[amcgrath]

Yea, I didn't mean to sound all high and mighty, we all gotta start somewhere. At least you're not afraid to ask for help 😉