create table masterdoor_sn (sn varchar(10),sipuser_app varchar(10));
create table sipdoor_sn (sn varchar(10),par varchar(10));
show tables;
insert into masterdoor_sn(sn ,sipuser_app ) values ('as','asd');
select * from masterdoor_sn;
DELETE FROM sipdoor_sn where sn=? and par like 'pippo';
delete from masterdoor_sn;
select * from masterdoor_sn;
<?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 sipdoor_sn where sn=? and par like '$namefind%' ");
echo $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());