Quick link to menu (Bottom of page)

Servidor Web de Carlos Carrascosa Casamayor
"; //echo ""; //echo ""; //echo ""; //echo ""; if($nAutores > 1) $listadoAutores.=" and ".$autor; else $listadoAutores.=" ".$autor; echo "
  • "; echo $listadoAutores."
    "; if($fichero !=0 && $publico == 1) echo "".$titulo."

  • "; else echo "".$titulo."
    "; echo $congRev." ".$volumen.$numero.$paginas.". (".$anho.") "; echo 'Bibtex

    '; $nAutores = 0; } //$listadoAutores=$rst->datos[4]; //$listadoAutores.=","; $listadoAutores = ""; $autor= ""; } $aux=$rst->datos[0]; $titulo = $rst->datos[1]; $anho = $rst->datos[2]; $congRev = $rst->datos[3]; $autor = $rst->datos[4]; $fichero = $rst->datos[6]; $volumen = $rst->datos[7]; $publico = $rst->datos[10]; if($volumen != "") $volumen = " Vol. ".$volumen; $numero = $rst->datos[8]; if($numero != "") $numero = " No. ".$numero; $paginas = $rst->datos[9]; if($paginas != "") $paginas = " pp. ".$paginas; $nAutores++; $rst->movenext(); $row++; } if($hayRegs ==1 ) { if($nAutores > 1) $listadoAutores.=" and ".$autor; else $listadoAutores.=$autor; echo "
  • "; echo $listadoAutores."
    "; if($fichero !=0 && $publico==1) echo "".$titulo."

  • "; else echo "".$titulo."
    "; echo $congRev." ".$volumen.$numero.$paginas." .(".$anho.") "; echo 'Bibtex

    '; echo ""; } ?>

    cnx = null; } function open($host,$user,$pass){ $this->cnx = mysql_connect($host,$user,$pass); } function close(){ mysql_close($this->cnx); } } // --------------------------------------------------------- // ------- Implementación de la clase recordset ------------ // --------------------------------------------------------- class MysqlRecordSet{ var $numFil; //row number var $datos; //Array of fields var $position; //recordset pointer var $EOF; var $BOF; var $result; //data function MysqlRecordSet() { $this->EOF = true; $this->BOF = false; $this->numFil = 0; } function open($dbname, $sql, $cnx) { mysql_select_db($dbname,$cnx) or die ("Can't Select $dbname trough $cnx to do $sql"); $this->result = mysql_db_query($dbname, $sql, $cnx) or die ("Can't Query $sql"); @$this->numFil = mysql_num_rows($this->result); if ($this->numFil<=1) { $this->EOF = true; }else{ $this->EOF = false; } $this->position = 0; } function execute($dbname, $sql, $cnx) { $this->open($dbname, $sql, $cnx); } function getReg() { @mysql_data_seek($this->result,$this->position); $this->datos = null; $this->datos = mysql_fetch_array($this->result); } function moveFirst() { $this->position = 0; $this->EOF = false; $this->getReg(); } function moveLast() { $this->position = $this->numFil-1; $this->EOF = false; $this->getReg(); } function moveNext() { if ($this->position < $this->numFil-1) { $this->position++; $this->getReg(); } else { $this->EOF = true; } } function movePrev(){ if ($this->position > 0){ $this->position--; $this->getReg(); }else{ $this->BOF = true; } } function find($campo, $valor) { $this->moveFirts(); $encontrado = false; while ($this->EOF!=true){ if ($this->datos["$campo"]==$valor){ $encontrado = true; break; } $this->moveNext(); } return $encontrado; } function addNew($cnx, $dbname, $tabla, $datos) { $sql = "insert into $tabla values ('"; for ($i=0;$iexecute($dbname, $sql, $cnx); } function close() { @mysql_free_result($this->result); } }// end class $hayRegs = 0; //step one open the database connection so we need the first class : $MyCnx = new MysqlCnx; //now we open the cnx $MyCnx->open("urano.dsic.upv.es","admin_gti","agiretgti"); //now we are ready the use the database cnx every time that we need it //until we don't close it. //using the second class $rst = new MysqlRecordSet; //now we need to create the sql query $sql = "SET OPTION SQL_BIG_TABLES = 1"; $rst->open("gti",$sql,$MyCnx->cnx); $sql = "SELECT DISTINCT GTH1.idArticulo, A.titulo, A.anho, A.nombCongRev, AG1.nick, GTH1.orden, A.fichero, A.volumen,A.numero,A.paginas,A.bibPublic FROM gtiHaEscrito GTH1, gtiHaEscrito GTH2, articulos A, autoresGti AG1, autoresGti AG2 WHERE GTH1.idArticulo = A.idArticulo AND GTH2.idArticulo = A.idArticulo AND AG1.idAutor = GTH1.idAutor AND AG2.idAutor = GTH2.idAutor "; //if($year1 != "" && $year2 != "") //$sql.= "AND A.anho BETWEEN ".$year1." AND ".$year2." "; $sql.= "AND AG2.apellidos = 'Carrascosa Casamayor' "; // if($txtTitulo != "") // $sql.= "AND A.titulo LIKE '%".$txtTitulo."%' "; $sql.="ORDER BY A.anho DESC,GTH1.idArticulo DESC,GTH1.orden"; $hayRegs = 0; $rst->open("gti",$sql,$MyCnx->cnx); $rst->moveFirst(); echo "

      "; $rst->moveNext(); if($rst->EOF!= true) { // Hay Registros; $hayRegs = 1; $rst->movePrev(); } //$result = mysql_query("SELECT articulos.idArticulo, articulos.titulo, articulos.anho, autoresGti.apellidos, autoresGti.nombre // FROM articulos // JOIN gtiHaEscrito ON gtiHaEscrito.idArticulo = articulos.idArticulo // ",$link); $aux = -1; $listadoAutores = ""; $titulo = ""; $anho = ""; $congRev = ""; $row = 0; $autor =""; $nAutores = 0; $fichero = 0; $publico = 0; while ($rst->EOF!=true) { //echo $rst->datos[0].$rst->datos[1].$rst->datos[2].$rst->datos[3].$rst->datos[4]; if($rst->datos[0] == $aux) { //$listadoAutores.=$rst->datos[4]; //$listadoAutores.=","; if ( $nAutores > 1 ) $listadoAutores.=", ".$autor; else $listadoAutores.=$autor; } else { if($row > 0) { //echo "
    ".$listadoAutores."".$titulo."".$anho."
    Algunos enlaces
    CiteSeerXbeta logo

    Documents:

    Include Citations | Advanced Search | Help

    Authors:

    Include Citations | Advanced Search | Help

    www.scirus.com
    Search only by Author
    Search only in Computer Science
    Conference Rankings
    Journal Rankings

    Search query

    in
    Exact phrase
    Noticias: Aficiones

    Comentarios, sugerencias, ...

    Menu:

    Take me back to the top.