Kamran's blog

How to preview a image before upload

2016-07-19T09:44:00.001+05:30

How to preview a image before upload ?

<\script type="text/javascript">
        function readURL(input) {
            if (input.files && input.files[0]) {
                var reader = new FileReader();

                reader.onload = function (e) {
                    $('#blah').attr('src', e.target.result);
                }

                reader.readAsDataURL(input.files[0]);
            }
        }
    <\/script>

<\body>
    <\form id="form1" runat="server">
        <\input type='file' onchange="readURL(this);" />
        <\img id="blah" src="#" alt="your image" />
    <\/form>
<\/body>

Note :- Before using this code remove "\" from the tags

Magic Methods in PHP

2016-05-19T10:57:00.000+05:30

Magic methods in php are some predefined function by php compiler which executes on some event. Magic methods start with prefix __, for example __call, __get, __set.

List of List of Magic Methods in PHP

Magic Method	Description
__construct	This magic methods is called when someone create object of your class. Usually this is used for creating constructor in php5.
__destruct	This magic method is called when object of your class is unset. This is just opposite of __construct.
__get	This method called when your object attempt to read property or variable of the class which is inaccessible or unavailable.
__set	This method called when object of your class attempts to set value of the property which is really inaccessible or unavailable in your class.
__isset	This magic methods trigger when isset() function is applied on any property of the class which isinaccessible or unavailable.
__unset	__unset is something opposite of isset method. This method triggers when unset() function called on inaccessible or unavailable property of the class.
__call	__call magic method trigger when you are attempting to call method or function of the class which is either inaccessible or unavailable.
__callstatic	__callstatic execture when inaccessible or unavailable method is in static context.
__sleep	__sleep methods trigger when you are going to serialize your class object.
__wakeup	__wakeup executes when you are un serializing any class object.
__toString	__toString executes when you are using echo on your object.
__invoke	__invoke called when you are using object of your class as function

Above list is the most conman used magic methods in php object oriented programming. Above magic methods of php executes on some specif events occur on your class object. For example if you simply echo your object then __toString method trigger. Let us create group of related magic method and analyze how it is working.

__construct and __destruct magic method in PHP

__construct method trigger on creation of object. And __destruct triggers of deletion of object. Following is very basic example of __construct and __destruct magic method in php:

class test{

function __construct(){

echo 1;
}
function __destruct(){

echo 2;
}

}
$objT = new test(); //__construct get automatically executed and print 1 on screen
unset($objT);//__destruct triggers and print 2.

get set call and callStatic Magic Methods

__get, __set, __call and __callStatic all magic methods in php directly related with no accessible method and property of the class.
__get takes one argument and executes when any inaccessible property of the method is called. It takes name of the property as argument.
__set takes two property and executes when object try to set value in inaccessible property. It take first parameter as name of the property and second as the value which object is try to set.
__call method fires when object of your class is trying to call method of property which is either non accessible or not available. It takes 2 parameter First parameter is string and is name of function. Second parameter is an array which is arguments passed in the function.
__callStatic is a static magic method. It executes when any method of your class is called by static techniques.

Following is example of __get , __set , __call and __callStatic magic methods

class test {

function
__get($name){

echo "__get executed with name $name ";

}

function
__set($name , $value){

echo "__set executed with name $name , value $value";

}

function __call($name , $parameter){

$a = print_r($parameter , true); //taking recursive array in
string

echo "__call executed with name $name , parameter $a";
}

static function __callStatic($name ,
$parameter){

$a = print_r($parameter , true); //taking recursive array in
string

echo "__callStatic executed with name $name , parameter
$a";

}
}

$a = new test();
$a->abc = 3;//__set will executed
$app = $a->pqr;//__get will triggerd

$a->getMyName('ankur' , 'techflirt',
'etc');//__call willl be executed

test::xyz('1' , 'qpc' ,
'test');//__callstatic will be executed

__isset and __unset magic methods

__isset and __unset magic methods in php are opposite of each other.
__isset magic methods executes when function isset() is applied on property which is not available or not defined. It takes name of the parameter as an argument.
__unset magic method triggers when unset() method is applied on the property which is either not defined or not accessible. It takes name of the parameter as an argument.
Following is example of __isset and __unset magic method in php

