Wednesday, March 25, 2009

What is Smarty? Why Smarty? How to use Smarty?

About Smarty [What is, Why/How to Use Smarty]

It’s not a new name when we talk about LAMP. Not even like, I am the first going to write any thing about this.

It’s just for my Quick reference (As many time I collected some good information from the net and later that is not available for so many reason... :) )

Smarty is a PHP template available open source. Easy to use, have good documentation and plug-in available and even allow to write custom fuctions

What is a template and what’s the use to have that?

Templates are used to separate the application logic from presentation logic. Programmer handles the application side and presentation side will be maintained by designer.

So templates try to present the code in such a way so that designer can easily understand or don’t have to go through all the details of coding.

Available PHP templates are:-

  • Smarty PHP template,
  • PEAR::HTML_Template_Flexy PHP template,
  • 4/2/2009 class="MsoNormal" style="">PEAR::HTML_Template_IT PHP template,
  • PEAR::HTML_Template_PHPLIB PHP template,
  • PEAR::HTML_Template_Sigma PHP template,
  • PEAR::HTML_Template_Xipe PHP template,
  • patTemplate PHP template.

Why use Smarty template?

In Smarty’s word:

  • Designers can't break application code. They can mess with the templates all they want, but the code stays intact. The code will be tighter, more secure and easier to maintain.
  • Errors in the templates are confined to the Smarty’s error handling routines, making them as simple and intuitive as possible for the designer.
  • With presentation on its own layer, designers can modify or completely redesign it from scratch, all without intervention from the programmer.
  • Programmers aren't messing with templates. They can go about maintaining the application code, changing the way content is acquired, making new business rules, etc. without disturbing the presentation layer.
  • Templates are a close representation of what the final output will be, which an intuitive approach is. Designers don't care how the content got to the template. If you have extraneous data in the template such as an SQL statement, this opens the risk of breaking application code by accidental deletion or alteration by the designer.
  • You are not opening your server to the execution of arbitrary PHP code. Smarty has many security features built in so designers won't breach security, whether intentional or accidental. They can only do what they are confined to in the templates.

Smarty uses {$title} instead of <? echo $title; ?>.

{$title} is less extraneous than <? echo $title; ?>, so it was pretty evident that a simpler syntax helps to make templates easier to read and maintain.

Installation of smarty template

  1. Download smarty. You will get “libs” folder. Libs folder will have : -
    1. internals, plugin, configFile.class.php, debug.tpl, smarty.class.php and smarty_compile.class.php.
  2. Now create four dirs:- (under a folder like /smarty/)
    1. Smarty/templates/
    2. Smarty/template_c/
    3. Smarty/cache/
    4. Smarty/configs/

Note : template_c will have your all compiled template.

  1. Now you will store all your templates in /templates/ folder.
  2. Your config file will be placed at /configs/ folder.
  3. Smarty will store cache file at /cache/ folder, if you have enabled cache. You will enable cache through setting.

Note : Give /template_c and /cache proper permission for writing.

Now start coding with Smarty Template

Your first smarty page: - index.php [PHP file]

// Full path to smarty class-

require ‘your_Smarty_path/Smarty.class.php’;

$smarty = new Smarty();

// Configurations

$smarty->template_dir = ‘your_smarty_path /templates’;

$smarty->compile_dir = ‘your_smarty_path /templates_c’;

$smarty->cache_dir = ‘your_smarty_path /cache’;

$smarty->config_dir = ‘your_smarty_path /configs’;

# now assign variables (defined in template)

$smarty->assign(‘name’, ‘Smarty Enabled File’);

$smarty->display(‘index.tpl’); // template file of index.php

Now index.tpl [Smarty File]

<html>

<head>

<title> My First Smarty File

</head>

<body>

{$name}

</body>

</html>

This is the simplest example of smarty template.

Smarty config file: Smarty config file can have, configuration directives for whole site with some control statement for controlling the config directive usability also. Through this you can tell which variable in config file will be printed or not. The variable can be maintained for section wise also.

Mention config file in template-

{config_load file = ‘config.conf’} at top of the template page.

Use variables of config file like this in template:-

