caseycasey Posted October 31, 2010 Report Share Posted October 31, 2010 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? Quote Link to comment Share on other sites More sharing options...
Andrea Posted October 31, 2010 Report Share Posted October 31, 2010 Usually, all your files are uploaded to your hosting account - unless you were to use your own computer as a server. Quote Link to comment Share on other sites More sharing options...
caseycasey Posted November 1, 2010 Author Report Share Posted November 1, 2010 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 Quote Link to comment Share on other sites More sharing options...
Wickham Posted November 1, 2010 Report Share Posted November 1, 2010 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.