PHP/tableData

$dbname = 'test';
$host = 'localhost';
$user = 'root';
$password = '';
$dns = 'mysql:dbname='.$dbname.';host='.$host.';charset=utf8';

try {
    $dbh = new PDO($dns, $user, $password,
        array(
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
    );
    if ($dbh == null) {
        print_r('接続失敗').PHP_EOL;
    } else {
        print_r('接続成功').PHP_EOL;
    }
} catch(PDOException $e) {
    echo('Connection failed:'.$e->getMessage());
    die();
}

$sql = "SELECT * FROM sample";
$stmt = $dbh->query($sql);

table>
	tr>
		th>ID/th>
		th>名前/th>
		th>メールアドレス/th>
		th>パスワード/th>
		th>更新日/th>
		th id="newSign">新規追加/th>
	/tr>
/table>
?php 
foreach($stmt as $row){
? 
table>
	tr>
		td>?php echo $row["id"]; ?/td>
		td>?php echo $row["name"]; ?/td>
		td>?php echo $row["email"]; ?/td>
		td>?php echo $row["password"]; ?/td>
		td>?php echo $row["created"]; ?/td>
		td>編集削除/td>
	/tr>
/table>
?php 
} 
?

$dbname = 'test';
$host = 'localhost';
$user = 'root';
$password = '';
$dns = 'mysql:dbname='.$dbname.';host='.$host.';charset=utf8';

try {
    $dbh = new PDO($dns, $user, $password,
        array(
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
    );
    if ($dbh == null) {
        print_r('接続失敗').PHP_EOL;
    } else {
        print_r('接続成功').PHP_EOL;
    }
} catch(PDOException $e) {
    echo('Connection failed:'.$e->getMessage());
    die();
}

try{
	$dbh->beginTransaction();
	$sql ="INSERT INTO sample(name, email, password, created) 
			VALUES(:name, :email, :password, now())";
	$stmh = $dbh->prepare($sql);
	$stmh->bindValue(':name',
	        $_POST['name'], PDO::PARAM_STR);
	$stmh->bindValue(':email',
	        $_POST['email'], PDO::PARAM_STR);
	$stmh->bindValue(':password',
	        $_POST['password'], PDO::PARAM_STR);
	$stmh->execute();
	$dbh->commit();
	print "データを".$stmh->rowCount()."件挿入しましたbr />";
	}catch(PDOException $Exception){
	$dbh->rollback();
	print "エラー：" .$Exception->getMessage();
}
	

$dbname = 'test';
$host = 'localhost';
$user = 'root';
$password = '';
$dns = 'mysql:dbname='.$dbname.';host='.$host.';charset=utf8';

try {
    $dbh = new PDO($dns, $user, $password,
        array(
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
    );
    if ($dbh == null) {
        print_r('接続失敗').PHP_EOL;
    } else {
        print_r('接続成功').PHP_EOL;
    }
} catch(PDOException $e) {
    echo('Connection failed:'.$e->getMessage());
    die();
}

try{
	$dbh->beginTransaction();
	$sql ="UPDATE sample SET name=:name, email=:email, password=:password, created=now() WHERE id=:id";
	$stmh = $dbh->prepare($sql);
	$stmh->bindValue(':id',
	        $_POST['id'], PDO::PARAM_INT);
	$stmh->bindValue(':name',
	        $_POST['name'], PDO::PARAM_STR);
	$stmh->bindValue(':email',
	        $_POST['email'], PDO::PARAM_STR);
	$stmh->bindValue(':password',
	        $_POST['password'], PDO::PARAM_STR);
	$stmh->execute();
	$dbh->commit();
	print "データを".$stmh->rowCount()."件更新しました
";
	}catch(PDOException $Exception){
	$dbh->rollback();
	print "エラー：" .$Exception->getMessage();
}
	

$dbname = 'test';
$host = 'localhost';
$user = 'root';
$password = '';
$dns = 'mysql:dbname='.$dbname.';host='.$host.';charset=utf8';

try {
    $dbh = new PDO($dns, $user, $password,
        array(
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
    );
    if ($dbh == null) {
        print_r('接続失敗').PHP_EOL;
    } else {
        print_r('接続成功').PHP_EOL;
    }
} catch(PDOException $e) {
    echo('Connection failed:'.$e->getMessage());
    die();
}

try{
	$dbh->beginTransaction();
	$sql = "delete from sample where id = :id";
	$stmh = $dbh->prepare($sql);
	$stmh->bindValue(':id',
	        $_POST['id'], PDO::PARAM_INT);
	$stmh->execute();
	$dbh->commit();
	print "データを".$stmh->rowCount()."件削除しました
";
	}catch(PDOException $Exception){
	$dbh->rollback();
	print "エラー：" .$Exception->getMessage();
}
	

$dbname = 'test';
$host = 'localhost';
$user = 'root';
$password = '';
$dns = 'mysql:dbname='.$dbname.';host='.$host.';charset=utf8';

try {
    $dbh = new PDO($dns, $user, $password,
        array(
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
    );
    if ($dbh == null) {
        print_r('接続失敗').PHP_EOL;
    } else {
        print_r('接続成功').PHP_EOL;
    }
} catch(PDOException $e) {
    echo('Connection failed:'.$e->getMessage());
    die();
}

$statement = $dbh->prepare("SELECT * FROM sample WHERE name LIKE (:name) ");
	
		if($statement){
			$yourname = $_POST['name'];
			$like_yourname = "%".$yourname."%";
			//プレースホルダへ実際の値を設定する
			$statement->bindValue(':name', $like_yourname, PDO::PARAM_STR);
			
			if($statement->execute()){
				//レコード件数取得
				$row_count = $statement->rowCount();
				
				while($row = $statement->fetch()){
					$rows[] = $row;
				}
				
			}else{
				$errors['error'] = "検索失敗しました。";
			}
			
			//データベース接続切断
			$dbh = null;	
		}
?>

?php 
foreach($rows as $row){
? 
table>
	tr>
		td>?php echo $row["id"]; ?>/td>
		td>?php echo $row["name"]; ?>/td>
		td>?php echo $row["email"]; ?>/td>
		td>?php echo $row["password"]; ?>/td>
		td>?php echo $row["created"]; ?>/td>
		td>編集削除/td>
	/tr>
/table>
?php 
} 
?>