Forum PHP.pl

[SQL] pobierz, plaintext 
CREATE TABLE tabela_nowa LIKE tabela_stara
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT COUNT(id) FROM tabela_nowa WHERE id NOT IN (SELECT id FROM tabela_stara AND ... [dodatkowe warunki] )
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT brand_name FROM brand LEFT JOIN template ON brand.id = template.brand_id LEFT JOIN project ON project.template_id = template.id WHERE project.name="Magda";
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$str = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit nazwa-XXXXXXXXX, bibendum elit id pulvinar. Curabitur et cursus leo. Sed eu tellus nazwa-XXXXXXXXX, consectetur adipiscing ipsum dolor sit...';
preg_match_all('#nazwa-(.+?),#', $str, $matches);
var_dump($matches);
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
ALTER TABLE `tabela` MODIFY id int(11) FIRST;
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
preg_match_all('/[0-9]{9}/', $input, $matches);
var_dump($matches);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
$a1 = [ 
    14 => [ 'id' => 14, 'first_name' => 'Jan', 'last_name' => 'Kowalski' ],
    13 => [ 'id' => 13, 'first_name' => 'Anna', 'last_name' => 'Kowalska' ]
];
 
$a2 = [ 
    [ 'id' => 14, 'article_name' => "Artykul 1" ],
    [ 'id' => 14, 'article_name' => "Artykul 2" ],
    [ 'id' => 13, 'article_name' => "Artykul 3" ],
    [ 'id' => 13, 'article_name' => "Artykul 4" ],
    [ 'id' => 15, 'article_name' => "Artykul 0" ],
];
 
$ret = []; 
foreach($a2 as $a) {
    $author = array_key_exists($a['id'], $a1) ? $a1[$a['id']]['first_name']." ".$a1[$a['id']]['last_name'] : 'Nieznany';
    $ret[$author][] = $a['article_name'];
}
 
var_dump($ret);
[PHP] pobierz, plaintext