MySQL PDO Tutorial Lesson 6 - Prepared statements with placeholders

Показать описание

How to use placeholder question marks in prepared statements to return records from a MySQL database to which we have connected using PDO.

Рекомендации по теме

Комментарии

This series of videos helped me get something working that I have been working on for weeks now.

StormVeilGaming

I was waiting for an error to happen. You did come far without any errors though :)

coldmow

Are you a professor omg I've learnt so much from you.

chimpionboy

Hello Rickard i find this verry useful thank u.

zaven

Richard, for some reason the wildcard is not working for me, could you advise please. My code is below. My dbase columns are first last and postcode

$stmt = $db->prepare("SELECT * FROM names WHERE LIKE ?");
$stmt->bindValue(1, '%d%');
$stmt->execute();

while($row =

$first = htmlentities($row['first']);
$last = htmlentities($row['last']);
$pcode =

echo $first . ' ' . $last . ' ' . $pcode . $space;

}

Thanks

DavidAshby

Richard, could you tell me if this statement should work as I am not sure whether it is the statement or the fact I am using it in the wrong place within the code as I am using password_verify()

if($pdo){
$stmt = $pdo->prepare("select * from users where username = :username && password = :password");
$stmt->bindParam(":username", $username);
$stmt->bindParam(":password", $unhashed);
echo '<pre>';
if($stmt->execute()){
$rows =
print_r($rows);
}

}
echo '</pre>';

If I run the statement with just username = :username I get an array returned but the password is causing an issue.

Thanks

DavidAshby

Should you bind every field that you are retrieving or can you just bind the id as the PK or does that open your query to mysql injection?

DavidAshby

MySQL PDO Tutorial Lesson 6 - Prepared statements with placeholders

MySQL PDO Tutorial Lesson 6 - Prepared statements with placeholders

PHP for Beginners: PDO, MySQL, phpMyAdmin - Lesson 6

MySQL PDO Tutorial Lesson 5 - FetchAll method

PHP PDO CRUD Tutorial | #6 PDO MYSQL Daten auslesen

How To Insert Data Into The Database Using PHP Mysql PDO Method | PDO Method To Insert Data Into DB

MySQL PDO Tutorial Lesson 7 - Prepared statements with named parameters

MySQL PDO Tutorial Lesson 3 - Query method

How to Bind MySQL Data Values using PDO - Become a PHP Master - 36

PHP PDO Tutorial Part 2 - Transactions - Env Variables & PHPDotEnv - Full PHP 8 Tutorial

MySQL PDO Tutorial Lesson 8 - Insert, update and delete records

How to Connect To a Database using PHP PDO

6. Update Product (CRUD Operations in PHP and MySQL using PDO)

MySQL PDO Tutorial Lesson 2 - Error catching

MySQL vs. MySQLi - Differences (SQL Interview Q&A)

Learn PHP 11 - MySQL (PDO)

Learn PDO The PHP Data Object - Part 6

MySQL PDO Tutorial Lesson 4 - Fetch method

PHP with MySQL: PDO and Prepared Statements

MySQL PDO Tutorial Lesson 1 - Connection

MySQL PDO Tutorial - Introduction

PHP MySQL/PDO Tutorial in Hindi/Urdu (Insert, Update, Delete) | Part-6

Simplify Your Database Connections with PHP PDO and MySQL

PHP-Intro 11 Databases in PHP using PDO (Part 1)

Part-2 | PHP MySql PDO Tutorial For Beginner | Make Sql Query to Insert & Fetch Data and Exec