<?php
$servername = "localhost";
$username = "11229431_cbsklep";
$password = "v,v@LGokE:5j";
$dbname = "11229431_cbsklep";
$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$conn -> query("SET NAMES 'utf8'");

$sql = "SELECT id_image FROM ps_image_lang WHERE legend = 'Zdjecie'";
$result = $conn->query($sql);

$images_id = array();

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $images_id[] = $row['id_image'];
    }
}

$ids = join("','",$images_id);

$sql = "SELECT id_image, id_product FROM ps_image WHERE id_image IN ('$ids')";
$result = $conn->query($sql);

$out = array();

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $out[] = $row;
    }
}

$save = array();

foreach( $out as $single ) {
    $pid = $single['id_product'];
    $imid = $single['id_image'];
    $sql = "SELECT name FROM ps_product_lang WHERE id_product = $pid";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            $name = $row['name'];
            $save[] = array( 'id_image' => $imid, 'name' => $name );
        }
    }
}


foreach( $save as $image ) {
    $id_image = $image['id_image'];
    $name = mysql_real_escape_string($image['name']);

    echo $id_image." - ".$name."<br/>";

    $sql = "UPDATE ps_image_lang SET legend = '$name' WHERE id_image = $id_image";
    $result = $conn->query($sql);
}

?>