öncelikle size girisyap(): fonksiyonun içindekinleri atayım:
def girisyap(self):
kullaniciadi = self.ui.kuladi.text()
kullanicisifre = self.ui.kulsifre.text()
veri.execute('SELECT * FROM kullanicilar WHERE kuladi ="%s" AND kulsifre="%s"' % (kullaniciadi,kullanicisifre))
kullanicikontrol = veri.fetchone()
if kullanicikontrol:
veri.execute('SELECT * FROM kullanicilar WHERE kuladi ="%s"' % kullaniciadi)
bilgialma = veri.fetchall()
for row in bilgialma:
idbilgi = row[0]
tckimlikno = row[4]
sirketkurucununisimvesoyisim = row[10] + " " + row[11]
sirketkurulustarihi1 = row[9]
sirketiscisayisi = row[8]
hesapisimvesoyisim = row[5] + " " + row[6]
kullaniciadibilgi = row[1]
kullanicisifrebilgi = row[2]
kullaniciepostabilgi = row[3]
sirkettanitimibilgi = row[12]
sirkethesapacilisbilgi = row[14]
self.ui.Ui_girispaneli()
self.ui.setupUi(self)
self.ui.skurucutcno.setText(tckimlikno)
self.ui.skurucuisim.setText(sirketkurucununisimvesoyisim)
self.ui.sirketkurulustarihi.setText(sirketkurulustarihi1)
self.ui.scalisansayisi.setText(sirketiscisayisi)
self.ui.sgisim.setText(hesapisimvesoyisim)
self.ui.skullaniciadi.setText(kullaniciadibilgi)
self.ui.skullanicisifre.setText(kullanicisifrebilgi)
self.ui.skullanicieposta.setText(kullaniciepostabilgi)
self.ui.sirkettanitim.setText(sirkettanitimibilgi)
self.ui.veriidbilgi.setText(idbilgi)
else:
self.ui.sonuchata.setText("[!] Girdiğiniz Bilgiler YANLIŞ..!")
girisyap.ui ve girispaneli.ui kodları şunlar :
girisyap.ui:
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'girisyap.ui'
#
# Created by: PyQt5 UI code generator 5.15.1
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again. Do not edit this file unless you know what you are doing.
from PyQt5 import QtCore, QtGui, QtWidgets
class Ui_girisyap(object):
def setupUi(self, girisyap):
girisyap.setObjectName("girisyap")
girisyap.resize(1024, 582)
girisyap.setMinimumSize(QtCore.QSize(1024, 400))
icon = QtGui.QIcon()
icon.addPixmap(QtGui.QPixmap(":/icon/icons/1.ico"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
girisyap.setWindowIcon(icon)
girisyap.setStyleSheet("background-image: url(:/background/backgrounds/security.jpg);")
self.centralwidget = QtWidgets.QWidget(girisyap)
self.centralwidget.setStyleSheet("")
self.centralwidget.setObjectName("centralwidget")
self.frame = QtWidgets.QFrame(self.centralwidget)
self.frame.setGeometry(QtCore.QRect(250, 120, 551, 201))
self.frame.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);")
self.frame.setFrameShape(QtWidgets.QFrame.StyledPanel)
self.frame.setFrameShadow(QtWidgets.QFrame.Raised)
self.frame.setObjectName("frame")
self.sifremiunuttum = QtWidgets.QPushButton(self.frame)
self.sifremiunuttum.setGeometry(QtCore.QRect(20, 150, 201, 28))
self.sifremiunuttum.setStyleSheet("font: 75 italic 14pt \"Ubuntu\";")
self.sifremiunuttum.setObjectName("sifremiunuttum")
self.layoutWidget = QtWidgets.QWidget(self.frame)
self.layoutWidget.setGeometry(QtCore.QRect(20, 20, 511, 121))
self.layoutWidget.setObjectName("layoutWidget")
self.verticalLayout = QtWidgets.QVBoxLayout(self.layoutWidget)
self.verticalLayout.setContentsMargins(0, 0, 0, 0)
self.verticalLayout.setObjectName("verticalLayout")
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setObjectName("horizontalLayout")
self.label_2 = QtWidgets.QLabel(self.layoutWidget)
self.label_2.setStyleSheet("font: 75 italic 20pt \"Ubuntu\";")
self.label_2.setObjectName("label_2")
self.horizontalLayout.addWidget(self.label_2)
self.kuladi = QtWidgets.QLineEdit(self.layoutWidget)
self.kuladi.setTabletTracking(True)
self.kuladi.setStyleSheet("background-image: url(:/entrybackground/backgrounds/entrybackgrounds.jpg);\n"
"font: 25 italic 18pt \"Ubuntu\";\n"
"color: rgb(255, 255, 255);")
self.kuladi.setObjectName("kuladi")
self.horizontalLayout.addWidget(self.kuladi)
self.verticalLayout.addLayout(self.horizontalLayout)
self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_3 = QtWidgets.QLabel(self.layoutWidget)
self.label_3.setStyleSheet("font: 75 italic 20pt \"Ubuntu\";")
self.label_3.setObjectName("label_3")
self.horizontalLayout_2.addWidget(self.label_3)
self.kulsifre = QtWidgets.QLineEdit(self.layoutWidget)
self.kulsifre.setTabletTracking(True)
self.kulsifre.setStyleSheet("background-image: url(:/entrybackground/backgrounds/entrybackgrounds.jpg);\n"
"font: 25 italic 18pt \"Ubuntu\";\n"
"color: rgb(255, 255, 255);")
self.kulsifre.setEchoMode(QtWidgets.QLineEdit.Password)
self.kulsifre.setObjectName("kulsifre")
self.horizontalLayout_2.addWidget(self.kulsifre)
self.verticalLayout.addLayout(self.horizontalLayout_2)
self.sonuchata = QtWidgets.QLabel(self.layoutWidget)
self.sonuchata.setStyleSheet("font: 75 bold 16pt \"Ubuntu\";")
self.sonuchata.setText("")
self.sonuchata.setAlignment(QtCore.Qt.AlignCenter)
self.sonuchata.setObjectName("sonuchata")
self.verticalLayout.addWidget(self.sonuchata)
self.label = QtWidgets.QLabel(self.centralwidget)
self.label.setGeometry(QtCore.QRect(360, 80, 341, 41))
self.label.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);\n"
"font: 25 italic 24pt \"Ubuntu\";\n"
"color: rgb(0, 0, 0);")
self.label.setObjectName("label")
self.girisyap1 = QtWidgets.QPushButton(self.centralwidget)
self.girisyap1.setGeometry(QtCore.QRect(640, 320, 121, 41))
self.girisyap1.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);\n"
"font: 25 italic 22pt \"Ubuntu\";")
self.girisyap1.setObjectName("girisyap1")
self.kayitol = QtWidgets.QPushButton(self.centralwidget)
self.kayitol.setGeometry(QtCore.QRect(290, 320, 121, 41))
self.kayitol.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);\n"
"font: 25 italic 22pt \"Ubuntu\";")
self.kayitol.setObjectName("kayitol")
girisyap.setCentralWidget(self.centralwidget)
self.retranslateUi(girisyap)
self.sifremiunuttum.clicked.connect(girisyap.sifremiunuttum)
self.kayitol.clicked.connect(girisyap.kayitol)
self.girisyap1.clicked.connect(girisyap.girisyap)
QtCore.QMetaObject.connectSlotsByName(girisyap)
def retranslateUi(self, girisyap):
_translate = QtCore.QCoreApplication.translate
girisyap.setWindowTitle(_translate("girisyap", "İNTER AKTİF KAMERA GÜVENLİK SİSTEMİ"))
self.sifremiunuttum.setText(_translate("girisyap", "Şifremi Unuttum"))
self.label_2.setText(_translate("girisyap", "Kullanıcı Adı Giriniz : "))
self.label_3.setText(_translate("girisyap", "Kullanıcı Şifrenizi Giriniz : "))
self.label.setText(_translate("girisyap", "KULLANICI GİRİŞ PANELİ"))
self.girisyap1.setText(_translate("girisyap", "Giriş Yap"))
self.kayitol.setText(_translate("girisyap", "Kayıt OL"))
import backgrounds_rc
import entrybackgrounds_rc
import framebackgrounds_rc
import icons_rc
girispaneli.ui
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'girispaneli.ui'
#
# Created by: PyQt5 UI code generator 5.15.1
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again. Do not edit this file unless you know what you are doing.
from PyQt5 import QtCore, QtGui, QtWidgets
class Ui_girispaneli(object):
def setupUi(self, girispaneli):
girispaneli.setObjectName("girispaneli")
girispaneli.resize(1034, 583)
girispaneli.setMinimumSize(QtCore.QSize(1024, 400))
icon = QtGui.QIcon()
icon.addPixmap(QtGui.QPixmap(":/icon/icons/1.ico"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
girispaneli.setWindowIcon(icon)
girispaneli.setStyleSheet("background-image: url(:/background/backgrounds/security.jpg);")
self.centralwidget = QtWidgets.QWidget(girispaneli)
self.centralwidget.setObjectName("centralwidget")
self.tabWidget = QtWidgets.QTabWidget(self.centralwidget)
self.tabWidget.setGeometry(QtCore.QRect(10, 10, 1011, 541))
self.tabWidget.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);\n"
"color: rgb(0, 0, 0);")
self.tabWidget.setObjectName("tabWidget")
self.tab = QtWidgets.QWidget()
self.tab.setObjectName("tab")
self.tabWidget.addTab(self.tab, "")
self.tab_2 = QtWidgets.QWidget()
self.tab_2.setObjectName("tab_2")
self.tabWidget.addTab(self.tab_2, "")
self.tab_3 = QtWidgets.QWidget()
self.tab_3.setObjectName("tab_3")
self.tabWidget.addTab(self.tab_3, "")
self.tab_4 = QtWidgets.QWidget()
self.tab_4.setObjectName("tab_4")
self.layoutWidget = QtWidgets.QWidget(self.tab_4)
self.layoutWidget.setGeometry(QtCore.QRect(270, 10, 731, 491))
self.layoutWidget.setObjectName("layoutWidget")
self.verticalLayout = QtWidgets.QVBoxLayout(self.layoutWidget)
self.verticalLayout.setContentsMargins(0, 0, 0, 0)
self.verticalLayout.setObjectName("verticalLayout")
self.label_9 = QtWidgets.QLabel(self.layoutWidget)
self.label_9.setAlignment(QtCore.Qt.AlignCenter)
self.label_9.setObjectName("label_9")
self.verticalLayout.addWidget(self.label_9)
self.sirkettanitim = QtWidgets.QPlainTextEdit(self.layoutWidget)
self.sirkettanitim.setObjectName("sirkettanitim")
self.verticalLayout.addWidget(self.sirkettanitim)
self.layoutWidget1 = QtWidgets.QWidget(self.tab_4)
self.layoutWidget1.setGeometry(QtCore.QRect(10, 10, 245, 491))
self.layoutWidget1.setObjectName("layoutWidget1")
self.verticalLayout_3 = QtWidgets.QVBoxLayout(self.layoutWidget1)
self.verticalLayout_3.setContentsMargins(0, 0, 0, 0)
self.verticalLayout_3.setObjectName("verticalLayout_3")
self.label_23 = QtWidgets.QLabel(self.layoutWidget1)
self.label_23.setAlignment(QtCore.Qt.AlignCenter)
self.label_23.setObjectName("label_23")
self.verticalLayout_3.addWidget(self.label_23)
self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
self.horizontalLayout_2.setObjectName("horizontalLayout_2")
self.label_2 = QtWidgets.QLabel(self.layoutWidget1)
self.label_2.setObjectName("label_2")
self.horizontalLayout_2.addWidget(self.label_2)
self.skurucutcno = QtWidgets.QLabel(self.layoutWidget1)
self.skurucutcno.setText("")
self.skurucutcno.setObjectName("skurucutcno")
self.horizontalLayout_2.addWidget(self.skurucutcno)
self.verticalLayout_3.addLayout(self.horizontalLayout_2)
self.horizontalLayout = QtWidgets.QHBoxLayout()
self.horizontalLayout.setObjectName("horizontalLayout")
self.label = QtWidgets.QLabel(self.layoutWidget1)
self.label.setObjectName("label")
self.horizontalLayout.addWidget(self.label)
self.skurucuisim = QtWidgets.QLabel(self.layoutWidget1)
self.skurucuisim.setText("")
self.skurucuisim.setObjectName("skurucuisim")
self.horizontalLayout.addWidget(self.skurucuisim)
self.verticalLayout_3.addLayout(self.horizontalLayout)
self.horizontalLayout_5 = QtWidgets.QHBoxLayout()
self.horizontalLayout_5.setObjectName("horizontalLayout_5")
self.label_5 = QtWidgets.QLabel(self.layoutWidget1)
self.label_5.setObjectName("label_5")
self.horizontalLayout_5.addWidget(self.label_5)
self.skurulustarihi = QtWidgets.QLabel(self.layoutWidget1)
self.skurulustarihi.setText("")
self.skurulustarihi.setObjectName("skurulustarihi")
self.horizontalLayout_5.addWidget(self.skurulustarihi)
self.verticalLayout_3.addLayout(self.horizontalLayout_5)
self.horizontalLayout_8 = QtWidgets.QHBoxLayout()
self.horizontalLayout_8.setObjectName("horizontalLayout_8")
self.label_8 = QtWidgets.QLabel(self.layoutWidget1)
self.label_8.setObjectName("label_8")
self.horizontalLayout_8.addWidget(self.label_8)
self.scalisansayisi = QtWidgets.QLabel(self.layoutWidget1)
self.scalisansayisi.setText("")
self.scalisansayisi.setObjectName("scalisansayisi")
self.horizontalLayout_8.addWidget(self.scalisansayisi)
self.verticalLayout_3.addLayout(self.horizontalLayout_8)
self.horizontalLayout_6 = QtWidgets.QHBoxLayout()
self.horizontalLayout_6.setObjectName("horizontalLayout_6")
self.label_6 = QtWidgets.QLabel(self.layoutWidget1)
self.label_6.setObjectName("label_6")
self.horizontalLayout_6.addWidget(self.label_6)
self.sgisim = QtWidgets.QLabel(self.layoutWidget1)
self.sgisim.setText("")
self.sgisim.setObjectName("sgisim")
self.horizontalLayout_6.addWidget(self.sgisim)
self.verticalLayout_3.addLayout(self.horizontalLayout_6)
self.label_12 = QtWidgets.QLabel(self.layoutWidget1)
self.label_12.setAlignment(QtCore.Qt.AlignCenter)
self.label_12.setObjectName("label_12")
self.verticalLayout_3.addWidget(self.label_12)
self.horizontalLayout_7 = QtWidgets.QHBoxLayout()
self.horizontalLayout_7.setObjectName("horizontalLayout_7")
self.label_7 = QtWidgets.QLabel(self.layoutWidget1)
self.label_7.setObjectName("label_7")
self.horizontalLayout_7.addWidget(self.label_7)
self.skullaniciadi = QtWidgets.QLabel(self.layoutWidget1)
self.skullaniciadi.setText("")
self.skullaniciadi.setObjectName("skullaniciadi")
self.horizontalLayout_7.addWidget(self.skullaniciadi)
self.verticalLayout_3.addLayout(self.horizontalLayout_7)
self.horizontalLayout_9 = QtWidgets.QHBoxLayout()
self.horizontalLayout_9.setObjectName("horizontalLayout_9")
self.label_10 = QtWidgets.QLabel(self.layoutWidget1)
self.label_10.setObjectName("label_10")
self.horizontalLayout_9.addWidget(self.label_10)
self.skullanicisifre = QtWidgets.QLabel(self.layoutWidget1)
self.skullanicisifre.setText("")
self.skullanicisifre.setObjectName("skullanicisifre")
self.horizontalLayout_9.addWidget(self.skullanicisifre)
self.verticalLayout_3.addLayout(self.horizontalLayout_9)
self.horizontalLayout_10 = QtWidgets.QHBoxLayout()
self.horizontalLayout_10.setObjectName("horizontalLayout_10")
self.label_11 = QtWidgets.QLabel(self.layoutWidget1)
self.label_11.setObjectName("label_11")
self.horizontalLayout_10.addWidget(self.label_11)
self.skullanicieposta = QtWidgets.QLabel(self.layoutWidget1)
self.skullanicieposta.setText("")
self.skullanicieposta.setObjectName("skullanicieposta")
self.horizontalLayout_10.addWidget(self.skullanicieposta)
self.verticalLayout_3.addLayout(self.horizontalLayout_10)
self.tabWidget.addTab(self.tab_4, "")
self.label_24 = QtWidgets.QLabel(self.centralwidget)
self.label_24.setGeometry(QtCore.QRect(10, 550, 241, 16))
self.label_24.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);\n"
"color: rgb(0, 0, 0);")
self.label_24.setAlignment(QtCore.Qt.AlignCenter)
self.label_24.setObjectName("label_24")
self.veriidbilgi = QtWidgets.QLabel(self.centralwidget)
self.veriidbilgi.setGeometry(QtCore.QRect(250, 550, 111, 16))
self.veriidbilgi.setStyleSheet("background-image: url(:/framebackground/backgrounds/famebackgrounds.jpg);\n"
"color: rgb(0, 0, 0);")
self.veriidbilgi.setText("")
self.veriidbilgi.setAlignment(QtCore.Qt.AlignCenter)
self.veriidbilgi.setObjectName("veriidbilgi")
girispaneli.setCentralWidget(self.centralwidget)
self.retranslateUi(girispaneli)
self.tabWidget.setCurrentIndex(3)
QtCore.QMetaObject.connectSlotsByName(girispaneli)
def retranslateUi(self, girispaneli):
_translate = QtCore.QCoreApplication.translate
girispaneli.setWindowTitle(_translate("girispaneli", "İNTER AKTİF KAMERA GÜVENLİK SİSTEMİ"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("girispaneli", "Şirket Kamera Dökümanları"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_2), _translate("girispaneli", "Şirket Çalışanları"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_3), _translate("girispaneli", "Şirket Müşterileri"))
self.label_9.setText(_translate("girispaneli", "Şirket Tanıtım Bölümü : "))
self.label_23.setText(_translate("girispaneli", "Şirket Bilgileri : "))
self.label_2.setText(_translate("girispaneli", "Tc Kimlik Numarası: : "))
self.label.setText(_translate("girispaneli", "Şirket Kurucunun İsmi : "))
self.label_5.setText(_translate("girispaneli", "Şirket Kuruluş Tarihi : "))
self.label_8.setText(_translate("girispaneli", "Şirket Bulunan İşci Sayısı : "))
self.label_6.setText(_translate("girispaneli", "Hesap Açılan Kişinin İsmi : "))
self.label_12.setText(_translate("girispaneli", "GİRİŞ BİLGİLERİ : "))
self.label_7.setText(_translate("girispaneli", "Kullanıcı Adınız : "))
self.label_10.setText(_translate("girispaneli", "Kullanıcı Şifreniz : "))
self.label_11.setText(_translate("girispaneli", "Şirket Kurucunun İsmi : "))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_4), _translate("girispaneli", "Şirket Bilgileri"))
self.label_24.setText(_translate("girispaneli", "Veri Tabanındaki Kayıtlı ID Numarası: "))
import backgrounds_rc
import entrybackgrounds_rc
import framebackgrounds_rc
import icons_rc
hep bu hatayı almaktayım :
Traceback (most recent call last):
File "/home/deathangels43/Masaüstü/İnterAktifCameraGüvenlikSistemi/main.py", line 206, in girisyap
self.ui.Ui_girispaneli()
AttributeError: 'Ui_girisyap' object has no attribute 'Ui_girispaneli'
Şimdiden Teşekkür Ediyorum …!