<?php

// Crea file .zip di una cartella specifica

$path="sito_web/"; //percorso della cartella server (Indicare il percorso della cartella che contiene i file da comprimere)
$filename = "beckup.zip"; //nome del file .zip archivio

$x=0;
if ($handle = opendir($path)) {
    while (false !== ($arrayfile = readdir($handle))) {
	if( $arrayfile != '.' and $arrayfile != '..'){
		$array_all_file[$x]=$path.$arrayfile; //elenco dei file e cartelle
		$x++;
	}
    }
    closedir($handle);
} 

//richiamo fondamentale della libreria PclZip
require_once('pclzip.lib.php');

$archive = new PclZip($filename); 

//Una lista di nomi di files da comprimere 
$listOfFilesToCompress=implode(",",$array_all_file); 

//Aggiungo i files all'archivio 
$v_list = $archive->create($listOfFilesToCompress); 
if ($v_list == 0) { 
die("Error : ".$archive->errorInfo(true)); 
}

 echo "Archivio \"beckup.zip\" creato con successo.";

?>

<?php

//richiamo fondamentale della libreria PclZip
require_once('pclzip.lib.php');

  $file_zip = new PclZip('beckup.zip');
  $v_list = $file_zip->create('cartella, file.php, file.html');
  if ($v_list == 0) {
    die("Errore : ".$archive->errorInfo(true));
  }
  echo "Archivio \"beckup.zip\" creato con successo.";
?>

<?php

//decomprimere il file zip

//richiamo fondamentale della libreria PclZip
require_once('pclzip.lib.php');

$filename="beckup.zip";//inserire il percorso e il nome esatto del file .zip 
$archive = new PclZip($filename); 
if ($archive->extract() == 0) {
    die("Errore: ".$archive->errorInfo(true));  
}

echo "Estratti i file con sucesso";
?>

if ($archive->extract() == 0) {

if ($archive->extract(PCLZIP_OPT_PATH, 'newdir/') == 0)  //newdir è il nome della cartella da creare e dove verranno messi i file scompattati/estratti

<?php
//decomprimere il file zip

//richiamo fondamentale della libreria PclZip
require_once('pclzip.lib.php');

$filename="beckup.zip";//inserire il percorso e il nome esatto del file .zip 
$archive = new PclZip($filename); 
if ($archive->extract(PCLZIP_OPT_PATH, 'newdir/') == 0) {
    die("Errore: ".$archive->errorInfo(true));  
}

echo "Estratti i file con sucesso";
?>

[PHP]
post_max_size = 100M 
upload_max_filesize = 100M 
safe_mode = Off
enable_dl = On

<?php

set_time_limit(350);

//Percorso file remoto
$remotefile="http://imaginsystems.it/view_excel.rar";

//Cartella locale in cui copiare il file
$cartella="Download/"; 

//apro il file remoto da leggere
$srcfile1 = fopen("$remotefile", "r");

//prelevo il nome del file
$nomefile=basename($remotefile);

//apro il file in locale
if (!($fp1 = fopen($cartella.$nomefile,"w")));

//scrivo contenuto del file remoto, ora in temp file, in file locale
while ($contents = fread( $srcfile1, 8192 )) {
	fwrite( $fp1, $contents, strlen($contents) );
}

//chiudo i due files
fclose($srcfile1);
fclose($fp1);
?>

require_once 'Spreadsheet/Excel/Reader/OLERead.php';

require_once 'OLERead.php';

<?php

require_once 'Excel/reader.php';

$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251'); // Set output Encoding.
$data->read('test.xls'); //test.xls è un file demo di excel per il test
error_reporting(E_ALL ^ E_NOTICE);

echo "<table border='1'>";
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
        echo "<tr>";
	for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
		echo "<td>".$data->sheets[0]['cells'][$i][$j]."</td>";
	}
	echo "</tr>";

}
echo "</table>";
?>

	/**
	 * document creator
	 */
	define ('PDF_CREATOR', 'TCPDF');

	/**
	 * document author
	 */
	define ('PDF_AUTHOR', 'TCPDF');

	/**
	 * header title
	 */
	define ('PDF_HEADER_TITLE', 'TCPDF Example');

	/**
	 * header description string
	 */
	define ('PDF_HEADER_STRING', "by Nicola Asuni - Tecnick.com\nwww.tcpdf.org");

	/**
	 * image logo
	 */
	define ('PDF_HEADER_LOGO', 'tcpdf_logo.jpg');

	/**
	 * document creator
	 */
	define ('PDF_CREATOR', 'Davide86');

	/**
	 * document author
	 */
	define ('PDF_AUTHOR', 'Davide86');

	/**
	 * header title
	 */
	define ('PDF_HEADER_TITLE', 'Imaginsystems');

	/**
	 * header description string
	 */
	define ('PDF_HEADER_STRING', "by Davide86 - Imaginsystems.it\nwww.imaginsystems.it");

	/**
	 * image logo 
	 */
	define ('PDF_HEADER_LOGO', 'logo.jpg'); //Ricordati di salvare il file immagine nella cartella "images"

