[TRIM not working in my PHP Code while uploading CSV]

Thank you very much works like charm

[TRIM not working in my PHP Code while uploading CSV]

CSV file not uploading it says not allowed to upload

 

while fetching the table after uploading it shows me the special character where the white space and it was not removing the blank lines in the CSV file also

 

Not only problem with blank lines I have problem also with space before or after any field

 

while uploading CSV  file its shows me 

• report.csv

  You aren't permitted to upload this kind of file

 

[TRIM not working in my PHP Code while uploading CSV]

Hello

 

I am Importing CSV file using PHP but it imports with blank lines and white spaces 

 

please guide how to recover this 

 

 

i am attaching both files for reference

 

awaiting your valuable reply

dayseatchart.php

[Reading From htm file and saving in mysql table using php]

Hello

 

Is it possible to save data from saved htm table from other website in our mysql database system

 

as I have problem that there is one htm page where i can get data but i want to save it in mysql table. as data is large on htm page 

it was hard to copy so i want access it direct from php and save it in mysql table

 

please guide

 

awaiting your valuable reply.

 

Thank in advance

[Uploading XML to MYSQL using PHP]

Thank you Sir

i will try

[Uploading XML to MYSQL using PHP]

Hello

 

I want to know to upload the XML file to mysql using php as i am new to xml any help appreciated.

 

awaiting your valuable reply

here also i am attaching the xml file which i want to upload

 

 

Thanks in Advance

xml1.xml

[PHP and Crystal Report]

Hello

I want to know that should we connect the crystal report with php.

If yes then I want an example how to use that one with php which showing that selecting a particular user and showing its related information through crystal report. 

 

awaiting your valuable reply.

[Crystal Report and Php]

Hello

I want to know that should we connect the crystal report with php.

If yes then I want an example how to use that one with php which showing that selecting a particular user and showing its related information through crystal report. 

 

awaiting your valuable reply.

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

Thank you very much   SIR  all done 

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

Thank you very much all done 

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

Thanks sir working now but shows an notice undefined index which defined in switch statement 

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

thats run much pretty but i want to display it with staffname not by date i changed it $present[$d]++; to $present[$sn]++; it runs but not showing on the same line as staffname

 

awaiting your valuable reply

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

thank you very much sir

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

yes sir absent and present on each date

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

Sir please guide how to calculate number presents and absent

 

awaiting your valuable reply

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

Thanks it works as expected

[Pivot Table or Cross Tab in PHP using MYSQL for attendance]

Hello

 

I want to create attendance sheet on which date are printed as column and name of student/staff as column

database is as shown

CREATE TABLE IF NOT EXISTS `attendance` (
  `date` varchar(500) DEFAULT NULL,
  `time` varchar(1000) DEFAULT NULL,
  `staffname` varchar(1000) DEFAULT NULL,
  `id` int(11) DEFAULT NULL,
  `role` varchar(1000) NOT NULL,
  `status` varchar(1) DEFAULT NULL
)

but when I querying the table repeating the names of student and staff which not gives me report as expected here I attaching code also

 <table align="letf"  style="margin-left: 0px; border: 1px solid black; border-spacing: 0px;"  width="8"> 
        <th style="border: 1px solid black; text-align: center;">Date</th>
        <?php
         $sql133="select distinct date from attendance";
       $sql_row133=mysqli_query($dbConn,$sql133);       
       while($sql_res133=mysqli_fetch_assoc($sql_row133))       {

       $date=$sql_res133["date"];
             ?>         
       <th style="border: 1px solid black; text-align: center;">
       <?php echo $date;  ?>
   </th>
                <?php 
           
      $a=$date;
                $sql13="     
  SELECT   atten.date,atten.time,atten.staffname,atten.id, atten.status, supst.id, supst.staffname
    FROM
     (examcenter.attendance atten INNER JOIN examcenter.supportstaff supst ON
         atten.id = supst.id) where atten.date='$a'    group by supst.staffname,supst.id ORDER BY
    atten.id ASC    ";
                 $sql_row13=mysqli_query($dbConn,$sql13);
             while($sql_res13=mysqli_fetch_assoc($sql_row13))      {

             $staffname=$sql_res13["staffname"];
         $status=$sql_res13["status"];
                                       ?>
        
        <tr>
           <td><?php echo $staffname; ?></td>
        <td><?php echo $status; ?></td>
       
    <?php
       }
       }
      
     ?>
    
</table>

please guide what do to create a report as expected

 

Name/Date

 12-11-2013         

13-11-2013 16-11-2013 Student name1 P             A A Staffname 1 P P A

awaiting valuable reply