Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!doctype html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Untitled Document</title>
- </head>
- <body>
- <?php
- $conn=mysqli_connect("localhost","root","","COLLEGE");
- if($conn->connect_error)
- {
- die("Connection Failed".$conn->connect_error);
- }
- echo "Connected successfully<br>";
- $sql="SELECT SID,NAME,EMAIL,FEES,DOB FROM STUDENT";
- $result=mysqli_query($conn,$sql);
- if(mysqli_num_rows($result)>0)
- {
- //Output data at each row
- while($row=mysqli_fetch_assoc($result))
- {
- echo "ID: ".$row["SID"]."Name: ".$row["NAME"]."Email: ".$row["EMAIL"]."FEES: ".$row["FEES"]."DOB: ".$row["DOB"]."<br>";
- }
- }
- else
- {
- echo"0 results";
- }
- $conn->close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement