RE: Using MySQL with PHP

["Blanton, Bob" <BlantonB@xxxxxxxxxxxxx>]

Donatas,

  When running the phpinfo() I get this below for the mysql section.

  I copied the libmysql.dll to the windows directory as some of the instructions had said.  This is the library that is lets php talk to mysql. 

  I am running php 5, mysql 5, and apache 1.3.  I am successfully using mysql with the administrator and workbench modules of mysql.  I am trying to perform

a db connection from one of the on-line tutorials and I can’t get a db connection.  See my code below

 

mysql

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

 

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	localhost	localhost
mysql.default_password	mysql	mysql
mysql.default_port	3306	3306
mysql.default_socket	no value	no value
mysql.default_user	root	root
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

 

//this works fine

<?php

phpinfo();

?>

 

//this does not work

<?php

// Connecting, selecting database

echo 'Trying to Connect...';                                  //last line executed

$link = mysql_connect('flms', 'userid', 'password')  //appears to stop here

   or die('Could not connect: ' . mysql_error());

echo 'Connected successfully';

mysql_select_db('flms') or die('Could not select database');

 

// Performing SQL query

$query = 'SELECT * FROM allow';

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

 

// Printing results in HTML

echo "<table>\n";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

   echo "\t<tr>\n";

   foreach ($line as $col_value) {

       echo "\t\t<td>$col_value</td>\n";

   }

   echo "\t</tr>\n";

}

echo "</table>\n";

 

// Free resultset

mysql_free_result($result);

 

// Closing connection

mysql_close($link);

?>

 

 

---

From: Donatas Vyzas [mailto:donatas@xxxxxxxxxxxxxxx]
Sent: Saturday, May 27, 2006 2:32 PM
To: php-install@xxxxxxxxxxxxx
Subject: Re: Using MySQL with PHP

 

Hi,
MySQL support might be already available in your PHP. You can check that using phpinfo ( http://www.php.net/manual/en/function.phpinfo.php ). If you see MySQL section in the output of phpinfo() -  you already have MySQL support, if no - you have to recompile PHP with the following parameters to your configure script:

 --with-mysql[=DIR]      Include MySQL support. DIR is the MySQL base directory
  --with-mysql-sock[=DIR]   MySQL: Location of the MySQL unix socket pointer.
                            If unspecified, the default locations are searched

Donatas Vyzas

Blanton, Bob wrote:

Hi,

  If I want to use MySQL with PHP do I need to re-compile PHP or can I just adjust the php.ini file to use MySQL? 

 

Thanks in advance.

Bob