<html>
  <head>
  <title>Subsector</title>
  </head>
  <body>
  <h1>Mantenimiento de Subsector</h1>
  <table align=center border=1>
  <form name=sec1 action=ma_subsector.php method=post>
    <?

  if ($boton=='Editar'){
  echo "<tr><td>CODIGO</td><td><input type=text size=20 name=codigo value='$codigo' ></td></tr>";  
  echo "<tr><td>NOMBRE</td><td><input type=text size=20 name=nombre value='$nombre' ></td></tr><tr>"; 
  echo "<input type=hidden size=20 value='$id' name=id>";
  echo "<input type=submit size=20 value='Consultar' name=boton>";
  echo "<input type=submit size=20 value='Modificar' name=boton>";
  echo "<input type=submit size=20 value='Eliminar' name=boton>";
  echo "<input type=reset size=20 value='Limpiar Datos'></td></tr>";
  }else {
  echo "<tr><td>CODIGO</td><td><input type=text size=20 name=codigo></td></tr>";  
  echo "<tr><td>NOMBRE</td><td><input type=text size=20 name=nombre ></td></tr><tr>"; 
  echo "<tr><td colspan=2><input type=submit size=20 value='Insertar' name=boton>";
  echo "<input type=submit size=20 value='Consultar' name=boton>";
  echo "<input type=reset size=20 value='Limpiar Datos'></td></tr>";
  }
 ?>
  </table>
  <?
  
  if($boton){
      $con=mysql_connect('localhost','root','sa');
      if($boton=='Insertar'){ 
            $sql="select if(isnull(max(id_Producto)),0,max(id_Producto)) as dato from Prod_Subsector_Mype";
    	$resulid=mysql_db_query("bd_mype" , $sql);
    	$fila=mysql_fetch_array($resulid);
    	$id_Producto=$fila["dato"]+1;
            $sql="insert  into Prod_Subsector_Mype (id_Producto, codigo_subsector, nom_subsector) values ($id_subsector, '$codigo', '$nombre')";
            $resulid=mysql_db_query("bd_mype" , $sql);	
      }
      if($boton=='Consultar'){
           $sql="select * from sub_sector_mype";
           $resul=mysql_db_query("bd_mype",$sql);
           $list=mysql_fetch_array($resul);
           echo "<table border=1><tr><td>Id</td><td>Codigo</td><td>Nombre</td></tr>";
           while($list){
               $subsector=$list['nom_subsector'];
               $subsector=str_replace(' ', '+', $subsector);
               echo"<tr><td>" . $list["id_subsector"] . "</td><td>" . $list["codigo_subsector"] . "</td><td>" . "<a href='ma_subsector.php?boton=Editar&id=". $list['id_subsector'] . "&codigo=" . $list['codigo_subsector'] . "&nombre=$subsector'>" . $list["nom_subsector"] . "</a></td></tr>";
               $list=mysql_fetch_array($resul);
            }
            echo"</table>";
       } 
       if($boton=='Modificar'){
            $sql="update sub_sector_mype set codigo_subsector='$codigo', nom_subsector='$nombre' where id_subsector=$id";
            $resultid=mysql_db_query("bd_mype",$sql);
       }
       if($boton=='Eliminar'){
            $sql="delete from sub_sector_mype where id_subsector=$id";
            $resul=mysql_db_query("bd_mype",$sql);
       }
       }
?>
  </form>
  </body>
  </html>




 

 



