".$data['phname']."
"; echo "".$data['exdate']."
"; echo "".$data['stat']."
"; echo "".$data['price']."
"; } }*/ /*if(isset($_POST['btnsearch'])){ $str = $_POST['search']; $sth = $con->prepare("select * from phone where phname = '$str'"); $sth=mysqli_fetch_array(PDO:: FETCH_OBJ) ; $sth=mysqli_execute(); if($r = $sth->fetch()){ echo "".$r->phname."";
echo "".$r->exdate."";
echo "".$r->stat."";
echo "".$r->price."";
}
}
$host ="localhost";
$user ="root";
$pass ="";
$database ="comppho";
$con=mysqli_connect($host,$user,$pass,$database);
$search="";
if(isset($_POST['search'])){
$search=strip_tags($_POST['search']);
}
if(isset($_POST['btnsearch'])){
$r = "select * from phone wher phname = ".$search;
$q = mysqli_query($con ,$r);
while($fetch = mysqli_fetch_assoc($q)){
echo "phone name: ".$fetch['phname']."
" ;
}*/
//@$word = $_POST['search'];
@$pf =strip_tags($_POST['pf']);
@$pt = strip_tags($_POST['pt']);
$sql ="select * from phone where phname like '%$pf%'";
$sql1 ="select * from phone where phname like '%$pt%'";
$s="select phname from phone where phname like '%$pf%'";
$s1="select phname from phone where phname like '%$pt%'";
$query = mysqli_query($con,$sql);
$query1 = mysqli_query($con,$sql1);
$q = mysqli_query($con,$s);
$q1 = mysqli_query($con,$s1);
?>
".$r->exdate."";
echo "".$r->stat."";
echo "".$r->price."";
}
}
$host ="localhost";
$user ="root";
$pass ="";
$database ="comppho";
$con=mysqli_connect($host,$user,$pass,$database);
$search="";
if(isset($_POST['search'])){
$search=strip_tags($_POST['search']);
}
if(isset($_POST['btnsearch'])){
$r = "select * from phone wher phname = ".$search;
$q = mysqli_query($con ,$r);
while($fetch = mysqli_fetch_assoc($q)){
echo "phone name: ".$fetch['phname']."
" ;
}*/
//@$word = $_POST['search'];
@$pf =strip_tags($_POST['pf']);
@$pt = strip_tags($_POST['pt']);
$sql ="select * from phone where phname like '%$pf%'";
$sql1 ="select * from phone where phname like '%$pt%'";
$s="select phname from phone where phname like '%$pf%'";
$s1="select phname from phone where phname like '%$pt%'";
$query = mysqli_query($con,$sql);
$query1 = mysqli_query($con,$sql1);
$q = mysqli_query($con,$s);
$q1 = mysqli_query($con,$s1);
?>
".$r->stat."";
echo "".$r->price."";
}
}
$host ="localhost";
$user ="root";
$pass ="";
$database ="comppho";
$con=mysqli_connect($host,$user,$pass,$database);
$search="";
if(isset($_POST['search'])){
$search=strip_tags($_POST['search']);
}
if(isset($_POST['btnsearch'])){
$r = "select * from phone wher phname = ".$search;
$q = mysqli_query($con ,$r);
while($fetch = mysqli_fetch_assoc($q)){
echo "phone name: ".$fetch['phname']."
" ;
}*/
//@$word = $_POST['search'];
@$pf =strip_tags($_POST['pf']);
@$pt = strip_tags($_POST['pt']);
$sql ="select * from phone where phname like '%$pf%'";
$sql1 ="select * from phone where phname like '%$pt%'";
$s="select phname from phone where phname like '%$pf%'";
$s1="select phname from phone where phname like '%$pt%'";
$query = mysqli_query($con,$sql);
$query1 = mysqli_query($con,$sql1);
$q = mysqli_query($con,$s);
$q1 = mysqli_query($con,$s1);
?>
".$r->price."";
}
}
$host ="localhost";
$user ="root";
$pass ="";
$database ="comppho";
$con=mysqli_connect($host,$user,$pass,$database);
$search="";
if(isset($_POST['search'])){
$search=strip_tags($_POST['search']);
}
if(isset($_POST['btnsearch'])){
$r = "select * from phone wher phname = ".$search;
$q = mysqli_query($con ,$r);
while($fetch = mysqli_fetch_assoc($q)){
echo "phone name: ".$fetch['phname']."
" ;
}*/
//@$word = $_POST['search'];
@$pf =strip_tags($_POST['pf']);
@$pt = strip_tags($_POST['pt']);
$sql ="select * from phone where phname like '%$pf%'";
$sql1 ="select * from phone where phname like '%$pt%'";
$s="select phname from phone where phname like '%$pf%'";
$s1="select phname from phone where phname like '%$pt%'";
$query = mysqli_query($con,$sql);
$query1 = mysqli_query($con,$sql1);
$q = mysqli_query($con,$s);
$q1 = mysqli_query($con,$s1);
?>
" ; }*/ //@$word = $_POST['search']; @$pf =strip_tags($_POST['pf']); @$pt = strip_tags($_POST['pt']); $sql ="select * from phone where phname like '%$pf%'"; $sql1 ="select * from phone where phname like '%$pt%'"; $s="select phname from phone where phname like '%$pf%'"; $s1="select phname from phone where phname like '%$pt%'"; $query = mysqli_query($con,$sql); $query1 = mysqli_query($con,$sql1); $q = mysqli_query($con,$s); $q1 = mysqli_query($con,$s1); ?>