James Cheng

Showing all posts tagged #programming:

MySQL

Posted on October 7th, 2014

[GUI tools]
  1. INSERT INTO `joolma`.`jm_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (NULL, 'Super User', 'kylab', 'jb035.cheng@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', '', '', '0000-00-00 00:00:00.000000', '0', '', '', '0');
  2. INSERT INTO `joolma`.`jm_devices` (`mac`, `id`, `name`, `d_id`) VALUES ('112233445566', '984', 'watch', NULL);
[SELECT]
  1. 123
[INSERT]
  1. http://www.1keydata.com/tw/sql/sqlinsert.html
  2. INSERT INTO "表格名" ("欄位1", "欄位2", ...)
    VALUES ("值1", "值2", ...);
[UPDATE]
  1. http://www.1keydata.com/tw/sql/sqlupdate.html
  2. UPDATE Store_Information
    SET Sales = 500
    WHERE Store_Name = 'Los Angeles'
    AND Txn_Date = 'Jan-08-1999';

joomla

Posted on September 30th, 2014

[Installation Reference]
  1. XAMPP: https://www.apachefriends.org/download.html
    http://www.orztw.com/2014/06/xampp-install-on-windows.html
  2. After installing XAMPP, start the services. (Apache,MySQL, Tomcat)
  3. http://localhost/xampp/index.php
    Check the statu , if the services are running.
  4. To set the security for MySQL, XAMPP http://localhost/security/xamppsecurity.php
    http://duckycool.pixnet.net/blog/post/138688573-%E8%87%AA%E5%B7%B1%E7%8E%A9%E6%9E%B6%E7%AB%99---xampp
  5. Download the joolma full package : http://www.joomla.org/download.html#j3
  6. http://blog.winwu.today/2013/08/joomla-3xx.html
  7. Stuck in database installation : http://www.smartaddons.com/blog/item/1035-joomla-quickstart-package-installation-problems-and-solutions
    Open file php.ini in C:\xampp\php\php.ini

    Note: Stop Apache server before doing any modifications and start it again after saving these modifications.
    Tip 1: Turn off "display errors"
    In php.ini, find line "display_errors=On" replace with "display_errors=Off"

    Tip 2: Increase execution time in php.ini
    Find line "max_execution_time=30" change to "max_execution_time=3000"

    Tip 3: Increase memory limit
    Increase "memory_limit=128M" to "memory_limit=256M"

[AppServ]
[mobile]
  1. Joomla! Module 模組開發範本: http://lab.asika.tw/joomla/modules/10-joomla-module-example.html
  2. JOOMLA! 開發相關教學資源: http://ilovejoomla.tw/index.php/knowledge/joomla-application/development/50-joomla-related-to-the-development-of-teaching-resources.html
  3. 如何開發一個Joomla1.5模組-1 : http://cave-gvee.blogspot.tw/2010/09/how-to-create-joomla15-module.html
  4. Joomla 程式設計: http://wang.mis.au.edu.tw/index.php/component/flexicontent/8-2013-03-12-06-32-58/28-10002-joomla-3all
  5. http://www.joomla.org.tw/index.php/tutorial/install-manage/requirement
  6. Joolma Taiwain : http://www.joomla.org.tw/
  7. http://joomla123.com.tw/afu/2009-03-03-14-02-20.html
  8. http://missmarket.pixnet.net/blog/post/30785051-%E8%87%AA%E5%B7%B1%E6%9E%B6%E7%B6%B2%E7%AB%99-joomla%3A-%E8%AA%8D%E8%AD%98%E9%81%B8%E5%96%AEmenu%E3%80%81%E6%A8%A1%E7%B5%84module

[Create a module]
[DB connection]
  1. Creating a simple module/Using the Database: http://docs.joomla.org/J2.5:Creating_a_simple_module/Using_the_Database
  2. http://www.phpeveryday.com/articles/Joomla-Module-Using-Helper-Part-5--P82.html
  3. http://www.pluginvalley.com/tutorials/joomla-tutorials/95-how-to-access-your-joomla-database-in-an-extension.html
  4. http://stackoverflow.com/questions/21856750/joomla-3-2-module-helper-php
  5. Joomla module build. Dropdown list with database connection: http://stackoverflow.com/questions/14841209/joomla-module-build-dropdown-list-with-database-connection
  6. Query DB without prefix : http://docs.joomla.org/Database_Table_Prefix
    developers need to use the string #__ to represent the prefix.
  7. Get data from DB : http://docs.joomla.org/J1.5:Accessing_the_database_using_JDatabase
  8. insert into : http://stackoverflow.com/questions/21023420/access-joomlas-helpers-from-outside-php-file

[Multi-Language]
  1. http://cocoate.com/zh-hans
  2. http://www.open-open.com/doc/view/10e90f9d1f854a4b9e30554b9ce133b4
  3. http://www.joomla178.com/joomla-share/joomla-templates-tutorials.html
  4. http://www.joomla178.com/joomla-share/joomla-templates-tutorials/387-joomla-templates-tutorials-creat-a-simple-template.html
  5. Creating a simple module/Developing a Basic Module: http://docs.joomla.org/J2.5:Creating_a_simple_module/Developing_a_Basic_Module
  6. Creating Hello World Module: http://tutsforu.com/creating-basic-hello-world-module.html
  7. Joomla 2.5 hello world module development: http://stackoverflow.com/questions/11833815/joomla-2-5-hello-world-module-development
  8. Get user id : http://docs.joomla.org/Accessing_the_current_user_object
    http://forum.joomla.org/viewtopic.php?f=304&t=282043
  9. Extensions Module Manager: http://docs.joomla.org/Help33:Extensions_Module_Manager


[Reset Password]

PHP

Posted on September 29th, 2014

[Installation]
  1. Appserv架站教學-完整安裝設定指南: http://blog.xuite.net/arcloveangel/lovestore/22930165-Appserv%E6%9E%B6%E7%AB%99%E6%95%99%E5%AD%B8-%E5%AE%8C%E6%95%B4%E5%AE%89%E8%A3%9D%E8%A8%AD%E5%AE%9A%E6%8C%87%E5%8D%97
  2. Download: http://www.appservnetwork.com/
[Blog]
  1. PHP 教程: http://www.w3school.com.cn/php/index.asp
[switch mobile/pc]
  1. Mobile/Desktop Switching Code: http://mobiforge.com/developing/page/mobiledesktop-switching-code
  2. Switch From Mobile Version to Full Website (Desktop Version): http://stackoverflow.com/questions/11314944/switch-from-mobile-version-to-full-website-desktop-version-solved
  3. php mobile detection, header include with manual desktop switch: http://stackoverflow.com/questions/13160741/php-mobile-detection-header-include-with-manual-desktop-switch
[foreach]
  1. foreach 敘述的用法？: http://www.jollen.org/php/jollen_php_book_31_foreach.html
[Variant]
  1. require_once: http://help.i2yes.com/?q=node/51
[DataBase]

Regular-expression

Posted on June 25th, 2014

Redmine

Posted on June 20th, 2014

[Home]
  1. http://www.redmine.org/
    Redmine is open source and released under the terms of the GNU General Public License v2 (GPL).
  2. Creating Unit Tests: http://developer.android.com/training/activity-testing/activity-unit-testing.html

Java

Posted on June 12th, 2014

[Reference]
  1. jar version: http://stackoverflow.com/questions/5834794/how-to-check-the-version-of-jar-file
    Extrace the jar file by zip or rar, open the MANIFEST.MF
[String]
  1. Runnable和Thread的區別 : http://blog.csdn.net/wwww1988600/article/details/7309070
[Poniter]

Eclipse

Posted on June 6th, 2014

[Android SDK Samples]
  1. Import the project from SDK : https://groups.google.com/forum/#!topic/android-beginners/Y1bTqc61tQU
    Select "Create project form existing source" and then all the fields will
    autopopulate when you select the ApiDemos folder.
  2. Fix build error : http://stackoverflow.com/questions/4298155/compiling-and-running-apidemos
    http://rickiedroid.blogspot.tw/2011/02/add-open-sdk-apidemos-work-with-your.html
    I had the same problem and this is my solution.

    Uncheck "Build automatically" in the menu "project"
    Select "Clean" from menu "project".
    Select "Clean projects selected below" and check "ApiDemos".
    Check "Start a build immediatly", "Build only the selected projects"
[New package]
  1. http://stackoverflow.com/questions/15684183/how-can-i-make-a-child-package-inside-a-package-in-eclipse-project-explorer
    Add new package -> Add new class
  2. use external jar : http://stackoverflow.com/questions/1334802/how-can-i-use-external-jars-in-an-android-project
[Git]
  1. EGit: http://my.oschina.net/China2012/blog/174874
  2. Delete project fail :
    1. Delete the project first, but get failed.(.git/gen folder can't be deleted.)

    2. Close Eclipse , and delete the .git and folder. Do it again.

    1. Clone project from git server

    2. Import | Git | Project from Git or Click the button from the toolbar.
    3. Select the repository from URL
    4. Use ssh to connect to git server
      ssh://username@IP_address/Repository_path
      example : ssh://username@10.8.70.13/data/git/SmartWatch_Android
    5. Enter the password
    6. Set the local directory
    7. Import as an existing projects

    1. Create a new package

    1. Create a new class


  5. The git clone project path is : C:\Users\Administrator\git\SmartWatch_Android , need to select the
  6. Set the user name : Menu | Windows | Preference

    http://wiki.eclipse.org/EGit/User_Guide
    http://stackoverflow.com/questions/10663492/how-to-change-default-author-and-commiter-in-eclipse-git-plugin


[Others]

Perl

Posted on May 7th, 2014

[Install]
  1. Switch.pm: http://askubuntu.com/questions/204481/how-to-install-perl-switch-pm-module-required-to-build-webkit-gtk
    1. cpan
    2. install module_name ( c:>install Switch)
  2. Install new CPAN
    1. cpan
    2. install CPAN
    3. reload cpan
[Repetier Install]
  1. cpanm -v ./xs
  2. cpan
  3. install Test
  4. Change the SMUELLER/ExtUtils-ParseXS-3.18_04.tar.gz to SMUELLER/ExtUtils-ParseXS-3.24.tar.gz in the Slic3r/Build.PL

Coding

Posted on March 28th, 2014

  1. 想學程式設計，你怎麼能錯過這 31 個學 Coding 的網站: http://techorange.com/2014/03/27/best-resources-to-learn-code/
  2. 11 步驟就是成為頂尖 Coder 的必備條件: http://techorange.com/2014/07/09/step-step-path-becoming-great-software-developer/

CListCtrl

Posted on March 27th, 2014

  1. MFC總結之CListCtrl用法及技巧（一）: http://blog.csdn.net/zwgdft/article/details/7560592
James