tps2015gh

Python

• https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html

• https://www.tutorialspoint.com/python/python_functions.htm

• https://www.tutorialspoint.com/python/python_while_loop.htm

• https://wiki.python.org/moin/ForLoop

• https://www.tutorialspoint.com/python/python_if_else.htm

tps2015gh

Python MySQL

• https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchone.html
• type(var1) - เช็คว่าเป็น type อะไร http://stackoverflow.com/questions/402504/how-to-determine-the-variable-type-in-python
• tuple - https://www.tutorialspoint.com/python/python_tuples.htm
• tuple จะเกิดเมื่อ cursor.fetchone() จาก database - https://www.tutorialspoint.com/python/python_tuples.htm

NumPy

• หาค่า mean https://docs.scipy.org/doc/numpy/reference/generated/numpy.mean.html

tps2015gh

CHECK SERVER IS UP

• http://stackoverflow.com/questions/1949318/checking-if-a-website-is-up-via-python
• Delay or Sleep - http://stackoverflow.com/questions/510348/how-can-i-make-a-time-delay-in-python
• http.client — HTTP protocol client - https://docs.python.org/3/library/http.client.html

NOTE: Must Use exception http.client.HTTPException in Python3

#Python 2 to Python3

• PORT Code - http://www.diveintopython3.net/porting-code-to-python-3-with-2to3.html

tps2015gh

Requirement :

• python 3.4 (Tested with this version )
• Windows 10 ,32 Bit

Sample File

READ FROM CSV File

require pandas as pd fname = "c:/data/data_file_thai_utf8.txt" d = pd.read_csv(fname, encoding="utf-8",nrows=15000,sep='\t') print(d)

tps2015gh

Sample code for create Vue.js Component

tps2015gh

# Git Command 

## GIT change userName 
- (https://help.github.com/articles/setting-your-username-in-git/)

tps2015gh

how to composer update

for xampp user , windows os

• use this batch to update and install in

c:\> c:\xampp\php\php.exe composer.phar update
c:\> c:\xampp\php\php.exe composer.phar install

tps2015gh

I Found some code in stacke overflow is error .

• function is_found(p) is ok
• function is_found2(p) from stack overflow is fail !
• ref: (http://stackoverflow.com/questions/21729960/how-do-i-use-syntax-highlighting-in-php-within-a-markdown-github-gist)
• you can test this code by paste to page (http://phptester.net/)

<?php

echo "<h1>Test strpost() PHP </h1>"; 

tps2015gh

Check URL and Text

• This use PHP , CodeIgniter Framework
• This code is in controller file in project
• check url with text
• This in PHP Unit Test Code

<?php 

tps2015gh

#Windows 10 Symbol link

CREATE

• create virtual link in _pico folder named 'content'
• real data store in myapp1_pico_content\content
• when modify real data , data in vitual "look like" change too .
• C:\xampp\htdocs_pico>mklink /d content C:\xampp\htdocs\myapp1_pico_content\content
• /d mean create as directory

OUTPUT AFTER CALL