PHP日历显示几个

I am doing a week-by-week (24 hour calendar), this is going to be used to record what hours have been booked and on what days.

It's like a timetable with slots that you book. To ensure that booked and unbooked slots were different I put in PHP if statements to check the time against the database.

Problem being; I believe my if statements are only working for one row unlike a while statement that works over several. - so basically I want to be able to book more than one hour per day - and see more than one hour per day

(the database insert isn't a problem - displaying it on the calendar is)

I cannot do a while statement as I am unsure how I would structure my schedule/calendar with one.

Here is an my problem: http://postimage.org/image/gcb3x3fk3/ (if I booked 18:00 on Sep 9 - it wouldn't show)

$globalid is a global variable and is not held within the file/code below (but is included)

MY CODE

<div id="calendar">
<?
if(isset($_POST['add_week'])){
    $week = date('d-m-Y', strtotime($_POST['last_week']));
    $new_week =  strtotime ( '+1 week' , strtotime ( $week ) ) ;
    $new_week = date('d-m-Y', $new_week);


    $week_number = date("W", strtotime( $new_week));
    $year = date("Y", strtotime( $new_week));
}else if(isset($_POST['back_week'])){
    $week = date('d-m-Y', strtotime($_POST['last_week']));
    $new_week =  strtotime ( '-1 week' , strtotime ( $week ) ) ;
    $new_week = date('d-m-Y', $new_week);


    $week_number = date("W", strtotime( $new_week));
    $year = date("Y", strtotime( $new_week));
}else{

$week_number = date("W");
$year = date("Y");
}
/*if($week_number < 10){
   $week_number = "0".$week_number;
}*/
$week_start = date('d-m-Y', strtotime($year."W".$week_number,0));
?>

<table name="week" width="100%" cellspacing="0" cellpadding="0" height="13">
    <tr>
<?
for($day=1; $day<=7; $day++)
{
?>
<tr>
<td class="day">
<?
$daycal = date('d M', strtotime($year."W".$week_number.$day))."";
echo $daycal;
?>
</td>
<td width="3"> </td>
<td>
<!-- Timetable -->
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td>
<?
// Do not edit Below
$cal = mysql_query("SELECT * FROM `calendar` WHERE `day`='$daycal' && `userid`='$globalid'")or die(mysql_error());
$calendar = mysql_fetch_array($cal);
?>
<div class="hour" name="00:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="00:00"){ 
?>
Booked
<? }else{ ?>
00:00
<? } ?>
</div>
<div class="hour" name="01:00" id="<? echo $daycal; ?>">
<?
if($calendar2['time']=="01:00"){ 
?>
Booked
<? }else{ ?>
01:00
<? } ?>
</div>
<div class="hour" name="02:00" id="<? echo $daycal; ?>">
<?
if($calendar3['time']=="02:00"){ 
?>
Booked
<? }else{ ?>
02:00
<? } ?>
</div>
<div class="hour" name="03:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="03:00"){ 
?>
Booked
<? }else{ ?>
03:00
<? } ?>
</div>
<div class="hour" name="04:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="04:00"){ 
?>
Booked
<? }else{ ?>
04:00
<? } ?>
</div>
<div class="hour" name="05:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="05:00"){ 
?>
Booked
<? }else{ ?>
05:00
<? } ?>
</div>
<div class="hour" name="06:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="06:00"){ 
?>
Booked
<? }else{ ?>
06:00
<? } ?>
</div>
<div class="hour" name="07:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="07:00"){ 
?>
Booked
<? }else{ ?>
07:00
<? } ?>
</div>
<div class="hour" name="08:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="08:00"){ 
?>
Booked
<? }else{ ?>
08:00
<? } ?>
</div>
<div class="hour" name="09:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="09:00"){ 
?>
Booked
<? }else{ ?>
09:00
<? } ?>
</div>
<div class="hour" name="10:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="10:00"){ 
?>
Booked
<? }else{ ?>
10:00
<? } ?>
</div>
<div class="hour" name="11:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="11:00"){ 
?>
Booked
<? }else{ ?>
11:00
<? } ?>
</div>
<div class="hour" name="12:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="12:00"){ 
?>
Booked
<? }else{ ?>
12:00
<? } ?>
</div>
<div class="hour" name="13:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="13:00"){ 
?>
Booked
<? }else{ ?>
13:00
<? } ?>
</div>
<div class="hour" name="14:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="14:00"){ 
?>
Booked
<? }else{ ?>
14:00
<? } ?>
</div>
<div class="hour" name="15:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="15:00"){ 
?>
Booked
<? }else{ ?>
15:00
<? } ?>
</div>
<div class="hour" name="16:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="16:00"){ 
?>
Booked
<? }else{ ?>
16:00
<? } ?>
</div>
<div class="hour" name="17:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="17:00"){ 
?>
Booked
<? }else{ ?>
17:00
<? } ?>
</div>
<div class="hour" name="18:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="18:00"){ 
?>
Booked
<? }else{ ?>
18:00
<? } ?>
</div>
<div class="hour" name="19:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="19:00"){ 
?>
Booked
<? }else{ ?>
19:00
<? } ?>
</div>
<div class="hour" name="20:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="20:00"){ 
?>
Booked
<? }else{ ?>
20:00
<? } ?>
</div>
<div class="hour" name="21:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="21:00"){ 
?>
Booked
<? }else{ ?>
21:00
<? } ?>
</div>
<div class="hour" name="22:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="22:00"){ 
?>
Booked
<? }else{ ?>
22:00
<? } ?>
</div>
<div class="hour" name="23:00" id="<? echo $daycal; ?>">
<?
if($calendar['time']=="23:00"){ 
?>
Booked
<? }else{ ?>
23:00
<? } ?>
</div>
</td></tr>
</table>

