More Annotations

Favourite Annotations

Text

JIANSEN LU'S COMPUTING BLOG: USEFUL COMMANDS A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A TOOL TO TEST IF A PORT IS phpmailer, firewall, inbond, outbound, port 25, 21, 22, 1935, 80,8080,

1935, 3306

JIANSEN LU'S COMPUTING BLOG: A SIMPLE HTML5 FULL SCREEN DEMO A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: CREATE ECLASSROOM FOR FREE A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A SIMPLE CSS LAYOUT DEMO A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: DIFFERENCE BETWEENING A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: "FAST EDIT" A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: THREE NAME NOTATIONS IN A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: WINMERGE A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: HOW TO ADD RSS FEEDS TO YOUR A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: LINUX, AUTOMATICALLY BACKUP Backup MySQL database daily using cron job 1) create a bk directory under home directory, in my case /home/jiansen, cd bk 2) Create a shell scrip MySQLdump.sh JIANSEN LU'S COMPUTING BLOG: DATATABLE EXPORT EXCEL IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents. IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the JIANSEN LU'S COMPUTING BLOG: INSTALL MEDIA WIKI IN LOCALHOST A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: PHP CONNECT IBM DB2 DATABASE Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship

and networking.

JIANSEN LU'S COMPUTING BLOG: UPLOAD AN ANIMATED GIF FILE Wait, the ball is not animated. This is because: if you upload the animated image direct via the Blogger photo upload icon , the image will no longer be animated. I need to upload my animated gif to the free Photobucket image host and it give you 4 codes. The second one is the actual URL and if you are familiar with HTML for displaying images, you can type the HTML yourself. JIANSEN LU'S COMPUTING BLOG: INSTALL PHPMAILER 5.2.4 AND how to remove SMTP -> FROM SERVER:220 mx.google.com ESMTP uf6sm10363353pac.16 - gsmtp SMTP -> FROM SERVER: 250-mx.google.com at your service, 250-SIZE 35882577 250-8BITMIME 250-AUTH LOGIN PLAIN XOAUTH XOAUTH2 PLAIN-CLIENTTOKEN 250-ENHANCEDSTATUSCODES 250-PIPELINING 250-CHUNKING 250 SMTPUTF8 JIANSEN LU'S COMPUTING BLOG: JOB INTERVIEW QUESTIONS AND A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: RENEW SSL CERTIFICATE FROM Renew SSL certificate from StartSSL. 1) The web server SSL certificates from startssl is free for class 1 and needs to be renewed every year. Two weeks before SSL certificates expiration, you will receive an email notification. But you need to validate your JIANSEN LU'S COMPUTING BLOG: AUGUST 2011 If you want to setup donation button using PayPal, you may need to upgrade your PayPal personal account to a Premier or Business account.It is for free. But you may need to pay a small fee when you receive payments with a Premier or Business account. For purchase, it is free to pay, but 1.9% to 2.9% + $0.30 CAD for getting paid. JIANSEN LU'S COMPUTING BLOG: USEFUL COMMANDS A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A TOOL TO TEST IF A PORT IS phpmailer, firewall, inbond, outbound, port 25, 21, 22, 1935, 80,8080,

1935, 3306

and networking.

1935, 3306

and networking.

JIANSEN LU'S COMPUTING BLOG: UPLOAD AN ANIMATED GIF FILE Wait, the ball is not animated. This is because: if you upload the animated image direct via the Blogger photo upload icon , the image will no longer be animated. I need to upload my animated gif to the free Photobucket image host and it give you 4 codes. The second one is the actual URL and if you are familiar with HTML for displaying images, you can type the HTML yourself. JIANSEN LU'S COMPUTING BLOG: INSTALL PHPMAILER 5.2.4 AND how to remove SMTP -> FROM SERVER:220 mx.google.com ESMTP uf6sm10363353pac.16 - gsmtp SMTP -> FROM SERVER: 250-mx.google.com at your service, 250-SIZE 35882577 250-8BITMIME 250-AUTH LOGIN PLAIN XOAUTH XOAUTH2 PLAIN-CLIENTTOKEN 250-ENHANCEDSTATUSCODES 250-PIPELINING 250-CHUNKING 250 SMTPUTF8 JIANSEN LU'S COMPUTING BLOG: JOB INTERVIEW QUESTIONS AND A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: RENEW SSL CERTIFICATE FROM Renew SSL certificate from StartSSL. 1) The web server SSL certificates from startssl is free for class 1 and needs to be renewed every year. Two weeks before SSL certificates expiration, you will receive an email notification. But you need to validate your JIANSEN LU'S COMPUTING BLOG: AUGUST 2011 If you want to setup donation button using PayPal, you may need to upgrade your PayPal personal account to a Premier or Business account.It is for free. But you may need to pay a small fee when you receive payments with a Premier or Business account. For purchase, it is free to pay, but 1.9% to 2.9% + $0.30 CAD for getting paid. JIANSEN LU'S COMPUTING BLOG A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: USEFUL COMMANDS A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: GUESTBOOK/GAMES/VIDEOS/TV/MOVIE A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A TOOL TO TEST IF A PORT IS phpmailer, firewall, inbond, outbound, port 25, 21, 22, 1935, 80,8080,

1935, 3306

JIANSEN LU'S COMPUTING BLOG: CREATE CSS HORIZONTAL AND A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A SIMPLE CSS LAYOUT DEMO A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: "FAST EDIT" A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: THREE NAME NOTATIONS IN A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: CREATE AN ONLINE PUBLIC A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: RENEW SSL CERTIFICATE FROM Renew SSL certificate from StartSSL. 1) The web server SSL certificates from startssl is free for class 1 and needs to be renewed every year. Two weeks before SSL certificates expiration, you will receive an email notification. But you need to validate your email first as email validation only for 30 days. JIANSEN LU'S COMPUTING BLOG: DATATABLE EXPORT EXCEL IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents. IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the JIANSEN LU'S COMPUTING BLOG: A SIMPLE HTML5 FULL SCREEN DEMO A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: LINUX, AUTOMATICALLY BACKUP Backup MySQL database daily using cron job 1) create a bk directory under home directory, in my case /home/jiansen, cd bk 2) Create a shell scrip MySQLdump.sh JIANSEN LU'S COMPUTING BLOG: MAY 2014 Set up Git server in Ubuntu 14.04. To setup Git server in Ubuntu 14.04, log in admin account in Ubuntu: 1) Install git-core. sudo apt-get install git-cor e. 2) create git master firectory, using --bare for not directly editable. sudo mkdir -p /opt/git/directory.git. sudo git init --bare /opt/git/directory.git. JIANSEN LU'S COMPUTING BLOG: 2016 7) Go back Youtube Creator Studio, under Video manager, you can find the video you recorded. Change setting and publish in Youtube. Compare to other screencast, I did not find pause button using this method, Video:Use Youtube as screencast to record your Desktop Screen. YouTube. Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: INSTALL PHPMAILER 5.2.4 AND how to remove SMTP -> FROM SERVER:220 mx.google.com ESMTP uf6sm10363353pac.16 - gsmtp SMTP -> FROM SERVER: 250-mx.google.com at your service, 250-SIZE 35882577 250-8BITMIME 250-AUTH LOGIN PLAIN XOAUTH XOAUTH2 PLAIN-CLIENTTOKEN 250-ENHANCEDSTATUSCODES 250-PIPELINING 250-CHUNKING 250 SMTPUTF8 JIANSEN LU'S COMPUTING BLOG: UPLOAD AN ANIMATED GIF FILE Wait, the ball is not animated. This is because: if you upload the animated image direct via the Blogger photo upload icon , the image will no longer be animated. I need to upload my animated gif to the free Photobucket image host and it give you 4 codes. The second one is the actual URL and if you are familiar with HTML for displaying images, you can type the HTML yourself. JIANSEN LU'S COMPUTING BLOG: 2013 Method 1: 1) Go to system tray at the bottom menu of Windows 7, click dropbox icon, a menu popup, click gear icon at top right, click preferences, the click advanced, click selective sync and choose the folder you want to show in Windows. The unchecked folder will be deleted from your local computer. JIANSEN LU'S COMPUTING BLOG: 2011 3) Click Start Variables at the left Panel. 4) Click "Advanced Networking", under Advanced, you can change Max connection, the default for old MySQL database is 100, for MySQL 5.5 is 151. Posted by Jiansen Lu at 3:34 PM 0 comments. JIANSEN LU'S COMPUTING BLOG: AUGUST 2011 If you want to setup donation button using PayPal, you may need to upgrade your PayPal personal account to a Premier or Business account.It is for free. But you may need to pay a small fee when you receive payments with a Premier or Business account. For purchase, it is free to pay, but 1.9% to 2.9% + $0.30 CAD for getting paid. JIANSEN LU'S COMPUTING BLOG A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: USEFUL COMMANDS A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: GUESTBOOK/GAMES/VIDEOS/TV/MOVIE A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A TOOL TO TEST IF A PORT IS phpmailer, firewall, inbond, outbound, port 25, 21, 22, 1935, 80,8080,

