PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- $host = '127.0.0.1';
- $db = 'gigal';
- $user = 'root';
- $pass = '';
- $charset = 'utf8';
- $objectId = '';
- $image = '';
- $row = '';
- $id = '';
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- $pdo = new PDO($dsn, $user, $pass, $opt);
- $stmt = $pdo->query('SELECT * FROM id_images');
- /* TODO
- header("Content-Type: image/jpeg");
- */
- $number_catalog = 1;
- while ($row = $stmt->fetch(PDO::FETCH_LAZY))
- {
- $row_object = $row['objectId'];
- $row_image = $row['image'];
- $id_image = $row['id'];
- $type_image = $row['ext'];
- //Начало сортировки тут затык!
- if($count_dir = 0 && count_dir = 100) {
- $strukture = "../uploads/image/{$number_catalog}/";
- $path = $strukture.$row_object;
- file_put_contents("../uploads/image/{$number_catalog}/{$row_object}/{$id_image}.{$type_image}", $row_image);
- } elseif ($count_dir = 101) {
- $number_catalog++;
- file_put_contents("../uploads/image/{$number_catalog}/{$row_object}/{$id_image}.{$type_image}", $row_image);
- }
- }
- ?>