Tryangled Solutions web designing tips tricks

If your problem is with a specific MySQL expression or function, you can perform a timing test by invoking the BENCHMARK() function using the mysql client program. Its syntax is BENCHMARK(loop_count,expression). The return value is always zero, but mysql prints a line displaying approximately how long the statement took to execute

Use multiple-row INSERT statements to store many rows with one SQL statement.

The explain command can tell you which indexes are used with the specified query and many other pieces of useful information that can help you choose a better index or query.

Example of usage: explain select * from table

explanation of row output:

* table—The name of the table.
* type—The join type, of which there are several.
* possible_keys—This column indicates which indexes MySQL could use to find the rows in this table. If the result is NULL, no indexes would help with this query. You should then take a look at your table structure and see whether there are any indexes that you could create that would increase the performance of this query.
* key—The key actually used in this query, or NULL if no index was used.
* key_len—The length of the key used, if any.
* ref—Any columns used with the key to retrieve a result.
* rows—The number of rows MySQL must examine to execute the query.
* extra—Additional information regarding how MySQL will execute the query. There are several options, such as Using index (an index was used) and Where (a WHERE clause was used).

We’ve transcribed all 101 tips here. To fit our Mac-centric audience a little better, we’ve switched everything around to the default Mac keyboard commands.

1. Want to copy a Layer? Jump it: Command-J
2. You a Windows user? Press Control instead of Command.
3. For a new Layer: Command-Shift-N
4. To Delete a Layer, hit the Move Tool (v) and       Command-Delete.
5. Every letter selects a tool. Except for:
6. F for Fullscreen.
7. Q for QuickMask.
8. D for Default colors.
9. X for Switch colors.
10. Press a Number to change Opacity.
11. …or Two Numbers for better Control.
12. Shift-Plus (+) to Advance a Blend Mode.

13. Shift-Minus (-) to Go Back one Blend Mode.

14. Shift-Option+[a letter] for a specific Blend Mode(Dissolve=I, Multiple=M, Screen=S, Overlay=O, Soft Light=F, Hard Light=H, Linear Light=J, Vivid         Light=J, Pin Light=Z, Color Dodge=D, Color Burn=B, Darken=K, Lighten=G,Difference=E, Exclusion=X,   Hue=U, Saturation=T, Color=C, Luminosity=Y, Behind=Q)
15. Windows Folks, Option means Alt for shortcuts.
16. Command-Plus (+) Zooms In.
17. Command-Minus (-) Zooms Out.
18. Spacebar gets the Hand so you can drag the image around.
19. Command-Spacebar = Zoom Tool In.
20. Option-Spcebar = Zoom Tool Out.
21. Command-Spacebar-Drag to zoom in on a specific area.
22. Command-Z for Undo.
23. Command-Option-Z Steps Back one action.
24. Command-Shift-Z Steps Forward one action.
25. Command-Shift-F Fades the last edit.
26. F12 = Revert Document.
27. Hey! You can even Undo a Revert!
28. Command-X = Cut.
29. Command-C = Copy.
30. Command-V = Paste.
Deke sings about how wonderful he is…
31. Image Size = Command-Option-I.
32. It’s partner, Canvas Size = Command-Option-C.
33. Command-F repeats the last Filter.
34. Command-Option-F repeats last Filter with Different Settings.
35. Using Selection Tools: Drag to start a new selection.
36. …or drag to move a selection outline.
37. …add to a section using Shift.
38. …delete from a selection using Option.
39. …find the intersection holding down Shift-Option.
40. …Press Spacebar to move the selection on the fly.
41. Command-A = Select All.
42. Command-D = Deselects Everything.
43. Command-Shift-I Inverts the existing Selection.
44. Command-Option-R brings up Refine Edge.
45. Option-Click with Lasso tool to select a straight-sided selection.
46. Shift-Click with Brush to draw straight lines.
47. Press Option with Brush to get the Color-Lifting Eyedropper.
48. Press Command to get the Move tool.
49. Command-H = Hide Selection.
50. Command-1 shows 1st channel (Red or Cyan)
51. Command-2 shows 2nd channel (Green or Magenta)
52. Command-3 shows 3rd channel (Blue or Yellow)
53. Command-Tilde (~) shows a Full-Color Composite. (Read about the tilde if you like.)
54. Command-L for Levels.
55. Command-M for Curves.
56. Command-B for Color Balance.
57. Command-U for Hue/Saturation.
58. Add the Option-key to bring up last settings for those last four.
59. Command-Shift-Option for Black and White.
60. In Levels & Curves, Option-drag that White Slider to preview your clip highlights…
61. …Option-drag the Black Slider to preview clip shadows.
62. DekePod-DuplicatefromHistory.pngWant to duplicate an image? Cool tip! Click this Icon at the bottom of history palette.
63. Command-W to Close an image. Then…
64. …Y to save changes. (Windows Only)
65. …N to abandon changes. (Windows Only)
66. …On a Mac: S=Save and D=Don’t Save.
67. …ESC to Cancel on both Mac and Windows.
Deke sings some more… (whew! Lots of typing!)
68. Press Command-T to invoke Free Transform…
69. …Enter to Apply, or ESC to Cancel.
70. Command-Option-T will Transform a Copy!
71. Command-Shift-T repeats the last Transformation.
72. Command-Shift-Option-T plays a Transformation sequence.
73. Press the Bracket keys [ or ] to change the size of a Brush.
74. ..add the Shift key to change the brush hardness.
75. Caps Lock for Precise cursors.
76. Option key switches from Dodge to Burn or Burn to Dodge.
77. Hitting the Period in Gradient tool switches between gradients.
78. Here’s a tip: The Sharpen Tool Sucks! Don’t use it!
79. Command-Click the Thumbnail in Layers or Paths palette to Load a Selection.
80. Type Slash (/) to lock/unlock a Layer’s Transparency.
81. Press Tilde (~) to hide an image while Viewing a Mask.
82. Press Backslash (\) to view a Layer’s Mask.
83. Command-Delete fills selection with the Background Color.
84. Option-Delete fills selection with the Foreground Color.
85. …add the Shift key to fill just the Opaque pixels. (cool!)
86. Shift-Delete to bring up the Fill dialog box.
87. Filling using the Behind mode locks out “preserve transparency”.
88. Command-Brackets ([ or ]) moves Layers up or down.
89. …add Shift to move Layers all the way to top or bottom.
90. Option-Brackets ([ or ]) Selects Layers.
91. …add Shift to select multiple layers.
92. Command-Option-A to select All Layers.
93. Command-G groups Layers into a group.
94. Command-E will Merge Selected Layers.
95. Command-Shift-E will Merge Visible Layers.
96. Command-Option-E will Merge selected Layer onto the Layer below.
97. Command-Shift-Option-E will Merge Everything onto a New Layer.
98. Command-Shift-C Copies a Merged version of Layers.
99. Command-Shift-V will paste an image into a Selection.
100. Hit Tab to Hide all Palettes.
101. Hit Shift-Tab to Hide just the Right-side Palettes.

