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');
select * from masterdoor_sn;
<?php
$par2='YQBwaXBwb1wnO2RlbGV0ZSBmcm9tIG1hc3RlcmRvb3Jfc247LS0=';
$par2=base64_decode($par2);
list ($doorname, $doorpar) = explode(chr(0), $par2);
$namefind=explode(chr(1),$doorpar)[0].chr(1);
echo $namefind;
$stmt2=$mysqli->prepare("select * from masterdoor_sn where sn=?");
$stmt2->bind_param("s",$seriale);
$stmt2->execute();
$result = $stmt2->get_result();
var_dump($result->fetch_assoc());