php& Linux hosting & MySQL server: download MySQL first or buy hosting first?
Hello. My question is about creating a simple site with php & MySQL database and several simple webpages.
What is the way to do that?
METHOD #1
1) buy cheap space on linux/unix server with MySQL (no more than per several months – is it possible?)
2) create a Table there in the database on that server
3) practice in writing web-pages using Notepad and html, php languages with sql queues to that database (using Internet if I don’t know how to do that).
OR
METHOD#2
1) set up an emulator of server on my computer (My desktop has Windows XP)
2) Download MySQL as well.
3) Set it up together
4) practice in writing web-pages using Notepad and html, php languages with sql queues to that database
5) buy hosting and upload everything to the server.
Does method 1 really works? Or programmers and developers usually use the second method?
Thank you.
Sorry for this quesion, I’m new to that.
Tagged with: amp • cheap space • developers • emulator • languages • Linux • notepad • programmers • queues • unix • unix server • Using Internet • web pages • windows xp
Filed under: Web Hosting
Like this post? Subscribe to my RSS feed and get loads more!
Yes method 1 will work. But method 2 is better because you don’t have to keep re-uploading your files every time you make a change while you’re building your site.
Instead of downloading Apache/PHP/MySQL separately, I suggest you download a binary package called WAMP. (Apache + PHP + MySQL for Windows). Its a great free program and it takes less than 5 minutes to set up.
http://www.wampserver.com/en/
Your webpage files will be in C:/wamp/www and the address of your "website" will be http://localhost
Once you are ready to publish your site to the web, you can get great hosting for a low price. My personal favorite is x10hosting.
http://x10hosting.com/premium.php
The simpliest method is to install it all on your local PC, or set aside another PC for the task.
http://www.wampserver.com/en/download.php
This package has everything you need to experiment with php & mysql
Once you have taught yourself how to do stuff then you can experiment with a web host, why spend money uneccessarily on a web host before you can use the technology.
I would develop everything locally first (method #2).
No reason to spend money for something that you aren’t ready to use yet. (There are free ad-free servers that support mysql databases and php out there by the way).
Download Apache for Windows and install it on your machine. Set it up so that its just for tests (no one else can access it). Install PHP and MySQL too. This actually isn’t too hard to do.
Depending on how you set it up, you test site files will probably need to go in c:\program files\apache\htdocs. The MySQL server will be running as a service.
You can export and import the database to the new server as well as copy the files.
By the way, here are all the links:
http://www.x10hosting.com – free hosting with database and php, no ads
http://www.ibiblio.org/pub/mirrors/apache/httpd/binaries/win32/apache_2.2.14-win32-x86-no_ssl.msi – windows install for apache
http://windows.php.net/downloads/releases/php-5.3.1-nts-Win32-VC9-x86.msi – php for windows
Tutorial on installation of all three:
http://www.php-mysql-tutorial.com/wikis/php-tutorial/installing-php-and-mysql.aspx
Hope this helps!
If you’re new to the world of servers, databases, PHP and SQL, I think that your proposed "method #2" would let you develop some skills without spending much (or any?) money. Then, when you do buy that server space, you’ll be ready to go.
Have you got an extra computer lying around? Put a Linux server on it, and install MySQL server. Stick it on your home LAN. You’ll have a very authentic mini-Internet completely under your control for learning, development and debugging.
Do you really intend to pass such an expensive and complicated process? You should know your site would be unavailable whenever your PC is turned off, and you’re leaving yourself open to attacks. So I recommend get a reliable company to do that in return for a few dollars.
As an experienced webmaster I recommend BH web hosting which I’m sure it would work for you and fulfill all your requirements. They have a really great offer for hosting & I have used them for over 3 yrs now, and have never had a single problem with them.
You can reach reviews about this web hosting provider and its latest DISCOUNT COUPONS at:
http://www.threehosts.com/reviews/1st
Only $3.95 /month.
******IMPORTANT********
* This service was awarded “The Best Web Host Of The Year”.
* If you sign up for this service you will have $75 credits to advertise your website with the google & yahoo search engines for free!
* You Can Register A Free Domain or Use Your Existing Domains. They Support All Domain Names.
****************************
Hope this helps.