Guest User

Untitled

a guest
Jun 21st, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. $sql = mysqli_fetch_object($db->query("SELECT username FROM member WHERE userID = 1");
  2.  
  3. $sql = $db->query("SELECT username FROM member WHERE userID = 1");
  4. $query = $sql->fetch(PDO::FETCH_OBJ);
  5.  
  6. $query = $db->query("SELECT username FROM member WHERE userID = 1")->fetch(PDO::FETCH_OBJ);
  7.  
  8. public function run($sql, $bind = array())
  9. {
  10. $stmt = $this->prepare($sql);
  11. $stmt->execute($bind);
  12. return $stmt;
  13. }
  14.  
  15. $sql = "SELECT username FROM member WHERE userID = ?";
  16. $name = $db->run($sql, [1])->fetchColumn();
  17.  
  18. $data = $pdo->prepare('INSERT INTO `data` (data_key, data_value) VALUES (:data_key, :data_value)')->execute($args);
  19. $data = $pdo->prepare('UPDATE `data` SET data_value = :data_value WHERE data_key = :data_key'->execute($args);
Add Comment
Please, Sign In to add comment