class test {

function
__isset($name){

echo "__isset is called for $name";

}

function
__unset($name){

echo "__unset is called for $name";

}

$a = new test();
isset($a->x);
unset($a->c);

What is a PHP Session?

2016-05-19T10:55:00.002+05:30

When you work with an application, you open it, do some changes, and then you close it. This is much like a Session. The computer knows who you are. It knows when you start the application and when you end. But on the internet there is one problem: the web server does not know who you are or what you do, because the HTTP address doesn't maintain state.
Session variables solve this problem by storing user information to be used across multiple pages (e.g. username, favorite color, etc). By default, session variables last until the user closes the browser.
So; Session variables hold information about one single user, and are available to all pages in one application.

Tip: If you need a permanent storage, you may want to store the data in a database.

Start a PHP Session

A session is started with the session_start() function.
Session variables are set with the PHP global variable: $_SESSION.
Now, let's create a new page called "demo_session1.php". In this page, we start a new PHP session and set some session variables:

Example

<\?php
// Start the session
session_start();

// Set session variables
$_SESSION["favcolor"] = "green";
$_SESSION["favanimal"] = "cat";
echo "Session variables are set.";
?>
Note: The session_start() function must be the very first thing in your document. Before any HTML tags.

Get PHP Session Variable Values

Next, we create another page called "demo_session2.php". From this page, we will access the session information we set on the first page ("demo_session1.php").
Notice that session variables are not passed individually to each new page, instead they are retrieved from the session we open at the beginning of each page (session_start()).
Also notice that all session variable values are stored in the global $_SESSION variable:

Example

<\?php
session_start();

// Echo session variables that were set on previous page
echo "Favorite color is " . $_SESSION["favcolor"] . ".
";
echo "Favorite animal is " . $_SESSION["favanimal"] . ".";
?>

Another way to show all the session variable values for a user session is to run the following code:

Example

<\?php
session_start();

print_r($_SESSION);
?>

How does it work? How does it know it's me?
Most sessions set a user-key on the user's computer that looks something like this: 765487cf34ert8dede5a562e4f3a7e12. Then, when a session is opened on another page, it scans the computer for a user-key. If there is a match, it accesses that session, if not, it starts a new session.

Modify a PHP Session Variable

To change a session variable, just overwrite it:

Example

<\?php
session_start();

// to change a session variable, just overwrite it
$_SESSION["favcolor"] = "yellow";
print_r($_SESSION);
?>

Destroy a PHP Session

To remove all global session variables and destroy the session, use session_unset() and session_destroy():

Example

<\?php
session_start();

// remove all session variables
session_unset();

// destroy the session
session_destroy();
?>

Cookies In PHP

2016-05-19T10:53:00.002+05:30

A cookie is often used to identify a user. ( Cookie is used for identify users)

What is a Cookie?

A cookie is often used to identify a user. A cookie is a small file that the server embeds on the user's computer. Each time the same computer requests a page with a browser, it will send the cookie too. With PHP, you can both create and retrieve cookie values.

A Cookie Size is : 4 KB

Maximum Cookies save in a Browser : 400

A Website save maximum Cookies : 20

Create Cookies With PHP

A cookie is created with the setcookie() function.

Syntax

setcookie(name, value, expire, path, domain, secure, httponly);

Only the name parameter is required. All other parameters are optional.

PHP Create/Retrieve a Cookie

The following example creates a cookie named "user" with the value "John Doe". The cookie will expire after 30 days (86400 * 30). The "/" means that the cookie is available in entire website (otherwise, select the directory you prefer).
We then retrieve the value of the cookie "user" (using the global variable $_COOKIE). We also use the isset() function to find out if the cookie is set:

Example

<\?php

$cookie_name = "user";
$cookie_value = "John Doe";
setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/"); // 86400 = 1 day

if(!isset($_COOKIE[$cookie_name])) {
    echo "Cookie named '" . $cookie_name . "' is not set!";
} else {
    echo "Cookie '" . $cookie_name . "' is set!
";
    echo "Value is: " . $_COOKIE[$cookie_name];
}

?>
Note: The setcookie() function must appear BEFORE the tag.

Note: The value of the cookie is automatically URLencoded when sending the cookie, and automatically decoded when received (to prevent URLencoding, use setrawcookie() instead).

Modify a Cookie Value

To modify a cookie, just set (again) the cookie using the setcookie() function:

Example

<\?php
$cookie_name = "user";
$cookie_value = "Alex Porter";
setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/");
if(!isset($_COOKIE[$cookie_name])) {
    echo "Cookie named '" . $cookie_name . "' is not set!";
} else {
    echo "Cookie '" . $cookie_name . "' is set!<\br>";
    echo "Value is: " . $_COOKIE[$cookie_name];
}
?>

Delete a Cookie

To delete a cookie, use the setcookie() function with an expiration date in the past:

Example

<\?php
// set the expiration date to one hour ago
setcookie("user", "", time() - 3600);
echo "Cookie 'user' is deleted.";
?>

Check if Cookies are Enabled

The following example creates a small script that checks whether cookies are enabled. First, try to create a test cookie with the setcookie() function, then count the $_COOKIE array variable:

Example

<\?php
setcookie("test_cookie", "test", time() + 3600, '/');

if(count($_COOKIE) > 0) {
echo "Cookies are enabled.";
} else {
echo "Cookies are disabled.";
}
?>
A session is a way to store information (in variables) to be used across multiple pages.

Unlike a cookie, the information is not stored on the users computer.

Join In CakePHP

2016-05-19T10:45:00.001+05:30

There are two main ways that you can do this. One of them is the standard CakePHP way, and the other is using a custom join.

The CakePHP Way

You would create a relationship with your User model and Messages Model, and use the containable behavior:

class User extends AppModel {

public $actsAs = array('Containable');

public $hasMany = array('Message');

}

class Message extends AppModel {

public $actsAs = array('Containable');

public $belongsTo = array('User');

}

You need to change the messages.from column to be messages.user_id so that cake can automagically associate the records for you.

Then you can do this from the messages controller:

$this->Message->find('all', array(

'contain' => array('User')

'conditions' => array(

'Message.to' => 4

'order' => 'Message.datetime DESC'

));

The (other) CakePHP way

I recommend using the first method, because it will save you a lot of time and work. The first method also does the groundwork of setting up a relationship which can be used for any number of other find calls and conditions besides the one you need now. However, cakePHP does support a syntax for defining your own joins. It would be done like this, from the MessagesController:

$this->Message->find('all', array(

'joins' => array(

array(

'table' => 'users',

'alias' => 'UserJoin',

'type' => 'INNER',

'conditions' => array(

'UserJoin.id = Message.from'

)

'conditions' => array(

'Message.to' => 4

'fields' => array('UserJoin.*', 'Message.*'),

'order' => 'Message.datetime DESC'

));

Note, I've left the field name messages.from the same as your current table in this example.

Using two relationships to the same model

Here is how you can do the first example using two relationships to the same model:

class User extends AppModel {

public $actsAs = array('Containable');

public $hasMany = array(

'MessagesSent' => array(

'className' => 'Message',

'foreignKey' => 'from'

)

);

public $belongsTo = array(

'MessagesReceived' => array(

'className' => 'Message',

'foreignKey' => 'to'

)

);

}

class Message extends AppModel {

public $actsAs = array('Containable');

public $belongsTo = array(

'UserFrom' => array(

'className' => 'User',

'foreignKey' => 'from'

)

);

public $hasMany = array(

'UserTo' => array(

'className' => 'User',

'foreignKey' => 'to'

)

);

}

Now you can do your find call like this:

$this->Message->find('all', array(

'contain' => array('UserFrom')

'conditions' => array(

'Message.to' => 4

'order' => 'Message.datetime DESC'

));

Cake PHP Url Rewriting

2016-05-19T10:41:00.000+05:30

Cake PHP Url Rewriting

Some developers don’t like CakePhp Url structure because controller name should end with “s” and that cause a lot of dissatisfaction fro developers while developing with cakephp.
For this CakePhp provides a simple and effective way to rewrite url in seo friendly way and according to client requirement.
So how to write code for it. Here is the simple example.

Go to app -> config -> routes.php
Add the following code

Router::connect('/contact-us', array('controller' => 'messages'));

Above code simply render the request for “/contact-us” to “messages” controller .

Router::connect('/terms',array('controller' => 'pages', 'action' => 'display','terms'));

And this code render the request for “pages” controller with action “display” with parameter “terms” to “/terms”.

CakePHP Questions And Answer

2016-05-19T10:40:00.001+05:30

(1) What is Cakephp?

CakePHP is a free, open-source, rapid development framework for PHP. It’s a foundational structure for programmers to create web applications. CakePHP goal is to enable developers to work in a structured and rapid manner–without loss of flexibility. CakePHP takes the monotony out of web development.

(2) When CakePHP was developed?

CakePHP started in April 2005.When a Polish programmer Michal Tatarynowicz wrote a minimal version of a Rapid Application Framework in PHP, dubbing it Cake.CakePHP version 1.0 released in May 2006. (source:http://en.wikipedia.org/wiki/CakePHP)

(3) What is the current stable version of CakePHP?

3.0 (on date 2015-06-12).

(4) What is MVC in CakePHP?

Model view controller (MVC) is an architectural pattern used in software engineering.

Model : Database functions exist in the model

View : Design parts written here

Controller : Business Logic goes here.

(5) Server requirements for CakePHP.

Here are the requirements for setting up a server to run CakePHP:

An HTTP server (like Apache) with the following enabled: sessions, mod_rewrite (not absolutely necessary but preferred)

PHP 4.3.2 or greater. Yes, CakePHP works great in either PHP 4 or 5.

A database engine (right now, there is support for MySQL 4+, PostgreSQL and a wrapper for ADODB).

(6) How to install CakePHP?

step1: Go to cakephp.org and download the latest version of cakephp.

step2: Cakephp comes in a .zip file,so unzip it.

step3: Extract the files in the localhost in the desired folder (for example:cakephp).

step4: Open the browser and run the URL localhost/cakephp

step5: Just Follow the instructions display on the page.

(7) What is the folder structure of CakePHP?

cakephp/

app/

Config/

Console/

Controller/

Lib/

  Locale/

  Model/

  Plugin/

  Test/

  tmp/

  Vendor/

  View/

  webroot/

    .htaccess

  index.php

 lib/

 plugins/

 vendors/

 .htaccess/

 index.php/

 README.md/

(8) What is the name of Cakephp database configuration file name and its location?

Default file name is database.php.default.

Its located at "/app/config/database.php.default".To connect with database it should be renamed to database.php

(9) What is the first file that gets loaded when you run a application using cakephp?can you change that file?

bootstrap.php

yes it can be changed.Either through index.php , or through .htaccess

(10) What is the use of Security.salt and Security.cipherSeed in cakephp? How to change its default value?

- The Security.salt is used for generating hashes.we can change the default Security.salt value in /app/Config/core.php.

- The Security.cipherseed is used for encrypt/decrypt strings.We can change the default Security.cipherSeed value by editing /app/Config/core.php.

(11) What are controllers?

A controller is used to manage the logic for a part of your application. Most commonly, controllers are used to manage the logic for a single model. Controllers can include any number of methods which are usually referred to as actions. Actions are controller methods used to display views. An action is a single method of a controller.

(12) What is default function for a controller?

index() function

(13) Which function is executed before every action in the controller?

function beforeFilter()

(14) List some of the features in CakePHP

Compatible with versions 4 and 5 of PHP

MVC architecture

Built-in validations

Caching

Scaffolding

Access Control Lists and Authentication.

CSRF protection via Security Component.

(15) Using cakephp, what all are drawbacks.

It loads full application before it starts your task. It's not recommended for small projects because of its resource-heavy structure.

(16) What is the naming convention in cakephp?

In Cakephp naming convention have a very important rule to use cake framework functionality.i have describe all naming conventation below.

Table Name : table are plural and lower cased.
Model Name: Model name are singular and CamelCased and model filenames are singular and underscored: model_name.php.

Controller Names : Controller Names are plural and CamelCased with Controller appended: ControllerNamesController, controller filenames are plural and underscored with *controller* appended: controller_names_controller.php.

Associations : Associations should use the ModelName, and the order should match the order of the foreignKeys:

var $belongsTo = ‘User’

Foreign keys : Foreign keys should always be: table_name_in_singular_form_id: user_id (foreign key) → users (table) .

many-to-many join tables should be named: alphabetically_first_table_plural_alphabetically_second_table_plural: tags_users

Column in many-to-many join tables should be named like other foreign keys: tag_id and user_id , columns named “created” and “modified” will automatically be populated correctly

(17) What is Scaffolding in Cakephp?

Scaffolding is a technique that allows a developer to define and create a basic application that can create, retrieve, update and delete objects.

(18) How to add Scaffolding in your application?

To add scaffolding to your application,just add the $scaffold variable in the controller,

<\?php

class PostsController extends AppController {

var $scaffold;

}

Assuming you’ve created Post model class file (in /app/Model/post.php), you’re ready to go. Visit http://example.com/posts to see your new scaffold.

(19) What is a Component in cakephp?

Components are packages of logic that are shared between controllers. They are useful when a common logic or code is required between different controllers.

(20) What are commonly used components of cakephp?

Security

Sessions

Access control lists

Emails

Authentication

Request handling

Scaffolding

(21) What is a Helper?

Helpers in CakePHP are associated with Presentation layers of application.Helpers mainly contain presentational logic which is available to share between many views, elements, or layouts

(22) What are commonly used helpers of cakephp?

· FormHelper

· HtmlHelper

· JsHelper

· CacheHelper

· NumberHelper

· Paginator

· RSS

· SessionHelper

· TextHelper

· TimeHelper

(23) What is a Behavior?

Behaviors in CakePHP are associated with Models.Behaviors are used to change the way models behaves and enforcing model to act as something else.

(24) What is the difference between Component, Helper, Behavior?

Component is a Controller extension, Helpers are View extensions, Behavior is a Model Extension.

For example:

· A shopping cart Component might offer functionality that can be used and shared across multiple Controllers.

· A custom upload Behavior could be used to extend a Model, such as this example for uploading images. Another common example of a Behavior would be to add extra validation functionality beyond that which CakePHP offers by default.

· A Helper can be used to assist with View functionality. A good example here would be the CK Editor helper that makes it easy to display a CK Editor.

(25) What is a Element?

Element in cakephp are smaller and reusable bits of view code. Elements are usually rendered inside views.

(26) What is a layout?

Layout in cakephp are used to display the views that contain presentational code. In simple views are rendered inside a layout

(27) How to set layout in the controller?

var $layout = ‘layout_name’;

to overwrite for a specific action use below code in that action

$this->layout =”layout_name”;

(28) How to include helpers in controller ?

public $helpers = array(‘Form’, ‘Html’, ‘Js’, ‘Time’);

to in specific action use below code in that action

$this->helper[] =”helper_name”;

(29) How to include components in controller ?

public $components = array(‘Emails’, ‘ImageUploader’, ‘Sms’);

(30) How to write, read and delete the Session in cakephp?

$this->Session->write(‘Bird.Color’, ‘Black’);

$black = $this->Session->read(‘Bird.Color’);

$this->Session->delete(‘Bird’);

(31) What is the use of $this->set();

The set() method is used for creating a variable in the view file.Say for example if we write,

$this->set('posts',$posts); in controller fie, then the variable $posts will be available to use in the view template file for that action.

(32) What is the use of $this->set(compact());

Using $this->set(compact()) , we can pass multiple parameters to access into the view file.

For example,

$this->set(compact('posts','users','reports'));

Now all these variables will be available in respective view file.

(33) What are the advantages of each?which would you use and why?

An advantage with first case $this->set('posts', $posts); is that it allows two different names for the view file and controller file. For example, you could write something like $this->set('postData', $posts);. Now the variable name in the view file would be $postData.

The advantage with the second approach $this->set(compact()); is easier to write, and useful especially when we are setting several variables to the view.No need to add separate line for each variable as we have with $this->set();

For example,

$this->set(compact('posts','users','reports'));

(34) Is it possible to have Multiple validation Rules per Field in cakephp?

Yes its possible.

(35) What is wrong with the below validation rule?

'email' => array(

    'rule' => array(

        'rule' => 'notEmpty',

        'message' => 'Please Enter Email address.'

),

    'rule' => array(

        'rule' => 'email',

        'message' => 'Entered Email address is invalid.'

The problem is the first rule notEmpty will never be called because email rule will overwrite it.While using multiple validation rules for the same field you must keep the rule key "unique". In this case if we want to use multiple rules then, we can simple change the rule key names like,

'email' => array(

    'rule1' => array(

        'rule' => 'notEmpty',

        'message' => 'Please Enter Email address.'

),

    'rule2' => array(

        'rule' => 'email',

        'message' => 'Entered Email address is invalid.'

(36) What is the difference between required and notEmpty in cakephp?

Difference between required and notEmpty

(37) How to Get current URL in CakePHP?

To get current url in cakephp use,

echo Router::url($this->here, true);

This will give full URL with hostname.If you want to get relative path instead of full URL,then use the following code:

echo $this->here;

This will produce absolute URL excluding hostname i.e. /controller/abc/xyz/

(38) How can you make urls search engine friendly while using cakephp?

It's an automatic task that is done by cakephp.

(39) Can you list some database related functions in cakephp?

find, findAll , findAllBy , findBy , findNeighbours and query.

(40) Which methods are used to create and destroy model associations on the fly?

The bindModel() and unbindModel() Model methods are used to create and destroy model associations on the fly.

(41) What is the use of requestAction method?

The method requestAction is used to call a controller’s action from any location and returns data from the action.

(42) What is recursive in cakephp?

To understand this topic follow this post :

(43) How can we use ajax in cakephp?

By calling ajax helper and then using it in controller for rendering.

(44) What is habtm?

Has and belongs to many is a kind of associations that can be defined in models for retrieving associated data across different entities.

(45) How cakephp URL looks in address bar?

http://example.com/controller/action/param1/param2/param3

(46) How can you include a javascript menu throughout the site. Give steps.

By adding the javascript files in webroot and call them in default views if needed everywhere or just in the related veiws.

(47) Why cakephp have two vendor folder?what is the difference between two vendors folder available in cakephp?

There will be two vendor folders available in cakephp frame work.

one in ” app ” folder and one in root folder

The vendor folder in the app folder is used to place the third-party libraries which are application specific.

The vendor folder in the root folder is used to place the third-party libraries which are used for multiple applications.

(48) What is the default extension of view files in cakephp?can we change it?if yes then how?

default extension of view files is '.ctp'.

yes we can change it by writing public $ext = '.yourext'; in AppController.If you want to change it for particular controller then add it into that controller only.You can also change it for the specific action of the controller by putting it in that action of controller.

public $ext = '.yourext'; in AppController

 - you can change all the views extentions.

 public $ext = '.yourext';  in specific controller like, PostsController

- you can change all the views extentions of PostsController.

public $ext = '.yourext';  in specific controller action like, index()

- you can change the view extention of index.ctp

Note: You cannot specify multiple extensions, however it seems like there is a fall back to .ctp if no .php file is found.

(49) How can you set custom page title for the static page?

To set a custom page title, copy-paste following code anywhere in your static page (.ctp) file:

$this->set("title_for_layout", "My page title");

(50) How to display the schema of the model?

If you want to display the schema of particular model then you just need to add the following single line of code.For example we have “Posts” Controller.

pr($this->Post->schema());

(51) A current alternative to the Containable behavior is to use the recursive function. Why is the use of the recursive function below incorrect in a case where we want to only retrieve the region data without any model associations?

$this->Region->find('all', array('recursive' => 0));

The use of recursive is incorrect in the above example (if we don’t want to pull any associated data) since recursive works as follows:

· -1 – No associated data is retrieved with the find query.

· 0 – Retrieves any BelongsTo associated data.

· 1 – Retrieves any directly related associations (i.e., BelongsTo, HasMany, HasOne, HasAndBelongsToMany).

· 2 – Retrieves any directly related associations, and their associations’ associations.

So in the above, example, -1 should have been used (rather than 0) to avoid pulling any associated data.

It is also important to note that recursive is slated to be phased out in CakePHP 3 and replaced solely with the Containable behavior.

(52) In the following line of code, how could the Containable behavior be used to optimize the find query so that only the region data is returned (i.e., without any model associations):

$this->Region->find('all');

The Containable behavior allows the developer to specify which associated models (if any) are retrieved from the find query.
So to ensure that no other associated models are returned in the above example, it could simply be re-written as:

$this->Region->find('all',
array('contain' => false));

(53) What’s wrong with this multiple Model Validation rule? Will both, one, or neither rule be executed and why? How might this code be fixed?

'email' => array(

'rule' => array(

'rule' => 'notEmpty',

'message' => 'Email address is required.'

'rule' => array(

'rule' => 'email',

'message' => 'The email address you entered is invalid.'

)

The key 'rule' needs to be unique when calling multiple validation rules. In the case above, the notEmpty rule will never be called, as the email rule will simply overwrite it (since the multidimensional array has the same key).

Each key should be unique, e.g:

'email' => array(

'rule-1' => array(

'rule' => 'notEmpty',

'message' => 'Email address is required.

'rule-2' => array(

'rule' => 'email',

'message' => 'The email address you entered is invalid.'

)

Q-2 What is default function and default controller of cakephp which is called automatically?
Default controller is indexController.php and Default function is index.

Q-3 How cakephp URL looks in address bar?
http://example.com/controller/action/param1/param2/param3

Q-4 List some database related functions in cakephp.
find, findAll , findAllBy , findBy , findNeighbours and query.

Q-9 If you have to validate a registration module for a user, what all can be possible ways , which one is the best?
can be done on submission in controller, or using javascript/ajax while user is still filling the data. second option is better.

Q-10 How can you include a javascript menu throughout the site. Give steps.
By adding the javascript files in webroot and call them in default views if needed everywhere or just in the related veiws.

Q-11 What is a Component in cakephp?
Components are packages of logic that are shared between controllers. They are useful when a common logic or code is required between different controllers.

Q: what is a component,helper and why are they used, is there other way we can do same thing, what is better.
Component : Component is an independent piece of code written for specific task that can be used by calling in diffrent controllers (example : Security, Sessions, Request handling Access, control lists,Emails,Cookies, Authentication)

Helper: Helper is used for helping cakephp in rendering the data to shown the user with views, these only adds to modularity in code otherwise same coding can be implemented in conrollers.

Q: how do you proceed when you have to use cakephp for any application.
take the framework either from cake site or if you have changed according to your needs start from there. proceed with basic software engg. concepts as requirement gathering etc

Q: what is habtm.
has and belongs to many is a kind of associations that can be defined in models for retrieving associated data across different entities.

Q: how can we use ajax in cakephp.
by calling ajax helper and then using it in controller for rendering.

Q: if you have to validate a registration module for a user, what all can be possible ways , which one is the best.
can be done on submission in controller, or using javascript/ajax while user is still filling the data. second option is better.

Q: how can you make urls search engine friendly while using cakephp
it is an automatic task that is done by cakephp.

Q: do you prefer to use cakephp,yes then why ?
Its a wide question and the answer would depend upon the kind of application for which it is to be decided, if its a basic cms i would prefer to have joomla. but yes cakephp is prefered for large systems, “simplicity” is the most important factor.
you include a javascript menu throughout the site. give steps.

Q-5 What are component, helper and why are they used?
A component is an independent piece of code written for specific task that can be used(Eg Email, Ajax, RequestHandler and Session).
A helper is used for helping cakephp in rendering the data to be shown to user with views(Eg Form, HTML etc).

Q-9 Why cakephp have two vendor folder?
There is two vendor folder, one folder in root and another is in "app" folder

Q-10 List some database related functions in cakephp.
find, findAll, findAllBy, findBy, findNeighbours and query.

Q-19 What is a Component in cakephp?
Components are packages of logic that are shared between controllers. They are useful when a common logic or code is required between different controllers.

Q-32 What is a layout?
Layout in cakephp are used to display the views that contain presentational code. In simple views are rendered inside a layout.

Q-38 Which methods are used to create and destroy model associations on the fly?
The bindModel() and unbindModel() Model methods are used to create and destroy model associations on the fly.

Q-39 What is the use of requestAction method?
The method requestAction is used to call a controller's action from any location and returns data from the action.

MVC architecture in PHP

2016-05-19T10:21:00.000+05:30

MVC architecture of CakePHP

CakePHP follows the MVC software design pattern. MVC Programming pattern will separate the application into three parts:

- Model layer
- View layer
- Controller layer

The Model layer

The Model layer represents one part of the application that implements the business logic. Models are representations of database tables. They can connect to database, query it and save data to the database.

In order to work with MVC its very important to note that there must be no interaction between models and views.All the logic will be handled by controllers.
It’s responsible for fetching data and then after converting them into meaningful concepts for the application by processing,validating, associating or other similar tasks related to handling data.

MVC Request

The View layer

You can describe Views as template files that present their content to the user.variables, arrays and objects that are used in views are registered through a controller.
A presentation of the modeled data will be rendered by the View.View will produce the presentational interface for your application using the information it has available.

For example, A set of data returned by the Model layer, will be used by the view to render a HTML page containing it.The View layer is not only used for HTML or text representation of the data,but also used to deliver a wide variety of formats.Like videos, music, documents and other format.

The Controller layer

Requests from the users are handled by the Controller layer.Controller mainly contains the logic of your application. Controller offers various functionalities,they retrieve the data and modify them by accessing database tables through models.They also register the variables and objects, that can be used in views.

You can consider the Controllers as managers taking care that all needed resources for completing a task are delegated to the correct workers.
They wait for petitions from clients, and then checks their validity according to the rules of authentication or authorization, processing to the model, and selects only the correct type of presentational data which are expected by the client ,to finally delegate this rendering process to the View layer.

Mod Rewrite in PHP with .htaccess

2016-05-18T18:07:00.000+05:30

What is Mod Rewrite

-> mod_rewrite is used for rewriting a URL at the server level, giving the user output for that final page.

-> mod_rewrite allows us to rewrite URLs in a cleaner fashion, translating human-readable paths into code-friendly query strings.

For example

http://www.yoursite.com/widgets/blue/

http://www.yoursite.com/widgets.php?colour=blue

Set Up mod_rewrite for Apache on Ubuntu

Step 1 — Enabling mod_rewrite

Run The Below Command for activate mod_rewrite.

Øsudo a2enmod rewrite

Note - This will activate the module or alert you that the module is already in effect. To put these changes into effect, restart Apache.

sudo service apache2 restart

Step 2 — Setting Up .htaccess

A .htaccess file allows us to modify our rewrite rules without accessing server configuration files

First, allow changes in the .htaccess file. Open the default Apache configuration file using nano or your favorite text editor.

Øsudo nano /etc/apache2/sites-enabled/000-default.conf

Inside that file, you will find the

var/www/html>

Options Indexes FollowSymLinks MultiViews

AllowOverride All

Order allow,deny

allow from all

To put these changes into effect, restart Apache.

sudo service apache2 restart

Step 3 — Create .htaccess file

Now, create the .htaccess file.

Øsudo nano /var/www/html/.htaccess

Add this first line at the top of the new file to activate the RewriteEngine.

/var/www/html/.htaccess

RewriteEngine on

Save and exit the file.

To ensure that other users may only read your .htaccess, run the following command to update permissions.

Øsudo chmod 644 /var/www/html/.htaccess

You now have an operational .htaccess file, to govern your web application's routing rules.

Step 4 — Setting Up Files

In this section, we will set up a basic URL rewrite, which converts pretty URLs into actual paths to code. Specifically, we will allow users to access example.com/about.

We will begin by creating a file named about.html.

Øsudo nano /var/www/html/about.html

Copy the following code into the HTML page.

/var/www/html/about.html

<\html>

<\head>

<\title>About Us<\/title>

<\/head>

<\body>

<\h1>About Us<\/h1>

<\/body>

<\/html>

You may access your web application at your_server_ip/about.html or example.com/about.html. Now notice that only about.html is accessible; if you try to access your_server_ip/about, you will get a Not Found error. We would like users to access about instead. Our rewrite rules will allow this very functionality.

Open up the .htaccess file.

Øsudo nano /var/www/html/.htaccess

After the first line, add the following.

/var/www/html/.htaccessRewriteRule ^about$ about.html [NC]

Your file should now be identical to the following.

/var/www/html/.htaccess

RewriteEngine on

RewriteRule ^about$ about.html [NC]

Set Up mod_rewrite for Apache on Wamp

Open httpd.conf file from below path

C:\wamp\bin\apache\apache*\conf

Remove # from beginning of

Ø“LoadModule rewrite_module modules/mod_rewrite.so “

Restart apache server

Note - * Install Wamp Version

Benifits
Applications Must Be Safe

A user must not be able to harm your site in any way by modifying a URL that points to your applications. In order to ensure your site’s safe, check all the GET variables coming from your visitors

For example, imagine we have a simple script that shows all the products in a category.

Generally, it’s called like this:

myapp.php?target=showproducts&categoryid=123

URL Rewrite -> myapp-showproducts-123

Applications Must Be Search-Engine Friendly

It’s not generally known, but many of the search engines will not index your site in depth if it contains links to dynamic pages like the one mentioned above. They simply take the “name” part of the URL, and then try to fetch the contents of the page.

Ex. myapp-mobile-123

Applications user-friendly

then most of your visitors will find it difficult to get back to their favourite category (eg. Nettools/Messengers) every time they start from the main page of your site. Instead, they’d like to see URLs like this:

http://www.yoursite.com/detail-page-38344.html

Changing html files to php

Sometimes you might have a static html website and need to use php code on the html pages. Rather than redirecting all your html pages to the equivalent php versions you simply need to tell your server to parse html files as if they were php.

AddHandler application/x-httpd-php .html

Error pages

Custom error pages can be set up in cpanel fairly easily, if you want to create a custom error page in htaccess instead use this line:

ErrorDocument 404 http://www.yoursite.com/404.php

Removing query strings

Some websites like to link to you by adding an query string, for example I could link to www.yoursite.com/index.php?source=blogstorm just so you know where your traffic came from. This creates duplicate content issue for your site so you really need to redirect back to your homepage:

RewriteCond %{QUERY_STRING} ^source= RewriteRule (.*) /$1? [R=301,L]

SQL Case Sensitive Query with Binary Keyword

2015-11-18T10:51:00.002+05:30

Make a Case-Sensitive Query

SELECT * FROM `table` WHERE BINARY `column` = 'value'

BINARY is a built-in keyword that after your WHERE clause that forces a comparison for an exact case-sensitive match. The BINARY operator casts the string following it to a binary string. This is an easy way to force a comparison to be done byte by byte rather than character by character. BINARY also causes trailing spaces to be significant.

As a side note, you can also make columns case-sensitive by adding the BINARY keyword when you create your table.

Installing Memcached with WAMP

2014-11-26T16:05:00.000+05:30

How to install memcache on wamp server

Follow below instructions
1> The first thing in installing memcached with wamp is to install the Memcached service. download here the Win 32 binary version.
2> Inside the download you will find a memcached.exe file. Extract this to C:\memcached
3> Now to install the service, open a command window and enter the following

- Install the memcached service by running:
C:\memcached\memcached.exe -d install

- Start the memcached service by running:
C:\memcached\memcached.exe -d start

- You can verify if memcached is running by executing this command (You have to see full path of memcached.exe):
C:\memcached\wmic process get description, executablepath | findstr memcached.exe

Install PHP Memcache extension (php_memcache.dll)
- If you don’t have php_memcache.dll in folder C:\wamp\bin\php\php5.x\ext, download it from here and extract into this directory.
- Open php configuration file php.ini from C:\wamp\bin\apache\Apache2.x\bin directory, and add the following line to the end of Dynamic Extensions block which lies between lines 920 and 990 roughly.

extension=php_memcache.dll

- Restart all services of Wamp Server through the system tray menu.

Testing Memcached with PHP

</?php
$memcache = new Memcache;
$memcache->connect('localhost', 11211) or die ("Could not connect to memcache");
$version = $memcache->getVersion();
echo "version: ".$version."
";
$tempObject = new stdClass;
$tempObject->strAttr = 'Testing';
$tempObject->intAttr = 0123456789;
$memcache->set('keys', $tempObject, false, 10) or die ("Failed to save data at the server");
echo "Store data in the cache (data will expire in 10 seconds)
";
$get_result = $memcache->get('keys');
echo "Data from the cache:
";
var_dump($get_result);
?>

How to Upload New Android Apps on Google Play Store

2014-11-24T12:26:00.000+05:30

Its very easy to upload or publish Android Apps on google play store
Follow below steps.

1. Generate APK File.
a. Edit AndroidManifest.xml write (android:debuggable="false") in application tag
android:debuggable="false" >
b. Click on File -> Export -> Export Android Application -> Next -> Browse Project -> Next -> Create new keystore and select Location folder and then write File name same to your application name and click on Save -> Write Password and confirm password -> Next
c. Fill and Write complete form Alias name, password and confirm password same as previous window. Validity years 25. First and Last Name, Organizational Unit, Organization, City or Location, Sate or Province, Country Code like "India". and click Next
d. Browse location or Destination APK file and Click Finish

2. Create Account and Upload APK for publish Apps
a. Buy Account on Google play store with $25
b. Go to your Google Play Developer Console ( https://play.google.com/apps/publish/ )
c. Near the top of the screen, click Add new application.
d. Using the drop down menu, select a default language and add a title for your app.
e. Type the name of your app as you want it to appear in Google Play.
f. Select Upload APK or Prepare Store Listing to add your app's information.
g. Browse your APK and upload

3. Compleate fill information which is show in 3 tab
a. APK
i. Upload APK file
b. Store Listing
i. Fill compleate information which show in form
Title, Short description, Full description, At least 2 screenshots and Max 8, screenshots, 7-inch tablet, 10-inch tablet, Hi-res icon, 32-bit PNG (with alpha), Feature Graphic, JPG or 24-bit PNG (no alpha), Application type , Category, Content rating , Website, Email , Privacy Policy and click sate.
c. Pricing & Distribution
i. Check countries which you want to live.
4. Select published on drop down right side up corner

How to Create Stored Procedure in MySql phpmyadmin with Example

2014-07-23T16:51:00.000+05:30

How to Create MySql Stored Procedure in PHP

Stored Procedure is a group of Transact SQL statements compiled into a single execution.

For create stored procedure please see below. Stored procedure reduces database request traffic.

Database Table

employees table contains empname and empno

CREATE TABLE employees(id INT PRIMARY KEY AUTO_INCREMENT,

empno VARCHAR(50) UNIQUE, empname VARCHAR(50));

connection.php

</?php

$con = mysql_connect(“localhost”, “root”, “root”);

mysql_select_db(“storedprocedure”, $con);

showresult.php (Simple fetch data from database)

</?php

include(“connection.php”);

$query = “select empno, empname from employees”;

$result = mysql_query($query);

while($data = mysql_fetch_array($result))

{

echo $data[‘empno’].’ - ‘.$data[‘empname’].’’;

}

Create Stored Procedure

We are going to create stored procedures that run on our database server.

Stored Procedure name empNoName(). Just like SQL statements.

DELIMITER //

CREATE PROCEDURE empNoName()

SELECT empno, empname from employees;

Call Stored Procedure

showresult.php ( With stored procedures )

</?php

include(“connection.php”);

$query = “CALL empNoName()”;

$result = mysql_query($query);

While($data = mysql_fetch_array($result))

{

echo $data[‘empno’].’ – ‘.$data[‘empname’];

}

Create Stored Procedure for Input

We can create stored Procedure from 2 types

1. 1^st type

Insert procedure IN – Input, name and datatype.

DELIMITER //

CREATE PROCEDURE insert(IN empno VARCHAR(50), IN empname varchar(50))

INSERT INTO employees(empno, empname) values (empno, empname);

2. 2^nd type

DELIMITER //

CREATE PROCEDURE insert(IN empno varchar(50), IN empname varchar(50))

BEGIN

SET @empno=empno;

SET @empname=empname;

PREPARE STMT FROM

“INSERT INTO user(empno, empname) VALUES (?,?)”;

EXECUTE STMT USING @empno, @empname

END

Insert.php

Include(“connection.php”);

$empno = 11;

$empname = “Kamran”;

$query = “CALL insert(‘$empno’, ‘$empname’)”;

$result = mysql_query($query);

Cron Job Configuration Setting Guide

2013-10-21T12:19:00.004+05:30

Cron Job Configuration Guide

Cron Jobs basic setup via Cpanel.

Cron Job is use to run a piece of code on certain time interval. It can done by adding following line via cpanel->Cron Jobs:

/usr/local/bin/php /home/your-site-root-dir/public_html/cron-file.php

Wget Method

* * * * * wget –q –O- ‘http://www.domain.com/cron.php’ >/dev/null

Note: Cron commands depend on the server configuration.

Cron Jobs setup via SSH

-> Login to server via SSH

-> Run cd [path-homedir] command for enter the root folder

-> Run password command

-> You will see the path for root folder (eg. /home/yoursitename/public_html)

-> Run which php

-> You see path to PHP (eg. /usr/local/bin/php)

-> Run crontab –e command

-> It will open crontab file editor

-> Make changes to this file, press I key on keyboard for insert/write mode

How to make a triangle in PHP

2012-02-06T13:06:00.001+05:30

<\?php
for ($size = 1; $size <= 5; $size++)
{
for ($j = 1; $j <= 5 -$size; $j++)
{
echo " ";
}
for ($j = 1; $j <= 2*$size - 1; $j++)
{
echo("*");
}
echo "<\br>";
}

?>

import csv data to mysql using php

2011-10-14T12:33:00.000+05:30

We can import data of CSV into MYSQL via PHP using fgetcsv() function along with some file handling functions. These codes help you to import data from csv file using PHP.

Create Table in bellow formate

CREATE TABLE `users` (

`id` int(11) NOT NULL auto_increment,

`first` text,

`middle` text,

`last` text,

`email` text,

PRIMARY KEY (`id`)

);

Save Bellow Code in import.php file

<\?php

$con = mysql_connect("HostName", "DataBaseUserName", "DataBasePassword");

mysql_select_db("DataBaseName");

if(isset($_POST['submit']))

{

$fileExt = $_FILES['importData']['name'];

$chkExt = explode(".",$fileExt);

if(strtolower($chkExt[1]) == "csv")

{

$fileName = $_FILES['importData']['tmp_name'];

$handle = fopen($fileName, "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)

{

$sql = "INSERT into users(first, middle, last, email) values('".addslashes($data[0])."', '".addslashes($data[1])."', '".addslashes($data[2])."', '".addslashes($data[3])."')";

mysql_query($sql) or die(mysql_error());

}

fclose($handle);

echo "Successfully Imported";

}else{

echo "Invalid File";

}

<\form action='' method='post' enctype="multipart/form-data">

Import File : <\input type="file" name='importData' size='20'>

<\input type='submit' name='submit' value='Submit'>

<\/form>

Note:- Remove "\" from html tags and php opening tags

birth date to year calculation in php

2011-05-21T16:52:00.000+05:30

Note:- If you want to change formate of date for example YYYY-MM-DD to MM-DD-YYYY then change in list() function parametter and pass same formate parameter end of birthday function.

<\?php
function birthday($birthday)
{
    list($year,$month,$day) = explode("-",$birthday);

    //list($day,$month,$year) = explode("-",$birthday);

    $year_diff = date("Y") - $year;
    $month_diff = date("m") - $month;
    $day_diff = date("d") - $day;

    if ($month_diff < 0)
    {
        $year_diff--;
    }
    elseif (($month_diff==0) && ($day_diff < 0))
    {
        $year_diff--;
    }
    return $year_diff;
}

//echo birthday("YYYY-MM-DD");

echo birthday("1982-11-10");

//echo birthday("11-01-1985");
?>

multidimensional array sorting in php

2011-05-17T14:08:00.000+05:30

Note:- In this post I am sorting multidimensional array by first name if you want to sort by other field then remove first_name and write other field in
array_sort_by_column($people, 'first_name');
Note :- Remove "\" from all places I have added "\" because blogger posting not supported html tags and php opening tag

<\?php

$people = array(
    1 => array(
        'id' => 1,
        'first_name' => 'Kamran',
        'surname' => 'Ahmad',
        'age' => 25,
        'sex' => 'm'
    ),
    2 => array(
        'id' => 2,
        'first_name' => 'Adam',
        'surname' => 'Smith',
        'age' => 18,
        'sex' => 'm'
    ),
    3 => array(
        'id' => 3,
        'first_name' => 'Joe',
        'surname' => 'Bloggs',
        'age' => 23,
        'sex' => 'm'
    ),
   4 => array(
        'id' => 4,
        'first_name' => 'Amy',
        'surname' => 'Jones',
        'age' => 21,
        'sex' => 'f'
    )
);

function array_sort_by_column(&$arr, $col, $dir = SORT_ASC) {
    $sort_col = array();
    foreach ($arr as $key=> $row) {
        $sort_col[$key] = $row[$col];
    }

    array_multisort($sort_col, $dir, $arr);
}

array_sort_by_column($people, 'first_name');
?>
<\table width="500px" cellpadding="0" cellspacing="0" border="1">
   <\tr>
       <\td height="30px" align="center"><\b>ID<\/td>
       <\td height="30px" align="center"><\b>First name<\/b><\/td>
       <\td height="30px" align="center"><\b>Surname<\/b><\/td>
       <\td height="30px" align="center"><\b>Age<\/b><\/td>
       <\td height="30px" align="center"><\b>Sex<\/b><\/td>

foreach($people as $peo)
{
   echo "<\tr>";
   echo "<\td height='30px' align='center'>".$peo['id']."<\/td>";
   echo "<\td height='30px' align='center'>".$peo['first_name']."<\/td>";
   echo "<\td height='30px' align='center'>".$peo['surname']."<\/td>";
   echo "<\td height='30px' align='center'>".$peo['age']."<\/td>";
   echo "<\td height='30px' align='center'>".$peo['sex']."<\/td>";
   echo "<\/tr>";
}

?>

<\/table>

export data from mysql database table in csv file using php

2011-05-05T18:10:00.001+05:30

In this post we export data from mysql database table in csv file formate using php.

Note : Save bellow file as name csvfile.php

<\?php
$host = 'localhost'; // MySql DataBase Host Name
$db = 'databasename'; // MySql DataBase Name
$user = 'root'; // MySql DataBase UserName
$pass = ''; // MySql DataBase Password

// Connect to the database
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);

require 'exportcsv.php';
$table="TableName"; // Table Name that you want to export in csv file from mysql database.

exportMysqlToCsv($table);
?>

Note: Save bellow file as name exportcsv.php

<\?php
function exportMysqlToCsv($table, $filename = 'csvfilename.csv')
{
    $csv_terminated = "\n";
    $csv_separator = ",";
    $csv_enclosed = '"';
    $csv_escaped = "\\";

   $sql_query = "select * from $table";
    $result = mysql_query($sql_query);
   $fields_cnt = mysql_num_fields($result);

    $schema_insert = '';
    for ($i = 0; $i < $fields_cnt; $i++)
    {
        $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
            stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
        $schema_insert .= $l;
        $schema_insert .= $csv_separator;
    } // end for
    $out = trim(substr($schema_insert, 0, -1));
    $out .= $csv_terminated;
    // Format the data
    while ($row = mysql_fetch_array($result))
    {
        $schema_insert = '';
        for ($j = 0; $j < $fields_cnt; $j++)
        {
            if ($row[$j] == '0' || $row[$j] != '')
            {
                if ($csv_enclosed == '')
                {
                    $schema_insert .= $row[$j];
                }
                else
                {
                    $schema_insert .= $csv_enclosed .
                    str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
                }
            }
            else
            {
                $schema_insert .= '';
            }
            if ($j < $fields_cnt - 1)
            {
                $schema_insert .= $csv_separator;
            }
        } // end for
        $out .= $schema_insert;
        $out .= $csv_terminated;
    } // end while
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Length: " . strlen($out));
    // Output to browser with appropriate mime type, you choose ;)
    header("Content-type: text/x-csv");
    //header("Content-type: text/csv");
    //header("Content-type: application/csv");
    header("Content-Disposition: attachment; filename=$filename");
    echo $out;
    exit;
}
?>

url rewriting using .htaccess

2011-03-25T15:56:00.003+05:30

URL Rewriting using .htaccess

Here is some example of URL Rewriting. If you are searching for URL Rewriting the bellow code help you for rewriting. In this post we are rewrite URL though .htaccess file. Bellow is some example for URL Rewriting using .htaccess file.

1) Redirecting non www URL to www URL

If we type on browser’s address bar domainname.com it will be redirected to www.domainname.com.

RewriteEngine On
RewriteCond %{HTTP_HOST} ^domainname\.com$
RewriteRule (.*) http://www.domainname.com/$1 [R=301,L]

2) Rewriting filename.php?id=111 to filename-111.html
Example : profile.php?id=111 to profile-111.html

It’s simple redirection rule in which php extension is hidden from browser address bar and generate dynamic url converted into a static URL.

RewriteEngine on
RewriteRule ^profile-([0-9]+)\.html$ profile.php?id=$1
Note: containing “?” character

3) Rewriting filename.php?id=111 to filename/name/111.html
Example: profile.php?id=111 to profile/kamran/111.html

In the following URL rewriting technique you can display the name of the profile in URL.

RewriteEngine on
RewriteRule ^profile/([a-zA-Z0-9_-]+)/([0-9]+)\.html$ profile.php?id=$2

4) Rewriting http://www.domainname.com/profile.php?username=abc to http://www.domainname.com/abc
Have you seen twitter.com or facebook.com. If you type http://twitter.com/ekamraan or http://facebook.com/ekamran in browser you can see my profile over there. If you want to do same kind of redirection i.e http://domainname.com/profile.php?username=abc to http://domainname.com/xyz then you need to add the following code to the .htaccess file.
RewriteEngine On
RewriteRule ^([a-zA-Z0-9_-]+)$ profile.php?username=$1
RewriteRule ^([a-zA-Z0-9_-]+)/$ profile.php?username=$1

5) Redirecting the domainname to a new subfolder of inside www or public_html.

If you have redeveloped your site and all the new development of site in "newfolder” of inside root folder. Then the new development of the site can be access like “http://www.domainname.com/newfolder”. Moving these files to the root newfolder can be a engaged process so you can use bellow code inside the .htaccess file and upload it under the root folder of the site. www.domainname.com point out to the files inside “newfolder”.

RewriteEngine On
RewriteCond %{HTTP_HOST} ^domainname\.com$ [OR]
RewriteCond %{HTTP_HOST} ^www\.domainname\.com$
RewriteCond %{REQUEST_URI} !^/newfolder/
RewriteRule (.*) /newfolder/$1

how to create static html page from a database table using php

2010-10-21T16:21:00.000+05:30

In this post we are creating a html file or pages which is static page in specific loacation of folder from a databse table using php. In this program we are also creating folders in specific location maintain url.

This table contains all the data for the "static" pages of the site.

Note: Please remove all "\" from bellow code, I have use it because blogger does not show html tags.

Step 1. Create a table as bellow.

CREATE TABLE `template` (

`id` bigint(200) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

`address` text NOT NULL,

`city` varchar(200) NOT NULL,

`country` varchar(200) NOT NULL,

`companyname` varchar(200) NOT NULL,

`empid` varchar(200) NOT NULL,

PRIMARY KEY (`id`)

);

Step 2. Copy bellow code and create a php file name refresh.html.

<\?php

ob_start();

/**************** DataBase Conectivity ************/

$connect = mysql_connect("localhost", "root", "") or die(mysql_error());

mysql_select_db("test");

/************** Create Directory(Folder)*************/

$query_dir = "select * from template";

$ressel_dir = mysql_query($query_dir);

while($data_dir = mysql_fetch_array($ressel_dir))

{

$datadir = $data_dir['name'];

$datapage = $data_dir['id'];

/**************Include Pages**************/

include ("template.php");

$content = ob_get_contents();

ob_end_clean();

$dir_name = strtolower(str_replace(' ', '-', $datadir));

$dir_page = strtolower(str_replace(' ', '-', $datapage));

@mkdir($dir_name, 0777, true);

/*************** Create File Path *****************/

$filename = $dir_name."/".$dir_page.".html";

/************** Write contents on file ****************/

$fp = fopen($filename, "w") or die("Could't open $filename");

fwrite($fp, $content);

fclose($fp);

}

echo "All File written Success Full<\br />";

echo "Congratulation HTML File has been created";

Step 3. Copy bellow code and create a php file name template.php

$query= "select * from template where id='".$datapage."'";

$res = mysql_query($query) or die(mysql_error());

$data = mysql_fetch_assoc($res);

<\html>

<\head>

<\title>creating static html page from a database table using php<\/title>

<\/head>

<\body>

<\table border="0" cellpadding="0" cellspacing="0" width="100%">

<\tr>

<\td><\b>Name<\/b><\/td>

<\td><\b>Address<\/b><\/td>

<\td><\b>City<\/b><\/td>

<\td><\b>Country<\/b><\/td>

<\td><\b>Company Name<\/b><\/td>

<\td><\b>Employee ID<\/b><\/td>

<\/tr>

<\tr>

<\td><\?=$data['name']?><\/td>

<\td><\?=$data['address']?><\/td>

<\td><\?=$data['city']?><\/td>

<\td><\?=$data['country']?><\/td>

<\td><\?=$data['companyname']?><\/td>

<\td><\?=$data['empid']?><\/td>

<\/tr>

<\/table>

<\/body>

<\/html>

How to check the user’s browser type and platform in php

2010-09-25T17:55:00.000+05:30

Tracks site visitor browser types.

<\?php
echo($_SERVER[‘HTTP_USER_AGENT’]);
?>

how to select limited characters from a table column in mysql

2010-08-23T16:35:00.000+05:30

In MySQL you can draw on the LEFT() thread function to choose a fix digit of qualities as of the left of a specific data column which permits me to obtain an appearance at the primary little utterances in comment to estimate. In this situation I am fetching 100 characters.

<\?php
      $query = "select id, left(content, 100), title from tablename";
      $res = mysql_query($query);
      while($data = mysql_fetch_array($res))
      {
             echo $data['id'];
             echo $data['left(content, 100)'];
             echo $data['title'];
             echo "<\br>";
      }
?>

how to search string from text file in php

2010-07-10T01:04:00.002+05:30

search string from text file in php or find string from text file in php
Note: In this file we store ( write ) all string ( value ) in text ( txt ) file. And searching string start from "name:", "address" and mend with ";".

Note: Save bellow string for search in "test.txt" file.

Hi my name:Kamran; and address:Delhi;. Working as a Software Developer and my area of expertise in PHP and Java/J2EE and I would like to work in software company providing cutting edge PHP and Java base web application.
In this file I am searching string in php name:ahmad; and address:delhi; with php program bellow. searching string from text file in php.

Note: Save bellow file "searchstring.php".
Note: Remove "\" every place from program

<\?php
    $filename = "test.txt";
    $fp = fopen($filename, "r") or die("couldn't open $filename");
    while(!feof($fp))
    {
        $char = fgets($fp);
        $name = strstr($char,'name:');
        $name1 = substr($name, 5);
        $name2 = strpos($name1, ';');

        echo $name3 = substr($name1, 0, $name2);
        echo "<\br>";

        $address = strstr($char,'address:');
        $address1 = substr($address, 8);
        $address2 = strpos($address1, ';');

        echo $address3 = substr($address1, 0, $address2);
        echo "<\br>";
    }
?>

JSP Connectivity with SQL Server

2010-06-15T23:57:00.000+05:30

Note :-
For the connectivity with JSP to SQL Server first Download Microsoft SQL Server JDBC 2.0 Driver for java on the bellow URL:

http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en

or

http://go.microsoft.com/fwlink/?LinkId=144633&clcid=0x409

After download it gives sqljdbc_2.0.1803.100_enu.exe. Run it, then it will gives a zip file, extract Zip file. Copy and paste sqljdbc4.jar in Paste java->jdk->jre->->lib->ext Folder after that restart the Tomcat-Apache webserver.

<%@ page language="java" import="java.sql.*" %>
<%
    Connection con = null;
    Statement stmt =null;
    ResultSet rs = null;
    try{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver://localhost:1433;username=mysqlusername;password=mysqlpassword;databasename=dbname";
        conn = DriverManager.getConnection(url);
        stmt = con.createStatement();
        out.println("Database connected");
        String queryCountry = "Select * from table";
        ResultSet countResultSet = stmt.executeQuery(queryCountry);
            while(countResultSet.next()){
                    out.println(countResultSet.getString("name"));
                    out.println("\n");
            }

      }catch(Exception e){
            out.println(e);
      }

%>

Kamran's blog

How to preview a image before upload

Magic Methods in PHP

List of List of Magic Methods in PHP

__get __set __call and __callStatic Magic Methods

What is a PHP Session?

Start a PHP Session

Example

Get PHP Session Variable Values

Example

Example

Modify a PHP Session Variable

Example

Destroy a PHP Session

Example

Cookies In PHP

Create Cookies With PHP

Syntax

PHP Create/Retrieve a Cookie

Example

Modify a Cookie Value

Example

Delete a Cookie

Example

Check if Cookies are Enabled

Example

Join In CakePHP

Cake PHP Url Rewriting

Cake PHP Url Rewriting

Router::connect('/contact-us', array('controller' => 'messages'));

Above code simply render the request for “/contact-us” to “messages” controller .

Router::connect('/terms',array('controller' => 'pages', 'action' => 'display','terms')); And this code render the request for “pages” controller with action “display” with parameter “terms” to “/terms”.

CakePHP Questions And Answer

(1) What is Cakephp?

(2) When CakePHP was developed?

(3) What is the current stable version of CakePHP?

(4) What is MVC in CakePHP?

(5) Server requirements for CakePHP.

(7) What is the folder structure of CakePHP?

(8) What is the name of Cakephp database configuration file name and its location?

(9) What is the first file that gets loaded when you run a application using cakephp?can you change that file?

(10) What is the use of Security.salt and Security.cipherSeed in cakephp? How to change its default value?

(11) What are controllers?

(12) What is default function for a controller?

(13) Which function is executed before every action in the controller?

(14) List some of the features in CakePHP

(15) Using cakephp, what all are drawbacks.

(16) What is the naming convention in cakephp?

(17) What is Scaffolding in Cakephp?

(18) How to add Scaffolding in your application?

(19) What is a Component in cakephp?

(20) What are commonly used components of cakephp?

(21) What is a Helper?

(22) What are commonly used helpers of cakephp?

(23) What is a Behavior?

(24) What is the difference between Component, Helper, Behavior?

(25) What is a Element?

(26) What is a layout?

(27) How to set layout in the controller?

(28) How to include helpers in controller ?

(29) How to include components in controller ?

(30) How to write, read and delete the Session in cakephp?

(31) What is the use of $this->set();

(32) What is the use of $this->set(compact());

(33) What are the advantages of each?which would you use and why?

(34) Is it possible to have Multiple validation Rules per Field in cakephp?

(35) What is wrong with the below validation rule?

(36) What is the difference between required and notEmpty in cakephp?

(37) How to Get current URL in CakePHP?

(38) How can you make urls search engine friendly while using cakephp?

(39) Can you list some database related functions in cakephp?

(40) Which methods are used to create and destroy model associations on the fly?

(41) What is the use of requestAction method?

(42) What is recursive in cakephp?

(43) How can we use ajax in cakephp?

(44) What is habtm?

(45) How cakephp URL looks in address bar?

(46) How can you include a javascript menu throughout the site. Give steps.

(47) Why cakephp have two vendor folder?what is the difference between two vendors folder available in cakephp?

(48) What is the default extension of view files in cakephp?can we change it?if yes then how?

get set call and callStatic Magic Methods

Router::connect('/terms',array('controller' => 'pages', 'action' => 'display','terms'));

And this code render the request for “pages” controller with action “display” with parameter “terms” to “/terms”.