Advertisement
Guest User

Untitled

a guest
Sep 29th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost:3306';
  3. $dbuser = 'root';
  4. $dbpass = '';
  5. $dbname = 'rusttest';
  6. $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);
  7.  
  8. if(! $conn ) {
  9. die('Could not connect: ' . mysqli_error());
  10. }
  11. echo 'Connected successfully<br>';
  12. $id = mysqli_real_escape_string($conn, $_GET['Userid']);
  13. $sql = 'SELECT * from rusttestet where name=$id';
  14. $result = mysqli_query($conn, $sql);
  15.  
  16. if (mysqli_num_rows($result) > 0) {
  17. while($row = mysqli_fetch_assoc($result)) {
  18. echo "Name: " . $row["name"]. "<br>";
  19. }
  20. } else {
  21. echo "0 results";
  22. }
  23. mysqli_close($conn);
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement