UP TO 80% DISCOUNT ON AMAZON LIMITED TIME ...

Sunday, 9 August 2015

moving text for wedsite

Moving Text the marquee tag

I will show you in this article some ways you can animate text with the marquee tag. The marquee tag is an HTML element that makes text to move from left to right and top to down.
I will illustrate these animations using the examples shown below.

Practical examples

From right to left. This is the most simple animation given and we will not 
need a label to achieve the movement.
<marquee>TEXT</marquee>

TEXT

From left to right. We will add the attribute direction with the "right" as follows
<marquee direction="right">TEXT</marquee>
TEXT

Alternatively. With attribute behavior.
<marquee behavior="alternate">TEXT</marquee>
TEXT

The bottom up.
<marquee direction="up">TEXT</marquee>
TEXT

From the top down.
<marquee direction="down">TEXT</marquee>
TEXT

From the top down alternative.
<marquee direction="up" behavior="alternate">TEXT</marquee>
TEXT

From the top down as well from left to right at the same time. See the example for a better understanding
<marquee behavior="alternate" direction="up" width="80%"><marquee direction="right">TEXT</marquee></marquee>
TEXT

Same example but in a closed space
<marquee behavior="alternate" direction="up" width="80%"><marquee direction="right" behavior="alternate">TEXT</marquee></marquee>
TEXT

On a background
<font color="WHITE"><marquee direction="left" style="background:RED">TEXT</marquee></font>
TEXT

In a frame.
<marquee style="border:RED 3px SOLID">TEXT</marquee>
TEXT

Picture. Using the above script, may be inserted photos with or without text. They will be introduced like in the following example:
<marquee>Some text here <img src="/img/header_zizix.jpg" width="88" height="31" alt="Zizix Tutorials " border="0"></marquee>
Some text hereHTML Tutorials

Animation placed in text.
Some text before <marquee WIDTH="20%"><img src="http://www.etutoriale.ro/banners/88x31.gif" width="88" height="31" alt="Zizix tutorials " border="0"></marquee> Some text after.
Some text before Tutorials in rumanian Some text after.

It would be something more to say: that the speed of the movement can be changed using "scrolldelay" where an attribute value of "1000" for example, would reduce speed close to 0, while a value of "1" would be a very high speed.

Movement interrupted with attribute scrollamount. A value of "10" for example, will advance the text movement with 10 pixels / frame.

You ca also set a number of times the text will pass from right to left for example, using attribute loop. A value of "3" it will let you see the words three times after that will disappear.

Images and logo
























































Sunday, 2 August 2015

MYSQI Database Commands

Mysql Database Commands:




DescriptionShortcut key
To login (from unix shell) use -h only if needed.[mysql dir]/bin/mysql -h hostname -u root -p
Create a database on the sql server.create database [databasename];
List all databases on the sql server.show databases;
Switch to a database.use [db name];
To see all the tables in the db.show tables;
To see database's field formats.describe [table name];
To delete a db.drop database [database name];
To delete a table.drop table [table name];
Show all data in a table.SELECT * FROM [table name];
Returns the columns and column information pertaining to the designated table.show columns from [table name];
Show certain selected rows with the value "whatever".SELECT * FROM [table name] WHERE [field name] = "whatever";
Show all records containing the name "Bob" AND the phone number '3444444'.SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';
Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field.

SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;
Show all records starting with the letters 'bob' AND the phone number '3444444'.SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444';
Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a.SELECT * FROM [table name] WHERE rec RLIKE "^a$";
Show unique records.SELECT DISTINCT [column name] FROM [table name];
Show selected records sorted in an ascending (asc) or descending (desc).SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;
Count rows.SELECT COUNT(*) FROM [table name];
Join tables on common columns.select lookup.illustrationid, lookup.personid,person.birthday from lookup
left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;
Switch to the mysql db. Create a new user.INSERT INTO [table name] (Host,User,Password) VALUES('%','user',PASSWORD('password'));
Change a users password.(from unix shell).[mysql dir]/bin/mysqladmin -u root -h hostname.blah.org -p password 'new-password'
Change a users password.(from MySQL prompt).SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
Switch to mysql db.Give user privilages for a db.INSERT INTO [table name] (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','db','user','Y','Y','Y','Y','Y','N');
To update info already in a table.UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';
Delete a row(s) from a table.DELETE from [table name] where [field name] = 'whatever';
Update database permissions/privilages.FLUSH PRIVILEGES;
Delete a column.alter table [table name] drop column [column name];
Add a new column to db.alter table [table name] add column [new column name] varchar (20);
Change column name.alter table [table name] change [old column name] [new column name] varchar (50);
Make a unique column so you get no dupes.alter table [table name] add unique ([column name]);
Make a column bigger.alter table [table name] modify [column name] VARCHAR(3);
Delete unique from table.alter table [table name] drop index [colmn name];
Load a CSV file into a table.LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);
Dump all databases for backup. Backup file is sql commands to recreate all db's.[mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql
Dump one database for backup.[mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql
Dump a table from a database.[mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql
Restore database (or database table) from backup.[mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql
Create Table Example 1.CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),
officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups
VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));
Create Table Example 2.create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastname varchar(50) default 'bato');

Bash Shell Commands

Bash Shell Commands:




DescriptionShortcut key
aliasCreate an alias
breakExit from a loop
caseEvaluate one of several scripts, depending on a given value
cdChange directory
commandRun a command - ignoring shell functions
continueResume the next iteration of a loop
declareDeclare variables and give them attributes
dirsDisplay list of remembered directories
enableEnable and disable builtin shell commands
evalEvaluate several commands/arguments
execExecute a command
exitExit the shell
exportSet an environment variable
forExpand words, and execute commands
hashRemember the full pathname of a name argument
historyCommand History
ifConditionally perform a command
letPerform arithmetic on shell variables
localCreate variables
logoutExit a login shell
popdRestore the previous value of the current directory
pushdSave and then change the current directory
readread a line from standard input
readonlyMark variables/functions as readonly
returnExit a shell function
setManipulate shell variables and functions
shiftShift positional parameters
shoptShell Options
sourceRun commands from a file `.'
timesUser and system times
typeDescribe a command
ulimitLimit user resources
umaskUsers file creation mask
unaliasRemove an alias
unsetRemove variable or function names
untilExecute commands (until error)
whileExecute commands

Ubuntu Commands

Ubuntu Commands:



Command privileges
DescriptionShortcut key
run command as rootsudo command
root shell opensudo su
open shell as a usersudo su user
forget your password sudosudo -k
sudo visual dialog (GNOME)gksudo command
sudo visual dialog (KDE)kdesudo command
edit / etc / sudoerssudo visudo
root file manager (GNOME)gksudo nautilus
root file manager (KDE)kdesudo konqueror
change your passwordpasswd
Command Network
displays information networkifconfig
displays information from wirelessiwconfig
scan wireless networkssudo iwlist scan
reset the networksudo /etc/init.d/networking restart
manual configuration(file) /etc/network/interfaces
bring online interfaceifup interface
disable interfaceifdown interface
Commands Display
show Configuration(file) /etc/X11/xorg.conf
reconfigure xserver-xorg-phigh - reset configuration Xsudo dpkg-reconfigure
X display reset if frozenCtrl+Alt+Bksp
switch to tty NCtrl+Alt+FN
switch back to X displayCtrl+Alt+F7
Commands Service System
service to start work (Upstart)start service
service to stop working (Upstart)stop service
check if service is running (Upstart)status service
start service (SysV)/etc/init.d/service start
stop service (SysV)/etc/init.d/service stop
check service (SysV)/etc/init.d/service status
reset service (SysV)/etc/init.d/service restart
get current runlevelrunlevel
Commands for Firewall
turn on the firewallufw enable
turn off the firewallufw disable
allow all connections by defaultufw default allow
drop all connections by defaultufw default deny
current rules andufw status
to allow traffic on portufw allow port
port blockufw deny port
ip blockufw deny from ip
Command System
get the version of Ubuntulsb_release -a
get kernel versionuname -r
get all the information kerneluname -a