get all student

  def get_all_students(self):
   sql = 'SELECT id, name, email, phone FROM students'
   self.db.cursor.execute(sql)    
   return self.db.cursor.fetchall()  

# Create Student Object
student = Student()
allstudent = student.get_all_students()
print(allstudent)

OutPut:

[(1, 'olee', '[e-mail]', '01953-6649667'), (2, 'Tarek', '[e-mail]', '01900-001122')]