<?php
  // LED Tower Submit - clean and insert the command into the DB
  $num_commands = 0;
  $commands = array();  

  // Process any simple commands
  $have_commands = 0;
  for ($i=0; $i<5; $i++) {
    if ($_REQUEST['color' . $i] != "") $have_commands = 1;
  }
  // clean up the command
  if ($have_commands) {  
    $cmd = "";
    for ($i=0; $i<5; $i++) {
      if ($_REQUEST['color' . $i] == "") $_REQUEST['color' . $i] = "000000";  // blanks get turned to black (LEDs off)
      $cmd .= $_REQUEST['color' . $i];
	}
	$commands[$num_commands++] = $cmd;
  } //have_commands

  // note - the site allows lists of commands too - removed here for simplicity
  
  // add any commands to the DB
  if ($num_commands > 0) {
    $db = new mysqli("localhost", "user", "password", "database");
    if($db->connect_errno > 0){
      die('Unable to connect to database [' . $db->connect_error . ']');
    }
    for ($i=0; $i<$num_commands; $i++) {
      $query = "INSERT INTO queue (queue_command) VALUES ('{$commands[$i]}')";
      if (!$result = $db->query($query)) {
        die('There was an error running the query [' . $db->error . ']');
      }
	}
    mysqli_free_result($result);
    $db->close();
  }
?>