note 121992 added to pdo.prepare
| From: | omidbahrami1990 at gmail dot com | Date: | Wed, 06 Dec 2017 22:09:37 +0000 |
| Subject: | note 121992 added to pdo.prepare | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-209329@lists.php.net to get a copy of this message | ||
This Is A Secure Way To Sign in With pdo::prepare
--------------------------------------------------------
<?php
function secured_signin($username,$password)
{
try
{
$connection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbusername, $dbpassword);
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$prepared = $connection->prepare("SELECT COUNT(
username) FROM
users WHERE username = :bp_username AND password =
:bp_password ; ");
$prepared->bindParam(':bp_username', $username);
$prepared->bindParam(':bp_password', $password);
$prepared->execute();
if ($prepared->fetchColumn() == 1)
$result=true;
else
$result=false;
}
catch(PDOException $x) { die("Secured"); }
$prepared = null;
$connection = null;
return $result;
}
/*
$dbhost ---> DataBase IP Address
$dbusername ---> DataBase Username
$dbpassword ---> DataBase Password
$dbname ---> DataBase Name
*/
?>
----
Server IP: 208.43.231.9
Probable Submitter: 128.199.173.225
----
Manual Page -- http://php.net/manual/en/pdo.prepare.php
Edit -- https://master.php.net/note/edit/121992
Del: integrated -- https://master.php.net/note/delete/121992/integrated
Del: useless -- https://master.php.net/note/delete/121992/useless
Del: bad code -- https://master.php.net/note/delete/121992/bad+code
Del: spam -- https://master.php.net/note/delete/121992/spam
Del: non-english -- https://master.php.net/note/delete/121992/non-english
Del: in docs -- https://master.php.net/note/delete/121992/in+docs
Del: other reasons-- https://master.php.net/note/delete/121992
Reject -- https://master.php.net/note/reject/121992
Search -- https://master.php.net/manage/user-notes.php