Forum PHP.pl

Cytat(kpt_lucek @ 7.09.2017, 10:19:09 )

[PHP] pobierz, plaintext 
foreach ($solutions as $key => $sol) {
    echo sprintf('<p>%d, %s</p>', $key + 1, implode(' ', $sol));
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
foreach (array_values($solutions) as $key => $sol) {
    echo sprintf('<p>%d, %s</p>', $key + 1, implode(' ', $sol));
}
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
var discountPrice   =   parseFloat($(this).closest('.discount').data('discount-value'));
[HTML] pobierz, plaintext 

[HTML] pobierz, plaintext 
var discountPrice   =   parseFloat($(this).closest('.discount').data('discount-percentage ')) * basePrice;
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
$mail = mail(WEBMASTER_EMAIL, $subject, nl2br($message),
     "From: ".$name." <".$email.">\r\n"
    ."Reply-To: ".$email."\r\n"
    ."X-Mailer: PHP/" . phpversion());
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT
	u.id,
	com.id AS comment_id,
	com.time AS comment_date
FROM tablica_uzytkownikow u
INNER JOIN sktest.wp_comment com
	ON com.whom = u.id
WHERE com.id IN (
	SELECT
		scom.id
	FROM sktest.wp_comment scom
	WHERE
		scom.whom = u.id
		AND scom.action = 'comment'
		-- Tutaj dodatkowe WHERE związane z datą
	ORDER BY scom.time DESC
	LIMIT 3
)
-- Tutaj dodatkowe WHERE związane z filtrowaniem użytkowników
ORDER BY
	u.id,
	com.time DESC;
[SQL] pobierz, plaintext 

[HTML] pobierz, plaintext 
{{ c.post.xyz }}
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php 
 
$currentRow	=	0;
$rowsToSkip	=	2;
 
if(($handle = fopen($file, "r")) !== false){
	while(($data = fgetcsv($handle, 2048, ",")) !== false) {
		$currentRow++;
		if($currentRow <= $rowsToSkip){
			continue;
		}
 
		//	reszta kodu
	}
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
function zwieksz(&$x){
   $x++;
}
 
$foo = 1;
 
echo $foo;   // wyświetli 1
 
zwieksz($foo);
 
echo $foo;   // wyświetli 2
 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
$tablica = ['a', 1, 'trzy'];
 
echo '<pre>';
print_r($tablica);
echo '</pre>';
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
$zipCodes	=	unserialize(file_get_contents('/sciezka/do/pliku/ser_zips.dat'));
 
print_r($zipCodes['05-500']);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php 
 
/**
 * @param string $xmlTimestamp
 * @return \DateTime
 */
function getDateTime($xmlTimestamp){
	$timestamp	=	intval(substr(str_replace('-0000', '', $xmlTimestamp), 0, -3));
 
	$date	=	new DateTime();
	$date->setTimestamp($timestamp);
 
	return $date;
}
 
print_r(getDateTime('1475791200000-0000'));
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
$pdo	=	new PDO();	// inicjalizacja połączenia, host, user, pass itd.
 
$query	=	"
	SELECT
		*
	FROM (
		SELECT
			name,
			id,
			'A' AS table_id
		FROM ".$prefix."A
		WHERE A_name LIKE :nameA
 
		UNION ALL
 
		SELECT
			name,
			id,
			'B' AS table_id
		FROM ".$prefix."B
		WHERE B_title LIKE :nameB
	) res
";
 
$stmt	=	$pdo->prepare($query);
$paramName	=	'%'.$name.'%';
$stmt->bindParam(':nameA', $paramName, PDO::PARAM_STR);
$stmt->bindParam(':nameB', $paramName, PDO::PARAM_STR);
 
$stmt->execute();
 
$result	=	$stmt->fetchAll(PDO::FETCH_CLASS, 'Wynik');
 
class Wynik{
	public $name;
	public $id;
	public $table_id;
 
	public function getName(){
		return $this->name;
	}
 
	public function test(){
		return $this->table_id . '_name';
	}
 
	public function getMyArray(){
		return [
			$this->table_id . '_name' => $this->name,
			'id'                      => $this->id,
		];
	}
}
 
$myResult	=	[];
 
foreach ($result as $v){
	$myResult[]	=	$v->getMyArray();
}
 
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT
	*
FROM (
	SELECT
		name,
		id,
		'A' AS table_id
	FROM ".$prefix."A
	WHERE A_name LIKE '%".$name."%' 
 
	UNION ALL
 
	SELECT
		name,
		id,
		'B' AS table_id
	FROM ".$prefix."B
	WHERE B_title LIKE '%".$name."%' 
) res
[SQL] pobierz, plaintext