$correct_result = true;
/*---------------Country---------------*/
if (isset($u_country) && $u_country !== "") {
validate_country();
}
/*---------------City---------------*/
if (isset($u_city) && $u_city !== "") {
validate_city();
}
/*---------------Title---------------*/
if (isset($u_jobtitle) && $u_jobtitle !== "") {
validate_title();
}
/*---------------Category---------------*/
if (isset($u_category) && $u_category !== "Industry" && $u_category !== "") {
validate_category();
}
/*---------------Location---------------*/
if (isset($u_location) && $u_location !== "Location" && $u_location !== "") {
validate_location();
}
/*---------------keywords---------------*/
if (isset($u_keywords) && $u_keywords !== "") {
validate_keywords_and();
}
/*---------------Display Result---------------*/
if ($correct_result == true) {
add_result($input);
}
}
//END FOR LOOP
# This script simply creates a category, if it doesn't already exist.
#
header('Pragma: no-cache');
require_once 'shared.php';
# Make a connection to the database
$db_read = get_db_read();
$db_write = get_db_write();
if (!$me) {
redirect("index.php");
}
if (isset($_POST['category']) == false) {
redirect("index.php");
}
$category = mysql_escape_string(htmlentities(trim($_POST['category'])));
$private = isset($_POST['private']) ? '1' : '0';
if (validate_category($category) == false) {
show_error_redirect_back("Please enter a valid category name (between 3 and {$max_length_category} characters)");
}
$result = try_mysql_query("SELECT * FROM categories WHERE name = '{$category}' AND user_id = '" . $me['user_id'] . "'", $db_read);
if (mysql_num_rows($result) > 0) {
show_error_redirect_back('Error: you already have a category with that name!');
}
try_mysql_query("INSERT INTO categories (user_id, name, private, date_created, last_updated, last_updated_public) VALUES (" . $me['user_id'] . ", '{$category}', '{$private}', NOW(), 0, 0)", $db_write);
$category_id = mysql_insert_id($db_write);
try_mysql_query("UPDATE users SET last_category='{$category_id}' WHERE user_id='" . $me['user_id'] . "'", $db_write);
show_message_redirect_back("Category successfully created!");
?>