Shutdown
shutdown /s  /t /t 0
Restart
shutdown /r  /t /t 0

// enable command line buffering
php -doutput_buffering=1 console_app.php
// disable command line buffering
php -doutput_buffering=0 console_app.php
// console_app.php code
<?php
for ( $i=1; $i<=100;$i++)
{
print “$i]hin”;
sleep( 1 );
}
?>

What is ASP?Active Server Pages (ASP) is Microsoft’s scripting language for building dynamic web sites, web applications and web services., First released in January 2002 , along with the version 1.0 of the .NET Framework, ASP.net is the successor to Microsoft’s Active Server Pages (ASP) technology. ASP.NET is made on the Common Language Runtime, allowing programmers to write ASP.NET code via any supported .NET language such as VBScript and Jscript.What is PHP?PHP or (PHP: Hypertext Preprocessor) is a PC scripting language designed for the construction of dynamic web pages. PHP is largely used in server-side scripting, but can also be used from a command line interface or in standalone graphical applications.PHP commonly runs on a web server, taking the PHP code as its input and creating web pages as output. It can be set up on most web servers and on almost every operating system and platform for free.To be Continued…

By far the easiest top 10 SEO tips you will ever do as it relates to search engine optimization is include a robots.txt file at the root of your website. Open up a text editor, such as Notepad and type “User-agent: *”. Then save the file as robots.txt and upload it to your root directory on your domain. This one command will tell any spider that hits your website to “please feel free to crawl every page of my website”.

Here’s one of my best top 10 SEO tips: Because the search engine analyzes everything it indexes to determine what your website is all about, it might be a good idea to block folders and files that have nothing to do with the content we want to be analyzed. You can disallow unrelated files to be read by adding “Disallow: /folder_name/” or “Disallow: /filename.html”. Here is an example of the robots.txt file on this site:

Open a Command Prompt window and leave it open.
Close all open programs.
Click Start, Run and enter TASKMGR.EXE
Go to the Processes tab and End Process on Explorer.exe.
Leave Task Manager open.
Go back to the Command Prompt window and change to the directory the AVI (or other undeletable file) is located in.
At the command prompt type DEL where is the file you wish to delete.
Go back to Task Manager, click File, New Task and enter EXPLORER.EXE to restart the GUI shell.
Close Task Manager.

Or you can try this

Open Notepad.exe

Click File>Save As..>

locate the folder where ur undeletable file is

Choose ‘All files’ from the file type box

click once on the file u wanna delete so its name appears in the ‘filename’ box

put a ” at the start and end of the filename
(the filename should have the extension of the undeletable file so it will overwrite it)

click save,

It should ask u to overwrite the existing file, choose yes and u can delete it as normal

Here’s a manual way of doing it. I’ll take this off once you put into your first post zain.

1. Start
2. Run
3. Type: command
4. To move into a directory type: cd c:\*** (The stars stand for your folder)
5. If you cannot access the folder because it has spaces for example Program Files or Kazaa Lite folder you have to do the following. instead of typing in the full folder name only take the first 6 letters then put a ~ and then 1 without spaces. Example: cd c:\progra~1\kazaal~1
6. Once your in the folder the non-deletable file it in type in dir - a list will come up with everything inside.
7. Now to delete the file type in del ***.bmp, txt, jpg, avi, etc… And if the file name has spaces you would use the special 1st 6 letters followed by a ~ and a 1 rule. Example: if your file name was bad file.bmp you would type once in the specific folder thorugh command, del badfil~1.bmp and your file should be gone. Make sure to type in the correct extension.