PHP Windows Installation

Gregoo

Alright, this is going to sound really dumb, but I'm having trouble with my windows PHP/MySQL. I have a few years experience with ColdFusion, so I'll do OK once I get the basics figured out. I ran the windows installer. I believe I have 4.3 installed. I've run through some of the kindergarten tutorials. But now I get to the tutorial on Creating a PHP login script and it's assuming I know all kinds of things like how to create a frigging batabase in the MySQL that I installed. It doesn't appear there's an user interface for MySQL built in, so I installed MyAdmin. But I can't seem to configure that.

This tutorial tells me to put in my username, pw, dbhost, and db name. I have no idea where to start!

cgraz

well ou gotta connect to your database. you can do this through php

<?

// connect to server
mysql_connect("server", "username", "password") or die(mysql_error());

// select database
mysql_select_db("database_name") or die(mysql_error());

// rest of code here

?>

You can always search google or even this board for php + mysql + tutorials. There are a lot of really good ones out there that will help get you started.

Cgraz

mystrymaster

Go get the gui for interacting with MySQL aat mysql.com it is real nice in the windows environment

Gregoo

OK, I tried the control panel. It looks nice. I created a db called php_users and set host as "localhost", left username as root, and no password. Whe I try to connect to this new db it says "Can't connect to mysql server on localhost (10061)

cgraz

can you post code?

Cgraz

cgraz

Sorry, I hadn't seen your pm. Try this

<?

// connect to server
mysql_connect("localhost", "root", "") or die(mysql_error());

// select database
mysql_select_db("php_users") or die(mysql_error());

// rest of code here

?>

If you don't get any errors, then it properly connected.

MySQL is just a command-line. If you want a graphical user interface you'll need to donwload one, but in my opinion it's better to just learn the code. When i started, I wanted a GUI also and even tried a few, but I'm glad I just learned the code. It's not very difficult, you just can't let yourself get intimidated at first.

My first book to intro me to php and mysql was "PHP and MySQL Web Development" By Luke Welling and Laura Thomson. Pretty good book. You may consider going to your local bookstore and flipping through the pages to see what you think.

Cgraz