SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Sep 2007
    Location
    Toronto/Whitby ON Canada
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL or MySQLi?

    quick question,

    i have been reading that post MySQL 4 I should be using ext/MySQLi with php but when it comes time to take my site out of development and pay for a shared hosting plan (not much control over server settings) how will i know the host is not using ext/mysql only? or is it more likely that they will have both enabled at this point in time? or is it as simple as enabling it with .htaccess? im lost, so i appreciate any response.

    thanks,
    andy

  2. #2
    SitePoint Enthusiast jcarouth's Avatar
    Join Date
    Sep 2006
    Location
    College Station, TX
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's not as simple as enabling mysqli in an .htaccess file, unfortunately. php must be compiled with support for mysqli

    as far as how you will know if the host has mysqli support compiled in, well, ask them.

  3. #3
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    16,430
    Mentioned
    160 Post(s)
    Tagged
    1 Thread(s)
    You may not have much control over whether a host offers it, but you have conrol over which host you use. I imagine most do have it, but you should check before you commit.
    Or you could use a "DB" class that is portable to whatever database is available.

  4. #4
    hi galen's Avatar
    Join Date
    Jan 2006
    Location
    New Haven, CT
    Posts
    1,228
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    every decent host will have mysqli and pdo available


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
  •