| <?php | |
| /** | |
| * How to get substring UTF-8 characters | |
| */ | |
| // If you try something like this | |
| $utf_8_characters = 'Sábado'; | |
| echo substr($utf_8_characters, 0, 3); | |
| // you get something like "Sá", but not "Sáb" |
| function show_my_videos(data){ | |
| html = ['<ul id="youtube-videos">']; | |
| $(data.feed.entry).each(function(entry){ | |
| url = this.link[0].href; | |
| url_thumbnail = this.media$group.media$thumbnail[3].url; | |
| description = this.media$group.media$description.$t; | |
| html.push('<li><a href="'+url+'">'); | |
| html.push('<img src="'+url_thumbnail+'" alt="'+description+'">'); | |
| html.push('</a></li>'); | |
| }); |
#Django + git + apache mod_wsgi na Kinghost
NOTE: Atualmente não é necessário tanto para fazer deploy de aplicações Django na Kinghost.
I hope you like it!
##Início
Talvez você não queira ficar digitando a senha toda vez que usar o ssh, então adicione sua chave pública ao seu host:
| sudo apt-get build-dep python-mysqldb | |
| pip install mysql-python |
| -- This problem happens when you try to order columns ASC | |
| -- and you want to ignore the 0 values in the first results | |
| SELECT `DATABASE_NAME`.* | |
| FROM `TABLE_NAME` | |
| ORDER BY | |
| CASE WHEN `FIELD_FILL_WITH_0` in("", "0") THEN 1 | |
| ELSE 0 END, `FIELD_FILL_WITH_0_OR_ANY_OTHER_FIELD` ASC |
| /* Example */ | |
| /* Par */ | |
| ul li:nth-child(even){ | |
| background:#fff; | |
| } | |
| /* Ímpar */ | |
| ul li:nth-child(odd){ | |
| background:#000; |
| # I don't know why, but everytime than i try to install or update splinter in my pc | |
| # i get this error: src/lxml/etree_defs.h:9:31: fatal error: libxml/xmlversion.h | |
| # anyway i try to discover why, for while this is a solution: | |
| # install/upgrade libxml2-dev and libxslt-dev | |
| sudo apt-get install libxml2-dev libxslt-dev |
| # 1 ANO | |
| <FilesMatch "\.(ico|pdf|flv)$"> | |
| Header set Cache-Control "max-age=29030400, public" | |
| </FilesMatch> | |
| # 1 SEMANA | |
| <FilesMatch "\.(jpg|jpeg|png|gif|swf)$"> | |
| Header set Cache-Control "max-age=604800, public" | |
| </FilesMatch> | |
| # 2 DIAS | |
| <FilesMatch "\.(xml|txt|css|js)$"> |
| # Export and pack | |
| mysqldump -uUSER -pPASSWORD database_name --compact --host=HOST_IP_ADDRESS | gzip > mysqlbackup.sql.gz | |
| # Unpack | |
| gunzip mysqlbackup.sql.gz | |
| # Importing free of troubles with Foreign Key Restriction From innoDB Tables | |
| mysql -uUSER -pPASSWORD | |
| # MySQL terminal | |
| mysql> CREATE DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci; |
| git checkout -b issue2 | |
| # after fix | |
| git add YOUR_FILES_HERE | |
| git commit -m "fixing #issue2" | |
| git checkout master | |
| git merge issue2 | |
| git branch -d issue2 |
