����
������������������������������������
<?php
include "header.php";
include "connection.php";
session_start();

//echo $_SESSION['user_id'];

if(isset($_POST['submit'])){
    
    $query=mysqli_query($conn,"insert into users set usertype = 'Website', fname = '".$_POST['fname']."', lname = '".$_POST['lname']."', email = '".$_POST['email']."', heard_about = '".$_POST['heard_about']."', idea_state = '".$_POST['idea_state']."', created = '".date('d','m','y')."', modified = '".date('d','m','y')."', status = 'Applied' ");
    
    if($query){
        echo "<script>alert('Registration Success');</script>";
    }else{
        echo "<script>alert('Error to Registration');</script>";
    }
    
}

?>
<main class='site-container'>
    <div class='container container-small' style='margin-top:50px;'>
    <header class='page-header'><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <h2 class='prelude'>
    </h2>
    <h1 class='xlarge-heading title'>
    Austin 2020
    </h1>
    
    </header>
    </div>
    
    <section class="container container-small application-progress-container">
    <ul class="application-progress -three">
    <li class="step step-1">
    <span class="disc"></span>
    <span class="text">Welcome</span>
    </li>
    <li class="step step-2 -active">
    <span class="disc"></span>
    <span class="text">Questions</span>
    </li>
    <li class="step step-3">
    <span class="disc"></span>
    <span class="text">Finish</span>
    </li>
    </ul>
    </section>
    
    <div id="fragment-for-logged-in-users">
    <div class="application-page-2"><section class="container container-small"><article class="article">
    <h3><strong>Munish's Application: STEP 2</strong></h3>
    <p>&nbsp;</p>
    <p>Please provide some basic biographical information below. Accelerativ Admissions Team will look at your professional background when making an admissions decision.&nbsp;</p>
    <p>If you are applying with Co-Founders or as a team, be sure to complete the "Company Name" section below.</p>
    </article></section></div>
    </div>
    
    <section class="container container-small highlight-form-heading">
    <form class="registration-form" action="" accept-charset="UTF-8" method="post">
        
        <input name="utf8" type="hidden" value="✓">
        <input type="hidden" name="authenticity_token" value="ZTSsIBqtoiSeoeglynthq5Ofw9RxSFnkXt59ZeoZjlp+gDuLrHMVdMgOs9yGgicLpKBzcjnc0tJ7wNi5NSSTlA==">
        
    <ul class="errorMessages"></ul>
    <section class="box">
    <header class="form-header">
    <h3 class="form-heading">Application Questions</h3>
    </header>
    
    
    
    <?php
      //$query_que = mysqli_query($conn, "select qu.question, an.answer as ans from questions qu left join answers an ON (qu.id = an.q_id) where qu.id = an.q_id ");
      
      $query_que = mysqli_query($conn, "select * from questions ");
      
      $num_rows = mysqli_num_rows($query_que); 
       if($num_rows>=1){
        while($query_data = mysqli_fetch_array($query_que)){
           
       ?> 
    <div class="form-row">
        <div class="input-block">
            <label class="form-label required-field" for="education"><?php echo $query_data['question']; ?></label>
            
         <?php
         $query_ans1 = mysqli_query($conn, "select * from answers where q_id = '".$query_data['id']."' "); 
             $num_rows1 = mysqli_num_rows($query_ans1); 
            if($num_rows1>=1){
                
             $ans_data1 = mysqli_fetch_array($query_ans1);
         
             if($ans_data1['answer'] == "" ){ 
             ?>
                <input type="text" class="select" id="education" name="education" required="">
             <?php } else { ?>
               <select class="select" id="education" name="question<?php echo $query_data['id']; ?>" required="">
                    <option disabled="disabled" selected="selected" value="">-- select an option --</option>
                   <?php
                   $query_ans = mysqli_query($conn, "select * from answers where q_id = '".$query_data['id']."' "); 
                   while($ans_data = mysqli_fetch_array($query_ans)){ ?>
                    <option value="<?php echo $ans_data['id']; ?>"><?php echo base64_decode($ans_data['answer']); ?></option>
                    <?php } ?>
                </select>
             <?php } ?>
            
        </div>
    </div>
    
    <?php } } }else{ ?>
        No Option for  this question
    <?php } ?>
    
    
    <div class="form-section">
        <header class="form-header">
        <h3 class="form-heading">Other Information</h3>
        </header>
    
        <div class="form-row">
            <div class="input-block">
            <label class="form-label required-field" for="gender">Gender</label>
            <select class="select" id="gender" name="gender" required="">
                <option disabled="disabled" selected="selected" value="">-- select an option --</option>
                <option value="1">Male</option>
                <option value="2">Female</option>
                <option value="3">Non binary</option>
                <option value="4">I'd prefer not to say</option>
            </select>
            </div>
        
            <div class="input-block">
            <label class="form-label required-field" for="phone_number">Phone Number ( xxx-xxx-xxxx )</label>
            <input class="input" id="phone_number" name="phone_number" placeholder="Phone Number" required="" type="text" maxlength="255">
            </div>
        </div>
        
        <div class="form-row">
            <div class="input-block">
            <label class="form-label required-field" for="linkedin_website">LinkedIn Profile or Online Biography</label>
            <input class="input" id="linkedin_website" name="linkedin_website" placeholder="LinkedIn/Web URL" required="" type="text" maxlength="255">
            </div>
        </div>
        
        <div class="form-row">
            <div class="input-block">
                <label class="form-label">Address 1</label>
                <input class="input" name="address_1" placeholder="Address Line 1" type="text" maxlength="255">
            </div>
            <div class="input-block">
                <label class="form-label">Address 2</label>
                <input class="input" name="address_2" placeholder="Address Line 2" type="text" maxlength="255">
            </div>
        </div>
        
        <div class="form-row">
            <div class="input-block">
            <label class="form-label required-field" for="city">City</label>
            <input class="input" id="city" name="city" placeholder="City" required="" type="text" maxlength="255">
            </div>
            <div class="input-block">
            <label class="form-label">State</label>
            <input class="input" name="state" placeholder="State" type="text" maxlength="255">
            </div>
        </div>
        <div class="form-row">
            <div class="input-block">
            <label class="form-label">Zip Code / Postal Code</label>
            <input class="input" name="zip_code" placeholder="Zip Code" type="text" maxlength="255">
            </div>
            <div class="input-block">
            <label class="form-label">Country</label>
            <input class="input" name="country" placeholder="Country" type="text" maxlength="255">
            </div>
        </div>
    </div>
    
    <div class="form-section">
        <header class="form-header">
        <h3 class="form-heading">Company Information</h3>
        </header>
        <div class="form-row">
            <div class="input-block">
            <label class="form-label">Company Name</label>
            <input class="input" name="company_name" placeholder="Company Name" type="text" maxlength="255">
            <span class="form-note">
            <span class="title">OPTIONAL</span>
            <span class="content"><b>Only fill this field out if applying with cofounders.</b> If you are applying to the Institute with one or more cofounders, each co-founder must complete a separate application. Each cofounder must enter the same company name as everyone else that applies as a team.</span>
            </span>
            </div>
        </div>
    </div>
    
    <div class="form-section">
        <header class="form-header">
        <h3 class="form-heading">Referral Source</h3>
        </header>
        <div class="form-row">
            <div class="input-block">
            <label class="form-label">Please let us know how you heard about the Founder Institute</label>
            <select class="select" name="heard_about">
                <option disabled="disabled" selected="selected" value="">-- select an option --</option>
                <option value="Referred by Mentor / Director">
                Referred by Mentor / Director
                </option>
                <option selected="" value="Referred by Graduate">
                Referred by Graduate
                </option>
                <option value="Referral">
                Referral
                </option>
                <option value="Search Engine">
                Search Engine
                </option>
                <option value="Meetup">
                Meetup
                </option>
                <option value="Facebook">
                Facebook
                </option>
                <option value="Twitter">
                Twitter
                </option>
                <option value="LinkedIn">
                LinkedIn
                </option>
                <option value="Event Listing">
                Event Listing
                </option>
                <option value="Email / Newsletter">
                Email / Newsletter
                </option>
                <option value="FI Blog">
                FI Blog
                </option>
                <option value="Press">
                Press
                </option>
                <option value="Webinar">
                Webinar
                </option>
                <option value="WhatsApp">
                WhatsApp
                </option>
                <option value="Instagram">
                Instagram
                </option>
                <option value="Snapchat">
                Snapchat
                </option>
                <option value="Youtube">
                Youtube
                </option>
                <option value="Quora">
                Quora
                </option>
                <option value="AngelList">
                AngelList
                </option>
                <option value="F6S">
                F6S
                </option>
                <option value="Startup Weekend">
                Startup Weekend
                </option>
                <option value="Other">
                Other
                </option>
            </select>
            </div>
        </div>
        
        <div class="form-row">
            <div class="input-block">
            <label class="form-label">Please provide more details on how you heard about us below:</label>
            <input class="input" name="heard_about_detail" placeholder="e.g. a specific website, partner, news article" type="text" maxlength="255">
            </div>
        </div>
    </div>
    <footer class="form-action">
    <input class="btn btn-blue" data-disable-with="please wait..." type="submit" value="SUBMIT APPLICATION">
    </footer>
    </section>
    </form>
    
    </section>

</main>

<?php
include "footer.php";
?>