/* Execute a prepared statement using an array of values for an IN clause */
$params = array(1, 21, 63, 171);
/* Create a string for the parameter placeholders filled to the number of params */
$place_holders = implode(',', array_fill(0, count($params), '?'));
/*
This prepares the statement with enough unnamed placeholders for every value
in our $params array. The values of the $params array are then bound to the
placeholders in the prepared statement when the statement is executed.
This is not the same thing as using PDOStatement::bindParam() since this
requires a reference to the variable. PDOStatement::execute() only binds
by value instead.
*/
$sth = $dbh->prepare("SELECT id, name FROM contacts WHERE id IN ($place_holders)");
$sth->execute($params);'WHERE id in (?,?,?,?,?,?,?)'
и собачить типизированные параметры
->bindParam(1, $id, PDO::PARAM_INT);
->bindParam(2, $id, PDO::PARAM_INT);
...
Но это за тебя сделает
вот эта штука
$place_holders = implode(',', array_fill(0, count($params), '?'));
насколько я понял.if (!$res) {
die('Неверный запрос: ' . mysql_error());
}error_reporting(E_ALL);
ini_set("display_errors", 1);ВНИМАНИЕ: Данное расширение устарело, начиная с версии PHP 5.5.0, и будет удалено в будущем. Используйте вместо него MySQLi или PDO_MySQL.
abstract class Parent
{
abstract public function getName()
{
return "Родитель";
}
}
class Child1 extends Parent
{
public function getName()
{
return "Дочерний 1";
}
}
class Child2 extends Parent
{
public function getName()
{
return "Дочерний 2";
}
}<\w+>\s<\w+>\s?text\s?<\/\w+>\s<\/\w+>/(<(\w+)>\s?подставить текст сюда\s?<\/\w+>)/gim/(<\w+>\s<raw>text</raw>\s<\/\w+>)/gim<?php echo $entry_child; ?>
<?php if ($child_visible) { ?>
<?php echo $text_yes; ?>
<?php } else { ?>
<?php echo $text_yes; ?>
<?php } ?>
<?php if (!$child_visible) { ?>
<?php echo $text_no; ?>
<?php } else { ?>
<?php echo $text_no; ?>
<?php } ?>if (isset($this->request->post['child_visible'])) {
$data['child_visible'] = $this->request->post['child_visible'];
} elseif (!empty($module_info)) {
$data['child_visible'] = $module_info['child_visible'];
} else {
$data['child_visible'] = "1";
}/*
* Inserts a new key/value after the key in the array.
*
* @param $key
* The key to insert after.
* @param $array
* An array to insert in to.
* @param $new_key
* The key to insert.
* @param $new_value
* An value to insert.
*
* @return
* The new array if the key exists, FALSE otherwise.
*
* @see array_insert_before()
*/
function array_insert_after($key, array (link is external) &$array, $new_key, $new_value) {
if (array_key_exists (link is external)($key, $array)) {
$new = array (link is external)();
foreach ($array as $k => $value) {
$new[$k] = $value;
if ($k === $key) {
$new[$new_key] = $new_value;
}
}
return $new;
}
return FALSE;
}В строку влезает один 4x4, два 2x4,