sabato 13 ottobre 2018

LEZIONI DI PHP



SPEDIRE UNA EMAIL

<?php

$mail_destinatario = "destinatario@sito.com";
$mail_oggetto = "Messaggio di prova";
$mail_corpo = "Questo è un messaggio di prova per testare la mia applicazione";

$nome_mittente = "Ulderico";
$mail_mittente = "ulde@hotmail.com";

$mail_headers = "From: " .  $nome_mittente . " <" .  $mail_mittente . ">\r\n";
$mail_headers .= "Reply-To: " .  $mail_mittente . "\r\n";
$mail_headers .= "X-Mailer: PHP/" . phpversion();

if (mail($mail_destinatario, $mail_oggetto, $mail_corpo, $mail_headers))
  echo "Messaggio inviato con successo a " . $mail_destinatario;
else
  echo "Errore. Nessun messaggio inviato.";
?>

---------------------------------------------------------------------------------------------------------------

TORNA ALLA PAGINA PRECEDENTE


if($folder == '')

{
            echo "<script>javascript:history.go(-1)</script>";
            exit;
}


---------------------------------------------------------------------------------------------------------------

ON CLICK CAMBIA IMMAGINE


<input name=\"uploaded\" type=\"file\" size=\"50\" /><br><br>

<input type=\"submit\" value=\"Upload\" onclick=\"document.images[0].src='../images/loading.gif';\" />


---------------------------------------------------------------------------------------------------------------

SCRIPT ALERT


echo "<script>alert('FOTO ELIMINATA.')</script>";



---------------------------------------------------------------------------------------------------------------

PHP IN HTML


<img border="0" src="<?php echo $cartella; ?>" height="344"></td>


---------------------------------------------------------------------------------------------------------------
CONTA I FILE DI UNA CARTELLA

$codice = ‘48’;
$i = 0;
$dir = 'images/' . $codice . '/';
if ($handle = opendir($dir))
{
        while (($file = readdir($handle)) !== false)
        {
         if (!in_array($file, array('.', '..')) && !is_dir($dir.$file))
         $i++;
        }
 }

---------------------------------------------------------------------------------------------------------------
CONTROLLO CAMPI VUOTI IN FORM

<form name="modulo" id="modulo" method="POST"  onSubmit="return controllo();" action="file.php">

<script language="JavaScript">
 function controllo()
{
            with(document.modulo)
            {
                        if(cognome.value=="")
{
                        alert("Errore: compilare il campo COGNOME");
                        cognome.focus();
                        return false;
                        }

                        if(nome.value=="")
                        {
                        alert("Errore: compilare il campo NOME");
                        nome.focus();
                        return false;
                        }

                        if(cellulare.value=="")
{
                        alert("Errore: compilare il campo CELLULARE");
                        cellulare.focus();
                        return false;
                        }
            }
}
 </script>

---------------------------------------------------------------------------------------------------------------
PRENDE VARIABILE DA FORM PRECEDENTE

$vende = ($_POST['tex_vende']);

---------------------------------------------------------------------------------------------------------------
CONDIZIONI IF

$r = (1 == $v) ? 'Yes' : 'No';
            \\NUMERICO SUPERIORE A 0
            $r = ($ripostiglio3 > 0) ?  ',' . $ripostiglio3 . 'Ripostiglio' . ',' : '';
            $Note4 = $Note4 . $r;
            \\UGUALE
$r = ($ingresso3 = 'si') ? 'Ingresso, ' : '';
            $Note4 = $Note4 . $r;
            \\ NUMERICO INFERIORE A 1
$r = (1 > $riscaldamento3) ? 'Riscaldamento' . ' ' . $riscaldamento3 . ', ' : '';
            $Note4 = $Note4 . $r;
  

---------------------------------------------------------------------------------------------------------------

QUERY IN UNA NUOVA FINESTRA


Stampa_rubrica.php

<?php
include 'config.php';

$query = mysql_query("SELECT * FROM clienti ORDER BY cognome");
while($cicle=mysql_fetch_array($query))
{
echo "<tr><td>".$cicle['cognome']."</td>";
echo "<td>".$cicle['nome']."</td>";
echo "<td>".$cicle['via']."</td>";
echo "<td>".$cicle['citta']."</td>";
echo "<td>".$cicle['telcasa']."</td>";
echo "<td>".$cicle['teluff']."</td>";
echo "<td>".$cicle['cellulare']."</td></tr>";
}
?>

