[scl789]

Ok i gave up on the imputing data into a access database so i started learning Mysql and php. Now i have my mysql database all set up my tables created and everythign. Now how the heack to i make a form for users to enter stuff and having it go into my mysql database? I went through some of the tutorials but all i was able to find out was how to have a form someone fileld out get e-mail to me. I want it to go directly into the mysql database.Or if i shuld use something other than PHP to make a webpage for people to enter data in a form so it goes into my mysql database

Thanks

[dennispopel]

Hello,

I'm afraid you really did no research on this topic, as PHP+MySQL is the most popular stack for web applications. Assuming you know how to get data from a form, you do the following:

mysql_connect('server', 'userName', 'password');
mysql_select_db('dbname');

to insert data:

mysql_query("insert into tableName(field1, field2, ...) values('$value1', '$value2', ...)");

to update data:

mysql_query("update tableName set field1='$value1', field2='$value2', ... where primaryKey=$rowId");

I also assume that you know the relational model of your data. $valueXX should be escaped before going into database.

[scl789]

Thank you like i said im new to all this. this is one of the first places ive been to. I did find one e-book on it but it gave u the stuff to have the data go into the mysql table it dident teach you how to do it thats why im not sure how to do it. Where can i get more info on this stuff?

[NeverMind]

this website has some good tuts:
http://www.php-mysql-tutorial.com/index.php

there are some stuff that are overdone there, but generally it's good

[scl789]

Thank you guys

[stormshadow]

just make queries