SHARE
TWEET

Untitled

cjae4079 May 23rd, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. users = helper.select("SELECT * FROM students WHERE firstName LIKE '%"+window1.txtSearch.text()+"%' OR lastName LIKE '%"+window1.txtSearch.text()+"%' OR middleInitial LIKE '%"+window1.txtSearch.text()+"%' OR age LIKE '%"+window1.txtSearch.text()+"%' OR gender LIKE '%"+window1.txtSearch.text()+"%' OR yearLevel LIKE '%"+window1.txtSearch.text()+"%' OR department LIKE '%"+window1.txtSearch.text()+"%'")
  2.  
  3.     for row_number,user in enumerate(users):
  4.  
  5.         window1.tblList.insertRow(row_number)
  6.  
  7.         for column_number,data in enumerate(user):
  8.  
  9.             cell = QtWidgets.QTableWidgetItem(str(data))
  10.  
  11.             window1.tblList.setItem(row_number,column_number,cell)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top