PHP で MySQL のデータを扱う際に良く使う SQL とかその辺

1
2
3
4
5
6
7
8
9
10

$db_user = 'username';
$db_name = 'dbname';
$db_host = 'localhost';
$db_pass = 'password';
 
$db = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name);
mysql_query("SET NAMES utf8");
mb_internal_encoding('UTF-8');
mb_regex_encoding('UTF-8');

1
2
3
4
5
6
7

$sql = "select * from member where address = '東京都'";
$result = mysql_query($sql);
if(mysql_num_rows($result)>0) {
	echo '既存のデータです。';
} else {
	echo 'データがありません。';
}

1
2
3

while ($value = mysql_fetch_assoc($result)) {
	echo $value['name']."<br />\n";
}

1
2
3
4
5
6
7
8
9
10
11

$sql = "select * from member where id = '14578'";
$result = mysql_query($sql);
$member = mysql_fetch_array($result);
 
if(isset($member)) {
	echo $member['name']."<br />\n";
	echo $member['address']."<br />\n";
	echo $member['email']."<br />\n";
} else {
	echo 'データがありません。';
}

1
2

$sql = "insert into member (id, name) values (10, 'ナギ')";
$result = mysql_query($sql);

1
2

$sql = "UPDATE member set name = 'ナギ' where id = 78964";
$result = mysql_query($sql);