34 users online (1 members and 33 guests)  


  Results 1 to 6 of 6

Related

  1. Replies: 0
  2. Replies: 1
  3. web form data import to ms access db    Forum: PHP Forum
    Replies: 2
  4. Replies: 2
  5. @import and netscape 6x    Forum: CSS Forum
    Replies: 1
  1. #1
    tarek990's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2004
    Posts
    3

    dat to mysql import - or redirect authorization

    hello everyone..

    my users are signing up in a cgi script.. their info is being set inside a .dat file.

    now i have many applications that use mysql authorization (forums.. shoppong cart.. image galleries) and i need to have the same users who signed up above to be able to access those...

    so i either have to have a script that imports the .dat file into the mysqls and make that run every hour (cron job)..

    or i have to have a script that redirects the mysql authorization process to the .dat file (knowing that all the mysqls run on php)..

    i this falls under the perl or php exprience..
    ANY suggestion may help..
    thanks
    Tarek

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    Personally, I would import the data from the .dat file ONCE, then code any future signups to the mySQL database.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  3. #3
    tarek990's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2004
    Posts
    3

    well

    thanks for the reply..
    the problem is that i am using the cgi signup and many other features depend on that so i cant change that..
    any other sugg?
    thanks
    Tarek

  4. #4
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    Well, perl/cgi can talk to mySQL as well..so why not add code so they sign up once, and get added both to the dat file and the sql database.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  5. #5
    tarek990's Avatar
    New User

    Status
    Offline
    Join Date
    Apr 2004
    Posts
    3
    ah good idea.. is it possible to add the same sign up to one .dat and like 4 mysqls at the same time??

    thanks
    tarek

  6. #6
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    yup, make four different queries. Or if you mean 4 tables rather than 4 databases, you can do it in one query. Check out www.mysql.org
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?