Example #1
0
 function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
 {
     if (PHP_VERSION < 6) {
         $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
     }
     $theValue = function_exists("oci_real_escape_string") ? oci_real_escape_string($theValue) : oci_escape_string($theValue);
     switch ($theType) {
         case "text":
             $theValue = $theValue != "" ? "'" . $theValue . "'" : "NULL";
             break;
         case "long":
         case "int":
             $theValue = $theValue != "" ? intval($theValue) : "NULL";
             break;
         case "double":
             $theValue = $theValue != "" ? doubleval($theValue) : "NULL";
             break;
         case "date":
             $theValue = $theValue != "" ? "'" . $theValue . "'" : "NULL";
             break;
         case "defined":
             $theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
             break;
     }
     return $theValue;
 }
Example #2
0
 public function modifier()
 {
     $rq = "UPDATE " . SCHEMA . ".IMPACT SET ";
     $rq .= "APPLICATION_ID='" . $this->getApplicationId() . "',";
     $rq .= "DATESTART=TO_TIMESTAMP('" . $this->getDateDebut() . "','DD/MM/YYYY HH24:MI'),";
     $rq .= "DATEEND=TO_TIMESTAMP('" . $this->getDateFin() . "','DD/MM/YYYY HH24:MI'),";
     $rq .= "DUREEREELLE='" . oci_escape_string(html_entity_decode($this->getDureeReelle())) . "',";
     $rq .= "JOURHOMME='" . oci_escape_string(html_entity_decode($this->getJourHomme())) . "',";
     $rq .= "IMPACTMETIER='" . $this->getImpactMetier() . "',";
     $rq .= "IMPACT='" . $this->getImpact() . "',";
     $rq .= "SLA='" . $this->getSla() . "',";
     $rq .= "SEVERITE='" . $this->getSeverite() . "',";
     $rq .= "DESCRIPTION='" . oci_escape_string(html_entity_decode($this->getDescription())) . "',";
     $rq .= "UPDATED=sysdate";
     $rq .= " WHERE ID=" . $this->getId();
     $db = new db();
     $db->db_connect();
     $db->db_query($rq);
     $db->close();
 }
Example #3
0
 public function Modifier()
 {
     $rq = "UPDATE " . SCHEMA . ".INCIDENT SET ";
     $rq .= "TITRE='" . oci_escape_string(html_entity_decode($this->getTitre())) . "',";
     $rq .= "INCIDENT='" . oci_escape_string(html_entity_decode(trim($this->getIncident()))) . "',";
     $rq .= "DEPARTEMENT='" . oci_escape_string(html_entity_decode($this->getDepartement())) . "',";
     $rq .= "STATUT='" . $this->getStatut() . "',";
     $rq .= "PRIORITE='" . $this->getPriorite() . "',";
     $rq .= "AFFECTEDUSER='******',";
     $rq .= "DATEDEBUT=TO_TIMESTAMP('" . $this->getDateDebut() . "','DD/MM/YYYY HH24:MI'),";
     $rq .= "DATEFIN=TO_TIMESTAMP('" . $this->getDateFin() . "','DD/MM/YYYY HH24:MI'),";
     $rq .= "DUREE='" . $this->getDuree() . "',";
     $rq .= "DESCRIPTION='" . oci_escape_string(html_entity_decode($this->getDescripIncident())) . "',";
     $rq .= "RISQUEAGGRAVATION='" . $this->getRisqueAggravation() . "',";
     $rq .= "CAUSE='" . oci_escape_string(html_entity_decode($this->getCause())) . "',";
     $rq .= "INCIDENTSCONNEXES='" . oci_escape_string(html_entity_decode($this->getConnexe())) . "',";
     $rq .= "PROBLEME='" . oci_escape_string(html_entity_decode($this->getProbleme())) . "',";
     $rq .= "RETABLISSEMENT='" . oci_escape_string(html_entity_decode($this->getRetablissement())) . "',";
     $rq .= "RESPONSABILITE='" . $this->getResponsabilite() . "',";
     $rq .= "SERVICEACTEUR='" . $this->getActeur() . "',";
     $rq .= "LOCALISATION='" . oci_escape_string(html_entity_decode($this->getLocalisation())) . "',";
     $rq .= "USERACTION='" . oci_escape_string(html_entity_decode($this->getActionUtlisateur())) . "',";
     $rq .= "DATEPUBLICATION=TO_TIMESTAMP('" . $this->getDateCreci() . "','DD/MM/YYYY'),";
     $rq .= "COMMENTAIRE='" . oci_escape_string(html_entity_decode($this->getCommentaire())) . "',";
     $rq .= "DEJAAPPARU='" . $this->getDejaApparu() . "',";
     $rq .= "PREVISIBLE='" . $this->getPrevisible() . "',";
     $rq .= "SUIVI=" . $this->getSuivi() . ",";
     $rq .= "DATE_DECISION=TO_TIMESTAMP('" . $this->getDateDecision() . "','DD/MM/YYYY HH24:MI'),";
     $rq .= "CHRONOGRAMME='" . oci_escape_string(html_entity_decode($this->getChronogramme())) . "',";
     $rq .= "UPDATED=sysdate";
     $rq .= " WHERE ID=" . $this->getNumero();
     // debug($rq);
     $base = new db();
     $base->db_connect();
     $base->db_query($rq);
     $base->close();
 }
Example #4
0
	
	$conn = oci_connect("pms_rnd","pms_rnd", "203.201.225.124");
	if (!$conn) {
		$e = oci_error();
		trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);		
	}
	
	$stid = oci_parse($conn, "SELECT first_name, last_name FROM pms_employee WHERE first_name LIKE '%$my_data%' or last_name LIKE '%$my_data%' ORDER BY first_name");
	oci_execute($stid);
	

	while($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS))
	{
		echo $row['first_name'];	
	}<?php */
$q = $_GET['q'];
$my_data = oci_escape_string($q);
$conn = oci_connect("pms_rnd", "pms_rnd", "203.201.225.124/ipcatest");
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT first_name, last_name FROM pms_employee WHERE first_name LIKE '%{$my_data}%' or last_name LIKE '%{$my_data}%' ORDER BY first_name");
oci_execute($stid);
while ($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) {
    echo $row['title'] . " " . $row['first_name'] . " " . $row['last_name'] . "\n";
}
function oci_escape_string($string)
{
    return str_replace(array('"', "'", '\\'), array('\\"', '\\\'', '\\\\'), $string);
}