Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. public function doQuery ($aParameter) {
  2. .
  3. .
  4. .
  5. $sqlQuery = mysql_query("SELECT * FROM Table WHERE id = '".$aParameter."'");
  6. .
  7. .
  8. .
  9. }
  10.  
  11. public function doQuery ($aParameter) {
  12. .
  13. .
  14. .
  15. $sqlQuery = mysql_query(THE_QUERY);
  16. .
  17. .
  18. .
  19. }
  20.  
  21. define("THE_QUERY", "SELECT * FROM Table WHERE id = '".$aParameter."'");
  22.  
  23. define("Q_QUERY1", "SELECT * FROM Table WHERE id = :1");
  24. $cn = new PDO();
  25. /* more code ... */
  26. $arr = array();
  27. $arr[":1"] = $parameterValue;
  28.  
  29. $s = $cn->prepare(Q_QUERY1);
  30. $s->execute($arr);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement