Running MySQL with IIS + PHP
 

I'm somehwhat a noob. I installed MySQL on my local machine with PHP. What do I need to do or configure MySQL to get it start storing values and what not? I probably should install phpmyadmin right?

<?php phpinfo(); ?

and see for yourself if everything is installed correctly ...

phpMyAdmin is a front-end for your database, it can idd come in handy

Yeah I already did that and PHP is working :P .

Here's what it says for MySQL..

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.49

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout -1 -1
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32

Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited

You'll need:

1. A place to store the data. That is, MySQL is the program, but you need data files/tables/colums. If you'r doing this all via command line, that's create, but I'd definitely recommend a GUI to do this.

2. A way for PHP to get to the data. This means creating ODBC connections. Then, you'll need to code so your PHP to get access to read/write to the database files. I'd recommend doing this in a include file as a separate procedure, so that you can do includes on your working PHP pages, rather than rewriting every time.

3. You'll need this link:

http://www.mysql.com/documentation/index.html

Also, look at possibly downloading the MySQL Control Center. It'll help on the db side to keep thing under control.

Thought someone should write about how to connect. Hell, I'm bored and hopefully someone will find it useful!
You can use 'mysql_fetch_array' to get the column names into things like $row['surname'], or use 'mysql_fetch_row' to end up with $row[1] etc... which can be a bugger to debug.

Hope that's of some use

Actually you don't need to do anything with ODBC for getting php to work with mysql, it has native mysql connectivity.

See cliche's post. The best PHP site is.... www.php.net. Most of the functions will have tutorials and user comments, read 'em.
Look up these mysql functions in the function list:
mysql_connect
mysql_select_db
mysql_query
mysql_fetch_array/row/assoc

If you don't know anything about SQL, you'll have to read up on that as well (mysql.com would probably be the best place)

phpMyAdmin is probably the way to go for creating your database structure.