从下拉列表中获取列值并将其插入另一个表中 - fetch column values from drop down and insert it in another table

fetch column values from drop down and insert it in another table

>我创建了一个下拉列表，在其中我从一个表"类别"（它有两个列cat_id和类别名称）中获取数据，我想在另一个表GALLERY中插入列值。我能够获取cat_id但无法获取类别名称..请帮忙..SQL注入不是问题

 <?php
    include_once("header.php");
    include ("connection.php");
    if(isset($_REQUEST['ansave']))
    {
    $a=$_REQUEST['choosecategory'];
    $image=$_FILES['uploadgallery']['name'];// name given in input type 
    $ext=substr(strchr($image,'.'),1);//it breaks the string in part so that format can be matched
    if($ext!='jpg' && $ext!='jpeg' && $ext!='png' && $ext!='gif' && $ext!='JPG' && $ext!='JPEG')
    {
    echo "please select image";
    }
    else
    {
    $path="gallery/".$image; //folder in which image to be saved
    $action=copy($_FILES['uploadgallery']['tmp_name'],$path);//name given in input type (line72)
    $query="insert into gallery (`cat_id`,`galimage`) values('$a','$image')";
    $result=mysql_query($query);`enter code here`
    echo "insert successfully";
    }
    }
    ?>

         <option selected> -- select -- </option>';
           <?php $sql = "SELECT * FROM category";
        $result = mysql_query($sql);
        while($row=mysql_fetch_array($result)){
        echo '<option value="'.$row['cat_id'].'">'.$row['categoryname'].'</option>';
        }

   ?>

希望对您有所帮助，

      <?php
             include_once("header.php");
             include ("connection.php");
             if(isset($_REQUEST['ansave']))
             {
                $a=$_REQUEST['choosecategory'];
                $image=$_FILES['uploadgallery']['name'];// name given in input type
                $ext=substr(strchr($image,'.'),1);//it breaks the string in part so that format can be matched
                if($ext!='jpg' && $ext!='jpeg' && $ext!='png' && $ext!='gif' && $ext!='JPG' && $ext!='JPEG')
                {
                     echo "please select image";
                 }else  {
                     $path="gallery/".$image; //folder in which image to be saved
                     $action=copy($_FILES['uploadgallery']['tmp_name'],$path);//name given in input type (line72)
                     $sqlCategory = "SELECT categoryname FROM category where cat_id='".$a."' ";
                     $resultCategory = mysql_query($sqlCategory);
                     $rowCategory=mysql_fetch_array($resultCategory);
                     $categoryname = $rowCategory['categoryname']; // category name
                     $query="insert into gallery (`cat_id`,`galimage`) values('$a','$image')";
                     $result=mysql_query($query);
                    echo "insert successfully";
                }
            }
          ?>