[+] EDITØR MODE [+]
htdocs
>
web
>
chi_siamo.php
Edit File: chi_siamo.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); } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"><!-- Begin Cookie Consent plugin by Silktide - http://silktide.com/cookieconsent --> <script type="text/javascript"> window.cookieconsent_options = {"message":"Questo sito utilizza cookie di terze parti. Chiudendo questo banner, scorrendo questa pagina, cliccando su un link o proseguendo la navigazione in altra maniera, acconsenti all'uso dei cookie.","dismiss":"Accetta","learnMore":"Maggiori informazioni","link":"http://fontana-architetti.it/crediti.php","theme":"dark-top"}; </script> <script type="text/javascript" src="//s3.amazonaws.com/cc.silktide.com/cookieconsent.latest.min.js"></script> <!-- End Cookie Consent plugin --> <!-- ------------------------------------------------META------------------------------------------------ --> <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"> <!-- ------------------------------------------------CSS------------------------------------------------ --> <link rel="Stylesheet" href="css/home.css" /> <link rel="Stylesheet" href="css/menu.css" /> <link rel="stylesheet" type="text/css" href="css/cookieBar.css"> </head> <body> <div id='root'> <div class='box_l' id='top_bar'> <div class='box_r' id='cerca'></div> </div> <div id='titoli'> <div id="head_l"> <div id="head_l_text"><h2><?php echo $lang['CHISIAMO_HEADER']; ?></h2></div> </div> <a href="index.php"><div id="cer"> </div></a> <a href="index.php"><div id="dietro"><h3>BACK</h3></div></a> <div id="head_r"><a href="index.php"><img src="img/logo_small.jpg" class="r"></a></div> </div> <div style="clear: both"></div> <div id="cont_lungo"> <div id='testo'> <?php //testo presentazione $sql4 = 'SELECT * FROM testi WHERE pagina = "chisiamo"'; $result4 = $conn->query($sql4); if ($result4->num_rows > 0) { while($row = $result4->fetch_assoc()) { echo '<p class="giust">'.strip_tags($row["testo_".$lang["LANG"]], "<b><strong><i><em>").'</p>'; //echo '<p class="giust">'.$row["testo_".$lang["LANG"]].'</p>'; } } ?></div> <div id='barra_dx'> <?php $sql = 'SELECT * FROM staff WHERE ruolo = "1"'; //Prende nomi capi $sql2 = 'SELECT * FROM staff WHERE ruolo = "2"'; //Prende nomi staff $result = $conn->query($sql); $result2 = $conn->query($sql2); //Posta nomi capi if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo '<ul class="pers"> <li class="pers"><a href="bio.php?id='.$row['id'].'">' .$row['nome'].' '.$row["cognome"].'</a></li>'; } } echo '<li class="staff">STAFF</li>'; //Posta nomi staff if ($result2->num_rows > 0) { while($row = $result2->fetch_assoc()) { echo '<li class="pers"><a href="bio.php?id='.$row['id'].'">' .$row['nome'].' '.$row["cognome"].'</a></li>'; } } ?> </ul> </div> </div> <div style="clear: both"></div> <?php //prende collaboratori e li ordina per cognome grassettando gli assunti $sql3 = 'SELECT * FROM staff WHERE ruolo = "3" OR ruolo = "4" ORDER BY cognome ASC'; $result3 = $conn->query($sql3); echo '<div id="cont_lungo_basso"><b>'.$lang['CHISIAMO_COLLABORATORI'].'</b>:<br/> '; if ($result3->num_rows > 0) { while($row = $result3->fetch_assoc()) { //echo $row['nome']; if($row["ruolo"]=="3"){ $array[] = '<span style="font-weight:bold">'.$row["nome"].' '.$row["cognome"].'</span>'; }else{ $array[] = $row["nome"].' '.$row["cognome"]; } /*print "<pre>"; print_r($virgola); print "</pre>";*/ } echo implode(", ", $array); } $conn->close(); ?> </div> <div id='menu'> <ul> <li><a href="chi_siamo.php"><?php echo $lang['MENU_CHISIAMO']; ?></a></li> <li><a href="progetti.php"><?php echo $lang['MENU_PROGETTI']; ?></a></li> <li><a href="concorsi.php"><?php echo $lang['MENU_CONCORSI']; ?></a></li> <li><a href="pubblicazioni.php"><?php echo $lang['MENU_PUBBLICAZIONI']; ?></a></li> <li><a href="episodi.php"><?php echo $lang['MENU_EPISODI']; ?></a></li> <li><a href="clienti.php"><?php echo $lang['MENU_CLIENTI']; ?></a></li> <li><a href="contatti.php"><?php echo $lang['MENU_CONTATTI']; ?></a></li> <li><a href="crediti.php"><?php echo $lang['MENU_CREDITI']; ?></a></li> </ul> </div> </div> </body> </html>
Method:
fopen()
file_put_contents()
stream_context_create()
Simpan
Rename:
Rename