Final image

Step 1

Tipe new text layer.

Step 2

Rasterize layer and with selected parts of text and free transform tool conect leters.

Step 3

Duplicate layer.

Step 4

To duplicated layer give stroke.

Step 5

First layer who's now inside of second layer, select and trim second layer.

Step 6

Delete first layer. now we use only duplicated (second) layer.

To second layer give Gradient Overlay like in picture.

Step 7

Duplicate layer and give him vertical transformation.

Step 8

Then select both layers and tranform them with Perspective Transformation.

Step 9

Duplicate them and merge them togheter. then color them and move just a little in front off.

Step 10

Open new layer and start to drawing lighting effects.. Use Pen Tool.

Step 11

Color layer.

Step 12

With Eraser Tool erase some part of light.

Step 13

Then give Lighten effect.

Step 14

Open new layer as background, color him, put him behind and give Gradient Overlay like in picture.

Step 15

Final

Tutorial goal:
I am going to show you an easy way to transform photos into fully shaded pencil sketches. We will be using very basic photoshop skills and two filters. I did this image in CS4, but since it is very basic I would imagine it could be done with any version. So let us begin.

End result:

step 1

The Goal

We want to take a photo like the one pictured here and turn it into a fully shaded pencil sketch like the image below.

step 2

Step One:
Select your image and load it into Photoshop of course.
Then click on the "New layer" icon in the Layers pallet to create two empty layers above our original background layer.

Your layer pallet should look like this.

step 3

Step Two:
Select the Paint Bucket Tool.
Make sure you are using the default colors by hitting the d key.
Make sure your foreground color is white.
Select Layer 1 and fill it with white.
Tap the X key to switch the fore & background colors and then select Layer 2, and fill it with black.

step 4

Step Three:
Now while you still have Layer Two (the top layer) selected, go ahead and flip the fore & background colors by taping the X key again.
Ok, Go to Filters / Sketch / Note Paper, and apply the default settings of:
Balance 25
Graininess 10
Relief 11
and select OK

step 5

Step Four:
Still working on our Black Layer, we are going to adjust the levels.
Hit Ctrl / L and pull the sliders in to the edges of the bell curve like so.

step 6

Step Five:
Next thing we will do to the Black Layer is apply a little motion blur. That is under Filters / Blur / Motion Blur.
Use the setting:
Angle -40
Distance 13

This will be the simulation of the pencil marks in the shaded areas of our final image.

step 7

Step Six:
We are done with the Black Layer for now.
Make the Black and the White Layers invisible by clicking on the little Eye icons.

Now, make the original background layer visible, if it is not visible already, by clicking on the small empty box at the left edge of the layer.
Select the original background layer and drag it down to the New Layer icon to duplicate it.
Select the newly created "Background Copy" to make it the active Layer.
Hit Ctrl / Shift / U to desaturate it.
Hit Ctrl / L to bring up the Levels and pull the sliders way in like in this image, to give us a high contrast image. However don't over do it, we don't want it to be stark black and white, we want to keep just a little bit of those mid tones.

step 8

Step Seven:
With our high contrast desaturated image still active, tap Ctrl / I to invert the image.
On the Menu chose, Selections / All.
Then Edit / Copy

Click the Eye icon on the Desaturated image to turn it off.

Make our Black Layer visible again by clicking on the small empty box at the left edge of the layer.
Select the Black Layer to make it the active layer,
Click the Layer Mask icon at the bottom of the layer pallet to add a mask to the Black Layer.
Alt / click on the Mask thumbnail. The image will turn all white.
Chose Edit / Paste to paste the inverted high contrast image into the mask.
Re-click on the eye to turn the black layer back on.
Set the blending mode to Hard Light.

Click on the eye icon on the white layer to make it visible as well.

your image should look like this.

step 9

Step Eight:
Click on the Mask Thumbnail of the Black Layer so that it has the little white box around it.
Hit Ctrl / L to bring up the Levels adjustment again and fine tune the balance of the light and dark to your liking.

step 10

Step Nine:

And finally, we want to lose a little of the regularity in the simulated pencil strokes.

So Select the blur tool and set the strength to about 50.
Select the Black Layer's image thumbnail (the one on the left, not the mask) so that it has the white frame around it.
Brush the blur tool around on the black portions in random circles to soften the little white lines up a bit.

