LHA PHP Page

\n"; if($MySQL) { // MYSQL portion of code *************************************************** //------ DATABASE CONNECTION --------// // I need better error checking here $mysql_link = @mysql_connect($dbhost, $dbuser, $dbpass); if(!$mysql_link) { echo "Login failed
\n"; exit(); } $column = mysql_list_fields($dbname, $dbtable, $mysql_link); $sql = "SELECT * FROM $dbtable;"; $result = @mysql_db_query($dbname, $sql); if(!$result) { echo "Query failed
\n"; $result = mysql_error(); echo "$result\n"; mysql_close($mysql_link); exit(); } $i = 0; while($row = mysql_fetch_object($result)) { // Now I need to store the info in an array $Nom[$i] = $row->Nom; $Desc[$i] = $row->Dsc; $d_HC[$i] = $row->HC; $d_UC[$i] = $row->UC; // Generate JavaScript variables, you can use TAGS in the $desc[] entries. echo "$d_HC[$i]$d_UC[$i] = ' $Desc[$i]';\n"; $i++; } mysql_close($mysql_link); /* readfile("group.txt"); */ } else { //**************************************************************** //* CSV file portion of code *********************************************** $data = file("device"); // file name = table name used by MySQL $i = 0; foreach( $data as $line){ list($id, $Nom[$i], $Desc[$i], $d_HC[$i], $d_UC[$i], $t, $s) = split(",",$line); // Generate JavaScript variables, you can use TAGS in the $desc[] entries. echo "$d_HC[$i]$d_UC[$i] = ' $Desc[$i]';\n"; $i++; } } echo "\n"; //************************************************************************** $fp = fsockopen($XHost, $XPort); if(!$fp) { echo "connection failed\n"; exit; } /* ** This CMD can be either be POST'd or GET'd */ if($CMD) { // We really should validate the command before execution fputs($fp, "$CMD\r\n"); $count = 0; do { $str[$count] = fgets($fp, 512); $x = preg_split("/[\s]/", $str[$count++]); } while("R" == $x[0]); } /* ** I want this changed to a local command and maybe a link. */ $st =`bin/HomeDaemon-dump`; $ar = explode("\n", $st); $n = count($ar); // Build a table with links echo "\n"; echo "\n"; echo "\n"; // Genreate the Unit number line for($k = 1; $k < 17; $k++) { if($k < 10) { echo "\n"; } else { echo "\n"; } } /* echo "\n"; echo "\n"; echo "\n"; */ echo "\n"; $k = 0; $i = 0; $j = 0; $B_URI = preg_split("/[\?]/", $REQUEST_URI); for($i = 0; $i <$n-1; ++$i) { echo "\n"; $sub_ar = preg_split ("/[\s]+/", $ar[$i]); $sub_n = count($sub_ar); $HC = preg_split ("/[:]/", $sub_ar[1]); // Return just the House code echo "\n"; for($j = 2;$j < $sub_n; ++$j) { if($sub_ar[$j] == "1") { $SW = "Off"; // Toggle state to opposite for cmd $CL = "On"; // Class (changes colors) } else { $SW = "On"; $CL = "Off"; } $UN = $j - 1; echo "\n"; $k++; } /* echo "\n"; echo "\n"; echo "\n"; */ echo "\n"; } echo "

**X10 Status**
House Code	$k	$k	All Off	All On	Group
\n"; ?> Linux Home Automation PHP Page \n"; echo "
$HC[0]	$Nom[$k]	$HC[0]17	$HC[0]18	$HC[0]19

\n"; echo "\n"; ?>

"; echo "CommandResponse"; echo "$CMD"; for($i = 0; $i < $count; $i++) { echo " $str[$i]
\n"; } echo "\n\n"; } ?>