mysql查询到mysqli查询UPDATE语句

Question

Im trying to convert mysql query to mysqli but it doesnt work...why? From:

mysql_query("UPDATE views SET views=views+1 WHERE viewID='1'");

To:

$q1 = $mysqli->query("UPDATE views SET views=views+1 WHERE viewID='1'");

Notice: Undefined variable: mysqli in

Fatal error: Call to a member function query() on a non-object

When I do

mysqli_query("UPDATE views SET views=views+1 WHERE viewID='1'");

mysqli_query expects two parameters

Answer 1

Because you have not initialized MySqli object named $mysqli. There are 2 ways of doing that

Procedural

If you want it to do Procedural way you would do it like this

$q1 = mysqli_query($connection,"UPDATE views SET views=views+1 WHERE viewID=1");

Where $connection is the result of mysqli_connect, like this

$connection = mysqli_connect("localhost", "my_user", "my_password", "my_database");

OOP

If you want to do it the OOP way, you would need to initialize your $mysqli like this

$mysqli = new mysqli("localhost", "my_user", "my_password", "my_database");

And then you can query like

$q1=$mysqli->query("UPDATE views SET views=views+1 WHERE viewID=1");

Manual