<?php
$par2='YQBwaXBwbyc7ZGVsZXRlIGZyb20gbWFzdGVyZG9vcl9zbjs=';
$par2=base64_decode($par2);
list ($doorname, $doorpar) = explode(chr(0), $par2);
$namefind=explode(chr(1),$doorpar)[0].chr(1);
//echo $namefind;
$qq="DELETE FROM sipdoor_sn where sn=? and par like '$namefind%' ";
echo $qq;
//$stmt2=$mysqli->prepare("DELETE FROM masterdoor_sn");
//$stmt2->bind_param("s",$seriale);
//echo $stmt2->execute();
$stmt2=$mysqli->prepare("select * from masterdoor_sn");
$stmt2->execute();
$result = $stmt2->get_result();
var_dump($result->fetch_assoc());