Jump to content


Photo

Date sheet population


  • Please log in to reply
9 replies to this topic

#1 ankycooper

ankycooper
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 25 September 2006 - 02:43 PM

hi i have a database in which there are following fields
name
month
startdate
enddate
starttime
endtime
wf1
wf2
wf3

lets take a sample data
jay peter
march
2006-09-03
2006-09-24
07:00
16:00
Saturday
Sunday
NA

there are sevral such records

i want to populate a table like this (see the attachment)

Need some help




[attachment deleted by admin]

#2 steveclondon

steveclondon
  • Members
  • PipPipPip
  • Advanced Member
  • 161 posts

Posted 25 September 2006 - 04:45 PM

Do you mean export to excel or just display in the browser in a table.

#3 ankycooper

ankycooper
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 25 September 2006 - 05:57 PM

Populate as a table in the browser

Please Help

#4 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 25 September 2006 - 06:35 PM

You just need to output 2 HTML table rows for each record in the db table
<tr><td rowspan='2'>$date</td> <td rowspan='2'>$day</td> <td>Office reporting</td> <td>$time1</td></tr>
<tr>                                                     <td>Office departing</td> <td>$time2</td></tr>

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#5 craygo

craygo
  • Staff Alumni
  • Advanced Member
  • 1,973 posts
  • LocationRhode Island

Posted 25 September 2006 - 06:57 PM

Try this
<table width=800 align=center border=1>
  <tr>
    <td width=150>Date</td>
    <td width=150>Day</td>
    <td width=300>Time</td>
<?php
$sql = "SELECT * FROM table_name";
  $res = mysql_query($sql) or die (mysql_error());
  $r = mysql_fetch_assoc($res);
  echo "<td width=200>".$r['name']."</td></tr>";
  $days = (date("j", strtotime($r['enddate'])) - date("j", strtotime($r['startdate']))) + 1;
  $startdate = date("Y-m-d", strtotime($r['startdate']));
  for($i=0; $i<$days; $i++){
    $day = date("D", strtotime($startdate));
    $fullday = date ("l", strtotime($startdate));
      if($fullday == $r['wf1'] || $fullday == $r['wf2'] || $fullday == $r['wf3']){
        $st_time = "WOFF";
        $e_time = "WOFF";
      } else {
        $st_time = $r['starttime'];
        $e_time = $r['endtime'];
      }
    echo "<tr>";
    echo "<td rowspan=2>$startdate</td>";
    echo "<td rowspan=2>$day</td>";
    echo "<td>Start time</td>";
    echo "<td>$st_time</td>";
    echo "</tr>";
    echo "<tr>";
    echo "<td>End Time</td>";
    echo "<td>$e_time</td>";
    echo "</tr>";
    $startdate = date("Y-m-d", strtotime("$startdate +1 day"));
  }
  echo "</table>";
?>

Ray

#6 ankycooper

ankycooper
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 25 September 2006 - 07:01 PM

Still No Good

Does Any one Knows How To Do It

#7 craygo

craygo
  • Staff Alumni
  • Advanced Member
  • 1,973 posts
  • LocationRhode Island

Posted 25 September 2006 - 07:03 PM

Works fine for me based on your info up top.

Ray

#8 ankycooper

ankycooper
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 27 September 2006 - 11:08 AM

This Code Works For ME But it only shows the 1st record and does not populate all of them

<html>
<link rel="stylesheet" type="text/css" href="../scripts/main.css" >
<head>
<title>Roster Management System</title>
</head>

<body bgcolor="#C7E1F4">
<div align="center">
  <center>

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" bgcolor="#EEEEEE">
  <tr style="font-size: 12px; color: #ffffff; font-family: Arial, Helvetica, sans-serif">
    
    <td class="info" style='border:1px solid #C7E1F4; background-color: #2955B5' width="100" height="1">
    <p align="left"><b><font color='#FFFFFF'>&nbsp;Date&nbsp;&nbsp;</font></b></td>
	<td class="info" style="border:1px solid #C7E1F4; background-color: #2955B5" width="65" height="1">
    <p align="left"><b><font color='#FFFFFF'>&nbsp;Day&nbsp;&nbsp;</font></b></td>
	<td class="info" style="border:1px solid #C7E1F4; background-color: #2955B5" width="100" height="1">
    <p align="left"><b><font color='#FFFFFF'>&nbsp;Time&nbsp;&nbsp;</font></b></td>

