Related Articles
Search and Retrieve Data from MySQL DB Using PHP
Below is the Simple PHP and MYSQL Search Program. Use below database queries: CREATE TABLE IF NOT EXISTS user (id int(10) NOT NULL AUTO_INCREMENT,Name varchar(20) NOT NULL,PRIMARY KEY (id)); INSERT INTO user (id, Name) VALUES (‘1’, ‘vicky’), (‘2’, ‘vivek’); Below is the sample program:
Javascript Key Codes
Key ==> Code backspace ==> 8 tab ==> 9 enter ==> 13 shift ==> 16 ctrl ==> 17 alt ==> 18 pause/break ==> 19 caps lock ==> 20 escape ==> 27 page up ==> 33 page down ==> 34 end ==> 35 home ==> 36 left arrow ==> 37 up arrow ==> 38 right arrow […]
How to Get MySql Query Result as an Email
If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick. Go to mysql command:Set pager directive: mysql> pager mail -s “subject” emailme@domain.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]