Use This Script
<?php
$servername = "localhost";
$username = YOUR_USER;
$password = YOUR_PASSWORD;
$dbname = YOUR_DB_NAME;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$a1 = ($_GET['id']);
$sql = "SELECT post_content FROM `wp_posts` where ID='$a1'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row["post_content"];
}
} else {
echo "0 results";
}
$conn->close();
?>
Don’t Forget To Change Your Database Details Above
Related Posts:
- “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
- Find locations of all featured images of draft posts via SQL
- SQL query to change custom field in WordPress database
- An SQL query to find orphaned image attachments and their meta
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
- Cannot delete or update a parent row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails
- Rename a column in MySQL
- Cannot delete or update a parent row: a foreign key constraint fails
- How do I restore a dump file from mysqldump?
- How do I import an SQL file using the command line in MySQL?
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- What does SQL Select symbol || mean?
- What is the definition of cardinality in SQL
- When to use SELECT … FOR UPDATE?
- Setting up foreign keys in phpMyAdmin?
- SQL Query Where Field DOES NOT Contain $x
- Column ‘user_id’ in field list is ambiguous
- How to join two tables by multiple columns in SQL?
- mysql Foreign key constraint is incorrectly formed error
- Selecting data from two different tables without using joins
- 1052: Column ‘id’ in field list is ambiguous
- 1052: Column ‘id’ in field list is ambiguous
- MySQL: Invalid use of group function
- difference between primary key and unique key
- Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
- Simple Random Samples from a Sql database
- ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
- #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
- What does SQL clause “GROUP BY 1” mean?
- SQL ZOO List each continent and the name of the country that comes first alphabetically
- MySQL Error #1133 – Can’t find any matching row in the user table
- How can I prevent SQL injection in PHP?
- Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
- Generating a random & unique 8 character string using MySQL
- SQL select only rows with max value on a column
- Unknown Column In Where Clause
- SQL statement not working – “Operand type clash: date is incompatible with int’
- Convert partially non-numeric text into number in MySQL query
- phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
- Repair all tables in one go
- How can I search (case-insensitive) in a column using LIKE wildcard?
- How to create a foreign key in phpmyadmin
- importing a CSV into phpmyadmin
- MySQL: Can’t create table (errno: 150)
- #1062 – Duplicate entry for key ‘PRIMARY’
- How to do a batch insert in MySQL
- ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- Remove Primary Key in MySQL
- Is merge statement available in MySQL
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
- How to get the count of each distinct value in a column?
- How do you properly prepare a %LIKE% SQL statement?
- What SQL Query to do a simple find and replace
- Optimize WordPress Query that take 5 seconds to execute
- Scanning Database for malicious Data
- wpdb->prepare function remove single quote for %s in SQL statment
- What specific database privileges does WordPress need?
- Extending the database
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- How to copy post titles to post slug in phpmyadmin
- How to do a MySQL dump from production site without using a search and replace script for local development?
- How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
- SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
- How to find meta entries with their posts missing via SQL?
- Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
- Can’t find my wordpress DB in phpmyadmin
- SQL Database, repeated tables?
- Backing up and restoring multiple sites efficiently
- $wpdb to insert html form information
- Code to remove authors with no posts connected to them
- SQL command to convert all tags in lowercase?
- Which is better and faster ? WordPress Queries or SQL Query
- SQL Query in WordPress – Getting Impossible WHERE error
- Setting up WordPress Locally on WAMP for a new site (with one already)
- How to get INSERT errors from $wpdb?
- Getting Error Trying to Create Table
- Export Yoast Keywords from MySQL/phpMyAdmin
- MySQL query for taxonomy-meta
- How can I write a formal sql query to get data from a custom table
- Editing mysql tables/database with wordpress or other app/cms
- List users with the most posts in the last 30 days
- Export SQL query based on custom field?
- latency problems with wordpress install (from SQL import)
- Data is not constatntly loading from custom wordpress table
- Mysql Server keeps crashing
- DB prefix not updating
- Lock wait timeout exceeded; try restarting transaction
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- How to bulk delete a certain part of all wordpress posts
- When I add metadata, metavalue length is added in to the value in some cases
- WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
- Update WooCommerce stock status with SQL query if stock value is greater than 0
- How to show result of sql query in a page?
- update_option returns false in AJAX, how to debug?
- Improving performance of SQL sub-queries in WordPress