WEB programing tricks
SSH commands
- Export data from tar
- tar -xvf "filename"
- Make zip archive through ssh
- zip -r pavadinimas.zip /home/httpd/vhosts/saitovardas.com/httpdocs
- Make tar archive on ssh
- tar -cvvf bak.tar /usr/public_html/
- Make mysqldump through ssh (backup mysql data)
- mysqldump -e --force --quick --quote-names -h localhost -u root -p DBNAME > BACKUP_FILE.sql
- Restore mysql data through ssh (import mysql data)
- mysql -u USER -p DBNAME < dump.sql
Also usefull free mysql tool (community edition)
- MYSQL REPLACE
- UPDATE mc_products set `description`=replace(`description`, 'what', 'with what')
- Other mysql queries examples
- http://www.1keydata.com/sql
Tools
PHP syntax
($this->userId)?$this->userId:0;
SQL queries
UPDATE mc_products set `description`=replace(`description`, 'what', 'with what')
Tutorials
PHP
htaccess
Enable PHP debugging using .htaccess
php_flag display_errors on
# supress php errors
php_flag display_startup_errors off
php_flag display_errors off
php_flag html_errors off
php_value docref_root 0
php_value docref_ext 0
# enable PHP error logging
php_flag log_errors on
php_value error_log /home/path/public_html/domain/PHP_errors.log
MySQL
Design
AJAX
Gyvenimo principai
| When you're riding, only the race in which you're riding is important.Bill Shoemaker, Jockey |
| "Effort, not ability, makes the biggest difference in achievement." Bill Clinton, 42nd President of the United States |
| Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore. Dream. Discover. Mark Twai |
| If you do what you've always done, you'll get what you've always gotten |
Gali paclick'int!
- Vienišas dizaineris
- Keiskimės reklaminėmis antraštėmis
arba pašėlusiomis dovanomis! - Paslėptos SMS
- Brangus hostingas
Spustelk ir pamatysi NAUDINGAS nuorodas
