doudao8283 2013-05-10 22:01
浏览 584
已采纳

在MYSQL查询中使用变量作为列名

I made a table for appointments that works as a form, it shows whether a time slot is free or not and you can reserve appointments from it. This is the code that works ..

$query=mysql_query("SELECT * FROM days "); 
echo " <form action=\"change.php\" method=\"post\"><TABLE>";
echo "<TR><Th> Dia <Th> 8 <Th> 9 <Th> 10 <Th> 11<Th>12 <Th> 13 <Th> 14 <Th> 15 <Th> 16       ";

while ($rows=mysql_fetch_array($query)) { 
    if ($rows['08'] == 'taken') {
        $rows['08'] = "<TD id=\"red\" >TAKEN";
    } 
    else {
        $rows['08'] = "<TD id=\"blue\" ><input type=\"radio\" name=\"slot\" value= \"08 $rows[day]\" >$rows[08]";
    }

    if ($rows['09']=='taken') {
        $rows['09']="<TD  id=\"red\" >TAKEN";
    }
    else {
        $rows['09']="<TD  id=\"blue\" ><input type=\"radio\" name=\"slot\" value= \"09 $rows[day]\" >$rows[09]";
    }

    if ($rows['10']=='taken') {
        $rows['10']="<TD  id=\"red\" >TAKEN";
    }

the code goes further to cover all timeslots .. this is an example of how the table looks like .. well ..with the free cells having a radio botton next to them:

           day   08      09     10     11     12     13     14     15      16 
    2013-05-05  free   free   free   taken   free   free   taken   free   free

what i'm trying to do is to automate this . as in creating a loop so i dont have to repeat the same code so many times .. i tried the following but it didnt work:

while ($rows=mysql_fetch_array($query)) {
    $c="08"; 
    if ($rows["$c"]=='taken') {
        $rows["$c"]='taken';
    } 

    if ($rows["$c"]=='free') {
        $rows[$c] = "<input type=\"radio\" name=\"slot\" value= \"$c. $rows[day]\" >$rows[$c]";
    }

    echo "<TR><TD>$rows[day]"; echo "<TD> $rows[$c]"; $c++;
    echo "<TD> $rows[$c]"; $c++;
    echo "<TD> $rows[$c]"; $c++;
    echo "<TD> $rows[$c]"; $c++;

.....and so on ..

I'm thinking the problem is in the way to put the variable inside the row array any suggestions?

  • 写回答

1条回答 默认 最新

  • duanluanlang8501 2013-05-10 22:12
    关注
    $query=mysql_query("SELECT * FROM days "); 
    echo "<form action='change.php' method='post'><table>";
    echo "<tr><td>day</td><td>8</td><td>9</td><td>10</td><td>11</td><td>12</td><td>13</td><td>14</td><td>15</td><td>16</td></tr>";
    
    while ($rows=mysql_fetch_array($query)) { 
    
        while (  $rows=mysql_fetch_assoc($query) ) {
    
            $res[]="<tr><td>".$rows[day];
    
            for ($c="8";$c<="16";$c++)
            {
    
                if ($c<10){$ca="0".$c;} else {$ca=$c;}
    
                if ($rows[$ca]=='taken') {
                    $res[]='taken';
                } 
                if ($rows[$ca]=='free') {
                    $res[] = "<input type='radio' name='slot' value='".$c." ".$rows[day]." >".$rows[$ca];
                }
            }
            $res[]="</td></tr>";
            echo implode("</td><td>",$res);
        }
        echo "</table></form>"; 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 机器学习或深度学习问题?困扰了我一个世纪,晚来天欲雪,能饮一杯无?
  • ¥15 c语言数据结构高铁订票系统
  • ¥15 关于wkernell.PDB加载的问题,如何解决?(语言-c#|开发工具-vscode)
  • ¥15 (标签-STM32|关键词-智能小车)
  • ¥20 关于#stm32#的问题,请各位专家解答!
  • ¥15 (标签-python)
  • ¥20 搭建awx,试了很多版本都有错
  • ¥15 java corba的客户端该如何指定使用本地某个固定IP去连接服务端?
  • ¥15 activiti工作流问题,求解答
  • ¥15 有人写过RPA后台管理系统么?