1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| <?php
if(isset($_POST['Project'])){
if ( isset($_POST['Archived']) ){
$Archive=1; //checked
}
else{
$Archive=0; //not checked
}
mysql_connect("localhost","root","votremotdepasse");
mysql_select_db("votredatabase");
$query='UPDATE project p, prgmgr prg, prjmgr prj, busorg b, rdorg ro, customer c, platform pt
SET p.Name="'.$_POST['ProjectName'].'",
p.PrgMgrID="'.$_POST['ProgramManager'].'",
p.PrjMgrID="'.$_POST['ProjectManager'].'",
p.BusOrgID="'.$_POST['BusOrg'].'",
p.RDOrgID="'.$_POST['RDOrg'].'",
p.CustomerID="'.$_POST['Customer'].'",
p.PlatformID="'.$_POST['Platform'].'",
p.Type="'.$_POST['Type'].'",
p.Archived="'.$Archive.'"
WHERE p.ProjectID="'.$_POST['Project'].'"';
mysql_query($query);
$query='DELETE FROM siteprj WHERE ProjectID="'.$_POST['Project'].'"';
mysql_query($query);
$query='INSERT INTO siteprj VALUES("'.$_POST['RDSite'].'","'.$_POST['Project'].'");';
mysql_query($query);
}
?> |
Partager