func_search.php

Dokumenacija za ovu datoteku.

<?
/**************************************************************************************
 Studentski Informacijski servis, 2004
 **************************************************************************************
 func_search.php
 repozitorij funkcija za site wide pretrazivanje


 Srdjan Segvic - srle
 **************************************************************************************
 **************************************************************************************
 This program is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU Library General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 **************************************************************************************/


 //
 // funkcija koja prikuplja sumarne rezultate pretrazivanja
 //
 function doSearch($id, $odsjek, $keyword){
if (($keyword=="") || (strlen($keyword)<3)){
        printServisGreska(_SEARCHTOSHORT);
        printRokoviKraj();
}
else {
        //
        // trazimo keyword u obavjestenjima predmeta...
        //
        $sem_poc = getSemestarPocetak($id);
        $sem_kraj = getSemestarKraj($id);

        $query_predmeti =
                "SELECT DISTINCT obavjestenje.obavjestenje_ID
                FROM  obavjestenje, obavjestenje_predavac, odsjek_predmet, predmet
                WHERE odsjek_predmet.odsjek_ID = '$odsjek'
                AND   obavjestenje_predavac.obavjestenje_ID = obavjestenje.obavjestenje_ID
                AND   obavjestenje_predavac.predmet_ID = odsjek_predmet.predmet_ID
                AND   obavjestenje.status_obavjestenja = 'objavljeno'
                AND   predmet.predmet_ID = obavjestenje_predavac.predmet_ID
                AND   odsjek_predmet.datum_kraja = '0000-00-00'
                AND   predmet.semestar_pocetak >= $sem_poc
                AND   predmet.semestar_pocetak <= $sem_kraj
                AND   predmet.semestar_polaganje >= $sem_poc
                AND   predmet.semestar_polaganje <= $sem_kraj
                AND   obavjestenje.obavjestenje_ID =obavjestenje_predavac.obavjestenje_ID
                ORDER BY obavjestenje.obavjestenje_ID";


        $result_predmeti = mysql_query($query_predmeti) or
                                                  die(mysql_error());

        if (mysql_num_rows($result_predmeti)!=0){
        $count = 0;
        // opet kerefeke za ubrzanje query-a
        while ($row_predmeti = mysql_fetch_array($result_predmeti)){
                $oid[$count] = $row_predmeti[0];
                $count++;
        }

        $query_op_start =
                "SELECT obavjestenje.obavjestenje_ID
                FROM     obavjestenje
                WHERE   obavjestenje.text LIKE '%$keyword%'
                OR         obavjestenje.naslov LIKE '%$keyword%'
                HAVING       obavjestenje.obavjestenje_ID IN (";

        $broj = 0;
        $query_op_add = "";
        while ($broj < $count){
                $query_op_add .= "'".$oid[$broj]."', ";
                $broj++;
        }
        $len = strlen($query_op_add);
        $query_op_add = substr($query_op_add, 0, ($len-2));


        $query_op_end =
                        ")";

        $query_op = $query_op_start.$query_op_add.$query_op_end;



        $result_op = mysql_query($query_op) or die(mysql_error());
        $broj_op = mysql_num_rows($result_op);
        }
        else {
        $broj_op = 0;
        }



        //
        // hajmo sad traziti keyword u obavjestenjima sluzbe...
        //
        $query_sss =
                        "SELECT obavjestenje.obavjestenje_ID
                        FROM  obavjestenje, obavjestenje_sss, sss
                        WHERE obavjestenje.tip_obavjestenja = 'sss'
                        AND   obavjestenje_sss.obavjestenje_ID = obavjestenje.obavjestenje_ID
                        AND   obavjestenje_sss.sss_ID = sss.sss_ID
                        AND   obavjestenje.status_obavjestenja = 'objavljeno'
                        ORDER BY obavjestenje_sss.datum_postavljanja DESC";

        $result_sss = mysql_query($query_sss) or
                                                  die(mysql_error());

        if (mysql_num_rows($result_sss)!=0){
        $count_sss = 0;
        // opet kerefeke za ubrzanje query-a
        while ($row_sss = mysql_fetch_array($result_sss)){
                $oid_sss[$count_sss] = $row_sss[0];
                $count_sss++;
        }

        $query_os_start =
                "SELECT  obavjestenje.obavjestenje_ID
                FROM     obavjestenje
                WHERE   obavjestenje.text LIKE '%$keyword%'
                OR          obavjestenje.naslov LIKE '%$keyword%'
                HAVING   obavjestenje.obavjestenje_ID IN (";

        $broj_sss = 0;
        $query_os_add = "";
        while ($broj_sss < $count_sss){
                $query_os_add .= "'".$oid_sss[$broj_sss]."', ";
                $broj_sss++;
        }
        $len_sss = strlen($query_os_add);
        $query_os_add = substr($query_os_add, 0, ($len_sss-2));

        $query_os_end =
                        ")
                        ";

        $query_os = $query_os_start.$query_os_add.$query_os_end;


        $result_os = mysql_query($query_os) or die(mysql_error());
        $broj_os = mysql_num_rows($result_os);
        }
        else {
        $broj_os = 0;
        }
;

        //
        // trazimo u generalnim downloadima...
        //
        $query_downgen =
                        "SELECT DISTINCT upload.upload_ID
                        FROM  odsjek_predmet, predmet, upload
                        WHERE odsjek_predmet.odsjek_ID = '$odsjek'
                        AND   predmet.predmet_ID = upload.predmet_ID
                        AND   odsjek_predmet.datum_kraja = '0000-00-00'
                        AND   predmet.semestar_pocetak >= $sem_poc
                        AND   predmet.semestar_pocetak <= $sem_kraj
                        AND   predmet.semestar_polaganje >= $sem_poc
                        AND   predmet.semestar_polaganje <= $sem_kraj";

        $result_downgen = mysql_query($query_downgen) or
                                                  die(mysql_error());
        if (mysql_num_rows($result_downgen)!=0){
        $count_dg = 0;
        // opet kerefeke za ubrzanje query-a
        while ($row_downgen = mysql_fetch_array($result_downgen)){
                $dgid[$count_dg] = $row_downgen[0];
                $count_dg++;
        }

        $query_dg_start =
                "SELECT upload.upload_ID
                FROM     upload
                WHERE   upload.opis_dokumenta LIKE '%$keyword%'
                OR          upload.naziv_dokumenta LIKE '%$keyword%'
                HAVING   upload.upload_ID IN (";

        $broj_dg = 0;
        $query_dg_add = "";
        while ($broj_dg < $count_dg){
                $query_dg_add .= "'".$dgid[$broj_dg]."', ";
                $broj_dg++;
        }
        $len_dg = strlen($query_dg_add);
        $query_dg_add = substr($query_dg_add, 0, ($len_dg-2));

        $query_dg_end =
                        ")";

        $query_dg = $query_dg_start.$query_dg_add.$query_dg_end;

        $result_dg = mysql_query($query_dg) or die(mysql_error());
        $broj_dg = mysql_num_rows($result_dg);
        }
        else {
        $broj_dg = 0;
        }

        //
        // trazimo u personalnim downloadima...kako je lijepo kad su tabele jednostavne... :)
        //
        $query_dp =
                        "SELECT down_personal_ID
                        FROM   downloadi_personal
                        WHERE  student_id = '$id'
                        AND down_opis LIKE '%$keyword%'
                        OR   down_ime LIKE '%$keyword%'";

        $result_dp = mysql_query($query_dp) or die(mysql_error());
        $broj_dp = mysql_num_rows($result_dp);


        //
        // trazimo u generalnim linkovima
        //
        $query_lg=
                        "SELECT links_ID
                        FROM   linkovi_links
                        WHERE  links_opis LIKE '%$keyword%'
                        OR   links_naziv LIKE '%$keyword%'";

        $result_lg = mysql_query($query_lg) or die(mysql_error());
        $broj_lg = mysql_num_rows($result_lg);


        //
        // i napokon, trazimo u personalnim linkovima...
        //
        $query_lp =
                        "SELECT links_id
                        FROM   linkovi_personal_links
                        WHERE  student_id = '$id'
                        AND links_opis LIKE '%$keyword%'
                        OR   links_naziv LIKE '%$keyword%'";

        $result_lp = mysql_query($query_lp) or die(mysql_error());
        $broj_lp = mysql_num_rows($result_lp);

        printSearchStart($broj_op, $broj_os, $broj_dg, $broj_dp, $broj_lg, $broj_lp, $keyword);
   }

}

//
//
//
//
function doSearchPred($id, $odsjek, $keyword, $red, $stranica){

        $nr_set_obav = getObavPerPage($id);
        //
        // funkcija ispisuje rezultate pretrage...
        //
        $sem_poc = getSemestarPocetak($id);
        $sem_kraj = getSemestarKraj($id);

        $query_predmeti =
                "SELECT DISTINCT obavjestenje.obavjestenje_ID
                FROM  obavjestenje, obavjestenje_predavac, odsjek_predmet, predmet
                WHERE odsjek_predmet.odsjek_ID = '$odsjek'
                AND   obavjestenje_predavac.obavjestenje_ID = obavjestenje.obavjestenje_ID
                AND   obavjestenje_predavac.predmet_ID = odsjek_predmet.predmet_ID
                AND   obavjestenje.status_obavjestenja = 'objavljeno'
                AND   predmet.predmet_ID = obavjestenje_predavac.predmet_ID
                AND   odsjek_predmet.datum_kraja = '0000-00-00'
                AND   predmet.semestar_pocetak >= $sem_poc
                AND   predmet.semestar_pocetak <= $sem_kraj
                AND   predmet.semestar_polaganje >= $sem_poc
                AND   predmet.semestar_polaganje <= $sem_kraj
                AND   obavjestenje.obavjestenje_ID =obavjestenje_predavac.obavjestenje_ID
                ORDER BY obavjestenje.obavjestenje_ID";

        $result_predmeti = mysql_query($query_predmeti) or
                                                  die(mysql_error());
        $count = 0;
        // opet kerefeke za ubrzanje query-a
        while ($row_predmeti = mysql_fetch_array($result_predmeti)){
                $oid[$count] = $row_predmeti[0];
                $count++;
        }

        $query_op_start =
                "SELECT obavjestenje.naslov, obavjestenje.text, obavjestenje.obavjestenje_ID
                FROM     obavjestenje
                WHERE   obavjestenje.text LIKE '%$keyword%'
                OR          obavjestenje.naslov LIKE '%$keyword%'
                HAVING  obavjestenje.obavjestenje_ID IN (";

        $broj = 0;
        $query_op_add = "";
        while ($broj < $count){
                $query_op_add .= "'".$oid[$broj]."', ";
                $broj++;
        }
        $len = strlen($query_op_add);
        $query_op_add = substr($query_op_add, 0, ($len-2));

        $query_op_end =
                        ")
                        ";
        $query_op_l = "LIMIT ". $red.", ". $nr_set_obav;


        $query_op_export = $query_op_start.$query_op_add.$query_op_end;

        $query_op = $query_op_export.$query_op_l;


        countSearchPred($id, $query_op_export, $stranica, $keyword, 1);

        $result_ob_prof = mysql_query($query_op) or
                                                  die(mysql_error());


        if (mysql_num_rows($result_ob_prof)==0){
                          noNews();
                          }
        else {


                while ($row_ob_prof = mysql_fetch_array($result_ob_prof)){

                        $ob_id= $row_ob_prof[2];
                        $query_prof =
                                        "SELECT predavac.ime_predavaca, predavac.prezime_predavaca, obavjestenje_predavac.datum_postavljanja
                                         FROM predavac, obavjestenje_predavac
                                         WHERE obavjestenje_predavac.obavjestenje_ID = '$ob_id'
                                         AND     predavac.predavac_ID = obavjestenje_predavac.predavac_ID";
                        $result_prof = mysql_query($query_prof) or
                                                die(mysql_error());

                        $row_prof = mysql_fetch_array($result_prof);

                        $query_pred = "SELECT predmet.naziv_predmeta
                                               FROM predmet, obavjestenje_predavac
                                               WHERE obavjestenje_predavac.obavjestenje_ID = '$ob_id'
                                               AND     predmet.predmet_ID = obavjestenje_predavac.predmet_ID";

                        $result_pred = mysql_query($query_pred) or
                                                die(mysql_error());

                        if (mysql_num_rows($result_pred)!==0){

                                $row_pred = mysql_fetch_array($result_pred);


                                $headPr = $row_pred['naziv_predmeta'];
                                $naslovPr = $row_ob_prof[0];
                                $textPr = $row_ob_prof[1];
                                $datumPr = $row_prof[2];
                                $profesor = $row_prof['ime_predavaca'] . " " . $row_prof['prezime_predavaca'];
                                $color = getColor($id, 2);
                                $picture = "small.jpg";

                                $textPr = nl2br($textPr);

                                $textPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $textPr);
                                $naslovPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $naslovPr);
                                $keyword1 = ucfirst($keyword);
                                $textPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $textPr);
                                $naslovPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $naslovPr);
                                $keyword2 = strtoupper($keyword);
                                $textPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $textPr);
                                $naslovPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $naslovPr);


                                printObavjestenje($headPr, $naslovPr, $textPr, $datumPr, $profesor, $color, $picture);

                        }

                }
        }
        countSearchPred($id, $query_op_export, $stranica, $keyword, 0);
}