<?php
//============================================================+
// File name   : example065.php 
// Begin       : 2011-09-28
// Last Update : 2011-09-28
//
// Description : Example 065 for TCPDF class
//               Default Header and Footer
//
// Author: Nicola Asuni
//
// (c) Copyright:
//               Nicola Asuni
//               Tecnick.com s.r.l.
//               Via Della Pace, 11
//               09044 Quartucciu (CA)
//               ITALY
//               www.tecnick.com
//               info@tecnick.com
//============================================================+

/**
 * Creates an example PDF/A-1b document using TCPDF
 * @package com.tecnick.tcpdf
 * @abstract TCPDF - Example: PDF/A-1b mode
 * @author Nicola Asuni
 * @since 2011-09-28
 */

require_once('config/lang/eng.php');
require_once('tcpdf.php');

// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false, true);

// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('TCPDF Example 065');
$pdf->SetSubject('TCPDF Tutorial');
$pdf->SetKeywords('TCPDF, PDF, example, test, guide');

// set default header data
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 065', PDF_HEADER_STRING);

// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

//set some language-dependent strings
$pdf->setLanguageArray($l);

// ---------------------------------------------------------

// set default font subsetting mode
$pdf->setFontSubsetting(true);

// Set font
$pdf->SetFont('helvetica', '', 14, '', true);

// Add a page
// This method has several options, check the source code documentation for more information.
$pdf->AddPage();

// Set some content to print
$html = <<<EOD
<h1>Esempio Creazione File PDF </h1>
<br>
<p> by Davide86 <a href="http://www.imaginsystems.it" style="text-decoration:none;background-color:#CC0000;color:black;">Imaginsystems.it</a> 
</p>
<i>Questo documento è conforme allo standard <b>PDF/A-1b (ISO 19005-1:2005)</b>.</i>
<br><br>Inserisco qui il codice HTML <br>
EOD;

// Print text using writeHTMLCell()
$pdf->writeHTMLCell(0, 0, '', '', $html, 0, 1, 0, true, '', true);

// ---------------------------------------------------------

// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$pdf->Output('creapdf_temp.pdf', 'I');

//============================================================+
// END OF FILE
//============================================================+

?>

<?php
define('FFMPEG_LIBRARY', '/usr/bin/ffmpeg'); 
?>

<?php
define('FFMPEG_LIBRARY', '/usr/bin/ffmpeg'); 

$input = "upload/video/test.avi"; //percorso dove leggere il file .avi
$estenzione = ".mp4"; //estenzione file qui cambiate come volete .mp4, ogg, flv, mpeg, m4v ec..
$nome_file = "Test"; //Nome del File da salvare
$output = "upload/video/"; //percorso cartella destinazione

$salva = $output . $nome_file . $estenzione;

$risultato_conversione = Converti_video($input,$salva);
if($risultato_conversione == "TRUE"){ echo "Convertito con sucesso";}else{ echo "Errore conversione";}

function Converti_video($percorso_file,$destinazione){
	$boolean = "FALSE";
   $exec_string = FFMPEG_LIBRARY.' -i ' . $percorso_file . ' -an ' . $destinazione; 
   exec($exec_string); //commando di shell php 
  return $boolean = "TRUE";
}
?>

<?php

$input = "upload/video/test.avi"; //percorso dove leggere il file .avi
$estenzione = ".m4v"; //estenzione file qui cambiate come volete .mp4, ogg, flv, mpeg, m4v ec..
$nome_file = "Test"; //Nome del File da salvare
$output = "upload/video/"; //percorso cartella destinazione

$salva = $output . $nome_file . $estenzione;

$risultato_conversione = Converti_File_AVI_to_M4V($input,$salva);
if($risultato_conversione == "TRUE"){ echo "Convertito con sucesso";}else{ echo "Errore conversione";}

function Converti_File_AVI_to_M4V($file_name,$destinazione){
$boolean = "FALSE";

$extension = "ffmpeg";
$extension_soname = $extension . "." . PHP_SHLIB_SUFFIX;
$extension_fullname = PHP_EXTENSION_DIR . "/" . $extension_soname;

// load extension
if(!extension_loaded($extension))
{ 
   dl($extension_soname) or die("Can't load extension $extension_fullname\n");
}

// Set our source file 
$srcFile = $file_name; 
$destFile = $destinazione; 

$ffmpegPath = "/usr/bin/ffmpeg"; 

 // Call our convert using exec() 
exec($ffmpegPath ." -i " .  $srcFile . " ". $destFile);
//echo $ffmpegPath ." -i " .  $srcFile . " -ar "  . $destFile;
$boolean = "TRUE";
return $boolean;
}
?>

