如何在mysqli中使用PHP变量? [英] How to use a php variable in mysqli?

问题描述

这有效

<?php

         $result = $conn->query('SELECT * FROM people
         WHERE user="55"') or die(mysql_error());  

        $row = mysqli_fetch_array( $result );
         echo $row['name'];
?>

但是当我尝试使用php变量时，以下操作无效:

But when I try to use a php variable, the following does not work:

<?php

     $a = 55; 
     $result = $conn->query('SELECT * FROM people
     WHERE user="$a"') or die(mysql_error());  

    $row = mysqli_fetch_array( $result );
     echo $row['name'];
?>

推荐答案

尝试一下:

$query = 'SELECT * FROM people  WHERE user="'.$a.'"';

这篇关于如何在mysqli中使用PHP变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！