内爆功能突然停止工作

Question

This was working perfectly... I made some adjustments to the where clause of the select statement on the form from which the post is sourced and now it is no longer working. Any idea why I am suddenly getting an implode error?

Warning: implode() [function.implode]: Invalid arguments passed on line 9

  <?php
// show error messages
ini_set('error_reporting', E_ALL);
ini_set("display_errors", 1);

$datea= $_POST["userDatea"];
$media= $_POST["userMedia"];
$datez= $_POST["userDatez"];
$media_names = "'".implode( "%','", $media)."%'";


//var_dump($media_names);

if( !empty($_SERVER['REQUEST_METHOD']) && (strcasecmp($_SERVER['REQUEST_METHOD'], 'post')===0)  ) {
// Create connection
$conn = pg_connect("dbconnection info");

// Check connection
if (!$conn) {
echo "Did not connect.
";
exit;
}
$result = pg_query($conn,
"SELECT
date (b.starttime),
Count(b.starttime) as Plays,
Count(distinct(b.playerid)) as Stores

FROM
public.billing b,
public.medias m,
public.players p

WHERE
b.mediaitemid = m.id and
p.id = b.playerid and
m.name LIKE any (array[$media_names]) and
b.starttime >= date('$datea') and 
b.starttime < date('$datez')+1 and
m.startdate >  '2015-01-01'

GROUP BY
date (b.starttime)

ORDER BY
date (b.starttime);");

if (!$result) {
  echo "Query failed.
";

  exit;
}

 $num_fields = pg_num_fields($result);
    $headers = array();

    for ($i = 0; $i < $num_fields; $i++) 
    {
        $headers[] = pg_field_name($result , $i);
    }

    $fp = fopen('php://output', 'w');
    if ($fp && $result)
    {
            header('Content-Type: text/csv');
            header('Content-Disposition: attachment; filename="customreport.csv"');
            header('Pragma: no-cache');
            header('Expires: 0');
            fputcsv($fp, $headers);

            while ($row = pg_fetch_row($result)) 
            {
                 fputcsv($fp, array_values($row));
            }
            die;

}
        exit('It works');
    }
?>

Here is the source of the post:

<select multiple name="userMedia" class="form-control" id="userMedia[]" style="height:350px;">
 <?php

$conn = pg_connect("db connection");

if (!$conn) {
echo "Did not connect.
";
exit;
}
$sql = "SELECT 
        m.name
        FROM 
        public.medias m
        where 
        date(m.enddate) >= date(now()) - interval '183 days' and
        date(m.startdate) > '2015-01-01' and
        m.enddate != ''

        UNION ALL

        SELECT 
        m.name
        FROM 
        public.medias m
        where 
        m.enddate = '' and
        date(m.startdate) > '2015-01-01';";
$rs = pg_query($conn, $sql);


if (pg_num_rows($rs) > 0) {
// output data of each row
while($row = pg_fetch_assoc($rs)) {
$menu .= "<option value=".$row['name'].">" . $row['name']. "</option>";
}
}

echo $menu;

pg_close($conn); 

?> 
</select></p>

Answer 1

Since the first argument you pass to implode() is a string (the "glue"), it expects the second argument to be an array.

When $media (initialized using $_POST["userMedia"]) is not an array, implode() triggers the warning and returns NULL instead of the string you expect.