# get all student

```python
  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:**

```bash
[(1, 'olee', 'olee.techs@gmail.com', '01953-6649667'), (2, 'Tarek', 'tarek@gmail.com', '01900-001122')]
```
