'accounts',
'where' => getNumberFromEndOfUrl(),
'limit' => '1',
'allowSearch' => '0',
));
$accountsRecord = @$accountsRecords[0]; // get first record
// show error message if no matching record is found
if (!$accountsRecord) {
header("HTTP/1.0 404 Not Found");
print "レコードがありません。";
exit;
}
list($kuchikomiRecords, $kuchikomiMetaData) = getRecords(array(
'tableName' => 'kuchikomi',
'where' => "createdByUserNum= '$accountsRecord[num]' ",
'orderBy' => 'updatedDate DESC',
'allowSearch' => '0',
'perPage' => '10',
));
// submit form
if (@$_REQUEST['submit']) {
// error checking
$errorsAndAlerts = "";
if (!@$_REQUEST['title']) { $errorsAndAlerts .= "Please specify title!
\n"; }
// turn off strict mysql error checking for: STRICT_ALL_TABLES
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)
// add record
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}kuchikomi` SET
title = '".mysql_escape( $_REQUEST['title'] )."',
createdDate = NOW(),
updatedDate = NOW(),
dragSortOrder = 'mysql_insert_id()',
createdByUserNum = '$accountsRecord[num]',
updatedByUserNum = '$accountsRecord[num]'")
or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();
// display thanks message and clear form
$errorsAndAlerts = "Thanks, we've added that record!";
$_REQUEST = array();
list($kuchikomiRecords, $kuchikomiMetaData) = getRecords(array(
'tableName' => 'kuchikomi',
'where' => "createdByUserNum= '$accountsRecord[num]' ",
'orderBy' => 'updatedDate DESC',
'perPage' => '10',
));
}
}
?>
ACCOUNT - Detail
num:
account:
user:
shopname:
pref:
city:
area:
other_address:
phone:
link:
EVENT INFORMATION |
MENU |
GALLERY |
COUPON |
COMMENT
COMMENT - List
Title:
« prev
« prev
- ／ -
Next »
Next »
not
« List -
« back -
mailto