Module Admin development

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

I am slowly working my way thru creating the backend to my MILPACS module. I am currently working on a page to edit the units page which can be seen here. [ Only registered users can see links on this board! Get registered or login! ]

This is the page for 1st Platoon. I have 5 units in my roster_units table and I am trying to find the best way to display the data for each unit.

Forms are not my strong area and I've probably got several issues with this latest editunit.php page.

But it's a start.

I'm trying to loop thru and display the info for all my units and create them in their own table. There are only 9 fields I need to mess with. Trying to get $counter = ($counter + 1) to increment thru my units to display.

I don't even know if this code:

Code:

$unit_count = max("SELECT unit_id FROM roster_units");

would work to find the max number of units in the table.

As alway any help is much appreciated.

-Donovan

Code:

<?php 


//////////////////////////////////////////////////////////////////////


//===========================


// MILPACS


//


// This is the Military Personell and Classification System.


//


//


//


///////////////////////////////////////////////////////////////////////


if (!eregi("modules.php", $PHP_SELF)) {


   die ("You can't access this file directly...");


    }


$index = 0;


//finds the server's root directory


$self = dirname(__FILE__);


$nukemod = basename($self);


$rootdir = eregi_replace("/modules/$nukemod", "", $self);


$index=0;


require_once("mainfile.php");


global $module_name, $db;


$module_name = basename(dirname(__FILE__));


include("header.php");


OpenTable();


echo "<html>";


echo "<body>";


echo "<form name=\"editunit\">";


echo "<form action=\"$_SERVER ['PHP_SELF']\" method=\"POST\">";


echo "<div align=\"center\">";


echo "<H2>3rd ID Unit Page</H2>";   


echo "<HR>";


echo "</div>";


echo "<br>";


$unit_count = max("SELECT unit_id FROM roster_units");


$counter = 0;


while ( $counter <= $unit_count) {


echo "<H3>Unit Information</H3>";


   $sql = "SELECT * FROM roster_units ORDER BY unit_id";


   $result = $db->sql_query($sql);


   while ( $row = $db->sql_fetchrow($result) ) {


   $unit = $row["unit_name"];


   $nick = $row["unit_nick"];


   $creed = $row["unit_creed"];


   $motto = $row["unit_motto"];


   $image = $row["unit_image"];


   $goal1 = $row["unit_goal_one"];


   $goal2 = $row["unit_goal_two"];


   $goal3 = $row["unit_goal_three"];


   $bio = $row["unit_bio"];


   }


echo" <HR>"  


  . "  <table align= center>"


  . "  <tr>         "


  . "   <th align = right>Unit:</td><input type=\"text\" name=\"$unit\" size=\"30\"/>"


  . "  <tr>   "


  . "   <th align = right>Unit Name:</td><input type=\"text\" name=\"$nick\" size=\"25\"/>"


  . "  <tr>   "


  . "   <th align = right>Creed:</td><input type=\"text\" name=\"$creed\" size=\"25\"/>"


  . "  <tr>   "


  . "   <th align = right>Motto:</td><input type=\"text\" name=\"$motto\" size=\"25\"/>"


  . "  <tr>   "


  . "   <th align = right>Unit Image:</td><input type=\"text\" name=\"$image\" size=\"25\"/>"


  . "  <tr>   "


  . "   <th align = right>Goal One:</td><input type=\"text\" name=\"$goal1\" size=\"25\"/>"


  . "  <tr>   "


  . "   <th align = right>Goal Two</td><input type=\"text\" name=\"$goal2\" size=\"20\"/>"


  . "  <tr>   "


  . "   <th align = right>Goal Three:</td><input type=\"text\" name=\"$goal3\" size=\"25\"/>"


  . "  <tr>"


  . "   <th align = right>Unit Bio:</td><input type=\"text\" name=\"$bio\" size=\"25\"/>"


  . "  <tr>"


  . "     <td colspan=2 align=center>"


  . "   <input type=submit value=\"Update Unit\">"


  . "   </table> "


  . "</form>"; 


  $counter = ($counter + 1)


}


echo "</body>";


echo "</html>";


CloseTable();


include("footer.php");


?>