bUTschy.de

PDO::PARAM_

Hier nur kurz eine PDO Funktionsweise mit bindParam

#prepare #bindParam #execute #PDO::PARAM

SELECT

$sql = 'SELECT `uid` FROM * WHERE `uid` = :uid';
$stmt = $db->prepare($sql);
$stmt->bindParam(':uid', $_POST['uid'], PDO::PARAM_INT);
$stmt->execute();

INSERT

$sql = 'INSERT INTO * (uname) VALUES (:uname)';
$stmt = $db->prepare($sql);
$stmt->bindParam(':uname', $_POST['uname'], PDO::PARAM_STR);      
$stmt->execute();

UPDATE

$sql = 'UPDATE * SET `uname` = :uname WHERE `uid` = :uid';
$stmt = $db->prepare($sql);                                 
$stmt->bindParam(':uname', $_POST['uname'], PDO::PARAM_STR);      
$stmt->bindParam(':uid', $_POST['uid'], PDO::PARAM_INT);  
$stmt->execute();

DELETE

$sql = 'DELETE FROM * WHERE `uid` = :uid';
$stmt = $db->prepare($sql);
$stmt->bindParam(':uid', $_POST['uid'], PDO::PARAM_INT);  
$stmt->execute();

▼ Kommentare