Is mysqli_* a better choice than mysql_*?

Question

I have used PHP for years, and I always use mysql_* functions.

I don't really mind it a lot, but does mysqli_* function worth me to have a try? If I am gonna make a new project, which one should I choose?

Any advice is welcomed. Thanks in advance. :-)

http://php.net/manual/en/mysqlinfo.api.choosing.php – Omesh Aug 09 '12 at 06:39 — Omesh, Aug 09 '12 at 06:39
http://www.php.net/manual/en/intro.mysql.php – kawashita86 Aug 09 '12 at 06:39 — kawashita86, Aug 09 '12 at 06:39
between mysql and mysqli you should choose mysqli – Mihai Matei Aug 09 '12 at 06:41 — Mihai Matei, Aug 09 '12 at 06:41

score 2 · Answer 1 · edited Jan 18 '21 at 12:34

2

Please, don't use mysql_* functions to write new code. They are no longer maintained and the community has begun deprecation process. See the red box? Instead you should learn about prepared statements and use either PDO or MySQLi. If you can't decide which, this article will help you. If you pick PDO, here is good tutorial. (canonical answer from PHP chat, feel free to join)

edited Jan 18 '21 at 12:34

Community

answered Aug 09 '12 at 06:44

Dejan Marjanović

Thank you a lot! Special thanks to @Matei Mihai , who really read my question! – bombless Aug 09 '12 at 07:27
@Leigh every post is a repost repost... are you the original author of the answer? I can name a few. – Dejan Marjanović Aug 09 '12 at 07:40
@webarto No, why so serious? We both see this copy/paste 3-4x a day, just remarking on how it's left its normal home and made it into an answer. – Leigh Aug 09 '12 at 08:24
@Leigh I'll never wake up at 6AM again, everything looks different, carry on with pasting ol' chap :) I'm proud of us :P – Dejan Marjanović Aug 09 '12 at 08:35

score 1 · Accepted Answer · answered Aug 09 '12 at 06:40

1

Use of mysql_* is discouraged.

answered Aug 09 '12 at 06:40

IAmMearl

2 Answers2