Untitled

<!DOCTYPE html>
<html>
   <head>
      <title>Title of the document</title>


      <link  rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

   </head>
  <?php
		$hostname = 'localhost';
        $username = 'root';
        $password = '';
        $dbname = 'work_task';

        $mysqli = new mysqli($hostname, $username, $password, $dbname);

        if ($mysqli->connect_errno) {
            die("Error! Failed to connect to MySQL!");
        }

        		if($_GET){
	  				$fields = array();
					$query    = $mysqli->prepare("SELECT * FROM brand_custom_fields WHERE brand_id = 45 ");
			        $query->execute();
			        $result = $query->get_result();
			        if (!$result) {
			            die('Error! Failed to process query');
			        }

			        if ($result->num_rows > 0) {
			        	while ($row = $result->fetch_assoc()) {
			        		array_push($fields,$row);
			        	}
					  	print_r($fields);
			        }
			        else{
			        	 echo "No products";
			        }
		        }


   ?>
   <body>
      <!--hi -->
      <div class="container">
      <form method="POST">
         <div class="control-group">
            <label class="control-label">Допълнителна информация</label>


            <input type="hidden" name="brand_id" value="45">
            <div class="prototype" style="display:none">
               <div class="fields">
               		<label>Type of field</label>
                  <select name="field_choice[]" id="" class="form-control field_choice">
                   		<option></option>
                    	 <option value="0">Text</option>
                     	 <option value="1">Link</option>
                  </select>

                  <div class="text_field" id="" style="display:none">
                     <label>Text: </label>
                     <input type="text" name="text_fields[]" class="form-control">
                  </div>
                  <div class="link_field" id="" style="display:none">
                     <label>Link desciprtion: </label>
                     <input type="text" name="link_descr_field[]" class="form-control">
                     <label>URL: </label>
                     <input type="text" name="link_url[]" class="form-control">
                  </div>
                  <button type="button" class="remove"> x remove </button>

               </div>
            </div>
         </div>

         <div class="dynamic">
          	<a  href="javascript:;" class="new_custom_field">+ add </a>

         </div>
 			<input type="submit" name="Submit">
       </form>
      </div>


  <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
       <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script type="text/javascript">

// Adjusting ids to turn on hide and show when clicking select button

	var i = 1;
	$(".new_custom_field").on("click",function() {
		var element = $( ".fields" ).first();
		var clone = element.clone();
		clone.appendTo( ".dynamic").insertBefore("a");
		clone.children("select").attr("id","field_choice_"+i);
		clone.children(".text_field").attr("id","text_field_"+i);
		clone.children(".link_field").attr("id","link_field_"+i);
		clone.children("#field_choice_"+i).change(select_change_handler);


			function select_change_handler(e) {
		        var value = $(this).val();
		        var id = $(this).attr('id');
		          console.log(value + ' | ' + id);
		          var actualId = id.replace("field_choice_","");
		          parseInt(actualId);
		        if(value == 0){
		        		$("#link_field_"+actualId).hide();
		        	$("#text_field_"+actualId).show();

		        }
		        else{
		        	$("#text_field_"+actualId).hide();
		        	$("#link_field_"+actualId).show();

		        }


	    }
		i++;
    });


</script>
<script type="text/javascript">
	   $(".remove").on("click",".remove",function(){
	   		console.log(1);
    	//$(this).parent().delete();
    });

</script>
   </body>
</html>
<?php
				if($_POST){
				echo 1;
		        	$sql = "DELETE FROM brand_custom_fields WHERE brand_id = 45";
		        		 if ($mysqli->query($sql) === TRUE) {
	        			echo "Sucecss";
		       		 }

		       		 $data = $_POST;
			$brand_id = $data["brand_id"];
			$arrangedData = array();
			$num = 0;

			// never take the first element
			$num = 0;
			for($i=1; $i <count($data["field_choice"]);$i++){

				if($data["field_choice"][$i]==0){
					if(!empty($data["text_fields"][$i])){
						$arrangedData[$num]["field_choice"]=0;
						$arrangedData[$num]["text_field"]=$data["text_fields"][$i];
						$text = $arrangedData[$num]["text_field"];

					//Insert заявка

					 $sql="INSERT INTO brand_custom_fields (brand_id, custom_field_type, custom_field_text) VALUES ('$brand_id',0,'$text')";

				          if ($mysqli->query($sql) === TRUE) {
        						echo 1;
        		 	}
       				 }
				}
				else{
					if(!empty($data["link_descr_field"][$i])&& !empty($data["link_url"][$i])){
						$arrangedData[$num]["field_choice"]=1;
						$arrangedData[$num]["link_description"]=$data["link_descr_field"][$i];
						$arrangedData[$num]["link_url"]=$data["link_url"][$i];
						$desc =$data["link_descr_field"][$i];
						$url = $data["link_url"][$i];
							//Insert заявка
						 $sql="INSERT INTO brand_custom_fields (brand_id, custom_field_type, custom_field_link_descr,custom_field_url) VALUES ('$brand_id',1,'$desc','$url')";

				          if ($mysqli->query($sql) === TRUE) {
        						echo 1;
        		 }

					}

				}
				$num++;
			}
			print_r($arrangedData);

		        }

?>