PHP MySQL database query for fetching categories data in JSON Format. I run my WordPress website with MySQL database so need to fetch the database categories post data in JSON format and use it on another website created with REST API. In the below code, I will provide MySQL queries that can run on […]
MySql query for fetch WP post_id, post_title, post_date & name with using thumbnail for a particular WordPress category. WordPress also provides some methods for retrieving post data with thumbnails but you can also fetch them with MySQL query. Also, do with same with MySql join in array format. If you are required to display WordPress […]
How to import, export, and create a database in MySQL or MariaDB Create a new database in MySQL or MariaDB First login to MySQL shell or MariaDB in putty using the below command. mysql -u root -p Create new database mysql> create database new_website; Check your database create or not use mysql> show databases; List […]
Developed Simple Rest API data in array convert into JSON fetch from MySQL Database Tables. Below is code for creating JSON Array API data fetch from MySQL database. I use this simple API to get all records entered in a database table. I developed this on localhost requires database configuration changes in the top 4 […]
How to manage MySQL user account, update records, insert records, login into SSH MySQL, and another SSH command for help to learn MySQL in SSH. List of all commands used in SSH for creating a new database, insert the record into the selected database, Alter the table column, login database by SSH client (Putty). Below […]