1935, 3306

JIANSEN LU'S COMPUTING BLOG: CREATE CSS HORIZONTAL AND A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: A SIMPLE CSS LAYOUT DEMO A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: "FAST EDIT" A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: THREE NAME NOTATIONS IN A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: CREATE AN ONLINE PUBLIC A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: RENEW SSL CERTIFICATE FROM Renew SSL certificate from StartSSL. 1) The web server SSL certificates from startssl is free for class 1 and needs to be renewed every year. Two weeks before SSL certificates expiration, you will receive an email notification. But you need to validate your email first as email validation only for 30 days. JIANSEN LU'S COMPUTING BLOG: DATATABLE EXPORT EXCEL IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents. IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the JIANSEN LU'S COMPUTING BLOG: A SIMPLE HTML5 FULL SCREEN DEMO A blog about PHP, HTML, CSS, JavaScript, jQuery programming and coding, Internet technology from Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: LINUX, AUTOMATICALLY BACKUP Backup MySQL database daily using cron job 1) create a bk directory under home directory, in my case /home/jiansen, cd bk 2) Create a shell scrip MySQLdump.sh JIANSEN LU'S COMPUTING BLOG: MAY 2014 Set up Git server in Ubuntu 14.04. To setup Git server in Ubuntu 14.04, log in admin account in Ubuntu: 1) Install git-core. sudo apt-get install git-cor e. 2) create git master firectory, using --bare for not directly editable. sudo mkdir -p /opt/git/directory.git. sudo git init --bare /opt/git/directory.git. JIANSEN LU'S COMPUTING BLOG: 2016 7) Go back Youtube Creator Studio, under Video manager, you can find the video you recorded. Change setting and publish in Youtube. Compare to other screencast, I did not find pause button using this method, Video:Use Youtube as screencast to record your Desktop Screen. YouTube. Jiansen Lu. JIANSEN LU'S COMPUTING BLOG: INSTALL PHPMAILER 5.2.4 AND how to remove SMTP -> FROM SERVER:220 mx.google.com ESMTP uf6sm10363353pac.16 - gsmtp SMTP -> FROM SERVER: 250-mx.google.com at your service, 250-SIZE 35882577 250-8BITMIME 250-AUTH LOGIN PLAIN XOAUTH XOAUTH2 PLAIN-CLIENTTOKEN 250-ENHANCEDSTATUSCODES 250-PIPELINING 250-CHUNKING 250 SMTPUTF8 JIANSEN LU'S COMPUTING BLOG: UPLOAD AN ANIMATED GIF FILE Wait, the ball is not animated. This is because: if you upload the animated image direct via the Blogger photo upload icon , the image will no longer be animated. I need to upload my animated gif to the free Photobucket image host and it give you 4 codes. The second one is the actual URL and if you are familiar with HTML for displaying images, you can type the HTML yourself. JIANSEN LU'S COMPUTING BLOG: 2013 Method 1: 1) Go to system tray at the bottom menu of Windows 7, click dropbox icon, a menu popup, click gear icon at top right, click preferences, the click advanced, click selective sync and choose the folder you want to show in Windows. The unchecked folder will be deleted from your local computer. JIANSEN LU'S COMPUTING BLOG: 2011 3) Click Start Variables at the left Panel. 4) Click "Advanced Networking", under Advanced, you can change Max connection, the default for old MySQL database is 100, for MySQL 5.5 is 151. Posted by Jiansen Lu at 3:34 PM 0 comments. JIANSEN LU'S COMPUTING BLOG: AUGUST 2011 If you want to setup donation button using PayPal, you may need to upgrade your PayPal personal account to a Premier or Business account.It is for free. But you may need to pay a small fee when you receive payments with a Premier or Business account. For purchase, it is free to pay, but 1.9% to 2.9% + $0.30 CAD for getting paid. JIANSEN LU'S COMPUTING BLOG Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel

