Menu
Community /Pin to ProfileBookmark
@NogDogOct 16.2020 — #
Start by figuring out why
@NogDogOct 19.2020 — #Just because this came up recently elsewhere, be careful with use of sub-domains (include
This is a useful thing to stick into any start-up script you
PDO database query array error
Hello
PDO database query array error
PHP Warning: count(): Parameter must be an array or an object that implements Countable in
PHP Warning: str_repeat(): Second argument has to be greater than or equal to 0 in
PHP Warning: array_merge(): Argument #2 is not an array in
PHP Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in
PDOStatement->execute(NULL)
$_SESSION[‘satellite_ids_json’] = [“1″,”2″,”3″,”4”]
“`
$arr = json_decode($_SESSION[‘satellite_ids_json’]);
$in = str_repeat(‘?,’, count($arr) – 1) . ‘?’;
$sql = “SELECT * FROM satellite WHERE satellite_lnb_type=? AND id IN ($in)”;
$stm = $PDOdatabase->prepare($sql);
$params = array_merge([‘MDULNB’], $arr);
$stm->execute($params);
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogOct 16.2020 — #>@gecekule#1624299 PHP Warning: count(): Parameter must be an array or an object that implements Countable in
Start by figuring out why
$arrvar_dump()json_decode()0
@NogDogOct 17.2020 — #Glad you figured it out. While that session check is probably fine, you might want to consider this as being a bit more robust (and maybe a bit more explicit?):<i>
</i>if(session_status() == PHP_SESSION_NONE) {
session_start();
}
0
@NogDogOct 19.2020 — #Just because this came up recently elsewhere, be careful with use of sub-domains (include www.<i>
</i><?php
session_set_cookie_params(60 * 60 * 24, '/', '.yourdomain.com'); // note leading dot for domain
session_start();
This is a useful thing to stick into any start-up script you
require