Category: Програмирование

Я программист, этим работаю, и здесь буду выкладывать кое какие открытия для себя, скрипты ну и прочее что удостоится моего внимания, и на что хватит время\вдохновения

Index column size too large. The maximum column size is 767 bytes.

Проблема много где описана, но решается на уровне рута и настройки базы данных

mysql

set global innodb_file_format = BARRACUDA;

set global innodb_large_prefix = ON;

SET GLOBAL innodb_default_row_format = DYNAMIC;

Windows 10 subsystem ubuntu apache2 + mysql

sudo su

apt update

apt install apache2 mysql

nano /etc/apache2/sites-available/sites.loc.conf

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
# Place any notes or comments you have here
# It will make any customisation easier to understand in the weeks to come
 
# domain: domain1.com
# public: /home/demo/public_html/domain1.com/
 
<VirtualHost *:80>
 
  # Admin email, Server Name (domain name) and any aliases
  ServerAdmin webmaster@domain1.com
  ServerName  sites.loc
  ServerAlias www.sites.loc
 
 
  # Index file and Document Root (where the public files are located)
  DirectoryIndex index.php
  DocumentRoot /mnt/c/work/website/sites.loc/html
 
 
  # Custom log file locations
  LogLevel warn
  ErrorLog /var/log/apache2/error-mydomainname.com.log
  CustomLog /var/log/apache2/access-mydomainname.com.log combined
 
</VirtualHost>

add in

nano /etc/apache2/apache2.conf

1
<Directory /mnt/c/work/website/*>                                                                                                      Options Indexes FollowSymLinks MultiViews                                                                               AllowOverride All                                                                                                       Order allow,deny                                                                                                        allow from all                                                                                                          Require all granted                                                                                              </Directory>  

a2ensite sites.loc

service apache2 restart

add in c:\Windows\System32\drivers\etc\hosts

127.0.0.1 cprice.loc

a2enmod rewrite

service apache2 restart

Find the php.ini on your server. In wamp you click on the toolbar icon -> select PHP -> select php.ini

Push ctrl+ f and find "realpath_cache_size" . Remove the semi-colon at the beginning of the line and make it =16M instead of 16k .

This all

Установка Drupal через drush

Установить друпал можно через командную строку в одну строку!!!! Ну если быть точнее через две.

#Первая строка скачивает drupal
drush dl drupal

#установка друпалла
drush site-install standard --account-name=LoginAdmin --account-pass=passwordAdmin --db-url=mysql://UserDB:PasswordDB@localhost/NameDB

Больше команд можно почитать здесь

Анимация css

Пример анимации на CSS очень прикольно! 🙂

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

.uwloader{
	background: url(http://my-opinions.info/wp-content/uploads/2014/09/preloader.png) no-repeat;
	background-size: 80px 80px;
	position: fixed;
	top: 50%;
	left: 50%;
	margin-left: -30px;
	margin-top: -30px;
	width: 80px;
	height: 80px;
	-webkit-animation: rotateplane 2s infinite ease-in-out;
	animation: rotateplane 2s infinite ease-in-out;
}
@-webkit-keyframes rotateplane {
    0% {
    -webkit-transform: perspective(120px) rotateX(0deg) rotateY(0deg)
	}
	25% {
	    -webkit-transform: perspective(120px) rotateX(-180.1deg) rotateY(0deg)
	}
	50% {
	    -webkit-transform: perspective(120px) rotateX(-180deg) rotateY(-179.9deg)
	}
	75% {
	    -webkit-transform: perspective(120px) rotateX(0deg) rotateY(-179.9deg)
	} <a href="http://my-opinions.info/en/programing/css/animaciya-css#more-266" class="more-link">Continue reading <span class="screen-reader-text">Анимация css</span></a>

 

XML -> PHP

It's no longer the post as well primetka for myself that would not have forgotten

1
2
simplexml_load_file("file.xml");
simplexml_load_string($xml_string);

At output you get an object with a pre-packaged xml. That's super easy and super convenient.
The only thing that should probably be noted that this method requires php5 and I understand some module, well, I have gone without a shaman. If that is not the path to the php.ini file
For example, you can write here is a simple file

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
$xml="<request>     
<version>1.2</version>
<result_url>http://ulove.ua//buy/</result_url>
<server_url>http://ulove.ua//buy/resultliqpay/</server_url>
<merchant_id>i4927007979</merchant_id>
<order_id>128</order_id>
<amount>12</amount>
<currency>USD</currency>
<description>uLove</description>
<default_phone>+380938729936</default_phone>
<pay_way>card</pay_way>
</request>";
$xml=simplexml_load_string($xml);
print_r($xml);
echo $xml->order_id;

On the screen we

01
02
03
04
05
06
07
08
09
10
11
12
13
14
SimpleXMLElement Object
(
    [version] => 1.2
    [result_url] => http://ulove.ua//buy/
    [server_url] => http://ulove.ua//buy/resultliqpay/
    [merchant_id] => i4927007979
    [order_id] => 128
    [amount] => 12
    [currency] => USD
    [description] => uLove
    [default_phone] => +380938729936
    [pay_way] => card
)
128

My opinion, this is the easiest option, who will offer easier listen.

Настройка PhpMyAdmin для локал хоста

Вот как то долго не настраивал PhpMyAdmin, а потом взял и настроил! ) создаем в корне папки PhpMyAdmin файл config.inc.php и вставляем туда вот такое Continue reading Настройка PhpMyAdmin для локал хоста