Sitemap required for my image hosting site

[1200]

Currently using https://pro-sitemaps.com/, but its free version can only crawl up to 500 pages. Paying to purchase its service is not a small expense for me. Is there a free sitemap generation? System?

 

[paffy]

https://www.codepunker.com/tools/sitemap-generator use this for unlimited it's free but it's taking time to sending you sitemap in your inbox +- 1 hour 🙂

 

[Laurentiu]

Hey there, I want to share my solution for those using Chevereto who struggle with image indexing (I created a free sitemap script see here) :

 

[Barry]

Hey there, I want to share my solution for those using Chevereto who struggle with image indexing (I created a free sitemap script see here) :

Hidden behind a required email address requirement

 

[Punker]

Hey there, I want to share my solution for those using Chevereto who struggle with image indexing (I created a free sitemap script see here) :

potential xml injection on your $title?

If any of the data coming from your database contains characters like &, <, >, ", or ', it will break the XML structure here.

escape the url too.

$escapedUrl = htmlspecialchars($fileUrl, ENT_XML1, 'UTF-8');
echo "    <loc>$escapedUrl</loc>\n";
echo "      <image:loc>$escapedUrl</image:loc>\n";

catch (Exception $e) {
    error_log($e->getMessage());
    http_response_code(500);
    exit;
}

mine is

<?php
ini_set('display_errors', 0);
ini_set('log_errors', 1);

header("Content-Type: application/xml; charset=utf-8");

try {
    $pdo = new PDO(
        "mysql:host=$db_host;dbname=$db_name;charset=utf8",
        $db_user,
        $db_pass,
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );

    echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
    echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
          xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">' . "\n";

    $stmt = $pdo->query("SELECT image_id, image_name, image_extension, image_date, image_title 
                         FROM lgpn_images 
                         WHERE image_is_approved = 1 
                         ORDER BY image_id DESC 
                         LIMIT 4000");

    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $folderPath = date("Y/m/d/", strtotime($row['image_date']));
        $fileUrl = "https://YOURWEBSITE.COM/images/$folderPath{$row['image_name']}.{$row['image_extension']}";

        $escapedUrl = htmlspecialchars($fileUrl, ENT_XML1, 'UTF-8');
        $title = htmlspecialchars($row['image_title'] ?: $row['image_name'], ENT_XML1, 'UTF-8');

        echo "  <url>\n";
        echo "    <loc>$escapedUrl</loc>\n";
        echo "    <image:image>\n";
        echo "      <image:loc>$escapedUrl</image:loc>\n";
        echo "      <image:title>$title</image:title>\n";
        echo "    </image:image>\n";
        echo "  </url>\n";
    }

    echo '</urlset>';

} catch (Exception $e) {
    error_log($e->getMessage());
    http_response_code(500);
}

I did add HTTP_ACCEPT_ENCODING gzip to mine with paginated sitemap_1.xml etc but thankfully under the 50K still i did consider DOMDocument but not got around to it yet.