[RESOLVED] Basic MySQL/PHP Integration

[sunil28]

I'm using PHP 5.2.5, MySQL 5.0.51b-community-nt and a WinXP machine.
I'm trying to use MySQL using PHP commands, but I can't even get the simplest PHP/MySQL commands
to work. For example here's code from Sams TYS PHP in 24 hours, pg 249:

<?php
$conn = mysql_connect("localhost", "joeuser", "somepass");
echo $conn;
mysql_close($conn);

$user = "p24_user";
$pass = "pass";
$db = "p24";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
die( "Couldn't connect to MySQL: ".mysql_error() );
}
print "<h2>Successfully connected to server</h2>\n\n";
mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
print "Successfully selected database \"$db\"<br />\n";
mysql_close( $link );
?>

I tried running the above code and nothing happens.

I've already tried replacing $pass variable with my password and tried using differenct pathnames to the DB files,
but nothing works.

I've just started learning PHP. Things were fine until I started using MySQL.
I have no problem using MySQL from the command line, but integrating MySQL with PHP has been a problem.
Could the problem be in the php.ini file? I don't know. Maybe someone out here knows.

[NogDog]

Try starting with one step at a time, building as you go along once you get the current part working.

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

$conn = mysql_connect("localhost", "joeuser", "somepass");
if($conn == false)
{
   echo "Connection failed: " . mysql_error();
}
else
{
   echo "Connection OK";
}
?>

If that fails and the problem is not apparent to you, copy and paste the exact error message here so we can try to help.

[cahva]

You say that nothing happens so are you getting a blank screen? Then check your error log to see what is happening. What does phpinfo() function say? Does it show that you have installed mysql driver for php?

[sunil28]

cahva;10881237 wrote:

You say that nothing happens so are you getting a blank screen? Then check your error log to see what is happening. What does phpinfo() function say? Does it show that you have installed mysql driver for php?

Yes I get a blank screen. phpinfo() works fine.
I've got MySQL installed, but MySQL driver? Don't know. I've looked in my php.ini file
and edited it to read:
;Path the MySQL
./configure --with-mysql=C:\Program Files\MySQL\MySQL Server 5.0\bin\

but it doesn't help.

I don't get it. Am I just clumsy, or is getting php to work with MySQL really hard? I'm learning PHP on my own using SAMS TYS PHP in 24 Hours by Matt Zandstra.

BTW I copied the libmysql.dll to the windows system directory to see if that would help. It hasn't.

[sunil28]

NogDog;10881236 wrote:

Try starting with one step at a time, building as you go along once you get the current part working.

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

$conn = mysql_connect("localhost", "joeuser", "somepass");
if($conn == false)
{
   echo "Connection failed: " . mysql_error();
}
else
{
   echo "Connection OK";
}
?>

If that fails and the problem is not apparent to you, copy and paste the exact error message here so we can try to help.

Did it. Here's the message I got:

Fatal error: Call to undefined function mysql_connect() in D:\htdocs\TYS PHP in 24 Hours\sqltest.php on line 14

[NogDog]

Sounds like the PHP mysql extension is not completely configured/running. Check out these threads:
http://phpbuilder.com/board/showthread.php?t=10246585
http://phpbuilder.com/board/showthread.php?t=10340995

[bradgrafelman]

Also note that the [man]mysql[/man] library of functions has been deprecated in favor of [man]MySQLi[/man] (or even [man]PDO[/man]).

[sunil28]

bradgrafelman;10881265 wrote:

Also note that the [man]mysql[/man] library of functions has been deprecated in favor of [man]MySQLi[/man] (or even [man]PDO[/man]).

I've added the following lines to my php.ini file:

--with-mysqli="C:\Program Files\MySQL\MySQL Server 5.0\mysql_config"
extension="C:\Program Files\PHP\php_mysqli.dll"

I've also copied the php_mysqli.dll and libmysql.dll to C:\Program Files\PHP
Should I restart my apache server? I tried that and it didn't work.
The path command shows PATH=C:\Program Files\php; and so on

But when I use the command 'PEAR version' I get the following error message:

