I'm working on a website and i need a way to integrate a database. I just need to simply have people enter data in a form and it gets posted in a database and possibly a page to give a summary of whats been posted in the database. Can anyone help or give a point to start working?
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Database
- Thread starter jsm4182
- Start date
- Sort by reaction score
Here's how I would do it,
First you will need to create the form in html, then a separate (doesn't have to be but it's easier if it is) php script that handels the form inputs, adding records to the sql database as it goes. There will be plenty of tutorials on writing a script to add records on somewhere like sitepoint. If this is user entered data pay particulat attention to security..you never know what people will try and put in a text box.
There are also a few good forums out there for php/mysql integration,
phpbuilder
devshed
also if you want to get a book about it I believe Larry Ul(l)man (sp?) wrote a rather good one that explains the basics very well. It's on peachpit press and is called something completely obvious like..learning php and mysql.
Hope this helps a litte. Also be sure that your host allows for a mysql database to be set up and php scripts to run. If it does not I would recommend dreamhost (sign up with this link and I get some cash, http://www.dreamhost.com/donate.cgi?id=4318 )
First you will need to create the form in html, then a separate (doesn't have to be but it's easier if it is) php script that handels the form inputs, adding records to the sql database as it goes. There will be plenty of tutorials on writing a script to add records on somewhere like sitepoint. If this is user entered data pay particulat attention to security..you never know what people will try and put in a text box.
There are also a few good forums out there for php/mysql integration,
phpbuilder
devshed
also if you want to get a book about it I believe Larry Ul(l)man (sp?) wrote a rather good one that explains the basics very well. It's on peachpit press and is called something completely obvious like..learning php and mysql.
Hope this helps a litte. Also be sure that your host allows for a mysql database to be set up and php scripts to run. If it does not I would recommend dreamhost (sign up with this link and I get some cash, http://www.dreamhost.com/donate.cgi?id=4318 )
Macromedia Dreamweaver 8
This piece of software has an ability to generate record insert , record update , record list php code automatically. You just select a mysql database and table...
Nice for lazy people who don't want to write it all in text editor. And good starting point for looking at php->mysql code structure. Plus 30 days eval. version is there...
Have Fun
This piece of software has an ability to generate record insert , record update , record list php code automatically. You just select a mysql database and table...
Nice for lazy people who don't want to write it all in text editor. And good starting point for looking at php->mysql code structure. Plus 30 days eval. version is there...
Have Fun