//
// funkcija koja proslijedjuje broj obavjestenja i tip predmeti
//
function countSearchPred($id, $query_broj, $stranica, $keyword, $gore){

        $result_broj = mysql_query($query_broj) or
                                          die(mysql_error());

        $broj_obavjestenja = mysql_num_rows($result_broj);

        if ($gore == "1"){
                echo "
                <h3><font color=\"#4B4B4B\"><strong>"._SEARCHRESULTSFOR." <font color=\"#FF0000\">".$keyword."</font>, "._SEARCHRESULTSSUM." ".$broj_obavjestenja." "._SEARCHRESULTSSUMRESULT."<br/><br/></h3>";
        }
        $tip = "pred";
        numberSearchPages($stranica, $broj_obavjestenja, $tip, $keyword, $id);
}


//
// funkcija koja ispisuje odabir stranica obavjestenja i ispisuje koja je stranica aktivna
//
function numberSearchPages($stranica, $broj_obavjestenja, $tip, $keyword, $id){

        $nr_set_obav = getObavPerPage($id);
        //
        // na osnovu broja obavjestenja pravi izbor stranica
        //
        echo " <center><table cellpadding=\"0\" cellspacing=\"0\">\n";
        echo " <tr>\n";
        echo " <td width=\"15\"><div align=\"center\">\n";

    if (isset($stranica) && $stranica<>1){
                echo " <font color=\"#4B4B4B\" class=\"textsize1\"><strong>";
                echo " <a href=\"search.php?&tip=".$tip."&keyword=" . $keyword . "&stranica=" . ($stranica-1) . "\"><<</a></div></strong></font></td>\n";
        }
        else {
                echo " <font color=\"#B6B6B6\" class=\"textsize1\"><strong>";
                echo "<<</div></strong></font></td>\n";
        }
        
        for ($i=0; $i<($broj_obavjestenja / $nr_set_obav); $i++){
                $j = $i;
                echo " <td width=\"15\"><div align=\"center\">\n";
                if (++$j != $stranica){
                        echo " <font color=\"#4B4B4B\" class=\"textsize1\"><strong>";
                        echo " <a href=\"search.php?&tip=".$tip."&keyword=" . $keyword . "&stranica=" . $j . "\"> ". $j . " </a></div></strong></font></td>\n";
                }
                else {
                        echo " <font color=\"#B6B6B6\" class=\"textsize1\"><strong>";
                        echo $j . "</a></div></strong></font></td>\n";
                }
    }
    echo " <td width=\"15\"><div align=\"center\">\n";


        if (isset($stranica) and $stranica < $j){
                echo " <font color=\"#4B4B4B\" class=\"textsize1\"><strong>";
                echo " <a href=\"search.php?&tip=".$tip."&keyword=" . $keyword . "&stranica=" . ($stranica+1) . "\">>></a></div></strong></font></td>\n";
        }
        else {
                echo " <font color=\"#B6B6B6\" class=\"textsize1\"><strong>";
                echo ">></div></strong></font></td>\n";
        }
    echo " </tr></table></center>\n";
}


