SQL Databases

[munkZ]

I want to setup a web based system for inputting data into an SQL database. The idea being the user gets a simple form style interface with a drop down menu with people's names in (ie: reads from existing data in the database, in this case, a list of people) and then underneath that perhaps some checkboxes and input boxes etc..

where do I start

 

[Rob1000100]

erm, are you wondering how to achive this in terms of writing it and which language to write it in. As I wrote the following post without really fully understanding your question

Spoiler

Well I went down the road of...

Apache 2
http://httpd.apache.org/download.cgi

Mysql 5
http://dev.mysql.com/downloads/mysql/5.0.html

Php 5
http://uk2.php.net/get/php-5.1.4-Win32.zip/from/a/mirror


I used the path of CServer\

• CServer\Apache\
• CServer\mysql\
• CServer\php\
• CServer\www\

Getting them all working for the first time is an absolute pain in the arse, so best of luck if you choose the above.

 

[brajan]

Do you mean SQL or mySQL database?

 

[Martz]

Yup.. more info.

Does your webhost already run MySQL, Apache + PHP? Or are you on a Windows IIS/ASP/MSSQL server?

Either way what you want to achieve is quite easy once you get going, lots of tutorials and examples out there. Just depends on your setup.

 

[munkZ]

well i have an option really. ideally i want it running off my web host which is b-one.net and runs php/mysql

i have a server with IIS setup but would only look at using that if it wasn't possible with thye above setup

 

[brajan]

Well php + mysql is the best choice imho. Do you have any experience with PHP or you're just starting?

 

[brajan]

Getting them all working for the first time is an absolute pain in the arse, so best of luck if you choose the above.

Not really. You picked harder way to install it all manually but you always can use all-in-one packages like:
- Krasnal Serv
- WAMP
- and a lot of others
All those packages cointans: Apache server + PHP, mySQL database. Some others got much more like PERL or FTP servers.

 

[foxy]

there are tonnes of mysql-php for dummies pdf books about that run through setting up basic db on the web....

 

[munkZ]

well i've done bits n pieces a few yrs back at uni, just not a great deal. was hoping for some sort of template i could modify more than anything rly

 

[brajan]

Click!