<?php require $_SERVER["DOCUMENT_ROOT"] . '/vendor/autoload.php'; use SMS\App\Modules\RegisterStaff\Controller\RegisterStaffController as RegisterStaff; $view = new RegisterStaff(); $fields = $view->getTableFields(); ?> <div class="box box-default"> <div class="box-header with-border"> <h3 class="box-title">Staff Registration Form <small>Use The Slider Below To Change The Size Of The Form To Suit You</small></h3> <input class="bar" type="range" id="rangeinput" value="4" min="2" max="12"/> <div class="box-tools pull-right"> <button class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> <button class="btn btn-box-tool" data-widget="remove"><i class="fa fa-remove"></i></button> </div> </div><!-- /.box-header --> <form id="StaffForm"> <div class="box-body"> <div class="row"> <?php foreach ($fields as $field) { $name = $field["Name"]; $type = $field["Type"]; echo "<div class='col-md-4 FORMSIZE'><div class='form-group'><label>{$name}</label>"; $inputtype = $view->predictInputType($field); if ($inputtype == "SELECT") { $select_elements = $view->loadSelectElements($name); echo "<select class='form-control select2 NEWSTAFFFIELD' style='width:100%;' data-id='{$name}' name='{$name}'>"; foreach ($select_elements as $element) { $value = $element[str_replace(" ", "_", strtolower($name))]; echo "<option value='" . $element["id"] . "'>" . $value . "</option>";
<?php require $_SERVER["DOCUMENT_ROOT"] . '/vendor/autoload.php'; use SMS\App\Modules\RegisterStaff\Controller\RegisterStaffController as RegisterStaff; $rs = new RegisterStaff(); $id = $_POST["id"]; $value = str_replace("-", " ", $_POST["value"]); $newvalue = $_POST["newvalue"]; $v = $rs->valueUpdate($id, $value, $newvalue); print_r($v); //print_r(array($id, $value, $newvalue));
<?php require $_SERVER["DOCUMENT_ROOT"] . '/vendor/autoload.php'; use SMS\App\Modules\RegisterStaff\Controller\RegisterStaffController as RegisterStaff; $rs = new RegisterStaff(); $data = array(array("samuel", false), array("adeshina", false)); $b = $rs->insertNewStaff($data); $r = $rs->getTableFields(); print_r($rs->loadSelectElements("Religion"));
<?php require $_SERVER["DOCUMENT_ROOT"] . '/vendor/autoload.php'; use SMS\App\Modules\RegisterStaff\Controller\RegisterStaffController as RegisterStaff; $rs = new RegisterStaff(); $postdata = $_POST; $data = array(); foreach ($postdata as $key => $value) { $data[] = array($value, false); } $b = $rs->insertNewStaff($data);
<?php require $_SERVER["DOCUMENT_ROOT"] . '/vendor/autoload.php'; use SMS\App\Modules\RegisterStaff\Controller\RegisterStaffController as RegisterStaff; $view = new RegisterStaff(); $fields = $view->getTableFields(); $staffs = $view->getStaffs(); ?> <section class="content"> <div class="row"> <div class="col-xs-12"> <div class="box"> <div class="box-header"> <h3 class="box-title">You Can Use The Search Form To Filter Data On This Page</h3> </div><!-- /.box-header --> <div class="box-body"> <table id="example1" class="table table-bordered table-striped"> <thead> <tr> <th class="info" style="width: 20px !important;"><center><i class="fa fa-info"></i></center></th> <?php foreach ($fields as $field) { $name = $field["Name"]; echo "<th>{$name}</th>"; } ?> </tr> </thead> <tbody> <?php foreach ($staffs as $staff) {