query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } //GET LAST PROFILE ID IN PREPARATION TO ENTRY $pro = "SELECT * FROM user_profile WHERE deleted = 0 ORDER BY id DESC LIMIT 1"; $qpro = mysqli_query($conn,$pro); while($pr = mysqli_fetch_array($qpro)){ $proID = $pr['id']; } //Scan All Modules and create Entry with default value or ZERO '0' or DENIED ACCESS $mod = "SELECT * FROM user_modules WHERE deleted = 0"; $qmod = mysqli_query($conn,$mod); while($md = mysqli_fetch_array($qmod)){ $moduleID = $md['id']; //insert to user_profile_data with 0 value $sqlMod = "INSERT INTO user_profile_data (`id`, `profile_id`,`module_id`, `can_view`, `can_add`, `can_edit`, `can_delete`) VALUES ('', '$proID', '$moduleID', '0', '0', '0', '0')"; if ($conn->query($sqlMod) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $aRole = "SELECT * FROM `user_profile` WHERE `deleted`=0 ORDER BY `profile_name` ASC"; $qRole = mysqli_query($conn,$aRole); while($row = mysqli_fetch_array($qRole)){ ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

ID	PROFILE NAME	PROFILE DESCRIPTION
".$row['profile_name']."	".$row['profile_description']."

"; $conn->close(); } ?>