I installed a program called EasyPHP because it was an easy install and I wanted to be able to learn php and still be able to down the road learn MySQL. But I can't figure out how to use MySQL. Does anyone out there use this program that could tell me alittle about it. Alot of the product site is written in a different language, but everything on the program is english so that is good. Any help would be appreciated.

Reply

The bundle should have installed mysql with the software. One way of checking is to create a new file, and see if everythings set up in your php.ini settings. Simply put this file in the /www/ directory that your localhost (127.0.0.1) points to.


Scroll down through it and see if mysql has a section in there. If so, php is configured. You can also look through your services to see if mysql has been installed on your system.
Start->Run->services.msc
Scroll through that and see if mysql is running (or look in your processes by using alt+ctrl+delete). After that you're probably in business. It would have asked you for a user name and password for mysql database, just use those when you access it.

If you're not very strong in SQL, I would recommend finding a package that has phpMyAdmin with it so you can have a GUI and very friendly environment to work with. Here's a list of other packaged web servers.

Taken from http://www.flash-db.com/Board/index.php?bo...y;threadid=2926

If you're wanting to learn sql then I suggest http://www.htmlgoodies.com/beyond/php/ and scroll down to where you see the introductory to databases. There's better resources, but you should be able to understand these tutorials/primers well enough to get the jist of everything. Once you get the hang of it you can try more advanced guides.

 

 

 

Reply

Google on xampp. It is a bundled package containing Apache, Mysql, Php, Perl, phpadmin , mercurymail, and a whack of other stuff. I installed it about a month ago. No problems.

Reply

Yes I agree XAMPP is great I have been using it for at least three years now WAMP is also good, I do not know alot about easyphp but to test your MySQL install, since apparently you have not made any changes to your MySQL server yet copy and place this in your web root directory if it is www then put it there, or the place where you placed the phpinfo code earlier mentioned. This file will connect to your MySQL server and show its status. Name the file mysql.php as shown in the comment of the file then point your browser to your localhost and that file and you should see a table with all kinds of stuff about your MySQL install, or you will get an error.

Reply

There's nothing wrong with EasyPHP at all, I use it for testing and even for some users to access tests of some of my site and general script building.

It has PHP, MySQL, Apache and PHPMyAdmin all bundled and is quite easy to use. Once you have EasyPHP started try going to http://localhost in your browser.

If you are building up a site try putting it into the WWW folder of EasyPHP for example: PathToEasyPHP/WWW/YourSite.

If you have an index.htm, .html or .php then just simply put in your browser http://localhost/YourSite and it should go directly to the main page. This way you can also have many different sites set up.

If you need any help learning PHP and MySQL I might be able to help you out, I'll also keep an eye out for some good sites for learning, search Google for PHPFreaks, I visit there quite often and they are very helpful.

EDIT: Also if you do end up learning PHP, do some searching on the include command of PHP it is very usefull, much like using borderless iframes but it injects the source of the file directly at that point.

Reply