Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost:';
  3. $dbuser = 'root';
  4. $dbpass = '';
  5.  
  6. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  7.  
  8. if(! $conn ) {
  9. die('Could not connect: ' . mysql_error());
  10. }
  11.  
  12. $sql = 'SELECT student_name, student_email, student_contact, student_address FROM students';
  13. mysql_select_db('testveeb');
  14. $retval = mysql_query( $sql, $conn );
  15.  
  16. if(! $retval ) {
  17. die('Could not get data: ' . mysql_error());
  18. }
  19.  
  20. while($row = mysql_fetch_assoc($retval)) {
  21. echo "<div class='table-wrap row-bottom'><div class='table-cell-mid bt-row row-right bt-submit-title'> Nimi:</div> <div class='table-cell-mid bt-row'>{$row['student_name']} </div></div> ".
  22. "<div class='table-wrap row-bottom'><div class='table-cell-mid bt-row row-right bt-submit-title'> Email:</div> <div class='table-cell-mid bt-row'>{$row['student_email']} </div></div> ".
  23. "<div class='table-wrap row-bottom'><div class='table-cell-mid bt-row row-right bt-submit-title'> Kontakt:</div> <div class='table-cell-mid bt-row'>{$row['student_contact']} </div></div> ".
  24. "<div class='table-wrap row-bottom'><div class='table-cell-mid bt-row row-right bt-submit-title' style='width: 105px;'> Lisainformatsioon:</div> <div class='table-cell-mid bt-row'>{$row['student_address']} </div></div>";
  25. }
  26.  
  27. echo "<div class='bt-row' style='color: green'>Valmis!\n</div>";
  28.  
  29. mysql_close($conn);
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement