|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/logicswapweb/guias/ |
Upload File : |
<html>
<script>
function generar()
{
consulta="select * from ";
alert(consulta);
}
function ingresardetalle(cantidad_campos)
{
var car = new Array()
var elm = document.getElementsByTagName("select");
var elt = document.getElementsByTagName("table");
opcion = elm['ca'];
tabla = elt['tabla1'];
//opcion=document.getElementById('ca');
//tabla=document.getElementById('tabla1');
tabla_tr = tabla.insertRow();
tabla_td = tabla_tr.insertCell();
sel1 = document.createElement("select");
for (i=0;i<cantidad_campos;i++)
{
opt = document.createElement("OPTION");
opt.value =document.forms['reporte'].ca.options[i].value;
opt.innerText =document.forms['reporte'].ca.options[i].value
sel1.appendChild(opt);
}
tabla_td.appendChild(sel1);
tabla_td = tabla_tr.insertCell();
opt1 = document.createElement("OPTION");
opt1.value = "=";
opt1.innerText = "=";
opt2 = document.createElement("OPTION");
opt2.value = "<>";
opt2.innerText = "<>";
opt3 = document.createElement("OPTION");
opt3.value = ">";
opt3.innerText = ">";
opt4 = document.createElement("OPTION");
opt4.value = ">=";
opt4.innerText = ">=";
opt5 = document.createElement("OPTION");
opt5.value = "<";
opt5.innerText = "<";
opt6 = document.createElement("OPTION");
opt6.value = "<=";
opt6.innerText = "<=";
opt7 = document.createElement("OPTION");
opt7.value = "LIKE";
opt7.innerText = "LIKE";
opt8 = document.createElement("OPTION");
opt8.value = "BETWEEN";
opt8.innerText = "BETWEEN";
opt9 = document.createElement("OPTION");
opt9.value = "IS NULL";
opt9.innerText = "IS NULL";
opt10 = document.createElement("OPTION");
opt10.value = "IS NOT NULL";
opt10.innerText = "IS NOT NULL";
sel2 = document.createElement("select");
sel2.appendChild(opt1);
sel2.appendChild(opt2);
sel2.appendChild(opt3);
sel2.appendChild(opt4);
sel2.appendChild(opt5);
sel2.appendChild(opt6);
sel2.appendChild(opt7);
sel2.appendChild(opt8);
sel2.appendChild(opt9);
sel2.appendChild(opt10);
tabla_td.appendChild(sel2);
tabla_td = tabla_tr.insertCell();
sel3 = document.createElement("<input name='logica' value=''>");
tabla_td.appendChild(sel3);
}
</script>
<head>
<LINK href="style.css" type=text/css rel=StyleSheet>
<title>Lista de Tablas de BD_WEB</title>
</head>
<body>
<?php
$seleccion = (array_key_exists('seleccion',$_REQUEST))?$_REQUEST['seleccion']:NULL;
print("<FORM name='reporte' ACTION='reporteador.php' METHOD=POST>") ;
$link = mysql_connect ("localhost",'root','root') or die ("Could not connect");
$result = mysql_list_tables ("panel_aplicaciones");
$i = 0;
print ("<div id='lt' style='display:inline;overflow:scroll'>");
print("<select name=tablas>");
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
$val = $tb_names[$i];
print("<option value=$val>$val</option> ");
$i++;
}
print("</select>");
print("<TABLE border=1>") ;
print("<tr class=celda ><td COLSPAN=2 ALIGN='CENTER'>LISTA DE TABLAS</td></tr>") ;
$result = mysql_list_tables ("panel_aplicaciones");$i = 0;
while ($i < mysql_num_rows ($result)) {
$tb_names[$i] = mysql_tablename ($result, $i);
$val = $tb_names[$i];
echo "<tr><td>"."<a href=reporteador.php?seleccion=$i&table_name=$tb_names[$i]>".($i+1)."</a></td><td>".$tb_names[$i] . "<BR></td></tr>";
$i++;
}
print("</TABLE>") ;
print ("</div>");
//$seleccion=true;
if ($seleccion<>NULL)
{
print ("<div id='lc' style='position:absolute;top:10px;left:330;width:500;height:250;display:inline;overflow:scroll'>");
print ("<table BORDER=2>");
print ("<tr>");
$consulta="select * from $table_name";
$resultado = mysql_query($consulta);
$fields = mysql_num_fields($resultado);
$rows = mysql_num_rows($resultado);
$j = 0;
$table = mysql_field_table($resultado, $j);
print ("<tr class=ancla >");
print ("<td colspan=5>");
print ("TABLA : $table_name");
print ("</td>");
print ("</tr>");
print ("<tr class=celda>");
print ("<td>");
print ("NOMBRE CAMPO");
print ("</td>");
print ("<td>");
print ("TIPO");
print ("</td>");
print ("<td>");
print ("LONGITUD");
print ("</td>");
print ("<td>");
print ('CONDICIONES');
print ("</td>");
print ("<td>");
print ('Seleccionar');
print ("</td>");
print ("</tr>");
while ($j < $fields) {
$type = mysql_field_type ($resultado, $j);
$name = mysql_field_name ($resultado, $j);
$len = mysql_field_len ($resultado, $j);
$flags = mysql_field_flags ($resultado, $j);
print ("<tr>");
print ("<td>");
print ($name);
print ("</td>");
print ("<td>");
print ($type);
print ("</td>");
print ("<td>");
print ($len);
print ("</td>");
print ("<td>");
print ($flags.'.');
print ("</td>");
print ("<td>");
print ("<input type='checkbox' name='ch' >");
print ("</td>");
print ("</tr>");
$j++;
}
print ("<tr class=celda>");
print ("<td colspan=5>");
print ("Total Registros : $rows");
print ("</td>");
print ("</tr>");
print ("</table>");
print ("</div>");
print ("<div id='condiciones' style='position:absolute;top:300px;left:330;width:500;height:150;display:inline;overflow:scroll'>");
print ("<table BORDER=2 id='tabla1'>");
print ("<tr>");
print("<td>");
print ("Campo");
print("</td>");
print("<td>");
print ("Operador");
print("</td>");
print("<td>");
print ("Valor");
print("</td>");
print ("</tr>");
print ("<tr>");
print ("<td>");
/* Muestra las Condiciones*/
print("<select name='ca'>");
for ($i=0;$i<$fields;$i++)
{
$name = mysql_field_name ($resultado, $i);
$campos[$i]=$name;
print("<option value=$name>$name</option>");
}
print("</select>");
print ("</td>");
print ("<td>");
print("<select name='operador'>");
print("<option value='='> = </option>");
print("<option value='<>'> <> </option>");
print("<option value='>'> > </option>");
print("<option value='>='> >= </option>");
print("<option value='<'> < </option>");
print("<option value='<='> <= </option>");
print("<option value='LIKE'> LIKE </option>");
print("<option value='BETWEEN'> BETWEEN </option>");
print("<option value='IS NULL'> IS NULL </option>");
print("<option value='IS NOT NULL'> IS NOT NULL </option>");
print("</select>");
print ("</td>");
print ("<td>");
print("<input type=text >");
print ("<td>");
print ("<td>");
print("<input type=button value='AND'onClick=ingresardetalle('$fields')>");
print ("<td>");
print ("<td>");
print("<input type=button value='OR' onClick=ingresardetalle('$fields')>");
print ("<td>");
print ("</tr>");
print ("</table>");
print ("</div>");
print("<center><input type=button value='GENERAR CONSULTA' onClick=generar()><center>");
}
mysql_close ($link);
print("</FORM>");
?>
</body>
</html>