Show Posts
ahmm problem je nemogu dati link za stranciu, jer radi samo na mrezi firme!
ali evo kopirat cu kodu... pa malo objasnit vise, mozda onda ko shvati kako sredit,jer ja nikako...
Code:
<html>
<head><title>Iskanje</title></head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<body>
<?php
###############################################
# copyright by MuhammedPasha
# made february 2008 for *******, SI
###############################################
include '../library/session_proof.php';
include '../library/config.php';
include '../library/opendb.php';
$pronum = $_POST['produktnumer'];
$typnum = $_POST['typnumer'];
$aufnum = $_POST['auftragsnumer'];
$user = $_POST['user'];
$kluster = $_POST['kluster'];
$datum = $_POST['datum'];
$flag ="OK";
$msg = "";
$rowsPerPage = 3;
$pageNum = 1;
if ( isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
$offset = ( $pageNum - 1 ) * $rowsPerPage;
if(empty($datum) && empty($pronum) && empty($typnum) && empty($aufnum) && empty($user) && empty($kluster)) {
echo "<center>Niste podali iskalnega niza!</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
exit;
}
//iskanje po datumu
if(isset($datum) && empty($pronum) && empty($typnum) && empty($aufnum) && empty($user) && empty($kluster)) {
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster LIMIT $offset, $rowsPerPage";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $datum;
$iskalni_niz = "datumu";
/*********************************/
$sql1 = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result1 = mysql_query($sql1) or die ("Napaka v iskanju... ".mysql_error());
$numrows = mysql_num_rows($result1);
}
//iskanje po uporabnikih
if(isset($user) and empty($pronum) and empty($typnum) and empty($aufnum) and empty($kluster) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE user_id = $user AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $user;
$iskalni_niz = "uporabniku";
}
//iskanje po klusterih
if(isset($kluster) and empty($pronum) and empty($typnum) and empty($aufnum) and empty($user) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE cluster = $kluster AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $kluster;
$iskalni_niz = "klusteru";
}
//iskanje po ?t.auftraga
if(isset($aufnum) and empty($pronum) and empty($typnum) and empty($user) and empty($kluster)and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE auftrags_numer = $aufnum AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $aufnum;
$iskalni_niz = "st.naloga";
}
//iskanje po ?t.tipa
if(isset($typnum) and empty($pronum) and empty($aufnum) and empty($user) and empty($kluster) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE typ_numer = $typnum AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $typnum;
$iskalni_niz = "st.tipa";
}
//iskanje po ?t.produkta
if(isset($pronum) and empty($typnum) and empty($aufnum) and empty($user) and empty($kluster) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE produkt_numer = $pronum AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $pronum;
$iskalni_niz = "st.produkta";
}
#ima tu jos querja...al da sad ne kopiram previse djabe
?>
<center><img src="../images/logomb.png" width="200" /><br /><br />
<?php
if ( $num_rows <= 0 ) {
echo "<center>Iskanje je bilo zal neuspesno, poskusite z drugimi parametri!</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
else {
if( $iskalni_niz4 != NULL && $iskalni_niz3 != NULL && $iskalni_niz2 != NULL && $iskalni_niz != NULL){
echo "<center>Rezultat iskanja po $iskalni_niz <b>$iskanec </b>, $iskalni_niz2 <b>$iskanec2</b>, $iskalni_niz3 <b>$iskanec3</b> in $iskalni_niz4 <b>$iskanec4:</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
if( $iskalni_niz3 != NULL && $iskalni_niz2 != NULL && $iskalni_niz != NULL && $iskalni_niz4 == NULL){
echo "<center>Rezultat iskanja po $iskalni_niz <b>$iskanec </b>, $iskalni_niz2 <b>$iskanec2</b> in $iskalni_niz3 <b>$iskanec3:</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
if ( $iskalni_niz2 != NULL && $iskalni_niz != NULL && $iskalni_niz4 == NULL && $iskalni_niz3 == NULL) {
echo "<center>Rezultat iskanja po $iskalni_niz <b>$iskanec </b>in $iskalni_niz2 <b>$iskanec2:</b></center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
if ( $iskalni_niz != NULL && $iskalni_niz4 == NULL && $iskalni_niz3 == NULL && $iskalni_niz2 == NULL) {
echo "<center>Rezultat iskanja po $iskalni_niz: <b>$iskanec:</b></center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>"; }
?>
<br />
<table border="1" cellspacing="1" cellpadding="4" align="center">
<tr align='center' height='40' bgcolor='#CC0000'>
<td><b><font color="#FFFFFF">Id</font></b></td><td><b><font color="#FFFFFF">Uporabnik</font></b></td><td><b><font color="#FFFFFF">Narejeno</font></b></td><td><b><font color="#FFFFFF">Kluster</font></b></td><td><b><font color="#FFFFFF">St.produkta</font></b></td><td><b><font color="#FFFFFF">St.tipa</font></b></td><td><b><font color="#FFFFFF">St.zahtevka</font></b></td>
</tr>
<?php
while( $row = mysql_fetch_array($result) ) {
echo "<tr align='center'><td width='50'>{$row['id']}</td><td>{$row['username']}</td><td>{$row['created_at']}</td><td>{$row['name']}</td><td>{$row['produkt_numer']}</td><td>{$row['typ_numer']}</td><td>{$row['auftrags_numer']}</td></tr>";
}
echo '</table>';
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
for ( $page = 1; $page <= $maxPage; $page++ ) {
if ( $page == $pageNum ) {
$nav .= "$page "; }
else {
$nav .= "<a href=\"$self?page=$page\">$page</a>"; }
}
if ( $pageNum > 1 ) {
$page = ($pageNum - 1);
$prev = "<a href=\"$self?page=$page\">[-]</a>";
$first = "<a href=\"$self?page=1\">[<<]</a>";
}
else {
$prev = ' ';
$first = ' ';
}
if ( $pageNum < $maxPage ) {
$page = $pageNum + 1;
$next = "<a href=\"$self?page=$page\">[+]</a>";
$last = "<a href=\"$self?page=$maxPage\">[>>]</a>";
}
else {
$next = ' ';
$last = ' ';
}
echo '<center><br>'.$first.$prev.$nav.$next.$last.'</center>';
}
?>
</center></body></html>
<head><title>Iskanje</title></head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<body>
<?php
###############################################
# copyright by MuhammedPasha
# made february 2008 for *******, SI
###############################################
include '../library/session_proof.php';
include '../library/config.php';
include '../library/opendb.php';
$pronum = $_POST['produktnumer'];
$typnum = $_POST['typnumer'];
$aufnum = $_POST['auftragsnumer'];
$user = $_POST['user'];
$kluster = $_POST['kluster'];
$datum = $_POST['datum'];
$flag ="OK";
$msg = "";
$rowsPerPage = 3;
$pageNum = 1;
if ( isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
$offset = ( $pageNum - 1 ) * $rowsPerPage;
if(empty($datum) && empty($pronum) && empty($typnum) && empty($aufnum) && empty($user) && empty($kluster)) {
echo "<center>Niste podali iskalnega niza!</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
exit;
}
//iskanje po datumu
if(isset($datum) && empty($pronum) && empty($typnum) && empty($aufnum) && empty($user) && empty($kluster)) {
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster LIMIT $offset, $rowsPerPage";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $datum;
$iskalni_niz = "datumu";
/*********************************/
$sql1 = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result1 = mysql_query($sql1) or die ("Napaka v iskanju... ".mysql_error());
$numrows = mysql_num_rows($result1);
}
//iskanje po uporabnikih
if(isset($user) and empty($pronum) and empty($typnum) and empty($aufnum) and empty($kluster) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE user_id = $user AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $user;
$iskalni_niz = "uporabniku";
}
//iskanje po klusterih
if(isset($kluster) and empty($pronum) and empty($typnum) and empty($aufnum) and empty($user) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE cluster = $kluster AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $kluster;
$iskalni_niz = "klusteru";
}
//iskanje po ?t.auftraga
if(isset($aufnum) and empty($pronum) and empty($typnum) and empty($user) and empty($kluster)and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE auftrags_numer = $aufnum AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $aufnum;
$iskalni_niz = "st.naloga";
}
//iskanje po ?t.tipa
if(isset($typnum) and empty($pronum) and empty($aufnum) and empty($user) and empty($kluster) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE typ_numer = $typnum AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $typnum;
$iskalni_niz = "st.tipa";
}
//iskanje po ?t.produkta
if(isset($pronum) and empty($typnum) and empty($aufnum) and empty($user) and empty($kluster) and empty($datum)){
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE produkt_numer = $pronum AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $pronum;
$iskalni_niz = "st.produkta";
}
#ima tu jos querja...al da sad ne kopiram previse djabe
?>
<center><img src="../images/logomb.png" width="200" /><br /><br />
<?php
if ( $num_rows <= 0 ) {
echo "<center>Iskanje je bilo zal neuspesno, poskusite z drugimi parametri!</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
else {
if( $iskalni_niz4 != NULL && $iskalni_niz3 != NULL && $iskalni_niz2 != NULL && $iskalni_niz != NULL){
echo "<center>Rezultat iskanja po $iskalni_niz <b>$iskanec </b>, $iskalni_niz2 <b>$iskanec2</b>, $iskalni_niz3 <b>$iskanec3</b> in $iskalni_niz4 <b>$iskanec4:</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
if( $iskalni_niz3 != NULL && $iskalni_niz2 != NULL && $iskalni_niz != NULL && $iskalni_niz4 == NULL){
echo "<center>Rezultat iskanja po $iskalni_niz <b>$iskanec </b>, $iskalni_niz2 <b>$iskanec2</b> in $iskalni_niz3 <b>$iskanec3:</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
if ( $iskalni_niz2 != NULL && $iskalni_niz != NULL && $iskalni_niz4 == NULL && $iskalni_niz3 == NULL) {
echo "<center>Rezultat iskanja po $iskalni_niz <b>$iskanec </b>in $iskalni_niz2 <b>$iskanec2:</b></center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
}
if ( $iskalni_niz != NULL && $iskalni_niz4 == NULL && $iskalni_niz3 == NULL && $iskalni_niz2 == NULL) {
echo "<center>Rezultat iskanja po $iskalni_niz: <b>$iskanec:</b></center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>"; }
?>
<br />
<table border="1" cellspacing="1" cellpadding="4" align="center">
<tr align='center' height='40' bgcolor='#CC0000'>
<td><b><font color="#FFFFFF">Id</font></b></td><td><b><font color="#FFFFFF">Uporabnik</font></b></td><td><b><font color="#FFFFFF">Narejeno</font></b></td><td><b><font color="#FFFFFF">Kluster</font></b></td><td><b><font color="#FFFFFF">St.produkta</font></b></td><td><b><font color="#FFFFFF">St.tipa</font></b></td><td><b><font color="#FFFFFF">St.zahtevka</font></b></td>
</tr>
<?php
while( $row = mysql_fetch_array($result) ) {
echo "<tr align='center'><td width='50'>{$row['id']}</td><td>{$row['username']}</td><td>{$row['created_at']}</td><td>{$row['name']}</td><td>{$row['produkt_numer']}</td><td>{$row['typ_numer']}</td><td>{$row['auftrags_numer']}</td></tr>";
}
echo '</table>';
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
for ( $page = 1; $page <= $maxPage; $page++ ) {
if ( $page == $pageNum ) {
$nav .= "$page "; }
else {
$nav .= "<a href=\"$self?page=$page\">$page</a>"; }
}
if ( $pageNum > 1 ) {
$page = ($pageNum - 1);
$prev = "<a href=\"$self?page=$page\">[-]</a>";
$first = "<a href=\"$self?page=1\">[<<]</a>";
}
else {
$prev = ' ';
$first = ' ';
}
if ( $pageNum < $maxPage ) {
$page = $pageNum + 1;
$next = "<a href=\"$self?page=$page\">[+]</a>";
$last = "<a href=\"$self?page=$maxPage\">[>>]</a>";
}
else {
$next = ' ';
$last = ' ';
}
echo '<center><br>'.$first.$prev.$nav.$next.$last.'</center>';
}
?>
</center></body></html>
eh ovako sta se desi... ja sam stavijo za paging samo prvi querja...
Code:
if(isset($datum) && empty($pronum) && empty($typnum) && empty($aufnum) && empty($user) && empty($kluster)) {
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster LIMIT $offset, $rowsPerPage";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $datum;
$iskalni_niz = "datumu";
/*********************************/
$sql1 = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result1 = mysql_query($sql1) or die ("Napaka v iskanju... ".mysql_error());
$numrows = mysql_num_rows($result1);
}
$sql = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster LIMIT $offset, $rowsPerPage";
$result = mysql_query($sql) or die ("Napaka v iskanju... ".mysql_error());
$num_rows = mysql_num_rows($result);
$iskanec = $datum;
$iskalni_niz = "datumu";
/*********************************/
$sql1 = "SELECT input_table.id, user_table.username, cluster_table.name, input_table.created_at, input_table.produkt_numer, input_table.typ_numer, input_table.auftrags_numer FROM input_table,user_table,cluster_table WHERE date(input_table.created_at) = '$datum' AND user_table.id = input_table.user_id AND cluster_table.id = input_table.cluster";
$result1 = mysql_query($sql1) or die ("Napaka v iskanju... ".mysql_error());
$numrows = mysql_num_rows($result1);
}
kada neko trazi po datumu -> izpise prvih 3... i onda ako stisne drugu stranicu nece da izpise sljedecih 3... nego izspise : "Nista podali sikalnega niza" ... a to dolazi od ovoga :
Code:
if(empty($datum) && empty($pronum) && empty($typnum) && empty($aufnum) && empty($user) && empty($kluster)) {
echo "<center>Niste podali iskalnega niza!</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
exit;
}
echo "<center>Niste podali iskalnega niza!</center><br>";
echo "<center><input type='button' value='Vrni se' onClick='history.go(-1)'></center><br>";
exit;
}
eh sad ja mislim da je problem u tome,da kad stisnem na sljedecu stranicu, on ponovo podze da pretrazuje sve querya al vise nezna koji je pravi i izpise kao da nije uneseno nista za trazenje???
eh nadam se da je sad bolje razlozeno
hvala jos jednom
...
to je na papiru super i bilo bi odlicno ... 
