php 코드 질문입니다.

php 코드 질문입니다.

QA

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';?> 

이 질문에 댓글 쓰기 :

답변 1

답변을 작성하시기 전에 로그인 해주세요.
전체 123,134 | RSS
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT