2
I would like to know what are the advantages mysqli_
has in relation to mysql_
, because they keep suggesting me to pass to mysqli_
.
2
I would like to know what are the advantages mysqli_
has in relation to mysql_
, because they keep suggesting me to pass to mysqli_
.
3
Function MySQL
are therefore impaired functions MySQLi
end up being newer, safer, have new features (features) and are object-oriented. Aside from that MySQLi
is an evolution of MySQL
.
There is still an alternative to MySQLi
which is the PDO
(driver that implements the PHP Data Objects interface) that allows working with multiple databases transparently.
I prefer PDO ^_^
@Wallacemaxters Also =D
3
I don’t think you have any idea what it is mysqli_
and mysql_
. These are not different DBMS. They are libraries (extensions) of access to a Mysql database through PHP. The difference is that functions of type mysql_
will be discontinued and the improved mysqli_
to replace.
Although it seems obvious, I fully agree with your explanation of "they are not DBMS". For those who are starting, this may actually seem confusing :\
@Wallacemaxters if you look at the original question you realize it looks like AP thinks they’re DBMS.
@Wallace, the original title, and the context, like the tags, did not include PHP. I also think AP might be confusing it with SGDB. In the first edition I made explicit as php_mysql and php_mysqli, however, someone removed and leftmysql_ and mysqli_..
It was me @Danielomnie didn’t get better like this?
1
By title placing in the manual on the library mysqli
, I answer very simply:
Whymysqli_ is better than mysql_?
Because according to the manual, it’s:
Improved Mysql extension
Look at this one link
Other words: the extension Mysqli
is the evolution of the Mysql
for PHP.
In case, I advise you to leave your codes with mysqli
, since the extension mysql
has already been discontinued (and its use becomes discouraged by PHP staff).
And Mariadb is the same thing as Mysqli ?
No, it’s another SGDB. It’s like the difference of Postgresql, Mysql, Sqlserver, Sqlite and the like :)
Rodrigo... mysql and mysqli to which you refer are only PHP libraries for connection to SGDB Mysql..
When I said "it’s another SGDB" I didn’t mean that Mysqli was an SGDB, but "Maria DB"
Browser other questions tagged php mysqli
You are not signed in. Login or sign up in order to post.
The first reason is simple and obvious. php_mysqli is the enhanced version of php_mysql. The php_mysql library has been obsolete since version 5.5. The recommendation for change has been widely publicized for over 6 years.
– Daniel Omine
It’s hard to deal with duplicates these days. The person asks without researching, people answer without researching, then the AP soon accepts some, even if there is no quality already found on the site, before they close.
– Maniero
see a code using mysql_ormysqli_ is at least nostalgic for me.
– Paulo Roberto Rosa
@bigown by chance I researched quite a lot until, but I did not find this question.
– Jorge B.