And there you have it.

Most people out there heard about 3GP files but the truth is that few really know how to play this format and when faced with the need to watch 3GP they do not know what to do. That is when tutorials are researched and we try to learn how to do it. Let us see what we are dealing with and this will be the only tutorial you will ever need on playing 3GP files.

Many of my customers hold data in Excel files. Then, when they decide to build a web based, database driven project controlled by PHP, ask me to move their Excel data into the MySQL. Whether it’s possible and how to do it, will be the content of this post.

Since the PHP allows you to create an OLE compatible COM object with its methods and properties, the solution is more than easy. All you need is take a brief look into the PHP COM Manual Pages to be able to understand the following explanatory example. I wrote this code as a PHP CLI script which seems to me more usable for interaction with other applications.

Before we start, let’s introduce input parameter of the function which is responsible for data retrieve from an Excel file and output it as a matrix, representing the Excel table.

• $file - (string) absolute path to the Excel data file
• $sheet - (int) order number of the sheet which data we want to extract
• $rows - (array) rows selected from the sheet
• $cols - (array) columns selected from the sheet

function getDataFromExcel($file, $sheet, $rows, $cols)
{
   // COM CREATE
   fwrite(STDOUT, "----------------------------------------\r\n");
   $excel = new COM("Excel.application") or die ("ERROR: Unable to instantaniate COM!\r\n");
   fwrite(STDOUT, "Application name: {$excel->Application->value}\r\n") ;
   fwrite(STDOUT, "Loaded version: {$excel->Application->version}\r\n");
   fwrite(STDOUT, "----------------------------------------\r\n\r\n");

   // DATA RETRIEVAL
   $Workbook = $excel->Workbooks->Open($file) or die("ERROR: Unable to open " . $file . "!\r\n");
   $Worksheet = $Workbook->Worksheets($sheet);
   $Worksheet->Activate;
   $i = 0;
   foreach ($rows as $row)
   {
       $i++; $j = 0;
       foreach ($cols as $col)
       {
           $j++;
           $cell = $Worksheet->Range($col . $row);
           $cell->activate();
           $matrix[$i][$j] = $cell->value;
       }
   }

   // COM DESTROY
   $Workbook->Close();
   unset($Worksheet);
   unset($Workbook);
   $excel->Workbooks->Close();
   $excel->Quit();
   unset($excel);

   return $matrix;
}

// define inputs
$xls_path = "C:\\Users\\Johny\\Documents\\Business\\excel_data.xls"; // input file
$xls_sheet = 1; // sheet #1 from file excel_data.xls
$xls_rows = range(2, 270, 1); // I want extract rows 2 - 270 from excel_data.xls with step 1 row
$xls_cols = array("A", "B", "C", "D", "E", "F"); // I want to extract columns A - F from excel_data.xls

// initiate MySQL connection
mysql_connect("server", "username", "password") or die("Unable to connect MySQL server!");
mysql_select_db("database") or die("Unable to select requested database!");

// retrieve data from excel
$data = getDataFromExcel($xls_path, $xls_sheet, $xls_rows, $xls_cols);

// insert retrieved data into database
foreach ($data as $line)
{
   $i = 0;
   foreach ($line as $col => $entry)
   {
       // create the SET string for INSERT query
       $i++;
       $string .= "`" . $col . "` = '" . $entry . "'";
       if ($i < count($line))
           $string .= ", ";
   }
   mysql_query("INSERT INTO `table` SET " . $string . "");
}

Writing external scripts to perform complex data handling is a tedious affair. The best way to automate tasks straightaway into the server is by using Stored Procedures. It is very useful to make them as flexible as possible, as it facilitates easy identification of any errors and can be used for executing a variety of tasks as well.

What are Stored Procedures?

Stored procedures are set of SQL commands that are stored in the database data server. After the storing of the commands is done, the tasks can be performed or executed continuously, without being repeatedly sent to the server. This also helps in decreasing the traffic in the networks and also reduces the CPU load.

CREATE

    [DEFINER = { user | CURRENT_USER }]

    PROCEDURE sp_name ([proc_parameter[,...]])

    [characteristic ...] routine_body 

CREATE

    [DEFINER = { user | CURRENT_USER }]

    FUNCTION sp_name ([func_parameter[,...]])

    RETURNS type

    [characteristic ...] routine_body    

