Difference between revisions of "Active Directory/Software Packages"
| Line 9: | Line 9: | ||
*Many software packages have additional license restrictions not listed in the table. | *Many software packages have additional license restrictions not listed in the table. | ||
*Software packages that are only available for manual installation are not listed here. | *Software packages that are only available for manual installation are not listed here. | ||
| + | |||
| + | <php> | ||
| + | define ('INCLUDES',"../_include/"); | ||
| + | require_once(INCLUDES . "myit/myit.inc.php"); | ||
| + | $server = $DB["server"]; | ||
| + | $username = $DB["read-un"]; | ||
| + | $password = $DB["read-pw"]; | ||
| + | $database = $DB["database"]; | ||
| + | $table = "packaged_software"; | ||
| + | // Connect | ||
| + | $link = mysql_connect($server, $username, $password) | ||
| + | or die("Unable to connect to database server"); | ||
| + | // Select Table | ||
| + | @mysql_select_db($database) | ||
| + | or die("Unable to select database"); | ||
| + | |||
| + | echo "<HTML>\n<HEAD>\n\t<title>$title</title>\n</HEAD>\n<BODY>\n"; | ||
| + | $query = "SELECT vendor,title,version,licensor,notes FROM $table " | ||
| + | . "ORDER BY vendor, title, version"; | ||
| + | $result = mysql_query($query) | ||
| + | or die("Query failed! $result"); | ||
| + | echo "<table BORDER=1 cellpadding='10'>\n"; | ||
| + | echo "\t<tr><th>Vendor</th><th>Title</th><th>Version</th><th>Licensor</th><th>Notes</th></tr>\n"; | ||
| + | while ( $line = mysql_fetch_array($result, MYSQL_ASSOC) ) { | ||
| + | if($count++ % 2 == 0) echo "\t<tr bgcolor='gray'>\n"; | ||
| + | else echo "\t<tr bgcolor='silver'>\n"; | ||
| + | foreach ($line as $col_value) { | ||
| + | echo "\t\t<td>$col_value</td>\n"; | ||
| + | } | ||
| + | echo "\t</tr>\n"; | ||
| + | } | ||
| + | echo "</table>\n"; | ||
| + | echo "</BODY>\n</HTML>"; | ||
| + | // Free resultset | ||
| + | mysql_free_result($result); | ||
| + | </php> | ||
Revision as of 13:21, 27 February 2006
The following software is packaged and available for automatic distribution over the network. To request that software be installed on your computer, please email ecehelp@ncsu.edu.
Once we have setup the installation, you can simply reboot your computer and the software will be installed while Windows is booting up.
Notes:
- Many software packages have additional license restrictions not listed in the table.
- Software packages that are only available for manual installation are not listed here.
<php> define ('INCLUDES',"../_include/"); require_once(INCLUDES . "myit/myit.inc.php"); $server = $DB["server"]; $username = $DB["read-un"]; $password = $DB["read-pw"]; $database = $DB["database"]; $table = "packaged_software"; // Connect $link = mysql_connect($server, $username, $password) or die("Unable to connect to database server"); // Select Table @mysql_select_db($database) or die("Unable to select database");
echo "<HTML>\n<HEAD>\n\t<title>$title</title>\n</HEAD>\n<BODY>\n"; $query = "SELECT vendor,title,version,licensor,notes FROM $table " . "ORDER BY vendor, title, version"; $result = mysql_query($query) or die("Query failed! $result");
echo "
\n"; echo "\t\n";while ( $line = mysql_fetch_array($result, MYSQL_ASSOC) ) {
if($count++ % 2 == 0) echo "\t\n"; else echo "\t\n"; foreach ($line as $col_value) { echo "\t\t\n";}echo "\t\n"; } echo "
| Vendor | Title | Version | Licensor | Notes |
|---|---|---|---|---|
| $col_value |
\n";
echo "</BODY>\n</HTML>"; // Free resultset mysql_free_result($result); </php>