#重複チェック
if (-e "./data/$FORM{'id'}\.htm") { &error(); }
#新規開設
if (!open(OUT,"> ./data/$FORM{'id'}\.htm")) { &error(); }
print OUT "<html<head></head><body>\n";
print OUT "</body></html>\n";
close(OUT);
chmod(0666,"./data/$FORM{'id'}\.htm");
読み込みモードでオープン open (FH, "file")
open (FH, "< file")
上書きモードでオープン open (FH, "> file")
追加書き込みモードでオープン open (FH, ">> file")
読み書き両用モードでオープン open (FH, "+> file")
open (FH, "+< file")
パイプ出力用でオープン open (FH, "| コマンド")
パイプ入力用でオープン open (FH, "コマンド |")
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Placemark>
<name>Simple placemark</name>
<description>Attached to the ground. Intelligently places itself
at the height of the underlying terrain.</description>
<Point>
<coordinates>-122.0822035425683,37.42228990140251,0</coordinates>
</Point>
</Placemark>
</kml>
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document>
<Placemark>
<name>CDATA example</name>
<description>
<![CDATA[
<h1>CDATA Tags are useful!</h1>
<p><font color="red">Text is <i>more readable</i> and
<b>easier to write</b> when you can avoid using entity
references.</font></p>
]]>
</description>
<Point>
<coordinates>102.595626,14.996729</coordinates>
</Point>
</Placemark>
</Document>
</kml>
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document>
<Placemark>
<name>Entity references example</name>
<description>
<h1>Entity references are hard to type!</h1>
<p><font color="green">Text is
<i>more readable</i>
and <b>easier to write</b>
when you can avoid using entity references.</font></p>
</description>
<Point>
<coordinates>102.594411,14.998518</coordinates>
</Point>
</Placemark>
</Document>
</kml>
DROP TABLE IF EXISTS `data`;
CREATE TABLE IF NOT EXISTS `data` (
`id` varchar(15) NOT NULL,
`name` varchar(15) NOT NULL,
`age` varchar(3) NOT NULL,
`tel` varchar(15) NOT NULL,
`mes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SELECT * FROM `data` WHERE 1
SELECT `id`, `name`, `age`, `tel`, `mes` FROM `data` WHERE 1
INSERT INTO `data`(`id`, `name`, `age`, `tel`, `mes`) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5])
UPDATE `data` SET `id`=[value-1],`name`=[value-2],`age`=[value-3],`tel`=[value-4],`mes`=[value-5] WHERE 1
DELETE FROM `data` WHERE 1
$sql = "SELECT COUNT(*) AS `行`, `id` FROM `data` GROUP BY `id` ORDER BY `id` LIMIT 0, 30 ";
DROP TABLE IF EXISTS `bungaku`;
CREATE TABLE IF NOT EXISTS `bungaku` (
`sakusya` varchar(12) NOT NULL,
`kai` int(3) NOT NULL,
`nendo` int(4) NOT NULL,
`myoji` varchar(6) NOT NULL,
`namae` varchar(6) NOT NULL,
`sakuhin` varchar(20) NOT NULL,
`shozoku` varchar(6) NOT NULL,
PRIMARY KEY (`sakusya`,`kai`,`nendo`,`myoji`,`namae`,`sakuhin`,`shozoku`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
##Example2
CREATE TABLE IF NOT EXISTS `bungaku` (
`sakusya` varchar(12) NOT NULL default '',
`kai` int(3) NOT NULL default '0',
`nendo` int(4) NOT NULL default '0',
`myoji` varchar(6) NOT NULL default '',
`namae` varchar(6) NOT NULL default '',
`sakuhin` varchar(20) NOT NULL default '',
`shozoku` varchar(6) NOT NULL default '',
PRIMARY KEY (`sakusya`,`kai`,`nendo`,`myoji`,`namae`,`sakuhin`,`shozoku`)
) TYPE=MyISAM;
$result = mysql_query("SELECT kai, nendo, myoji, namae, sakuhin, shozoku FROM $dbname WHERE sakusya='$wid' or kai='$wid' or nendo='$wid' or myoji='$wid' or sakuhin='$wid'");
