php 코드 질문입니다.
관련링크
본문
초보자가 수정하고 있어 어려움이 많은데요..
카테고리를 설정하는 카테고리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';?>