<?php
$video_file = "upload/video/test.avi";

$Array_Video = Durata_Video($video_file); // così facendo scrive i valori e poi li salva nella variabile Array_Video
$durata = $Array_Video['durata'];
$altezza = $Array_Video['h'];
$larghezza = $Array_Video['w']; 

function Durata_Video($video_file){

$extension = "ffmpeg";
$extension_soname = $extension . "." . PHP_SHLIB_SUFFIX;
$extension_fullname = PHP_EXTENSION_DIR . "/" . $extension_soname;

// load extension
if(!extension_loaded($extension))
{ 
   dl($extension_soname) or die("Can't load extension $extension_fullname\n");
}

//$file = "robot.avi";
$file = $video_file;

$frame = 150;
$max_width = 400; 

$movie = new ffmpeg_movie($file);

echo "Durata Video: ";
echo "<b>".gmdate("H:i:s",$movie->getDuration())."</b><br />"; 
echo "Grandezza: ";
echo "<b>".$movie->getFrameWidth()." x ".$movie->getFrameHeight()."</b>"; 

$valore['durata'] = gmdate("H:i:s",$movie->getDuration());
$valore['w'] = $movie->getFrameWidth();
$valore['h'] = $movie->getFrameHeight();

return $valore;
}
?>

<?php
$video_file = "upload/video/test.avi";
$destinazione_jpg = "upload/video/test.jpg";

$risultato_cattura_img = Crea_Immagine_Anteprima_Video($video_file, $destinazione_jpg);
if($risultato_cattura_img == "TRUE"){ echo "creato file .jpg";}else{ echo "errore file non salvato";}

function Crea_Immagine_Anteprima_Video($video_file, $destinazione_jpg){
	$boolean = "FALSE";
	
$extension = "ffmpeg";
$extension_soname = $extension . "." . PHP_SHLIB_SUFFIX;
$extension_fullname = PHP_EXTENSION_DIR . "/" . $extension_soname;

// load extension
if(!extension_loaded($extension))
{ 
   dl($extension_soname) or die("Can't load extension $extension_fullname\n");
}

//$file = "ffmpeg1/tests/test_media/robot.avi";
$file = $video_file;

$frame = 2;
$max_width = 400; 

$movie = new ffmpeg_movie($file);

$image = $movie->getFrame($frame);
$show_img = $image->toGDImage(); 

$new_image = new ffmpeg_frame($show_img);

$old_width = $new_image->getWidth();
$old_heighgt = $new_image->getHeight();

$mov_ratio = $old_width/$old_heighgt;
if($old_width > $max_width){
$new_width = $max_width;
}

//$new_height = $new_width / $mov_ratio;
//$new_image->resize($new_width, $new_height);
$new_image->resize(300, 300);
$new_show_img = $new_image->toGDImage(); 

//header("Content-type: image/jpeg");
 imagejpeg($new_show_img,$destinazione_jpg);
 imagedestroy($new_show_img); 
  $boolean = "TRUE";

return $boolean;
}
?>

  Set conn = CreateObject("ADODB.Connection")
    
    'Inizializza le variabili
    mysql_host = "server6.hostservicenet.com"
    mysql_userid = "username"
    mysql_password = "password"
    mysql_database = "username_test"
    mysql_port = "3306"


    'Crea la stringa di connessione
    connect_string = "Provider=MySqlProv;Data Source=" & Chr(34) & "server=" & mysql_host & ";DB=" & mysql_database & ";User=" & mysql_userid & ";Password=" & mysql_password & ";Option=131088; Stmt=;Port=" & mysql_port & "" & Chr(34)
    conn.Provider = "MySqlProv"
    conn.ConnectionString = connect_string
    conn.CommandTimeout = 1000
    conn.ConnectionTimeout = 1000 'Tempo in mS prima che il tentativo di connessione vada in TimeOut
    conn.CursorLocation = adUseServer

Public Sub do_connect()
   On Error GoTo Connect_Error
    
    If Not (conn.State = adStateOpen) Then
        'Evita la comparsa della finestra POPUP del provider di MySQL
        conn.Properties("PROMPT") = adPromptNever
        conn.Open 'Instaura la connessione con il Database
        Debug.Print "Connessione con il server MySQL riuscita"
    End If
    Exit Sub
    
Connect_Error:
    MsgBox "Connessione con il server MySQL " & mysql_host & " fallita", vbCritical, "Attenzione"
    
End Sub

'Termina la connessione con il server MySQL
Public Sub do_disconnect()
    If conn.State = adStateOpen Then 'Esegue solo se si connessi
        conn.Close 'Chiude la connessione con MySQL
        Debug.Print "Disconnessione da MySQL riuscita"
    End If
End Sub