LAAS in figures

Members



Error with the following message:

oci_connect(): ORA-01017: nom utilisateur/mot de passe non valide ; connexion refusee

in /www/html/2-31930-LAAS-in-figures.php at line 67


Code sample:


$SQL="SELECT to_char(to_date(JOUR, 'DD/MM/YY'), 'Month dd, yyyy','NLS_DATE_LANGUAGE = American') JOUR,TOTAL,CHERCHEUR_TOUS,CHERCHEUR_CNRS,ENS_CHERCHEUR,CHERCHEUR_CDD,POST_DOC,DOCTORANTS,ITA_TOUS,ITA,ITAOS,ITA_CONTRACTUEL FROM DONNEESPERSONNEL.BILAN_PERSONNEL_LAAS";

//Connection à la base de données
$conn = oci_connect('WWW_USER', 'www_user', 'dbserver.laas.fr/SI10G.LAAS.FR');

// Préparation de la requête
$stid = oci_parse($conn, $SQL);

// Exécution de la logique de la requête
$r = oci_execute($stid);


Error with the following message:

oci_parse() expects parameter 1 to be resource, boolean given

in /www/html/2-31930-LAAS-in-figures.php at line 70


Code sample:

//Connection à la base de données
$conn = oci_connect('WWW_USER', 'www_user', 'dbserver.laas.fr/SI10G.LAAS.FR');

// Préparation de la requête
$stid = oci_parse($conn, $SQL);

// Exécution de la logique de la requête
$r = oci_execute($stid);

// Récupération des résultats de la requête
$row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS);


Error with the following message:

oci_execute() expects parameter 1 to be resource, null given

in /www/html/2-31930-LAAS-in-figures.php at line 73


Code sample:

// Préparation de la requête
$stid = oci_parse($conn, $SQL);

// Exécution de la logique de la requête
$r = oci_execute($stid);

// Récupération des résultats de la requête
$row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS);

print '<br />On <b>' . $row["JOUR"] . '</b>, LAAS members are <b>' . $row["TOTAL"] . '</b> people with :


Error with the following message:

oci_fetch_array() expects parameter 1 to be resource, null given

in /www/html/2-31930-LAAS-in-figures.php at line 76


Code sample:

// Exécution de la logique de la requête
$r = oci_execute($stid);

// Récupération des résultats de la requête
$row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS);

print '<br />On <b>' . $row["JOUR"] . '</b>, LAAS members are <b>' . $row["TOTAL"] . '</b> people with :


<br />
<br />


On , LAAS members are people with :

Researchers and Faculty Members :   
Engineers, Technicians and Admin Clerks (ITA) :    

CNRS researchers

ITA from CNRS
Faculty researchers
ITA from University

Researchers under short term contract ITA under short term contract

Post-doct


PhD Students


Error with the following message:

oci_free_statement() expects parameter 1 to be resource, null given

in /www/html/2-31930-LAAS-in-figures.php at line 140


Code sample:




//Deconnection de base de données
oci_free_statement($stid);
oci_close($conn);


print '
<br />There is a variation in the population of the laboratory during the year, the largest number of people being met at the start of the academic year, when the new PhD students arrive whereas the main part of the finishing ones will be defending their doctoral thesis in the following weeks.
<br />


Error with the following message:

oci_close() expects parameter 1 to be resource, boolean given

in /www/html/2-31930-LAAS-in-figures.php at line 141


Code sample:



//Deconnection de base de données
oci_free_statement($stid);
oci_close($conn);


print '
<br />There is a variation in the population of the laboratory during the year, the largest number of people being met at the start of the academic year, when the new PhD students arrive whereas the main part of the finishing ones will be defending their doctoral thesis in the following weeks.
<br />
<br />


There is a variation in the population of the laboratory during the year, the largest number of people being met at the start of the academic year, when the new PhD students arrive whereas the main part of the finishing ones will be defending their doctoral thesis in the following weeks.

Publications



2000 2001
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011
Books 12 42 15 19 19 17 10
17 27 23 22 19
Scientific Journals
84 108 78 104 109 119 138 125 150 148 204 182
International Conferences
177 173 173 218 247 295 362 331 334 327 457 357
National Conferences
159 164 156
179
150 121 81 89 69 67 68 58
Thesis 46 36 35 49
45 52 44 50 62 56 69 62
Habilitations 5 3 1 5
6 8 6 3 2 4 9 9
Technical Reports 154 184  173
164
315 304 272 282 196 252 236 179
Sum 637 710 631 738
891 916 913
897 840 625 829 687

Budget