moz1208ex.txt

mozilla developer book examples.

<?php header( "Content-type: application/vnd.mozilla.xul+xml" ); ?>
<?xml version="1.0"?>
<?php
  // connect code
  $host           = "127.0.0.1";
  $user           = "nobody";
  $database       = "test";
  $password       = "mypass";
  $connect        =  mysql_connect($host, $user, $password);
  mysql_select_db($database);
  $query          = "SELECT * FROM sample ORDER BY User";
  $result         = mysql_query($query, $connect);
  $e              = mysql_error( );
  if($e)
    print  "ERROR:projects: $e";
  $row            = mysql_num_rows($result);
?>
<!DOCTYPE window>
<window
  id = "remote"
  xmlns = "http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul"
  title = "A Remote Image" style = "min-width:282px; min-height:137px;">
  <image src="http://books.mozdev.org/screenshots/logo5.gif" />
  <hbox>
    <tree>
      <treecols>
        <treecol id="userCol" label="User" />
        <treecol id="projectCol" label="Project" flex="1"/>
      </treecols>

      <treechildren>
        <?php
          // generate data from db
          for($i=0;$i<$row;$i++) {
            $user    = mysql_result($result, $i, "User");
            $project = mysql_result($result, $i, "Project");
            print "<treeitem container=\"true\" open=\"true\">\n";
            print "<treerow>\n";
            print "<treecell label=\"".ucwords($user)."\" />";
            print "<treecell label=\"".ucwords($project)."\" flex=\"1\"/>";
            print "</treerow>\n";
            print "</treeitem>\n";
          }
        ?>
       </treechildren>
    </tree>
    <spacer flex="1" />
 </hbox>
</window>