Advertisement
Guest User

insert.php

a guest
May 21st, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2. $db = new SQLite3('minhadb.db');
  3.  
  4. $username = $_GET['username'];
  5. $score = $_GET['score'];
  6.  
  7. $sql = "INSERT INTO score (username, score) VALUES ('{$username}', {$score})";
  8.  
  9.  
  10. if ($db->query($sql) == TRUE) {
  11.     echo "Obrigado pela inserção! <br> <a href='https://paginas.fe.up.pt/~up201603438/lpoo/'>Voltar</a>";
  12. } else {
  13.     echo "Erro! <br><br>Exemplo de inserção: <br> <b>https://paginas.fe.up.pt/~up201603438/lpoo/insert.php?username=vidal&score=13</b> <br><br><b>Tambem podes inserir aqui:</b><br> <br><form action='/~up201603438/lpoo/insert.php'>Username:<br><input type='text' name='username'><br>Score:<br><input type='text' name='score'><br><br><input type='submit' value='Submit'></form> <br><br> <a href= 'https://paginas.fe.up.pt/~up201603438/lpoo/'>Scores</a>";
  14. }
  15. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement