How to integrate fckeditor to smarty application?

Integration of fckeditor in smarty application

1 . in libs\plugins write the foolowing file called function.fckeditor.php

<?php
/**
* Smarty plugin
* @package Smarty
* @subpackage plugins
*/

/**

* Smarty function plugin
* Requires PHP >= 4.3.0
* ————————————————————-
* Type: function
* Name: fckeditor
* Version: 1.0
* Purpose: Creates a FCKeditor, a very powerful textarea replacement.
* ————————————————————-
* @param InstanceName Editor instance name (form field name)
* @param BasePath optional Path to the FCKeditor directory. Need only be set once on page. Default: /FCKeditor/
* @param Value optional data that control will start with, default is taken from the javascript file
* @param Width optional width (css units)
* @param Height optional height (css units)
* @param ToolbarSet optional what toolbar to use from configuration
* @param CheckBrowser optional check the browser compatibility when rendering the editor
* @param DisplayErrors optional show error messages on errors while rendering the editor
* Default values for optional parameters (except BasePath) are taken from fckeditor.js.
* All other parameters used in the function will be put into the configuration section,
* CustomConfigurationsPath is useful for example.
* See http://wiki.fckeditor.net/Developer%27s_Guide/Configuration/Configurations_File for more configuration info.
*/

function smarty_function_fckeditor($params, &$smarty)
{
if(!isset($params['InstanceName']) || empty($params['InstanceName']))
{
$smarty->trigger_error(‘fckeditor: required parameter “InstanceName” missing’);
}

static $base_arguments = array();

static $config_arguments = array();

// Test if editor has been loaded before

if(!count($base_arguments)) $init = TRUE;
else $init = FALSE;

// BasePath must be specified once.

if(isset($params['BasePath']))
{
$base_arguments['BasePath'] = $params['BasePath'];
}
else if(empty($base_arguments['BasePath']))
{
$base_arguments['BasePath'] = ‘/FCKeditor/’;
}

$base_arguments['InstanceName'] = $params['InstanceName'];

if(isset($params['Value']))
$base_arguments['Value'] = $params['Value'];
else
$base_arguments['Value'] = ”;

if(isset($params['Width'])) $base_arguments['Width'] = $params['Width'];

if(isset($params['Height'])) $base_arguments['Height'] = $params['Height'];

if(isset($params['ToolbarSet'])) $base_arguments['ToolbarSet'] = $params['ToolbarSet'];

if(isset($params['CheckBrowser'])) $base_arguments['CheckBrowser'] = $params['CheckBrowser'];

if(isset($params['DisplayErrors'])) $base_arguments['DisplayErrors'] = $params['DisplayErrors'];

// Use all other parameters for the config array (replace if needed)

$other_arguments = array_diff_assoc($params, $base_arguments);
$config_arguments = array_merge($config_arguments, $other_arguments);

$out = ”;
if($init)

{
$out .= ‘<script type=”text/javascript” src=”‘ . $base_arguments['BasePath'] . ‘fckeditor.js”></script>’;
}

$out .= “\n<script type=\”text/javascript\”>\n”;

$out .= “var oFCKeditor = new FCKeditor(‘” . $base_arguments['InstanceName'] . “‘);\n”;

foreach($base_arguments as $key => $value)

{
if(!is_bool($value))
{
// Fix newlines, javascript cannot handle multiple line strings very well.
$value = ‘”‘ . preg_replace(“/[\r\n]+/”, ‘” + $0″‘, addslashes($value)) . ‘”‘;
}
$out .= “oFCKeditor.$key = $value; “;
}

foreach($config_arguments as $key => $value)

{
if(!is_bool($value))
{
$value = ‘”‘ . preg_replace(“/[\r\n]+/”, ‘” + $0″‘, addslashes($value)) . ‘”‘;
}
$out .= “oFCKeditor.Config[\"$key\"] = $value; “;
}

$out .= “\noFCKeditor.Create();\n”;

$out .= “</script>\n”;

return $out;

}

/* vim: set expandtab: */

?>

2 download the fckeditor from the http://www.fckeditor.net/ and save it in the smarty folder

3 in the php file we include the fckeditor.php file

4 in the tpl file we write the following code

{fckeditor BasePath=”../includes/fckeditor/” InstanceName=”news_desc” Width=”650px” Height=”300px” Value=”$news_desc”}

Complete information @ http://anil2u.wordpress.com

Installation of drupal in localhost

Drupal Installation procedure:

1) Download the zip file from http://www.drupal.org that is drupal 5.20 version.

2) Unzip that file and place that folder at www follder

3) Run that file at browser :

http://localhost/drupal/

4) The Drupal installer requires write permissions to

./sites/default/settings.php

during the installation process. So we need to change the file permission of settings.php file.

5) Creare database in phpmyadmin and give the details at the second screen of installation procedure.

6) After that we need to chnage the file permisstion of

./sites/default/settings.php ,

remove the write permisstion.

7) Now we can sucessfully run the drupal site like :

http://localhost/drupal/

Hope that it will be useful.

Complete information @ http://anil2u.wordpress.com

Select the age from birthday date field in mysql ?

Hi,

following is user table:

CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fname` varchar(255) NOT NULL,
`mname` varchar(255) NOT NULL,
`lname` varchar(255) NOT NULL,
`createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`birthday` date NOT NULL,
PRIMARY KEY (`id`)
);

insert one row into table:

INSERT INTO `user` (`id`, `fname`, `mname`, `lname`, `createdat`, `birthday`) VALUES

(1, ‘Anil’, ‘Kumar’, ‘Panigrahi’, ‘2009-11-19 11:04:27′, ‘1983-02-14′),

To retrieve age from the table:

SELECT YEAR( NOW( ) ) - YEAR( birthday ) - IF( MONTH( NOW( ) ) < MONTH( birthday ) , 1, 0 ) - IF( MONTH( NOW( ) ) = MONTH( birthday )AND DAYOFMONTH( NOW( ) ) < DAYOFMONTH( birthday ) , 1, 0 ) AS age, birthday, now( ) From user;

Hope that it will be useful.

Complete information @ http://anil2u.wordpress.com