Wordpress check if any part of slug exists
up vote
-1
down vote
favorite
I'm using this code block below:
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name = '" . $post_name . "'", 'ARRAY_A'))
return true;
else
return false;
Usage:
if (the_slug_exists($term)) :
echo 'Ok';
endif;
Which seems to work fine. I want to altar the code to check if any part of the slug exists. For example the word "school" . I want to check all Wordpress pages to see if any page has the word "school" in it.
I do know Wordpress also has the function 'get_page_by_title' but I don't believe it will retrieve anything other than the exact title.
php wordpress
asked Nov 9 at 18:46
Michael Vincent
1
add a comment |
up vote
-1
down vote
favorite
I'm using this code block below:
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name = '" . $post_name . "'", 'ARRAY_A'))
return true;
else
return false;
Usage:
if (the_slug_exists($term)) :
echo 'Ok';
endif;
Which seems to work fine. I want to altar the code to check if any part of the slug exists. For example the word "school" . I want to check all Wordpress pages to see if any page has the word "school" in it.
I do know Wordpress also has the function 'get_page_by_title' but I don't believe it will retrieve anything other than the exact title.
php wordpress
asked Nov 9 at 18:46
Michael Vincent
1
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I'm using this code block below:
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name = '" . $post_name . "'", 'ARRAY_A'))
return true;
else
return false;
Usage:
if (the_slug_exists($term)) :
echo 'Ok';
endif;
Which seems to work fine. I want to altar the code to check if any part of the slug exists. For example the word "school" . I want to check all Wordpress pages to see if any page has the word "school" in it.
I do know Wordpress also has the function 'get_page_by_title' but I don't believe it will retrieve anything other than the exact title.
php wordpress
asked Nov 9 at 18:46
Michael Vincent
1
I'm using this code block below:
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name = '" . $post_name . "'", 'ARRAY_A'))
return true;
else
return false;
Usage:
if (the_slug_exists($term)) :
echo 'Ok';
endif;
Which seems to work fine. I want to altar the code to check if any part of the slug exists. For example the word "school" . I want to check all Wordpress pages to see if any page has the word "school" in it.
I do know Wordpress also has the function 'get_page_by_title' but I don't believe it will retrieve anything other than the exact title.
php wordpress
php wordpress
asked Nov 9 at 18:46
Michael Vincent
1
asked Nov 9 at 18:46
Michael Vincent
1
asked Nov 9 at 18:46
Michael Vincent
1
asked Nov 9 at 18:46
Michael Vincent
1
asked Nov 9 at 18:46
Michael Vincent
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
change your SQL query to is LIKE instead of =
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name LIKE '%" . $post_name . "%'", 'ARRAY_A'))
return true;
else
return false;
answered Nov 9 at 18:51
mrben522
1348
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
change your SQL query to is LIKE instead of =
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name LIKE '%" . $post_name . "%'", 'ARRAY_A'))
return true;
else
return false;
answered Nov 9 at 18:51
mrben522
1348
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
add a comment |
up vote
1
down vote
change your SQL query to is LIKE instead of =
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name LIKE '%" . $post_name . "%'", 'ARRAY_A'))
return true;
else
return false;
answered Nov 9 at 18:51
mrben522
1348
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
add a comment |
up vote
1
down vote
up vote
1
down vote
change your SQL query to is LIKE instead of =
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name LIKE '%" . $post_name . "%'", 'ARRAY_A'))
return true;
else
return false;
answered Nov 9 at 18:51
mrben522
1348
change your SQL query to is LIKE instead of =
function the_slug_exists($post_name)
global $wpdb;
if($wpdb->get_row("SELECT post_name FROM wp_posts WHERE post_name LIKE '%" . $post_name . "%'", 'ARRAY_A'))
return true;
else
return false;
answered Nov 9 at 18:51
mrben522
1348
answered Nov 9 at 18:51
mrben522
1348
answered Nov 9 at 18:51
mrben522
1348
answered Nov 9 at 18:51
mrben522
1348
1348
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
add a comment |
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
In the function would I add something like this right before the if statement: $post_name = 'school';
– Michael Vincent
Nov 9 at 18:58
add a comment |
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53231666%2fwordpress-check-if-any-part-of-slug-exists%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
