当 while 循环和行变量满足条件时,如何循环它们
How do I loop through the while loop and through row variables when they meet a condition?
PHP - MySQL - Javascript
我有一个javascript手风琴,我想用基于MySQL查询的数据填充它。手风琴的示例(现在已手动更新(可在此处获得: http://www.vi-athletics.com/schedules/mens-soccer-schedule-2013-14?id=56
我已经编写了一些代码(请参阅它在 http://www.vi-athletics.com/schedules/mens-soccer-schedule-2013-14?id=55 的作用(,但是,我不确定如何继续。我需要手风琴始终与一周的日期在一起,并且要么包含该日期的游戏行,要么说今天没有游戏.
我还需要展示按运动分组的游戏。因此,例如,如果 9 月 10 日有两场男子足球比赛和一场排球比赛,那么我需要表格有一个表格行,其中包含运动名称,后跟该运动下的表格行(每场比赛((就像我的例子一样(。如果当天没有安排比赛,那么我需要看看第二天是否有安排的比赛等等......
我的想法是继续为每个手风琴写 if 语句,但我认为我会遇到运动类型出现在每行$sport = "值" 的问题.这是我到目前为止的代码:
<?php
/* create the days of the week */
date_default_timezone_set('US/Eastern');
$today = time();
$weekStartDate = date('l, F d, Y',strtotime("last Monday", $today));
$weekTuesDate = date('l, F d, Y', strtotime('+1 days', strtotime($weekStartDate)));
$weekWedDate = date('l, F d, Y', strtotime('+2 days', strtotime($weekStartDate)));
$weekThursDate = date('l, F d, Y', strtotime('+3 days', strtotime($weekStartDate)));
$weekFriDate = date('l, F d, Y', strtotime('+4 days', strtotime($weekStartDate)));
$weekSatDate = date('l, F d, Y', strtotime('+5 days', strtotime($weekStartDate)));
$weekSunDate = date('l, F d, Y', strtotime('+6 days', strtotime($weekStartDate)));
/* select only the games for the current week from database */
require_once('filename.php');
$query = "SELECT gamedate, gametime, homeschool, visitorschool, homelivestatsurl, notes, gamestatus, homescore, visitorscore, score, record, sporttype FROM my_table WHERE WEEKOFYEAR(gamedate)=WEEKOFYEAR(NOW()) ORDER BY gamedate";
/* if there are results build the accordion and tables - if not, just say there are no games this week */
if ($result = mysqli_query($link, $query)) { ?>
<div style="vertical-align:top;"><img src="images/cobrasschedule.png" border="0"/></div>
<div style="width:300px; float: left; margin-left:15px; display:table;">
<?php
/* variables that will change*/
$weekday = ' ';
$day = ' ';
$sport = ' ';
/* fetch associative array */
while ($row = mysqli_fetch_assoc($result)) {
if (date('d', strtotime($row['gamedate'])) !== $weekday) {
$weekday=date('d', strtotime($row['gamedate']));
if (date('l, F d, Y', strtotime($row['gamedate'])) !== $day) {
$day=date('l, F d, Y', strtotime($row['gamedate']));
if ($row['sporttype'] !== $sport) {
$sport=$row['sporttype'];
?>
<!--This builds the accordion -->
<div style="margin-top:13px;">
<div id="AC-label">
<div id="ACIntro"><span id="hidden_box_button1" style="color:#000000; cursor:pointer;padding-top:10px; padding-bottom:10px;font-size:14px;font-weight:bold; text-shadow:none;"><?php echo date('l, F d, Y', strtotime($weekStartDate));?><span style="float:right; margin-right: 10px;"><span id="hidden_box_button1" style="color:#000000; cursor:pointer; text-shadow:none;">+</span></span></div></div></div>
<div id="hidden_box1" style="display:none;">
<div style="float:left; clear:both; display:table; margin-top:5px;">
<!-- See if the gamedate matches the accordion date -->
<?php if (date('d', strtotime($row['gamedate'])) == date('d', strtotime($weekStartDate))) { ?>
<table style="margin-left:-15px;" cellpadding="3px">
<tbody>
<tr>
<!--Check the value of $sport and echo the appropriate table row -->
<?php if ($sport == 'Baseball'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>BASEBALL</strong></td>
<?php elseif ($sport == 'MBasketball'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>MEN'S BASKETBALL</strong></td>
<?php elseif ($sport == 'Golf'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>GOLF</strong></td>
<?php elseif ($sport == 'MSoccer'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>MEN'S SOCCER</strong></td>
<?php elseif ($sport == 'WBasketball'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>WOMEN'S BASKETBALL</strong></td>
<?php elseif ($sport == 'WSoccer'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>WOMEN'S SOCCER</strong></td>
<?php elseif ($sport == 'Softball'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>SOFTBALL</strong></td>
<?php elseif ($sport == 'Volleyball'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>VOLLEYBALL</strong></td>
<?php elseif ($sport == 'Cycling'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>CYCLING</strong></td>
<?php elseif ($sport == 'Equine'): ?>
<td colspan="2" style="background-color:#D3BC9A; color:white;text-transform:uppercase; padding-left:25px;"><strong>EQUINE</strong></td>
<?php endif; ?>
</tr>
<!--Build the table rows for the games based on the sport -->
<?php if ($row['homescore'] != ' ' and $row['homeschool'] == 'Virginia Intermont College - VA'): ?>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><strong><?php echo $row['homeschool'];?> vs.</strong><br/><?php echo $row['visitorschool'];?></span></td>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['homescore'];?><br/><?php echo $row['visitorscore'];?></span></td>
</tr>
<?php elseif ($row['homescore'] != ' ' and $row['visitorschool'] == 'Virginia Intermont College - VA'): ?>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['visitorschool'];?> @<br/><?php echo $row['homeschool'];?></span></td>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['visitorscore'];?><br/><?php echo $row['homescore'];?></span></td>
</tr>
<?php elseif (empty($row['homescore']) and empty($row['score']) and $row['homeschool'] == 'Virginia Intermont College - VA'): ?>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><strong><?php echo $row['homeschool'];?> vs.</strong><br/><?php echo $row['visitorschool'];?></span></td>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['gametime'];?><br/> </span></td>
</tr>
<?php elseif (empty($row['homescore']) and empty($row['score']) and $row['visitorschool'] == 'Virginia Intermont College - VA'): ?>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['visitorschool'];?> @<br/><?php echo $row['homeschool'];?></span></td>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['gametime'];?><br/> </span></td>
</tr>
<?php elseif ($row['score'] != ' ' and $row['homeschool'] == 'Virginia Intermont College - VA'): ?>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><strong><?php echo $row['homeschool'];?> vs.</strong><br/><?php echo $row['visitorschool'];?></span></td>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['score'];?><br/> </span></td>
</tr>
<?php elseif ($row['score'] != ' ' and $row['visitorschool'] == 'Virginia Intermont College - VA'): ?>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['visitorschool'];?> @<br/><?php echo $row['homeschool'];?></span></td>
<td style="margin-bottom:3px;"><span style="text-shadow: none;"><?php echo $row['score'];?><br/> </span></td>
</tr>
<?php endif; ?>
</tr>
</tbody>
</table>
</div>
<?php } else { ?>
<div style="float:left; clear:both; display:table; margin-top:5px;">
<table style="margin-left:-15px;" cellpadding="3px">
<tbody>
<tr>
<td style="margin-bottom:3px;"><span style="text-shadow: none;">No games today.</span></td>
</tr>
</tbody>
</table>
</div>
<?php }
}
}
}
/* close while and reset weekday date and sport */
$weekday=date('d', strtotime($row['gamedate']));
$day=date('l, F d, Y', strtotime($row['gamedate']));
$sport=$row['sporttype'];
}
?>
</div>
<script type="text/javascript">
(function($) {
$("#hidden_box_button1").click(function() {
if ( $("#hidden_box1").is(":hidden") ) {
$("#hidden_box1").slideDown("normal");
} else {
$("#hidden_box1").slideUp("normal");
}
});
})(jQuery);
</script>
</div>
<?php
/* close ifresult and give no results statement*/
} else {?>
<span style="vertical-align:top;margin-left:-16px;padding:0;"><img src="images/cobrasschedule.png" border="0"/></span>
<?php
echo "Schedule is not available.";
}
/* free result set*/
mysqli_free_result($result);
/* close connection */
mysqli_close($link);
?>
我将回答标题中的问题
$sql=mysql_query(SELECT field1 from table1 where condition1 ) // condition1 =field1=value1 for example
然后
while($r=mysql_fetch_assoc($sql)){
$var=$r['field1'];
if($var){
//Something
}
}
相关文章:
- 对于循环-在循环内部循环,用于获取带有ascii值的字母表
- 函数未完全循环通过循环
- 为什么while循环无限循环
- JavaScript:在 for 循环中循环
- jquery中基于剃刀循环的循环
- 如何重新启动循环javascript循环
- 简单的 do/while 循环无限循环问题
- 看起来我的每个循环都循环不止一次
- 我应该如何在同一循环中循环访问多个getElementsByClassName()调用的结果
- JavaScript 中的无限循环 - while 循环
- 了解循环:在循环中使用未定义的变量
- 如何在循环中循环此 JavaScript 代码
- 在jquery中,json对象How中的每个循环(使循环从对象中找到一个值,并与另一个对象值进行比较,以避免重复打印)
- ajax调用的循环-访问循环计数器
- javascript for循环;t循环到底
- JS类循环和循环
- 关于循环Javascript循环和算法所需的建议
- 基于条件,每个循环将循环变量递增一次以上
- 在JavaScript中创建一个随机数生成器游戏,无法使While循环保持循环
- 循环中循环