how to do named parameters

namedparameters.php

<?php

// pdo
$params = array(':username' => 'John', ':email' => $mail );
$pdo->prepare('
   SELECT * FROM users
   WHERE username = :username
   AND email = :email');
$pdo->execute($params);

// mydqli
$query = $mysqli->prepare('
   SELECT * FROM users
   WHERE username = ?
   AND email = ?');
   
// ss - represents 2 parameters in string
$query->bind_param('ss', 'John', $mail);
$query->execute();

// mysqli doesn't support named parameters  
?>