Tema: Php vincular java scrip menu desplegable y tabla
Ver Mensaje Individual
  #3 (permalink)  
Antiguo 02/06/2012, 22:17
fillo_mv
 
Fecha de Ingreso: junio-2012
Mensajes: 6
Antigüedad: 12 años, 5 meses
Puntos: 0
Respuesta: Php vincular java scrip menu desplegable y tabla
Código HTML: 
Ver original
  1. <?php require_once('../Connections/Prueba.php'); ?>
  2. <html>
  3. <head>
  4. <title>BIBLIOTECA LABORATORIO DE HIDRAULICA</title>
  5. <script type="text/JavaScript">
  6. <!--
  7. function menu(){
  8. var menu_1=ac
  9. }
  10. function MM_jumpMenu(targ,selObj,restore){ //v3.0
  11. eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"1");
  12. if (restore) selObj.selectedIndex=0;
  13. }
  14. //-->
  15. </script>
  16. </head>
  17. <body bgcolor="#0099FF">
  18. <table width="80%" border="0" align="center" cellpadding="0" bgcolor="">
  19. <tr bgcolor="">
  20. <td colspan="3" rowspan="2" nowrap><img src="dh3.jpg" width="230" height="104" >
  21. </td>
  22. <td height="60" nowrap colspan="3" id="logo" valign="bottom"><h2>BIBLIOTECA DEL LABORATORIO DE HIDRAULICA</h2>
  23. </td>
  24. <td width="0"></td>
  25. </tr>
  26. <tr bgcolor="">
  27. <td height="50" colspan="3" valign="TOP" nowrap bgcolor="" id="tagline"><hr><H3>UMSNH</H3></td>
  28. </tr>
  29. <tr>
  30. <td colspan="8" align="center"><H3>INVENTARIO GENERAL </H3></td>
  31. </tr>
  32. <tr>
  33. <td width="196" valign="top" height="370">
  34. <table border="0" cellspacing="0" cellpadding="0" width="155" id="navigation">
  35. <tr>
  36. </tr>
  37. <tr>
  38. <td width="155" height="40" align="center"><a href="javascript:;">DEPARTAMENTO</a></td>
  39. </tr>
  40. <tr>
  41. <td width="155" height="40" align="center"><a href="javascript:;" >LABORATORIO</a></td>
  42. </tr>
  43. <tr>
  44. <td width="155" height="40" align="center"><a href="javascript:;">INGRESAR AL SISTEMA</a></td>
  45. </tr>
  46. <tr>
  47.  
  48. </tr>
  49. </table></td>
  50. <td width="3" bgcolor=""><img src="mm_spacer.gif" alt="" width="1" height="1" border="0"></td>
  51. <td width="30"></td>
  52. <td colspan="2" valign="top"><img src="mm_spacer.gif" alt="" width="304" height="1" border="0"><br>
  53. <table border="0" cellspacing="0" cellpadding="0" width="675">
  54.  
  55. <tr>
  56. </tr>
  57. <td align="center">
  58. <form name="form1" method="post" action="">
  59. VER 
  60. <select name="menu1" onChange="javascript:menu()">
  61. <option value="1">TESIS</option>
  62. <option value="2">MEMORIAS</option>
  63. <option value="3">LIBROS</option>
  64. <option value="4">SERIES</option>
  65. </select>
  66. <label>BUSCAR
  67. <input name="textarea" type="text" value="">
  68. </label> 
  69. <select name="menu2" >
  70. <option value="1">TITULO</option>
  71. <option value="2">AUTOR</option>
  72. <option value="3">NUMERO</option>
  73. </select> 
  74. <label>
  75. <input type="submit" name="Submit" value="ACTUALIZAR LISTA" onClick=scr"">
  76. </label>
  77. </form> </td>
  78. <tr>
  79. <Td>
  80. <table width="100%" border="0">
  81. </table>
  82. </Td>   
  83.  
  84. <?php
  85. $db_host = 'localhost';
  86. $db_user = 'root';
  87. $database = 'hidrobib';
  88. $table = 'memorias';
  89. if (!mysql_connect($db_host, $db_user))
  90. die("Can't connect to database");
  91.  
  92. if (!mysql_select_db($database))
  93. die("Can't select database");
  94. // sending query
  95. $result = mysql_query("SELECT * FROM $table ORDER BY $table.Numero");
  96. if (!$result) {
  97. die("Query to show fields from table failed");
  98. }
  99.  
  100. $fields_num = mysql_num_fields($result);
  101. echo "<table border='3' width=100%><tr>";
  102. // printing table headers
  103. for($i=0; $i<$fields_num; $i++)
  104. {
  105. if ($i==0){
  106. $field = mysql_fetch_field($result);
  107. echo "<td width=10%>{$field->name}</td>";
  108. }
  109. else{
  110. $field = mysql_fetch_field($result);
  111. echo "<td>{$field->name}</td>";
  112. }
  113. }
  114. echo "</tr>\n";
  115. // printing table rows
  116. while($row = mysql_fetch_row($result))
  117. {
  118. echo "<tr>";
  119.  
  120. // $row is array... foreach( .. ) puts every element
  121. // of $row to $cell variable
  122. foreach($row as $cell)
  123. echo "<td>$cell</td>";
  124.  
  125. echo "</tr>\n";
  126. }
  127. mysql_free_result($result);
  128. ?>
  129. </tr>
  130. </table>
  131. </Td></tr>
  132. </table>    </td>
  133. </table> 
  134. <tr>
  135. </tr>
  136. </table>
  137. </body>
  138. </html>