function doSearchSSS($id, $keyword, $red, $stranica){

        $nr_set_obav = getObavPerPage($id);
        //
        // funkcija ispisuje rezultate pretrage...
        //
        $query_sss =
                "SELECT obavjestenje.obavjestenje_ID
                FROM  obavjestenje, obavjestenje_sss, sss
                WHERE obavjestenje.tip_obavjestenja = 'sss'
                AND   obavjestenje_sss.obavjestenje_ID = obavjestenje.obavjestenje_ID
                AND   obavjestenje_sss.sss_ID = sss.sss_ID
                AND   obavjestenje.status_obavjestenja = 'objavljeno'";

        $result_sss = mysql_query($query_sss) or die(mysql_error());
        $count_sss = 0;
        // opet kerefeke za ubrzanje query-a
        while ($row_sss = mysql_fetch_array($result_sss)){
                $oid_sss[$count_sss] = $row_sss[0];
                $count_sss++;
        }

        $query_os_start =
                "SELECT obavjestenje.naslov, obavjestenje.text, obavjestenje.obavjestenje_ID
                FROM     obavjestenje
                WHERE   obavjestenje.text LIKE '%$keyword%'
                OR          obavjestenje.naslov LIKE '%$keyword%'
                HAVING   obavjestenje.obavjestenje_ID IN (";

        $broj_sss = 0;
        $query_os_add = "";

        while ($broj_sss < $count_sss){
                $query_os_add .= "'".$oid_sss[$broj_sss]."', ";
                $broj_sss++;
        }

        $len_sss = strlen($query_os_add);
        $query_os_add = substr($query_os_add, 0, ($len_sss-2));

        $query_os_end =
                        ")
                        ";

        $query_os_l = "LIMIT ". $red.", ". $nr_set_obav;

        $query_os_export = $query_os_start.$query_os_add.$query_os_end;
        $query_os = $query_os_export.$query_os_l;


        countSearchsss($id, $query_os_export, $stranica, $keyword, 1);



        $result_os_sss = mysql_query($query_os) or die(mysql_error());

        if (mysql_num_rows($result_os_sss)==0){
                  noNews();
        }

        else {

                while ($row_os_sss = mysql_fetch_array($result_os_sss)){
                        $ob_id= $row_os_sss[2];

                        $query_sss =
                                "SELECT sss.ime_sss, sss.prezime_sss, obavjestenje_sss.datum_postavljanja
                                 FROM sss, obavjestenje_sss
                                 WHERE obavjestenje_sss.obavjestenje_ID = '$ob_id'
                                 AND     sss.sss_ID = obavjestenje_sss.sss_ID ";




                        $result_sss = mysql_query($query_sss) or die(mysql_error());

                        $row_sss = mysql_fetch_array($result_sss);


                        $headPr = _SSERVICE;
                        $naslovPr = $row_os_sss[0];
                        $textPr = $row_os_sss[1];
                        $datumPr = $row_sss[2];
                        $autor = $row_sss[0] . " " . $row_sss[1];
                        $color = getColor($id, 3);
                        $picture = "smallo.jpg";

                        $textPr = nl2br($textPr);

                        $textPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $textPr);
                        $naslovPr = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $naslovPr);
                        $keyword1 = ucfirst($keyword);
                        $textPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $textPr);
                        $naslovPr = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $naslovPr);
                        $keyword2 = strtoupper($keyword);
                        $textPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $textPr);
                        $naslovPr = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $naslovPr);


                        printObavjestenje($headPr, $naslovPr, $textPr, $datumPr, $autor, $color, $picture);
                }
        }
        countSearchsss($id, $query_os_export, $stranica, $keyword, 0);
}


