Issue with custom PHP query

Hi ladydelaluna,

I’ve got an idea for this.

You could use a conditional (IF statement) to assist you with this. It could look something like this:

<?php
if ( is_front_page () )
{ // DO THE FRONT PAGE SLIDER }
else if ( in_array ( $category_id, $categories ) )
{ // DISPLAY THE SLIDER USING THE $category_id VARIABLE AS A FILTER }
?>

In the above example, the $category_id variable is the id of the category currently being viewed and the $categories variable holds an array of all the categories the current post is listed under. The $category_id variable could be acquired at random from the array or passed through the page. There are various methods in the WordPress Codex on how to acquire the category id. The in_array() function checks whether a variable is listed in the array passed to it… in this case, $categories.

Although this example is a tad rough and rather simple, I hope it helps. ??

Hi mattyza – Ummm I can try that, but the problem is I’m not all that proficient in PHP to begin with, so I was hoping to find someone who knew the theme or could figure out what it is… (cause it’s not a slider… lol)

But thank you very much for taking the time to try – I suppose I can see if I can play around somehow, but I’m still hoping for someone to be able to hand me the code I need I guess. lol Thank you!

Hi Ladydelaluna. ??

No problem. ?? I’ll try looking around a bit and see if I can find anything to help. ??

Thanks tons, mattyza! I appreciate the efforts SO much!

Hi ladydelaluna.

Just popping in to let you know I’m working on this. I’m not familiar with the Studiopress theme, although I do believe I’m coming to a solution. Just have to test a few WP functions to make sure I’m on the right path with what I’m thinking for a solution. ??

Hi ladydelaluna.

As mentioned above, I’m not familiar with the construction of the Studiopress WordPress theme. When reading your original post above, the process looks, to me, like this:

Goal: Display images of other posts in the same category(s) as the post currently being viewed.

And the process:

1. If the page being viewed isn’t a single post page, display the images as they are currently.

2. If the page being viewed is a single post page, do the following:

2.1 Determine the IDs of the categories the current post is categorised under.

2.2 Use a custom SQL query to pull the values of all other posts in hte same categories into an array.

2.3 If the query returns no results, display the images as they are on the homepage.

2.4 Otherwise, if the query returns results, loop through and display the images within the results only.

Using the first snippet of code above, we can modify it to read as follows:

<?php
if ( is_single() ) {
// DO CHECKS FOR CATEGORIES, ETC
} else {
// DISPLAY IMAGES AS THEY ARE CURRENTLY
}
?>

Knowing this, we’ve solved step 1.

Step 2 is clear, once the code is in place. The first part looks, in my mind, like this:

<?php
	$categories = get_the_category();

	$category_ids = array();

	foreach ($categories as $category) {
		$category_ids[] = $category->cat_ID;
	}

	global $wpdb;

	$sql = "SELECT
				ID, post_title
			FROM
			" . $wpdb->prefix . "posts
			JOIN
			" . $wpdb->prefix . "term_relationships ON ID = object_id
			WHERE
				post_type = 'post' AND post_status = 'publish' AND ID != " . $post->ID . "
			AND
				(";

	for ($i = 0; $i < count($category_ids); $i++) {
		$sql .= " term_taxonomy_id = " . $category_ids[$i];

		if ($i < count($category_ids)-1) {
			$sql .= " OR ";
		}
	}

	$sql.= ") GROUP BY ID ORDER BY post_date ASC";

	$rs = $wpdb->get_results($sql, ARRAY_A);
?>

Essentially, the above code handles steps 2.1 and 2.2. Steps 2.3 and 2.4 are a matter of running an IF statement that looks something like this:

<?php if (empty($rs)) {
// DISPLAY NORMAL IMAGES
} else {
// DISPLAY CATEGORY SPECIFIC IMAGES
}
?>

As I am unfamiliar with how the images are selected from the database and displayed, I am unable to code the image display itself. If this is using a WordPress custom field, it should have functions such as get_post_meta() in the code snippet, which should be quite clear to decipher and work through. ??

I hope this helps. ??

Oh wow! Thank you so much, I’ll try this all out and will let you know how it works. ??

Awesome! Glad I could help. ??

Did this solution work out?

https://www.leodata.de

With leodata PHP is not problem.