Running MySQL with IIS + PHP - Tilted Forum Project Discussion Community

Jesus Pimp · 04-05-2004, 09:07 PM

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?

Cuball · 04-06-2004, 12:49 AM

<?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

Jesus Pimp · 04-06-2004, 05:39 AM

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

JohnnyRoyale · 04-06-2004, 05:49 AM

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.

cliche · 04-06-2004, 10:30 AM

Thought someone should write about how to connect. Hell, I'm bored and hopefully someone will find it useful!

Code:

$link = mysql_connect("localhost", "<user>", "<password>") or die("Could not connect");
mysql_select_db("<Database Name>") or die("Could not select database");
$result = mysql_query("SELECT * FROM <table> WHERE <whatever>",$link);
while ($row = mysql_fetch_array($result)) {
   <do stuff with the row>
}

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

MrFlux · 04-07-2004, 02:49 AM

Quote:

Originally posted by JohnnyRoyale

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.

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.

04-05-2004, 09:07 PM	#1 (permalink)
Jesus Pimp The Original JizzSmacka	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? __________________ Never date anyone who doesn't make your dick hard.

04-06-2004, 12:49 AM	#2 (permalink)
Cuball Insane Location: Belgium	<?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 __________________ Let's GO

04-06-2004, 05:39 AM	#3 (permalink)
Jesus Pimp The Original JizzSmacka	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 __________________ Never date anyone who doesn't make your dick hard.

04-06-2004, 05:49 AM	#4 (permalink)
JohnnyRoyale Psycho Location: Boston, MAss., USA	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. __________________ I'm gonna be rich and famous, as soon I invent a device that lets you stab people in the face over the internet.

04-06-2004, 10:30 AM	#5 (permalink)
cliche Rookie Location: Oxford, UK	Thought someone should write about how to connect. Hell, I'm bored and hopefully someone will find it useful! Code: $link = mysql_connect("localhost", "<user>", "<password>") or die("Could not connect"); mysql_select_db("<Database Name>") or die("Could not select database"); $result = mysql_query("SELECT * FROM <table> WHERE <whatever>",$link); while ($row = mysql_fetch_array($result)) { <do stuff with the row> } 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 __________________ I can't understand why people are frightened of new ideas. I'm frightened of the old ones. -- John Cage (1912 - 1992)