<?

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_studenti` (`nume`, `specializarea`, `domeniul`, `competente`, `nota`, `diplome`, `participari`, `ocupatii`, `recomandari`, `data_adaugare`, `email`, `parola`,`validare`) 
VALUES ('$_POST[nume]', '$_POST[specializarea]', '$_POST[domeniul]', '$_POST[competente]', '$_POST[nota]', '$_POST[diplome]', '$_POST[participari]', '$_POST[ocupatii]', '$_POST[recomandari]', '$today', '$_POST[email]', '$_POST[parola]','1')";
$w -> query($sql);		
}
$w = new imtuoradea;
$sql = "select * from consiliere_studenti where validare=1 order by id desc";
$w -> query($sql);
while($w -> next_record()){
    $id=$w->f(id);
    $nume=$w->f(nume);
    $specializarea=$w->f(specializarea);

    $result[]=array("id"=>$id,"nume"=>$nume,"specializarea"=>$specializarea);
}

$smart = new Smarty();
$smart -> assign("result",$result); 
$smart -> display("studenti.tpl");

?>