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]

crontab

Posted on September 15th, 2014

  1. crontab -l : list user's crontab
[Reference]