Start up help

[caseycasey]

So i am new here and new the world of web design. I am making a blog for myself and am wondering a few things that I couldn't find out on the internet.

When you make a site and have the php and the mysql coded out so that i works, when you pay to host it...does all that info come back and save on the mysql database you made on your computer, or does it go somewhere else? Does the host store it? I am interested in learning a lot about mysql and php, I am in some classes now, but they do not move fast enough. Help?

[Andrea]

Usually, all your files are uploaded to your hosting account - unless you were to use your own computer as a server.

[caseycasey]

Thanks. like I said I have never done this before, is there any kind of advice you can give me. Like something you wish you knew when you started that you now know, related to anything really...just looking for some experienced wisdom

[Wickham]

When you create a page using PHP and a MySQL database you have to have a server on your local computer to process the PHP and database locally (just for testing) and you can use Wampserver2 http://www.wampserver.com/en/download.php or XAMPP http://www.apachefriends.org/en/xampp.html which have Apache server bundled up with PHPmyAdmin and PHP processing.

 

Having tested, you upload your html, css, php and mysql files to your hosting service.

 

When someone fills in a form the data is stored on the mysql database on the hosting service's server. You can set up another PHP page with a password that only you know to read the data from the database from there on a webpage or go into your hosting service control panel and read the database directly. You can then export the database from the hosting service (say at regular intervals) back onto your computer to overwrite the database or export it in another format, like Excel.

 

http://www.wickham43.net/formphptomysql.php

Edited November 1, 2010 by Wickham