Webdesign

How to reset root password?

pkill mysqld
mysqld_safe --skip-grant-tables
mysql --user=root mysql
update user set Password=PASSWORD('my_pass') where user='root';
flush privileges;
exit;

Create database and grant user

mysql -u root -p
my_password
create database my_db;
grant all privileges on my_user.* to 'my_db'@'localhost' identified by 'my_pass';

Import sql file

use mydatabase
source filename.sql

Export/Import database

mysqldump -u username -ppassword database_name > dump.sql
mysql -u username -ppassword database_name < dump.sql

JavaScriptObject is an application to publish 3D models via JavaScript http://finnrudolph.de/JavaScriptObject

Flash object overlaps the box? Fix it by adding wmode=transparent to the embedded flash.

swfobject documentation – Embedding Adobe Flash Player content using SWFObject 2

Pri datetime v php date("Y-m-d H:i:s") alebo dať ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

www.nawebe.net -> nawebe.net

RewriteEngine On
RewriteCond %{HTTP_HOST} ^www.nawebe.net [NC]
RewriteRule ^(.*)$ http://nawebe.net/$1 [L,R]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?v=$1 [PT,L,QSA]

nawebe.net -> www.nawebe.net

RewriteEngine On
RewriteCond %{HTTP_HOST} ^nawebe.net [NC]
RewriteRule ^(.*)$ http://www.nawebe.net/$1 [L,R]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?v=$1 [PT,L,QSA]

Odstrániť lomku

RewriteCond %{HTTP_HOST} ^www.example\.com$ [NC]
RewriteRule ^(.+)/$ http://%{HTTP_HOST}/$1 [R=301,L]

<wbr> (word break) means: "The browser may insert a line break here, if it wishes."
http://www.quirksmode.org/oddsandends/wbr.html

/* Copyleft 2005 Tibor Kádek */

function showhide(id)
{
	el = document.getElementById(id);
	el.style.display = (el.style.display=='block')?'none':'block';
}

usage:
<p id="produkt1" style="display:none">Some Show/Hide text</p>
<a href="javascript:showhide('produkt1');">more info</a>