Re: [PHP] Question about sqli class


Both ext/mysql and ext/mysqli work exclusively with MySQL databases. They could not talk to SQLite, which is a different database engine entirely.

If you have the choice and are using MySQL 5 and PHP 5, ext/mysqli is generally faster than ext/mysql. More importantly, it supports native prepared statements which is easier to use and more secure than trying to do your own escaping.

Better still would be to use PDO, which provides the advantages of ext/mysqli and supports a half dozen databases using the same (or nearly the same) OO API.

Even better than that is to write your own thin wrapper API and then use mysqli or PDO under the hood. Then if necessary you can switch from one to another with only minimal impact on your application code.

Whether the API is OO or function-oriented doesn't make a huge difference. Prepared statements do.

--Larry Garfield

On Sun, 30 Dec 2007 20:11:16 +0100, alvaro <iorm@xxxxxxxxxxxxx> wrote:
I don´t know if this is the correct place to ask this questions but I
haver some doubts about using mysqli class in php. I am designing a web
place using wamp2 (php5, mysql 5.0.x ....). My databases have been done
using phpmyadmin so they are "normal" mysql, I mean that I have done
nothing with SQLITE. On the other hand, I am accessing to my databases and
tables using mysqli class and methods for example:
$conn = new mysqli ( ..........) (this is what I am using)
I am using that because I read in the internet that mysqli methods where
more efficient but I don´t know if it´s correct to use that methods with
my mysql database (it runs perfect).

so... is it correct? supposing that it´s correct to use it......is it
faster and better to use mysqli methods than using the functions that were
used before these new classes appeared?

thanks...

my email is:
iorm@xxxxxxxxxxxxx

.

Relevant Pages

  • Re: MySQL & FP
    ... if your hosting service is offering MySQL databases with your ... Unix. ...
    (microsoft.public.frontpage.programming)
  • Mysql->Connect and Ports
    ... use the Mysql->connect with multiple databases. ... does not have info on accessing multiple mysql databases on different ... ports. ...
    (comp.lang.perl.misc)
  • SQL2000/C# vs MySQL/C#
    ... MySQL databases versus a SQL 2000 database? ... My provider gives me 25megs of MySQL space but no ... I want to be able to code using all the technologies ...
    (microsoft.public.dotnet.languages.csharp)
  • Query 2 MySQL databases in 1 statement
    ... I was wondering how it may be possible to query 2 MySQL databases using ... My concern is, when connecting to MySQL, I only ...
    (comp.lang.php)