<title> {#pageTitle#}

See two ‘#’ sign before and after variable.

In smarty config file, variable will be declared like this:-

#global variable

pageTitle = 'testing'

You can use double quotes or avoid it in config file. In general use double quotes for string.

Smarty config file can have sections

# student section

[student]

myVars = '…';

# hidden section. Database section.

[.database]

databaseName = 'IGNOU';

databaseUser = 'smarty';

Sample config file

# this is comment

# global vars

pageTitle = 'Testing'

bodyBgColor = 'gray'

[student]

pageTitle = 'Student Info Page'

bodyBgColor = 'orchid'

Use of template variables

{config_load file='config.conf' section='student'}

or

{config_load file='config.conf'}

First will give preference to student section variables in config file. So, when variables in template file do not found in student section then it will look in global variable section.

Documentation for using smarty template

You will find full document of smarty template uses at

Smarty Document

More Smarty Example:

{strip} {/strip} is used in template for stripping whitespace from source.

One dimension array loop in smarty

For Loop

In PHP file:

$arrValue = array('bob','jim','joe','jerry','fred');

$smarty->assign('student', $arrValue);

In Smarty template (tpl) file:

{section name=mysec loop=$student}

{$student[mysec]}

{/section}

Looping Associative array in smarty

In PHP file:

// assign an associative array of data

$arrValue = array(

array('student' => 'bob', 'phone' => '555-3425'),

array('student' => 'jim', 'phone' => '555-4364'),

array('student' => 'joe', 'phone' => '555-3422'),

array('student' => 'jerry', 'phone' => '555-4973'),

array('student' => 'fred', 'phone' => '555-3235')

);

$smarty->assign('student ', $arrValue);

In Smarty Template (tpl) file:

Loop in associative array:

{section name=mysec2 loop=$student }

{strip}

{$users[mysec2].student} : {$users[mysec2].phone}

{/strip}

{/section}

Using PHP code in template (tpl) file:

For running php codes directly in template page, use {php} {/php}.

{php}

echo 'Hello World';

{/php}

Variable modifiers example: capitalize, escape and display date.

In tpl file This will capitalize name variable value:

{$name | capitalize}

Date: {$smarty.nowdate_format:"%d-%m-%Y"}

Include file in template file:

{include file="footer.tpl" title="Header below body"}

Smarty predefined variable

We can use PHP predefined variable in smart template (tpl) file:

Script Name: {$smarty.server.SCRIPT_NAME}

PATH: {$smarty.env.PATH}

PHP_VERSION: {$smarty.const.PHP_VERSION}

Smarty "Capture" Function:

{capture name=banner assign=testAssign}

Hello Testing

{/capture}

Now checking for banner is assigned or not!

{if $smarty.capture.banner ne ''}

{/if}

I have also used assign=testAssign, So I can use this also-

{$testAssign}

Smarty support Custom Function. How to write Custom Function…

Reference :
http://waxjelly.wordpress.com/2007/03/14/how-to-write-a-custom-smarty-function-in-php
http://www.smarty.net

Tuesday, March 24, 2009

How to install MySQL on Windows

Option 1: Use All-in-One distributions packages

There are some distributions packages available that contain Apache, PHP, MySQL and other applications in a single installation file, e.g. XAMPP, WampServer etc.

These packages are good for beginner as well as for Quick setup.

If need custom/ advance configuration use manually installing MySQL, it will help you learn more about the system and give you more control.

Option 2: Manual Installation

Manual Installation

Step 1: Download MySQL

Download MySQL from dev.mysql.com/downloads/. download the “Without installer” version.

Step 2: Extract the files

Extract the ZIP to your C: drive and rename the folder from “mysql-x.x.xx-win32″ to “mysql”.

MySQL can be installed anywhere on your system. If you want a lightweight installation, you can remove every sub-folder except for bin, data, scripts and share.

Step 3: Move the data folder (optional)

I recommend placing the data folder on another drive or partition to make backups and re-installation easier. For the purposes of this example, we will create a folder called D:\MySQLdata and move the contents of C:\mysql\data into it.

You should now have two folders, D:\MySQLdata\mysql and D:\MySQLdata\test. The original C:\mysql\data folder can be removed.

Step 4: Create a configuration file

MySQL provides several configuration methods but, in general, it is easiest to to create a my.ini file in the mysql folder. There are hundreds of options to tweak MySQL to your exact requirements, but the simplest my.ini file is:

[mysqld]

# installation directory

basedir="C:/mysql/"

# data directory

datadir="D:/MySQLdata/"

Step 5: Test your installation

The MySQL server is started by running C:\mysql\bin\mysqld.exe. Open a command box (Start > Run > cmd) and enter the following commands:

cd \mysql\bin

mysqld

This will start the MySQL server which listens for requests on localhost port 3306. You can now start the MySQL command line tool and connect to the database.

Open another command box and enter:

cd \mysql\bin

mysql -u root

This will show a welcome message and the mysql> prompt. Enter “show databases;” to view a list of the pre-defined databases.

Step 6: change the root password

The MySQL root user is an all-powerful account that can create and destroy databases. If you are on a shared network, it is advisable to change the default (blank) password. From the mysql> prompt, enter:

UPDATE mysql.user SET password=PASSWORD("my-new-password") WHERE User='root';

FLUSH PRIVILEGES;

You will be prompted for the password the next time you start the MySQL command line.

Enter “exit” at the mysql> prompt to stop the command line client. You should now shut down MySQL with the following command:

mysqladmin.exe -u root shutdown

Step 7: Install MySQL as a Windows service

From a command prompt, enter:

cd \mysql\bin

mysqld --install

Open the Control Panel, Administrative Tools, and then Services and double-click MySQL.

Set the Startup type to “Automatic” to ensure MySQL starts every time you boot your PC.

Alternatively, set the Startup type to “Manual” and launch MySQL whenever you choose using the command “net start mysql”.

The Windows service can be removed using:

cd \mysql\bin

mysqld --remove