public function view_freshWorkers()
{
$db = self::dbLink();
$stmt = $db -> stmt_init();
$query ="SELECT w.pesel, w.name, w.surename, wo.lev0, w.city, w.adddate, w.tel1, w.tel1date, w.wascalled, w.jobstart, w.jobend
FROM workers w
INNER JOIN workers_occupation wo
WHERE w.pesel = wo.pesel
AND w.blacklisted = 0
AND DATE_SUB(CURDATE(),INTERVAL 14 DAY) <= adddate";
if ($stmt = $db->prepare($query))
{
if ($stmt->execute())
{
$stmt->store_result();
$stmt->bind_result($pesel_result, $name_result, $surename_result, $lev0_result, $city_result, $adddate_result, $tel1_result,
$tel1date_result, $wascalled_result, $jobstart_result, $jobend_result);
while ($stmt->fetch())
{
<td>'.$surename_result.' '.$name_result.'</td>
<td>'.$lev0_result.'</td>
<td>'.$city_result.'</td>
<td>'.$adddate_result.'</td>
<td>'.$tel1_result.'</td>
<td>'.$tel1date_result.'</td>';
if($wascalled_result == 1)
{
<div class="wascalledico_true">
<form action="called.php" method="post" >
<input type="image" src="styles/images/ico/16x16/actions/dialog-ok-apply-2.ico" value="submit" />
<input type="hidden" name="submitted_call_false" value="true" />
<input type="hidden" name="pesel" value="'.$pesel_result.'" />
</form>
</div>
</td>';
}
else
{
<div class="wascalledico_false">
<form action="called.php" method="post" >
<input type="image" src="styles/images/ico/16x16/actions/dialog-no.ico" value="submit" />
<input type="hidden" name="submitted_call_true" value="true" />
<input type="hidden" name="pesel" value="'.$pesel_result.'" />
</form>
</div>
</td> ';
}
echo '<td>'.$jobstart_result.'-'.$jobend_result.'</td> <td>
<div class="viewworkerico">
<form action="show_detail.php?id='.$pesel_result.'" method="get" >
<input type="image" src="styles/images/ico/16x16/actions/edit-find-user.ico" value="submit" />
</form>
itd....
Chodzi o ostatni form