<!-- End Timetable -->
</td>
</tr>
<tr height="3"><td> </td></tr>
<?
}
?>
</tr>
<tr>
<form name="move_weeks" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="last_week" value="<? echo $week_start; ?>" />
<td colspan="7"><input type="submit" name="back_week" value="back_week" /><input type="submit" name="add_week" value="add_week" />
</td>
</form>
</tr>
</table>
</div>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

drt12345678 2012-09-08 10:52

关注

So huge and useless code.. Why not to loop through and from 100 lines of code have only 10? I tried to reorganize your code. So finally i have this one:

<div id="calendar">
<?php
    $week = date('d-m-Y', strtotime($_POST['last_week']));

    if(isset($_POST['add_week']))
        $new_week =  strtotime ( '+1 week' , strtotime ( $week ) ) ;
    if(isset($_POST['back_week']))
        $new_week =  strtotime ( '-1 week' , strtotime ( $week ) ) ;

    $new_week = date('d-m-Y', $new_week);

    if(!isset($_POST['add_week']) && !isset($_POST['back_week']))
    {
        $week_number = date("W");
        $year = date("Y");
    }
    else
    {
        $week_number = date("W", strtotime( $new_week));
        $year = date("Y", strtotime( $new_week));
    }

    $week_start = date('d-m-Y', strtotime($year."W".$week_number,0));
?>

<table name="week" width="100%" cellspacing="0" cellpadding="0" height="13">
    <tr>
<?
for($day=1; $day<=7; $day++)
{
?>
<tr>
    <td class="day">
        <?=$daycal = date('d M', strtotime($year."W".$week_number.$day))."";?>
    </td>

    <td width="3"> </td>
    <td>
    <!-- Timetable -->
    <table width="100%" cellspacing="0" cellpadding="0" height="13">
        <tr>
            <td>
            <?
                // Do not edit Below
                $cal = mysql_query("SELECT * FROM `calendar` WHERE `day`='$daycal' && `userid`='$globalid'")or die(mysql_error());
                $calendar = mysql_fetch_array($cal);

                for($cnt=0; $cnt<=24; $cnt++)
                { 
                    $hour = ($cnt<10?'0':'').$cnt.':00';
            ?>
                <div class="hour" name="<?=$hour?>" id="<? echo $daycal; ?>">
                    <?= ($calendar['time']==$hour) ? 'Booked' : $hour;  ?>
                </div>
            <? 
                } 
            ?>
            </td>
        </tr>
    </table>
    <!-- End Timetable -->
    </td>
</tr>
<tr height="3">
    <td> </td>
</tr>
<?
}
?>
</tr>
<tr>
    <form name="move_weeks" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
        <input type="hidden" name="last_week" value="<? echo $week_start; ?>" />
        <td colspan="7">
            <input type="submit" name="back_week" value="back_week" />
            <input type="submit" name="add_week" value="add_week" />
        </td>
    </form>
</tr>
</table>
</div>

报告相同问题？

关注问题

vue日历组件显示一年中的第几周 elementui
2021-12-28 02:05

