HTML5 Form with JQuery Repeater, Bootstrap and Multi-Dimensional Array

By -
<?php
if($_SERVER['REQUEST_METHOD'] == "POST"){
$sql1 = "INSERT INTO clbmeetings (`clbid`, `meeting_date`, `speaker`, `subject`, `attendance_percent`, `ri_year`, `created_by`, `ip`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
  $stmt1 = mysqli_prepare($conn, $sql1);
    if($stmt1){
mysqli_stmt_bind_param($stmt1, "ssssssss", $param_clbid, $param_meeting_date, $param_speaker, $param_subject, $param_attendance_percent, $param_ri_year, $param_created_by, $param_ip);
         //Set These Parameters
         foreach ($_POST['meet'] as $item) {
            if(empty($item['mtdt'])){
            echo 'Empty Array';
            }
    else{
                 $meeting_date = $item['mtdt'];
                 $speaker = $item['speaker'];
                 $subject = $item['subject'];
                 $attendance_percent = $item['atpercent'];
                 $param_meeting_date= $meeting_date; 
                 $param_speaker= $speaker; 
                 $param_subject= $subject; 
                 $param_attendance_percent= $attendance_percent;

                 //Try to execute the Query
                 if (mysqli_stmt_execute($stmt1)){
                  $success = " added Successfully!";
                 }
                 else{
                  $err = "Meetings not Updated";
                 }
    }
    }
  }                
    else{
     $err = "Club Meetings Not Added Sussessfully!";
    } 
    mysqli_stmt_close($stmt1);
} 


?>
Form with post Function
<h3>Club Meetings & Nature Of Publication</h3>
<form id="form-horizontal" class="form-horizontal form-wizard-wrapper form-material mb-0" enctype="multipart/form-data"  id="add-mreport" role="form" method="POST" action="">
  <fieldset>
    <h4 class="mt-0 header-title">Club Meetings</h4>
    <div class="repeater-default">
      <div data-repeater-list="meet">
        <div data-repeater-item="">
          <!--data goes Here-->
          <div class="form-group row d-flex align-items-end text-right">
            <div class="col-md-3">
              <label for="example-number-input" class="col-form-label text-right">Date of Meeting</label>
              <input class="form-control" type="date" name="mtdt" value="" id="mtdt">
            </div>
            <div class="col-md-3">
              <label for="example-number-input" class="col-form-label text-right">Name of Speaker</label>
              <input class="form-control" type="text" name="speaker" value="" id="speaker">
            </div>
            <div class="col-md-3">
              <label for="example-number-input" class="col-form-label text-right">Subject</label>
              <input class="form-control" type="text" name="subject" value="" id="subject">
            </div>
            <div class="col-md-2">
              <label for="example-number-input" class="col-form-label text-right">% of Attendance</label>
              <input class="form-control" type="text" name="atpercent" value="" id="atpercent">
            </div>
            <div class="col-sm-1">
              <span data-repeater-delete="" class="btn btn-danger btn-sm">
                <span class="far fa-trash-alt mr-1"></span>
              </span>
            </div><!--end col-->
          </div><!--end row-->
        </div><!--end /div-->
      </div><!--end repet-list-->
      <div class="form-group mb-0 row text-right">
        <div class="col-sm-12">
          <span data-repeater-create="" class="btn btn-secondary">
            <span class="fas fa-plus"></span> Add
          </span>
        </div><!--end col-->
      </div><!--end row-->                                         
    </div> <!--end repeter-->
  </fieldset>
  <!--end fieldset-->
</form>
<!--end form-->


CDN URLs for Required Files
https://cdnjs.cloudflare.com/ajax/libs/jquery.repeater/1.2.1/jquery.repeater.js
https://cdnjs.cloudflare.com/ajax/libs/jquery.repeater/1.2.1/jquery.repeater.min.js

Comments

Post a Comment

Popular posts from this blog

Domain Name Registration in Agra

By -
Your domain name says a lot about you, it gives you personality and recognized identity. Register your name, idea or brand and get online! What is Domain Name Registration? Domain name registration is the act of reserving a name on the Internet for a certain period, usually one year. It is important to know that this domain will remain yours for as long as you renew it and there is no way to purchase a domain name forever. Why you need a Domain Name? Below are some basic points explaining your reason or purpose why you need a domain name. A Domain helps you Let your visitors & customers find you easily!  Domain names provide a clean, user-friendly and convenient option to access your website. A simple descriptive website is easy to remember and looks great on a business card!  A Domain helps you to Get better visibility and exposure on search engines!  Register a keyword rich domain name and get an instant boost to your SEO efforts from the get-go! ...
Read more

Things to know about Popup

By -
What is a 'Pop-up'? " A Pop-up is  something that appears suddenly or unexpectedly " A pop-up is a graphical user interface ( GUI ) display area, usually a small window, that suddenly appears ("pops up") in the foreground of the visual interface. Pop-ups can be initiated by a single or double mouse click or rollover (sometimes called a mouseover), and also possibly by voice command or can simply be timed to occur. A pop-up window must be smaller than the background window or interface; otherwise, it's a replacement interface. On the World Wide Web, JavaScript (and less commonly Java applet s) are used to create interactive effects including pop-up and full overlay windows. A menu or taskbar pulldown can be considered a form of pop-up. So can the little message box you get when you move your mouse over taskbars in many PC applications. Types of Pop-up? Popup Popup is the generic term used for website popups. More specifically, they are t...
Read more

WEB DEVELOPMENT COMPANY IN CHANDAUSI

By -
Searching for web development company in Chandausi?  There is no doubt in the fact that there is hardly any shortage in finding the Good & largest web development companies in Chandausi. There are quite a few web design & development companies which offers an array of services, from WordPress deployments to completely customized sites. But finding a right partner among all, that will make your website simple and user-friendly along with the required functionalities is essential.  There are many factors to consider when selecting a web design firm ranging from Android or iPhone implementation to social networking and development solutions. Keep in mind that some companies focus solely on the design while others may also offer additional services such as Domain Services, Web Hosting, SSL Certificates, SiteLock Malware Detector, Branding & Identity Design, Marketing & Promotion, Website Designing, Web Development, Web Portals, Mobile Apps Development, Website ...
Read more