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 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');
insert into sipdoor_sn(sn ,par ) values ('as','pippo');
select * from masterdoor_sn;
select * from sipdoor_sn;
<?php
$par2='YQBwaXBwbyctLQ==';
$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($qq);
$seriale='as';
$stmt2->bind_param("s",$seriale);
echo $stmt2->execute();
$stmt2=$mysqli->prepare("select * from sipdoor_sn");
$stmt2->execute();
$result = $stmt2->get_result();
var_dump($result->fetch_assoc());