초보자가 수정하고 있어 어려움이 많은데요..
카테고리를 설정하는 카테고리php파일인데
영문단어 "MUSIC" 이라고 쓰면 카테고리가 설정되는데
한글로 "뮤직" 이라고 쓰면 카테고리로 들어갔을때
에러가 납니다. 어떤 설정을 변경해야 하는지
도움좀 부탁드립니다.
<?php
include dirname(__FILE__).'/config.php';
function dehtml($html) {
return htmlentities($html, ENT_QUOTES, 'utf-8');
}
$homepage = true;
$page_title = $site_name;
include dirname(__FILE__).'/admin_header.php';
if(isset($_SESSION['logged']) && $_SESSION['logged'] != "")
{
}
else
{
header('location:login.php');
}
?>
<script>
$(document).ready(function(){
//alert();
function test_name(id,msgId)
{
//alert();
var namepattern = /^[a-zA-Z-가-힣-,/]{2,}$/;
var name = $(id).val();
if (name != "")
{
if (!namepattern.test(name))
{
$(msgId).html('* Name Contains Only Letters and Word.');
$(id).css({
"border": "1px solid #B94A48"
////"background": "#FFCECE"
});
return false;
}
else
{
$(msgId).html('');
$(id).css({
"border": "",
"background": ""
});
return true;
}
}
else
{
$(msgId).html('* This field is required.');
$(id).css({
"border": "1px solid #B94A48"
//"background": "#FFCECE"
});
return false;
}
}
$("#txtcategory").bind("input propertychange",function()
{
test_name('#txtcategory',"#msgcategory");
});
$("#btnAdd").click(function(){
var uname = test_name('#txtcategory',"#msgcategory");
if(uname == true)
{
return true;
}
else
{
return false;
}
});
//for edit validation
$("#txtedcategory").bind("input propertychange",function()
{
test_name('#txtedcategory',"#msgedcategory");
});
$("#editsubmit").click(function(){
var name = test_name('#txtedcategory',"#msgedcategory");
if(name == true)
{
return true;
}
else
{
return false;
}
});
});
</script>
<?php
//$categories = ORM::for_table('Categories')->where('link_to_category', NULL)->find_many();
$categories = ORM::for_table('Categories')->where('link_to_category', '0')->find_many();
//echo "<pre>";print_r($categories);die();
if(isset($_POST['editsubmit']) && $_POST['editsubmit']!="")
{
//print_r($_POST);die();
$query = ORM::get_db()->prepare("UPDATE `Categories` SET CategoryName='".$_POST['txtcategory']."',img_url='".$_POST['txturl']."',img_desc='".$_POST['txtdesc']."' where ID='".$_POST['catid']."'");
if( $query->execute() )
{
$_SESSION['msg'] = '<div class="alert alert-dismissable alert-success">Category was successfully Updated. </div>';
header("location:EditCategories.php");
exit;
}
else
{
$_SESSION['msg'] = '<div class="alert alert-dismissable alert-danger">An error occurred while Updating Category.</div>';
header("location:EditCategories.php");
exit;
}
}
if(isset($_GET['ed']) && $_GET['ed'] !="" )
{
$nbsites = ORM::for_table('Categories')->where_equal('ID', $_GET['ed'])->find_one();
//echo "<pre>"; print_r($nbsites->CategoryName);
?>
<div class="content">
<form action="" method="post" class="form-horizontal">
<div class="form-group">
<label class="control-label col-md-3">Category Name:</label>
<div class="controls col-md-9 col-xs-12">
<input type="hidden" class="form-control" name="catid" value="<?php echo $nbsites->ID;?>" id="category" />
<input type="text" class="form-control" name="txtcategory" id="txtedcategory" value="<?php if(isset($nbsites->CategoryName)){ echo $nbsites->CategoryName;}?>" id="txtcategory" />
<span id="msgedcategory" style="color:#B94A48"></span>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Image Url:</label>
<div class="controls col-md-9 col-xs-12">
<input type="text" class="form-control" name="txturl" value="<?php if(isset($nbsites->img_url)){ echo $nbsites->img_url;}?>" id="txturl" />
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Description:</label>
<div class="controls col-md-9 col-xs-12">
<input type="text" class="form-control" name="txtdesc" value="<?php if(isset($nbsites->img_desc)){ echo $nbsites->img_desc;}?>" id="txtdesc" />
</div>
</div>
<div class="form-group">
<div class="controls col-md-9 col-xs-12">
<input type="submit" class="btn btn-success" value="Edit Category" name="editsubmit" id="editsubmit" >
</div>
</div>
</form>
</div>
<?php
include dirname(__FILE__).'/admin_footer.php';
exit;
}
if(isset($_GET['dl']) && $_GET['dl'] !="" )
{
$query = ORM::get_db()->prepare("delete from `Categories` where ID= '".$_GET['dl']."'");
if( $query->execute() )
{
$_SESSION['msg'] = '<div class="alert alert-dismissable alert-success">Category was successfully Deleted. </div>';
}
else
{
$_SESSION['msg'] = '<div class="alert alert-dismissable alert-danger">An error occurred while Deleting Category.</div>';
}
header("location:EditCategories.php");
exit;
}
if(isset($_POST['submit']))
{
$max_id = ORM::for_table('Categories')->select_expr('MAX(id)', 'id')->find_one();
$id = intval($max_id['id']) + 1;
$query = ORM::get_db()->prepare("INSERT INTO `Categories` (ID,CategoryName,img_url,img_desc) values (:id, :CategoryName,:img_url,:img_desc)");
$query->bindParam(':id', $id, PDO::PARAM_INT);
$query->bindParam(':CategoryName', $_POST['txtcategory'], PDO::PARAM_STR, 55);
$query->bindParam(':img_url', $_POST['txturl'], PDO::PARAM_STR, 55);
$query->bindParam(':img_desc', $_POST['txtdesc'], PDO::PARAM_STR, 55);
if( $query->execute() )
{
$_SESSION['msg'] = '<div class="alert alert-dismissable alert-success">Category was successfully inserted. </div>';
}
else
{
$_SESSION['msg'] = '<div class="alert alert-dismissable alert-danger">An error occurred while inserting Category.</div>';
}
header("location:EditCategories.php");
exit;
};
?>
<center>
<h1>Categories</h1>
<h3>Add New Category</h3>
<div class="content">
<form action="" method="post" class="form-horizontal">
<div class="form-group">
<label class="control-label col-md-3">Category Name:</label>
<div class="controls col-md-9 col-xs-12">
<input type="text" class="form-control" name="txtcategory" id="txtcategory" value=""/>
<span id="msgcategory" style="color:#B94A48"></span>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Image Url: </label>
<div class="controls col-md-9 col-xs-12">
<input type="text" class="form-control" name="txturl" id="txturl" value=""/>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3">Description: </label>
<div class="controls col-md-9 col-xs-12">
<input type="text" class="form-control" name="txtdesc" id="txtdesc" value=""/>
</div>
</div>
<div class="form-group">
<div class="controls col-md-9 col-xs-12">
<input type="submit" class="btn btn-success" value="Add Category" id="btnAdd" name="submit" >
</div>
</div>
</form>
<?php
if(isset($_SESSION['msg']) && $_SESSION['msg'] != "")
{
echo $_SESSION['msg'];
unset($_SESSION['msg']);
}
?>
</div>
<h3>All Categories</h3>
<table class="table table-bordered table-striped table-condensed cf">
<thead>
<tr>
<th>Category Name</th>
<th>Image Url</th>
<th>Description</th>
<th align="center" colspan="3">Action</th>
</tr>
</thead>
<tbody>
<?php
//print_r($categories);
foreach($categories as $category)
{ ?>
<tr>
<td><?php echo $category->CategoryName; ?></td>
<td><?php echo $category->img_url; ?></td>
<td><?php echo $category->img_desc; ?></td>
<td> <a href="EditSubCategories.php?cat=<?php echo $category->ID?>"> Manage Subcategory </a></td>
<td> <a href="EditCategories.php?ed=<?php echo $category->ID?>"> Edit </a></td>
<td> <a href="EditCategories.php?dl=<?php echo $category->ID?>"> Delete </a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</center>
<?php
include dirname(__FILE__).'/admin_footer.php';?>
답변 1개
답변을 작성하려면 로그인이 필요합니다.