php エラーでマイページ情報が取得できません

Question

 PHP Warning:  PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in /vagrant/model/mypage.php on line 45

このエラーが出てマイページの情報と画像が表示されません。
ご回答お願いします。

model

<?php
class Mypage
{
    private $db;
    function __construct()
    {
        require_once('../config.php');
        $this->db = new PDO('mysql:host=127.0.0.1;dbname=one_luck;charset=utf8', 'root', DB_PASSWORD);
    }

    public function getIndexByName($session_id)
    {
        $sql='SELECT name FROM mypage WHERE id=?';
        $stmt=$this->db->prepare($sql);
        $params = [$session_id];
        $stmt->execute($params);
        $record = $stmt->fetch(PDO::FETCH_ASSOC);
        return $record;
    }

    public function addMypageByUser($name, $email, $pass)
    {
        $sql = "INSERT INTO mypage (name, email, password) VALUES ('" . $name . "', '" . $email . "', '" . $pass . "')";
        error_log("sql=" . $sql);
        $stm = $this->db->prepare($sql);
        $stm->execute();
        return $this->db->lastInsertId();
    }

    public function loginMypageByUser($mypage_email, $mypage_pass)
    {
        $sql='SELECT * FROM mypage WHERE email=? AND password=?';
        $stmt=$this->db->prepare($sql);
        $data[]=$mypage_email;
        $data[]=$mypage_pass;
        $stmt->execute($data);
        $rec=$stmt->fetch(PDO::FETCH_ASSOC);
        return $rec;
    }

    public function getMypageByUsers($session_id)
    {
        $sql='SELECT * FROM mypage WHERE id=?';
        $stmt=$this->db->prepare($sql);
        $stmt->execute();
        $rec=$stmt->fetch(PDO::FETCH_ASSOC);
        return $rec;
    }

    public function addMypageByImage($id, $fname)
    {
        $sql = "UPDATE mypage set attach_filename = '" . $fname . "' WHERE id = " .$id;
        error_log("sql=" . $sql);
        $stm = $this->db->prepare($sql);
        $stm->execute();
    }
}

mypage.php

<p><input type="button" onClick="location.href='http://192.168.33.10:3000/luckfile/index.php'" value="みんなの投稿"></p>
<?php
require_once('../config.php');
session_start();
$session_id = $_SESSION['id'];
if (! isset($_SESSION['id'])) {
    print 'ログインされていません。 <br />';
    print '<a href="../login/">login</a>';
    exit();
} else {
    require_once('../config.php');
    require_once('model/mypage.php');
    $dbh=new PDO('mysql:host=127.0.0.1;dbname=one_luck;charset=utf8', 'root', DB_PASSWORD);
    $dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    $mypage = new Mypage();
    $rec = $mypage->getMypageByUsers($session_id);
    echo $rec["name"] . "さん、ようこそ <br>";
    echo "メールアドレス" . $rec["email"];
    echo "<br>";
    echo "プロフィール画像";
    echo "<br>";

    if ($rec['attach_filename']) {
        echo "<td><img src='../login/mypage_images/" .$rec['attach_filename'] . "'/></td>";
    } else {
        echo "<td>no image</td>";
    }
}

Answer 1

    public function getMypageByUsers($session_id)
    {
        $sql='SELECT * FROM mypage WHERE id=?';
        $stmt=$this->db->prepare($sql);
        $stmt->execute();
        $rec=$stmt->fetch(PDO::FETCH_ASSOC);
        return $rec;
    }

?プレースホルダ使っておきながら、パラメータを送ってないじゃないか。

Answer 2

エラーのままですね。
パラメータを要求するSQLを突っ込んでいるのにパラメータをセットしていません。

$sql='SELECT * FROM mypage WHERE id=?';

    $stmt=$this->db->prepare($sql);
    $stmt->execute();