Loading ...
Sorry, an error occurred while loading the content.

got trouble in highlighting searched record

Expand Messages
  • metysoriano
    I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what
    Message 1 of 8 , Mar 3, 2009
    • 0 Attachment
      I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what colum it is.. my problem is this, I want to highlight its either changing color or change into fontsize the date 03/04/09, so that I could see immediately the date. Because if I can not highlight the search date I need to read each column where the date belongs to. I need to scroll right slowly, it takes time to read each row..

      Please help..

      Thank you so much
    • 9el
      a simple trick can be setting a flag like $searched=false; then after the search use $searched=true if ($searched) { background-color= new color } You can
      Message 2 of 8 , Mar 3, 2009
      • 0 Attachment
        a simple trick can be  setting a flag like  $searched=false;
        then  after the search use $searched=true
        if ($searched) {
        background-color= new color
        }

        You can either use JavaScript or PHP for this.


        -----------------------------------------------------------------------
        Use FreeOpenSourceSoftwares, Stop piracy, Let the developers live. Get
        a Free CD of Ubuntu mailed to your door without any cost. Visit :
        www.ubuntu.com
        ----------------------------------------------------------------------


        On Wed, Mar 4, 2009 at 11:48 AM, metysoriano <metysoriano@...> wrote:

        I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what colum it is.. my problem is this, I want to highlight its either changing color or change into fontsize the date 03/04/09, so that I could see immediately the date. Because if I can not highlight the search date I need to read each column where the date belongs to. I need to scroll right slowly, it takes time to read each row..

        Please help..

        Thank you so much


      • $@!ful™
        You can try with this following code. I did not run it, so you may consider it as pseudo code. function display_output( $highlight_date_list, $date ) {    
        Message 3 of 8 , Mar 4, 2009
        • 0 Attachment

          You can try with this following code. I did not run it, so you may consider it as pseudo code.

          function display_output( $highlight_date_list, $date )
          {
              echo '<td', in_array($date,$highlight_date_list) ?' style="color:red">'.$date.'</td>' :'>'.$date.'</td>';
          }

           

          $highlight_date_list = array( '03/04/09', '05/06,09' );

           

          echo '<table border=0>';
          while ($row = mysql_fetch_object($result)) {
              echo '<tr>';
              display_output( $row->date1 );
              display_output( $row->date2 );
              display_output( $row->date3 );
              echo '<tr>';
          }
          echo '</table>'; 

           

          CHECKMATE - PLAY with PROBLEMS



          From: metysoriano <metysoriano@...>
          To: phpexperts@yahoogroups.com
          Sent: Wednesday, March 4, 2009 11:48:07 AM
          Subject: [phpXperts] got trouble in highlighting searched record

          I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what colum it is.. my problem is this, I want to highlight its either changing color or change into fontsize the date 03/04/09, so that I could see immediately the date. Because if I can not highlight the search date I need to read each column where the date belongs to. I need to scroll right slowly, it takes time to read each row..

          Please help..

          Thank you so much


        • Mety Soriano
          I am using php sir.  where do I insert the variable..     METY  R. SORIANO IT Administrator Sacred Heart College 1 Merchan Street Lucena City, Quezon
          Message 4 of 8 , Mar 4, 2009
          • 0 Attachment
            I am using php sir. 
            where do I insert the variable..
             


             
            METY  R. SORIANO
            IT Administrator
            Sacred Heart College
            1 Merchan Street
            Lucena City, Quezon
            Philippines

            (+63)9282860545
            (042)3736167
            http://www.shc.edu.ph


            --- On Wed, 4/3/09, 9el <doctortomorrow@...> wrote:
            From: 9el <doctortomorrow@...>
            Subject: Re: [phpXperts] got trouble in highlighting searched record
            To: phpexperts@yahoogroups.com
            Date: Wednesday, 4 March, 2009, 3:15 PM

            a simple trick can be  setting a flag like  $searched=false;
            then  after the search use $searched=true
            if ($searched) {
            background-color= new color
            }

            You can either use JavaScript or PHP for this.


            ------------ --------- --------- --------- --------- --------- --------- -----
            Use FreeOpenSourceSoftw ares, Stop piracy, Let the developers live. Get
            a Free CD of Ubuntu mailed to your door without any cost. Visit :
            www.ubuntu.com
            ------------ --------- --------- --------- --------- --------- --------- ----


            On Wed, Mar 4, 2009 at 11:48 AM, metysoriano <metysoriano@ yahoo.com> wrote:
            I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what colum it is.. my problem is this, I want to highlight its either changing color or change into fontsize the date 03/04/09, so that I could see immediately the date. Because if I can not highlight the search date I need to read each column where the date belongs to. I need to scroll right slowly, it takes time to read each row..

            Please help..

            Thank you so much




            Get your new Email address!
            Grab the Email name you've always wanted before someone else does!
          • Mety Soriano
            this is my codes, im new in php   while ($row = mysql_fetch_array($checker_open))              {              echo ;
            Message 5 of 8 , Mar 4, 2009
            • 0 Attachment
              this is my codes, im new in php
               
              while ($row = mysql_fetch_array($checker_open)) 
                   
                    {
                    
                    echo "</tr>";
                     ?>
                      <!-- SECOND LINE -->    
                      <tr bgcolor="#EEEEEE">
                      <!-- SECOND LINE -->  
                      
                      <td><div align="center"><font face="Arial" size="2"><?php echo         
                      $row['sowno_source']; ?></font></div></td> 
                      
                      <td><div align="center"><font face="Arial" size="2"><?php echo         
                      $row['date_farrow']; ?></font></div></td> 
                      
                      <td><div align="center"><font face="Arial" size="2"><?php echo         
                      $row['iron']; ?></font></div></td> 
                      

               
              METY  R. SORIANO
              IT Administrator
              Sacred Heart College
              1 Merchan Street
              Lucena City, Quezon
              Philippines

              (+63)9282860545
              (042)3736167
              http://www.shc.edu.ph


              --- On Wed, 4/3/09, $@!ful™ <anm.saiful@...> wrote:
              From: $@!ful™ <anm.saiful@...>
              Subject: Re: [phpXperts] got trouble in highlighting searched record
              To: phpexperts@yahoogroups.com
              Date: Wednesday, 4 March, 2009, 4:34 PM

              You can try with this following code. I did not run it, so you may consider it as pseudo code.

              function display_output( $highlight_date_ list, $date )
              {
                  echo '<td', in_array($date, $highlight_ date_list) ?' style="color: red">'.$date.'</td>' :'>'.$date.'</td>';
              }

               

              $highlight_date_ list = array( '03/04/09', '05/06,09' );

               

              echo '<table border=0>';
              while ($row = mysql_fetch_ object($result) ) {
                  echo '<tr>';
                  display_output( $row->date1 );
                  display_output( $row->date2 );
                  display_output( $row->date3 );
                  echo '<tr>';
              }
              echo '</table>'; 

               

              CHECKMATE - PLAY with PROBLEMS



              From: metysoriano <metysoriano@ yahoo.com>
              To: phpexperts@yahoogro ups.com
              Sent: Wednesday, March 4, 2009 11:48:07 AM
              Subject: [phpXperts] got trouble in highlighting searched record

              I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what colum it is.. my problem is this, I want to highlight its either changing color or change into fontsize the date 03/04/09, so that I could see immediately the date. Because if I can not highlight the search date I need to read each column where the date belongs to. I need to scroll right slowly, it takes time to read each row..

              Please help..

              Thank you so much




              Get your preferred Email name!
              Now you can @... and @....
            • Arunjyoti Das
              Hello METY R. SORIANO , I think the following code will illustrate you how to change the background of the column which holds the date of the search-item.
              Message 6 of 8 , Mar 4, 2009
              • 0 Attachment
                Hello  METY  R. SORIANO ,

                I think the following code will illustrate you how to change the background of the column which holds the date of the search-item.

                Here I am testing "last_login" ,which is a date type of the user's last login with your searched date (i.e. $searchedItem).

                <?php
                        $query="select * from registration where 1";
                        $result=@mysql_query($query) or die(mysql_error());
                        while ($myrow = mysql_fetch_array($result))
                        {
                        $emails[]=$myrow["email"];
                        $fnames[]=$myrow["fname"];
                        $lnames[]=$myrow["lname"];
                        $states[]=$myrow["state"];
                        $store_ids[]=$myrow["store_id"];
                        $last_logins[]=$myrow["last_login"];
                        }
                        ?>
                        <!-- result area starts here -->
                        <?php for($i=0;$i<count($emails);$i++){?>
                            <div class="grid_title" id="result<?=$i?>" style="background-color:<?php if($last_logins[$i]==$searchItem)echo "#F8F8F8";else echo "white";?>">
                               
                                <div style="float:left;width:200px;"><?php echo $emails[$i];?>
                                </div>       
                                <div style="float:left;width:130px;"><?php echo $fnames[$i]." ".$lnames[$i];?>
                                </div>
                                <div style="float:left;width:90px;"><?php echo $last_logins[$i];?>
                                </div>
                                <div style="float:left;width:70px;">
                                    <?php echo $store_ids[$i];?>
                                </div>       
                                <div class="small"><?php if($states[$i]) echo $states[$i]; else echo "N/A";?>
                                </div>
                           
                               
                            </div>
                            <?php }?>
                        <!-- result area ends here -->

                Regards,
                Arunjyoti Das
                Guwahati,
                India

                From: Mety Soriano <metysoriano@...>
                To: phpexperts@yahoogroups.com
                Sent: Wednesday, 4 March, 2009 2:23:08 PM
                Subject: Re: [phpXperts] got trouble in highlighting searched record

                I am using php sir. 
                where do I insert the variable..
                 


                 
                METY  R. SORIANO
                IT Administrator
                Sacred Heart College
                1 Merchan Street
                Lucena City, Quezon
                Philippines

                (+63)9282860545
                (042)3736167
                http://www.shc. edu.ph


                --- On Wed, 4/3/09, 9el <doctortomorrow@ gmail.com> wrote:
                From: 9el <doctortomorrow@ gmail.com>
                Subject: Re: [phpXperts] got trouble in highlighting searched record
                To: phpexperts@yahoogro ups.com
                Date: Wednesday, 4 March, 2009, 3:15 PM

                a simple trick can be  setting a flag like  $searched=false;
                then  after the search use $searched=true
                if ($searched) {
                background-color= new color
                }

                You can either use JavaScript or PHP for this.


                ------------ --------- --------- --------- --------- --------- --------- -----
                Use FreeOpenSourceSoftw ares, Stop piracy, Let the developers live. Get
                a Free CD of Ubuntu mailed to your door without any cost. Visit :
                www.ubuntu.com
                ------------ --------- --------- --------- --------- --------- --------- ----


                On Wed, Mar 4, 2009 at 11:48 AM, metysoriano <metysoriano@ yahoo.com> wrote:
                I have 15 colums fields. Each column contains date. For example I want to search 03/04/09 date, then once it is on the row it will display regardless what colum it is.. my problem is this, I want to highlight its either changing color or change into fontsize the date 03/04/09, so that I could see immediately the date. Because if I can not highlight the search date I need to read each column where the date belongs to. I need to scroll right slowly, it takes time to read each row..

                Please help..

                Thank you so much




                Get your new Email address!
                Grab the Email name you've always wanted before someone else does!



                Add more friends to your messenger and enjoy! Invite them now.
              • $@!ful™
                Analyze the following script carefully. I hope it will help you.   After executing the script, if a highlighted date found in any row then the row’s
                Message 7 of 8 , Mar 4, 2009
                • 0 Attachment

                  Analyze the following script carefully. I hope it will help you.

                   

                  After executing the script, if a highlighted date found in any row then the row’s background color will be changed.

                   
                  function highlighted_date_exists( $higilight_date_list, $date_list )
                  {
                      foreach( $date_list as $date ) {
                          if( is_array( $date, $higilight_date_list ) ) {
                              return TRUE;
                          }
                      }
                      return FALSE;
                  }
                   
                  $higilight_date_list = array( '03/06/09', '03/08/09' );
                   
                  while( $row = mysql_fetch_array($checker_open) )
                  {
                      echo highlighted_date_exists( $higilight_date_list, array($row['sowno_ source'],$row['date_farrow' ],$row['iron']) ) ? '<tr bgcolor="#EEEEEE">': '<tr>';
                      echo '<td><div align="center"><font face="Arial" size="2">'.$row['sowno_ source'].'</font></div></td>';
                      echo '<td><div align="center"><font face="Arial" size="2">'.$row['iron'].'</font></div></td>';
                      echo '<td><div align="center"><font face="Arial" size="2">'.$row['sowno_ source'].'</font></div></td>';
                      echo '</tr>';
                  }
                  CHECKMATE - PLAY with PROBLEMS



                  From: Mety Soriano <metysoriano@...>
                  To: phpexperts@yahoogroups.com
                  Sent: Wednesday, March 4, 2009 2:59:34 PM
                  Subject: Re: [phpXperts] got trouble in highlighting searched record

                  this is my codes, im new in php
                   
                  while ($row = mysql_fetch_ array($checker_ open)) 
                       
                        {
                        
                        echo "</tr>";
                         ?>
                          <!-- SECOND LINE -->    
                          <tr bgcolor="#EEEEEE">
                          <!-- SECOND LINE -->  
                          
                          <td><div align="center"><font face="Arial" size="2"><?php echo         
                          $row['sowno_ source']; ?></font></div></td> 
                          
                          <td><div align="center"><font face="Arial" size="2"><?php echo         
                          $row['date_farrow' ]; ?></font></div></td> 
                          
                          <td><div align="center"><font face="Arial" size="2"><?php echo         
                          $row['iron'] ; ?></font></div></td> 
                          

                   
                  METY  R. SORIANO
                  IT Administrator
                  Sacred Heart College
                  1 Merchan Street
                  Lucena City, Quezon
                  Philippines

                  (+63)9282860545
                  (042)3736167
                  http://www.shc. edu.ph

                  .

                • Mety Soriano
                  Sorry SIr, it is still not running...   below is my whole codes, I do not know wat is lacking in my codes, I applied your codes, it was stack on is_array
                  Message 8 of 8 , Mar 8, 2009
                  • 0 Attachment
                    Sorry SIr, it is still not running...
                     
                    below is my whole codes, I do not know wat is lacking in my codes, I applied your codes, it was stack on is_array code..
                     
                    ****************************
                    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
                    <html xmlns="http://www.w3.org/1999/xhtml">
                    <head>
                    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
                    <title>Saving Record</title>
                    </head>
                    <body bgcolor="#ddffdd">
                    <table width="50%" border="0" align="center">
                      <tr>
                        <td>
                     <form name="mety" method="post" action="http://202.71.180.139/site07/testing/snhf/test.php" />
                    <input type="text" name="checker" />
                    <input type="submit" value="Check This Date" />
                    </form>
                     
                     </td>
                      </tr>
                    </table>

                    <?php
                     

                         $checker = $_POST['checker'];
                      $sowno_source = $_POST['sowno_source'];
                      $iron = $_POST['iron'];
                      $myco_lac = $_POST['myco_lac'];
                     if ($checker)
                     {
                      $dbaseconnect = mysql_connect("localhost","metysoriano","mety1124") or die ("Can not connect   Database");
                      mysql_select_db(snhf,$dbaseconnect) or die ("No database Found");

                      $save = "SELECT * FROM snhf_table WHERE iron = '$checker' OR myco_lac = '$checker' OR
                      castration = '$checker' OR iron_follow = '$checker' OR myco_follow = '$checker' OR vit_b =
                      '$checker' OR weaning = '$checker' OR nutrilac = '$checker' OR deworm = '$checker' OR
                      n_start = '$checker' OR hog_cho = '$checker' OR n_grow = '$checker' OR n_big = '$checker' OR   disposal = '$checker'";
                      
                      $checker_open = mysql_db_query(snhf,$save,$dbaseconnect);
                      
                       if ($checker_open)
                       
                       {   
                       ?>
                       <table width="225%" border="1" align="center">
                         <!-- FIRST LINE -->
                            <tr bgcolor="#DDDDDD">
                         <!-- FIRST LINE -->
                     
                            <td width="10%"><font face="Georgia" size="2"><div align="center">SOW # / SOURCE
                         </div></td>
                         
                         <td width="8%"><font face="Georgia" size="2"><div align="center">DATE FARROWED
                         </div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">IRON
                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(3)</div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">MYCOPLASMA /
                         LAC (7)</div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">CASTRATION (10)
                         </div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">IRON FOLLOW
                         (15)</div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">MYCO FOLLOW
                         (21)</div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">VIT_B&nbsp;
                         (25)</div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">WEANING (30)</
                         div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">N_LAC (36)
                         </div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">DEWORM (45)</
                         div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">N_START (55)</
                         div></td> 
                           
                         <td width="5%"><font face="Georgia" size="2"><div align="center">ANTI HOG CHO
                         (60)</div></td>
                            
                         <td width="5%"><font face="Georgia" size="2"><div align="center">N_GROW (90)</
                         div></td>
                           
                         <td width="5%"><font face="Georgia" size="2"><div align="center">N_BIG (120)</
                         div></td>
                         
                         <td width="5%"><font face="Georgia" size="2"><div align="center">DISPOSAL (150)
                         </div></td>
                         
                        <?php
                          
                          
                        while ($row = mysql_fetch_array($checker_open))
                        
                            {
                         
                              echo "</tr>";
                                ?>
                               <!-- SECOND LINE -->    
                               <tr bgcolor="#EEEEEE">
                               <!-- SECOND LINE --> 
                           
                         
                         <td><div align="center"><font face="Arial" size="4"><?php echo        
                               $row['sowno_source']; ?></font></div></td>
                           
                               <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['date_farrow' ]; ?></font></div></td>
                           
                               <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['iron'] ; ?></font></div></td>
                         
                           <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['myco_lac'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['castration'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['iron_follow'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['myco_follow'] ; ?></font></div></td>
                         
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['vit_b'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['weaning'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['nutrilac'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['deworm'] ; ?></font></div></td>
                       
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['n_start'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['hog_cho'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['n_grow'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['n_big'] ; ?></font></div></td>
                         
                         <td><div align="center"><font face="Arial" size="2"><?php echo        
                               $row['disposal'] ; ?></font></div></td>
                       
                       <?php
                       
                       }
                        ?>
                       </tr>
                       </table>
                       
                               
                       <?php
                        mysql_query($save);
                        mysql_close($dbaseconnect); 
                     
                      }
                      
                     
                     }
                     
                      
                     ?>
                    </body>
                    </html>
                    ************************************
                     


                     
                    METY  R. SORIANO
                    IT Administrator
                    Sacred Heart College
                    1 Merchan Street
                    Lucena City, Quezon
                    Philippines

                    (+63)9282860545
                    (042)3736167
                    http://www.shc.edu.ph


                    --- On Wed, 4/3/09, $@!ful™ <anm.saiful@...> wrote:
                    From: $@!ful™ <anm.saiful@...>
                    Subject: Re: [phpXperts] got trouble in highlighting searched record
                    To: phpexperts@yahoogroups.com
                    Date: Wednesday, 4 March, 2009, 6:25 PM

                    Analyze the following script carefully. I hope it will help you.

                     

                    After executing the script, if a highlighted date found in any row then the row’s background color will be changed.

                     
                    function highlighted_ date_exists( $higilight_date_ list, $date_list )
                    {
                        foreach( $date_list as $date ) {
                            if( is_array( $date, $higilight_date_ list ) ) {
                                return TRUE;
                            }
                        }
                        return FALSE;
                    }
                     
                    $higilight_date_ list = array( '03/06/09', '03/08/09' );
                     
                    while( $row = mysql_fetch_ array($checker_ open) )
                    {
                        echo highlighted_ date_exists( $higilight_date_ list, array($row[' sowno_ source'],$row[ 'date_farrow' ],$row['iron' ]) ) ? '<tr bgcolor="#EEEEEE">': '<tr>';
                        echo '<td><div align="center"><font face="Arial" size="2">'.$row['sowno_ source'].'</font></div></td>';
                        echo '<td><div align="center"><font face="Arial" size="2">'.$row['iron' ].'</font></div></td>';
                        echo '<td><div align="center"><font face="Arial" size="2">'.$row['sowno_ source'].'</font></div></td>';
                        echo '</tr>';
                    }
                    CHECKMATE - PLAY with PROBLEMS



                    From: Mety Soriano <metysoriano@ yahoo.com>
                    To: phpexperts@yahoogro ups.com
                    Sent: Wednesday, March 4, 2009 2:59:34 PM
                    Subject: Re: [phpXperts] got trouble in highlighting searched record

                    this is my codes, im new in php
                     
                    while ($row = mysql_fetch_ array($checker_ open)) 
                         
                          {
                          
                          echo "</tr>";
                           ?>
                            <!-- SECOND LINE -->    
                            <tr bgcolor="#EEEEEE">
                            <!-- SECOND LINE -->  
                            
                            <td><div align="center"><font face="Arial" size="2"><?php echo         
                            $row['sowno_ source']; ?></font></div></td> 
                            
                            <td><div align="center"><font face="Arial" size="2"><?php echo         
                            $row['date_farrow' ]; ?></font></div></td> 
                            
                            <td><div align="center"><font face="Arial" size="2"><?php echo         
                            $row['iron'] ; ?></font></div></td> 
                            

                     
                    METY  R. SORIANO
                    IT Administrator
                    Sacred Heart College
                    1 Merchan Street
                    Lucena City, Quezon
                    Philippines

                    (+63)9282860545
                    (042)3736167
                    http://www.shc. edu.ph
                    .



                    New Email addresses available on Yahoo!
                    Get the Email name you've always wanted on the new @ymail and @rocketmail.
                    Hurry before someone else does!
                  Your message has been successfully submitted and would be delivered to recipients shortly.