Results 1 to 6 of 6
if mysql select returns no results redirect Forum: PHP ForumReplies: 0
web form data import to ms access db Forum: PHP ForumReplies: 2
320,000+ page Export Import industry b2b Portal & Directory are offered for sale. Forum: Websites For SaleReplies: 2
@import and netscape 6x Forum: CSS ForumReplies: 1
04-24-2004, 11:14 AM #1
dat to mysql import - or redirect authorization
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..
04-24-2004, 07:43 PM #2
Personally, I would import the data from the .dat file ONCE, then code any future signups to the mySQL database.
04-25-2004, 08:14 AM #3
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?
04-25-2004, 08:22 AM #4
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.
04-25-2004, 08:26 AM #5
ah good idea.. is it possible to add the same sign up to one .dat and like 4 mysqls at the same time??
04-25-2004, 10:21 AM #6
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