0

Hi Friends ,

I am new to PHP . I have designed a page and using MySQL at backend .
On my page , I have following logic .
1. There are 4 checkboxes and a search button .
2. On the basis of selection of checkboxes when user clicks search button then results are displayed on the same page in a table . My problem is when user selects only one checkbox , layout of page looks fine but when user selects more than 1 checkbox layout gets disorted , although the no. of records in both cases (single check box and multiple check boxex) are same . Also in the results table at last row , I will put a hyperlink which will export the results to excel . All the data is coming fine in both the cases . Problem is only with the layout when more than one checkbox is selected .

Please help . Pasting my code below :

<body>
<form id="form1" name="form1" method="post" action="ds_my_tickets_continue.php">
<table width="88%" align="center" bgcolor="#9CB7AK"> <!-- outermost main table-->
  <tr style="border:1px solid #F00;">
    <td height="27" colspan="2" align="right" >  
    <?php echo '<a href="login_success.php?user='.$userid.' "><img src="images/home.jpg" width="30" height="21" alt="home" /></a>'; ?><?php echo "Welcome ," .$userid ; ?> <input type="submit" name="logout" id="logout" value="Logout" onclick="form.action = 'logout.php';" />
    </td>
  </tr>
  <tr>
    <td height="106" colspan="2" style="border:1px solid  #FFF;">

       <?php

          if($mess != '') {


           echo "<SCRIPT>
              alert('$mess');
           </SCRIPT>";


           }

           $temp_date1 = $_POST['date5'];
           $temp_date2 = $_POST['date6'];

         ?>

    </td>
  </tr>
  <tr valign="top">
    <td width="16%" height="653" style=" border-left:1px solid  #FFF;" align="center"><p>Main Menu</p>
      <table width="84%"> <!-- Menu Table -->
        <tr align="left">
          <td width="13%">1.</td>
          <td width="87%"><?php echo '<a href="cr_ticket.php?user='.$userid.' ">Create Ticket</a>' ; ?></td>
        </tr>
        <tr align="left">
          <td>2.</td>
          <td><?php echo '<a href="ed_tickets.php?user='.$userid.'">Edit tickets</a>' ; ?></td>
        </tr>
        <tr align="left">
          <td>3.</td>
          <td><?php echo '<a href="ds_my_tickets.php?user='.$userid.'">Display My tickets</a>' ; ?></td>
        </tr>
        <tr align="left">
          <td>4.</td>
          <td><?php echo '<a href="ds_all_tickets.php?user='.$userid.'">Display All tickets</a>' ; ?></td>
        </tr>
      </table>  <!-- Menu Table -->
    <p> </p></td>
    <td width="84%" style=" border-left:1px solid   #FFF;"> 

      <table width="86%" height="23" align="center" bgcolor="#C4D9CB"> <!--Searching table-->
            <tr>
              <td width="18%">Search :</td>
              <td width="3%">Date</td>
              <td width="33%">
              <label for="date1">
              <?php

              //get class into the page
              require_once('classes/tc_calendar.php');


            $myCalendar = new tc_calendar("date5", true, true);
            //$myCalendar->setIcon("calendar/images/iconCalendar.gif"); 
             $myCalendar->setIcon("images/iconCalendar.gif");  
            $myCalendar->setDate(1,1,2013);   
            // $myCalendar->setPath("calendar/");    
             $myCalendar->setYearInterval(2000, 2015);    
            $myCalendar->dateAllow('2008-05-13', '2015-03-01');   
            $myCalendar->setDateFormat('j F Y');      
            $myCalendar->setAlignment('left', 'bottom');      
            $myCalendar->setSpecificDate(array("2011-04-01", "2011-04-04", "2011-12-25"), 0, 'year');     
            //$myCalendar->setSpecificDate(array("2011-04-10", "2011-04-14"), 0, 'month');    
            $myCalendar->setSpecificDate(array("2011-06-01"), 0, '');      
             //output the calendar
            $myCalendar->writeScript(); 
            $sel_date = $myCalendar->getDate();

      ?>

              </label></td>
              <td width="5%"> TO</td>
              <td width="41%">

              <label for="date2">
              <?php

              //get class into the page
              require_once('classes/tc_calendar.php');


            $myCalendar = new tc_calendar("date6", true, true);
            //$myCalendar->setIcon("calendar/images/iconCalendar.gif"); 
             $myCalendar->setIcon("images/iconCalendar.gif");  
            $myCalendar->setDate1(1,1,2013);      
            // $myCalendar->setPath("calendar/");    
             $myCalendar->setYearInterval(2000, 2015);    
            $myCalendar->dateAllow('2008-05-13', '2015-03-01');   
            $myCalendar->setDateFormat('j F Y');      
            $myCalendar->setAlignment('left', 'bottom');      
            $myCalendar->setSpecificDate(array("2011-04-01", "2011-04-04", "2011-12-25"), 0, 'year');     
            //$myCalendar->setSpecificDate(array("2011-04-10", "2011-04-14"), 0, 'month');    
            $myCalendar->setSpecificDate(array("2011-06-01"), 0, '');      
             //output the calendar
            $myCalendar->writeScript(); 
            $sel_date = $myCalendar->getDate();

      ?>

              </label></td>
            </tr>
            <tr>
              <td><label>
                <input type="checkbox" name="ch_status[2]" value="New" id="ch_status_2" />
                New</label></td>
              <td> </td>
              <td> </td>
              <td> </td>
              <td> </td>
            </tr>
            <tr>
              <td><label>
                <input type="checkbox" name="ch_status[0]" value="In Process" id="ch_status_0" />
                In Process</label></td>
              <td> </td>
              <td> </td>
              <td> </td>
              <td> </td>
            </tr>
            <tr>
              <td><label>
                <input type="checkbox" name="ch_status[1]" value="Confirmed" id="ch_status_1" />
                Confirmed</label></td>
              <td> </td>
              <td> </td>
              <td> </td>
              <td> </td>
            </tr>
            <tr>
              <td><label>
                <input type="checkbox" name="ch_status[3]" value="Customer Action" id="ch_status_3"  checked="checked"/>
                Customer Action</label></td>
              <td> </td>
              <td> </td>
              <td> </td>
              <td> </td>
            </tr>
            <tr>
              <td><input type="submit" name="search" id="search" value="Search" onclick="form.action = 'ds_my_tickets_continue.php?user=<?php echo $userid ?>';"/></td>
              <td> </td>
              <td> </td>
              <td> </td>
              <td> </td>
            </tr>
          </table> <!--Searching table-->
      <p></p>

