የአማራ መልሶ መቋቋም ልማት ድርጅት/አመልድ/ 

{source}
<!-- You can place html anywhere within the source tags -->


<script language="javascript" type="text/javascript">
// You can place JavaScript like this

</script>
<?php
$edutype =$_POST['edutype'];
$edutype=addslashes($edutype);

$db=mysql_pconnect('mysql.etisp.et','ordadb','test@123');

if(!$db)
{
echo 'could not connect to server';
exit;

}
//mysql_select_db('vacancy');
if(!mysql_select_db('ordadb')){
echo 'database not connected';
}
$result=mysql_query("insert into jos_educationtype values ('$edutype')");


if($result)
echo "<font size=22>";
echo mysql_affected_rows().'Education type added ';
echo "</font>";
?>
{/source}

{source}
<?php
$jid =$_POST['joid'];
$position =$_POST['position'];
$level=$_POST['level'];
$exp=$_POST['Exp'];
$edulevel=$_POST['edulevel'];
$edutype=$_POST['edutype'];
$pay=$_POST['payment'];
$nofreq=$_POST['noofrequired'];
$des=$_POST['des'];
$dld=$_POST['dld'];


$todays_date = date("Y-m-d");
$today = strtotime($todays_date);
$dldate = strtotime($dld);

if (preg_match ("/^([0-9]{4})-([0-9]{2})-([0-9]{2})$/", $dld, $parts)){
if(checkdate($parts[2],$parts[3],$parts[1])){

if ($dldate > $today)
goto a;
else
echo "The deadline date was past so you cannot add past date ,Please insert deadline date after Today's Date";
exit;

}
else{
echo "INvalid date,Check date either the month or day out of boundary 12 months, and 29,30,31 days acoording to months ";
exit;
}

}
else{
echo "date formate is not correct,please insert in this format YYYY-MM-DD";
exit;
}
a:

$db=mysql_pconnect('mysql.etisp.et','ordadb','test@123');

if(!$db)
{
echo 'could not connect to server';
exit;

}
//mysql_select_db('vacancy');
if(!mysql_select_db('ordadb')){
echo 'database not connected';
}

$result=mysql_query("UPDATE jos_jobpost SET j_position='$position', j_level='$level', j_experiance='$exp', j_educationlevel='$edulevel', j_educationtype='$edutype', j_payement='$pay', j_noofrequired='$nofreq', j_description='$des' ,j_deadlinedate='$dld' WHERE j_id='$jid' ");
if($result)
echo "<font size=22>";
echo mysql_affected_rows().'JOB IS Updated ';
echo "</font>";
?>
{/source}

{source}
<!-- You can place html anywhere within the source tags -->


<script language="javascript" type="text/javascript">
// You can place JavaScript like this

</script>

<form action="index.php?option=com_content&view=article&id=83:insert-to-database-edu-type&catid=37:vacancy-maneger" method="POST">
Education Type <input type="text" name="edutype" maxlength="25"><br/>
<input type="submit" value="Add">
</form>

{/source}

{source}
<!-- You can place html anywhere within the source tags -->


<script language="javascript" type="text/javascript">
// You can place JavaScript like this

</script>
<?php


$db=mysql_pconnect('mysql.etisp.et','ordadb','test@123');

if(!$db)
{
echo 'could not connect to server';
exit;

}
//mysql_select_db('vacancy');
if(!mysql_select_db('ordadb')){
echo 'database not connected';

}


$jid =$_POST['ID'];

echo " <label></label><input type=hidden name=jid value=" .$jid. "><br />";

$kal=mysql_query("DELETE FROM jos_jobpost WHERE j_id=$jid ");

if(!$kal){
echo "not deleted row";
}

else {
$result=mysql_query("SELECT 'j_position' FROM jos_jobpost WHERE j_id=$jid ");
$row = mysql_fetch_array($result);
$jobposition=$row['j_position'];
echo " Job IS Deleted"."<br/>";

$result=mysql_query("select * from jos_jobpost ");
echo "<Table border=2 cellpadding=5 cellspacing=5 border-color=#000000 bgcolor=#FF0066>
<tr bgcolor=#00CC33>
<td width='auto'>No</td>
<td width=10>Position </td>

<td width='auto'>Exeperiance</td>
<td width='auto'>Description</td>

<td width='auto'>No of Required</td>
<td width='auto'>Payment</td>
<td width='auto'>DeadLine Date</td>
<td width='auto'>Action</td>
</tr>";
$i=1;
echo "<caption>Available Job List</caption>";
while($row = mysql_fetch_array($result)) {
echo "<tr bgcolor=#F3F9FF> <td>".$i."</td>";
$currentID=$row['j_id'];

echo "<td>".$row['j_position'] . "</td><td>" . $row['j_experiance'] . "</td><td> " . $row['j_educationlevel']. " in ". $row['j_educationtype']." " .
$row['j_description'] . " </td><td>" . $row['j_noofrequired'] . "</td><td> " . $row['j_payement'] . "</td><td>" . $row['j_deadlinedate'] ."</td>
<td> <form action=index.php?option=com_content&view=article&id=59:delete-vacancy&catid=37:vacancy-maneger method=POST>
<INPUT TYPE=HIDDEN NAME=ID value= ".$currentID." /><input type=submit value=Delete></form>
<form action=# method=POST>
<INPUT TYPE=HIDDEN NAME=ID value= ".$currentID." /><input type=submit value=Edit></form></td> ";

echo "</tr>";
$i++;
}
echo "</table>";

}


?>
{/source}