C:\Documents and Settings\Owner>pear version
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\
ext\C:\Program Files\PHP\php_mysqli.dll' - The specified module could not be found.
in Unknown on line 0
PEAR Version: 1.7.2
PHP Version: 5.2.5
Zend Engine Version: 2.2.0

Still doesn't work. 😕

[bradgrafelman]

1. The "--with-mysqli=" line is only for building the PHP from source at the command line (e.g. on Unix systems, rarely done on Windows systems) - get rid of that.

2. The "extension=" line should match the others in php.ini - that is, it should simply contain the name of the file, e.g. php_mysqli.dll. The path to the extension files is taken from the extension_dir directive.

[sunil28]

Still doesn't work.

Here's part of my php.ini file:

extension_dir="C:\Program Files\PHP\ext"
;BTW there wasn't a ext directory. I had to create one and place the *.dll files there.
;But the extension_dir was.
extension=php_mysqli.dll

I then entered the following command at the DOS prompt:

C:\Documents and Settings\Owner>pear version

Here's the error message:

A windows error message box that said:

The procedure entry point mysql_slave_query could not be located dynamic link library LIBMYSQL.dll

then this error message at the DOS prompt:

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\
ext\php_mysqli.dll' - The specified procedure could not be found.
in Unknown on line 0
PEAR Version: 1.7.2
PHP Version: 5.2.5
Zend Engine Version: 2.2.0
Running on: Windows NT YOUR-AT5QGAAC3Z 5.1 build 2600

I then renamed the libmysql.dll to -libmysql.dll thinking that would help. It didn't

I then modified part of my php.ini file like this:

;extension=php_mysqli.dll
extension=libmysql.dll

I got the following error message at the DOS prompt where I reentered the pear version command:

C:\Documents and Settings\Owner>pear version
PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'libmysql.d
ll' in Unknown on line 0
PEAR Version: 1.7.2
PHP Version: 5.2.5
Zend Engine Version: 2.2.0
Running on: Windows NT YOUR-AT5QGAAC3Z 5.1 build 2600

I then modified my php.ini file to:
extension=php_mysqli.dll
extension=libmysql.dll

I got similar error messages.

Have I downloaded the wrong *.dll files?
I've used MySQL from the command line with no problems. And I haven't had any problem learning PHP until started using MySQL with PHP.
I also tried using SQLite, which is supposed to be bundled with PHP 5 and above, but no luck either.
Maybe I've got a poorly installed PHP?

[bradgrafelman]

sunil28 wrote:

BTW there wasn't a ext directory. I had to create one and place the *.dll files there.

Sounds like you used the MSI installer version of PHP. I've always recommended using the .zip download and manual installation process so that you know how everything is set up.

As for the extension directory itself, note that you should not move all DLL files into that folder - only PHP extensions (e.g. DLL files that start with "php_").

