Deprecated mysql functions?

Question

I have changed my code to cater the new functions of MySQLi. Here is a snippet of my code:

From:

mysqli_query("SELECT user_type FROM user");

To:

mysqli_query("SELECT user_type FROM user");

Although this now does not work, what else would I need to change?

yep! However certain functions with `mysqli_` need certain modifications but that will get you started. — Funk Forty Niner, Dec 29 '13 at 19:37
*"Although this now does not work, what else would I need to change?"* You need to post your full code, and not just one line. — Funk Forty Niner, Dec 29 '13 at 19:41

score 2 · Answer 1 · answered Dec 29 '13 at 19:37

2

There are two main options:

The latter lends itself better to OOP techniques.

answered Dec 29 '13 at 19:37

BenM

score 0 · Answer 2 · answered Dec 29 '13 at 19:37

0

Change it to mysqli_query("SELECT user_type FROM user");

or, if you want object oriented

$mysqli = new mysqli('localhost', 'root', 'pass', 'db');
$mysqli->query("SELECT user_type FROM USER")

answered Dec 29 '13 at 19:37

scrblnrd3

2 Answers2