proc_parameter:

    [ IN | OUT | INOUT ] param_name type    

func_parameter:

    param_name type 

type:

    Any valid MySQL data type 

characteristic:

    LANGUAGE SQL

  | [NOT] DETERMINISTIC

  | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

  | SQL SECURITY { DEFINER | INVOKER }

  | COMMENT 'string' 

routine_body:

    Valid SQL procedure statement

Regular expression is the basic functionality of pattern comparison. PHP offers two sets of functions for regular expressions - POSIX style and Perl style. Both types have their unique syntax and this post should give basic overview of the POSIX one.

Regular expression (called regex) is nothing more just sequence of characters (called pattern) which is compared agains a text in which we search. Patterns contain a combination of metacharacters and literals. Metacharacters (also called operators) define how literals (also called constants) should be treated on pattern evaluation against evaluated expression. For example, POSIX pattern [a-z0-9] which determines valid expression containig lowercase letters or number 0-9 has two metacharacters (opening square bracket and closing square bracket) and two literal ranges (a-z and 0-9, also called classes). In other words, literal means character itself whilst metacharacter means control character. Why it’s so important to distinguish between metacharacters and literals? The reason is that if you need to use metacharacters in pattern as a literal you must precede it by \ (backslash), very often said: it must be escaped. For example, if you need to add a dot in the regular expression pattern and don’t want to use this dot as a control character with meaning “any character” it is necessary to escape it - use it with backslash (see the table below for an example).

Following table lists POSIX metacharacters:

Following table lists POSIX character classes for more comfortable programming:

This table lists PHP POSIX regex functions:

Regular expressions are very usefull when we need to check some user inputs. If you have a contact form on your site which contains mandatory e-mail address field, how would you check whether user input string has valid e-mail format? Use regular expression match! Here are some examples for better understanding:

• ^(([A-Za-z0-9_-]+)[.]([A-Za-z0-9_-]+))+$ : matches a hostname expression (hostname.example.com)
• ^([0-9]{1,3})\.([0-9]{1,3})[.]([0-9]{1,3})\.([0-9]{1,3})$ : matches an IP address (192.168.10.122)
• ^([A-Za-z0-9._-]+)@([A-Za-z0-9._-]+)[.]([a-z]{2,4})$ : matches an e-mail address (mailbox@example.com)

Maybe you have noticed that sometimes there is a choice how to write regular expression pattern. In the first and third example above the dot character is expressed as a member of list class [.] whilst in the second example (IP address regexp) the dot is expressed as an escaped metacharacter \. at some places (this was done for demonstration purposes).

Another very important detail which should be noted is the fact that if you need to use metacharacters in a range class or list class it must be placed at the end of a content of such class, right before closing square bracket [... _-].

You can play with staed above examples by pasting the following code into a regexp.php file and run it in a browser:

  Enter String:



  



  Select Pattern:



  Hostname



  IP Address



  Email Address



  





' . $pattern . '

';

echo 'String: ' . $string . '



';



echo 'Match: ';

if (ereg($pattern, $string))

  echo 'OK';

else

  echo 'WRONG';

?>

I hope this post gave you at least basic overview of POSIX regular expressions and their use in PHP. In some of future articles we will take a look at Perl style regular expressions.

This tutorial will teach you the very basics on how to use a PHP #include command. The #include command is used to insert the content of an external HTML page into an existing PHP page. For example, the header and footer of this page you are reading right now are actually external files which are loaded into the page when you request the server to display the page. Using this technique makes it easier to update the header of all the pages of our website by simple updating a single included header file without having to update any code in any of our pages.

This technique can be used anyone without having any advanced PHP knowledge. This tutorial will teach you how to use this command.

Our tutorial is divided into two main sections:

• Server Requirements
• Code Implementation
  

Server Requirements

In order to run this command you will need to have PHP installed on your server. You can check this with your hosting service provider. Any modern version of PHP will be sufficient to execute this command. Other than that, there are no specific server requirements.

Code Implimentation

We are going to create a very simple example in which a HOME page includes a HEADER into it. This means that we are going to need two pages the HOME page and teh HEADER page.

We will start off with the header page. Using any web editing tool, simply create an HTML page with the following content:

Note that you do not need to create a proper HTML file with ,