pb insert into mysql

lolodev

hi

i become crisy !

my insert into mysql doesn't run ...

here my code:

$today=getdate();
$jour=$today['mday'];
$mois=$today['mon'];
if($mois<'10')
$mois='0'.$mois;
$annee=$today['year'];
$date=$annee."-".$mois."-".$jour;

$tmpFile = ( @get_magic_quotes_gpc() ) ? $_FILES['Filedata']['tmp_name']   : @addslashes($_FILES['Filedata']['tmp_name']) ;
//$nomfichier = ( @get_magic_quotes_gpc() ) ? $_FILES['Filedata']['name']  : @addslashes($_FILES['Filedata']['name']) ; //nom du fichier a uploader
$targetFile=html_entity_decode(htmlentities($_FILES['Filedata']['name'], ENT_QUOTES, 'UTF-8'));
// change $_FILES['Filedata']['name'] by $targetFile in the follow line

$auteur=$_SESSION['utilisateur'];    //nom de la personne connecte
$taille = $_FILES['Filedata']['size'];
$taille=$taille/1024;
$format = $_FILES['Filedata']['type'];
$format = end(explode(".",$targetFile));



    if( $doc['parent'] != 0)  // si pas racine
    {
        $chemin.=getChemin1($doc,$db);
    }

    $chemin.=$doc['titre']."/";
    $chemin.=$targetFile;
    
  	if(file_exists($chemin.$targetFile))
	{
		exit;
	}

    if(move_uploaded_file($tmpFile,$chemin))
        {
           $req = "INSERT INTO document (nomfichier,titre,auteur,datecreat,datemodif,daterecept,format,nomsource,taille,proprietaire,parent,fichier,repertoire,ordre) VALUES('$targetFile','$targetFile','$auteur','$date','$date','$date','$format','$nomfichier','$taille','$auteur',$iddoc,1,0,2)";     
           //$req = "INSERT INTO test (nomfichier,titre) VALUES('$targetFile','$targetFile')";     
		   mysql_query($req); 
        //$result=mysql_db_query($db,"INSERT INTO document SET titre=".$res);                                          
    // on recupere les droits du pere si on n'est pas &agrave; la racine
                $recupDoc=mysql_db_query($db,"SELECT max(iddoc) as lastdocid from document");
                
                $lastdoc=mysql_fetch_array($recupDoc);
                $idlastdoc=$lastdoc[lastdocid];  // id du dernier doc enregistrÃ©
                $resDroit=mysql_db_query($db,"SELECT idaction,idrole from documentDroit where iddoc =".$iddoc) or die("Impossible de recuperer le dernier dossier cr&eacute;e");

        while($voirDroit=mysql_fetch_array($resDroit)){
                    $insertDroit=mysql_db_query($db,"insert into documentDroit (iddoc,idaction,idrole) values ($idlastdoc,$voirDroit[idaction],$voirDroit[idrole])");
                }

    }

IMPOSSIBLE to add something in TITRE or AUTEUR fields !! NOMFICHIER is GOOD !

Manual SQL statement is good ...

it's seem that AUTEUR and TITRE contains invalid caracters...

is someone have an idea ?????

sharingmaksim

Sportswear and asics shoes equipment manufacturer asics running sponsors many nationally ranked NAIA and NCAA asics running shoes and women’s teamsasics tiger, as well as the national teams of: Argentina, Asics Revolve LE, Canada, Italy, Japan, Puerto Rico, Slovenia, Spain, and Sweden. The company also sponsors individuals asics running trainers and teams that compete in the asics running sneakers, football, asics gel shoes, acis running shoes, cricket, tennis, asics gel nimbus triathlon,asics shoe and wrestling.asics onitsuka ASICS is the asics gel kinsei official apparel sponsor Asics Gel Duomax of the Olympic team of the Asics Gel Kinsei 2 Netherlands, and these Asics Gel Lyte IIIteam apparel collections were Asics Gel Stratus 2.1 designed for Asics Mexico 66 the brand by fashion Asics Mexico 66 Baja designers Warmenhoven & Venderbos. Asics Mexico 66 Couple Shoes also supplied apparel to the Asics Mexico 66 Deluxe, Dutch, Irish,Asics Mexico 66 Lauta South Korean, and Australian teams Asics Mini Cooperthat competed at the 2007 WorldAsics Onitsuka Tiger Kanuchi in Athletics in Osaka,Asics Onitsuka Tiger Olympos Japan.In its 2006 fiscal year, Asics Suroingu Japan Ar generated 171 billion yen in Asics Top Sevennet sales and 13 billion yen in net income. Sixty-six percent of the company's income comes from the sale of sports shoes,Asics Tiger New 24 percent from sportswear,Asics Ultimate 81 and 10 percent from sports equipment.Asics Whizzer Lo Forty-nine percent of the company's sales are in Japan,Onitsuka Tiger 60th Anniversary 28 percent in North America,Onitsuka Tiger Rotation 77 and 19 percent in asics tiger shoes.Tokidoki Onitsuka Tiger

Howdy, Stranger!

Categories