LEDColors/getpatterns.php

20 lines
361 B
PHP

<?php
require 'header.php';
$query = "SELECT id, name FROM patterns ORDER BY name";
$sth = $globaldbh->prepare($query);
$sth->execute();
$patterns = array();
while ( $row = $sth->fetch(PDO::FETCH_ASSOC) ) {
$patterns[] = $row['name'];
}
$msg = "";
foreach ( $patterns as $pattern ) {
$msg .= $pattern . ",";
}
$msg = substr($msg, 0, -1);
echo $msg;