MySql help needed! connecting to server?

Question

hi! i'm a new user to web designing and stuff and hit a major roadblock.

basically my site needs a database that can store info provided through forms filled in my users. After which, the user can look at the updated database.

i know for a fact that u can use mysql as the database, but how do you do the actual linking? Do i need other software such as Php/asp ???

And if possible are there any gd sites that u'll recommend for web designing too? i'll really need a crash course =_=

well, i'm currently using dreamweaver to build the website coz i'm not that good with hard coding.

i'll just need a page that has the following 2 functions.
1) allows users to enter info via a form
2) displays all info stored currently within a database.

not much data manipulation needed on the database.

Answer 1

Yes. MySQL simply stores and retrieves data. In order to actually do something with that data, say, output it to a web page, you need to have server-side scripting in place. PHP and ASP.NET are the two most popular platforms/languages. These are programming languages that connect to the MySQL server (among many other things), tell it what data to retrieve, then manipulate the data, and output raw HTML, which is then viewed by the web browser just like any normal, static HTML page.

If you have little or no programming experience, I recommend PHP and MySQL for Dummies (http://www.amazon.com/PHP-MySQL-Dummies-Computer-Tech/dp/0470096004/ref=pd_bbs_sr_1/105-0984288-7766013?ie=UTF8&s=books&qid=1174458348&sr=8-1 ) or ASP.NET for Dummies (http://www.amazon.com/ASP-NET-Dummies-Computer-Tech/dp/076457907X/ref=pd_bbs_1/105-0984288-7766013?ie=UTF8&s=books&qid=1174458372&sr=1-1 ). The Dummies series is an excellent resource for beginners because it is written without any assumptions regarding the readers' previous experience with the subject.

As far as sites... it depends on what you need to learn. Do you need to learn about good design? Do you need to learn how to do HTML, CSS coding? Or do you need resources on server-side languages or MySQL development?

Answer 2

You should read the following.
http://www.webmonkey.com/programming/php/tutorials/tutorial4.html
It is just an intro into php/mysql.
You will need some active page to store and retreive your data.

You can probably find pages to store form data from any of the php script archives and simply adapt the code to your page in Dreamweaver. It works well.

Answer 3

Few blunders: a million. Connecting: desires username and password. $link = mysql_connect("localhost", "username", "password") or die(" ought to not connect : " . mysql_error()); this might teach you WHY you do not connect (mysql_error returns a message.) save the fee $link to close the DB later. 2. choosing the DB mysql_select_db("dbname") or die("ought to not opt for database"); 3. The interest: "opt for * from" returns an array. i.e. $question = "opt for * FROM `shoppers` the place `person`=' " . $uname." ' "; (Your question does not have any info which includes "the place". in case you have nothin, merely write "the place a million".) (Now, deliver the question:) $checklist = mysql_query($question) or die("question failed : " . mysql_error()); (and checklist the blunders if there is one) (Now fetch the array:) $lst = mysql_fetch_array($checklist); (now, use the array $lst) (Now, unfastened the outcomes:) mysql_free_result($checklist); (finally, close the link:) mysql_close($link); (do not forget to close your link: it is why you save $link all the way by using.)