Access database and php :(

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Katie

    Access database and php :(

    Hi all,

    I'm a genetic student at uni, and am doing a final year web project.

    But I have a problem. I've found a web hosting place, and in the site
    have created a microsoft access database. But for the life of me I
    can not find out how to connect and input data using php! There seems
    to be not tutorials on the internet :(

    Basically I have a response form, people fill it in and hit submit
    then the data is stored in the database.

    I'm thinking using php, would it be easier to use another language,
    e.g. asp?

    Can anyone help me with this? - point me towards any
    information/tutorials or suggest some code etc to connect and input
    data into a access db?

    I'm really stuck and the deadline is comming quite close :(

    Any help would be so much greatly be appreciated!

    Thanks for reading, Katie x
  • Manuel Lemos

    #2
    Re: Access database and php :(

    Hello,

    On 03/14/2004 11:42 PM, Katie wrote:[color=blue]
    > I'm a genetic student at uni, and am doing a final year web project.
    >
    > But I have a problem. I've found a web hosting place, and in the site
    > have created a microsoft access database. But for the life of me I
    > can not find out how to connect and input data using php! There seems
    > to be not tutorials on the internet :(
    >
    > Basically I have a response form, people fill it in and hit submit
    > then the data is stored in the database.
    >
    > I'm thinking using php, would it be easier to use another language,
    > e.g. asp?
    >
    > Can anyone help me with this? - point me towards any
    > information/tutorials or suggest some code etc to connect and input
    > data into a access db?[/color]

    If you are using Windows hosting you can use ODBC to connect to MS
    Access databases.

    In that case you may also use this database API that has MS Access
    drivers using ODBC and comes with a tutorial:



    --

    Regards,
    Manuel Lemos

    PHP Classes - Free ready to use OOP components written in PHP


    PHP Reviews - Reviews of PHP books and other products


    Metastorage - Data object relational mapping layer generator

    Comment

    • Geoff Berrow

      #3
      Re: Access database and php :(

      I noticed that Message-ID:
      <cb27234c.04031 41842.5b9a94d1@ posting.google. com> from Katie contained
      the following:
      [color=blue]
      >Basically I have a response form, people fill it in and hit submit
      >then the data is stored in the database.[/color]

      If the webspace has MySql and phpMyAdmin you may find it easier to use
      these.

      --
      Geoff Berrow (put thecat out to email)
      It's only Usenet, no one dies.
      My opinions, not the committee's, mine.
      Simple RFDs http://www.ckdog.co.uk/rfdmaker/

      Comment

      • R. Rajesh Jeba Anbiah

        #4
        Re: Access database and php :(

        katie_robertson _180@hotmail.co m (Katie) wrote in message news:<cb27234c. 0403141842.5b9a 94d1@posting.go ogle.com>...[color=blue]
        > Hi all,
        >
        > I'm a genetic student at uni, and am doing a final year web project.
        >
        > But I have a problem. I've found a web hosting place, and in the site
        > have created a microsoft access database. But for the life of me I
        > can not find out how to connect and input data using php! There seems
        > to be not tutorials on the internet :([/color]

        I wonder, what was your search keywords?

        1. http://www.google.com/search?q=php+access+database
        2. http://www.google.com/search?q=php+MS+access+database
        3. http://webokay.net/~siddarth/Main.html
        4. http://in2.php.net/manual/en/ref.odbc.php
        5. http://in2.php.net/manual/en/ref.dbx.php

        --
        "Democracy: Where all citizens are politicians and all politicians are citizens"
        Email: rrjanbiah-at-Y!com

        Comment

        • Katie

          #5
          Re: Access database and php :(

          Hi

          Thanks for all your responses. I researched asp up and it seems so
          much easeir. Unfortunatly I can not do an mysql database but I've
          information for the asp and example scripts and explanations on all
          the functions off of web wizrd I think it was called.

          Thats for helping, Katie xx

          Comment

          • Tim Van Wassenhove

            #6
            Re: Access database and php :(

            On 2004-03-17, Katie <katie_robertso n_180@hotmail.c om> wrote:[color=blue]
            > Hi
            >
            > Thanks for all your responses. I researched asp up and it seems so
            > much easeir. Unfortunatly I can not do an mysql database but I've
            > information for the asp and example scripts and explanations on all
            > the functions off of web wizrd I think it was called.[/color]

            You could connect to you mysql db through odbc.

            --

            Comment

            Working...