Open phpMyAdmin:<\/p>\n\n\n\n Step 2. <\/strong>Open your web browser and navigate to http:\/\/localhost\/phpmyadmin.<\/strong> This will open the phpMyAdmin interface.<\/p>\n\n\n\n Step 3. <\/strong>In the phpMyAdmin interface, click on the “Databases”<\/strong> tab. Enter a name for your database (e.g., “student”<\/strong>) in the “Create database”<\/strong> field.<\/p>\n\n\n\n Click the “Create”<\/strong> button to create the database.<\/p>\n\n\n\n Step 4. <\/strong>After creating the database, click on its name in the left sidebar to select it. Click on the “SQL”<\/strong> tab to run SQL queries. Create a “students”<\/strong> Table: In the SQL tab, enter the following SQL query to create the “students”<\/strong> table:<\/p>\n\n\n\n <\/p>\n\n\n\n Click the “Go”<\/strong> button to execute the query and create the table.<\/p>\n\n\n\n That’s it! You have created a student database with a “students” table. You can now perform CRUD operations on these tables using PHP and MySQL.<\/p>\n\n\n\n You can create a project folder like the following structure.<\/p>\n\n\n\n The following code acts as the connection between the webpage and the database where the data from the webpage will be stored.<\/p>\n\n\n\n The name of the file is dbconfig.php.<\/strong><\/p>\n\n\n\n The name of the file is create-student.php.<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n The name of the file is view-student.php.<\/strong><\/p>\n\n\n\n PHPCopy<\/p>\n\n\n\n The name of the file is update-student.php.<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n The name of the file is delete-student.php.<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n Create database and tables in MySQL using…<\/p>\n","protected":false},"author":1,"featured_media":5129,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[133,75],"tags":[570,134],"class_list":["post-5127","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-web-design","tag-crud","tag-php"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/5127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=5127"}],"version-history":[{"count":3,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/5127\/revisions"}],"predecessor-version":[{"id":5134,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/5127\/revisions\/5134"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/5129"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=5127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=5127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=5127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/isophal.com\/wp-content\/uploads\/2024\/05\/image.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/isophal.com\/wp-content\/uploads\/2024\/05\/image-1.png\")
<\/figure>\n\n\n\n![\"CRUD](\"https:\/\/www.c-sharpcorner.com\/article\/crud-operation-in-php-using-mysql\/Images\/img3.jpg\")
<\/figure>\n\n\n\nCREATE TABLE students (\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(50) NOT NULL,\n age INT,\n email VARCHAR(50),\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);<\/code><\/pre>\n\n\n\nCRUD operations on these tables using PHP and MySQL<\/h2>\n\n\n\n
![\"CRUD](\"https:\/\/www.c-sharpcorner.com\/article\/crud-operation-in-php-using-mysql\/Images\/img4.jpg\")
<\/figure>\n\n\n\nHow to Create a MySQL Database Connection?<\/h2>\n\n\n\n
<?php\n$servername = \"localhost\";\n$username = \"root\";\n$password = \"\";\n$dbname = \"student\";\n$conn = new mysqli($servername, $username, $password, $dbname);\nif ($conn->connect_error) {\n die(\"Connection failed: \" . $conn->connect_error);\n}\n?><\/code><\/pre>\n\n\n\nHow to Create Records?<\/h2>\n\n\n\n
<!DOCTYPE html>\n<html>\n<title>Student Database<\/title>\n<body>\n<h2>Student Form<\/h2>\n<form action=\"\" method=\"POST\">\n <fieldset>\n <legend>Student information:<\/legend>\n Name:<br>\n <input type=\"text\" name=\"name\"> <br>\n Age:<br>\n <input type=\"text\" name=\"age\"> <br>\n Email:<br>\n <input type=\"email\" name=\"email\"><br>\n <br><br>\n <input type=\"submit\" name=\"submit\" value=\"submit\">\n <\/fieldset>\n<\/form>\n<\/body>\n<\/html>\n\n<?php\ninclude \"dbconfig.php\";\n if (isset($_POST['submit'])) {\n $name = $_POST['name'];\n $age = $_POST['age'];\n $email = $_POST['email'];\n $sql = \"INSERT INTO `students`(`name`, `age`, `email`) VALUES ('$name','$age','$email')\";\n $result = $conn->query($sql);\n if ($result == TRUE) {\n echo \"New record created successfully.\";\n header('Location: view-student.php');\n }else{\n echo \"Error:\". $sql . \"<br>\". $conn->error;\n }\n $conn->close();\n }\n?><\/code><\/pre>\n\n\n\n![\"CRUD](\"https:\/\/www.c-sharpcorner.com\/article\/crud-operation-in-php-using-mysql\/Images\/img5.jpg\")
<\/h3>\n\n\n\nHow to View Records?<\/h2>\n\n\n\n
<?php\ninclude \"dbconfig.php\";\n?>\n<!DOCTYPE html>\n<html>\n<head>\n <title>Student Database<\/title>\n<link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.4.0\/css\/bootstrap.min.css\">\n<\/head>\n<body>\n\n <div class=\"container\">\n <h2>Student Details<\/h2>\n<table class=\"table\">\n <thead>\n <tr>\n <th>ID<\/th>\n <th>Name<\/th>\n <th>Age<\/th>\n <th>Email<\/th>\n <th>Action<\/th>\n\n <\/tr>\n <\/thead>\n <tbody>\n <?php\n $sql = \"SELECT * FROM students\";\n $result = $conn->query($sql);\n if ($result->num_rows > 0) {\n while ($row = $result->fetch_assoc()) {\n ?>\n <tr>\n <td><?php echo $row['id']; ?><\/td>\n <td><?php echo $row['name']; ?><\/td>\n <td><?php echo $row['age']; ?><\/td>\n <td><?php echo $row['email']; ?><\/td>\n <td><a class=\"btn btn-info\" href=\"update-student.php?id=<?php echo $row['id']; ?>\">Edit<\/a>\n \n <a class=\"btn btn-danger\" href=\"delete-student.php?id=<?php echo $row['id']; ?>\">Delete<\/a>\n <\/td>\n <\/tr>\n <?php }\n }\n ?>\n <\/tbody>\n<\/table>\n <\/div>\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/www.c-sharpcorner.com\/article\/crud-operation-in-php-using-mysql\/Images\/img6.jpg\")
<\/h3>\n\n\n\nHow to Update Records?<\/h2>\n\n\n\n
<?php\ninclude \"dbconfig.php\";\n if (isset($_POST['update'])) {\n $stu_id = $_POST['stu_id'];\n $name = $_POST['name'];\n $age = $_POST['age'];\n $email = $_POST['email'];\n $sql = \"UPDATE `students` SET `name`='$name',`age`='$age',`email`='$email' WHERE `id`='$stu_id'\";\n $result = $conn->query($sql);\n if ($result == TRUE) {\n echo \"Record updated successfully.\";\n header('Location: view-student.php');\n }else{\n echo \"Error:\" . $sql . \"<br>\" . $conn->error;\n }\n\n }\n\nif (isset($_GET['id'])) {\n $stu_id = $_GET['id'];\n $sql = \"SELECT * FROM students WHERE id='$stu_id'\";\n $result = $conn->query($sql);\n if ($result->num_rows > 0) {\n while ($row = $result->fetch_assoc()) {\n $id = $row['id'];\n $name = $row['name'];\n $age = $row['age'];\n $email = $row['email'];\n }\n ?>\n\n <h2>Student details Update Form<\/h2>\n <form action=\"\" method=\"post\">\n <fieldset>\n <legend>Personal information:<\/legend>\n Name:<br>\n <input type=\"text\" name=\"name\" value=\"<?php echo $name; ?>\">\n <input type=\"hidden\" name=\"stu_id\" value=\"<?php echo $id; ?>\">\n <br>\n Age:<br>\n <input type=\"text\" name=\"age\" value=\"<?php echo $age; ?>\">\n <br>\n Email:<br>\n <input type=\"email\" name=\"email\" value=\"<?php echo $email; ?>\">\n <br><br>\n <input type=\"submit\" value=\"Update\" name=\"update\">\n <\/fieldset>\n <\/form>\n <\/body>\n <\/html>\n\n\n <?php\n } else{\n header('Location: view-student.php');\n }\n}\n?><\/code><\/pre>\n\n\n\n![\"CRUD](\"https:\/\/www.c-sharpcorner.com\/article\/crud-operation-in-php-using-mysql\/Images\/img7.jpg\")
<\/figure>\n\n\n\nHow to Delete Records?<\/h2>\n\n\n\n
\u200b<?php\ninclude \"dbconfig.php\";\nif (isset($_GET['id'])) {\n $stu_id = $_GET['id'];\n $sql = \"DELETE FROM students WHERE id ='$stu_id'\";\n $result = $conn->query($sql);\n if ($result == TRUE) {\n echo \"Record deleted successfully.\";\n header('Location: view-student.php');\n }else{\n echo \"Error:\" . $sql . \"<br>\" . $conn->error;\n }\n}\n?><\/code><\/pre>\n\n\n\nConclusion<\/h2>\n","protected":false},"excerpt":{"rendered":"