//データベース接続$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);
CREATE DATABASE dev-c5db DEFAULT CHARACTER SET=utf8mb4;
GRANT ALL PRIVILEGES ON `dev-c5db`.* TO `dev-c5dbuser`@`127.0.0.1` IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `dev-c5db`.* TO `dev-c5dbuser`@`localhost` IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `dev-c5db`.* TO `dev-c5dbuser`@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `dev-c5db`.* TO `dev-c5dbuser`@`Additional IP`
FLUSH PRIVILEGES;
DROP DATABASE `dev-db`;
CREATE DATABASE `dev-db` DEFAULT CHARACTER SET=utf8mb4;
GRANT ALL ON `dev-db`.* to `dev-dbuser`@`127.0.0.1` WITH GRANT OPTION;
GRANT ALL ON `dev-db`.* to `dev-dbuser`@`localhost` WITH GRANT OPTION;
GRANT ALL ON `dev-db`.* to `dev-dbuser`@`XXX.XXX.XXX.XXX` WITH GRANT OPTION;
FLUSH PRIVILEGES;
concrete5
File Storage Location from 2 to 1
UPDATE `Files` SET fslID=REPLACE(fslID, 2,1);
Update user data
Batch change concrete5 User data
UPDATE Users SET uEmail=REPLACE(uEmail, "original", "example");
UPDATE Users SET uEmail=REPLACE(uEmail, "original", "example");
UPDATE Users SET uEmail=CONCAT(uName, '@example.com');
UPDATE Users SET uEmail=CONCAT(uName, '@example.com') WHERE uEmail NOT LIKE "%@concrete5.co.jp";
UPDATE Users SET uName=uID WHERE uID NOT LIKE "1";
UPDATE Users SET uEmail=CONCAT(uID, '@example.com') WHERE uEmail NOT LIKE "%@concrete5.co.jp";
Replace URL
UPDATE atDefault SET value = REPLACE(value, 'http://example.com', 'http://example.net');
UPDATE btContentLocal SET content = REPLACE(content, 'http://example.com', 'http://example.net');
MySQL ユーザー権限
mysqlに切り替え
USE mysql
登録されているユーザを確認
SELECT user, host FROM user;
権限を表示
SHOW GRANTS for 'user'@'%';
SHOW GRANTS for 'user'@'127.0.0.1';
SHOW GRANTS for 'user'@'localhost';
$mix new friendsmysql --sup * creating README.md
* creating .formatter.exs
* creating .gitignore
* creating mix.exs
* creating lib
* creating lib/friendsmysql.ex
* creating lib/friendsmysql/application.ex
* creating test
* creating test/test_helper.exs
* creating test/friendsmysql_test.exs
Your Mix project was created successfully.
You can use "mix" to compile it, test it, and more:
cd friendsmysql
mix test
Run "mix help" for more commands.
$mix new friendsmysql --sup * creating README.md
* creating .formatter.exs
* creating .gitignore
* creating mix.exs
* creating lib
* creating lib/friendsmysql.ex
* creating lib/friendsmysql/application.ex
* creating test
* creating test/test_helper.exs
* creating test/friendsmysql_test.exs
Your Mix project was created successfully.
You can use "mix" to compile it, test it, and more:
cd friendsmysql
mix test
Run "mix help" for more commands.
$mix new friendsmysql --sup * creating README.md
* creating .formatter.exs
* creating .gitignore
* creating mix.exs
* creating lib
* creating lib/friendsmysql.ex
* creating lib/friendsmysql/application.ex
* creating test
* creating test/test_helper.exs
* creating test/friendsmysql_test.exs
Your Mix project was created successfully.
You can use "mix" to compile it, test it, and more:
cd friendsmysql
mix test
Run "mix help" for more commands.
$ mkdir -p $HOME/opt/mysql
$ dbdeployer unpack mysql-5.7.29-macos10.14-x86_64.tar.gz
Unpacking tarball mysql-5.7.29-macos10.14-x86_64.tar.gz to $HOME/opt/mysql/5.7.29
.........100.........200.........300.......376
Renaming directory /Users/hiraoka.yosuke/opt/mysql/mysql-5.7.29-macos10.14-x86_64 to /Users/hiraoka.yosuke/opt/mysql/5.7.29
これで準備は出来たのでdeployしてみる
$ dbdeployer deploy single 5.7.29
Creating directory /Users/hiraoka.yosuke/sandboxes
Database installed in $HOME/sandboxes/msb_5_7_29
run 'dbdeployer usage single' for basic instructions'
... sandbox server started
確認してみると
$ dbdeployer sandboxes
msb_5_7_29 : single 5.7.29 [5729 ]
