CRUD

 <?php

$host = "localhost";

$user = "root";

$pass = "";

$db = "crud_db";


$conn = new mysqli($host, $user, $pass, $db);

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

}


$id = $_GET['id'] ?? null;

$action = $_GET['action'] ?? '';

$name = '';

$email = '';


if ($_SERVER["REQUEST_METHOD"] === "POST") {

    $name = $_POST['name'];

    $email = $_POST['email'];


    if ($_POST['action'] === "create") {

        $conn->query("INSERT INTO users (name, email) VALUES ('$name', '$email')");

    } elseif ($_POST['action'] === "update" && isset($_POST['id'])) {

        $id = $_POST['id'];

        $conn->query("UPDATE users SET name='$name', email='$email' WHERE id=$id");

    }

    header("Location: " . $_SERVER['PHP_SELF']);

    exit;

}


if ($action === "delete" && $id) {

    $conn->query("DELETE FROM users WHERE id=$id");

    header("Location: " . $_SERVER['PHP_SELF']);

    exit;

}


if ($action === "edit" && $id) {

    $result = $conn->query("SELECT * FROM users WHERE id=$id");

    $row = $result->fetch_assoc();

    $name = $row['name'];

    $email = $row['email'];

}

?>

<!DOCTYPE html>

<html>

<head><title>Single File PHP CRUD</title></head>

<body>

<h2>Simple PHP CRUD (Single File)</h2>


<form method="POST">

    <input type="hidden" name="action" value="<?= $action === 'edit' ? 'update' : 'create' ?>">

    <?php if ($action === 'edit') echo '<input type="hidden" name="id" value="' . $id . '">'; ?>

    Name: <input type="text" name="name" value="<?= htmlspecialchars($name) ?>" required><br><br>

    Email: <input type="email" name="email" value="<?= htmlspecialchars($email) ?>" required><br><br>

    <input type="submit" value="<?= $action === 'edit' ? 'Update' : 'Add' ?> User">

    <a href="<?= $_SERVER['PHP_SELF'] ?>">Cancel</a>

</form>


<h3>User List</h3>

<table border="1" cellpadding="5">

    <tr><th>ID</th><th>Name</th><th>Email</th><th>Actions</th></tr>

    <?php

    $result = $conn->query("SELECT * FROM users");

    while ($row = $result->fetch_assoc()) {

        echo "<tr>

                <td>{$row['id']}</td>

                <td>" . htmlspecialchars($row['name']) . "</td>

                <td>" . htmlspecialchars($row['email']) . "</td>

                <td>

                    <a href='?action=edit&id={$row['id']}'>Edit</a> |

                    <a href='?action=delete&id={$row['id']}' onclick='return confirm(\"Delete this user?\")'>Delete</a>

                </td>

              </tr>";

    }

    ?>

</table>

</body>

</html>









🛠 Setup Steps

  1. Create database in phpMyAdmin:

sql


CREATE DATABASE crud_db;

USE crud_db;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

  1. Save the above PHP code as crud.php in your XAMPP htdocs folder.

  2. Run Apache + MySQL, go to:

http://localhost/crud.php

Comments

Post a Comment

Popular posts from this blog

COMPILER END

 flex example.l gcc lex.yy.c -o lexer -lfl ./lexer example.l example.y bison -d example.y        # generates y.tab.c and y.tab.h flex example.l            # generates lex.yy.c gcc lex.yy.c y.tab.c -o parser -lfl ./parser Q1. Design a LEX Code to count the number of lines, space, tab-meta character, and rest of characters in each Input pattern. Solution: %{ #include<stdio.h> int line = 0 , space = 0 , tab = 0 , meta = 0 , other = 0; %} %% "\n" {line++;} " " {space++;} "\t" {tab++;} [\^\$\%\*\+\-\/\&\(\)\{\}\[\]\;\"] {meta++;} . {other++;} %% int main(){ yylex(); printf("Line:%d\n",line); printf("Space:%d\n",space); printf("Tab:%d\n",tab); printf("Meta:%d\n",meta); printf("Other:%d\n",other); return 0; } int yywrap(){ return 1; } Output: int main(){ cout << "hello"; } Line:3 Space:3 Tab:1 Meta:7 Other:18 Q2. Design a LEX Code to identify and print valid Identifier of C/C++ in gi...
Read more

HTML form

 <!DOCTYPE html> <html> <head>   <title>Simple Form</title>   <style>     .error { color: red; font-size: 0.9em; }   </style> </head> <body>   <form onsubmit="return checkForm()">     Name: <input type="text" id="name"><span class="error" id="nameErr"></span><br><br>     Email: <input type="text" id="email"><span class="error" id="emailErr"></span><br><br>     Password: <input type="password" id="pass"><span class="error" id="passErr"></span><br><br>     Confirm Password: <input type="password" id="cpass"><span class="error" id="cpassErr"></span><br><br>     Age: <input type="number" id="age"><span class="err...
Read more

REACT CALCULATOR

 import React, { useState } from 'react'; export default function Calculator() {   const [display, setDisplay] = useState('0');   const [previousValue, setPreviousValue] = useState(null);   const [operation, setOperation] = useState(null);   const [waitingForNewValue, setWaitingForNewValue] = useState(false);   const inputNumber = (num) => {     if (waitingForNewValue) {       setDisplay(String(num));       setWaitingForNewValue(false);     } else {       setDisplay(display === '0' ? String(num) : display + num);     }   };   const inputOperator = (nextOperator) => {     const inputValue = parseFloat(display);     if (previousValue === null) {       setPreviousValue(inputValue);     } else if (operation) {       const newValue = calculate(previousValue, inputValue, operation);       setPrevious...
Read more