<table width="86%" align="center" bgcolor="#C4D9CB">

            <tr >
              <td width="4%" style="border:1px solid  #FFF;">TId</td>
              <td width="7%" style="border:1px solid  #FFF;">Date</td>
              <td width="9%" style="border:1px solid  #FFF;">Status</td>
              <td width="11%" style="border:1px solid  #FFF;">Priority</td>
              <td width="13%" style="border:1px solid  #FFF;">Created By</td>
              <td width="18%" style="border:1px solid  #FFF;">Description</td>
              <td width="12%" style="border:1px solid  #FFF;">Close Date</td>
              <td width="11%" style="border:1px solid  #FFF;">Assigned to</td>
              <td width="15%" style="border:1px solid  #FFF;">Category</td>     
            </tr>
            <?php
             include 'data_selection.php' ;


          require_once("excelwriter.class.php");
           $excel=new ExcelWriter("billreport.xls");
          if($excel==false) 
            echo $excel->error;

            $myArr=array("");
            $myArr=array("Product Report");
            $excel->writeLine($myArr);
            $myArr=array("");
            $excel->writeLine($myArr);
            $myArr=array("ticket id","Description","date","Assigned to");
            $excel->writeLine($myArr);
            $from=$_POST['from'];
            $to=$_POST['to'];


        if(is_array($_POST['ch_status'])){
            foreach ($_POST['ch_status'] as $id)
            {

                $query  = "SELECT * FROM master_ticket WHERE status = '$id' and date >= '$temp_date1' and date <= '$temp_date2'";
               $result = mysql_query($query) ; // or die(mysql_error()); 

               do { ?>
              <tr >
                <td style="border:1px solid  #FFF;"><?php echo $row['tid']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['date']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['status']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['priority']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['createdby']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['desc']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['closedate']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['assignedto']; ?></td>
                <td style="border:1px solid  #FFF;"><?php echo $row['categ'];?> </td> <?php $myArr=array($row_rs_ds_my_tickets['tid'],$row_rs_ds_my_tickets['desc'],$row_rs_ds_my_tickets['date'],$row_rs_ds_my_tickets['assignedto']);
        $excel->writeLine($myArr);?>
              </tr>
  <?php } while ($row = mysql_fetch_assoc($result)); ?>

          </table>


            <?php   
            }} // forech($_POST['ch_status'] as $id) ?>


    <p> </p> </td>

  </tr>
  <tr>
    <td height="21" colspan="2" style="border:1px solid  #FFF;" align="right"><b>Designed By : Achal Mehra</b></td>
  </tr>
</table> <!-- outermost main table-->
  </form > 
</body>
2
Contributors
2
Replies
38
Views
4 Years
Discussion Span
Last Post by amehra2013
0

I am new to PHP . I have designed a page and using MySQL at backend .

Is this code related to datepicker?

0

Hi LastMitch ,

Yes code is realted to date picker .
I am using one Java script to show a calendr to user where he picks date
and selects the checkboxes and then database is searched to show the results

Edited by amehra2013

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.