Pasted

<?php
 
    require 'dbconfig.php';
 
    if(isset($_GET['newcontact']) && isset($_GET['newphone']) && isset($_GET['userid'])) {
        $query = $conn->prepare("INSERT INTO contacts (contact, phone, createdbyuserid) VALUES (:newcontact, :newphone, :userid)");
        $query->bindValue(':newcontact', $_GET['newcontact']);
        $query->bindValue(':newphone', $_GET['newphone']);
        $query->bindValue(':userid', $_GET['userid']);
        $query->execute();
        $query->closeCursor();
 
        if(isset($_GET['neworganization'])) {
            $query = $conn->prepare("UPDATE contacts SET organization = :organization WHERE phone = :phone");
            $query->bindValue(':organization', $_GET['neworganization']);
            $query->bindValue(':phone', $_GET['newphone']);
            $query->execute();
            $query->closeCursor();
        }
        if(isset($_GET['newrelationship'])) {
            $query = $conn->prepare("UPDATE contacts SET relationship = :relationship WHERE phone = :phone");
            $query->bindValue(':relationship', $_GET['newrelationship']);
            $query->bindValue(':phone', $_GET['newphone']);
            $query->execute();
            $query->closeCursor();
        }
        if(isset($_GET['newaddress'])) {
            $query = $conn->prepare("UPDATE contacts SET address = :address WHERE phone = :phone");
            $query->bindValue(':address', $_GET['newaddress']);
            $query->bindValue(':phone', $_GET['newphone']);
            $query->execute();
            $query->closeCursor();
        }
        if(isset($_GET['newgroup'])) {
            $query = $conn->prepare("INSERT INTO groups (createdbyuserid, groupname) VALUES (:userid, :groupname)");
            $query->bindValue(':userid', $_GET['userid']);
            $query->bindValue(':groupname', $_GET['groupname'])
            $query->execute();
            $query->closeCursor();
 
            $query = $conn->prepare("UPDATE contacts SET contacts.groupid = (SELECT groupid FROM groups WHERE groupname = :groupname) and phone = :phone");
            $query->bindValue(':groupname', $_GET['groupname']);
            $query->bindValue(':phone', $_GET['newphone']);
            $query->execute();
            $results = $query->fetchAll(PDO::FETCH_ASSOC);
            $query->closeCursor();
        }
 
    }
 
?>