I have decided to take the plunge into the improved MySQL by using MySQLI .
Problem is I cannot find any in-depth yet simple tutorials online. The ones I have found are very short and or does not really explain anything. I know you have the PHP website but to tell you the truth it is really not a easy tutorial to follow, it's a manual and it's confusing for most of the time.
Does anyone know of any good tutorials for a MySQLI newbie? I know the normal MySQL but nothing about MySQLI. I also need tutorials on how you fetch data etc using using mysqli etc as I am not sure if it differs with MySQLi ?
Also can someone tell me why is it that people say you don't have to use
I found these two articles very helpful:
Also, to learn about MySQL prepared statements in general:
About the function mysqli_real_escape_string(), I think they have it for when you are using Mysqli, but not the prepared statements. Because it's not mandatory to use them in order to use Mysqli, actually in some cases they are not advised.
I don't know about a video tutorial, but I hope this is helpful.