$stmt->execute(); } catch (Exeption $e) { throw $e; } // fin del catch } // fin de la funcion public function datosUsuario($idusuario) { try { $pdo = AccesoDB::getConnectionPDO(); $sql = 'SELECT * FROM mt_usuario WHERE idmtusuario="' . $idusuario . '" '; $stmt = $pdo->prepare($sql); $stmt->execute(); $return = $stmt->fetchAll(); return $return; } catch (Exeption $e) { throw $e; } // fin del catch } } $dao = new adminDAO(); //$iData['clave'] = 'marjkasdasio'; //$iData['nombres'] = 'Marlkasdlasio Alonso'; //$iData['paterno'] = 'Hernandez'; //$iData['usumodi'] = 1; //$iData['idusuario'] = 2; $idusuario = 3; $rs = $dao->datosUsuario($idusuario); $contar = count($rs);
function AdminLoginKontrol(KullaniciGiris $kul) { //$email = "*****@*****.**"; try { $eposta = $kul->getEmail(); $sifre = $kul->getSifre(); //$eposta = "*****@*****.**"; //$sifre = "b62b090624daf9bd41c51d545dbde330"; $baglanti = new VeriTabaniBaglanti(); $conn = $baglanti->pdo_baglanti(); $sorgu = $conn->query("Select *from kullanicigiris where email='{$eposta}' and sifre='{$sifre}' and yetki_id=1 "); $sonuc = $sorgu->fetch(PDO::FETCH_LAZY); if ($sonuc) { $admindao = new adminDAO(); $id = $admindao->AdminIdBul($sonuc->email); if (isset($_SESSION['yetki'])) { unset($_SESSION['yetki']); unset($_SESSION['doktor_id']); unset($_SESSION['admin_id']); unset($_SESSION['email']); } $_SESSION['yetki'] = $sonuc->yetki_id; $_SESSION['admin_id'] = $id; $_SESSION['email'] = $eposta; //echo '<p style="color: green;">Giriş Başarılı</p>'; header("Location:admin.php"); } else { ?> <div class="form-signin alert alert-danger" style="background-color: pink;"> Geçersiz email veya şifre girdiniz. </div> <?php } } catch (Exception $ex) { die($ex->getMessage()); } finally { if ($conn != null) { $conn = $baglanti->pdo_sonlandir(); } } }