PHP hr::bind Examples

Example #1

File: yFrontAjax.php Project: ravindevteam/tasksapp

<?php

session_start();
require_once "classes/tasksConnection.php";
require_once "classes/hrConnection.php";
require_once "_inc/mFunctions.php";
$hr_db = new hr();
$db = new db();
if (!empty($_REQUEST['action']) && $_REQUEST['action'] == "getEmployees") {
    $jobId = $_REQUEST['jobId'];
    $data = '';
    //get employees under this job
    $q = "SELECT users.emp_id, users.name FROM `users` \n\t\t   JOIN `employees` on employees.emp_id = users.emp_id\n\t\t   WHERE employees.job_id = :jobId ORDER BY emp_id";
    $sq = $hr_db->query($q);
    $hr_db->bind(":jobId", $jobId);
    $sq = $hr_db->execute();
    $getEmployees = $hr_db->fetchAll();
    if (!empty($getEmployees)) {
        $data .= "<option value=''>Select...</option>";
        foreach ($getEmployees as $Employees) {
            $data .= "<option value='" . $Employees['emp_id'] . "'>" . $Employees['name'] . "</option>";
        }
    }
    echo $data;
}
if (!empty($_REQUEST['action']) && $_REQUEST['action'] == "addTask") {
    $creatorId = $_REQUEST['creatorId'];
    $assigneeId = $_REQUEST['assigneeId'];
    $locId = $_REQUEST['locId'];
    $date = $_REQUEST['date'];
    $repeat = $_REQUEST['repeat'];