Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <head>
- <meta http-equiv="Refresh" content="20">
- </head>
- <?
- $startScan = microtime(true);
- //TU DODAJE PARAMETRY DO BAZY MAZOVII
- $dbhost = '58915.m.tld.pl';
- $database = 'baza58915_wynik';
- $dbusername = 'admin58915_wynik';
- $dbpassword = 'pj3U060H';
- //TU DODAJE POLACZENIE Z FTP - MOŻE SIĘ NIE ZJEBIE
- $ftp_server = '94.152.132.115';
- $ftp_user_name = 'mazovia_ftp';
- $ftp_user_pass = 'mazovia';
- // set up basic connection
- $conn_id = ftp_connect($ftp_server);
- // login with username and password
- $login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);
- // get contents of the current directory
- $files = ftp_nlist($conn_id, "./sts_foto/upload_photo");
- $dont_index_last_files = 4; // nie indexuj ostatnich 4 plikow bo moga nie byc zaladowane do konca
- try {
- $db = new PDO('mysql:host='.$dbhost.';charset=utf8;dbname='.$database, $dbusername, $dbpassword);
- }
- catch (PDOException $e)
- {
- print "Błąd połączenia z bazą!: " . $e->getMessage() . "<br/>";
- die();
- }
- $db->exec("set names utf8");
- echo 'Indeksuję zdjęcia:<br><br>';
- $stamp = imagecreatefrompng('images/TEST.png');
- // get last indexed filename
- $last_file = false;
- $insert_to_db = false;
- $statement = $db->query('SELECT * FROM photo ORDER BY date DESC LIMIT 1');
- foreach($statement as $last)
- {
- $last_file = $last['filename'];
- }
- $statement->closeCursor();
- $array_size = sizeof($files);
- foreach($files as $key=>$filename) {
- // dont index last file might not be uploaded fully
- if(($key+$dont_index_last_files) >= $array_size) continue;
- if($filename != '.' && $filename != '..' && $filename != 'test') {
- //echo $filename.'<br>';
- $filename = basename($filename);
- list($pre,$pre2,$filetime,$post) = explode('_', $filename);
- if($insert_to_db || $last_file == false) {
- $date = DateTime::createFromFormat('YmdHisu', $filetime);
- echo($filetime);
- $filedate = $date->format('Y-m-d H:i:s');
- echo $filetime.' '.$filename.' - '.$filedate.'<br>';
- $stmt = $db->prepare("INSERT INTO photo (date, filename) VALUES (:date, :filename)");
- $stmt->bindValue(':date', $filedate, PDO::PARAM_STR);
- $stmt->bindValue(':filename', $filename, PDO::PARAM_STR);
- $stmt->execute();
- $stmt->closeCursor();
- }
- if($last_file == $filename)
- $insert_to_db = true;
- }
- }
- $endScan = microtime(true);
- echo "Czas indeksowania: " . ($endScan-$startScan) . "<br>";
- //PRZYPISYWANIE ZDJĘĆ DO ZAWODNIKÓW
- $day = '2018-09-23';
- $foto_seconds_add = 0;
- $foto_seconds_substract = 0;
- $foto_seconds = 5;
- $stmt = $db->prepare("SELECT cz_rz_1, numer FROM zawodnik_inne WHERE cz1 > '00:00:00' AND photo1 = ''");
- $stmt->execute();
- if($stmt->rowCount() > 0 ) {
- while($zawodnik = $stmt->fetchObject()){
- $photos = '';
- echo("Przypisywanie zdjec - zawodnik numer: $zawodnik->numer czas $zawodnik->cz_rz_1 <br>");
- $zawodnik_numer = $zawodnik->numer;
- $zawodnik_czas = $zawodnik->cz_rz_1;
- $zawodnik_czas = $day.' '.$zawodnik_czas;
- $zawodnik_czas = new DateTime($zawodnik_czas);
- $zawodnik_czas->add(new DateInterval('PT' . $foto_seconds_add . 'S'));
- $zawodnik_czas->sub(new DateInterval('PT' . $foto_seconds_substract . 'S'));
- $time1 = clone $zawodnik_czas;
- $time2 = clone $zawodnik_czas;
- $time1->add(new DateInterval('PT' . $foto_seconds . 'S'));
- $time2->sub(new DateInterval('PT' . $foto_seconds . 'S'));
- echo $time1->format('Y-m-d H:i:s').'<br>';
- echo $time2->format('Y-m-d H:i:s').'<br>';
- $stmt2 = $db->prepare('SELECT * FROM photo WHERE date BETWEEN :time_from AND :time_to');
- $stmt2->bindValue(':time_from', $time2->format('Y-m-d H:i:s'), PDO::PARAM_STR);
- $stmt2->bindValue(':time_to', $time1->format('Y-m-d H:i:s'), PDO::PARAM_STR);
- $stmt2->execute();
- if($stmt->rowCount() > 0 ) {
- while($obj = $stmt2->fetchObject())
- $photos = $photos.$obj->filename.";";
- }
- $stmt2->closeCursor();
- echo($photos);
- $stmt3 = $db->prepare('UPDATE zawodnik_inne SET photo1 = :photos WHERE numer = :numer');
- $stmt3->bindValue(':photos', $photos ,PDO::PARAM_STR);
- $stmt3->bindValue(':numer', $zawodnik_numer, PDO::PARAM_STR);
- $stmt3->execute();
- $stmt3->closeCursor();
- }
- $stmt->closeCursor();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement