
<?php 

include 'includes/header.php';


$servername = "localhost";
$username = "codesite_codesitex";
$password = "~O25D_)lgLc4VL7H";
$db = "codesite_codesitex";

// Create connection
$conn = new mysqli($servername, $username, $password , $db);


$sql = "SELECT * FROM `smm` WHERE id='". $_GET['id'] ."'";
 $result = $conn->query($sql);

  if ($result) {
    $return = array();
    while($row = $result->fetch_assoc()) {
      $return = $row;
    $data_value = json_decode($return['smm']);
    $data_img =  $return['company_attachment'];
    //  var_dump($data_img);
    }
  } else {
    $return = array();
  }
  
 

$conn->close();


?>


<style>
    .logoimg img {
   display: none;
}
.reserve_form {
    padding: 0 0;
}
.allYourSec h1 {
    color: #3e8fc9;
    text-transform: capitalize;
}
</style>
<body>
		 <section>
        <div class="main_form">
            <div class="container-fluid">
                <div class="row justify-content-center">
                    <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12 col-xxl-12">
                        <form action="javascript:void(0)" id="web-form" class="form" method="post" enctype="multipart/form-data">
                            <div class="head">
                                <h3>Social Media Brief Form</h3>
                                  <input type="hidden" name="form_id" value="59183">
                                <p>Fill out this social media brief form so that our SMM team will have the information needed to ensure we accurately represent your company. Be sure to answer all questions accurately – keeping in mind that your answers should reflect your TARGET audience – so we can promote your company’s products and services. Please provide any specials or promotions along with any other information that will help us grow your brand.</p>
                                <div class="form_area_1">
                                    <h4>CONTACT INFORMATION</h4>
                                   
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-6 col-lg-6 col-xl-6 col-xxl-6">
                                                <label> Company Name <span>*</span></label>
                                                <input type="text" class="form-control" placeholder="Your answer" name="company[company_name]" value="<?php echo $data_value->company_name??null;?>">
                                            </div>
                                           
                                            <div class="col-12 col-sm-12 col-md-6 col-lg-6 col-xl-6 col-xxl-6">
                                                <label> Email Address <span>*</span></label>
                                                <input type="email" class="form-control" placeholder="Your answer" name="company[company_email]" value="<?php echo $data_value->company_email??null;?>">
                                            </div>
                                            <div class="col-12 col-sm-12 col-md-6 col-lg-6 col-xl-6 col-xxl-6">
                                                <label> Website URL (Developed or Under developed) <span>*</span></label>
                                                <input type="text" class="form-control" placeholder="Your answer"  name="company[company_website]" value="<?php echo $data_value->company_website??null;?>">
                                            </div>
                                        </div>
                                   
                                </div>
                                <div class="form_area_2">
                                    <h4>PRODUCTS & SERVICES</h4>
                                    <p>What Products/Services are you interested in for your business? <span> * </span></p>
                                        <div class="row">
                                        <?php 
                                        foreach($data_value->company_service as  $key => $val) { ?>
                                          
                                        <div class="col-12 col-sm-12 col-md-3 col-lg-3 col-xl-3 col-xxl-3">
                                            <label>
                                                <input type="checkbox" name="company[company_service]" value="" checked>
                                                <span><?php echo $val;?></span>
                                            </label>
                                        </div>
                                          
                                       <?php } ?>
                                       
                                    
                                     
                                    </div>
                                    
                                    
                                    <p class="p_1">Choose Social Media Platforms <span>*</span> </p>
                                    <div class="row">
                                         <?php
                                           foreach($data_value->company_social_plateform as  $key => $val) { ?>
                                        <div class="col-12 col-sm-12 col-md-3 col-lg-3 col-xl-3 col-xxl-3">
                                            <div class="mb-3 form-check">
                                                <input type="checkbox" class="form-check-input" id="exampleCheck10"  name="company[company_social_plateform]" value="" checked>
                                                <label class="form-check-label" for="exampleCheck10"><?php echo $val;?></label>
                                            </div>
                                        </div>
                                         <?php } ?>
                                       
                                     

                                    </div>

                                    
                                </div>
                                <div class="form_area_1 extra_class">
                                   
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-4 col-lg-4 col-xl-4 col-xxl-4">
                                                <label> What does your company do or sell? <span>*</span></label>
                                                <input type="text" class="form-control" placeholder="Your answer"  name="company[company_q1]" value="<?php echo $data_value->company_q1??null;  ?>">
                                            </div>
                                            <div class="col-12 col-sm-12 col-md-4 col-lg-4 col-xl-4 col-xxl-4">
                                                <label> Target Region <span>*</span></label>
                                                <input type="text" class="form-control" placeholder="Your answer" name="company[company_q2]" value="<?php echo $data_value->company_q2??null;  ?>">
                                            </div>
                                            <div class="col-12 col-sm-12 col-md-4 col-lg-4 col-xl-4 col-xxl-4">
                                                <label> Target Audience <span>*</span></label>
                                                <input type="number" class="form-control" placeholder="Your answer" name="company[company_q3]" value="<?php echo $data_value->company_q3??null;  ?>">
                                            </div>
                                        </div>
                                    
                                </div>
                                <div class="form_area_2 extra_class">
                                    <!-- <h4>PRODUCTS & SERVICES</h4> -->
                                    <p>Please tell us why potential clients/customers are more apt to choose your company & your product/service over those of your competitors? (Check all that apply.) <span>*</span></p>
                                    <div class="row">
                                        
                                       <?php
                                           foreach($data_value->company_competitors as  $key => $val) { ?>
                                        <div class="col-12 col-sm-12 col-md-3 col-lg-3 col-xl-3 col-xxl-3">
                                            <div class="mb-3 form-check">
                                                <input type="checkbox" class="form-check-input" id="exampleCheck6" name="company[company_competitors]" value="" checked>
                                                <label class="form-check-label" for="exampleCheck6"><?php echo $val;?></label>
                                            </div>
                                        </div>
                                          <?php } ?>
                                 
                                     

                                    </div>
                                
                                      

                                    </div>



                                

                                <div class="form_area_2 extra_class">
                                    <p>Who would you say are your biggest competitors? Please list at least 3 & provide their URL <span>*</span></p>
                                   
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12 col-xxl-12">
                                                <input type="text" class="form-control" placeholder="Your answer" name="company[company_competitors_url]" value="<?php echo $data_value->company_competitors_url??null; ?>">
                                            </div>
                                        </div>
                                   
                                </div>


                                <div class="form_area_2 extra_class">
                                    <!-- <h4>PRODUCTS & SERVICES</h4> -->
                                    <p>Please tell us why potential clients/customers are more apt to choose your company & your product/service over those of your competitors? (Check all that apply.) <span>*</span></p>
                                    <div class="row">
                                      <?php
                                          foreach($data_value->company_potential_client as  $key => $val) { ?>   
                                        <div class="col-12 col-sm-12 col-md-3 col-lg-3 col-xl-3 col-xxl-3">
                                            <div class="mb-3 form-check">
                                                <input type="checkbox" class="form-check-input" id="exampleCheck17" name="company[company_potential_client]" value="" checked>
                                                <label class="form-check-label" for="exampleCheck17"><?php echo $val;?></label>
                                            </div>
                                        </div>
                                        <?php } ?>
                                        
                                  
                                      

                                    </div>
                                   



                                </div>



                                <div class="form_area_2 extra_class">
                                    <!-- <h4>PRODUCTS & SERVICES</h4> -->
                                    <p>What forms of marketing are you currently utilizing? (Check all that apply.) <span>*</span></p>
                                    <div class="row">
                                       <?php
                                          foreach($data_value->company_form_type as  $key => $val) { ?>       
                                        <div class="col-12 col-sm-12 col-md-3 col-lg-3 col-xl-3 col-xxl-3">
                                            <div class="mb-3 form-check">
                                                <input type="checkbox" class="form-check-input" id="exampleCheck25" name="company[company_form_type]" value="" checked>
                                                <label class="form-check-label" for="exampleCheck25"><?php echo $val;?></label>
                                            </div>
                                        </div>
                                        
                                     <?php } ?>

                                    </div>
                                 
                                    



                                </div>






                                <div class="form_area_2 extra_class">
                                    <!-- <h4>PRODUCTS & SERVICES</h4> -->
                                    <p>Please tell us what characteristics your company possesses? (Check all that apply) <span>*</span> </p>
                                    <div class="row">
                                        <?php
                                          foreach($data_value->company_characteristics as  $key => $val) { ?> 
                                        <div class="col-12 col-sm-12 col-md-3 col-lg-3 col-xl-3 col-xxl-3">
                                            <div class="mb-3 form-check">
                                                <input type="checkbox" class="form-check-input" id="exampleCheck35" name="company[company_characteristics]" value="" checked>
                                                <label class="form-check-label" for="exampleCheck35"><?php echo $val;?></label>
                                            </div>
                                        </div>
                                        
                                      
                                      <?php } ?>
                                      
                                      

                                    </div>
                                    
                                
                                    




                                </div>





                                <div class="form_area_2 extra_class">
                                    <p>Existing Social Media Links (If Any) <span>*</span>  </p>
                                  
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12 col-xxl-12">
                                            <textarea name="company[company_socialmedia_links]" id="" cols="30" rows="10" placeholder="Your answer" ><?php echo $data_value->company_socialmedia_links??null; ?> </textarea>
                                            </div>
                                        </div>
                                  
                                </div>





                                <div class="form_area_2 extra_class">
                                    <p>Additional Notes or Comments</p>
                                   
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12 col-xxl-12">
                                                <textarea name="company[company_overview]" id="" cols="30" rows="10" placeholder="Your answer"><?php echo $data_value->company_overview??null; ?> </textarea>
                                            </div>
                                        </div>
                                    
                                </div>
                                
                                 <div class="form_area_2 extra_class">
                                    <p>Download Now</p>
                                   
                                         <div class="row">
                                           
                                              
                                            <div class="col-12 col-sm-12 col-md-12 col-lg-12 col-xl-12 col-xxl-12">
                                             <div class="attachmenttext">
                                              <?php 
                                                  $data_img = json_decode($return['company_attachment']);
                                                  foreach($data_img as  $key => $value){ ?>
                                                 
                                                 <a href="./images/uploads/<?php echo $value; ?>" download>Attachment Download</a>
                                                
                                               
                                               <?php } ?>
                                               
                                               </div>
                                          
                                            </div>
                                           
                                           
                                          
                                        </div>
                                    
                                </div>
                                
                                
                                


                               




                                

                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </section>
  



<?php include 'includes/footer.php' ?>