akshayhomkar

Thank you very much works like charm

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.csvYou aren't permitted to upload this kind of file

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

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

Thank you Sir i will try

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

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.

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.

Thank you very much SIR all done

Thank you very much all done

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

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

thank you very much sir

yes sir absent and present on each date

Sir please guide how to calculate number presents and absent awaiting your valuable reply

Thanks it works as expected

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