Guest User

Untitled

a guest
Oct 26th, 2016
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. <?php
  2. $servername="localhost";
  3. $username="root";
  4. $password="jit123";
  5. $dbname="1jt14cs004db4";
  6.  
  7.  
  8. $conn=new mysqli($servername,$username,$password,$dbname);
  9.  
  10.  
  11. if($conn->connect_error)
  12. {
  13. die("Connection failed:".$conn->connect_error);
  14. }
  15. else
  16. {
  17. $tabname=$_POST["tbname"];
  18. $sql="select * from ".$tabname;
  19. echo $sql;
  20.  
  21. $sqlquery="select * from $tabname";
  22. $result=$conn->query($sqlquery);
  23. if($result->num_rows>0)
  24. {
  25. echo "<table align=\"center\"border=1> <tr> <th>aid</th><th>aname</th><th>acity</th><th>acountry</th> </tr>";
  26.  
  27. while($row=$result->fetch_assoc())
  28. {
  29. echo "<tr><td>$row[author_id]</td><td>$row[aname]</td><td>$row[acity]</td><td>$row[acountry]</td></tr>";
  30. }
  31. echo "</table>";
  32. }
  33. else
  34. echo "Empty set";
  35. }
  36.  
  37.  
  38. $conn->close();
  39.  
  40. ?>
Add Comment
Please, Sign In to add comment