Embedded Files
Tools for web app/service dev
Tools for web app/service dev
curl
curl
curl -v http://git.company.com: Verbose the response when accessing http://git.company.com- If the response is 3XX (moved/redirection), then there must be Location: header that shows the redirection site.
- To automatically access to the redirect URL:
curl -L http://git.company.com. Then will redirect to the Location: header. - To use proxy when using curl, etc., from terminal:
- Activate
tunarcproxy.sh, which port-forwarding internal-proxy-server-port to localhost:12345 export http_proxy="http://localhost:12345"(unset http_proxy)export https_proxy="http://localhost:12345"(unset https_proxy)- Be careful for https_proxy, it is using http, not httpS:
- https://stackoverflow.com/questions/50840101/curl-35-error1408f10bssl-routinesssl3-get-recordwrong-version-number
- Activate
Web Service in the world
Web Service in the world
Jupyter with AWS EC2 <==== TODO
Jupyter with AWS EC2 <==== TODO
Jupyter with Google's GCE (Google Compute Engine) <==== TODO
Jupyter with Google's GCE (Google Compute Engine) <==== TODO
- GCE may be cheaper than EC2.
- However, no free tier from both. AND, my EC2 free tier t2.micro already expired...
- https://jeffdelaney.me/blog/running-jupyter-notebook-google-cloud-platform/
Web application on Heroku PaaS + Ruby on Rails <==== TODO
Web application on Heroku PaaS + Ruby on Rails <==== TODO
- http://myenigma.hatenablog.com/entry/2015/06/20/154445
- Heroku 入門: http://dotinstall.com/lessons/basic_heroku
- Install Ruby on Rails: http://qiita.com/keneo/items/1772adc2ebbde229fb71
- Ruby tutorial: https://blog.codecamp.jp/what_is_ruby
- Shebang for ruby script:
- http://qiita.com/tueda/items/369215b99316b2e9f3d8
#!/bin/shexec ruby -S -x "$0" "$@"#!ruby# -*- coding: utf-8 -*-puts RUBY_VERSIONprint("Hello, Ruby\n")#!/usr/bin/env ruby# -*- coding: utf-8 -*-puts RUBY_VERSIONprint("Hello, Ruby\n")
- Ruby on Rails tutorial:
- https://www.railstutorial.org/book
- http://guides.rubyonrails.org/getting_started.html
- codeanywhere: https://codeanywhere.com/
- https://blog.codecamp.jp/what_is_rails
- Learn Enough to Be Dangerous: https://www.learnenough.com/tutorials
- vi: http://stackoverflow.com/questions/4488979/how-to-move-one-word-left-in-vi-editor
- move hjkl, b backward 1 word, w forward 1 word
- $: go to end of line
- 0 or ^: go to beg of line
- delete until end of line: D or d$
- delete until beg of line: d0 or d^
- count action motion:
- 1dw: count 1, delete, forward 1 word
- dw: delete 1 word forward
- 55G: go to line 55
- G go to end, 1G go to begin
- :w save
- u for undo
- ZZ save and quit
- ^v visual for range
- :q!
- From less to vi: v
- Editor: TextMate
- In TextMate app: TextMate -> Preferences -> Terminal, support shell install.
- From shell: $ mate . OR mate asdf.rb
- Bundle concept: http://projects.serenity.de/textmate/tutorials/basics/
- Editor: Atom
- Opening project: $ atom .
- Fuzzy opening file: Command + p
- Tab switch: Command + 1 or 2 or 3
- Learn Enough to Be Dangerous: https://www.learnenough.com/tutorials
- Learn enough HTML:
- Metadata, css style, put in <head> tag.
- HTML skeleton:
<!-- -*- coding: utf-8 -*- --><!DOCTYPE html><html><head><title>Page Title</title><meta charset="utf-8"></head><body><p>Hello, world!</p></body></html>
Virtual Machine setup (VMWare ESXi)
Virtual Machine setup (VMWare ESXi)
VM setup
VM setup
- Use WebClient (Access to https://vm**** OR port forward from localhost to vm****:443)
- Open the VMware host client, the webclient for VMware. Can use vsphere client for windows.
- Create a new VM, edit the configuration to connect to CD-ROM which is inserted with datastore/media -> iso image.
- Open console (but, cannot open console when using port forwarding)
- In case of Mac OS + Chrome, the web client does not receive Ctrl-C. Firefox OK.
- Install VM ware tools (enable shutdown etc. from the web client):
- Install vmware tools for the VM using webclient or vsphere
- Then, from the guest os (ubuntu), do:
sudo apt-get install open-vm-tools
- Refresh web client to get the up-to-date vm info.
Unix command etc
Unix command etc
sudo poweroff- sudo apt-get update
- sudo apt-get upgrade
- Change from dhcp client to static IP address
- PATH setting in .profile, instead of .bashrc. Especially when using byobu (to prevent multiple assignment):
- http://itiut.hatenablog.com/entry/2013/07/07/114143
- See also Byobu part of https://sites.google.com/site/ivansetiawantky/macwork#TOC-UNIX-awk-perl-one-liner
- Emacs24
- sudo apt-get install emacs24
- In .bashrc set alias:
- alias emacs='TERM=xterm-256color emacs -nw' <==== USE THIS.
- alias emacs='TERM=xterm emacs -nw'
- http://stackoverflow.com/questions/7617458/terminal-emacs-colors-only-work-with-term-xterm-256color
- sudo apt-get install emacs-goodies-el
- copy .emacs from Ubuntu machine.
- Setting Emacs24 on vm:
- Basically install with package-list-packages from stable.melpa.org
- 1. undo tree 0.6.5, change the .emacs dot-emacs-load-path-list (needed)
- 2. install auto-complete
- In case cannot install auto-complete:
- http://emacs.stackexchange.com/questions/10480/cannot-install-auto-complete-package
- 1. emacs -Q
- 2. in scratch buffer:
(require 'package)(add-to-list 'package-archives'("melpa" . "http://[stable.]melpa.org/packages/") t)
- 3. Evaluate the buffer: M-x eval-buffer
- 4. M-x package-list-packages
- 3. highlight-symbol
- Then add path to highlight and popup
- 4. highlight-parentheses
- 5. php-mode
- 6. web-mode
- 7. sml-mode
- 8. markdown-mode
- 9. flymake-php
- Emacs -nw have some difficulties in key-binding, because the terminal itself cannot send / differentiate key bindings (http://d.hatena.ne.jp/hirose31/20040219/1160403206)
- Some discouragement ... :
- http://emacs.stackexchange.com/questions/17509/how-to-distinguish-c-i-from-tab
- http://emacs.stackexchange.com/questions/220/how-to-bind-c-i-as-different-from-tab
- For GUI mode Emacs, not terminal Emacs -nw: http://stackoverflow.com/questions/1792326/how-do-i-bind-a-command-to-c-i-without-changing-tab
- http://stackoverflow.com/questions/22426944/iterm2tmuxemacs-differentiating-between-tab-and-ctrl-i
- C-i and TAB is the same signal. So, C-i (incremental search) is always performed when we want to have tab-completion or indentation.
- Control-Shift-i is not working either.
- C-- (Control + Hyphen) for popup-mark is NOT send either (see above link)
- So, let's work using local emacs to modify remote file, using TRAMP.
- https://www.google.co.jp/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=working+with+emacs+in+remote+terminal
- http://stackoverflow.com/questions/846608/how-to-do-remote-development-with-emacs
- http://qiita.com/maueki/items/dac0aa68e3499fb46f26
- http://qiita.com/biwakonbu/items/1e4899ccb8f91cb69ff4
- HOWTO (TRAMP):
- 1. Port forward localhost:28022 to remote:22
- 2. C-x C-f /ssh:remoteuser@localhost#28022:/ <==== Dired seems working. Look from root.
- In case of freeze due to connection lost: M-x tramp-cleanup-all-buffers
- Can be used for "remote-compile"
- Bad: must do step 1, i.e., port forwarding. Need to end this if not needed.
- HOWTO2 (sshfs):
- 1. tunsshfs: mount using sshfs
- 2. Just do the work as in local files
- Bad: must do step 1, i.e., sshfs file mount. Need to unmount if not needed.
- HOWTO3 (TRAMP + using entry in localhost:~localuser/.ssh/config. <==== RECOMMENDED):
- Add this entry in the localhost:~/localuser/.ssh/config:
Host vm-remote.extUser userremoteHostName vm-remote.shamei.co.jpProxyCommand ssh userproxy@proxy.shamei.co.jp -W %h:%p
- 1. C-x C-f /ssh:vm-remote.ext:/ <==== Dired seems working, can access from root.
- Add this entry in the localhost:~/localuser/.ssh/config:
- No need to end connection, unmount, etc. Connection will be automatically killed when the Emacs is closed.
- In case of freeze due to connection lost: M-x tramp-cleanup-all-buffers
- TRAMP process can be terminated by killing the TRAMP run buffer with C-x C-k, just as usual buffer. OR:
- C-x C-b: list all buffers (Just return at the line to go to the buffer)
- Press d at the line where the buffer is to be killed (flag as delete) (u to undo)
- Press x to execute flag operation (delete in this case)
- C-x b (NOT C-x C-b (C-xb)) is for switching buffer
- With remote-process capability, C-c C-c will compile the cpp source with the remote machine environment, NOT the local emacs environment.
- https://www.gnu.org/software/emacs/manual/html_node/tramp/Remote-processes.html
- TRAMP process can be terminated by killing the TRAMP run buffer with C-x C-k, just as usual buffer. OR:
- Notice when using "M-x shell" via TRAMP:
- 1. PATH in the remote host .profile must be set using "export". CANNOT USE BASH SYNTAX.
- So, this will NOT work:
- export PATH=/some/path:$PATH
- But this will:
PATH=/some/path:$PATHexport PATH
- http://stackoverflow.com/questions/10463152/tramp-using-ssh-does-not-source-bash-profile-profile
- 2. Add below such that the path of the remote "M-x shell" also includes ones set by .profile in the remote host
(add-to-list 'tramp-remote-path 'tramp-own-remote-path)
- http://stackoverflow.com/questions/26630640/tramp-ignores-tramp-remote-path
- With SUDO:
- C-x C-f /sudo::/filename
- C-x C-f /sudo:localuser@localhost:/filename
- http://dqn.sakusakutto.jp/2011/08/tramp-emacs-sudo.html
- C-x C-f /ssh:vm-remote.ext|sudo:vm-remote.ext:/etc/passwd
- http://qiita.com/sakadonohito/items/c8861cd99efafbdf5319
- TRAMP hung up after sleep:
- https://www.reddit.com/r/emacs/comments/1q427w/tramp_mode_always_hangs_after_sleep/
- M-x tramp-cleanup-all-connections
- hold down C-g until you get prompt back, then M-x tramp-cleanup-all-connections
- HOWTO (TRAMP):
- Print the 10-th line of a file.sh to standard output (line num can be checked with cat -n file.sh):
tail -n+10 file.sh | head -1sed '10q;d' file.sh- Execute the 10th line only of a shell script:
- source + process substitution:
source <(tail -n+10 file.sh | head -1)
- source + process substitution:
tail -n+10 file.sh | head -1 | source /dev/stdin- Execute from the 10th line of a script:
source <(tail -n+10 file.sh)tail -n+10 file.sh | source /dev/stdin
Browser using terminal
Browser using terminal
- w3m
- w3m google.com
- Press enter before inputting text box
- v: Show source
- Shift u: load different URL
- Shift b: back to previous buffer. Current buffer is KILLED.
- s: select buffer
- H: help
- q / Q: quit with / without confirmation
Backup vm setting to dropbox
Backup vm setting to dropbox
- How to do?
- DO NOT ADD VM TO machine-list that can access Dropbox.
- Use Oauth2
- Steps:
- Create appli in dropbox (Choose between access to a special folder or full access):
- https://www.dropbox.com/login?cont=https%3A%2F%2Fwww.dropbox.com%2Fdevelopers%2Fapps%2Fcreate
- Generate token.
- Linked application is shown in Setting -> Security. Can delete the appli from here also.
- Get user info:
- $ curl https://api.dropbox.com/1/account/info/ -H "Authorization: Bearer TOKEN_HERE"
- Info is in JSON format.
- ls home/top-level-directory:
- ls a specific directory:
- Make directory
- Upload file
- Download file
- Delete directory
- Upload directory
- References:
- https://suin.io/542
- https://blogs.dropbox.com/developers/2013/07/using-oauth-2-0-with-the-core-api/
- https://www.dropbox.com/developers-v1/core/docs
- http://jlls.info/blog-entry.php?id=79246319145
- http://stackoverflow.com/questions/27873017/example-of-dropbox-api-put-using-curl-and-oauth-2-to-upload-a-file-to-dropbox
- Dropbox uploader shell script (maybe use it later):
- http://xmodulo.com/access-dropbox-command-line-linux.html
- https://github.com/andreafabrizi/Dropbox-Uploader
- Use dropShell.sh !!!
- File (directory/) to backup:
- .profile
- .bashrc
- .git-prompt.sh
- .svn-prompt.sh
- .emacs
- .emacs.d/
- src/
PHP development on Mac
PHP development on Mac
- Use Xcode, PhpStorm, Eclipse?
- What is PHP: https://techacademy.jp/magazine/6618
- What is MVC (Model-View-Controller): http://qiita.com/tshinsay/items/5b1724baf32b8b5113c2
- Constructing local web server on Mac: http://qiita.com/shuntaro_tamura/items/bdabcb77926dc92617b1
- Web dev env for Mac:
- https://mallinson.ca/osx-web-development/
- http://blog.hyec.jp/2014/02/mac-os-x-mavericksapachephpweb.html
Constructing local web server (+ PHP) on Mac
Constructing local web server (+ PHP) on Mac
- On El Capitan, httpd -v and php -v, are already installed.
- Auto load / unload of httpd apache:
- Check: sudo launchctl list | egrep 'http|apache' OR launchctl list | egrep 'http|apache'
- Stop automatic launch: sudo launchctl unload -w /System/Library/LaunchDaemons/org.apache.httpd.plist
- Start automatic launch: sudo launchctl load -w /System/Library/LaunchDaemons/org.apache.httpd.plist
- http://osxdaily.com/2015/08/30/automatically-start-apache-mac-os-x-boot/
- httpd start stop restart:
- sudo apachectl {start,stop,restart}
- ps auxww | grep httpd
- access http://localhost
- Log files location: /private/var/log/apache2
- Configuration:
- sudo vi /private/etc/apache2/httpd.conf
- Change DocumentRoot and <Directory> tag, to /newdir. Make sure /newdir is in 755 or 701 (ll -d /newdir).
- Activate LoadModule php5_module libexec/apache2/libphp5.so
- Allow html to be executed as php:
- AddType application/x-compress .Z (already active)
- AddType application/x-gzip .gz .tgz (already active)
- AddType application/x-httpd-php .php .html <==== Add this!
- Enable userdir access, i.e., enable accessing directory below DocumentRoot directory:
- Activate LoadModule userdir_module libexec/apache2/mod_userdir.so
- Activate Include /private/etc/apache2/extra/httpd-userdir.conf
- Copy html to /newdir
- Check apache2 configuration syntax with:
apachectl configtest!
- Check phpinfo in the server:
- vi $DocumentRoot/mytest/index.php
<?phpecho "Hello PHP";phpinfo();?>
- access localhost/mytest/index.php. See the source of the document using browser. No PHP source is shown.
- vi $DocumentRoot/mytest/index.php
- Enable per user directory in apache2 of MacOSX El Capitan:
- In /private/etc/apache2/httpd.conf, uncomment below if not uncommented:
- LoadModule userdir_module libexec/apache2/mod_userdir.so (maybe mod_authz_{host,core} also.
- Include /private/etc/apache2/extra/httpd-userdir.conf
- Edit /private/etc/apache2/extra/httpd-userdir.conf:
- UserDir -> public_html
- Add Include /private/etc/apache2/users/username.conf
- Edit /private/etc/apache2/users/username.conf:
- <Directory "/Users/username/public_html/">
- Options Indexes MultiViews
- AllowOverride None
- Require all granted
- </Directory>
- See also:
- http://stackoverflow.com/questions/24583859/apache-localhost-username-not-working
- https://coolestguidesontheplanet.com/get-apache-mysql-php-and-phpmyadmin-working-on-osx-10-11-el-capitan/
- In /private/etc/apache2/httpd.conf, uncomment below if not uncommented:
Constructing apache2 + PHP on Ubuntu
Constructing apache2 + PHP on Ubuntu
- Process is apache2: sudo apache2ctl {start,stop,restart}
- Configuration:
- Enable PHP parsing:
- sudo apt-get install php5 php5-cgi libapache2-mod-php5 php5-common php-pear
- sudo a2enconf php5-cgi.conf
- sudo vi /etc/php5/apache2/php.ini
- date.timezone = "Asia/Tokyo"
- sudo apache2ctl configtest
- /etc/init.d/apache2 restart
- See https://www.server-world.info/query?os=Ubuntu_14.04&p=httpd&f=3
- By the above setting, .php extension will be correctly parsed. Below, we will allow .html to be parsed as .php also:
- sudo vi /etc/apache2/mods-enabled/mime.conf; Add below line.
- AddType application/x-httpd-php .php .html
- sudo apache2ctl restart
- By the above setting, .php extension will be correctly parsed. Below, we will allow .html to be parsed as .php also:
- Enable PHP parsing:
- Enable per user directory:
- sudo a2enmod userdir
- Keep /etc/apache2/mods-enabled/userdir.conf as it is.
- To enable PHP in per userdir:
- sudo vi /etc/apache2/mods-enabled/php5.conf:
- Comment out mod_userdir.c as instructed.
- sudo apache2ctl configtest
- sudo apache2ctl restart
- See http://www.techytalk.info/enable-userdir-apache-module-ubuntu-debian-based-linux-distributions/
MySQL
MySQL
- Installation:
- Get the DMG: https://dev.mysql.com/downloads/mysql/
- http://www.dbonline.jp/mysqlinstall/
- Installed in /usr/local/mysql -> /usr/local/mysql5.7.17
- From system preference in Mac, stop/start the mysqld. Also set not to automatically start sql on startup.
- How to use: http://www.dbonline.jp/mysql/
- From system preference, start mysqld.
- mysqladmin -u root -p'oldpassword' password 'newpass'
- mysql -u root -p'newpass' -e 'show databases;'
- mysql -u root -p mysql -? mysql -V mysql --print-defaults
- mysql> quit; mysql> show databases;
- Other mysql prompt command: status, help, quit
- Mostly, ; is for concise display, \G is for detail display.
- show variables like 'char%'; show character set; (% is the wildcard *, while _ is the wildcard ?)
- Database creation:
- show variables like 'datadir';
- create database mytest;
- $ sudo ls -l /usr/local/mysql/data/
- $ sudo cat /usr/local/mysql/data/mytest/db.opt
- show databases;
- drop database mytest;
- create database testing character set utf8;
- select * from information_schema.schemata where schema_name = "testing"; (Use \G instead of ; )
- Alter database character set:
- http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8
- alter database database_name character set utf8 collate utf8_general_ci;
- Checking: select * from information_schema.schemata;
- Select database and table:
- use mytest; (or $ mysql -u root -p mytest)
- To see current connected database: show processlist; OR select database();
- show tables;
- select * from dbname.tablename;
- Create / drop user:
- Connect with root, then:
- create user 'kuda'@'localhost' identified by 'pswd';
- select user, host from mysql.user;
- Connect with kuda by:
- $ mysql -u kuda -p
- show databases; only show database visibled by kuda.
- drop user 'kuda'@'localhost'
- Connect with root, then:
- Table:
- create database sampledb [character set utf8]; (select * from information_schema.schemata;)
- create table sampledb.sampletbl (id int) character set utf8; (can have different character set from the default database's character set)
- show tables from sampledb; show table status\G show table status from sampledb\G (detailed table)
- show table status like 'goods'\G (see like auto increment etc.)
- create table goods (id int); show columns from tablename;
- create table pritest(id int not null primary key, name varchar(10))
- show columns from pritest;
- show index from pritest\G
- insert into pritest(id, name) values(1,'扇風機');
- insert into pritest values(2,'掃除機'); select * from pritest;
- create table pritest2 like pritest; show columns from pritest; select * from pritest;
- View:
- View is like a part of table. It is also updated when the original table is updated.
- create table products(id int not null primary key, name varchar(20), category varchar(20));
- insert into products values (1,'a','b'), (1,'a','c'); (ERROR, same id)
- insert into products values (1,'a','b'), (2,'a','c');
- delete from products where id=1;
- delete from products;
- insert into products values (1, "Coffee", "Drink"), (2, "Orange", "Fruit"), (3, "Melon", "Fruit"), (4, "Tea", "Drink"), (5, "Banana", "Fruit"), (6, "Water", "Drink");
- create view drink_products as select id, name from products where category = "Drink";
- select * from drink_products;
- create view categorylist as select distinct category from products;
- create view fruit_products(id, fruitname) as select id, name from products where category = "Fruit";
- show tables; <==== View is treated as tables.
- show table status like "food%"\G <==== VIEW ('food%' or "food%")
- update products set name="Hot Coffee" where id=1;
- delete from products where id=2;
- insert into products values (8, "Martabak", "Food");
- select * from {drink_products, categorylist, fruit_products}; <==== Also updated along with the original products table.
- Data (row) insert, update, delete:
- create table tokyo_sales (name varchar(20), count int, d date);
- insert into tokyo_sales values ('Banana', 10, '2009-10-13'), ('Melon', 7, '2009-10-12'), ('Orange', 12, '2009-10-18'), ('Apple', 5, '2009-10-10');
- create table osaka_sales (name varchar(20), count int, d date);
- insert into osaka_sales values ('Orange', 4, '2009-10-02'), ('Strawberry', 21, '2009-10-05'), ('Orange', 7, '2009-10-07'), ('Watermelon', 3, '2009-10-12');
- create table sales(name varchar(20) unique, count int);
- insert into sales select name, count from osaka_sales; <==== ERROR
- insert into sales select name, count from osaka_sales on duplicate key update count=sales.count+values(count);
- insert into sales select name, count from tokyo_sales on duplicate key update count=sales.count+values(count);
- select name from sales;
- select count from sales;
- Data select:
- select * from dbname.tablename;
- select * from dbname.tablename\G (\G (capital G) will return after displaying each column. Better visualization for data with a long string in the column)
- show table status\G
- select count*3 from sales; select 9*7+2;
- ----
- create table seiseki(name varchar(20), suugaku int, eigo int, kokugo int);
- insert into seiseki values ('木下',54,92,58), ('山口',82,47,62), ('長谷部',91,83,87), ('竹部',72,76,69);
- select name, suugaku+eigo+kokugo, round((suugaku+eigo+kokugo)/3.0) from seiseki;
- select name, suugaku+eigo+kokugo as goukei, round((suugaku+eigo+kokugo)/3.0) as heikin from seiseki;
- elect name, suugaku+eigo+kokugo as goukei, (suugaku+eigo+kokugo)/3.0 as heikin from seiseki;
- You can only use column aliases (AS) in GROUP BY, ORDER BY, or HAVING clauses. http://stackoverflow.com/questions/942571/using-column-alias-in-where-clause-of-mysql-query-produces-an-error
- select name, suugaku+eigo+kokugo as goukei, (suugaku+eigo+kokugo)/3.0 as heikin from seiseki where heikin between 70 and 100; <==== ERROR
- select name, suugaku+eigo+kokugo as goukei, (suugaku+eigo+kokugo)/3.0 as heikin from seiseki having heikin between 70 and 100;
- select name, suugaku+eigo+kokugo as goukei, (suugaku+eigo+kokugo)/3.0 as heikin from seiseki order by heikin desc;
- select * from osaka_sales where d between '2009-9-1' and '2009-10-6';
- ----
- create table personal(name varchar(20), hobbies varchar(30));
- insert into personal values ('Yamada', 'Sports, Movie'), ('Endou', 'movie,drive'), ('Nishioka', 'Reading, drive'), ('Akagi', 'Travel');
- select * from personal where hobbies like '%Movie%';
- select * from personal where hobbies like binary '%Movie%';
- ----
- create table salarylist (salary int, pref varchar(20));
- insert into salarylist values (240000, 'Tokyo'), (290000, 'Sapporo'), (280000, 'Tokyo'), (250000, 'Osaka'), (245000, 'Tokyo'), (210000, 'Sapporo'), (2340000, 'Osaka');
- update salarylist set salary=234000 where salary=2340000 and pref='Osaka';
- select pref, avg(salary) as avgsal from salarylist group by pref;
- select pref, avg(salary) as avgsal from salarylist group by pref desc
- select pref, avg(salary) as avgsal from salarylist group by pref order by avgsal;
- select pref, avg(salary) as avgsal from salarylist group by pref order by avgsal desc;
- select pref, avg(salary) as avgsal from salarylist group by pref having avgsal>245000 order by avgsal desc;
- ----
- select distinct name[, count] from osaka_sales;
- ----
- create table accesslog (searchengine varchar(20), d date);
- insert into accesslog values ('Google', '2009-10-24'), ('Yahoo', '2009-10-25'), ('BING', '2009-10-25'), ('Google', '2009-10-26'), (null,'2009-10-27'), ('Yahoo', '2009-10-28'), ('Google', '2009-10-30'), ('BING', '2009-10-30'), ('Google', '2009-10-31');
- select count(*) from accesslog;
- select count(searchengine) from accesslog;
- select searchengine, count(searchengine) from accesslog group by searchengine;
- select searchengine, count(*) from accesslog group by searchengine;
- ----
- Connect to MySQL from PHP: http://www.phpbook.jp/tutorial/mysql/ (For Windows)
- Setting php:
- Create HTML with <?php phpinfo(); ?> or php --ini, to find the location of php.ini.
Uncomment extension=php_mysql.dll in php.ini.<==== This is for windows.- For mac:
- No need to copy to /etc/php.ini. No need to do anything. Just do below:
- http://qiita.com/DQNEO/items/97ffe7c33a37e1724f0c
- Replace "localhost" below with "localhost:/tmp/mysql.sock"
- Make sure NO warning / error when doing: php -i | grep socket
- Test with $ php test1.php
- Prepare mysql database:
- mysql -u root -p
- create database uriage character set utf8;
- create table uriage.hanbai(id int not null primary key, shouhin_id int, uriage int);
- create table uriage.shouhin( id int not null primary key, name varchar(20));
- create user 'testuser'@'localhost' identified by 'thepswd';
- grant all on uriage.* to 'testuser'@'localhost';
- insert into uriage.shouhin values (1, 'テレビ'), (2, 'DVD'), (3, 'パソコン');
- insert into uriage.hanbai values (1,1, 320000), (2,2, 160000), (3,3, 180000), (4,1, 128000), (5,3, 98000), (6,2, 140000), (7,1, 175000);
- test1.php:
- vi $DocumentRoot/test1.php
<html><head><title>PHP TEST</title></head><body><?php$link = mysql_connect('localhost:/tmp/mysql.sock', 'testuser', 'thepswd');if (!$link) {die('接続失敗です。'.mysql_error());}print('<p>接続に成功しました。</p>');// MySQLに対する処理$close_flag = mysql_close($link);if ($close_flag){print('<p>切断に成功しました。</p>');}?></body></html>
- sudo apachectl start;
- Use browser to access http://localhost/test1.php
- 当然のように、失敗：No such file or directory.
- php -i | grep socket: Unable to load dynamic library...
- vi $DocumentRoot/test1.php
- test4.php:
<html><head><title>PHP TEST</title></head><body><?php$link = mysql_connect('localhost:/tmp/mysql.sock', 'testuser', 'thepswd');if (!$link) {die('接続失敗です。'.mysql_error());}print('<p>接続に成功しました。</p>');$db_selected = mysql_select_db('uriage', $link);if (!$db_selected){die('データベース選択失敗です。'.mysql_error());}print('<p>uriageデータベースを選択しました。</p>');mysql_set_charset('utf8');$result = mysql_query('select id,name from shouhin');if (!$result) {die('クエリーが失敗しました。'.mysql_error());}while ($row = mysql_fetch_assoc($result)) {print('<p>');print('id='.$row['id']);print(',name='.$row['name']);print('</p>');}$close_flag = mysql_close($link);if ($close_flag){print('<p>切断に成功しました。</p>');}?></body></html>
- Setting php:
Prepare web + PHP development environment in Mac
Prepare web + PHP development environment in Mac
- DNS masquerade (setting website as subdomain), backup service etc: https://mallinson.ca/osx-web-development/
- http://blog.hyec.jp/2014/02/mac-os-x-mavericksapachephpweb.html
- Just use Xcode, PhpStorm, Emacs, Eclipse to edit the PHP source file.
Trying NetBeans:- Need Java8 / latest.
- Has C/C++, Java, PHP, ... dev env.
- Trying Eclipse PDT:
- Need Java8 / latest.
- http://white-bear.info/archives/1822
- No need to JP. Before launching, do:
- /Applications/eclipse/php-neon/Eclipse.app/Contents/MacOS/eclipse -clean
- How to change Ctrl+K shortcut????
- No need to JP. Before launching, do:
PHP + MySQL tutorials
PHP + MySQL tutorials
- Connect to MySQL from PHP: http://www.phpbook.jp/tutorial/mysql/
- See above.
- PHP tutorial: https://www.tutorialspoint.com/php/index.htm
- Learn PHP here! Xcode or maybe Emacs, Eclipse, PhpStorm. <==== DOING
- For a pure .php file (no mixing with html tag etc), then use <?php opening tag ONLY. NO need closing ?> tag.
- To enable execution of <?php ?> inside html tag, the file needs to have .php extension.
- To comment out <?php ?>, do NOT encapsulate the block with <!-- -->. Instead, change <?php to <!--, and ?> to -->.
- Or comment the contents of <?php ?> only (C-rc between <?php ?>:
<?php// $filename = "newfile.txt";// $file = fopen( $filename, "w" );// if( $file == false ) {// echo ( "Error in opening new file" );// exit();// }// fwrite( $file, "This is a simple test\n" );// fclose( $file );?>
- Be careful with external program execution:
<?phpecho exec('whoami') . "\n <br>";echo exec('groups') . "\n <br>";echo exec('echo $PATH') . "\n <br>";echo exec('which whoami') . "\n <br>";echo exec('pwd') . "\n <br>";echo exec('w') . "\n <br>";echo exec('cd ~') . "\n <br>";echo exec('cd ..') . "\n <br>";echo exec('echo $HOME') . "\n <br>";echo exec('pwd') . "\n <br>";echo exec('date') . "\n <br>";$phpdate = getdate();foreach($phpdate as $key => $val) {print "$key = $val\n<br />";}echo "\n <br>";// echo exec('mkdir ./tutorpnt2') . "\n <br>";echo exec('cd ./tutorpnt') . "\n <br>";echo exec('pwd') . "\n <br>";
- PHP tutorial: http://www.freewebmasterhelp.com/tutorials/php/1
- PHP + MySQL tutorial: http://www.freewebmasterhelp.com/tutorials/phpmysql
- PHP + MySQL tutorial: https://www.tutorialspoint.com/php/php_and_mysql.htm
Post/Redirect/Get (PRG) pattern in PHP
Post/Redirect/Get (PRG) pattern in PHP
Need to activate SESSION in php.ini(SESSION holds parameter unique to the pair of browser and site).- When session.save_path is empty, the location of the session file can be checked with:
<?php echo sys_get_temp_dir(); ?>- In Mac, it is /var/tmp.
- http://stackoverflow.com/questions/4927850/location-for-session-files-in-apache-php
- PRG with one file: http://wordsideasandthings.blogspot.jp/2013/04/post-redirect-get-pattern-in-php.html
<!-- -*- coding: utf-8 -*- --><?phpsession_start();$echoedShout = "";if(count($_POST) > 0) {$_SESSION['shout'] = $_POST['shout'];header("HTTP/1.1 303 See Other"); // For redirection.// header("Location: http:$_SERVER[HTTP_HOST]/mytest/prg/echochamber.php");header("Location: ./echochamber.php");// OR// header("Location: ./echochamber.php?redirect=true");die();}else if (isset($_SESSION['shout'])){$echoedShout = $_SESSION['shout'];/*Put database-affecting code here.*/session_unset();session_destroy();}?><!DOCTYPE html><html><head><title>PRG Pattern Demonstration</title><body><?php echo "<p>$echoedShout</p>" ?><form action="./echochamber.php" method="post"><input type="text" name="shout" value="" /></form></body></html>- PRG with two files, userInput, userView: http://d.hatena.ne.jp/j5ik2o/20070301/1172734267
Embed object/wav audio to html
Embed object/wav audio to html
- http://stackoverflow.com/questions/13821164/create-a-wav-file-of-a-certain-frequency-with-php
- tempnam sys_get_temp_dir
How to pass parameters between page call without using $_GET
How to pass parameters between page call without using $_GET
- Encoded URL (http://address.com?key1=value1&key2=value2) passed with HTTP GET has limitation in character length. Use $_SESSION instead to pass them.
- http://www.atmarkit.co.jp/bbs/phpBB/viewtopic.php?topic=29275&forum=12
- http://stackoverflow.com/questions/663442/php-session-variables-not-preserved
- http://stackoverflow.com/questions/26683125/use-sessions-variables-between-different-php-files
- http://php.net/manual/en/session.examples.basic.php
- http://www.tizag.com/phpT/phpsessions.php
Page updated
Google Sites
Report abuse