and

Google site.

* Home

* Useful links

* Useful Commands

* My Photos

* Job links

* Online Video Chat

* GuestBook/Games/Videos/TV/Movie

* My Google sites

* Contact Me

* My Online Tools

* My phpBB3 Forum

* My Music Collection * My Youtube Channel

ADSENSE

JS Chosen library

https://harvesthq.github.io/chosen/

Example:

https://stackoverflow.com/questions/30190588/html-select-multiple-as-dropdown

JS and CSS used:

src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js">
src="https://cdn.rawgit.com/harvesthq/chosen/gh-pages/chosen.jquery.min.js">
href="https://cdn.rawgit.com/harvesthq/chosen/gh-pages/chosen.min.css"
rel="stylesheet"/>
Initialization
    $(".chosen-select").chosen({     no_results_text: "Oops, nothing found!"
    })
Set default value
var str_array = "9999,90"; var dataarray=str_array.split(",");    $("select").val(dataarray).trigger("chosen:updated");
php post
$.ajax({
    type: "POST",         //$('select').val() is
cfp_appt_status
    data: {'department1':
$('select').val()},
    async: true,    ........................... Process data example:     $pad_id = $this->input->post('department1');
    $con =1;
    foreach ($pad_id as $pad_id0)
        {
                if($pad_id0=='9999') $con =0;                 if($pad_id0==$entry) $con
=0;
        }
if($con==1) continue; Posted by Jiansen Lu at 2:08 PM
1 comments
Labels: chosen ,
jquery , JS
FRIDAY, DECEMBER 7, 2018 DESIGN SEARCH IN A MANUAL IN PHP Design search in a manual in PHP 1) INSTEAD OF SEARCH IN MYSQL DATABASE
such as
SELECT * FROM tutorial WHERE MATCH(title,description) AGAINST ('left right' IN NATURAL LANGUAGE MODE); I design search algorithm in PHP
2) SEARCH BOX



3) REPLACE SEARCH WORD WITH HIGHLIGHT BACKGROUND RED TEXT WHITE , SEARCH TITLE AND CONTENT $pattern = htmlspecialchars($_POST); $replacement = ''.$pattern.''; $entry = eregi_replace($pattern, $replacement,
$entry);
4) USING FUNCTION CONTEXT_FIND($HAYSTACK, $NEEDLE, $CONTEXT) to show searching Word with 10 surrounding Words in first occurance, add link "Read More" add '&search='.$_POST in link. When the link is clicked, highlight of search word shown in the text. 5) EXAMPLE CODE INDEX.PHP


'.$row.'
';                     $category = $UserManualController->loadTableOfContents($row);                     $item = "";                     $i==0;                     $extra = "";                     foreach($category as
$entry){
                    if(trim($_POST)!=""){                             $pattern = htmlspecialchars($_POST);                             if (strpos($entry, $pattern) !== false) $i= $i + 1;                             $replacement = ''.$pattern.'';                         $entry = eregi_replace($pattern, $replacement,
$entry);
                            $loadContent = $UserManualController->loadContent($entry);                             $extra = $UserManualController->context_find($loadContent, $pattern,
10);
                            $extra = eregi_replace($pattern, $replacement, strip_tags($extra));
if(!empty($extra))
                            $extra ='
... '.$extra.' ... Read More ...
';                         }                                     if(trim($_POST)=="" || strpos($entry, $pattern) !== false|| strpos($loadContent, $pattern) !== false)                         $item .=
'
href="'.SITE_BASE_URL.'/TRACSManual/tracs-manual-content.php?id='.$entry.'&search='.$_POST.'">'.$entry.''.$extra;                     }                     $item .= '
';                 if(trim($_POST)=="" || $item != '
' ||$extra!=""
){
                    echo $cat_each.$item;                     $j=$j+1;                     }                                 }                 if($j==0) echo "No match found.";             ?>

