1. Create a MySQL database:<\/p>\n\n\n\n
CREATE DATABASE mydatabase;<\/p>\n\n\n\n
2. Create a MySQL user and grant access to the database:<\/p>\n\n\n\n
CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypassword’;<\/p>\n\n\n\n
GRANT ALL PRIVILEGES ON mydatabase.* TO ‘myuser’@’localhost’;<\/p>\n\n\n\n
3. Create a PHP file and establish a connection to the MySQL database:<\/p>\n\n\n\n
<?php<\/p>\n\n\n\n
$servername = “localhost”;<\/p>\n\n\n\n
$username = “myuser”;<\/p>\n\n\n\n
$password = “mypassword”;<\/p>\n\n\n\n
$dbname = “mydatabase”;<\/p>\n\n\n\n
$conn = new mysqli($servername, $username, $password, $dbname);<\/p>\n\n\n\n
if ($conn->connect_error) {<\/p>\n\n\n\n
die(“Connection failed: ” . $conn->connect_error);<\/p>\n\n\n\n
}<\/p>\n\n\n\n
echo “Connected successfully”;<\/p>\n\n\n\n
?><\/p>\n\n\n\n
4. Create a table in the database:<\/p>\n\n\n\n
CREATE TABLE users (<\/p>\n\n\n\n
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
firstname VARCHAR(30) NOT NULL,<\/p>\n\n\n\n
lastname VARCHAR(30) NOT NULL,<\/p>\n\n\n\n
email VARCHAR(50),<\/p>\n\n\n\n
reg_date TIMESTAMP<\/p>\n\n\n\n
);<\/p>\n\n\n\n
5. Insert data into the table:<\/p>\n\n\n\n
INSERT INTO users (firstname, lastname, email)<\/p>\n\n\n\n
VALUES (‘John’, ‘Doe’, ‘john@example.com’);<\/p>\n\n\n\n
6. Retrieve data from the table:<\/p>\n\n\n\n
SELECT * FROM users;<\/p>\n\n\n\n
7. Close the connection:<\/p>\n\n\n\n
$conn->close();<\/p>\n","protected":false},"excerpt":{"rendered":"
1. Create a MySQL database: CREATE DATABASE mydatabase; 2. Create a MySQL user and grant access to the database: CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypassword’; GRANT ALL PRIVILEGES ON mydatabase.* TO ‘myuser’@’localhost’; 3. Create a PHP file and establish a connection to the MySQL database: <?php $servername = “localhost”; $username = “myuser”; $password = “mypassword”; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,1],"tags":[],"class_list":["post-877","post","type-post","status-publish","format-standard","hentry","category-php","category-programming"],"_links":{"self":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/877","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/comments?post=877"}],"version-history":[{"count":2,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/877\/revisions"}],"predecessor-version":[{"id":879,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/877\/revisions\/879"}],"wp:attachment":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/media?parent=877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/categories?post=877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/tags?post=877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}