How do I count query result rows?

$query->num_rows;

or

mysqli_num_rows($query);

you could just do

    if($row = mysqli_fetch_assoc($query)) {

    }

also you may want to save your username and password in one file as constants