Sujet Précédent Sujet Suivant

Passage de PHP4 a PHP5 - Ajout MySQL

jothecracker Messages postés 26 Date d'inscription jeudi 26 décembre 2002 Statut Membre Dernière intervention 9 mars 2011 - 9 déc. 2009 à 04:09
jothecracker Messages postés 26 Date d'inscription jeudi 26 décembre 2002 Statut Membre Dernière intervention 9 mars 2011 - 9 déc. 2009 à 04:50

Bonjour,

Je suis passer ressemant sur PHP5 et depuis impossible de faire un ajout dans ma Base mySQL, aucun message d'erreur je ne comprend pas d'ou vient l'erreur...

Mon code estait fonctionnel sur PHP4, maintenant impossible de l'executer, Safari me retourne ceci :

Safari ne parvient pas à ouvrir la page.
Safari ne parvient pas à ouvrir la page « http://127.0.0.1/index.php?load= _Add » car le serveur a inopinément interrompu la connexion. Ceci arrive parfois lorsque le serveur est occupé. Attendez quelques minutes et essayez à nouveau.

et firefox m'offre une jolie page blanche...

voici le code de la page :

<?php

session_start();

if(isset($_SESSION['Responsibility']))
{

include("content/add/_post.php");
include("content/add/_variables.php");
 	include("mySQL/_base.php");
 	
 	//DATE_FORMAT(madate, "%d/%m/%Y")
 	//SELECT DATE_FORMAT(madate, "%d/%m/%Y") FROM matable;
 	
 
 	$nom = $_SESSION['NOM'];
 	$prenom = $_SESSION['PRENOM'];
 	

//cree la chaine date (YYYY-MM-DD) pour mySQL
$datesql = $Date_Annee .'-'.date('m',strtotime('2000-'.$Date_Mois.'-01')).'-'.$Date_Jour;
 	
 	$dateFault = $Date_Fault_Annee .'-'.date('m',strtotime('2000-'.$Date_Fault_Mois.'-01')).'-'.$Date_Fault_Jour;
 	
 	//Traitement des variables de Status
  	if ($Swap_Status == "Open" && $Swap_Replace=='y') {$swap_sta='1';}else {$swap_sta='0';}	
 	if ($WorkStatus == 'Open') {$work_sta='1';}else {$work_sta='0';}	
  	
  	//Genenrent les heures (00:00)
$time_start = $StartTime_Heure.':'.$StartTime_Minutes; //generent les heures
$time_finish = $FinishTime_Heure.':'.$FinishTime_Minutes;
 	
 	// ouverture de la connexion
   	$connexion = mysql_connect($hote,$login,$mdp) or die ('Erreur de connexion '.mysql_error());
   	// choix de la base CD_test
  	mysql_select_db('Daily_Book',$connexion);

//Recupere l'id de Secu_List_Users pour MySQL
$mysql_result mysql_query('SELECT ID FROM Secu_List_Users WHERE Nom\''.$nom.'\' AND Prenom =\''.$prenom.'\'');
$ligne = mysql_fetch_array($mysql_result);
$team = $ligne['ID'];

//Recupere l'id de Secu_List_Users pour MySQL
list($TechNom, $TechPrenom)= split (" - ", $Prb_Who_Know);
$mysql_result mysql_query('SELECT ID FROM Secu_List_Users WHERE Nom\''.$TechNom.'\' AND Prenom =\''.$TechPrenom.'\'');
$ligne = mysql_fetch_array($mysql_result);
$technical = $ligne['ID'];

//Recupere l'id de Event_Source pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Issued_ID WHERE Name\''.$Event_Source.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Event_Source_id = $ligne['ID'];

//Recupere l'id de Responsability pour MySQL
$mysql_result  mysql_query('SELECT ID FROM FRACAS_Team_Leader WHERE Name\''.$Responsibility.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Responsibility_id = $ligne['ID'];

//Recupere l'id de Func_Main pour MySQL
//$mysql_result  mysql_query('SELECT ID FROM List_Main_Func WHERE Main_Func\''.$Main_Func.'\'');
//$ligne = mysql_fetch_array($mysql_result);
//$Main_Func_id = $ligne['ID'];

//Recupere l'id de MAP_Code pour MySQL
$mysql_result  mysql_query('SELECT ID FROM List_MAP_Code WHERE MAP_Code\''.$MAP_Code.'\'');			
$ligne = mysql_fetch_array($mysql_result);
$MAP_Code_id = $ligne['ID'];
//Recupere l'id de Noria_Code pour MySQL
$mysql_result  mysql_query('SELECT ID FROM List_Noria_Code WHERE Noria_Code\''.$Noria_Code.'\'');			
$ligne = mysql_fetch_array($mysql_result);
$Noria_Code_id = $ligne['ID'];

//Recupere l'id de Fault_code1 pour MySQL
$mysql_result  mysql_query('SELECT ID FROM List_Fault_Code WHERE Fault_Code\''.$Event_Code1.'\'');			
$ligne = mysql_fetch_array($mysql_result);
$Event_Code1_id = $ligne['ID'];

//Recupere l'id de Fault_code2 pour MySQL
$mysql_result  mysql_query('SELECT ID FROM List_Fault_Code WHERE Fault_Code\''.$Event_Code2.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Event_Code2_id = $ligne['ID'];

//Recupere l'id de Fault_code3 pour MySQL
$mysql_result  mysql_query('SELECT ID FROM List_Fault_Code WHERE Fault_Code\''.$Event_Code3.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Event_Code3_id = $ligne['ID'];

if($Swap_Replace != 'y')
{
//Recupere l'id de Loco_Number pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Loco_Number WHERE Loco_Number\''.$Loco_Number.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Loco_Number_id = $ligne['ID'];
//Recupere l'id de Loco_Unit pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Loco_Unit WHERE Loco_Unit\''.$Loco_Unit.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Loco_Unit_id = $ligne['ID'];
//Recupere l'id de Under_Func pour MySQL
//$mysql_result  mysql_query('SELECT ID FROM List_Under_Func WHERE Under_Func\''.$Under_Func.'\'');
//$ligne = mysql_fetch_array($mysql_result);
//$Under_Func_id = $ligne['ID'];
}
else
{
//Recupere l'id de Loco_Number_A pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Loco_Number WHERE Loco_Number\''.$Loco_Number_A.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Loco_Number_A_id = $ligne['ID'];
//Recupere l'id de Loco_Unit_A pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Loco_Unit WHERE Loco_Unit\''.$Loco_Unit_A.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Loco_Unit_A_id = $ligne['ID'];
//Recupere l'id de Under_Func_A pour MySQL
//$mysql_result  mysql_query('SELECT ID FROM List_Under_Func WHERE Under_Func\''.$Under_Func_A.'\'');
//$ligne = mysql_fetch_array($mysql_result);
//$Under_Func_A_id = $ligne['ID'];
//Recupere l'id de Loco_Number_B pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Loco_Number WHERE Loco_Number\''.$Loco_Number_B.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Loco_Number_B_id = $ligne['ID'];
//Recupere l'id de Loco_Unit_B pour MySQL
$mysql_result mysql_query('SELECT ID FROM FRACAS_Loco_Unit WHERE Loco_Unit\''.$Loco_Unit_B.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Loco_Unit_B_id = $ligne['ID'];
//Recupere l'id de Under_Func_B pour MySQL
//$mysql_result  mysql_query('SELECT ID FROM List_Under_Func WHERE Under_Func\''.$Under_Func_B.'\'');
//$ligne = mysql_fetch_array($mysql_result);
//$Under_Func_B_id = $ligne['ID'];		
}

if ($_POST['Choix']=='Schematic_Name')
{
//Recupere l'id de Schema_name pour MySQL si selected
$mysql_result  mysql_query('SELECT ID FROM FRACAS_Arbo WHERE Schem_Name\''.$Schem_Name.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Schem_Name_id = $ligne['ID'];
$Part_Number_id = $ligne['ID'];
}
else
{
//Recupere l'id de Part_Number pour MySQL si selected
$mysql_result  mysql_query('SELECT ID FROM FRACAS_Arbo WHERE Part_Number\''.$Part_Number.'\'');
$ligne = mysql_fetch_array($mysql_result);
$Part_Number_id = $ligne['ID'];
$Schem_Name_id = $ligne['ID'];
}
 	
 	if($Swap_Replace == 'r')
 	{
 		
 		$sql= "INSERT INTO Daily_Book(ID,Date,Loco_Number_id,Loco_Unit_id,Starting_Time,Finishing_Time,Team,Event_Source_id,Failure_Cat,FI,Fault_Code1_id,Fault_Code2_id,Fault_Code3_id,Main_Func_id,Under_Func_id,Even_Descrip,Troo_Descrip,Work_Descrip,Loco_Mileage,MAP_Code_id,Noria_Code_id,Swap_Status,Schem_Name_id,Swap_BefNbr,Swap_AftNbr,Part_Number_id,Repla_In,Repla_Out,Serial_Number,Responsibility_id,Status,Short_Descrip,Prob_Freq,Technical_Valid,Fault_Date,Fault_File)VALUES('','$datesql','$Loco_Number_id','$Loco_Unit_id','$time_start','$time_finish','$team','$Event_Source_id','','NA','$Event_Code1_id','$Event_Code2_id','$Event_Code3_id','$Main_Func_id','$Under_Func_id','$Even_Descrip','$Troo_Descrip','$Work_Descrip','$Loco_Mileage','$MAP_Code_id','$Noria_Code_id','9','$Schem_Name_id','','','$Part_Number_id','','','$Serial_Number','$Responsibility_id','$work_sta','$Prb_Short','$Prb_Freq','$technical','$dateFault','$Fault_File')";
 		
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error()); 
 		
 	}
 	elseif ($Swap_Replace == 'n')
 	{

 		$sql= "INSERT INTO Daily_Book(ID,Date,Loco_Number_id,Loco_Unit_id,Starting_Time,Finishing_Time,Team,Event_Source_id,Failure_Cat,FI,Fault_Code1_id,Fault_Code2_id,Fault_Code3_id,Main_Func_id,Under_Func_id,Even_Descrip,Troo_Descrip,Work_Descrip,Loco_Mileage,MAP_Code_id,Noria_Code_id,Swap_Status,Schem_Name_id,Swap_BefNbr,Swap_AftNbr,Part_Number_id,Repla_In,Repla_Out,Serial_Number,Responsibility_id,Status,Short_Descrip,Prob_Freq,Technical_Valid,Fault_Date,Fault_File)VALUES('','$datesql','$Loco_Number_id','$Loco_Unit_id','$time_start','$time_finish','$team','$Event_Source_id','','','$Event_Code1_id','$Event_Code2_id','$Event_Code3_id','$Main_Func_id','$Under_Func_id','$Even_Descrip','$Troo_Descrip','$Work_Descrip','$Loco_Mileage','$MAP_Code_id','$Noria_Code_id','5','$Schem_Name_id','','','$Part_Number_id','$Repla_In','$Repla_Out','','$Responsibility_id','$work_sta','$Prb_Short','$Prb_Freq','$technical','$dateFault','$Fault_File')";
 				
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error()); 

 	}
 	if ($Swap_Replace == 'y')
 	{

 		$sql= "INSERT INTO Daily_Book(ID,Date,Loco_Number_id,Loco_Unit_id,Starting_Time,Finishing_Time,Team,Event_Source_id,Failure_Cat,FI,Fault_Code1_id,Fault_Code2_id,Fault_Code3_id,Main_Func_id,Under_Func_id,Even_Descrip,Troo_Descrip,Work_Descrip,Loco_Mileage,MAP_Code_id,Noria_Code_id,Swap_Status,Schem_Name_id,Swap_BefNbr,Swap_AftNbr,Part_Number_id,Repla_In,Repla_Out,Serial_Number,Responsibility_id,Status,Short_Descrip,Prob_Freq,Technical_Valid,Fault_Date,Fault_File)VALUES('','$datesql','$Loco_Number_A_id','$Loco_Unit_A_id','$time_start','$time_finish','$team','$Event_Source_id','','','$Event_Code1_id','$Event_Code2_id','$Event_Code3_id','$Main_Func_id','$Under_Func_A_id','$Even_Descrip','$Troo_Descrip','$Work_Descrip','$Loco_Mileage_A','$MAP_Code_id','$Noria_Code_id','$swap_sta','$Schem_Name_id','$Swap_BefNbr_A','$Swap_AftNbr_A','$Part_Number_id','','','','$Responsibility_id','$work_sta','$Prb_Short','$Prb_Freq','$technical','$dateFault','$Fault_File')";
 			
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error()); 

 		$sql= "INSERT INTO Daily_Book(ID,Date,Loco_Number_id,Loco_Unit_id,Starting_Time,Finishing_Time,Team,Event_Source_id,Failure_Cat,FI,Fault_Code1_id,Fault_Code2_id,Fault_Code3_id,Main_Func_id,Under_Func_id,Even_Descrip,Troo_Descrip,Work_Descrip,Loco_Mileage,MAP_Code_id,Noria_Code_id,Swap_Status,Schem_Name_id,Swap_BefNbr,Swap_AftNbr,Part_Number_id,Repla_In,Repla_Out,Serial_Number,Responsibility_id,Status,Short_Descrip,Prob_Freq,Technical_Valid,Fault_Date,Fault_File)VALUES('','$datesql','$Loco_Number_B_id','$Loco_Unit_B_id','$time_start','$time_finish','$team','$Event_Source_id','','','$Event_Code1_id','$Event_Code2_id','$Event_Code3_id','$Main_Func_id','$Under_Func_B_id','$Even_Descrip','$Troo_Descrip','$Work_Descrip','$Loco_Mileage_B','$MAP_Code_id','$Noria_Code_id','$swap_sta','$Schem_Name_id','$Swap_BefNbr_B','$Swap_AftNbr_B','$Part_Number_id','','','','$Responsibility_id','$work_sta','$Prb_Short','$Prb_Freq','$technical','$dateFault','$Fault_File')";
 		
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error()); 
 	}
 	
 	mysql_close();  // on ferme la connexion 
 	
//reset la session !!
unset($_SESSION['Date_Jour']);
unset($_SESSION['Date_Mois']);
unset($_SESSION['Date_Annee']);
unset($_SESSION['Event_Source']);
unset($_SESSION['StartTime_Heure']);
unset($_SESSION['StartTime_Minutes']);
unset($_SESSION['FinishTime_Heure']);
unset($_SESSION['FinishTime_Minutes']);
unset($_SESSION['Loco_Number']);
unset($_SESSION['Loco_Unit']);
unset($_SESSION['Loco_Mileage']);
unset($_SESSION['Loco_Number_A']);
unset($_SESSION['Loco_Unit_A']);
unset($_SESSION['Loco_Mileage_A']);
unset($_SESSION['Loco_Number_B']);
unset($_SESSION['Loco_Unit_B']);
unset($_SESSION['Loco_Mileage_B']);
unset($_SESSION['MAP_Code']);
unset($_SESSION['Noria_Code']);
unset($_SESSION['Swap_Replace']);
unset($_SESSION['Responsibility']);
unset($_SESSION['WorkStatus']);
unset($_SESSION['Event_Code1']);
unset($_SESSION['Event_Code2']);
unset($_SESSION['Event_Code3']);
unset($_SESSION['Main_Func']);
unset($_SESSION['Under_Func']);
unset($_SESSION['Under_Func_A']);
unset($_SESSION['Under_Func_B']);
unset($_SESSION['Even_Descrip']);
unset($_SESSION['Troo_Descrip']);
unset($_SESSION['Work_Descrip']);
unset($_SESSION['Schem_Name']);
unset($_SESSION['Part_Number']);
unset($_SESSION['Swap_BefNbr_A']);
unset($_SESSION['Swap_BefNbr_B']);
unset($_SESSION['Swap_AftNbr_A']);
unset($_SESSION['Swap_AftNbr_B']);
unset($_SESSION['Swap_Status']);
unset($_SESSION['Repla_In']);
unset($_SESSION['Repla_Out']);
unset($_SESSION['Serial_Number']);
 	unset($_SESSION['Part_Descrip']);
unset($_SESSION['Cathegorie']);
unset($_SESSION['Prim_Func']);
unset($_SESSION['Prb_Short']);
unset($_SESSION['Fault_File']);
unset($_SESSION['Prb_Who_Know']);
unset($_SESSION['Prb_Freq']);

$this->content ='
<center>
<form action="?load=Acceuil" 




Update Successful !
,

----

,

----

Your informations was add in our Data Base.







 "> 




</form>
</center>'; 

}
else
{
header("Location: ?load =Acceuil");
}


?>

Si quelqu'un a la moindre petite idee de la provenance de l'erreur, je suis tout ouie ...

Cordialement,

Vash

A voir également:

Passage de PHP4 a PHP5 - Ajout MySQL
C# passage par référence - Conseils pratiques -C# / .NET
Créer un utilisateur mysql - Conseils pratiques -PHP
Mysql iis - Conseils pratiques -PHP
Php mysql - Conseils pratiques -PHP
Mysql if ✓ - Forum PHP

2 réponses

Réponse 1 / 2

jothecracker Messages postés 26 Date d'inscription jeudi 26 décembre 2002 Statut Membre Dernière intervention 9 mars 2011 1
9 déc. 2009 à 04:48

Re Bonjour,

J'avance un peu dans mon problème, apparemment le problème viendrait de :

extension=mysql.so

dans le php.ini

le truc c'est que sous mac os x... je sais pas vraiment comment ca se passe.

Réponse 2 / 2

jothecracker Messages postés 26 Date d'inscription jeudi 26 décembre 2002 Statut Membre Dernière intervention 9 mars 2011 1
9 déc. 2009 à 04:50

extension=mysql.so

dans le php.ini
Source : ArchLinux.fr

Discussions similaires

Se connecter à mysql sur un port 3306 et/ou 3307

connexion du MySQL avec javafx

foreach $_POST INSERT MYSQL

Enregistrer une date dans MySQL

Formulaire de connexion et d'inscription

Votre réponse

Discussions similaires