"when should i use mysqli instead of mysql?" Code Answer

reasons why you should use mysqli extension instead of the mysql extension are many:

mysqli gives you prepared statements - a safer way of sending data to mysql and protecting you from sql injection. this alone should be enough for always choosing mysqli over mysql.
mysqli enables most of the mysql features.
mysqli is object orientated.
mysqli supports prepared statements, transactions and multiple statements.
the old mysql extension is deprecated as of php 5.5.0

and there are other benefits. but mainly, you should focus on security and stabiltity - and mysqli gives you just that.

By user1327961 on June 23 2022