php - 数据库中具有相同值的组列名称

Question

我正在制作一个程序来增加商店的数量，这些商店有自己的营业时间和营业时间(不同的日子可能会有所不同)

我存储开盘和关盘时间的数据库结构如下

所以在从这个表中获取我的数据时，我想将具有相同值的列名分组..

像第一个商店输出应该是

monday, tuesday, wednesday, thrusday, friday, saturday, sunday => 10:00-am to 8:00-pm

最后的存储输出应该是

monday, tuesday, wednesday, friday, saturday => 10:00-am to 8:00-pm

thrusday => 9:30-am to 5:00-pm

sunday => 10:00-am to 4:30-pm

那么我如何编写查询来获取这样的记录..

谢谢，

Answer 1

这可能对你有帮助。

$array = 来自数据库并处理它的输入。

$standardTime = 保存商店默认开门和关门时间的数组。

我不确定如何使用 SQL 或直接通过查询实现这一点，但在这里我尝试使用 PHP 脚本。希望这对您有所帮助。

    $array =  array(
      'monday' => "10:30-am to 08:00-pm",
      'tuesday' => "10:30-am to 08:00-pm",
      'wedensday' => "10:30-am to 08:00-pm",
      'thursday' => "09:30-am to 05:00-pm",
      'friday' => "10:30-am to 08:00-pm",
      'saturday' => "10:30-am to 08:00-pm",
      'sunday' => "10:00-am to 04:30-pm",
    );

    $standardTime = array("10:30-am to 08:00-pm","10:30-am to 08:00-pm","10:30-am to 08:00-pm","10:30-am to 08:00-pm","10:30-am to 08:00-pm","10:30-am to 08:00-pm","10:30-am to 08:00-pm");
    $diff = array_diff($array,$standardTime);
    $daysWithDiffTimmings = '';
    if(is_array($diff) && count($diff) > 0) {
        $daysThatHaveDiffTime = array_keys($diff);
        foreach($daysThatHaveDiffTime as $day) {
            $daysWithDiffTimmings.= $day.' = '.$diff[$day]."<br/>";
            unset($array[$day]);
       }
     }

    $remainingDaysWithSameTime = array_keys($array);
    $daysWithSameTime =  implode(",", $remainingDaysWithSameTime);
    $daysWithSameTime .= ' = 10:30-am to 08:00-pm<br/>';

    echo $daysWithSameTime;
    echo $daysWithDiffTimmings;

这将为您提供如下输出:

monday,tuesday,wedensday,friday,saturday = 10:30-am to 08:00-pm
thursday = 09:30-am to 05:00-pm
sunday = 10:00-am to 04:30-pm