mysqli_query参数[重复]

Question

This question already has an answer here:

• mysqli_query expects at least 2 parameters 5 answers

Im trying to convert a project of mine from mysql to mysqli but it seems to give me a error

Warning: mysqli_query() expects at least 2 parameters, 1

this is my database connection

$mysqli = new mysqli();
$mysqli->connect('localhost', 'root', '', 'myscript');

this is the query

$sql = mysqli_query("SELECT * FROM settings WHERE id='1'") or die (mysqli_error());
$results = mysqli_fetch_array($sql);

if anyone can tell me how to fix this error i will be grateful. thanks in advance.

</div>

Answer 1

You can try performing your query using Object oriented PHP way instead of mixing and matching Object oriented PHP and regular PHP:

$mysqli = new mysqli();
$mysqli->connect('localhost', 'root', '', 'myscript');
if($result = $mysqli->query("SELECT * FROM settings WHERE id='1'")){

    //DO STUFF

    $result->close();
}else{
     printf("Error: %s
", $mysqli->error);
}