PHP PDO NOTES

<?php
$stmt = $pdo->prepare('SELECT * FROM users WHERE email = ? AND status=?');
$stmt->execute([$email, $status]);
$user = $stmt->fetch();
// or
$stmt = $pdo->prepare('SELECT * FROM users WHERE email = :email AND status=:status');
$stmt->execute(['email' => $email, 'status' => $status]);
$user = $stmt->fetch();
?>

udpate.php

<?
$key = 'key'
$value = "value"

$stmt = $pdo->prepare('SELECT * FROM `settings` WHERE keyname = :keynamel');
$stmt->execute(['keyname' => $key]);
$settingRow = $stmt->fetch();

if($settingRow){
  //update

$stmt = $pdo->prepare('UPDATE `settings` SET `value` = :value WHERE `settings`.`keyname` = :keyname');
  $stmt->execute(['keyname' => $key,'value'=>$value]);
  $result = $stmt->fetch();
}
else{
 //create new 
  $stmt = $pdo->prepare('INSERT INTO `settings` (`id`, `keyname`, `value`) VALUES (NULL, :keyname , :value');
  $stmt->execute(['keyname' => $key,'value'=>$value]);
  $result = $stmt->fetch();
}