Search the Community
Showing results for tags 'php pdo insert update'.
Found 1 result
-
Is this right way to make success message? if (empty($errors)) { $query1 = "UPDATE table SET `value` = `value` - :somevalue WHERE `username` = :username"; $update = $dbh->prepare($query1); $update->bindParam(':somevalue', $_POST['somevalue']); $update->bindParam(':username', $_POST['username']); $success = $update->execute(); if ($success) { print "Success message!"; } } And if i need to execute more than 1 query? if (empty($errors)) { $query1 = "UPDATE table SET `value` = `value` - :somevalue WHERE `username` = :username"; $update = $dbh->prepare($query1); $update->bindParam(':somevalue', $_POST['somevalue']); $update->bindParam(':username', $_POST['username']); $success = $update->execute(); $query2 = "INSERT INTO table1 (`1`, `2`, `3`, `4`, `5`) VALUES (:1, :2, :3, :4, :5)"; $insert = $dbh->prepare($query2); $insert->bindParam(':1', $_POST['1']); $insert->bindParam(':2', $_POST['2']); $insert->bindParam(':3', $_POST['3']); $insert->bindParam(':4', $_POST['4']); $insert->bindParam(':5', $_POST['5']); $success = $insert->execute(); if ($success) { print "Success message!"; } }
