This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="utf-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<meta name="viewport" content="width=device-width, initial-scale=1"> | |
<title>Bootstrap 101 Template</title> | |
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"> | |
</head> | |
<body> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT SUM(IF(category_id=1,1,0)) as category_one, SUM(IF(category_id=2,1,0)) as category_two, SUM(IF(category_id=3,1,0)) as category_three, SUM(IF(category_id=4,1,0)) as category_four, SUM(IF(category_id=5,1,0)) as category_five, SUM(IF(category_id=6,1,0)) as category_six, SUM(IF(category_id=7,1,0)) as category_seven, SUM(IF(category_id=8,1,0)) as category_eight, SUM(IF(category_id=9,1,0)) as category_nine, SUM(IF(category_id=10,1,0)) as category_ten, SUM(IF(category_id=11,1,0)) as category_eleven, SUM(IF(category_id=12,1,0)) as category_twelve FROM my_table |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Релационна база от данни | |
Това е БД, която организира структурите данни в отделни двуизмерни таблици, които имат взаимовръзка (релация) между тях. Двуизмерна таблица означава, че даните са групирани в редове и колони: всяка колона репрезентира атрибут или свойство на запазеният обект, а всеки ред е отделен обект или инстанция на данните (запис, туплет). Релацията се дефинира като данни, които имат еднакви атрибути. Има множество различни имплементации на РБД като MySQL, PostgreSQL, OracleDB, Microsoft SQL Server и др. като се вижда, че обединяващ фактор във всички е наличието на съкращението SQL. | |
2. Агрегатни функций | |
Предназначение | |
Те позволяват да се пресмятат обобщения за множества от кортежи | |
COUNT(*) - връща броя на кортежите; COUNT(attribute) : връща броя на стойностите на атрибута (без NULL стойностите). | |
SUM(attribut) - връща сумата на стойностите на атрибута. | |
AVG(attribut) - връща средната стойност на стойностите на атрибута. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<h2>CORS (Cross-Origin Resource Sharing)</h2> | |
<p>When you do a cross-origin request, the browser sends <code>Origin</code> header with the current domain value.</p> | |
<pre> | |
Origin: http://zinoui.com</pre> | |
<p>When the server receives the request, check whether the origin header is within the allowed list, and sends a response with <code>Access-Control-Allow-Origin</code></p> | |
<pre> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
You probably have a permission issue. Add your user ID to group vboxusers with this command: sudo usermod -a -G vboxusers $USER, log off, log on and try again. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Dig (domain information groper) е програма за Linux също както е nslookup за Windows. Тя е малко по мощна. Тук са описани някои възможности за използването и, заявки към различни nameserver-и, заявки към специфични записи на nameserver (A, AAAA, MX, CNAME, TXT) и други. | |
Инсталиране на dig | |
Ако работите с Red Hat базирана дистрибуция (centos, fedora, red hat), може да използвате yum: | |
yum install bind-utils | |
За всяка Debian базирана е apt-get: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Какво е WGet ? | |
wget е съкращение от "web get". Това е command-line програма която се използва за сваляне на файлове от интернет. | |
Синтакс | |
wget [option]... [URL]... | |
Подробно описание |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Какво е CURL ? | |
cURL е инструмент за прехвърляне на информация от и към сървър чрез използването на някой от поддържаните протоколи (DICT, FILE, FTP, FTPS, GOPHER, HTTP, HTTPS, IMAP, IMAPS, LDAP, LDAPS, POP3, POP3S, RTMP, RTSP, SCP, SFTP, SMB, SMBS, SMTP, SMTPS, TELNET and TFTP). Програмата е направена да работи без намеса на потребителия. | |
cURL също поддържа proxy, user authentication, FTP ъплоад, HTTP post, SLL връзки, кукита, файлов трансфер, металинк и много други функции. | |
Статус на операциите | |
cURL обикновенно показва статуса на текущата операция, количество на прехвърлената информация, бързина на прехвърляне, очаквано време за приключване и други. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
if (!defined('BASEPATH')) | |
exit('No direct script access allowed'); | |
function mb_ucfirst($str, $encoding = "UTF-8", $lower_str_end = false) { | |
$first_letter = mb_strtoupper(mb_substr($str, 0, 1, $encoding), $encoding); | |
$str_end = ""; | |
if ($lower_str_end) { | |
$str_end = mb_strtolower(mb_substr($str, 1, mb_strlen($str, $encoding), $encoding), $encoding); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Understanding the differences between Illustrator and Photoshop | |
can range from confusing to downright frustrating for those who are | |
new to graphics and image editing. Which application should you use | |
for your project? Should you use a combination of the two together, or | |
just stick with one? Having a household name as Photoshop does, many people | |
simply turn to Photoshop for all their work, but that may not be the best | |
choice for all your graphics work. | |
It really boils down to having an understanding not only of what you wish to achieve, | |
but also having a firm grasp on the key differences between Photoshop and Illustrator; |