Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:99002
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain msn.com designates 40.92.64.64 as permitted sender)
To: "internals@lists.php.net" <internals@lists.php.net>
Thread-Topic: my concept ( new PDO FETCH MODE )
Thread-Index: AdLJpMM5bXdxYgrDSomjp3A06uT41w==
Date: Wed, 10 May 2017 15:51:45 +0000
Message-ID: <DB6PR0801MB1736E67F7FFD4B3053A033A2ADEC0@DB6PR0801MB1736.eurprd08.prod.outlook.com>
Accept-Language: hu-HU, en-US
Content-Language: en-US
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
	boundary="_000_DB6PR0801MB1736E67F7FFD4B3053A033A2ADEC0DB6PR0801MB1736_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-originalarrivaltime: 10 May 2017 15:51:45.5622
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Internet
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1EUR01HT211
Subject: my concept ( new PDO FETCH MODE )
From: Titus1006@msn.com (Csonka Titus)

--_000_DB6PR0801MB1736E67F7FFD4B3053A033A2ADEC0DB6PR0801MB1736_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 c=
ases.

However with the new php7.1 return type declaration(https://wiki.php.net/rf=
c/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), retur=
ning 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 =3D new PDO(dsn, user, pass, driver_options);
    $sql =3D "SELECT * FROM user WHERE name =3D {$pdo->quote($name)}";
    $stmt =3D $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 =3D new PDO(dsn, user, pass, driver_options);
    $sql =3D "SELECT * FROM user WHERE name =3D {$pdo->quote($name)}";
    $stmt =3D $pdo->query($sql);
    $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_NULL_IFNODATA,'UserClas=
s');

    return $stmt->fetch();
}

Looking forward to you answer

Best regards
Miklos Csonka

--_000_DB6PR0801MB1736E67F7FFD4B3053A033A2ADEC0DB6PR0801MB1736_--