回答 2 已采纳这个只能自己写一个了，然后添加一个鼠标悬停事件onmouseover然后你移到的那个数字除七取整就可以获取到第几周了
今日日历以红色显示 php
2018-05-22 12:15

回答 1 已采纳 <table border="1"> <?php date_default_timezone_set('Europe/Stockholm');
显示全天活动的完整日历 jquery php
2017-09-03 04:45

回答 1 已采纳 I found the issue about allDay. There is a conflict between your use of start / end and allDay.
如何为WordPress创建Google日历插件
2020-06-20 23:17

cunjie3951的博客无论利基市场如何，向您的WordPress网站添加日历插件都是提高用户参与度和... 在本教程中，我将向您展示如何使用Google Calendar API快速创建一个WordPress日历插件，该插件可以显示任何可公开访问的Google日历中...
PHP：DatePicker /日历不显示 jquery php
2013-06-15 18:05

回答 2 已采纳 Thats because you are calling jquery two times in sample.php. Either remove <script src="http
php日历上一个按钮不断递增 php
2014-08-04 08:19

回答 3 已采纳 here is your complete working code <?php $current_month = date("n"); $month = (isset($_GET['m
404问题去年的时候 - php日历 php
2019-07-08 17:48

回答 1 已采纳 Since you're on Wordpress, it seems like you're using reserved terms for $_GET variables: https://
前端日历添加记事功能_通过添加实验室功能从Google日历中获取更多信息
2020-09-29 23:11

cuma1988的博客前端日历添加记事功能Recently we took a look at how you can take Gmail further by enabling some of the extra features that are available in the experimental Labs section. If you use Google Calendar to ...
当我去下个月时，日历中缺少几个月 html javascript php
2019-01-29 07:17

回答 1 已采纳 You are correct that the problem stems from the available number of days in the next month. Since
基于php周的日历月初 php
2018-06-05 08:05

回答 1 已采纳 don't show number 03 because this code elseif ($daysnumber>=$today){ echo"<td bgcolor='
如何使用php phalcon日历检索数据 database php
2016-07-21 05:39

回答 1 已采纳 Your archivesAction takes a parameter $date which you aren't using. You are basically querying al
iphone 日历事件消失_如何在iPhone和iPad上从邮件创建日历事件
2020-09-02 15:24

culiuman3228的博客 iphone 日历事件消失Khamosh Pathak Khamosh Pathak If you receive an email that includes a date and time, the Mail app on your iPhone or iPad can recognize it as an appointment request. Here’s how to ...
在PHP日历上显示事件 mysql php
2010-04-08 18:16

回答 1 已采纳 Assuming you've got a $year and $month variable already precomputed for displaying the calendar gr
整理了几个经常访问的Qt知名社区
2022-01-06 22:14

李肖遥的博客关注、星标公众号，直达精彩内容来源：技术让梦想更伟大作者：李肖遥qt是一个跨平台C++图形用户界面应用程序开发框架，可以做很多东西，应用也很广泛，初学者来说怎么快速去了解入门呢？我...
CodeCanyon上有20个有用的PHP框架
2020-06-13 03:54

cunjie3951的博客 “没有理由重新发明轮子。” 重塑不仅浪费时间已经存在的东西，而且通常也注定要失败。 Web开发也可以这样说。这就是为什么使用框架对于项目... 因此，让我们看一下Envato Market上可用的20个有用的PHP框架。 ...
没有解决我的问题, 去提问

悬赏问题

¥15 基于卷积神经网络的声纹识别
¥15 Python中的request，如何使用ssr节点，通过代理requests网页。本人在泰国，需要用大陆ip才能玩网页游戏，合法合规。
¥100 为什么这个恒流源电路不能恒流？
¥15 有偿求跨组件数据流路径图
¥15 写一个方法checkPerson，入参实体类Person，出参布尔值
¥15 我想咨询一下路面纹理三维点云数据处理的一些问题，上传的坐标文件里是怎么对无序点进行编号的，以及xy坐标在处理的时候是进行整体模型分片处理的吗
¥15 CSAPPattacklab
¥15 一直显示正在等待HID—ISP
¥15 Python turtle 画图
¥15 stm32开发clion时遇到的编译问题

码龄粉丝数原力等级 --

PHP日历显示几个

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

PHP日历显示几个

1条回答 默认 最新

悬赏问题

1条回答默认最新