<?php
function dateconvert($date,$func) {
		if ($func == 1){ //insert conversion
			list($day, $month, $year) = split('[/.-]', $date); 
			$date = "$year-$month-$day"; 
			return $date;
		}
		if ($func == 2){ //output conversion
			list($year, $month, $day) = split('[-.]', $date); 
			$date = "$day/$month/$year"; 
			return $date;
		}
}

$mmyy=$_GET['mmyy'];

include '../config/dbinfo.inc.php';
@mysql_connect($host,$user_name,$pass_word);
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT * FROM emproster where mmyy='$mmyy'";
 $sql = "SELECT * FROM emproster where mmyy='$mmyy'";
  $res = mysql_query($sql) or die (mysql_error());
  $r = mysql_fetch_assoc($res);
  echo "<td class='info' style='border:1px solid #C7E1F4; background-color: #2955B5' width='150' height='1'>
    <p align='left'><b><font color='#FFFFFF'>&nbsp;".$r['name']."</font></b></td>";
	 echo "</tr>";
  $days = (date("j", strtotime($r['edate'])) - date("j", strtotime($r['sdate']))) + 1;
  $sdate = date("Y-m-d", strtotime($r['sdate']));
  for($i=0; $i<$days; $i++){
    $day = date("D", strtotime($sdate));
    $fullday = date ("l", strtotime($sdate));
      if($fullday == $r['wf1'])
		  {
        $st_time = "<span style='background-color: #FF0000'><b><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WOFF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b></span>";
        $e_time = "<span style='background-color: #FF0000'><b><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WOFF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b></span>";
      } 

	  elseif($fullday == $r['wf2'])
		  {
         $st_time = "<span style='background-color: #FF0000'><b><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WOFF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b></span>";
        $e_time = "<span style='background-color: #FF0000'><b><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WOFF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b></span>";
      } 
	  elseif($fullday == $r['wf3']){
        $st_time = "<span style='background-color: #FF0000'><b><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WOFF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b></span>";
        $e_time = "<span style='background-color: #FF0000'><b><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WOFF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></b></span>";
      } 
	  else {

        $st_time = "<b><font color='#2955B5'><span style='background-color: #FFFF99'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;".$r['stime']."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></font></b>";
        $e_time = "<b><font color='#2955B5'><span style='background-color: #CCFF99'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;".$r['etime']."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></font></b>";
      }
	  $sdate=dateconvert($sdate, 1);
	  echo "<tr>";
   
	echo "<td class='back2' style='border:1px solid #C7E1F4; background-color: #CED7EF' rowspan=2><b><font color='#2955B5'>&nbsp;$sdate</b></font></td>";
    echo "<td class='back2' style='border:1px solid #C7E1F4; background-color: #CED7EF' rowspan=2><b><font color='#2955B5'>&nbsp;$day</b></font></td>";
    echo "<td class='back2' style='border:1px solid #C7E1F4; background-color: #CED7EF'><b><font color='#2955B5'>&nbsp;Report Time</b></font></td>";
    echo "<td class='back2' style='border:1px solid #C7E1F4; background-color: #CED7EF'>$st_time</td>";
    echo "</tr>";
    echo "<tr>";
   
	echo "<td class='back2' style='border:1px solid #C7E1F4; background-color: #CED7EF'><b><font color='#2955B5'>&nbsp;Drop Time</b></font></td>";
    echo "<td class='back2' style='border:1px solid #C7E1F4; background-color: #CED7EF'>$e_time</td>";
    echo "</tr>";
    $sdate = date("Y-m-d", strtotime("$sdate +1 day"));
  }
  echo "</table>";
?>


  </center></div>


#9 ankycooper

ankycooper
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 01 October 2006 - 07:50 AM

Please Help

#10 ankycooper

ankycooper
  • Members
  • PipPipPip
  • Advanced Member
  • 32 posts

Posted 01 October 2006 - 03:54 PM

I Think no one is a real Guru Who can solve this




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users