DB登録処理のページでFatal errorが出てしまいます...

Question

DB登録処理のページへ遷移した時に下記errorがでます。

Fatal error: Call to a member function prepare() on null in C:\xampp\htdocs\XXX\register_human_thanks.php on line 10

これはなんなのでしょうか？

一応ソースも載せておきます。

<?php
session_start();

$dsn = 'mysql:dbname=test;host=localhost;charset=utf8';
$user = 'root';
$password = '';
$option = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
$dbh = new PDO($dsn, $user, $password, $option);

$stmt = $pdo->prepare("INSERT INTO user_data() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個
$stmt->execute([
$_SEESION['join1']['email'],
password_hash($_SEESION['join1']['pw']),
$_SEESION['join1']['name1'],
$_SEESION['join1']['name2'],
$_SEESION['join1']['name3'],
$_SEESION['join1']['name4'],
$_SEESION['join1']['name5'],
$_SEESION['join1']['name6'],
$_SEESION['join1']['name7'],
$_SEESION['join1']['year'],
$_SEESION['join1']['month'],
$_SEESION['join1']['day'],
$_SEESION['join1']['gender'],
$_SEESION['join1']['first_post'],
$_SEESION['join1']['last_post'],
$_SEESION['join1']['pref'],
$_SEESION['join1']['city'],
$_SEESION['join1']['town'],
$_SEESION['join1']['building'],
$_SEESION['join1']['tel1'],
$_SEESION['join1']['tel2'],
$_SEESION['join1']['tel3']
]);

$stmt = $pdo->prepare("INSERT INTO user_skill() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//スキル年数MAX10セット*2＝20セット（40個）
$stmt->execute([
$_SEESION['jion2']['programs1_1'],
$_SEESION['jion2']['programs_year1_1'],
$_SEESION['jion2']['programs1_2'],
$_SEESION['jion2']['programs_year1_2'],
$_SEESION['jion2']['programs1_3'],
$_SEESION['jion2']['programs_year1_3'],
$_SEESION['jion2']['programs1_4'],
$_SEESION['jion2']['programs_year1_4'],
$_SEESION['jion2']['programs1_5'],
$_SEESION['jion2']['programs_year1_5'],
$_SEESION['jion2']['programs1_6'],
$_SEESION['jion2']['programs_year1_6'],
$_SEESION['jion2']['programs1_7'],
$_SEESION['jion2']['programs_year1_7'],
$_SEESION['jion2']['programs1_8'],
$_SEESION['jion2']['programs_year1_8'],
$_SEESION['jion2']['programs1_9'],
$_SEESION['jion2']['programs_year1_9'],
$_SEESION['jion2']['programs1_10'],
$_SEESION['jion2']['programs_year1_10'],

$_SEESION['jion2']['programs2_1'],
$_SEESION['jion2']['programs_year2_1'],
$_SEESION['jion2']['programs2_2'],
$_SEESION['jion2']['programs_year2_2'],
$_SEESION['jion2']['programs2_3'],
$_SEESION['jion2']['programs_year2_3'],
$_SEESION['jion2']['programs2_4'],
$_SEESION['jion2']['programs_year2_4'],
$_SEESION['jion2']['programs2_5'],
$_SEESION['jion2']['programs_year2_5'],
$_SEESION['jion2']['programs2_6'],
$_SEESION['jion2']['programs_year2_6'],
$_SEESION['jion2']['programs2_7'],
$_SEESION['jion2']['programs_year2_7'],
$_SEESION['jion2']['programs2_8'],
$_SEESION['jion2']['programs_year2_8'],
$_SEESION['jion2']['programs2_9'],
$_SEESION['jion2']['programs_year2_9'],
$_SEESION['jion2']['programs2_10'],
$_SEESION['jion2']['programs_year2_10']
]);

$stmt = $pdo->prepare("INSERT INTO user_qualification() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//資格年数MAX10セット（30個）
$stmt->execute([
$_SEESION['jion2']['certificate1'],
$_SEESION['jion2']['certificate_year1'],
$_SEESION['jion2']['certificate_day1'],
$_SEESION['jion2']['certificate2'],
$_SEESION['jion2']['certificate_year2'],
$_SEESION['jion2']['certificate_day2'],
$_SEESION['jion2']['certificate3'],
$_SEESION['jion2']['certificate_year3'],
$_SEESION['jion2']['certificate_day3'],
$_SEESION['jion2']['certificate4'],
$_SEESION['jion2']['certificate_year4'],
$_SEESION['jion2']['certificate_day4'],
$_SEESION['jion2']['certificate5'],
$_SEESION['jion2']['certificate_year5'],
$_SEESION['jion2']['certificate_day5'],
$_SEESION['jion2']['certificate6'],
$_SEESION['jion2']['certificate_year6'],
$_SEESION['jion2']['certificate_day6'],
$_SEESION['jion2']['certificate7'],
$_SEESION['jion2']['certificate_year7'],
$_SEESION['jion2']['certificate_day7'],
$_SEESION['jion2']['certificate8'],
$_SEESION['jion2']['certificate_year8'],
$_SEESION['jion2']['certificate_day8'],
$_SEESION['jion2']['certificate9'],
$_SEESION['jion2']['certificate_year9'],
$_SEESION['jion2']['certificate_day9'],
$_SEESION['jion2']['certificate10'],
$_SEESION['jion2']['certificate_year10'],
$_SEESION['jion2']['certificate_day10']
]);

$stmt = $pdo->prepare("INSERT INTO user_pr() VALUES (?, ?, ?, ?)");//その他自己ＰＲ
$stmt->execute([
$_SEESION['join2']['major_cat'],
$_SEESION['join2']['major_skill'],
$_SEESION['join2']['agreement'],
$_SEESION['join2']['pr']
]);

session_destroy();
?>

Answer 1

ここでPDO の変数 $dbhなのに

$dbh = new PDO($dsn, $user, $password, $option);

$pdo になってる。

$stmt = $pdo->prepare("INSERT INTO user_data() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個

名ともなエディタ使えばこんなミスしないのに…

Comments

[earnest_gay]

すいません。
ありがとうございます！

Answer 2

Fatal error: Call to a member function prepare() on null in C:\xampp\htdocs\XXX\register_human_thanks.php on line 10
prepare()メソッドを実行させようとしているものがインスタンスではなくnullであることが原因です。

$dbh = new PDO($dsn, $user, $password, $option);

$stmt = $pdo->prepare("INSERT INTO user_data() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個

$pdoではなく、$dbhでは？

Comments

[earnest_gay]

ありがとうございます！

Answer 3

明らかに変数名が違います… $dbh $pdo

$dbh = new PDO($dsn, $user, $password, $option);
$stmt = $pdo->prepare("INSERT INTO user_data() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個

Noticeレベルのエラーも表示するようにすべきですね．php.iniの設定を変えてください．

error_reporting = E_ALL

こうしておくことで， Notice: Undefined variable: pdo というエラーも見えるようになります．

Comments

[earnest_gay]

ありがとうございます！

Answer 4

$dbh = new PDO($dsn, $user, $password, $option);

$pdoじゃなくて$dbhに入ってますよ。

エラーの意味は
Call to a member function prepare() on null
prepareというメンバ関数をnullから呼びだそうとしています

で、原因となる行でprepareを呼び出しているオブジェクトは$pdoです。
そして、遡ってみると$pdoは存在せず、おそらくやりたいことであろうPDOのインスタンスは$dbhという変数に入っています。

Comments

[earnest_gay]

すいません！
ありがとうございます！