=IMPORTXML("https://example.org/myxmlfilename.php", "//folder")

<?php
 
/* 
* LIST OF AVAILABLE THEMES IN A LS INSTALLATION 
* - - - - - - - - - - - - - - - - - - - - - - - - - - - 
* GGsheet formula (have to be pasted in a cell):
* =IMPORTXML("https://example.org/myxmlfilename.php", "//folder")
*/
 
header('Content-type: application/xml; charset=utf-8');
header ('X-Robots-Tag: none', true);
 
print "<?xml version='1.0' encoding='utf-8'?>"; 
print "<answers>";
 
// Fetch database credentials (better outside web www root directory)
 
$dblocation =   ' ';
$dbname =  ' ';
$dbuser =    '  ';
$dbpwd =   ' ';
 
 
// Create connection
$conn = new mysqli($dblocation, $dbuser, $dbpwd, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
 
$sql = "SELECT `folder` FROM `lime_templates`";
$result = $conn->query($sql);
 
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
 
    print "<item>\n";
    print "<folder>".$row["folder"]."</folder>\n";
    print "</item>\n";
    }
} else {
    print "big error";
}
 
$conn->close();
 
print "</answers>";
 
?>