Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:99003
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.218.52 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <DB6PR0801MB1736E67F7FFD4B3053A033A2ADEC0@DB6PR0801MB1736.eurprd08.prod.outlook.com>
References: <DB6PR0801MB1736E67F7FFD4B3053A033A2ADEC0@DB6PR0801MB1736.eurprd08.prod.outlook.com>
Date: Wed, 10 May 2017 10:12:15 -0600
Message-ID: <CAObuZdtpvqE4HzpBHMhQPmacFPy+PuAs3+Tm9dfTPdsiL3kJww@mail.gmail.com>
To: Csonka Titus <Titus1006@msn.com>
Cc: "internals@lists.php.net" <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=94eb2c0470ae5a9e6b054f2dbc6f
Subject: Re: [PHP-DEV] my concept ( new PDO FETCH MODE )
From: derokorian@gmail.com (Ryan Pallas)

--94eb2c0470ae5a9e6b054f2dbc6f
Content-Type: text/plain; charset=UTF-8

Couldn't you just use

return $stmt->fetch() ?: null;

to return null instead of false?

On Wed, May 10, 2017 at 9:51 AM, Csonka Titus <Titus1006@msn.com> wrote:

> Greetings,
>
> I want to propose a new PDO FETCH MODE.
>
> Whenever I fetch(http://php.net/manual/en/pdostatement.fetch.php) a
> class, it  returns the new instance of the requested class or false in any
> other cases.
>
> However with the new php7.1 return type declaration(https://wiki.php.
> net/rfc/nullable_types) Upon defining a nullable class as return type, I
> need to add extra code at the end of my function if my database don't have
> a row to return.
>
> PDO will return a false, my function will trigger a fatal error.
>
> My proposal is to add a new style of fetch(PDO::FETCH_NULL_IFNODATA),
> returning null if the PDOStatement::fetch has no result.
>
> //this function will trigger a fatal error if the user is not found
> function getUserByName($name): ?UserClass{
>     $pdo = new PDO(dsn, user, pass, driver_options);
>     $sql = "SELECT * FROM user WHERE name = {$pdo->quote($name)}";
>     $stmt = $pdo->query($sql);
>     $stmt->setFetchMode(PDO::FETCH_CLASS,'UserClass');
>
>     return $stmt->fetch();
> }
>
> //this function will return null representing the absent of user
> function getUserByName($name): ?UserClass{
>     $pdo = new PDO(dsn, user, pass, driver_options);
>     $sql = "SELECT * FROM user WHERE name = {$pdo->quote($name)}";
>     $stmt = $pdo->query($sql);
>     $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_NULL_
> IFNODATA,'UserClass');
>
>     return $stmt->fetch();
> }
>
> Looking forward to you answer
>
> Best regards
> Miklos Csonka
>

--94eb2c0470ae5a9e6b054f2dbc6f--