php-general Digest 19 May 2013 10:37:37 -0000 Issue 8236

Topics (messages 321118 through 321121):

Moving from mysql functions to mysqli or PDO - which is best?
        321118 by: dealTek
        321120 by: Matijn Woudt

Re: looking for a PDF generator class/library for PHP 5?
        321119 by: dealTek

Re: ODBC
        321121 by: georg

Administrivia:

To subscribe to the digest, e-mail:
        php-general-digest-subscr...@lists.php.net

To unsubscribe from the digest, e-mail:
        php-general-digest-unsubscr...@lists.php.net

To post to the list, e-mail:
        php-gene...@lists.php.net


----------------------------------------------------------------------
--- Begin Message ---
Hi folks,

[post newbie abilities] - I'm attempting to move away from PHP mysql functions 
to something newer, either mysqli or PDO.

I have read various things about them, but I'm curious at this point which 
would be best to learn for the present and future. I'm usually working on small 
to medium size projects.

I understand that PDO has an extra abstraction layer so it can work with / 
convert to other databases like oracle and others fairly easily, but some have 
said that PDO can be a bit slower the MySQLi?

So I would really like to hear opinions on the best choices of either MySQLi or 
PDO.

Also I'm also trying to learn OOP, so I'm looking for a very good working PDO 
and/or mysqli database class - to get started with, that has all the basic 
needs like UPDATE - INSERT - DELETE - QUERY etc. That would be very helpful.

Thanks in advance for your opinions!


--
Thanks,
Dave - DealTek
deal...@gmail.com
[db-3]


--- End Message ---
--- Begin Message ---
On Sat, May 18, 2013 at 8:09 PM, dealTek <deal...@gmail.com> wrote:

> Hi folks,
>
> [post newbie abilities] - I'm attempting to move away from PHP mysql
> functions to something newer, either mysqli or PDO.
>
> I have read various things about them, but I'm curious at this point which
> would be best to learn for the present and future. I'm usually working on
> small to medium size projects.
>
> I understand that PDO has an extra abstraction layer so it can work with /
> convert to other databases like oracle and others fairly easily, but some
> have said that PDO can be a bit slower the MySQLi?
>
> So I would really like to hear opinions on the best choices of either
> MySQLi or PDO.
>
> Also I'm also trying to learn OOP, so I'm looking for a very good working
> PDO and/or mysqli database class - to get started with, that has all the
> basic needs like UPDATE - INSERT - DELETE - QUERY etc. That would be very
> helpful.
>
> Thanks in advance for your opinions!
>
>
Hi,

Probably some people will say PDO, others will say MySQLi, in general it
doesn't really matter, and I think you have named the biggest differences
in your mail.
So if you're going to stick with MySQL anyway, you can take advantage of
the speed with MySQLi.

What class are you looking for?
MySQLi can be used as a class, and PDO is a class too?

- Matijn

--- End Message ---
--- Begin Message ---
Thanks Jose and Ali - I will look into them.

--
Thanks,
Dave - DealTek
deal...@gmail.com
[db-3]


--- End Message ---
--- Begin Message ---
Hi Negin, tnx for advice,

now however I have successfully downloaded and installed ODBC and
the things needed to connect PHP-ODBC (yum on the same actually)

however, the llinked library file that the odbcinit.ini file points to in order to link the libmimodbc.so library is not found, though the file is obviously at that location

(apache error_log contains a complaint file not found )

so Im still not through completely

/g
----- Original Message ----- From: "Negin Nickparsa" <nickpa...@gmail.com>
To: "georg" <georg.chamb...@telia.com>
Cc: "David OBrien" <dgobr...@gmail.com>; "PHP General" <php-gene...@lists.php.net>
Sent: Saturday, May 18, 2013 7:56 PM
Subject: Re: [PHP] ODBC


do you have the driver in linux?
https://www.microsoft.com/en-us/download/details.aspx?id=28160



On Tue, May 7, 2013 at 11:46 AM, georg <georg.chamb...@telia.com> wrote:

but isnt there some yum command that will fix things for me (download if
necessary, but I actually think
the ODBC would be in the distribution of fedora ?)

br georg

----- Original Message ----- From: "David OBrien" <dgobr...@gmail.com>
To: "georg" <georg.chamb...@telia.com>
Cc: "PHP General" <php-gene...@lists.php.net>
Sent: Monday, May 06, 2013 11:06 PM
Subject: Re: [PHP] ODBC



 On Mon, May 6, 2013 at 3:32 PM, georg <georg.chamb...@telia.com> wrote:

 Hi,

Id like to get ODBC connection to SQL from PHP going. Ive done that on
XP,
but now Im switching
to Linux (Fedora).

My impression in that the connecting part is per the DB designers
responsibility. Im using Mimer-SQL,
but cant find any information on how to set up ODBC for that. Any advice
welcome.

BR georg



http://developer.mimer.com/**howto/howto_57.htm<http://developer.mimer.com/howto/howto_57.htm>



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--- End Message ---

Reply via email to