void MainWindow::on_pushButton_clicked()
{
QSqlDatabase Databasee = QSqlDatabase::database();

Databasee = QSqlDatabase::addDatabase("QMYSQL", "SeccConnection");
Databasee.setHostName("localhost") ;
Databasee.setUserName("root");
Databasee.setPassword("mostafa");
Databasee.setDatabaseName("Clinic_Database");
if( QSqlDatabase::contains( "SeccConnection" ) )
{
QSqlDatabase db = QSqlDatabase::database( "SeccConnection" );
// qDebug() << "Donnne" ;
// now do some stuff with it
}
else
{
// qDebug() << "something error" ;

// connection not found, do something
}/*
if(Databasee.open()){
qDebug() << "Connected" ;
}else {

qDebug() << Databasee.lastError().text();
qDebug() << "not Connected";
}*/
QSqlQuery qr (Databasee) ;
qr.exec("select * from Employees") ;
while(qr.next()) {
qDebug() << qr.value(1) ;

}
QString User = ui->lineEdit_Username->text();
QString Pass = ui->lineEdit_2_Password->text() ;
QString ss = "SELECT NAME , PASSWORD FROM +‘“Employees”’+ WHERE User=:Name and Pass=:Password" ;
qr.prepare(ss);
qr.bindValue(":Name",User) ;
qr.bindValue(":Password",Pass) ;

if(qr.exec()) {
if(qr.next()){
qDebug()<< "ok";

qDebug()<< qr.value(1);
}
else{
qDebug()<< "login fail" ;
qDebug() << qr.lastError();
}

}else {
qDebug() << qr.lastError();
qDebug() << qr.exec();

}

if(qr.exec()){

if(qr.next()) {
qDebug() << User + "Welcome" ;
}else{
qDebug() << "Failed" ;
}

}

/*
while (qr.next())
{

qDebug() << qr.value(1).toString() ;

qDebug() << QSqlDatabase::drivers() << "Error" ;
qDebug() << qr.lastError();}
}*/
/*
while (qr.next())
{
if (User == qr.value(1).toString() && Pass ==
qr.value(2).toString()
)
{
// You login a user here
QString name = qr.value(1).toString();
qDebug() << name << "is logged in";
}

else {
qDebug() << "Login failed" ;
}
}

}*/

}