DROP PROCEDURE IF EXISTS `UsersR_DELETE_byPK` 
GO
 
CREATE PROCEDURE UsersR_DELETE_byPK
   (
        IN  UsersID             INT(11) 
)	
BEGIN 
 
   DELETE FROM UsersR   
 
           WHERE  UsersID=UsersID;
 
 
  END

//first create a connection to your database...
function connection(){
		$mysqli = new mysqli('$hostname','$dbusername', '$dbpassword', '$dbname');
		if (mysqli_connect_errno()) {
			printf("Connect failed: %s\n", mysqli_connect_error());
			exit();
		}
 
		return $mysqli;
 
	} 
//second create the function to call the stored procedure
  function query($query){
//call the connection function
  if($result = connection()->query($query)){
			while($row = $result->fetch_assoc()){
					$data[] = $row;
			}
			return $data;
			}else {
			print('error on:'.$query.mysqli_error($this));
                      }
 }
//then call the function to execute stored procedure
query("call store_proc('$param1')");