1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Rep Power
    A total newbie to this, Im an ASP web developer, looking to switch to PHP. I installed PHP only last night. Now as i understand it you can php on any odbc compliant database. What would be the point of using access if the php hosting company dont support it. I presume that mysql is the database to use.
    Where can i find it.
    Has it got an interface.
    does it come with php
    can php connect using a dsn-less conection (no odbc setup)

    i know its lots of questions but this is my first day with php

    Any help would be great

  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    I'm something of a newbie myself, but I think I can help. You can get the latest mySQL database from www.mysql.com, though you should really try to find it from a mirror near you. It doesn't have a GUI in the windows sense. It has a CLI that runs in DOS. PHP 4.0 has support for mysql built in so you shouldn't need any funny .dll's. However, if you want to hook mySQL up to ODBC look for a little number named myODBC, as I understand this will allow you to import records from mysql into an access database. There's a killer book about mySQL by Paul Dubois (I found it a copy at CompUSA for 15 bucks PHP and mySQL are like coffee and donuts.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    SLC, UT, USA
    Rep Power
    Just a suggestion but you might want to look into Linux or Unix to run MySQL on.

    The best configuration is Apache webserver on a Linux/Unix box.

    PHP is a module that you compile into Apache.

    Get PHP separately from http://www.php.net/
    Get MySQL from http://www.mysql.com/
    Get Apache from http://www.apache.org/

    The basic procedure is to build PHP with support for MySQL and then build Apache with the mod_php module.

    There's an excellent article here at devshed that explains how to do it pretty well, there's another article at webmonkey and some at phpbuilder.com too.

  6. #4
  7. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power
    Actually there are several graphical interfaces to MySQL available as third-party apps. Just browse the links at the www.mysql.com site.

    My personal favorite interface to MySQL is a web-based admin kit called phpMyAdmin (uses PHP, of course). You can get it at www.phpwizard.net. It will work under windows or Unix/Linux, although generally faster in a *nix environment.


Similar Threads

  1. Replies: 0
    Last Post: November 27th, 2003, 08:04 PM
  2. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM
  3. MySQL "TIME" Problem w/ ASP
    By cshontz in forum ASP Programming
    Replies: 5
    Last Post: June 27th, 2003, 06:07 AM
  4. MySQL "TIME" Problem w/ ASP
    By cshontz in forum MySQL Help
    Replies: 1
    Last Post: June 25th, 2003, 11:47 AM
  5. mysql date to asp page to mysql
    By Bob in forum MySQL Help
    Replies: 0
    Last Post: December 24th, 1999, 02:18 PM

IMN logo majestic logo threadwatch logo seochat tools logo