change from PDO to MSQLI

[viana2020]

how do i change this to mysqli?

<?php 
    require 'connect.php';
 
    session_start();
 
    $username = "";
    $password = "";
 
    if(isset($_POST['username'])){
        $username = $_POST['username'];
    }
    if (isset($_POST['password'])) {
        $password = $_POST['password'];
 
    }
 
    echo $username ." : ".$password;
 
    $q = 'SELECT * FROM users WHERE username=:username AND password=:password';
 
    $query = $dbh->prepare($q);
 
    $query->execute(array(':username' => $username, ':password' => $password));
 
 
    if($query->rowCount() == 0){
        header('Location: ind.php?err=1');
    }else{
 
        $row = $query->fetch(PDO::FETCH_ASSOC);
 
        session_regenerate_id();
        $_SESSION['sess_user_id'] = $row['id'];
        $_SESSION['sess_username'] = $row['username'];
        $_SESSION['sess_userrole'] = $row['role'];
 
        echo $_SESSION['sess_userrole'];
        session_write_close();
 
        if( $_SESSION['sess_userrole'] == "admin"){
            header('Location: adminhome.php');
        }else{
            header('Location: userhome.php');
        }
 
 
    }
 
 
?>

[Luuk]

Why do you want to do that? (see: this)

I think PDO has more advantages than MySQLi

[viana2020]

it is because most of my pages are in MYSQLI except the login. changing all the pages to PDO might take longer