Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbaddr = "localhost:3306";
- $user="root";
- $pass ="";
- $con = mysqli_connect($dbaddr,$user,$pass,"student");
- if(!$con){ echo "cannot connect to server";}
- else{ echo"server connected";}
- $name =$_POST["name"];
- $enroll =$_POST["e_no"];
- $sem =$_POST["sem"];
- $year =$_POST["year"];
- echo $name ."". $enroll."".$sem."".$year;
- $q1 ="INSERT INTO stud VALUES($name,$enroll,$sem,$year)";
- if(mysqli_query($con,$q1)){echo"query executed";}
- else{ echo "not executed";}
- $res = mysqli_query($con,"SELECT * FROM stud");
- $r = $res->fetch_assoc();
- echo "<html>
- <body>
- <table>
- <tr>
- <th>name</th>
- <th>enroll</th>
- <th>sem</th>
- <th>year</th>
- </tr>
- <tr>
- <td>{$r['name']}</td>
- <td>{$r['enrollment']}</td>
- <td>{$r['semester']}</td>
- <td>{$r['year']}</td>
- </tr>
- </table>
- </body>
- </html>
- ";
- ?>
Add Comment
Please, Sign In to add comment