mysql到mysqli php，只是把“我”？ [重复]

Question

This question already has an answer here:

• How to change mysql to mysqli? 10 answers

i have a website that is online about 5 years. just now I noticed that i use mysql connection.

I want to change it to mysqli.

So, I have some questions. To change mysql to mysqli I just need to put "i" after all mysql words?

query

eg
 $i=mysql_query("INSERT

to
 $i=mysqli_query("INSERT

num rows:

$num = mysql_num_rows($rs);
to
$num = mysqli_num_rows($rs);

string escape:

mysql_real_escape_string
to
mysqli_real_escape_string

fetch arraw

 $l = mysql_fetch_array($re);
to
 $l = mysqli_fetch_array($re);

is that simple? or i need to know something else?

</div>

Answer 1

No it's not that simple..mysqli functions usually take a second parameter...so check the syntax of whatever functions you are changing. For instance..instead of mysql_connect("localhost", "my_user","my_password"); for mysqli you will use mysqli_connect("localhost","my_user","my_password","my_db");