$staff_id = $_GET['staff_id'];
$skill_id = $_GET['skill_id'];
$qry = pg_query_params("update techmatcher.staffhaveskills set skill_deleted = true where spstaff_id = \$1 and serviceskill_id = \$2", array($staff_id, $skill_id));
?>

    <!-- add Staff button-->
    <div class="add-new-address clearfix">
        <p class="add-new-btn"><a href="javascript:void(0)" class="modalform" onclick="add_staff();">+ ADD STAFF</a></p>
    </div>

    <?php 
$staff_number = get_staff_for_provider($_SESSION['provider']['serviceprovider_id']);
$staff_counting = count($staff_number);
$staff_checker = 0;
while ($staff_counting > $staff_checker) {
    $get_staff_name = get_stafff_namee($staff_number[$staff_checker]['spstaff_id']);
    ?>
    <!-- address box -->
    <div id="div_staff_<?php 
    echo $address1[0]['address_id'];
    ?>
" class="address-box-wrap" style="float: left; margin-top: 12px;">
        <div class="address-box"><div class="address-box-inner">
                <p class="address-box-label">Staff Name</p>
                <p class="address-box-value"><?php 
    echo $get_staff_name[0]['spstaffname'];
    ?>
</p>
                <p class="address-box-show"><a id="show_box_<?php 
    echo $staff_checker;
    ?>
Exemple #2
0
<?php

session_start();
include_once '../dao/experience.php';
include_once '../dao/staff.php';
$staff_id = $_GET['id'];
$_SESSION['staff_id1'] = $staff_id;
$get_staff_name = get_stafff_namee($staff_id);
$g_hiredate = get_staffname_hiredate($staff_id);
$hiredate = $g_hiredate[0]['spstaffhiredate'];
//converting date format to m/d/Y
$date = new DateTime($hiredate);
$hire_date = $date->format('m/d/Y');
?>

<form name="edit_staff" id="edit_staff" method="post" onsubmit="return update_staff($(this));">
    <table width="90%" border="0" cellspacing="2" cellpadding="5" align="center">

        <tr>
            <td align="right"><strong>Employee name*</strong></td>
            <td><input type="text" name="employee_name" id="employee_name" value="<?php 
echo $get_staff_name[0]['spstaffname'];
?>
"/></td>
        </tr>
        <tr>
            <td align="right"><strong>Hire Date*</strong></td>
            <td><input name="hire_date" id="hire_date" value="<?php 
echo $hire_date;
?>
"/> MM/DD/YYYY</td>