Advertisement
yesamarcos

Faz com PDO ...

Mar 25th, 2018
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.95 KB | None | 0 0
  1. try {
  2.  
  3.     $pdo = new PDO('mysql:host=localhost;dbname=meuBancoDeDados', $username, $password);
  4.     $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  5.  
  6.     $stmt = $pdo->prepare('INSERT INTO publicacao VALUES(:garotagenero, :garotacat, :garotaestado, :garotatilt, :garotatext, :agegarota, :garotatel, :garotamail, :datahora)');
  7.     $stmt->execute(array(
  8.         ':garotagenero'     => $_POST["garotagenero"],
  9.         ':garotacat'        => $_POST["garotacat"],
  10.         ':garotaestado'     => $_POST["garotaestado"],
  11.         ':garotatilt'       => $_POST["garotatilt"],
  12.         ':garotatext'       => $_POST["garotatext"],
  13.         ':agegarota'        => $_POST["agegarota"],
  14.         ':garotatel'        => $_POST["garotatel"],
  15.         ':garotamail'       => $_POST["garotamail"],
  16.         ':datahora'         => date("Y-m-d H:i:s")
  17.     ));
  18.  
  19.     echo $stmt->rowCount();
  20.  
  21. } catch(PDOException $e) {
  22.     echo 'Error: ' . $e->getMessage();
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement