php mysql to php mysqli

I'm looking to sharpen my mysqli skills... Anyone have any suggestions on sites videos ?? I know php mysql somewhat well but I want to improve my skills to php mysqli. I guess I am looking for a site that will more likely closely relate one another maybe or a better type of a break down.

 

MySQLi overview: http://php.net/manual/en/mysqli.overview.php
MySQL vs MySQLi: http://af-design.com/blog/2009/01/30/php-mysql-vs-mysqli-database-access-metrics/
PHP: Chosing an API: http://php.net/manual/en/mysqlinfo.api.choosing.php
(slightly outside your question's scope, but still): PDO vs. MySQLi: http://net.tutsplus.com/tutorials/php/pdo-vs-mysqli-which-should-you-use/

 

I have been up and down php.net a bunch of times. The af-design.com is something what I was looking for. Thank you

 

I would go for PDO if i was you.

 

I started out with mysqli, but switched over to PDO. Start with PDO is the best option, unless you know that you will never use any other kind of database. PDO prepared statements are also nicer, you don't have remember the number of ???? placeholders, which can be annoying if you have many.

 

yea thats been the big thing.. However with everything I have never ran into over the years there has been very few times where I would have need pdo maybe once but then we ended up switching back.. How often have you guys have it popup where you had to switch the database type?

 

Hi,

I don't really understand this part. If you use mysql you can use PDO in any applications. Why would you switch? switching back what? mysqli?
Apart from that pdo supports many other databases like :
CUBRID (PDO)
MS SQL Server (PDO)
Firebird (PDO)
IBM (PDO)
Informix (PDO)
MySQL (PDO)
MS SQL Server (PDO)
Oracle (PDO)
ODBC and DB2 (PDO)
PostgreSQL (PDO)
SQLite (PDO)
4D (PDO)

 

Sorry that was a spelling mistake. ever=never... I was saying I never really ran into the point where we had to switch databases. However we did end up switching databases. We went from mysql but then a few months later back to mysql again.. Thats all I was saying..

 

I never ran into the issue where I had to switch from MySQL to a different SQL engine. I think that MySQL engine is by far the most efficient engine (along with Percona DB cluster, I really don't see such change).

I do end up using memory key/value storage to make things faster on busy environments, but that is nothing something you can replace in PDO.

 

I am also searching the same contents..Please provide me the best link that will be beneficial for learning

 

http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

 

Seriously? MySQL-engine the most efficient engine? In some cases, yes, but that depends entirely on the amount of data, cluster-availability, types of data etc. I think you'll learn that MySQL is more of a bastard child that can do most things okay-ish, than a really good DB-engine. Albeit, with the latest releases, they've jumped ahead a few miles - problem is, hardly any hosts and environments have implemented these versions yet.

 

thanks guys You have a website for Albeit?

 

Not sure if trolling or not.

 

My sqli has more great then simple sql. sqli has come with new improve then the old sql. read more on www.php.net

 

I like MySQL and mostly use it, so I am not an anti-MySQL person. However, depending on how you define efficient, PostgresSQL has the edge regarding efficiency.

 

Or Oracle which costs a fortune, but scales up better... or msSQL which some dumbass suit writing the checks might force you to deploy on, the kick-ass leanness of sqLite with it's miniscule system requirements, etc, etc...

Simply having the option is hard to turn down.

Though I prefer PDO over mysqli because it doesn't have the dumbass functional fallback wrappers encouraging the use of more overhead (since they are literally just wrappers to the object version)... Well, and I prefer "lazy variables" over bindParam, particularly being able to build multiple result arrays before running multiple execs of the same query.