无法获取显示的查询结果 - php / mysqli

Question

<form action="send_post.php" method="post">  
   <p>A: <input type="text" name="A">  
   <p>B: <input type="text" name="B">                                       
   <p><input type="submit">    
</form>     
<?php    
    $db = "localhost"; $usr = "blah1"; $pword = "blah2"; $dbname = "blah3"; 
    -----connects to server ok -------            
    $A = mysqli_real_escape_string($conn, $_POST['A']);  
    $B = mysqli_real_escape_string($conn, $_POST['B']);   
    $query="SELECT * FROM blah4 where A=$A and B=$B";     
    $sql=mysqli_query($conn, $query);         
    echo $sql;                                                
    $conn->clos();                                                                 
?>  

What does it take to display the data from the db?

Answer 1

Your query string is not properly formatted

<form action="send_post.php" method="post">  
   <p>A: <input type="text" name="A"> </p> 
   <p>B: <input type="text" name="B"> </p>                                     
   <p><input type="submit">    </p>
</form>     
<?php    
    $db = "localhost"; $usr = "blah1"; $pword = "blah2"; $dbname = "blah3"; 
    -----connects to server ok -------            
    $A = mysqli_real_escape_string($conn, $_POST['A']);  
    $B = mysqli_real_escape_string($conn, $_POST['B']);   
    $query="SELECT * FROM blah4 where A='$A' and B='$B'";     
    $sql=mysqli_query($conn, $query);         
    echo $sql;                                                
    $conn->close();                                                                 
?>  

or

  $query="SELECT * FROM blah4 where A='".  $A ,"' and B='" .$B ."'";     

you have also not closed </p>

and

$conn->close();