$str = "Основателем социальной сети ВКонтакте был [id1|Павел Дуров]";
if (preg_match_all("/\[.*\]/m", $str, $matches)) {
foreach ($matches[0] as $match) {
list($id, $name) = explode("|", substr($match, 1, -1));
$link = "<a href='http://vk.com/{$id}' target='_blank'>{$name}</a>";
var_dump($link);
}
}
Кроме прочего, там уже добавлено @ini_set(‘date.timezone’, ‘Moscow/Europe’);
date("m", strtotime("+1 month"));
Relative month values are calculated based on the length of months that they pass through. An example would be "+2 month 2011-11-30", which would produce "2012-01-30". This is due to November being 30 days in length, and December being 31 days in length, producing a total of 61 days.
$next_month = date("m")+1 > 12 ? 1 : date("m")+1;
$post_next_month = $next_month+1 > 12 ? 1 : $next_month+1;
SELECT
`name`,
(SELECT
SUBSTRING_INDEX(
GROUP_CONCAT(`images`.`name` SEPARATOR ","),
",",
5
)
FROM `images`
WHERE `images`.`album_id`=`albums`.`album_id`
ORDER BY `images`.`image_id` DESC
)
FROM `albums`
ORDER BY `album_id` DESC
LIMIT 10
SELECT
`albums`.`name`,
CONCAT_WS(',',
(SELECT `images`.`name`
FROM `images`
WHERE `images`.`album_id`=albums.`album_id`
ORDER BY `images`.`image_id` DESC
LIMIT 0,1
),
(SELECT `images`.`name`
FROM `images`
WHERE `images`.`album_id`=albums.`album_id`
ORDER BY `images`.`image_id`
DESC LIMIT 1,1
),
(SELECT `images`.`name`
FROM `images`
WHERE `images`.`album_id`=albums.`album_id`
ORDER BY `images`.`image_id`
DESC LIMIT 2,1
),
(SELECT `images`.`name`
FROM `images`
WHERE `images`.`album_id`=albums.`album_id`
ORDER BY `images`.`image_id`
DESC LIMIT 3,1
),
(SELECT `images`.`name`
FROM `images`
WHERE `images`.`album_id`=albums.`album_id`
ORDER BY `images`.`image_id`
DESC LIMIT 4,1
)
) AS 'images'
FROM `albums`
ORDER BY `album_id` DESC
LIMIT 10
SELECT
`name`,
(SELECT
GROUP_CONCAT(innerquery.`name`)
FROM
(SELECT `images`.`name`
FROM `images`
WHERE `images`.`album_id`=`albums`.`album_id`
ORDER BY `images`.`image_id` DESC
LIMIT 5
) AS innerquery
)
FROM `albums`
ORDER BY `album_id` DESC
LIMIT 10
Написать специальный класс-обертку для таких методов и получать строку чем-то вроде Str::getRandom(10)
function download($link) {
$opts = [
'http' => [
'method' => "GET",
'header' => "Cookie: uid=XXXXXX; pass=YYYYYYYYYYYYYYYYYYYYYYYYY"
]
];
$context = stream_context_create($opts);
return file_get_contents($link, false, $context);
}
$vsegogolosov = $wpdb->get_var($wpdb->prepare("SELECT count(meta_value) FROM $wpdb->postmeta WHERE meta_key = %s", "golosov"));
$checklogin = mysql_query("SELECT * FROM users WHERE Username = '".$username."'");
if(mysql_num_rows($checkusername) == 1)
<ul>
<? foreach ($menu as $item) { ?>
<li>
<a href="<?= $item->link ?>"><?= $item-title ?></a>
</li>
<? } ?>
</ul>
<ul>
<? $current_url = add_query_arg($wp->query_string, "", home_url( $wp->request)) ?>
<? foreach ($menu as $item) { ?>
<li <?= $current_url == $item->link ? "class='current'" : ""?>
<a href="<?= $item->link ?>"><?= $item-title ?></a>
</li>
<? } ?>
</ul>