mirror of
https://github.com/bancika/diy-layout-creator
synced 2026-11-07 12:24:58 +10:00
bancika
39 lines
765 B
PHP
39 lines
765 B
PHP
<?php
|
|
|
|
// Load help class
|
|
require_once("properties.php");
|
|
|
|
// Load properties
|
|
$dbProperties = new Properties();
|
|
$propertiesFile = fopen("db.properties", "rb");
|
|
$dbProperties->load($propertiesFile);
|
|
|
|
// Connect to the DB
|
|
$username=$dbProperties->getProperty("user");
|
|
$password=$dbProperties->getProperty("pass");
|
|
$database=$dbProperties->getProperty("db");
|
|
$mysqli = new mysqli(localhost,$username,$password,$database);
|
|
|
|
// Run the query
|
|
$sql= "SELECT display_name FROM diylc_category_view";
|
|
|
|
if (!$result = $mysqli->query($sql)) {
|
|
echo "{\"string\":Error}";
|
|
exit;
|
|
}
|
|
|
|
echo "{\"list\":{\"java.lang.String\":[";
|
|
|
|
$i=0;
|
|
|
|
while ($row = $result->fetch_assoc()) {
|
|
if ($i>0)
|
|
echo ",";
|
|
echo "\"".$row["display_name"]."\"";
|
|
$i++;
|
|
}
|
|
|
|
echo "]}}";
|
|
|
|
$mysqli->close();
|
|
?>
|