Chap 4 of Build your own Database Driven Web Site

[KMurray2]

I'm getting this error, I'm on page 120 of Chap 4:

Fatal error: Call to undefined function mysqli_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\connect\index.php on line 2

I can sign in MySQL console with my password so I know I typed in the right password. I checked C:\download\Wampserver\php\php.ini to ensure mysqli_connect was not commented out. Can anyone tell me what I'm doing wrong? Below is the output for: <?php phpinfo(); ?>


PHP Version 5.2.12

System Windows NT CDLW079 5.1 build 2600
Build Date Dec 16 2009 17:01:16
Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" "--without-pi3web"
Server API Apache 2.0 Handler
Virtual Directory Support enabled
Configuration File (php.ini) Path C:\WINDOWS
Loaded Configuration File C:\download\Wampserver\php\php.ini
Scan this dir for additional .ini files (none)
additional .ini files parsed (none)
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety enabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*

[KMurray2]

I edited php.ini and I received my Database connection established!!

[SpacePhoenix]

In your php.ini file does the line

extension=php_mysqli.dll

have a ; at the beginning of it?

[KMurray2]

I had to change the path to the directory in which the loadable extensions (modules) reside. I didn't have the path c:\php

[JasonHenry]

Hi, I am have the same issue as the original poster, but none of the suggestions has resolved the issue.

I recently purchased the book Build Your Own Database Driven Web Site Using PHP & MySQL and have become stuck with the error:
Call to undefined function mysqli_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\connect\index.php on line 2

I am running Windows Vista x64 w/ Apache 2.2.14 and PHP 5.2.13 and MySQL 5.1.44.

Here are my checks:

1) MySQL process is running in Win
2) Apache is running with PHP
3) php.ini is correct in phpinfo()
4) php.ini => extension=php_mysqli.dll has no (;) preceeding it
5) php.ini => extension_dir = "C:\PHP\ext" is pointing correctly

Here is the code being executed:

<?php
$link = mysqli_connect('localhost', 'root', 'nathaniel');
if (!$link)
{
$output = 'Unable to connect to the database server.';
include 'output.html.php';
exit();
}
if (!mysqli_set_charset($link, 'utf-8'))
{
$output = 'Unable to set database connection encoding.';
include 'output.html.php';
exit();
}
if (!mysqli_select_db($link, 'ijdb'))
{
$output = 'Unable to locate the joke database.';
include 'output.html.php';
exit();
}

$output = 'Database connection established.';
include 'output.html.php';
?>


I may try to continue with book using my remote host, but what will I have learned?

Thanks in advance.

[JasonHenry]

Besides a typo of 'utf-8' I still haven't figured it out.

I have installed WAMP and with this I have gotten the script to run successfully.

But this problem will nag me...leave no man behind.

[SpacePhoenix]

Which version of php did you install? There is a note about the versions on the corrections and typos page for the book:

Although this book provides download and installation instructions for PHP 5.2, the newly-released (at the time of this writing) PHP 5.3 includes some new download options that aren’t covered in the book.
There are four different versions of PHP 5.3. for Windows: VC6 Non Thread Safe, VC6 Thread Safe, VC9 Non Thread Safe, and VC9 Thread Safe. Talk about confusing!
First of all, you definitely want a Thread Safe version of PHP. The Non Thread Safe versions are not suitable for use as a plugin for Apache.
Secondly, assuming you will install (or have already installed) a version of the Apache HTTP Server from httpd.apache.org (see page 13), you will need the VC6 version of PHP.
In short, to follow the instructions in this book, you need the VC6 Thread Safe version of PHP 5.3 for Windows.

[JasonHenry]

I am running Windows Vista x64 w/ Apache 2.2.14 and PHP 5.2.13 and MySQL 5.1.44.

I have not checked that section of the site yet. I don't think that is an issue as I am using ver. 5.2. But I really don't know, that's why I'm here.

WAMPSERVER 2.0 installed and is using a flavor of 5.3 - which allows the script to run successfully. I installed this after my issue.

Thanks for responding.

[Yahel Armster]

Hi there!
i'm stuck on the same page, same code, exept for this:
dreamweaver doesn't recognize mysqli_set_charset, nor does my browser, it gives me this error:
Notice: Undefined variable: output in C:\wamp\www\connect\output.html.php on line 9

now this is my code...

for index.php

<?php
$link = mysqli_connect('localhost', 'root', 'mischa1938');
if (!$link)
{
$output = 'Unable to connect to the database server, please try again later.';
include 'output.html.php';
exit();
}
if (!mysqli_set_charset($link, 'utf8'))
{
$output = 'Unable to set database connection encoding.';
include 'output.html.php';
exit();
}
if (!mysqli_select_db($link, 'ijdb'))
{
$output = 'Unable to locate the jokes database.';
include 'output.html.php';
exit();
}
$outpu = 'Database conection established.';
include 'output.html.php';
?>

for output.html.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Output</title>
</head>
<body>
<p>
<?php echo $output; ?>
</p>
</body>
</html>

what seems to be wrong?

[Yahel Armster]

Hi there!
i'm stuck on the same page, same code, exept for this:
dreamweaver doesn't recognize mysqli_set_charset, nor does my browser, it gives me this error:
Notice: Undefined variable: output in C:\wamp\www\connect\output.html.php on line 9

now this is my code...

for index.php

<?php
$link = mysqli_connect('localhost', 'root', 'mischa1938');
if (!$link)
{
$output = 'Unable to connect to the database server, please try again later.';
include 'output.html.php';
exit();
}
if (!mysqli_set_charset($link, 'utf8'))
{
$output = 'Unable to set database connection encoding.';
include 'output.html.php';
exit();
}
if (!mysqli_select_db($link, 'ijdb'))
{
$output = 'Unable to locate the jokes database.';
include 'output.html.php';
exit();
}
$outpu = 'Database conection established.';
include 'output.html.php';
?>

for output.html.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Output</title>
</head>
<body>
<p>
<?php echo $output; ?>
</p>
</body>
</html>

what seems to be wrong?

fricking t...

[Log1c]

i have the same problem JasonHenry but im on

winxp pro / apache 2.2.14 / php 5.2.12 / mysql 5.1.43

anyone figure this one out?

[JasonHenry]

i have the same problem JasonHenry but im on

winxp pro / apache 2.2.14 / php 5.2.12 / mysql 5.1.43

anyone figure this one out?

I never figured it out. I updated to the thread safe version of PHP 5.3 and triple checked everything and still no go. I installed Wampserver 2.0 inplace of the individual parts and so far smooth sailing.

[Log1c]

idk what the problem was but i fixed it. i updated to php 5.3.2 VC6 (thread safe) and mysql 5.1.44. i also changed my pw for mysql, had some #@ symbols, but i dont think that did anything. but it works now!