Pass PDO prepared statement to variables

Question

I am using a prepared statement to upload submitted information into a MYSQL database  I would like to know how to pass my prepared statements to a separate variable so I can post a summary of what was uploaded  Here is the following code    stmt    dbh- gt prepare  INSERT INTO photos  Name  Type  Price  Description  Location     status  id   VALUES   item name   item type   item price   item description   image location   status   id      stmt- gt bindValue   item name     POST  item name      stmt- gt bindValue   item type     POST  item type      stmt- gt bindValue   item price     POST  item price      stmt- gt bindValue   item description     POST  item description      stmt- gt bindValue   image location    images     FILES  file    name      stmt- gt bindValue   status   0    stmt- gt bindValue   id   0    try       stmt- gt execute     catch PDOException  e        errors      item name    not saved in database        echo  e- gt getMessage      I suppose my question is  How does PHP store the  stmt variable and then execute it  Is   stmt- gt execute     being treated as an array  If so how can I access each prepared value so I can post a summary of each value   Thank you

User · Accepted Answer

Instead of using - gt bindParam   you can pass the data only at the time of - gt execute      data         item name    gt    POST  item name        item type    gt    POST  item type        item price    gt    POST  item price        item description    gt    POST  item description        image location    gt   images     FILES  file    name        status    gt  0      id    gt  0       stmt- gt execute  data     In this way you would know exactly what values are going to be sent

User · Answer

You could do  stmt- gt queryString to obtain the SQL query used in the statement  If you want to save the entire  stmt variable  I can t see why   you could just copy it  It is an instance of PDOStatement so there is apparently no advantage in storing it

[php] Pass PDO prepared statement to variables

Examples related to php

Examples related to pdo