Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Python 3 mysql export to csv
Post: Python 3 mysql export to csv
Hi there, I have been creating an attendance system (Clocking in and out machine) for the company i work for. I have been storing all the data in a mysql server on the local sever at work. I am now tr...
 elliott0184 General Coding Help 3 15,392 Feb-22-2017, 11:01 PM
    Thread: Attendence System
Post: RE: Attendence System
Ok so thought I would use the same thread even though I am much further on. Now I am looking at the clocking out section. I have managed to get the system to get them to input their staff id twice. it...
 elliott0184 General Coding Help 19 16,687 Feb-21-2017, 03:07 PM
    Thread: Attendence System
Post: RE: Attendence System
Ok problem solved. I started up a apache server on the same PC and it seemed to fix it. Don't really Understand but it now works. Thanks very much.
 elliott0184 General Coding Help 19 16,687 Dec-21-2016, 06:27 PM
    Thread: Attendence System
Post: RE: Attendence System
(Dec-21-2016, 01:36 PM)Larz60+ Wrote: Looks to me like the server is not running I can access the server from the console though. i start the server from the terminal and then i can access it. I pre...
 elliott0184 General Coding Help 19 16,687 Dec-21-2016, 01:47 PM
    Thread: Attendence System
Post: RE: Attendence System
(Dec-20-2016, 06:41 PM)nilamo Wrote: Try pinging the server after you've got a connection, but before trying to make a cursor.  That way you can make sure the database is running and you're connecte...
 elliott0184 General Coding Help 19 16,687 Dec-21-2016, 01:11 PM
    Thread: Attendence System
Post: RE: Attendence System
(Dec-20-2016, 06:30 PM)wavic Wrote: Do you have privileges to connect to the db? I think i do how would i check from the mysql console? + shouldnt it give me a error if i couldn't on the line above?
 elliott0184 General Coding Help 19 16,687 Dec-20-2016, 06:30 PM
    Thread: Attendence System
Post: RE: Attendence System
Ok didnt know how much i should post. The Mysql server is on the same machine i am using to write the code. import time import mysql.connector from mysql.connector import errorcode from datetim...
 elliott0184 General Coding Help 19 16,687 Dec-20-2016, 06:22 PM
    Thread: Attendence System
Post: RE: Attendence System
Ok then i have been playing around with mysql.connector today and i keep getting an error when calling cursor = cnx.cursor()This is the error that i keep getting i have looked a little online but don...
 elliott0184 General Coding Help 19 16,687 Dec-20-2016, 06:01 PM
    Thread: Attendence System
Post: RE: Attendence System
(Dec-13-2016, 05:20 PM)nilamo Wrote: You could just use http calls to get/send info somewhere else, and display that info to the user.  Strictly speaking, I think that'd actually be easier to do, as...
 elliott0184 General Coding Help 19 16,687 Dec-14-2016, 10:05 AM
    Thread: Attendence System
Post: RE: Attendence System
We are a very small company. 6 full time staff and in the summer around 20 freelancers. We currently use a raspberry pi as our server because we only require NAS and Print server. Although we do have ...
 elliott0184 General Coding Help 19 16,687 Dec-13-2016, 09:43 AM
    Thread: Attendence System
Post: RE: Attendence System
Yeah I had thought of the entering the wrong code. I considered that the program would sleep after having found out who's the code is and then get them to press enter after a short period. Say 2-3 sec...
 elliott0184 General Coding Help 19 16,687 Dec-12-2016, 10:04 PM
    Thread: Attendence System
Post: Attendence System
Hi there. I am a bit of a newbie to python so i may need a bit more help than normal. I am trying to program a raspberry pi using python to create an attendance system at work. I would like it to hav...
 elliott0184 General Coding Help 19 16,687 Dec-12-2016, 03:21 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020