libmysql.dll is not a PHP extension (it's just a MySQL client library), so loading it as one isn't going to help. Where is libmysql.dll located? Is it in te main C:\Program Files\PHP\ folder?

[sunil28]

I've newly installed php 5.2.6 using php-5.2.6-Win32.zip.

I've copied php5ts.dll and libmysql.dll files to c:\windows\system32
They're also in the c:\php directory

In my php.ini file:

; Directory in which the loadable extensions (modules) reside.
;extension_dir = "./"
extension_dir = "c:\php\ext"

extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_sqlite.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
;extension=php_sockets.dll
;and so on

In my apache httpd.conf file:

#

DirectoryIndex: sets the file that Apache will serve if a directory

is requested.

#
#DirectoryIndex index.php
<IfModule dir_module>
DirectoryIndex index.html
</IfModule>

#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL
#PHPIniDir "C:/Program Files/PHP/"
PHPIniDir "C:/PHP/"
#LoadModule php5_module "C:/Program Files/PHP/php5apache2_2.dll"
LoadModule php5_module "C:/PHP/php5apache2_2.dll"
#END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL

Here's php file:

<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Listing 13.1 Opening a Connection to a Database</title>
</head>
<body>
<div>
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

$conn = "";

$conn = mysql_connect('localhost', 'root', 'ramuk35');
//Fatal error: Call to undefined function mysql_connect() in D:\htdocs\TYS PHP in 24 Hours\sqltest.php on line 15
if($conn == false)
{
echo "Connection failed: " . mysql_error();
}
else
{
echo "Connection OK";
}

//I also get a fatal error when using sqlite
$db = "d:\testdb";
$dbres = sqlite_open($db, 0666, $error) ;
//Fatal error: Call to undefined function sqlite_open() in D:\htdocs\TYS PHP in 24 ///Hours\sqltest.php on line 37
if ( ! is_resource($dbres) ){
die ("sql error: $error");
}

?>

I tested the php installation using phpinfo() and there were no problems.
What else haven't I done to solve this problem?

[bradgrafelman]

sunil28 wrote:

I've copied php5ts.dll and libmysql.dll files to c:\windows\system32

PHP-related .dll files (or any others, for that matter, other than .php scripts) should never be moved outside of the main PHP installation folder. Delete these extraneous copies.

Next, you should verify that PHP is correctly parsing the .ini file. Make some change (such as changing display_errors to On) in your php.ini file, restart Apache, and do a phpinfo(); if PHP doesn't show the directive's newly changed value, then PHP isn't reading your .ini file and that's the first problem you should tackle.

Also, have you verified that the main PHP directory was added to your system's PATH environment variable? Easy way to check this is to open a command prompt (Start -> Run -> cmd) and type 'path' (without the quotes) - "c:\php" should be somewhere in that list of directories.

[sunil28]

Now it works. I reset the path from c:\program files\php to c:\php
I previously the php editor I was using would still access c:\program files\php and not c:\php

But I'm still have problem with this piece of code:

$db = "d:\testdb";
$dbres = sqlite_open($db, 0666, $error) ;
//Fatal error: Call to undefined function sqlite_open() in D:\htdocs\TYS PHP in 24 Hours\sqltest.php on line 42
if ( ! is_resource($dbres) ){
die ("sql error: $error");
}

Any suggestions?

[NogDog]

Try either of the following (PHP will convert forward slashes to reverse slashes as needed for paths):

// either escape the backslash:
$db = "d:\\testdb";

// or else use a forward slash:
$db = "d:/testdb";

[sunil28]

NogDog;10885085 wrote:

Try either of the following (PHP will convert forward slashes to reverse slashes as needed for paths):

// either escape the backslash:
$db = "d:\\testdb";

// or else use a forward slash:
$db = "d:/testdb";

Tried both. Didn't work. Still got an error message:

Fatal error: Call to undefined function sqlite_open() in D:\htdocs\TYS PHP in 24 Hours\sqltest.php on line 42

It occurs on this line of my code:

$dbres = sqlite_open($db, 0666, $error);

[NogDog]

Sounds like the SQLLite extension is not installed/enabled?

[sunil28]

NogDog;10885204 wrote:

Sounds like the SQLLite extension is not installed/enabled?

Don't know. Here's part of my php.ini file:

; Directory in which the loadable extensions (modules) reside.
;extension_dir = "./"
extension_dir = "c:\php\ext"

extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_pdo.dll
extension=php_sqlite.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
;extension=php_sockets.dll
;and so on

I then use phpinfo() and the entry for mysql and mysqli appears, but no entry for sqlite. I also checked in the ext/php directory and all the php_*.dll files including php_pdo.dll and php_sqlite.dll are there.

[mcloide]

Hey I have a MySQL and MySQLi wrappers classes available. You can get them at:

http://mcloide.wordpress.com/2008/09/04/mysql-handler-class/

Have fun

mcloide.wordpress.com

[rokchik]

Get Xampp. http://www.apachefriends.org/en/xampp.html
It's a pre-built server, including Apache 2.2.9, php 5.2.6, MySQL 5.0.51b and everything else you might need for a development environment.
You can get a zipped version or an installer version; personally, I just use the unzipped version on my USB drive. That's all there is to it, btw; unzip it to the right place and it's installed.
You can get it for Windoze, Linux or even Mac OSX, and it needs minimal configuration (set up 2 passwords and you're ready to go).

Good luck!