Hi All,
I need some advise, pointers or ideas how I can tackle this problem of mine.
I am running a front end php and backend mysql db.
I could import my csv file from php to mysql db. However I was wondering if I could upload the csv file from php and run the stored procedures in mysql to load the csv file into mysql.
I don't like people to see my php file and know where I import my file into for security purpose.
Please help me. Greatly appreciate all your feed backs.
Nidhi
Hello,
Stored procedures in mysql is a really good practice for us, (notice that db2 stored procedures are legendary). But there must be a reason to do that . None sees your PHP program and of course you haven’t to put it in public_html directory in order to work. Cron jobs are there for you in order to make thing roll automatic.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
