0) { /* fetch associative array */ while ($data = mysqli_fetch_object($result)) { $user_name = $data->usr_name; $user_fullname = $data->usr_fullname; $user_permission = $data->usr_permission; $user_email = $data->usr_email; } } else { $user_name = ''; $user_fullname = ''; $user_permission = 0; $grp_id = 0; $grp_name = ''; } mysqli_free_result($result); if ($usr_id > 0) { $sql = "SELECT grp.grp_name, grp.grp_id FROM grp, usr_grp "; $sql .= "WHERE grp.grp_id = usr_grp.grp_id AND usr_grp.usr_id = $usr_id"; if ($result = mysqli_query($db, $sql)) { $num_rows = mysqli_num_rows($result); if ($num_rows > 0) { /* fetch associative array */ while ($data = mysqli_fetch_object($result)) { $grp_id = $data->grp_id; $grp_name = $data->grp_name; } } else { $grp_id = 0; $grp_name = ''; } mysqli_free_result($result); } else { $grp_id = 0; $grp_name = ''; } } else { $grp_id = 0; $grp_name = ''; } } else { $user_name = ''; $user_fullname = ''; $user_permission = 0; $grp_id = 0; $grp_name = ''; } } else { $user_name = ''; $user_fullname = ''; $user_permission = 0; $grp_id = 0; $grp_name = ''; } $html = chr(0x0D).chr(0x0A); if(isset($_GET['method'])) { $method = $_GET['method']; } else { $method = 'view'; } if ($method == 'save') { $pag_title = addslashes($_GET['pag_title']); $pag_descr = addslashes($_POST['pag_descr']); $sql = "UPDATE pages SET pag_descr = '$pag_descr', pag_date = CURDATE(), pag_time = CURTIME(), usr_id = $usr_id WHERE pag_title = '$pag_title'"; if (mysqli_query($db, $sql) <> TRUE) { $html = '
Probeer het later nog eens of neem contact op met de beheerder.
'.chr(0x0D).chr(0x0A); } } else { if ($method == 'edit'){ if (isset($_GET['pag_title'])) { $pag_title = $_GET['pag_title']; $sql = "SELECT * FROM pages "; $sql .= "WHERE pag_title = '$pag_title'"; if ($result = mysqli_query($db, $sql)) { $num_rows = mysqli_num_rows($result); if ($num_rows > 0) { /* fetch associative array */ while ($data = mysqli_fetch_object($result)) { $pag_id = $data->pag_id; $pag_descr = stripslashes($data->pag_descr); } } else { $pag_id = 0; $pag_descr = ''; } mysqli_free_result($result); } else { $pag_id = 0; $pag_descr = ''; } } $html .= ''.chr(0x0D).chr(0x0A); } else { $html .= 'Probeer het later nog eens of neem contact op met de beheerder.
'.chr(0x0D).chr(0x0A); } } if($pag_title == 'Home' && $method == 'save') { echo ""; die; } ?>