//
// funkcija koja proslijedjuje broj obavjestenja i tip predmeti
//
function countSearchsss($id, $query_broj, $stranica, $keyword, $gore){

        $result_broj = mysql_query($query_broj) or die(mysql_error());

        $broj_obavjestenja = mysql_num_rows($result_broj);

        if ($gore == "1") {
                echo "
                <h3><font color=\"#4B4B4B\"><strong>"._SEARCHRESULTSFOR." <font color=\"#FF0000\">".$keyword."</font>, "._SEARCHRESULTSSUM." ".$broj_obavjestenja." "._SEARCHRESULTSSUMRESULT."<br/><br/></h3>";
        }
        $tip = "sss";
        numberSearchPages($stranica, $broj_obavjestenja, $tip, $keyword, $id);
}

//
//
//
function doSearchdg($id, $odsjek ,$keyword){
        $sem_poc = getSemestarPocetak($id);
        $sem_kraj = getSemestarKraj($id);
        //
        // trazimo u generalnim downloadima...
        //
        $query_downgen =
                        "SELECT DISTINCT upload.upload_ID
                        FROM  odsjek_predmet, predmet, upload
                        WHERE odsjek_predmet.odsjek_ID = '$odsjek'
                        AND   predmet.predmet_ID = upload.predmet_ID
                        AND   odsjek_predmet.datum_kraja = '0000-00-00'
                        AND   predmet.semestar_pocetak >= $sem_poc
                        AND   predmet.semestar_pocetak <= $sem_kraj
                        AND   predmet.semestar_polaganje >= $sem_poc
                        AND   predmet.semestar_polaganje <= $sem_kraj";

        $result_downgen = mysql_query($query_downgen) or
                                                  die(mysql_error());
        $count_dg = 0;
        // opet kerefeke za ubrzanje query-a
        while ($row_downgen = mysql_fetch_array($result_downgen)){
                $dgid[$count_dg] = $row_downgen[0];
                $count_dg++;
        }

        $query_dg_start =
                "SELECT upload.upload_id, upload.naziv_dokumenta, upload.opis_dokumenta, upload.datum_uploada, upload.velicina
                FROM     upload
                WHERE   upload.opis_dokumenta LIKE '%$keyword%'
                OR          upload.naziv_dokumenta LIKE '%$keyword%'
                HAVING   upload.upload_ID IN (";

        $broj_dg = 0;
        $query_dg_add = "";
        while ($broj_dg < $count_dg){
                $query_dg_add .= "'".$dgid[$broj_dg]."', ";
                $broj_dg++;
        }
        $len_dg = strlen($query_dg_add);
        $query_dg_add = substr($query_dg_add, 0, ($len_dg-2));

        $query_dg_end =
                        ")";

        $query_dg = $query_dg_start.$query_dg_add.$query_dg_end;

        $result_dg = mysql_query($query_dg) or die(mysql_error());

        $brojac=0;
        while ($row_predmeti = mysql_fetch_array($result_dg)){
                $down_general[$brojac][0] = $row_predmeti[0];
                $down_general[$brojac][1] = $row_predmeti[1];
                $down_general[$brojac][2] = $row_predmeti[2];
                $down_general[$brojac][3] = $row_predmeti[3];
                $down_general[$brojac][4] = round(($row_predmeti[4]/1024),2)." KB";

                $down_general[$brojac][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_general[$brojac][1]);
                $down_general[$brojac][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_general[$brojac][2]);

                $keyword1 = ucfirst($keyword);
                $down_general[$brojac][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_general[$brojac][1]);
                $down_general[$brojac][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_general[$brojac][2]);

                $keyword2 = strtoupper($keyword);
                $down_general[$brojac][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_general[$brojac][1]);
                $down_general[$brojac][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_general[$brojac][2]);

                $brojac++;
        }


        printRokoviStart(_SEARCHRESULTGENDOWNFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
        printDownGeneral($down_general, $brojac, $pid);
        printRokoviKraj();
}

//
//
//
function doSearchdp($id ,$keyword){

        $query_dp =
                        "SELECT down_personal_ID, down_ime, down_opis, down_size, down_datum
                        FROM   downloadi_personal
                        WHERE  student_id = '$id'
                        AND down_opis LIKE '%$keyword%'
                        OR   down_ime LIKE '%$keyword%'";

        $result_personal = mysql_query($query_dp) or die(mysql_error());

        $brojac_personal = 0;
        while ($row_personal = mysql_fetch_array($result_personal)){
                $down_personal[$brojac_personal][0] = $row_personal[0];
                $down_personal[$brojac_personal][1] = $row_personal[1];
                $down_personal[$brojac_personal][2] = $row_personal[2];
                $down_personal[$brojac_personal][3] = round(($row_personal[3]/1024),2)." KB";
                $down_personal[$brojac_personal][4] = $row_personal[4];


                $down_personal[$brojac_personal][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_personal[$brojac_personal][1]);
                $down_personal[$brojac_personal][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $down_personal[$brojac_personal][2]);

                $keyword1 = ucfirst($keyword);
                $down_personal[$brojac_personal][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_personal[$brojac_personal][1]);
                $down_personal[$brojac_personal][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $down_personal[$brojac_personal][2]);

                $keyword2 = strtoupper($keyword);
                $down_personal[$brojac_personal][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_personal[$brojac_personal][1]);
                $down_personal[$brojac_personal][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $down_personal[$brojac_personal][2]);

                $brojac_personal++;

        }
        printRokoviStart(_SEARCHRESULTPERSDOWNFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
        printDownPersonal($down_personal, $brojac_personal);
        printRokoviKraj();
}

function doSearchlg($keyword){

        $query_lg=
                        "SELECT links_url, links_naziv, links_opis
                        FROM   linkovi_links
                        WHERE  links_opis LIKE '%$keyword%'
                        OR   links_naziv LIKE '%$keyword%'";

        $result = mysql_query($query_lg) or die(mysql_error());


        $brojac_url = 0;
        while ($row = mysql_fetch_array($result)){
                $link_url[$brojac_url][0] = $row[0];
                $link_url[$brojac_url][1] = $row[1];
                $link_url[$brojac_url][2] = $row[2];


                $link_url[$brojac_url][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][1]);
                $link_url[$brojac_url][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][2]);

                $keyword1 = ucfirst($keyword);
                $link_url[$brojac_url][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][1]);
                $link_url[$brojac_url][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][2]);

                $keyword2 = strtoupper($keyword);
                $link_url[$brojac_url][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][1]);
                $link_url[$brojac_url][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][2]);

                $brojac_url++;
        }
        printRokoviStart(_SEARCHRESULTGENLINKSFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
        printLinkoviSearch($link_url, $brojac_url, "general");
        printRokoviKraj();
}


