Untitled

def get_person(self, e): #name, surname):
    sql = "select * from persons where ADI=%s and SOYADI=%s"
    self.datacursor.execute(sql, ("ahmet","çalışır"))
    self.persons = self.datacursor.fetchall()
    for index, person in enumerate(self.persons):
      t = Card(
        content = Container(
           content = Column(
        ),
        width=400,
        padding=10
        )
      )
      tile = ListTile(
                 title = Text(value=f"{person['ADI']} {person['SOYADI']}"),
                 subtitle = Column(
                   controls = [
                     Text(value=f"Mail: {person['MAIL']}"),
                     Text(value=f"Phone: {person['PHONE']}")
 ]
                 ),
on_click = (lambda _: self.clicked(_, str(index))),
               )
      t.content.content.controls.append(tile)
      self.listview.controls.append(t)
    self.page.scroll = "auto"
    self.page.update()
def clicked(self, _, id):
  print(id)