Advertisement
Guest User

Untitled

a guest
Jan 15th, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. <?php
  2. $dbhost = '';
  3. $dbuser = '';
  4. $dbpass = '';
  5.  
  6.  
  7. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  8.  
  9. if(! $conn ) {
  10. die('Could not connect: ' . mysql_error());
  11. }
  12. $No=$_GET['No'];
  13. $sql = "SELECT * from tablename where Name='$Name'";
  14. mysql_select_db('dbname');
  15. $retval = mysql_query( $sql, $conn );
  16.  
  17. if(! $retval ) {
  18. die('Could not get data: ' . mysql_error());
  19. }
  20.  
  21. while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
  22.  
  23. ?>
  24.  
  25.  
  26. <table width="100%"><tr><td>
  27. <table>
  28. <tr>
  29. <tr><td class="a" style="width:20%">Name</td><td style="width:20%" class="a"><a class="res" ><?php echo $row['Name'];?></a></td></tr>
  30. <tr><td class="a" style="width:20%">age</td><td style="width:20%" class="a"><a class="res"><?php echo $row['age'];?></a></td></tr>
  31. <tr><td class="a" style="width:20%">country</td><td style="width:20%" class="a"><a class="res"><?php echo $row['country'];?></a></td></tr>
  32. </tr>
  33. </table>
  34.  
  35. <?php
  36. }
  37.  
  38.  
  39. mysql_close($conn);
  40. ?>`
  41.  
  42. <?php if ($row['Name'] != '') {
  43. echo $row['Name'];
  44. } else {
  45. echo "Null";
  46. }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement