Re: Trying to Play Catch-Up & get the Bigger Picture
| From: | Christoph Becker | Date: | Wed, 02 Mar 2016 20:34:17 +0000 |
| Subject: | Re: Trying to Play Catch-Up & get the Bigger Picture | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-325432@lists.php.net to get a copy of this message | ||
On 02.03.2016 at 20:04, Ashley Sheridan wrote:
> On Wed, 2016-03-02 at 08:50 -0800, dealtek@gmail.com wrote:
>> So the question is, big picture, What is the best way to interface with MySQL for this
>> purpose? Would I use:
>>
>> - MySQLi
>> - PDO_MySQL (Am I correct in assuming that PDO is helpful if one may need to move to
>> another database system in the future?)
>>
>> - or maybe web services REST
>> - or ???
>
> Personally I'd always go with PDO, and not because it allows you to
> change the DB backend (I don't know anyone who's ever done this) but
> because it offers parameterised queries (prepared statements) to
> safeguard against a lot of injection attempts:
MySQLi also offers prepared statements, see
<http://php.net/manual/en/mysqli.prepare.php>.
:)
--
Christoph M. Becker