SitePoint Sponsor

User Tag List

Results 1 to 13 of 13
  1. #1
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Chap 4 of Build your own Database Driven Web Site

    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.*

  2. #2
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I edited php.ini and I received my Database connection established!!

  3. #3
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,072
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    In your php.ini file does the line

    extension=php_mysqli.dll

    have a ; at the beginning of it?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  4. #4
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I had to change the path to the directory in which the loadable extensions (modules) reside. I didn't have the path c:\php

  5. #5
    SitePoint Member JasonHenry's Avatar
    Join Date
    Feb 2010
    Location
    Minnesota, USA
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  6. #6
    SitePoint Member JasonHenry's Avatar
    Join Date
    Feb 2010
    Location
    Minnesota, USA
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  7. #7
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,072
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    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.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  8. #8
    SitePoint Member JasonHenry's Avatar
    Join Date
    Feb 2010
    Location
    Minnesota, USA
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by JasonHenry View Post

    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.

  9. #9
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?
    The Hec-meister

  10. #10
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Yahel Armster View Post
    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...
    The Hec-meister

  11. #11
    SitePoint Member
    Join Date
    Mar 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?

  12. #12
    SitePoint Member JasonHenry's Avatar
    Join Date
    Feb 2010
    Location
    Minnesota, USA
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  13. #13
    SitePoint Member
    Join Date
    Mar 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •