function detect_category_name($name) { global $db; $sql = "Select cat_categoryName from categories where cat_categoryName = '{$name}'"; $stmt = $db->prepare($sql); $stmt->execute(); if ($data = $stmt->fetch()) { echo "The Category Name you entered is already in the database, please try another name."; } else { add_categories($name); } }
/** * Update Posted Log */ function update_log_form($mode) { global $cfg, $lang, $row, $text_cols, $log_table; $row['id'] = htmlspecialchars($row['id']); $row['name'] = htmlspecialchars($row['name']); $row['href'] = htmlspecialchars($row['href']); $row['category'] = htmlspecialchars($row['category']); $row['comment'] = htmlspecialchars($row['comment']); $row['mod'] = htmlspecialchars($row['mod']); $row['ping_uri'] = htmlspecialchars($row['ping_uri']); if ($cfg['xml_lang'] == 'ja') { $input_check = 'inputCheck()'; $confirm_delete = 'confirmDelete()'; } else { $input_check = 'inputCheck_e()'; $confirm_delete = 'confirmDelete_e()'; } if ($cfg['trackback'] == 'on') { if ($row['ping_uri'] == '') { $ping_uri = 'http://'; } else { $ping_uri = $row['ping_uri']; } $trackback_ping_form = <<<EOD <p id="trackback-form"> <label for="send-ping-uri">{$lang['tb_sendurl']}:</label><br /> <input type="text" id="send-ping-uri" name="send_ping_uri" size="40" accesskey="z" tabindex="1" value="{$ping_uri}" class="bordered" /> <select name="encode" tabindex="1"> <option value="UTF-8" selected="selected">UTF-8</option> <option value="EUC-JP">EUC-JP</option> <option value="SJIS">Shift_JIS</option> </select> </p> <p> {$lang['send_update_ping']} : <input type="radio" tabindex="1" name="send_update_ping" value="no" checked="checked" />No <input type="radio" tabindex="1" name="send_update_ping" value="yes" />Yes </p> EOD; } else { $trackback_ping_form = ''; } if ($mode == 'draft') { $date = htmlspecialchars($row['date']); $dform = <<<EOD <label for="date-and-time">{$lang['date_and_time']} :</label><br /> <input type="text" id="date-and-time" name="date" tabindex="1" value="{$date}" size="20" class="bordered" /> <input type="checkbox" id="custom-date" name="custom_date" tabindex="1" /><label for="custom-date">{$lang['use_custom_date']}</label><br /> EOD; $target = 'draft_updated'; $draft_status = $lang['draft']; $no_change_mod_time = ''; $make_private = ''; $update_submit_title = $lang['draft_update']; $delete_submit_title = $lang['draft_destroy']; } else { $date = ''; $dform = ''; $target = 'updated'; $draft_status = ''; $no_change_mod_time = '<input type="checkbox" name="no_update_mod" tabindex="1" value="yes" checked="checked" /> ' . $lang['no_update_timestamp']; $make_private = '<p><input type="checkbox" name="private" tabindex="1" value="1" /> ' . $lang['make_private'] . '</p>'; $update_submit_title = $lang['update']; $delete_submit_title = $lang['delete']; } // Set variables $id = $row['id']; $name = $row['name']; $href = $row['href']; $comment = $row['comment']; $mod = $row['mod']; $categories = add_categories(); $tag_buttons = display_tag_buttons(); $upload_file_form = display_upload_file_form(); $hint = hint(); $contents = <<<EOD <div class="section"> <h2>{$draft_status} {$lang['update']} : {$lang['log']}ID {$id}</h2> <div class="section"> <form id="addform" action="./{$target}.php" method="post" enctype="multipart/form-data"> <p> {$dform} <label for="article-title">{$lang['title']} :</label><br /> <input type="text" name="name" id="article-title" tabindex="1" value="{$name}" size="40" class="bordered" /><br /> <label for="article-title-uri">URI{$hint['href']} : </label><br /> <input type="text" name="href" id="article-title-uri" tabindex="1" value="{$href}" size="40" class="bordered" /><br /> </p> {$categories} <p> <label for="comment">{$lang['comment']}{$hint['comment']} : </label><br /> {$tag_buttons} <br /> <textarea id="comment" name="comment" tabindex="1" rows="20" cols="{$text_cols}" >{$comment}</textarea><br /> </p> {$upload_file_form} <p> {$no_change_mod_time} <input type="hidden" name="mod" value="{$mod}" /> </p> {$make_private}{$trackback_ping_form} <div class="submit-button"> <input type="hidden" name="id" value="{$id}" /> <input class="backbutton" tabindex="1" accesskey="u" type="submit" value="{$update_submit_title}" /> </div> </form> <form id="del" action="./delete.php" method="post" onsubmit="return {$confirm_delete}"> <div class="submit-button"> <input type="hidden" name="id" value="{$id}" /> <input tabindex="2" accesskey="d" type="submit" value="{$delete_submit_title}" /> </div> </form> </div><!-- End .section --> </div><!-- End .section --> EOD; return $contents; }
$code = filter_input(INPUT_POST, 'code'); $name = filter_input(INPUT_POST, 'name'); $price = filter_input(INPUT_POST, 'price'); if ($category_id == NULL || $category_id == FALSE || $code == NULL || $name == NULL || $price == NULL || $price == FALSE) { $error = "Invalid product data. Check all fields and try again."; include '../errors/error.php'; } else { add_product($category_id, $code, $name, $price); header("Location: .?category_id={$category_id}"); } } else { if ($action == 'list_categories') { list_categories(); } else { if ($action == 'add_categories') { add_categories(); } else { if ($action == 'delete_categories') { delete_categories(); } else { if ($action == 'edit_products') { edit_products(); } } } } } } } } function list_categories()