<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 8:  MySQL APIs 539 8  MySQL APIs This chapter describes the APIs available for MySQL, where to get them, and how to use them.  The C API is the most extensively covered, as it was developed by the MySQL team, and is the basis for most of the other APIs. 8.1  MySQL PHP API PHP  is  a  server-side,  HTML-embedded  scripting  language  that  may  be  used  to  create dynamic web pages.  It contains support for accessing several databases, including MySQL. PHP may be run as a separate program or compiled as a module for use with the Apache web server. The distribution and documentation are available at the PHP web site (http://www.php.net/ 8.1.1  Common Problems with MySQL and PHP    Error:    "Maximum  Execution  Time  Exceeded"  This  is  a  PHP  limit;  go  into  the `php3.ini' le and set the maximum execution time up from 30 seconds to something higher, as needed.  It is also not a bad idea to double the ram allowed per script to 16MB instead of 8 MB.    Error:   "Fatal  error:   Call  to  unsupported  or  unde ned  function  mysql connect()  in .." This means that your PHP version isn't compiled with MySQL support.  You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support.  This is described in detail in the PHP manual.    Error:   "unde ned  reference  to  `uncompress'"  This  means  that  the  client  library  is compiled with support for a compressed client/server protocol.  The x is to add -lz last when linking with -lmysqlclient. 8.2  MySQL Perl API This section documents the Perl DBI interface.  The former interface was called mysqlperl. DBI/DBD now is the recommended Perl interface, so mysqlperl is obsolete and is not docu- mented here. 8.2.1  DBI with DBD::mysql DBI is a generic interface for many databases.  That means that you can write a script that works with many di erent database engines without change.  You need a DataBase Driver (DBD) de ned for each database type.  For MySQL, this driver is called DBD::mysql. For more information on the Perl5 DBI, please visit the DBI web page and read the docu- mentation:
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide