Bi-Dir

BiViewTable.inc

Line #0:<?php include("QJ_start.php");
Line #1:
Line #2:
Line #3:if (isset($_GET[bimod])) { $_GET[Desc]="*"; $_GET[biord]="wid";}
Line #4:
Line #5:if (isset($_GET[goon])) $_POST[goon]=$_GET[goon];
Line #6:if (isset($_GET[Desc])) $_POST[Desc]=$_GET[Desc];
Line #7:if (isset($_GET[Bis])) $_POST[Bis]=$_GET[Bis];
Line #8:if (isset($_GET[Export])) $_POST[Export]=$_GET[Export];
Line #9:if (isset($_GET[biord])) $_POST[biord]=$_GET[biord];
Line #10:if (isset($_GET[Limit])) $_POST[Limit]=$_GET[Limit];
Line #11:if (!isset($_POST[Limit])) $_POST[Limit]=50;
Line #12:
Line #13:$_POST[Bis]=trim($_POST[Bis]);
Line #14:if (isset($_GET[sql])) $_POST[Bis]=$_GET[sql];
Line #15:
Line #16:
Line #17:?>
Line #18:
Line #19:<BODY background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
Line #20:
Line #21:<FORM name=cimform action='BiViewTable.php?&tabla=<? echo($_GET[tabla]); ?>' method='post'>
Line #22:
Line #23:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #24:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #25:
Line #26:> Sorrend<?if (isset($_POST[Desc])) echo("(S)");?>  
Line #27:
Line #28:
Line #29:
Line #30: TYPE='text' NAME='Bis' size=100
Line #31: value='<?php if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
Line #32:>
Line #33:
Line #34:<br> Limit:
Line #35:
Line #36:
Line #37: TYPE='text' NAME='Limit' size=5
Line #38: value='<?php if (isset($_POST[Limit])) echo($_POST[Limit]); ?>'
Line #39:>
Line #40:
Line #41:
Line #42:>
Line #43:
Line #44:
Line #45:onchange=this.form.submit(); return true name='Bis'>
Line #46:<hr>
Line #47:
Line #48:<?
Line #49:
Line #50:$Viewpar="";
Line #51:$Limit=" Limit ".$_POST[Limit];
Line #52://// IDEIGLENES ///
Line #53://$_POST[Desc]="Y";
Line #54:
Line #55:if (isset($_POST[Del])) $Viewpar.="&Del=Y";
Line #56:if (isset($_POST[Desc])) $Viewpar.="&Desc=Y";
Line #57:if (isset($_POST[Limit])) $Viewpar.="&Limit=".$_POST[Limit];
Line #58:if (isset($_POST[Bis])) $Viewpar.="&Bis=".trim($_POST[Bis]);
Line #59:
Line #60:$ParHead="";
Line #61:$export=false;
Line #62:$tabla=$_GET["tabla"];
Line #63:$biord="";
Line #64:
Line #65:// echo "<script language = javascript>";
Line #66:// echo "alert('".$Viewpar."');";
Line #67:// echo "</script>";
Line #68:
Line #69://echo "<script language = javascript>";
Line #70:
Line #71://echo "</script>";
Line #72:
Line #73:$_SESSION['sqlfile']=$tabla;
Line #74:
Line #75:
Line #76:
Line #77:if (isset($_POST[Desc])) {
Line #78:
Line #79:}
Line #80:
Line #81:if (isset($_POST[biord]) and $_POST[biord]<>"") {
Line #82:$biord= " order by ".$_POST["biord"];
Line #83:if (isset($_POST[Desc]) and $_POST[Desc]<>"") {
Line #84:
Line #85:$biord.=" DESC";
Line #86:}
Line #87:}
Line #88:
Line #89:
Line #90:
Line #91:ECHO('<html>
Line #92:<title>'. $tabla.' </title>
Line #93:');
Line #94:
Line #95:
Line #96:$ee='<table BORDER=1 bgcolor="#DBE6E0" ><tr><td></td>';
Line #97:$fullRec="CONCAT_WS(";
Line #98:$vesszo="";
Line #99:$fid='';
Line #100:
Line #101:$eredmeny = mysql_query('show fields from '.$tabla);
Line #102:
Line #103:while ($row =mysql_fetch_row($eredmeny))
Line #104:{
Line #105:$fid.=$row[0] . ":";
Line #106:$ee .= '<td with=50><b><a href="BiViewTable.php?&tabla='.$tabla.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
Line #107:
Line #108:$fullRec.=$vesszo."(".$row[0].")";
Line #109:$vesszo=",'/', ";
Line #110:
Line #111:}
Line #112:
Line #113:$full=$fullRec.")";
Line #114:
Line #115:$fullRec.=") as full";
Line #116:$fid.="full:";
Line #117:
Line #118:if (isset($_POST[Bis]) and $_POST[Bis]<>"") $wer=" Where INSTR((".$full."),'".($_POST[Bis])."') "; else $wer="";
Line #119:
Line #120:
Line #121:$ee .= '</tr>';
Line #122:
Line #123:if (substr($_POST[Bis],0,2)=="//" and strlen($_POST[Bis])>4) {
Line #124:
Line #125: $sqlwer= str_replace("~", "'",substr($_POST[Bis],2,strlen($_POST[Bis])-2));
Line #126:// Use of the count parameter is available as of PHP 5.0.0
Line #127://$str = str_replace("ll", "", "good golly miss molly!", $count);
Line #128://echo $count; // 2
Line #129:
Line #130:
Line #131:// echo "<script language = javascript>";
Line #132:// echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
Line #133:// echo "</script>";
Line #134:
Line #135:
Line #136:$keres = "SELECT * FROM " . $tabla . " where ".$sqlwer . $biord;
Line #137:
Line #138:print "<font size=3 color=blue>SQL: <b>".$keres."</b></font>";
Line #139:
Line #140:
Line #141:$nurL=mysql_num_rows($eredmeny);
Line #142:$nur=$nurL;
Line #143:$Limit="";
Line #144:$biord="";
Line #145:
Line #146:////////
Line #147:} else {
Line #148:////////
Line #149:
Line #150:$keres = "SELECT * FROM " . $tabla . $wer . $biord;
Line #151://echo("<hr>".$keres."<hr>");
Line #152:
Line #153:
Line #154:$nurL=mysql_num_rows($eredmeny);
Line #155:
Line #156:$keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
Line #157://echo("<hr>".$keres."<hr>");
Line #158:
Line #159:
Line #160:
Line #161:$nur=mysql_num_rows($eredmeny);
Line #162:
Line #163:}
Line #164:
Line #165:///////////////////////////////////
Line #166://echo("<hr>".$keres."<hr>");
Line #167:///////////////////////////////////
Line #168:
Line #169:if ($nurL<1001) $Limit="";
Line #170:
Line #171:
Line #172://'</font></b>';
Line #173:
Line #174:$head=$ParHead;
Line #175:
Line #176:$head=$head.'<br><font size=3 color=red><b>'.($tabla).
Line #177:'</b></font>  Reccount:<b>  '.$nurL.
Line #178:'</b> <font color=blue> <b>'.$biord.
Line #179:'</b>  <b>'.$Limit.
Line #180:'</b></font><br></table>';
Line #181:
Line #182:if (!$nur) {
Line #183:
Line #184:$ee =$head.$ee. '</table>';
Line #185:echo($ee);
Line #186:
Line #187:
Line #188:
Line #189://include ("gvarlist.php");
Line #190:
Line #191:exit;
Line #192:}
Line #193:
Line #194:$ii=0;
Line #195:
Line #196:$h=split(':',$fid);
Line #197:
Line #198:$e= $head.$ee;
Line #199:
Line #200:
Line #201:for($i=0;$i<$nur;$i++) {
Line #202:
Line #203:$r=mysql_fetch_row($eredmeny);
Line #204:
Line #205:$ii++;
Line #206:// $e .= '<tr bgcolor="#A7C2B3"><td bgcolor=gold>'.$i.'</td>';
Line #207:$e .= '<tr bgcolor="#A7C2B3">';
Line #208:$e .= '<td>
Line #209:<A STYLE="{vlink : gold}" target=ediFrame
Line #210:href="BI_ediTable.php?&wjid='.$r[0].'&sqlfile='.$tabla.'">
Line #211:<IMG width=20 height=20 SRC="../_Screen/edit.png" border=0></a>
Line #212:';
Line #213:
Line #214:$e .= '
Line #215:<A STYLE="{vlink : gold}" target=ediFrame
Line #216:href="BI_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
Line #217:<IMG width=20 height=20 SRC="../_Screen/plus.ico" border=0></a>
Line #218:</td>';
Line #219:
Line #220:for($j=0,$k=0;$j<count($r);$j++) {
Line #221:$e .= '<td with=50> '.htmlspecialchars($r[$j]).' </td>';
Line #222:}
Line #223:$e .= '</tr>';
Line #224:
Line #225:if ($ii==50 and $export==false) {
Line #226:$e .= '</table>';
Line #227:echo($e);
Line #228:$ii=0;
Line #229:$e=$ee;
Line #230:}
Line #231:
Line #232:}
Line #233:
Line #234:$e .= '</table>';
Line #235:echo($e);
Line #236:
Line #237:echo($e);
Line #238:
Line #239://mysql_free_result ($eredmeny);
Line #240://include ("gvarlist.php");
Line #241:///////
Line #242:/// BiViewTable.php /// 2009.09.07. 10:58:30
Line #243:?>
Line #244:
Line #245:</body>