I use phpmyadmin and noticed that there's an option to save an entire database to a cvs file (excel)

That's really cool.
Is it hard to hadd a button to my site that lets a user do that himself?
But he needs to save only his flights like with a criteria of PERSON_ID = @#$@#%#$%

Can someone tell me how to do it or direct me to a link? i use php for the site.
Is there any sort of security risk of using this feature?

thanks
Noam

You can use the SELECT ... INTO OUTFILE .... Syntaxe to perform a CSV export from your request

how do i do that exactly? i don't have much experience with exporting. so far i've been using phpmyadmin. i've been searching on google alot but can't find anything
thanks
Noam

You could write a outfile-query like this:

SELECT DISTINCT * INTO OUTFILE "/[abs_path]/result.txt"
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM myTable WHERE PERSON_ID = $person_id

Your destination-folder must have write-permission for all

/pekron