Menu.htm
function stampa(){
weblink=window.open("stampa_rubrica.php","STAMPA RUBRICA","width=900,height=500,");
}
// -->
</script>

<a href="javascript:stampa()">
<img border="0" src="../images/menu.h5.jpg"></a>

---------------------------------------------------------------------------------------------------------------
SQL BETWEEN tra valori NUMERICI . STRVAL

$prezzoda = (strval($tex_prezzoda));
AND   prezzo between $prezzoda and $prezzoa

 ---------------------------------------------------------------------------------------------------------------

REGIONI – PROVINCIE – COMUNI



$user = "";
$pass = "";
$server = "localhost";
$conn = mysql_connect($server, $user, $pass);
mysql_select_db('immo', $conn);


$CAMPO1 = $_GET['CAMPO1'];
In cima al file php

<script>
   function valueselect(sel) {
      var value = sel.options[sel.selectedIndex].value;
      window.location.href = "form.php?CAMPO1="+value;
   }
</script>


Nota 2 variabili:
var ciao="hello";
   var mondo="world";
window.location.href ("percorso_pagina_php?var1="+ciao+"&var2="+mondo);

<font face="Times New Roman" size="2"><strong>
    PROVINCIA</font></strong>
    <select id="provincia" onchange="javascript:valueselect(this)" >
            <?php
            echo"<option>$CAMPO1</option>";
            $strSQL = "SELECT * FROM province ORDER by provincia ";
            $result = mysql_query($strSQL, $conn);
            while( $row = mysql_fetch_array($result) )
            {
            $nome_provincia = $row['provincia'];
           
            $selected = $_POST['provincia01'] == $nome_provincia;
            echo "<option " . ($selected ? "selected=\"selected\"" : "") . " value=\"".$nome_provincia."\">".$nome_provincia."</option>";
            }
           
            $strSQL = "SELECT * FROM province WHERE provincia = '$CAMPO1'";
            $result = mysql_query($strSQL, $conn);
            while( $row = mysql_fetch_array($result) )
            {
            $filtro = strval($row['id']);
            }
            ?>                   
            </select>
            <input name="provincia01" value="<?php echo"$CAMPO1"; ?>" type="hidden" size="14">


                        </b></td>
                        </tr>
                       
                        <tr>
                        <td colspan="3">
                        <p style="text-align: left">
                        <font face="Times New Roman" size="2">
            <strong>
            COMUNE </strong>
            <select name="comune01" id="comune01">
                        <option value="">Seleziona la causale</option>
                        <?php

                        $strSQL = ("SELECT * FROM comuni WHERE id_provincia = '$filtro'") ;
                        $result = mysql_query($strSQL, $conn);
                        while( $row = mysql_fetch_array($result) )
                        {
                        $id_comune = $row['id_provincia'];
                        $comune = $row['comune'];
                        echo "<option value=\"".$comune."\">".$comune."</option>";
                        }
            ?>                   
                        </select>



---------------------------------------------------------------------------------------------------------------

PRELOAD IMMAGINI


function not()
{
document.img1.src="../Immagini/3423/3423_1.jpg"
}

function imgOn(imgName) {
if (document.images) {
document.img1.src = imgName;        }}

function FP_swapImg() {//v1.0
 var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length;
 n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm;
 elm.$src=elm.src; elm.src=args[n+1]; } }
}

function FP_preloadImgs() {//v1.0
 var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
 for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image; d.FP_imgs[i].src=a[i]; }
}

function FP_getObjectByID(id,o) {//v1.0
 var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id);
 else if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el;
 if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c)
 for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; }
 f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements;
 for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } }
 return null;
}
</script>

</body>
<body onload="FP_preloadImgs(/*url*/'Immagini/button11.jpg', /*url*/'Immagini/button12.jpg')">
 
<tr>
            <td colspan="2" align="center" valign="top">
            <a href="javascript:not()" onmouseover="imgOn('../Immagini/3423/3423_2.jpg')">
            <img src="../Immagini/3423/3423_2.JPG" alt="" style="border-color: green" border="1" width="84" height="101"></a>
            &nbsp;&nbsp;&nbsp;<a href="javascript:not()" onmouseover="imgOn('../Immagini/3423/3423_1.jpg')">
</td>
</tr>

---------------------------------------------------------------------------------------------------------------
Ceched= si o no

$sauna = ($sauna == 'si') ? $sauna : '%';

---------------------------------------------------------------------------------------------------------------
ONCLICK SUBMIT

onclick="location.href='form.php?submit=Invia'"

---------------------------------------------------------------------------------------------------------------