Difference between mysql and mysqli
mysqli is the oop version of mysql,mysqli suppport some aditional functions that not in mysql(for example prepared statements,multiple statements and transactions,debugging capabilities and enhanced server support etc).