Question

我看上了本表所花时间,然后将这些时间从这三个阵列中删除。阵列为1-24时。

这一文字的最终目的是比较这些阵列中的所有失踪时间,使一大阵容与只有可用时间。

渔获量是,如果连续三度缺失时间,就需要加以检查。如果是的话,这一时间不会出现在最后的阵列中。

例如:

<?php

include  db-connect.php ;
if (isset($_GET[ month ]) && isset($_GET[ day ]) && isset($_GET[ year ])) {

$month = $_GET[ month ];
$day = $_GET[ day ];
$year = $_GET[ year ];

//string together date
$date = $month."/".$day."/".$year;

//define the queries
$sql1 = mysql_query("SELECT start_time, server FROM classes WHERE date =  $date  AND server =  1 ");
$sql2 = mysql_query("SELECT start_time, server FROM classes WHERE date =  $date  AND server =  2 ");
$sql3 = mysql_query("SELECT start_time, server FROM classes WHERE date =  $date  AND server =  3 ");

//define time lists for each server
$timelist1 = range(1, 24);
$timelist2 = range(1, 24);
$timelist3 = range(1, 24);

//unset the arrays with the taken times for server 1
while($query1 = mysql_fetch_array($sql1)) {

    unset($timelist1[$query1[ start_time ] - 1]);

}
//unset the arrays with the taken times for server 2
while($query2 = mysql_fetch_array($sql2)) {

    unset($timelist2[$query2[ start_time ] - 1]);

}
//unset the arrays with the taken times for server 3
while($query3 = mysql_fetch_array($sql3)) {

    unset($timelist3[$query3[ start_time ] - 1]);

}

//now see which times are missing three times in a row and make one final array of available times.

//code goes here...

}
?>

Answer 1

你们可以不像你目前的战略那样,只储存每一次阵列的数量:

include  db-connect.php ;
if (isset($_GET[ month ]) && isset($_GET[ day ]) && isset($_GET[ year ])) {

$month = $_GET[ month ];
$day = $_GET[ day ];
$year = $_GET[ year ];

//string together date
$date = $month."/".$day."/".$year;

//define time list
$timelist = array_fill(1, 24, 0);

while($query1 = mysql_fetch_array($sql1)) {

    $timelist[$query1[ start_time ]]++;

}

while($query2 = mysql_fetch_array($sql2)) {

    $timelist[$query2[ start_time ]]++;

}

while($query3 = mysql_fetch_array($sql3)) {

    $timelist[$query3[ start_time ]]++;

}

$timelist = array_keys(array_filter($timelist,  equals3 ));

function equals3($x){
    return $x == 3;
}

现在,时间清单是所有三个查询中发现的一系列时间。如果你想要从至少一个问答中遗漏一系列时间,而不是最后几个方面:

$timelist = array_keys(array_filter($timelist,  lessThan3 ));

function lessThan3($x){
    return $x < 3;
}

<>Edit,可变数量服务器。

// Here you can list the servers you want to include in the query
// In an array form so it can be filled easily
$servers = array(1,2,4,5);
$num_servers = count($servers);

// Convert servers into queryable format
$servers =  (  .implode(  ,  , $servers).  ) ;
$query =  SELECT `start_time`, COUNT(*) as `count` FROM `classes`
           WHERE `date` =   .$date.   AND `server` IN  .$servers.  
           GROUP BY `start_time` ;
$result = mysql_query($query);

$timelist = array_fill(1, 24, 1);
while($row = mysql_fetch_row($result))
    if($row[1] == $num_servers) // `start_time` is missing from at least one server
        unset($timelist[$row[0]]);
$timelist = array_keys($timelist);

// Now $timelist is an array of times that are available on at least one server from the query

请注意,由于您的日期变量来自_GET,你应当非常认真地对待MySQL的注射攻击。有些人如果得不到适当的保护,就可以删除整个数据库,或者更糟。请阅读:。

友情链接