473,387 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Which is the best function to exchange data with mysql?

mikek12004
200 100+
Until now I used mysql_ functions but recenlty heard something about mysqli_ functions which is supposed to be an improved versions of the previous and also saw an object oriented approached introduced in PHP 5, what's the best? Even if the object oriented approach is too complicated is it worth it to go at least to mysqli?
Jun 16 '09 #1
3 1285
dlite922
1,584 Expert 1GB
OOP is another issue (search for OOP on bytes in the last few days, you'll get to know all about it, don't want to start another thread on OOP).

Yes mysqli or PDO functions are better than the normal mysql function.

You won't notice a difference if it's a small app. We like PDO because of it's fetchAll() function that mysql_*() do not have.

Good luck,



Dan
Jun 16 '09 #2
Markus
6,050 Expert 4TB
@dlite922
@OP: Note PDO is a library (also OO) - not native functions like mysqli_* and mysql_*.
Jun 16 '09 #3
Dormilich
8,658 Expert Mod 8TB
another note: MySQLi can be used as functions (like mysql_*) or as classes (like PDO)
Jun 16 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

35
by: Swartz | last post by:
Hi all. I'm working here on a small project of mine. I'm not new to programming, but I'm new to PHP. You have to understand that I'm coming from C++, OOP world, so my code might seems a little...
3
by: Lu | last post by:
Hi, I have a redhat 9 linux machine running apache 2.0.47, mysql 4.0.15, and php 4.3.4. I have been puzzled by this mail() problem for quite a while, could someone please give me some hint on...
11
by: Dave Smithz | last post by:
Having adopted someone else's PHP cope and completing a crash course in the language I came across a (probably common) problem with the current code. On a registration form, whenever users names...
2
by: Mick Kehoe | last post by:
Hi All We are running SQL Server & Outlook with an exchange server. We are looking for a way to import the address book & email details into a database table. We have managed to do this with...
2
by: Joakim Braun | last post by:
Greetings, I'm playing around with a web-based interface to MySQL that would let you manage, create and use databases. So far I'm using PHP to talk to MySQL and query strings to exchange the...
3
by: Amy L. | last post by:
I have a client / server application. I just want to encrypt small amounts of data 1<x<1024 characters or so. I need to load the same Key and IV in both applications. However, both the key and...
4
by: jaYPee | last post by:
I am new to mysql and wondering which one is the best for accessing mysql. I have read this article from mysql website: At present, one can access MySQL using the following 3 interfaces...
9
by: Luke Vogel | last post by:
Hi all. This is a bit of a newbie type question. I am trying to figure out what is the best way to connect to a database; ado.net, odic others? I've found a couple of examples that show you...
0
by: Tom | last post by:
I'm trying to adapt a function I'd written to insert arrays in MySQL to the ADOdb_lite class. The best way to do this would probably be to extend the ADOdb_lite class, but there doesn't seem to be...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.