Call to an undefined function???

[Jwrbloom]

I made some progress, kind of:

http://spieceselect.org

Ok...here is a weird one. On a Page post, I have added the following INCLUDE:

<?php
include (ABSPATH . "resources/2011/profile.php");
?>

The code in that file is:

<?php

$page_data = get_page($page_id);

$playerName = $page_data->post_title;
 

$con = mysql_connect("localhost","jwrbloom_","redcoach");

 mysql_select_db("jwrbloom_wpspselect", $con);    

$query = 'SELECT * FROM team2011 ORDER BY uniform ASC';
$results = mysql_query($query);

while($line = mysql_fetch_assoc($results)) {

    if ($playerName == $line['nameFirst'].' '.$line['nameLast']) {
    
    echo '<div>' . $line['nameFirst'].' '.$line['nameLast'] . '</div>';
        
    }
}
?>

On the Pages the INCLUDE is included, it causes the thumbnail on the Home Page to disappear, and when that entry is active in the Feature Slider, the "Read Now" link links back to the URL, not that Page.

If you visit the intended URL, it all looks good: http://spieceselect.org/dwight-cliff


However, when you remove this...

$page_data = get_page($page_id);

...the thumbnails return to the Home Page and the proper link is active on the Read Now button. Of course the intent of the INCLUDE doesn't work (right now just a test echo), which is a problem. Essentially, when it's all working, it will echo data from a separate data table about each player.

[itsananderson]

I think you're might be overwriting a variable that WordPress needs to display the page.

To reduce frustration for all parties involved, I'm just gonna go ahead and post a shortcode plugin that you can use to do EXACTLY what you're attempting using shortcodes.

 <?php
/*
 Plugin Name: Simple Shortcode
 Plugin Author: Will Anderson
 Plugin URI: http://www.itsananderson.com/
 */

// Usage:
// [player name='First-Last' /]
function handle_player($atts = array(), $content = null) {
    $playerName = addslashes($atts['name']);
    $con = mysql_connect("localhost","jwrbloom_","redcoach");
    mysql_select_db("jwrbloom_wpspselect", $con);
    $query = "SELECT * FROM team2011 WHERE CONCAT(nameFirst, '-', nameLast) = '$playerName' ORDER BY uniform ASC";
    $results = mysql_query($query);

    while($line = mysql_fetch_assoc($results)) {
        echo '<div>' . $line['nameFirst'].' '.$line['nameLast'] . '</div>';
    }
}

add_shortcode('player', 'handle_player');
?>  

If you install this bad boy, you'll just need to go into your player pages and add the following code to get the appropriate player info.

[player name="First-Last" /]

of course, replace the first and last name here with the actual first and last name of the player on each page.

You'll probably need to hack the plugin code a little to get it to display exactly what you need, but I've given you all the structure need.

please somebody (Otto) correct me if any part of this is incorrect.

[Jwrbloom]

I get this error:

Warning: Cannot modify header information - headers already sent by (output started at /home/jwrbloom/public_html/spieceselect.org/wp-content/plugins/profile-query.php:1) in /home/jwrbloom/public_html/spieceselect.org/wp-includes/pluggable.php on line 868

It shut the whole site down. I had to delete the file from the server.


I'm just curious how what I had could work on the actual page itself but not in what the Home Page uses from that page.

[itsananderson]

Oops. Should have returned the content rather than outputting it.

Sorry about that. Give this a try.

 <?php
/*
 Plugin Name: Simple Shortcode
 Plugin Author: Will Anderson
 Plugin URI: http://www.itsananderson.com/
 */
 
// Usage:
// [player name='First-Last' /]
function handle_player($atts = array(), $content = null) {
    $playerName = addslashes($atts['name']);
    $con = mysql_connect("localhost","jwrbloom_","redcoach");
    mysql_select_db("jwrbloom_wpspselect", $con);
    $query = "SELECT * FROM team2011 WHERE CONCAT(nameFirst, '-', nameLast) = '$playerName' ORDER BY uniform ASC";
    $results = mysql_query($query);
    $response = ''
    while($line = mysql_fetch_assoc($results)) {
        $response .= '<div>' . $line['nameFirst'].' '.$line['nameLast'] . '</div>';
    }
}
 
add_shortcode('player', 'handle_player');
?>  

[Jwrbloom]

Same error:

Warning: Cannot modify header information - headers already sent by (output started at /home/jwrbloom/public_html/spieceselect.org/wp-content/plugins/profile-query.php:1) in /home/jwrbloom/public_html/spieceselect.org/wp-includes/pluggable.php on line 868

[Jwrbloom]

I changed get_page to get_post in the code that I had written, and it appears to be working.

[itsananderson]

Ok, not sure why my code was throwing that error, but at least you got yours working.