Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
create table test_admin_users (school_id int, username varchar(255));
insert into test_admin_users values (11, 'foo'),(11, 'jones');
<?php
$query = "select * from test_admin_users where school_id=? and username=?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ii", $school_id,$username);
$username='jones';
$school_id=11;
$stmt->execute();
$res = $stmt->get_result();
echo $res->num_rows;