*質問*
mysqlのDBを使用し情報を検索した際に
undefined variable rows
とエラーが標記され値がどうしても取れず
困っております。
ご助言頂ければ嬉しいです。
お願い致します。
<form action="DB_top.php" method="post"> <center>情報ツール(情報*検索)</center> <body background="back.gif" bgcolor="#ccc" class="a"> <br /> <body> <?php $semina_year = $_POST['semina_year']; $semina_month = $_POST['semina_month']; $semina_day = $_POST['semina_day']; $semina_type = $_POST['semina_type']; $name = $_POST['name']; $category = $_POST['category']; $memo = $_POST['memo']; $dsn = 'mysql:host=localhost;dbname=customer;charset=utf8'; $user = 'root'; $password = ''; $dbh = new PDO($dsn, $user, $password); $dbh->query('SET NAMES utf8'); // $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sqlcmd = "SELECT * FROM `customer_semina` WHERE semina_year like '%$semina_year%' and semina_month like '%$semina_month%' and semina_day like '%$semina_day%' and semina_type like '%$semina_type%' and name like '%$name%' and category like '%$category%' and memo like '%$memo%'"; $statement = $dbh->prepare($sqlcmd); $statement->execute(); if($statement){ $like_semina_year = "%".$semina_year."%"; $statement->bindValue(':semina_year', $like_semina_year, PDO::PARAM_STR); } if($statement->execute()){ $row_count = $statement->rowCount(); while($row = $statement->fetch()){ $rows[] = $row;} }else{ $errors['error'] = "検索失敗しました。"; } $dbh = null; ?> <fieldset> <?php foreach($rows as $row){ ?> <br /> <fieldset> <br /> [受講年月日]<input type="text" value="<?php print $row['semina_year']; ?>" class="d-na">年 <input type="text" value="<?php print $row['semina_month']; ?>" class="d-na">月 <input type="text" value="<?php print $row['semina_day'];?> " class="d-na">日 <br /> [セミナー種別]<input type="text" value="<?php print $row['semina_type']; ?>" class="d-ad"> <br /> [氏名]<input type="text" value="<?php echo $row['name']; ?>" class="d-na"> <br /> [受講種別] <input type="text" value="<?php echo $row['category']; ?>" class="d-y"> <br /> [メモ欄] <input type="text" value="<?php echo $row['memo']; ?>" class="d-y"> </fieldset> <?php }?> </fieldset> <br /> <br /> <input type="button" onclick="location.href='DB_top.php'" value="トップ戻る"> </body> </html>
ソースコードのインデントを揃え、無駄な改行は削ってください。
回答4件
あなたの回答
tips
プレビュー