Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Add Data</title>
- </head>
- <body>
- <?php
- //including the database connection file
- include_once("config.php");
- if(isset($_POST['Submit'])) {
- $name = mysqli_real_escape_string($mysqli, $_POST['name']);
- $age = mysqli_real_escape_string($mysqli, $_POST['age']);
- $email = mysqli_real_escape_string($mysqli, $_POST['email']);
- // checking empty fields
- if(empty($name) || empty($age) || empty($email)) {
- if(empty($name)) {
- echo "<font color='red'>Name field is empty.</font><br/>";
- }
- if(empty($age)) {
- echo "<font color='red'>Age field is empty.</font><br/>";
- }
- if(empty($email)) {
- echo "<font color='red'>Email field is empty.</font><br/>";
- }
- //link to the previous page
- echo "<br/><a href='javascript:self.history.back();'>Go Back</a>";
- } else {
- // if all the fields are filled (not empty)
- //insert data to database
- $result = mysqli_query($mysqli, "INSERT INTO users(name,age,email) VALUES('$name','$age','$email')");
- //display success message
- echo "<font color='green'>Data added successfully.";
- echo "<br/><a href='index.php'>View Result</a>";
- }
- }
- ?>
- </body>
- </html>
- <?php
- /*
- // mysql_connect("database-host", "username", "password")
- $conn = mysql_connect("localhost","root","root")
- or die("cannot connected");
- // mysql_select_db("database-name", "connection-link-identifier")
- @mysql_select_db("test",$conn);
- */
- /**
- * mysql_connect is deprecated
- * using mysqli_connect instead
- */
- $databaseHost = 'localhost';
- $databaseName = 'test';
- $databaseUsername = 'root';
- $databasePassword = 'root';
- $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName);
- ?>
- <?php
- //including the database connection file
- include("config.php");
- //getting id of the data from url
- $id = $_GET['id'];
- //deleting the row from table
- $result = mysqli_query($mysqli, "DELETE FROM users WHERE id=$id");
- //redirecting to the display page (index.php in our case)
- header("Location:index.php");
- ?>
- <?php
- // including the database connection file
- include_once("config.php");
- if(isset($_POST['update']))
- {
- $id = mysqli_real_escape_string($mysqli, $_POST['id']);
- $name = mysqli_real_escape_string($mysqli, $_POST['name']);
- $age = mysqli_real_escape_string($mysqli, $_POST['age']);
- $email = mysqli_real_escape_string($mysqli, $_POST['email']);
- // checking empty fields
- if(empty($name) || empty($age) || empty($email)) {
- if(empty($name)) {
- echo "<font color='red'>Name field is empty.</font><br/>";
- }
- if(empty($age)) {
- echo "<font color='red'>Age field is empty.</font><br/>";
- }
- if(empty($email)) {
- echo "<font color='red'>Email field is empty.</font><br/>";
- }
- } else {
- //updating the table
- $result = mysqli_query($mysqli, "UPDATE users SET name='$name',age='$age',email='$email' WHERE id=$id");
- //redirectig to the display page. In our case, it is index.php
- header("Location: index.php");
- }
- }
- ?>
- <?php
- //getting id from url
- $id = $_GET['id'];
- //selecting data associated with this particular id
- $result = mysqli_query($mysqli, "SELECT * FROM users WHERE id=$id");
- while($res = mysqli_fetch_array($result))
- {
- $name = $res['name'];
- $age = $res['age'];
- $email = $res['email'];
- }
- ?>
- <html>
- <head>
- <title>Edit Data</title>
- </head>
- <body>
- <a href="index.php">Home</a>
- <br/><br/>
- <form name="form1" method="post" action="edit.php">
- <table border="0">
- <tr>
- <td>Name</td>
- <td><input type="text" name="name" value="<?php echo $name;?>"></td>
- </tr>
- <tr>
- <td>Age</td>
- <td><input type="text" name="age" value="<?php echo $age;?>"></td>
- </tr>
- <tr>
- <td>Email</td>
- <td><input type="text" name="email" value="<?php echo $email;?>"></td>
- </tr>
- <tr>
- <td><input type="hidden" name="id" value=<?php echo $_GET['id'];?>></td>
- <td><input type="submit" name="update" value="Update"></td>
- </tr>
- </table>
- </form>
- </body>
- </html>
- <?php
- //including the database connection file
- include_once("config.php");
- //fetching data in descending order (lastest entry first)
- //$result = mysql_query("SELECT * FROM users ORDER BY id DESC"); // mysql_query is deprecated
- $result = mysqli_query($mysqli, "SELECT * FROM users ORDER BY id DESC"); // using mysqli_query instead
- ?>
- <html>
- <head>
- <title>Homepage</title>
- </head>
- <body>
- <a href="add.html">Add New Data</a><br/><br/>
- <table width='80%' border=0>
- <tr bgcolor='#CCCCCC'>
- <td>Name</td>
- <td>Age</td>
- <td>Email</td>
- <td>Update</td>
- </tr>
- <?php
- //while($res = mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to use mysqli_fetch_array
- while($res = mysqli_fetch_array($result)) {
- echo "<tr>";
- echo "<td>".$res['name']."</td>";
- echo "<td>".$res['age']."</td>";
- echo "<td>".$res['email']."</td>";
- echo "<td><a href="edit.php?id=$res[id]">Edit</a> | <a href="delete.php?id=$res[id]" onClick="return confirm('Are you sure you want to delete?')">Delete</a></td>";
- }
- ?>
- </table>
- </body>
- </html>
Add Comment
Please, Sign In to add comment