<?php
// We use the "classicmodels" database as a MySQL sample database.
// Download the SQL at https://www.phpformbuilder.pro/documentation/phpformbuildersampledatabase.sql.zip
// Original source: https://www.mysqltutorial.org/mysql-sample-database.aspx
// Setup your connection in phpformbuilder/vendor/migliori/power-lite-pdo/src/connection.php
use fileuploader\server\FileUploader;
use Migliori\PowerLitePdo\Db;
use phpformbuilder\Form;
$root = rtrim($_SERVER['DOCUMENT_ROOT'], DIRECTORY_SEPARATOR);
/* =============================================
Start session and include the autoloader
============================================= */
session_start();
include_once $root . '/phpformbuilder/autoload.php';
/* =============================================
Database connection
============================================= */
$container = require_once $root . '/phpformbuilder/vendor/migliori/power-lite-pdo/src/bootstrap.php';
$db = $container->get(Db::class);
/* =============================================
Validation if posted
============================================= */
if ($_SERVER["REQUEST_METHOD"] == "POST" && Form::testToken('customer-support-form') === true) {
// create validator & auto-validate required fields
$validator = Form::validate('customer-support-form');
// additional validation
$validator->email()->validate('user-email');
// check for errors
if ($validator->hasErrors()) {
$_SESSION['errors']['customer-support-form'] = $validator->getAllErrors();
} else {
/* Send email with attached file(s) */
$path = $root . '/file-uploads/';
$attachments = '';
if (isset($_POST['attachment']) && !empty($_POST['attachment'])) {
$postedFile = FileUploader::getPostedFiles($_POST['attachment']);
$attachments = $path . $postedFile[0]['file'];
}
$emailConfig = array(
'sender_email' => 'contact@phpformbuilder.pro',
'sender_name' => 'Php Form Builder',
'recipient_email' => addslashes($_POST['user-email']),
'subject' => 'Php Form Builder - Customer Support Form',
'attachments' => $attachments,
'filter_values' => 'customer-support-form, attachment'
);
$sentMessage = Form::sendMail($emailConfig);
Form::clear('customer-support-form');
}
}
/* =============================================
Select the products categories
============================================= */
$columns = array('id', 'name');
$where = [];
$extra = array('orderBy' => 'name');
$db->select('productlines', $columns, $where, $extra);
$rows = $db->fetchAll(PDO::FETCH_ASSOC);
$categories = $db->convertToSimpleArray($rows, 'name', 'id');
/* ==================================================
The Form
================================================== */
$form = new Form('customer-support-form', 'horizontal', 'novalidate', 'uikit');
$form->setMode('development');
$form->startFieldset('Please fill the form below', 'class=uk-fieldset', 'class=uk-legend uk-margin-bottom');
$form->setCols(4, 4);
$form->groupElements('first-name', 'last-name');
$form->addHelper('First name', 'first-name');
$form->addInput('text', 'first-name', '', 'Full Name: ', 'required');
$form->setCols(0, 4);
$form->addHelper('Last name', 'last-name');
$form->addInput('text', 'last-name', '', '', 'required');
$form->setCols(4, 8);
$form->addInput('email', 'user-email', '', 'E-Mail: ', 'required');
$form->addRadio('department', 'Technical', 'Technical');
$form->addRadio('department', 'Sales', 'Sales');
$form->addRadio('department', 'Billing', 'Billing');
$form->addRadio('department', 'Feedback', 'Feedback');
$form->printRadiogroup('department', 'Department', true, 'required');
$form->addRadio('urgency', 'Low', 'Low');
$form->addRadio('urgency', 'Medium', 'Medium');
$form->addRadio('urgency', 'High', 'High');
$form->printRadiogroup('urgency', 'Urgency', true, 'required');
$form->setCols(4, 8);
// empty option for slimselect placeholder
$form->addOption('category', '', '', '', 'data-placeholder=true');
foreach ($categories as $id => $name) {
$form->addOption('category', $id, $name);
}
$form->addSelect('category', 'Category', 'data-slimselect=true, data-placeholder=Choose a category, data-show-search=false, required');
$form->addSelect('product', 'Product', 'data-slimselect=true, data-placeholder=Choose a category first, disabled, required');
$form->addTextarea('message', '', 'Please describe your problem', 'rows=7, required');
$form->addHelper('Accepted File Types : .pdf, .doc[x], .xls[x], .txt', 'attachment');
// reload the previously posted file if the form was posted with errors
$currentFile = [];
if (isset($_POST['attachment']) && !empty($_POST['attachment'])) {
$postedFile = FileUploader::getPostedFiles($_POST['attachment']);
$currentFile_path = $root . '/file-uploads/';
$currentFile_name = $postedFile[0]['file'];
if (file_exists($currentFile_path . $currentFile_name)) {
$currentFile_size = filesize($currentFile_path . $currentFile_name);
$currentFile_type = mime_content_type($currentFile_path . $currentFile_name);
$currentFile = array(
'name' => $currentFile_name,
'size' => $currentFile_size,
'type' => $currentFile_type,
'file' => '/file-uploads/' . $currentFile_name, // url of the file
'data' => array(
'listProps' => array(
'file' => $currentFile_name
)
)
);
}
}
$fileUploadConfig = array(
'upload_dir' => '../../../../../file-uploads/', // the directory to upload the files. relative to phpformbuilder/plugins/fileuploader/default/php/ajax_upload_file.php
'limit' => 1, // max. number of files
'file_max_size' => 5, // each file's maximal size in MB {null, Number}
'extensions' => ['pdf', 'doc', 'docx', 'xls', 'xlsx', 'txt'],
'debug' => true // log the result in the browser's console and shows an error text on the page if the uploader fails to parse the json result.
);
$form->addFileUpload('attachment', '', 'Attach a file', '', $fileUploadConfig, $currentFile);
$form->setCols(0, 12);
$form->centerContent();
$form->addBtn('submit', 'submit-btn', 1, 'Submit', 'class=uk-button uk-button-primary, data-ladda-button=true, data-style=zoom-in');
$form->endFieldset();
// Custom radio & checkbox css
$form->addPlugin('icheck', 'input[name=\"department\"]', 'default', ['theme' => 'square', 'color' => 'red']);
$form->addPlugin('icheck', 'input[name=\"urgency\"]', 'line', ['color' => 'red']);
// Javascript validation
$form->addPlugin('formvalidation', '#customer-support-form');
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>UIkit Customer Support Form - How to create PHP forms easily</title>
<meta name="description" content="UIkit Form Generator - how to create a Customer Support Form with Php Form Builder">
<link rel="canonical" href="https://www.phpformbuilder.pro/templates/uikit-forms/customer-support-form.php" />
<!-- UIkit CSS -->
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/uikit@3.9.4/dist/css/uikit.min.css" />
<!-- Font awesome icons -->
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.15.4/css/solid.css" integrity="sha384-Tv5i09RULyHKMwX0E8wJUqSOaXlyu3SQxORObAI08iUwIalMmN5L6AvlPX2LMoSE" crossorigin="anonymous">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.15.4/css/fontawesome.css" integrity="sha384-jLKHWM3JRmfMU0A5x5AkjWkw/EYfGUAGagvnfryNV3F9VqM98XiIH7VBGVoxVSc7" crossorigin="anonymous">
<?php $form->printIncludes('css'); ?>
</head>
<body>
<h1 class="uk-text-center">Php Form Builder - UIkit Customer Support</h1>
<div class="uk-container" style="min-width:70vw;">
<div class="uk-text-center uk-margin-large-bottom">
<a href="https://www.phpformbuilder.pro/documentation/class-doc.php#database-overview" class="uk-button uk-button-default uk-button-small"><strong>Database PDO Library</strong> - documentation here</a>
</div>
<?php
if (isset($sentMessage)) {
echo $sentMessage;
}
$form->render();
?>
</div>
<!-- UIkit JavaScript -->
<script src="https://cdn.jsdelivr.net/npm/uikit@3.9.4/dist/js/uikit.min.js"></script>
<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>
<?php
$form->printIncludes('js');
$form->printJsCode();
?>
<script>
document.addEventListener('DOMContentLoaded', function(event) {
var $selectTarget = document.querySelector('select[name="product"]');
document.querySelector('select[name="category"]').addEventListener('change', function(e) {
e.preventDefault();
fetch('customer-support-form/ajax-products.php', {
method: 'POST',
body: new URLSearchParams({
'category': e.target.value
}).toString(),
headers: {
'Content-Type': 'application/x-www-form-urlencoded; charset=utf-8'
},
cache: 'no-store',
credentials: 'include'
}).then(function(response) {
return response.text()
}).then(function(data) {
$selectTarget.innerHTML = data;
// enable slimselect & update options
slimSelects['product'].enable();
$selectTarget.dispatchEvent(new Event('change'));
}).catch(function(error) {
console.log(error);
});
});
});
</script>
</body>
</html>