=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>"; ?>