class autoload
{
private $_fileExtension = '.php';
private $_namespace;
private $_includePath;
private $_namespaceSeparator = '\\';
public function __construct($ns = null, $includePath = null)
{
$this->_namespace = $ns;
$this->_includePath = $includePath;
}
public function setNamespaceSeparator($sep)
{
$this->_namespaceSeparator = $sep;
}
public function getNamespaceSeparator()
{
return $this->_namespaceSeparator;
}
public function setIncludePath($includePath)
{
$this->_includePath = $includePath;
}
public function getIncludePath()
{
return $this->_includePath;
}
public function setFileExtension($fileExtension)
{
$this->_fileExtension = $fileExtension;
}
public function getFileExtension()
{
return $this->_fileExtension;
}
public function register()
{
spl_autoload_register(array($this, 'loadClass'));
}
public function unregister()
{
spl_autoload_unregister(array($this, 'loadClass'));
}
public function loadClass($className)
{
if (null === $this->_namespace || $this->_namespace.$this->_namespaceSeparator === substr($className, 0, strlen($this->_namespace.$this->_namespaceSeparator))) {
$fileName = '';
$namespace = '';
if (false !== ($lastNsPos = strripos($className, $this->_namespaceSeparator))) {
$namespace = substr($className, 0, $lastNsPos);
$className = substr($className, $lastNsPos + 1);
$fileName = str_replace($this->_namespaceSeparator, DIRECTORY_SEPARATOR, $namespace) . DIRECTORY_SEPARATOR;
}
$fileName .= str_replace('_', DIRECTORY_SEPARATOR, $className) . $this->_fileExtension;
require ($this->_includePath !== null ? $this->_includePath . DIRECTORY_SEPARATOR : '') . $fileName;
}
}
}$autoload = new autoload('library', \ROOT.'/core');
$autoload->register();SELECT tableA.Id, tableA.Name, [tableB].Username AS Owner, [tableB].ImageUrl, [tableB].CompanyImageUrl, COUNT(tableD.UserId) AS Number
FROM tableD
RIGHT OUTER JOIN [tableB]
INNER JOIN tableA ON [tableB].Id = tableA.Owner ON tableD.tableAId = tableA.Id
GROUP BY tableA.Name, [tableB].Username, [tableB].ImageUrl, [tableB].CompanyImageUrl
UNION
SELECT tableA.Id, tableA.Name, '' AS Owner, '' AS ImageUrl, '' AS CompanyImageUrl, COUNT([tableC].Id) AS Number
FROM
[tableC]
RIGHT OUTER JOIN tableA ON [tableC].tableAId = tableA.Id GROUP BY tableA.Id, tableA.NameSELECT tableA.Id, tableA.Name, [tableB].Username AS Owner, [tableB].ImageUrl, [tableB].CompanyImageUrl, COUNT(tableD.UserId) AS NumberOfUsers, query2.NumberOfPlans
FROM tableD
RIGHT OUTER JOIN [tableB]
INNER JOIN tableA ON [tableB].Id = tableA.Owner ON tableD.tableAId = tableA.Id
INNER JOIN
(SELECT tableA.Id, COUNT([tableC].Id) AS NumberOfPlans
FROM [tableC]
RIGHT OUTER JOIN tableA ON [tableC].tableAId = tableA.Id
GROUP BY tableA.Id, tableA.Name) AS query2
ON query2.Id = tableA.Id
GROUP BY tableA.Name, [tableB].Username, [tableB].ImageUrl, [tableB].CompanyImageUrl//1
$welcome = mysqli_query($connect_db,"SELECT * FROM `welcome`");
//to
$welcome = $mysqli->query("SELECT * FROM `welcome`");
foreach($welcome->fetch_array() as $value) { }
//Вы серьезно ???
$news = mysqli_query($connect_db,"SELECT * FROM `news` WHERE `news`.`news_categoryid` = " . (int) $_GET['category_id']);
//
$category_id = \filter_input(INPUT_GET,'category_id', \FILTER_SANITIZE_NUMBER_INT);
$result- = $mysqli->query("SELECT * FROM `news` WHERE `news_categoryid` = '{$category_id}'");
while($row = $result->fetch_array()) { }$travel = [
"Russia" => [
"Moscow", "St-Peterburg", "Krasnoyarsk"
],
"Ukraine" => [
"Kiev", "Odessa", "Nikopol", "Donetsk"
],
"Belarusia" => [
"Minsk", "Bobruisk"
]
];
function getL2Keys($array)
{
$result = array();
foreach($array as $sub) {
$result = array_merge($result, $sub);
}
return array_keys($result);
}
echo '<pre>';
print_r(getL2Keys($travel));
echo '</pre>';'components' => [
'dbMySQL' => [
'class' => '\yii\db\Connection',
'dsn' => 'mysql:...',
'username' => '...',
'password' => '...',
'charset' => 'utf8',
],
'dbMongo' => [
'class' => '\yii\mongodb\Connection',
'dsn' => 'mongodb://...',
],
],Yii::$app->dbMySQL->...
Yii::$app->dbMongo->...(function($)
{
$(document).ready(function()
{
$.ajaxSetup(
{
cache: false,
beforeSend: function() {
$('#content').hide();
$('#loading').show();
},
complete: function() {
$('#loading').hide();
$('#content').show();
},
success: function() {
$('#loading').hide();
$('#content').show();
}
});
var $container = $("#content");
$container.load("file.php");
var refreshId = setInterval(function()
{
$container.load('file.php');
}, 9000);
});
})(jQuery);$files = array_slice($argv, 1);
foreach ($files as $file) {
$picture = file_get_contents($file);
$size = getimagesize($file);
// base64 encode бинарные данные, а затем разбить его на фрагменты в соответствии с семантикой RFC 2045
$base64 = chunk_split(base64_encode($picture));
echo '<img src="data:' . $size['mime'] . ';base64,' . "\n" . $base64 . '" ' . $size[3] . ' />', "\n";
}function base64_encode_image ($filename=string,$filetype=string) {
if ($filename) {
$imgbinary = fread(fopen($filename, "r"), filesize($filename));
return 'data:image/' . $filetype . ';base64,' . base64_encode($imgbinary);
}
}.logo {
background: url("<?php echo base64_encode_image ('img/logo.png','png'); ?>") no-repeat right 5px;
}<img src="<?php echo base64_encode_image ('img/logo.png','png'); ?>"/>class Example implements ExampleInterface
{
/****
* Я тебе везде пригожусь
*/
public function test()
{
return $this->view();
}
/****
* Я тебе нужен в этом классе, в другом месте хрен ты меня используешь.
*
* @return string
*/
protected function view()
{
return 'Привет ты меня использовал';
}
}
interface ExampleInterface
{
public function test();
}
class InitExample
{
public function release(ExampleInterface $ex)
{
echo $ex->test();
}
}