6. EXAMPLE CODE OF SEARCH TEN WORDS (https://stackoverflow.com/questions/22762797/php-show-searching-word-with-5-surrounding-words) function context_find($haystack, $needle, $context) {

    $haystack=' '.$haystack.' ';     if ($i=strpos($haystack, $needle)) {         $start=$i;         $end=$i;         $spaces=0;         while ($spaces < ((int) $context/2) && $start >
0) {
            $start--;             if (substr($haystack, $start, 1) == ' ') {                 $spaces++;             }
        }
        while ($spaces < ($context +1) && $end < strlen($haystack)) {             $end++;             if (substr($haystack,$end,1) == ' ') {                 $spaces++;             }
        }
        while ($spaces < ($context +1) && $start > 0) {             $start--;             if (substr($haystack, $start, 1) == ' ') {                 $spaces++;             }
        }
        return(trim(substr($haystack, $start, ($end -
$start))));
    } else {
        return false;
    }
}
Posted by Jiansen Lu at 3:40 PM
0 comments
Labels: PHP , search THURSDAY, NOVEMBER 22, 2018 PHP SETTING FOR PHP5.3 AND PHP 7 IN UBUNTU 1) CHECK PHP VERSION
php -v
PHP 7.0.32-0ubuntu0.16.04.1 (cli) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies with Zend OPcache v7.0.32-0ubuntu0.16.04.1, Copyright (c) 1999-2017, by Zend Technologies Found PHP is updated from 5.3 to 7. need to re-config /etc/php/7.0/apache2/php.ini
1) Change
short_open_tag = Off
to
short_open_tag = On
2) restart server
sudo service apache2 restart Posted by Jiansen Lu at 4:23 PM
1 comments
MYSQL, ERROR NUMBER: 1055 EXPRESSION #2 OF SELECT LIST IS NOT IN GROUP BY CLAUSE AND CONTAINS NONAGGREGATED COLUMN MySQL version is updatde from 5.5.36 to 5.7.24 in Ubuntu, when I run MySQL script, the following message showed "MySQl, Error Number: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column" As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY which means when you are grouping rows and then selecting something out of that groups, you need to explicitly say which row should that selection be made
from.
To turn off warning message 1. IN FILE /ETC/MYSQL/MY.CNF
add
sql_mode =
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
under
2. RESTART MYSQL SERVER IN sudo service mysql restart Ubuntu
Reference:
https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql Posted by Jiansen Lu at 4:19 PM
0 comments
Labels: MySQL
INSTALL THE PHP MODULE CURL UBUNTU I have following error messge for my web server in Ubuntu after CAS
server upgrade
"You need to install the PHP module curl to be able to use CAS
authentication."
The following steps is to install the PHP module curl at Ubuntu:
1) INSTALL CURL
sudo apt-get install curl
2) RESTART APACHE
sudo service apache2 restart 3) INSTALL PHP CURL sudo apt-get install php-curl ( note: do not run sudo apt-get install php5-curl it will return message: "Package 'php5-curl' has no installation candidate" In Ubuntu 16.04 default PHP version is 7.0, if you want to use different version then you need to install PHP package according to PHP version: PHP 7.2: sudo apt-get install php7.2-curl PHP 7.1: sudo apt-get install php7.1-curl PHP 7.0: sudo apt-get install php7.0-curl PHP 5.6: sudo apt-get install php5.6-curl PHP 5.5: sudo apt-get install php5.5-curl or just run sudo apt-get install php-curl
)
4) RESTART APACHE
sudo service apache2 restart
ANOTHER NOTES:
remove php 5 package A) CHECK PHP5 PACKAGE
dpkg -l | grep php5
dpkg --purge --force-all php5-curl
B) REMOVE
sudo dpkg --purge --force-all php5-curl sudo apt-get remove php5-* sudo apt-get purge php5-* sudo apt-get autoremove
dpkg -l | grep php5
C) CHECK UNIX SERVER OS AND VERSION
uname -a
Linux facts2 4.4.0-139-generic #165-Ubuntu SMP Wed Oct 24 10:58:50 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
D) DU -K
check space used
F) DF -K
check space available Posted by Jiansen Lu at 2:43 PM
0 comments
Labels: curl , PHP
, Ubuntu
Older Posts
Home
Subscribe to: Posts (Atom)
ABOUT ME
* Jiansen Lu
A computer programmer with wide interest in Internet technology, music, photography and investment. View my complete profile
TOTAL PAGEVIEWS
0
10
1
13
2
28
3
28
4
23
5
15
6
10
7
98
8
19
9
23
10
24
11
25
12
26
13
39
14
35
15
22
16
16
17
28
18
87
19
42
20
14
21
19
22
31
23
46
24
31
25
37
26
20
27
13
28
15
29
9
521,872
FOLLOWERS
LABELS
* Actionscript
(22)
* Adobe Flash Media Server
(6)
* Adsense (6)
* ajax (6)
* alert (1)
* algorithm
(2)
* animation
(1)
* apache (7)
* apple (1)
* array (1)
* as2 (3)
* as3 (3)
* Asp.net (1)
* autocomplete
(1)
* bbcode (1)
* blog (27)
* bootstrap
(2)
* C++ (36)
* chosen (1)
* CodeIgniter
(3)
* conduit (1)
* cron (1)
* cron job
(1)
* CSS (17)
* css3 (2)
* csv (1)
* curl (1)
* Cygwin (1)
* database
(1)
* db2 (1)
* draggable
(1)
* dropbox (1)
* editor (3)
* emulator
(1)
* excel (1)
* Filezilla
(1)
* Firefox (5)
* fireftp (1)
* firewall
(1)
* flash (14)
* ftp (2)
* g++ (1)
* git (1)
* github (1)
* gmail (1)
* Google (16)
* google search
(1)
* Heartbleed bug
(1)
* htaccess
(1)
* html (20)
* HTML5 (7)
* IIS (1)
* interview
(10)
* iphone (2)
* itune (1)
* javascript
(28)
* JavaScript library
(1)
* job (28)
* jquery (16)
* JS (5)
* json (2)
* keepass (1)
* latex (2)
* Linux (6)
* LMS (4)
* malware (1)
* MATLAB (7)
* Microsoft Family
(1)
* MinGW (1)
* minikeepass
(1)
* misc (37)
* mobile (3)
* mobile website
(1)
* modal (1)
* modernizr
(1)
* morris (1)
* mp3 (1)
* MVC (2)
* MySQL (58)
* Nagios (1)
* netextender
(1)
* Notepad++
(1)
* openmeetings
(1)
* Parental Controls
(1)
* password
(2)
* Paypal (3)
* pdf (2)
* perl (7)
* PHP (97)
* phpexcel
(1)
* phpmailer
(1)
* PocketC++
(1)
* Predator
(1)
* prefixr (1)
* python (4)
* QR code
(1)
* R (1)
* recorder
(1)
* red5 (1)
* reload (1)
* savant (1)
* scheduler
(1)
* screen capture
(1)
* screen recorder
(1)
* screencast
(1)
* search (1)
* Security
(4)
* SEO (3)
* speech input API
(1)
* statistics
(9)
* survey form
(1)
* sweet alert
(1)
* tex (1)
* tools (23)
* TRIGGER (1)
* tutorial
(25)
* Ubuntu (3)
* USB (1)
* video (18)
* vpn (1)
* wayback (1)
* web design
(2)
* webplayer
(1)
* wiki (2)
* Windows (8)
* Windows 10
(1)
* Windows 8
(1)
* Windows Scheduler
(1)
* Word (1)
* xampp (2)
* youtube (4)
BLOG ARCHIVE
* ▼ 2019 (1)
* ▼ March (1)
* Using JS Chosen library for multiselect dropdown
* ► 2018 (8)
* ► December (1) * ► November (5)
* ► March (1)
* ► February (1)
* ► 2017 (2)
* ► March (2)
* ► 2016 (6)
* ► November (2) * ► October (1) * ► September (1)
* ► March (1)
* ► February (1)
* ► 2015 (13)
* ► December (1)
* ► June (4)
* ► May (2)
* ► April (2)
* ► February (2) * ► January (2)
* ► 2014 (54)
* ► November (1) * ► October (6) * ► September (2)
* ► August (2)
* ► July (4)
* ► June (5)
* ► May (3)
* ► April (12)
* ► March (4)
* ► February (5) * ► January (10)
* ► 2013 (154)
* ► December (12) * ► November (17) * ► October (11) * ► September (11) * ► August (11)
* ► July (3)
* ► June (9)
* ► May (12)
* ► April (17)
* ► March (16)
* ► February (14) * ► January (21)
* ► 2012 (271)
* ► December (25) * ► November (19) * ► October (26) * ► September (27) * ► August (15)
* ► July (21)
* ► June (24)
* ► May (25)
* ► April (18)
* ► March (32)
* ► February (23) * ► January (16)
* ► 2011 (154)
* ► December (5) * ► November (15) * ► October (16) * ► September (15) * ► August (12)
* ► July (10)
* ► June (10)
* ► May (7)
* ► April (9)
* ► March (14)
* ► February (14) * ► January (27)
* ► 2010 (286)
* ► December (39) * ► November (43) * ► October (74) * ► September (62) * ► August (33)
* ► July (13)
* ► June (22)
DONATE TO SUPPORT MY WORK
CALCULATOR
Picture Window theme. Theme images by imagedepotpro
.
Powered by Blogger .

