ram1234

Retrieving data from database using php in different forms

Nov 6th, 2017
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. Retrieving data from database using php in different forms
  2. <?php
  3. $servername = "localhost";
  4. $username = "scse";
  5. $password = "scse";
  6.  
  7. //Create connection
  8. $conn = mysqli_connect($servername, $username, $password);
  9.  
  10. // Check connection
  11. if(!$conn)
  12. {
  13. die("Connection failed: " . mysqli_conenct_error());
  14. }
  15.  
  16. if(!mysqli_select_db($conn, "scse"))
  17. {
  18. echo "Database not selected";
  19. }
  20. $sql = "SELECT * FROM register WHERE Name LIKE 's%'";
  21. $result = mysqli_query($conn, $sql);
  22.  
  23. if (mysqli_num_rows($result) > 0) {
  24. // output data of each row
  25. while($row = mysqli_fetch_assoc($result)) {
  26. echo " Name: " . $row["Name"]." - Email: " . $row["Email"]. " - Website: " . $row["Website"]. " - Message " . $row["Message"]. "<br>";
  27. }
  28. } else {
  29. echo "0 results";
  30. }
  31. ?>
Add Comment
Please, Sign In to add comment