function doSearchlp($id, $keyword){

        $query_lg=
                        "SELECT links_url, links_naziv, links_opis, links_ID
                        FROM   linkovi_personal_links
                        WHERE  student_id = '$id'
                        AND links_opis LIKE '%$keyword%'
                        OR   links_naziv LIKE '%$keyword%'";

        $result = mysql_query($query_lg) or die(mysql_error());


        $brojac_url = 0;
        while ($row = mysql_fetch_array($result)){
                $link_url[$brojac_url][0] = $row[0];
                $link_url[$brojac_url][1] = $row[1];
                $link_url[$brojac_url][2] = $row[2];
                $link_url[$brojac_url][3] = $row[3];

                $link_url[$brojac_url][1] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][1]);
                $link_url[$brojac_url][2] = str_replace($keyword, "<font color=\"#FF0000\">".$keyword."</font>", $link_url[$brojac_url][2]);

                $keyword1 = ucfirst($keyword);
                $link_url[$brojac_url][1] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][1]);
                $link_url[$brojac_url][2] = str_replace($keyword1, "<font color=\"#FF0000\">".$keyword1."</font>", $link_url[$brojac_url][2]);

                $keyword2 = strtoupper($keyword);
                $link_url[$brojac_url][1] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][1]);
                $link_url[$brojac_url][2] = str_replace($keyword2, "<font color=\"#FF0000\">".$keyword2."</font>", $link_url[$brojac_url][2]);
                
                $brojac_url++;
        }
        printRokoviStart(_SEARCHRESULTPERSLINKSFOR." <font color=\"#FF0000\">".$keyword."</font>", 724);
        printLinkoviSearch($link_url, $brojac_url, "personal");
        printRokoviKraj();
}
?>

---