Mar-18-2021, 09:47 AM
I have not yet tried to use Python to interact with MySQL.
I run a little homework webpage for my classes. They do the homework, PHP marks it and saves the answers and the scores.
Once a week, I go to my webhost, open phpMyAdmin, then I do, as an example MySQL table:
Step 1:
SELECT studentnr, score FROM allstudentsAnswers20BE WHERE weeknr = 'Week2';
Step 2:
I export the resulting selection as a .csv file to my computer
(then I use Python to put the results in my timetable. I just need to get the .csv file first)
I would like to automate Step 1 and Step 2 using Python.
Could you please give me some tips about what Python modules can do this?
I run a little homework webpage for my classes. They do the homework, PHP marks it and saves the answers and the scores.
Once a week, I go to my webhost, open phpMyAdmin, then I do, as an example MySQL table:
Step 1:
SELECT studentnr, score FROM allstudentsAnswers20BE WHERE weeknr = 'Week2';
Step 2:
I export the resulting selection as a .csv file to my computer
(then I use Python to put the results in my timetable. I just need to get the .csv file first)
I would like to automate Step 1 and Step 2 using Python.
Could you please give me some tips about what Python modules can do this?