22/10/2008, 11:59
|
| | | Fecha de Ingreso: marzo-2007 Ubicación: Chile
Mensajes: 222
Antigüedad: 17 años, 1 mes Puntos: 6 | |
Respuesta: Ayuda con funcion include Si, pero dentro de tu while debes colocar esto.... Código PHP: <?php $id=$data['Pers_Id']; ?> Cita:
Iniciado por willykamp ahh osea que en el codigo le cambio donde diga $_GET['Id']; solo por $Id?
codigo original "update_time_pilot.php" Código PHP: <?php include("config/conf.php"); $requestvid = $_GET['Id']; // CONNEXION MYSQL $db_link = @mysql_connect($sql_serveur,$sql_user,$sql_passwd); if(!$db_link) {echo "No connected to <b>$sql_bdd</b> on the server <b>$sql_server</b>"; exit;} $details=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$requestvid\"",$db_link) or die(mysql_error()); $Pers_Last_Name=mysql_result($details,0,"Pers_Last_Name"); $Pers_First_Name=mysql_result($details,0,"Pers_First_Name"); $Pers_Id=mysql_result($details,0,"Pers_Id"); $Pers_Time_Pilot=mysql_result($details,0,"Pers_Time_Pilot"); $Pers_isPilot=mysql_result($details,0,"Pers_isPilot"); $Pers_Time_Total=mysql_result($details,0,"Pers_Time_Total"); $Pers_Time_All=mysql_result($details,0,"Pers_Time_All"); $cumulold = '0'; if($Pers_isPilot=="0")print 'Not Pilot '.$requestvid.'<br>'; else { $cumulreq=mysql_db_query($sql_bdd,"select CUMUL from ivan_time where VID=\"$requestvid\" and TYPE=\"PILOT\"",$db_link) or die(mysql_error()); { // SI L'ID N'EXISTE PAS if(mysql_num_rows($cumulreq)==0) { print 'No Pilot time '.$requestvid.'<br>'; } else { while ($data = mysql_fetch_array($cumulreq)) { { $cumul = $cumulold + $data['CUMUL']; $cumulold = $cumul; } } $new_cumul = $cumulold; $cumul_minutes = floor($new_cumul / 60); $total_cumul = $Pers_Time_Pilot + $cumul_minutes; $total_total = $Pers_Time_Total + $cumul_minutes; $total_all = $Pers_Time_All + $cumul_minutes; $Pers_Updated_Set = date("Y-m-d H:i:s"); $hourupdate=mysql_db_query($sql_bdd,"UPDATE user_data SET Pers_Time_Pilot='$total_cumul',Pers_Time_Total='$total_total',Pers_Time_All='$total_all',Pers_Updated='$Pers_Updated_Set' WHERE Pers_Id='$requestvid'",$db_link) or die(mysql_error()); { if($hourupdate) { print ''.$requestvid.' updated<br>'; } } $requete=mysql_db_query($sql_bdd,"select max(DATE_FIN) from ivan_time where VID=\"$requestvid\" and TYPE=\"PILOT\"",$db_link) or die(mysql_error()); $datemax=mysql_result($requete,0,"max(DATE_FIN)"); $datemax=$datemax-3600; $lastonlineupdate=mysql_db_query($sql_bdd,"UPDATE user_data SET lo_pilot='$datemax' WHERE Pers_Id='$requestvid'",$db_link) or die(mysql_error()); $delall=mysql_db_query($sql_bdd,"DELETE FROM ivan_time WHERE VID=\"$requestvid\" and TYPE=\"PILOT\"",$db_link) or die(mysql_error()); } } } ?> <? mysql_close($db_link); ?> |