Websites

how do i let users of my website add content to mySQL database, so i can then retrieve it?

Hi i want to know what i’d have to do (and how to do it if possible). I want people to be able to visit my website and place adverts, so i was thinking that they should add it to mySQL database, then have a way in which my site can retrieve their information and process it and place it in a new page for their advert and it will go into the correct category, would i need a php script or what in order to let them add the content and then what about processing the information, as currently they just email me and i process it and place the ad.but it can get very time consuming

Any help would be great

thanks

You are on the right track. It’s not too complicated to add content to the database..

1- Create a form. Let the user enter information, and click submit.

2- The submit method must do the following:
a. Connect to the database. You can use C# or php, and the code is available everywhere. For example: use this code in this website to connect. http://www.webcheatsheet.com/PHP/connect_mysql_database.php

b. Then you can run queries (shown in the same link). Use insert to load data, and select to pull data.

The best way is to read this book.
Build Your Own Database Driven Website Using PHP and MySQL by Kevin Yank