Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_POST['projecttoevoegen'])){
- $deadline = $connectie->real_escape_string($_POST['deadline']);
- $start = $connectie->real_escape_string($_POST['startdate']);
- if($deadline >= date("Y-m-d",time()) && $deadline >= $start){
- $naam = $connectie->real_escape_string($_POST['projectname']);
- $mainid= $connectie->real_escape_string($_POST['mainid']);
- $project_eigenaarsql= $connectie->query("SELECT * FROM userproject WHERE projectid = $mainid AND roleid= 1");
- $project_deelnemersql = $connectie->query("SELECT * FROM userproject WHERE projectid = $mainid AND roleid= 2");
- $sqlproject= "INSERT INTO projects (mainprojectid,name,startdate,enddate) VALUES ($mainid,'".$naam."','$start', '$deadline')";
- if ($connectie->query($sqlproject) === TRUE) {
- $new_project_id = $connectie->insert_id;
- while ($project_eigenaar = $project_eigenaarsql->fetch_assoc()) {
- $project_eigenaar_id = $project_eigenaar['userid'];
- $eigenaar_sql ="INSERT INTO userproject (userid, projectid, roleid) VALUES ($project_eigenaar_id,$new_project_id,1)";
- $connectie->query($eigenaar_sql);
- }
- while ($project_deelnemer = $project_deelnemersql->fetch_assoc()) {
- $project_deelnemer_id = $project_deelnemer['userid'];
- $deelnemer_sql ="INSERT INTO userproject (userid, projectid, roleid) VALUES ($project_deelnemer_id,$new_project_id,2)";
- $connectie->query($deelnemer_sql);
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement