//データベース接続$dsn='mysql:dbname=データベース名;host=localhost';$user='root';$password='パスワード';try{$PDO=newPDO($dsn,$user,$password);}catch(PDOException$e){print('Error:'.$e->getMessage());die();}//データの取得$sql_shop="SELECT * FROM shopdata";$sql_shop_result=$PDO->query($sql_shop);//同じデータのgenreというフィールドがあった場合ひとつだけ取得する（必要に応じて削除可）$sql_genre="SELECT DISTINCT genre FROM shopdata";$sql_genre_result=$PDO->query($sql_genre);//繰り返し処理（連想配列で取得）while($genre_row=$sql_genre_result->fetch(PDO::FETCH_ASSOC)){$genre_rows[]=$genre_row;}
<?php$query=$dbh->query("SELECT COUNT(*) FROM formdata WHERE userid = '".$userid."' AND kind = '".$kind."'");$count=$query->fetchColumn();if($count>0){?><palign="center">投稿が重複しています</p><?php}else{// データの追加$sql='INSERT INTO formdata(id, kind, star, message, userid) VALUES("'.$id.'","'.$kind.'","'.$star.'","'.$message.'","'.$userid.'")';$stmt=$dbh->prepare($sql);$stmt->execute();?><palign="center">投稿ありがとうございました。</p>
//データベース接続$dsn='mysql:dbname=テーブル名;host=localhost';$user='root';$password='パスワード';try{$PDO=newPDO($dsn,$user,$password);}catch(PDOException$e){print('Error:'.$e->getMessage());die();}// データの追加$sql='INSERT INTO formdata(id, kind, star, message, userid) VALUES("'.$id.'","'.$kind.'","'.$star.'","'.$message.'","'.$userid.'")';$stmt=$dbh->prepare($sql);$stmt->execute();//データの編集（更新）$sql=('UPDATE formdata SET star = :star,message = :message WHERE id = :id');$stmt=$PDO->prepare($sql);$params=array(':star'=>$star,':message'=>$message,':id'=>$form_id);$stmt->execute($params);//データの削除$sql=('DELETE FROM formdata where id = :id');$stmt=$PDO->prepare($sql);$params=array(':id'=>$form_id);$stmt->execute($params);
$ docker-compose exec app composer create-project --prefer-dist laravel/laravel .
the input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'
・
・
・
Discovered Package: laravel/tinker
Discovered Package: nesbot/carbon
Discovered Package: nunomaduro/collision
Package manifest generated successfully.
32 packages you are using are looking for funding.
Use the `composer fund`command to find out more!
XXXXXX@XXXXX MINGW64 /c/temp/docker-laravel/infrastructure
$
