CODEWITHSUNDEEP
phpmysqlpdo
Tim C
Tim C

Reputation: 5714

PDO bind multiple values in one statement

Im working with a lot of sql queries. While I have not mastered PDO yet I was hoping to come here for a bit of help since my previous searches didn't deliver much in terms of help. I did come across this link on SO but it seems a bit out of scope to what I am doing

Consider The following code, which works 100%;

public function composeMsg($userID, $toUser, $subject, $msg, $sentOn ){
        $db = DB::getInstance();
        $sql = "INSERT INTO messages (userID, fromID, subject, body, senton) values (:userID, :toUser, :subject, :msg, :sentOn )";
        $stmnt = $db->prepare($sql);
        //NOT EFFICIENT
        $stmnt->bindValue(':userID', $userID);
        $stmnt->bindValue(':toUser', $toUser);
        $stmnt->bindValue(':subject', $subject);
        $stmnt->bindValue(':msg', $msg);
        $stmnt->bindValue(':sentOn', $sentOn);

        $stmnt->execute();
        if($stmnt->rowCount() > 0){
            return true;
        }
        else{
            return false;
        }
    }//FUNCTION

Im finding myself to continuously type $stmnt->bindValue(':value', $value) multiple times as can be seen from the code above. Im looking for a build in PDO function or something similar which I can make use of to avoid all the repetition.

Any advise welcomed

Upvotes: 1

Views: 1358

Answers (1)

Nigel Ren
Nigel Ren

Reputation: 57121

Binding them all as part of the execute...

   $stmnt->execute([':userID'=> $userID,
         ':toUser'=> $toUser,
         ':subject' => $subject,
         ':msg' => $msg,
         ':sentOn' => $sentOn]);

Upvotes: 2

Related Questions