Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <body>
- <div>
- <form style="display:inline_block" action="insert_data.php" method="post">
- FirstName: <input type="text" name="FirstName"><br>
- LastName: <input type="text" name="LastName"><br>
- E-mail: <input type="text" name="email"><br>
- <input type="submit" value="Insert">
- </form>
- <form style="display:inline_block" action="show_data.php">
- <input type="submit" value="Show Database">
- </form>
- <form style="display:inline_block" action="delete_form.html">
- <input type="submit" value="Delete Data">
- </form>
- </div>
- </body>
- </html>
- <html>
- <body>
- <?php
- include('connect_db.php');
- //function insert(){
- $firstname = $_POST["FirstName"];
- $lastname = $_POST["LastName"];
- $email = $_POST["email"];
- echo $firstname . '<br/>' . $lastname . '<br/>' . $email . '<br/>';
- $sql_insert = "INSERT INTO Pacient(firstname,lastname,email)
- VALUES ('$firstname', '$lastname','$email')";
- if( mysqli_query($conn, $sql_insert))
- echo "New record created successfullly";
- else
- die("Failed inserting data: " . mysqli_error($conn));
- //}
- //insert();
- ?>
- <form action="form.php">
- <input type="submit" name="Home" value="Home">
- </form>
- </body>
- </html>
- <html>
- <body>
- <?php
- $servername = "localhost";
- $username = "user";
- $password = "password";
- $dbname = "Data_Base_Name";
- //Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- //Check connection
- if (!$conn)
- die("Connection failed: " . mysqli_error($conn) . '<br/>');
- else
- echo "Connected successfully" . '<br/>';
- if(mysqli_query("USE $dbname" ) )
- die("Failed selecting database: " . mysqli_error($conn) . '<br/>');
- else
- echo "Selected with success" . '<br/>';
- ?>
- </body>
- </html>
- if( mysqli_query($conn, $sql_insert))
- echo "New record created successfullly";
- else
- die("Failed inserting data: " . mysqli_error($conn));
Add Comment
Please, Sign In to add comment