<?

require("include/db_mysql.php"); //The class for database abstraction
require("include/my_db.php");
include('smarty/smarty.class.php');
if($_GET[action]=="adaugare") {

$today=date("Y-m-d");
$w = new imtuoradea;
$sql="INSERT INTO `imtu_imt`.`consiliere_companii` (`nume`, `post`, `experienta`, `competente`, `specializari`, `studii`, `documente`, `data_interviu`, `data_adaugare`) 
VALUES ('$_POST[nume]', '$_POST[post]', '$_POST[experienta]', '$_POST[competente]', '$_POST[specializari]', '$_POST[studii]', '$_POST[documente]', '$_POST[data_interviu]', '$today')";
$w -> query($sql);		
}
$w = new imtuoradea;
$sql = "select * from consiliere_companii where validare=1";
$w -> query($sql);
while($w -> next_record()){
    $id=$w->f(id);
    $nume=$w->f(nume);
    $post=$w->f(post);
    $data_interviu=$w->f(data_interviu);
    $result[]=array("id"=>$id,"nume"=>$nume,"post"=>$post,"data_interviu"=>$data_interviu);
}

$smart = new Smarty();
$smart -> assign("result",$result); 
$smart -> display("companii.tpl");

?>