[+] EDITÃ˜R MODE [+]

htdocs > public > www > admin_staffedit.php

Edit File: admin_staffedit.php

<?php
define('DB_SERVER', 'hostingmysql323.register.it');
define('DB_USERNAME', 'gregorio');
define('DB_PASSWORD', 'fontana2015');
define('DB_DATABASE', 'fontanaarchitetti');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
session_start();
$user_check=$_SESSION['login_user'];

$ses_sql=mysqli_query($db,"select username from members where username='$user_check' ");

$row=mysqli_fetch_array($ses_sql,MYSQLI_ASSOC);

$login_session=$row['username'];

if(!isset($login_session))
{
header("Location: admin.php");
}
?>

<?php
include_once 'common.php';

$servername = "hostingmysql323.register.it";
$username = "gregorio";
$password = "fontana2015";
$dbname = "fontanaarchitetti";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
} 
?>
<html>
<head>

        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta http-equiv="cache-control" content="max-age=0">
		<meta http-equiv="cache-control" content="no-cache">
    	<meta http-equiv="expires" content="0">
		<meta http-equiv="expires" content="Tue, 01 Jan 1980 1:00:00 GMT">
		<meta http-equiv="pragma" content="no-cache">
  <meta charset="UTF-8">
  <title>Fontana Architetti - Amministrazione</title>
    <link rel="stylesheet" href="css/style.css" media="screen" type="text/css" />
     <script src="./ckeditor/ckeditor.js"></script>	
          <script type="text/javascript">
	window.onload = function()
	{
		CKEDITOR.replace( 'bio_IT' );
		CKEDITOR.replace( 'bio_EN' );
	};
	
</script>
    
</head>
<body>
<?php

echo '<a href="admin_index.php"><div id="header"> <h1> Fontana Architetti - Amministrazione</h1></div></a>

<div id="sottoheader">
		<div class="back"><a href="admin_index.php?p=1"><img src="img/admin/back.jpg"></a></div>
 		<div class="tit"><h1>Modifica persona</h1></div>
 		
 	</div>';

if($_GET["load"] === "yes") echo '<div id="load"><h1>Caricamento avvenuto con successo</h1></div>';
if($_GET["load"] === "no") echo '<div id="errorl"><h1>ERRORE!</h1></div>';

/*if (empty($_GET["load"])) {
	echo '<div id="info"><h1>ATTENZIONE: tutti i campi sono obbligatori!</h1></div>';
};*/
$idz = $_GET['id'];
$sql = 'SELECT * FROM staff WHERE id="'.$idz.'"';
										$result = $conn->query($sql);
									
     								//Posta nomi capi
									if ($result->num_rows > 0) {
												while($row = $result->fetch_assoc()) {
													$nome_v = $row['nome'];
													$cognome_v = $row['cognome'];
													$ruolo_v = $row['ruolo'];
											    	$bioit_v =  $row['bio_IT'];
													$bioen_v = $row['bio_EN'];
																	} 
															} 
															
?>
<div id="blocco">	   
		<form action="PHP_script/loader_bio.php" method="post">
		<div class="insert">
    	<h2>Modifica bio di <?php echo  $nome_v.' '.$cognome_v; ?></h2>
        <input type="hidden" name="id_el" id="id_el" value="<?php echo  $idz; ?>">
		</div>
    	<div class="insert">
    	<label for="bio_IT">Biografia italiano (solo per Boss e Staff)</label>
		<textarea name="bio_IT" id="bio_IT"> <?php echo  $bioit_v; ?>' </textarea>
 		</div>
    	<div class="insert">
    	<label for="bio_EN">Biografia inglese (solo per Boss e Staff)</label>
    	<textarea name="bio_EN" id="bio_EN"> <?php echo  $bioen_v; ?>' </textarea>
		</div>
        <div class="insert">
		<label for="ruoloz">Ruolo</label> 
   	 	<select name="ruoloz" id="ruoloz">
    		<option value="1" <?php if ($ruolo_v  == "1" ) echo 'selected'; ?>>Boss</option>
  			<option value="2" <?php if ($ruolo_v  == "2" ) echo 'selected'; ?>>Staff</option>
  			<option value="3" <?php if ($ruolo_v  == "3" ) echo 'selected'; ?>>Collaboratore assunto</option>
  			<option value="4" <?php if ($ruolo_v  == "4" ) echo 'selected'; ?>>Collaboratore stagista</option>
		</select>
    	</div>
		<input type="submit"  id="register"   value="Modifica bio"> 
        </form>

</div>

</body>
</html>

Method: