douting0585 2018-07-09 21:37
浏览 40

在管理员菜单上调用字符串上的成员函数prepare()

I created a custom admin menu:

function new_menu() {
    add_menu_page(
        'New Menu',
        'New Menu',
        'administrator',   
        'new_menu',
        'new_menu_content'
    );
}

add_action('admin_menu', 'new_menu');

Inside that new menu, I get some data from a Database:

function fishing_data_content($conn){
    require_once(get_template_directory() . '/connect.php');
    require_once(get_stylesheet_directory() . '/data.php');
}

The connect.php connects to the DB:

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "data";
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, 
$password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    
}catch(PDOException $e){
    echo "Error: " . $e->getMessage();
}

And the data.php fetches some data from that DB:

$stmt = $conn->prepare('SELECT * FROM posts');
    $stmt->execute();
    $values = $stmt->fetchAll();
    foreach($values as $val){
        echo $val . '<br>';
    }
}

Also I tried to require the connection file inside the data.php:

require_once(dirname(__FILE__) . '/connect.php');

But still having the same error:

Fatal error: Call to a member function prepare() on string in /home/public_html/wordpress/wp-content/themes/theme/data.php on line 10
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥20 测距传感器数据手册i2c