Details

Image Url

HTML Url

Moderation By

More Annotations

Ellen Grant

2020-04-05 08:02:23

Ellen Grant

2020-04-05 08:02:24

Ellen Grant

2020-04-05 08:02:31

Ellen Grant

2020-04-05 08:03:01

Ellen Grant

2020-04-05 08:03:02

Ellen Grant

2020-04-05 08:03:22

Ellen Grant

2020-04-05 08:03:32

Ellen Grant

2020-04-05 08:03:39

Ellen Grant

2020-04-05 08:03:55

Ellen Grant

2020-04-05 08:04:04

Ellen Grant

2020-04-05 08:04:24

Ellen Grant

2020-04-05 08:04:24

Favourite Annotations

Ellen Grant

2019-10-03 12:11:23

Ellen Grant

2019-10-03 12:11:37

Ellen Grant

2019-10-03 12:11:38

Ellen Grant

2019-10-03 12:11:49

Ellen Grant

2019-10-03 12:11:58

Ellen Grant

2019-10-03 12:12:13

Ellen Grant

2019-10-03 12:12:36

Ellen Grant

2019-10-03 12:12:53

Ellen Grant

2019-10-03 12:13:06

Ellen Grant

2019-10-03 12:13:25

Ellen Grant

2019-10-03 12:13:38

Ellen Grant

2019-10-03 12:13:56

Text

1935, 3306

1935, 3306

and networking.

1935, 3306

1935, 3306

and networking.

1935, 3306

1935, 3306

and networking.

1935, 3306

1935, 3306

1935, 3306

1935, 3306

and

Google site.

PAGES

* Home

* Useful links

* Useful Commands

* My Photos

* Job links

* Online Video Chat

* My Google sites

* Contact Me

* My Online Tools

* My phpBB3 Forum

ADSENSE

POPULAR POSTS

JS Chosen library

'
href="'.SITE_BASE_URL.'/TRACSManual/tracs-manual-content.php?id='.$entry.'&search='.$_POST.'">'.$entry.''.$extra; } $item .= '