/*if(dirname($_SERVER["PHP_SELF"])!="/")
$path="../";
else*/
$path="";
$lang="fr";
$page="index";
$sub="index";
$subsub="index";
require_once($path."includes/global.inc.php");
require_once($path."includes/functions.inc.php");
require_once($path."classes/dbconnect.class.php");
require_once($path."classes/interventionsmanager.class.php");
require_once($path."classes/publicationsmanager.class.php");
$publicationsmanager = new publicationsmanager($dbconnect);
$interventionsmanager = new interventionsmanager($dbconnect);
$list = array();
//$sql = "SELECT id,title_en,text_en FROM interventions ";
//$sql .= "WHERE ";
//$sql .= "title_en NOT LIKE '' ";
//$sql .= "AND homepage='1' ";
//$sql .= "ORDER BY title_fr ASC";
$sql = "SELECT id,title_fr,title_en,title_es,text_fr,text_en,text_es FROM interventions WHERE homepage='1'";
$resultset = mysql_query($sql);
if( mysql_numrows($resultset) )
{
while($row=mysql_fetch_row($resultset))
{
$interventions = new interventions();
$interventions->id = $row[0];
//
$interventions->title_fr = $row[1];
$interventions->title_en = $row[2];
$interventions->title_es = $row[3];
$interventions->text_fr = $row[4];
$interventions->text_en = $row[5];
$interventions->text_es = $row[6];
//
array_push($list,$interventions);
}
$interventions = $list;
}
$list = array();
$sql = "SELECT id,title,year,author_name1,author_firstname1,author_name2,author_firstname2,author_name3,author_firstname3,image,edition,orderyear,particule,description FROM publications ";
$sql .= "WHERE ";
$sql .= " homepage='1' ";
$sql .= "ORDER BY title ASC";
$resultset = mysql_query($sql);
if( mysql_numrows($resultset) )
{
while($row=mysql_fetch_row($resultset))
{
$publications = new publications();
$publications->id = $row[0];
$publications->title = $row[1];
$publications->year = $row[2];
$publications->author_name1 = $row[3];
$publications->author_firstname1 = $row[4];
$publications->author_name2 = $row[5];
$publications->author_firstname2 = $row[6];
$publications->author_name3 = $row[7];
$publications->author_firstname3 = $row[8];
$publications->image = $row[9];
$publications->edition = $row[10];
$publications->orderyear = $row[11];
$publications->particule = $row[12];
$publications->description = $row[13];
array_push($list,$publications);
}
$publications = $list;
}
?>
CETIM - Centre Europe - Tiers Monde - accueil, qui sommes-nous?
|
SELECTION
DE PUBLICATIONS |
|
|
|
| |