Learn PHP - PHP Tutorials - PHP Interview Questions and Answers - PHP with MySQL Tutorials

Display custom text in wordpress

2012-01-16T02:06:00.002+05:30

Display custom text in wordpress

Using modified the_excerpt() function we can display an excerpt which is not longer than a predetermined length and doesn’t cut off in mid-sentence.

To do is open functions.php file and paste the code below in it which works as a function

// Variable & intelligent excerpt length.
function print_excerpt($length) { // Max excerpt length. Length is set in characters
 global $post;
 $text = $post->post_excerpt;
 if ( '' == $text ) {
 $text = get_the_content('');
 $text = apply_filters('the_content', $text);
 $text = str_replace(']]>', ']]>', $text);
 }
 $text = strip_shortcodes($text); // optional, recommended
 $text = strip_tags($text); // use ' $text = strip_tags($text,'< a >'); ' if you want to keep some tags

 $text = substr($text,0,$length);
 $excerpt = reverse_strrchr($text, '.', 1);
 if( $excerpt ) {
 echo apply_filters('the_excerpt',$excerpt);
 } else {
 echo apply_filters('the_excerpt',$text);
 }
}

// Returns the portion of haystack which goes until the last occurrence of needle
function reverse_strrchr($haystack, $needle, $trail) {
 return strrpos($haystack, $needle) ? substr($haystack, 0, strrpos($haystack, $needle) + $trail) : false;
}

Now you can use the print_excerpt() function in the theme files like this:

print_excerpt(50);

Display a thumbnail from a Youtube using a shortcode

2011-12-28T21:27:00.002+05:30

How to display a thumbnail from a Youtube using a shortcode

Copy the following code below and then paste it into the functions.php file under theme folder.

/*
    THis Shortcode will display youtube thumbnail on the wordpress blog.
    Usage:
    [youtube_thumb id="VIDEO_ID" img="0" align="left"]
    VIDEO_ID= Youtube video id
    img=0,1,2 or 3
    align= left,right,center
*/
function wp_youtube_video_thumbnail($atts) {
     extract(shortcode_atts(array(
          'id' => '',
          'img' => '0',
          'align'=>'left'
     ), $atts));
    $align_class='align'.$align;

}
add_shortcode('youtube_thumb', 'wp_youtube_video_thumbnail');

Now, you can use the shortcode. The shortcode accept 3 parameters: The video ID, the image size (0 for 480*360px, 1 for 120*90) and the image alignment.

[youtube_thumb id="8O9YA7PZZe0" img="0" align="center"]

Automatically remove p tags on images in wordpress

2011-11-30T02:16:00.003+05:30

Automatically remove p tags on images in wordpress
Wordpress By default embed images in tags. but if you don’t want those p tags to show, the following example display a great way to remove the tags without having to chnage the WordPress core

Just paste the following code in theme functions.php file, and save the file.the
tags are gone now.

add_filter('the_content', 'remove_ptags_on_images');

Login form shortcode for WordPress

2011-10-31T22:09:00.000+05:30

Here we learn how to displaying login forms on wordpress using a shortcodePaste the following code into functions.php file:

function sandip_login_form_shortcode() {
   if ( is_user_logged_in() )
       return '';

   return wp_login_form( array( 'echo' => false ) );
}

function sandip_add_shortcodes() {
   add_shortcode( 'sandip-login-form', 'sandip_login_form_shortcode' );
}

add_action( 'init', 'sandip_add_shortcodes' );

Once done, we can now use the shortcode as shown in the following example. just paste it on the post editor, where you want the login form to be displayed.[sandip-login-form]

Retrieve a remote page using WordPress

2011-09-30T00:13:00.001+05:30

How to retrieve a remote page using WordPress

If you want to get the content,file info from a remote file for use it in wordpress instal then follow the step describe below.
Use the wp_remote_get() function (Or wp_remote_post() is you prefer using the POST method) to retrieve the desired url. The following example describe how to retrieve an url and display its content as well as the file info.

This code can be used anywhere on your template files.

$response = wp_remote_get( 'http://sandipdas.in/file.txt' );
if( is_wp_error( $response ) ) {
echo 'Something went wrong!';
} else {
echo 'Response:';
print_r( $response );

';
}

Display your latest Google+ update on WordPress

2011-09-28T05:03:00.001+05:30

How to display your latest Google+ update on your WordPress blog

Just paste the following code where you want to display your latest Google+ update. Don't forget to put your Google+ ID on line 3.

include_once(ABSPATH.WPINC.'/rss.php');
$googleplus = fetch_feed("http://plusfeed.appspot.com/117307278436515842100

"); // Replace 117307278436515842100 by your own ID
echo '< a href="'; echo $googleplus->items[0]['link']; echo '">';
echo $googleplus->items[0]['summary'];

echo '';

Display a thumbnail of any website in wordpress

2011-08-24T00:35:00.000+05:30

In WordPress we can display a thumbnail of any website. Wordpress have a service named mShots, Its allow us to get snapshots of any website. We can use a shotcode to easily display a snapshot of a given website.

To create the shortcode ,just paste the following code into functions.php file.

function wpr_snap($atts, $content = null) {
extract(shortcode_atts(array(
"snap" => 'http://s.wordpress.com/mshots/v1/',
"url" => 'http://www.sandipdas.in',
"alt" => 'My image',
"w" => '500', // width
"h" => '400' // height
), $atts));

$img = '';
return $img;
}

add_shortcode("snap", "wpr_snap");

Now use the following shortcode to display any snaphot

[snap url="http://www.sandipdas.in" alt="description" w="500" h="400"]

Display Custom Fields Outside Loop in WordPress

2011-07-23T01:16:00.007+05:30

How to Display Custom Fields Outside The Loop in WordPress

When you need to display post-specific content for example a data for a specific post. Usually post specific contents are added via a custom field which can only be displayed inside a post loop.Here we will show you how you can display custom fields outside the loop.

Please check the following code:

global $wp_query;
$postid = $wp_query->post->ID;
echo get_post_meta($postid, 'Your-Custom-Field-data', true);
wp_reset_query();

You will need to make sure that you change the part where it says “Your-Custom-Field-data”.

Wordpress Tricks

2011-07-05T22:15:00.001+05:30

Get Category Name By ID (WordPress)
eho get_cat_name( $cat_id );

Get Category Link By ID (WordPress)
echo get_category_link($cat_id);

A Custom Read More in Wordpress

2011-06-26T10:26:00.000+05:30

Display A Custom Read More in Wordpress

To display "A Custom Read More" all you need to do is replace your usual the_content template tag with the following code. So when you write a new post, create a new custom field with the key name "custom_more".

$custommore = get_post_meta($post->ID, 'custom_more', true);
if (!$custommore) { $custommore = 'Read More »'; }
the_content($custommore);

Detect visitor browser within WordPress

2011-06-15T22:32:00.000+05:30

How to detect the visitor browser within WordPress

To ensure maximum cross-browser compatibility on the wordpress blog theme, We have to able to detect the browser used by the blog visitor. WordPress can detect client browser. I describe the proces below.

Paste the code below in your functions.php file:

add_filter('body_class','browser_body_class');
function browser_body_class($classes) {
global $is_lynx, $is_gecko, $is_IE, $is_opera, $is_NS4, $is_safari, $is_chrome, $is_iphone;

if($is_lynx) $classes[] = 'lynx';
elseif($is_gecko) $classes[] = 'gecko';
elseif($is_opera) $classes[] = 'opera';
elseif($is_NS4) $classes[] = 'ns4';
elseif($is_safari) $classes[] = 'safari';
elseif($is_chrome) $classes[] = 'chrome';
elseif($is_IE) $classes[] = 'ie';
else $classes[] = 'unknown';

if($is_iphone) $classes[] = 'iphone';
return $classes;
}

Now saved the file and the function will automatically add a CSS class to the body tag, as shown in the exemple below:

body class="home blog logged-in safari"

So now with the help of the code, you just have to take your stylesheet, and add some browser-specific styles!

Display Twitter-like “time ago” on WP

2011-05-24T23:31:00.002+05:30

Display Twitter-like “time ago” on your WordPress blog

Twitter have a built-in function that display time from now, like “3 days ago” or “more than a month ago”.If you want to do same with your WordPress post use the following function.

Paste the following into your functions.php file:

function post_time_ago( $type = 'post' ) {
$d = 'comment' == $type ? 'get_comment_time' : 'get_post_time';
return human_time_diff($d('U'), current_time('timestamp')) . " " . __('ago');
}

Now, you can use the following function in your theme files:
echo post_time_ago();

How to modify size of embedded videos

2011-05-08T21:21:00.000+05:30

Modify size of embedded videos in wordpress

In WordPress, it is easy to embed videos on the blog. But sometimes, dealing with the video sizes is a bit painful. Here is a solution how you can adjust the size of any embedded video using a filter in wordpress

Just paste the following code on the functions.php file.

function custom_embed_defaults($embed_size){
    $embed_size['width'] = 650; // Adjust values to your needs
    $embed_size['height'] = 550;

    return $embed_size;
}

add_filter('embed_defaults', 'custom_embed_defaults');

Display wordpress post titles with a custom length

2011-04-23T01:28:00.002+05:30

Display wordpress post titles with a custom length

Display wordpress post titles with a custom length

If you want to display only the first X characters of your wordpress post title, I display here some hack for that.

The first thing to do is to create the function. Open your functions.php file and paste this code:

function ODD_title($char) {
         $title = get_the_title($post->ID);
         $title = substr($title,0,$char);
         echo $title;
}

Now, you use the function on your wordpress theme files. Just pass how many characters you want to display as a parameter. In the following example, only the first 30 chars of the title will be displayed:

ODD_title(20);

So with the following code you can display wordpress post titles with a custom length

Set a maximum word count on post title

2011-04-23T01:20:00.000+05:30

Set a maximum word count on wordpress post titles

If you want to be able to set a maximum word count of post titles so you dont have to think titles that are too long, the following code is help you to overcome that. Here I’ll show you how you can easily set a maximum word count on post titles.

To apply this hack on wordpress post title , just paste the following ode in your functions.php file:

function maxWord($title){
    global $post;
    $title = $post->post_title;
    if (str_word_count($title) >= 10 ) //set this to the maximum number of words
        wp_die( __('Error: your post title is over the maximum word count.') );
}
add_action('publish_post', 'maxWord');

So with this code you can set a maximum word count on post title

How to remove WordPress admin bar from front end

2011-03-30T00:25:00.003+05:30

In the following process you can remove WordPress 3.1 admin bar

WordPress 3.1 introduced a new feature: the admin bar. It is very useful, but if you like to remove it. Please follow the instruction.

Paste the following piece of code into your functions.php file, save it to remove admin bar.

wp_deregister_script('admin-bar');
wp_deregister_style('admin-bar');
remove_action('wp_footer','wp_admin_bar_render',1000);

How to replace words in your wordpress posts

2011-03-24T20:22:00.001+05:30

Replace words in your wordpress posts

Let your Wordpress blog was named “portfolio” and you renamed it “myportfolio”. Then don’t edit your xxx posts to replace every single occurence! With this very useful code will do it for you, like a magic!

Just put words to replace in the array on line 4. Once done, paste the code into your function.php file, save the file, and you're ready!

function replace_text_wps($text){
$replace = array(
// 'WORD TO REPLACE' => 'REPLACE WORD WITH THIS'
'portfolio' => 'myportfolio',
'excerpt' => 'excerpt',
'function' => 'function'
);
$text = str_replace(array_keys($

replace), $replace, $text);
return $text;
}

add_filter('the_content', 'replace_text_wps');
add_filter('the_excerpt', 'replace_text_wps');

How to increase WordPress memory limit

2011-02-01T21:46:00.002+05:30

If ever this happen “Allowed memory size of xxx bytes exhausted”, then we need to increase WordPress memory limit. This can be done

open your wp-config file and paste the following code in it.

define('WP_MEMORY_LIMIT', '96M');

Set An Expiration Time For Wordpress Posts

2011-01-31T22:01:00.003+05:30

Set An Expiration Time For Wordpress Posts:

Sometimes (like, when we are running a contest), We want to be able to publish a post and then automatically stop displaying it after a certain date. This may seem quite hard to do but using the custom field we can do this easyly.

To do this Edit the WP theme and replace the current WordPress loop with this "modified" code:

if (have_posts()) :
while (have_posts()) : the_post(); ?>
$expirationtime = get_post_custom_values('expiration');
if (is_array($expirationtime)) {
$expirestring = implode($expirationtime);
}

$secondsbetween = strtotime($expirestring)-time();
if ( $secondsbetween > 0 ) {
// For example...
the_title();
the_excerpt();
}
endwhile;
endif;

To create a post set to expire at a certain date and time, Like create a custom field. Specify expiration as a key and your date and time as a value (with the format mm/dd/yyyy 00:00:00). The post will not show up after the time on that stamp

**This code does not remove or unpublish post, It just prevents it from being displayed in the loop.

How to make capital letters with CSS style

2011-01-06T20:58:00.000+05:30

You can capitalize words and letters with this css.

.classname{
text-transform: capitalize;
}

This is make Abcde to Abcde

.classname{
text-transform: uppercase;
}

This is make abcde to ABCDE

What is Type Juggling in php

2010-12-24T00:34:00.000+05:30

Type Juggling in php:

PHP does not require explicit type definition in variable declaration. a variable's type is determined by the context in which that variable is used. That is, if you assign a string value to variable $var, $var becomes a string. If you then assign an integer value to $var, it becomes an integer.

An example of PHP's automatic type conversion is the addition operator '+'. If any of the operands is a float, then all operands are evaluated as floats, and the result will be a float. Otherwise, the operands will be interpreted as integers, and the result will also be an integer. Note that this does NOT change the types of the operands themselves; the only change is in how the operands are evaluated.

$foo += 2; // $foo is now an integer (2)
$foo = $foo + 1.3; // $foo is now a float (3.3)
$foo = 5 + "10 Little Piggies"; // $foo is integer (15)
$foo = 5 + "10 Small Pigs"; // $foo is integer (15)

If the last two examples above seem odd, see String conversion to numbers.
If you wish to change the type of a variable, see settype().
If you would like to test any of the examples in this section, you can use the var_dump() function.
Note: The behavior of an automatic conversion to array is currently undefined

What are the functions for IMAP?

2010-12-24T00:29:00.000+05:30

Internet Message Access Protocol:

imap_body : Read the message body
imap_check : Check current mailbox
imap_delete : Mark a message for deletion from current mailbox
imap_mail : Send an email message

What are the database space-saving functions available in php ?

2010-11-19T22:29:00.003+05:30

# Use ip2long() and long2ip() to store the IP adresses as Integers instead
of storing them as strings, which will reduce the space from 15 bytes to 4
bytes. This will also increase search speed and make it easy to see if a ip
falls within a specified range.

# Use gzcompress() and gzuncompress() to reduce the strings before you
store them in a database. The gzcompress can compress plain-text up to 90%.
The only reason why you shouldn’t use it is when you need full-text
indexing capabilities.

How can we save an image from a remote web server to my web server using PHP?

2010-11-19T22:29:00.000+05:30

$file_rimg = fopen("http://w3answers /image23.jpg",'rb');
$newfile_name_img = "/tmp/tutorial.file";
$file_wnew = fopen($newfile_name_img,'wb');
while (!feof($file_rimg)) {
$chunk_rd = fread($file_rimg,1024);
fwrite($file_wnew,$chunk_rd);
}
fclose($file_wnew);
fclose(file_rimg);

Is Single Quotes better then double quotes

2010-11-19T22:27:00.000+05:30

By using single quotes instead of double quotes, we save PHP from having
to parse your string for variables. It's not only is faster, but I find it
more programmer-friendly because it is easier to find variables in your
code.
Also, when referencing an array that has a string index, always use single
quotes. This prevents PHP from having to figure out exactly what you were
trying to say.

How To Protect Special Characters in Query String?

2010-10-30T00:10:00.001+05:30

If you want to include special characters like spaces in the query string,
you need to

protect them by applying the urlencode() translation function. The script
below shows

how to use urlencode():

print(“< html >”);
print(“
Please click the links below”
.” to submit comments about FYICenter.com:
”);
$comment = ‘I want to say: “It\’s a good site! :->”‘;
$comment = urlencode($comment);
print(“
”
.” ”
.”It’s an excellent site! 
”);
$comment = ‘This visitor said: “It\’s an average site! :-(“‘;
$comment = urlencode($comment);
print(“
”
.’’
.”It’s an average site.

”);
print(“< /html >”);

Advantages and disadvantages of CASCADE STYLE SHEETS?

2010-10-30T00:08:00.002+05:30

External Style Sheets
Advantages
Can control styles for multiple documents at once Classes can be created
for use on

multiple HTML element types in many documents Selector and grouping
methods can be

used to apply styles under complex contexts

Disadvantages
An extra download is required to import style information for each
document The

rendering of the document may be delayed until the external style sheet is
loaded

Becomes slightly unwieldy for small quantities of style definitions

Embedded Style Sheets
Advantages
Classes can be created for use on multiple tag types in the document
Selector and

grouping methods can be used to apply styles under complex contexts No
additional

downloads necessary to receive style information

Disadvantage
This method can not control styles for multiple documents at once

Inline Styles
Advantages
Useful for small quantities of style definitions Can override other style

specification methods at the local level so only exceptions need to be
listed in

conjunction with other style methods

Disadvantages
Does not distance style information from content (a main goal of
SGML/HTML) Can not

control styles for multiple documents at once Author can not create or
control classes

of elements to control multiple element types within the document Selector
grouping

methods can not be used to create complex element addressing scenarios

How To Read the Entire File into a Single String?

2010-09-29T21:00:00.003+05:30

Read the Entire File into a Single String
If you have a file, and you want to read the entire file into a single
string, you can use the file_get_contents() function. It opens the
specified file, reads all characters in the file, and returns them in a
single string. Here is a PHP script example on how to file_get_contents():

$file = file_get_contents("/windows/system32/drivers/etc/services");
print("Size of the file: ".strlen($file)."\n");

This script will print:

Size of the file: 7116

Hide .php extension or Hide PHP Usage using .htaccess

2010-08-18T23:38:00.001+05:30

If You may not want other people to know that you are using PHP programming... Here is a easy ways to hide the fact that you're using PHP.
Use another extension than .php for your PHP files... your can use .foo, .blabla, .asp or even .htm and .html (in the later case, PHP parses all the files ending in .html, but it will work fine of course if some of these files are plain HTML; slowdown for parsing plain HTML is not noticeable even on the highest loads thanks to PHP's cache).
This process can be done easily by adding the following line to your .htaccess file in the same directory than your code:
AddType application/x-httpd-php .foo .blabla .asp .htm .html

Send html mail with PHP

2010-08-18T23:37:00.008+05:30

$to = 'pleace your mail id here';
$subject =’Place your subject here’;
$random_hash = md5(date('r', time()));
$headers = 'From: '.$my_fname.' '.$my_lname.' ' ."< ".$my_email." >". "\r\n";
$headers .= "Reply-To: ". $my_email. "\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
$massage='|table width="100%" border="0" align="center" cellpadding="0" cellspacing="1"|
|tr||td|Title :|/td||td|'.$my_title.'|/td||/tr|
|tr||td|First Name :|/td||td|'.$my_fname.'|/td||/tr|
|tr||td|Last Name :|/td||td|'.$my_lname.'|/td||/tr|
|/table|
’;
@mail( $to, $subject, $massage, $headers );

How to Ignore User Abort ?

2010-08-18T23:37:00.006+05:30

When your script is doing something sensible work (like database updating etc.) and you absolutely don't want it to be interrupted by the user pressing the 'Stop' button of his browser. Then just add the following code to your script:

ignore_user_abort(true);

How to show PHP credits?.

2010-08-18T23:37:00.003+05:30

Adding ?=PHPB8B5F2A0-3C92-11d3-A3A9-4C7B08C10000 at the end of the URL of PHP scripts will expose the PHP credits.

Create an image on the fly with the GD library

2010-08-18T23:36:00.000+05:30

Run the following code to create an image on the fly:
header ("Content-type: image/png");
$im = @imagecreate (150, 50)
or die ("Sorry Couldn't create image!");
$background_color = imagecolorallocate ($im, 205, 205, 255);
$text_color = imagecolorallocate ($im, 233, 14, 91);
imagestring ($im, 2, 5, 5, "Your demo text goes here", $text_color);
imagepng ($im);
imagedestroy($im);

How to Save bandwidth

2010-08-18T23:34:00.002+05:30

To save bandwidth add the following code at the beginning of your PHP page, and then PHP will automatically compress the page to web browsers that support with feature (support in both Internet Explorer and Mozilla Firefox do).
Since HTML can easily be compressed, you can expect to cut down by at least 2/3 the bandwidth used at the expense of some extra load on the server's CPU, but the CPU load difference usually isn't even noticeable.

@ini_set('zlib.output_compression_level', 1);
@ob_start('ob_gzhandler');

What is CAPTCHA?

2010-07-31T23:06:00.000+05:30

CAPTCHA stands for Completely Automated Public Turing Test to tell Computers and Humans Apart. CAPTCHA use for prevent spammers from using bots to automatically fill out forms, CAPTCHA programmers will generate an image containing distorted images of a string of numbers and letters. Computers or bot cannot determine what the numbers and letters are from the image but humans have great pattern recognition abilities and will be able to fairly accurately determine the string of numbers and letters. By entering the numbers and letters from the image in the validation field, the application can be fairly assured that there is a human client using it.
You can get more info here:
http://en.wikipedia.org/wiki/Captcha

What are the advantages of stored procedures, triggers, indexes?

2010-06-29T22:59:00.001+05:30

Stored procedure : Stored procedureis a set of SQL commands that can be compiled and stored in the server. Once this process has been done, user don’t need to keep re-issuing the entire query he can refer to the stored procedure. This provides better overall performance because the query has to be parsed only once and less information needs to be sent between the server and the user. We can also raise the conceptual level by having libraries of functions in the server. However, stored procedures of course do increase the load on the database server system, as more of the work is done on the server side and less on the client (application) side.

Trigger : A trigger is effectively a type of stored procedure, one that is invoked when a particular event occurs. For example, we can install a stored procedure that is triggered each time a record is deleted from a transaction table and that stored procedure automatically deletes the corresponding customer from a customer table when all his transactions are deleted.

Indexes : Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. The larger the table, the more this costs. If the table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the data file without having to look at all the data. If a table has 1,000 rows, this is at least 100 times faster than reading sequentially. If you need to access most of the rows, it is faster to read sequentially, because this minimizes disk seeks.

How to Extract Domain name from URL ?

2010-05-15T17:51:00.000+05:30

Here is a simple example describe below.

“parse_url” function can be used to parse the URL.

parse_url is a built in php function which can be used to parse url and get the type of request like whether its http or https or ftp, gives the domain name like www.example.com and path and the query.

eg. consider this url – “http://www.example.com/page.php?id=1”

In “http://www.example.com/page.php?id=1” this url if you execute parse_url function then it will show the following result.

Scheme - http
url - www.example.com
path - /page.php
query - id=1

How to Unlink all files and folder in a particular folder?

2010-04-12T15:31:00.002+05:30

Basically we use "unlink" to delete a file physically.
The syntax is unlink(file path including file name).

But if we want to delete all files and folder of a perticular folder then we can use this code

// arguments : The target directory , delete directory or leave it blank (true/false)
// return : none

function removeAll ($dir, $delDir) {
if(!$dh = @opendir($dir)) return;
while (false !== ($obj = readdir($dh))) {
if($obj=='.' || $obj=='..') continue;
if (!@unlink($dir.'/'.$obj)) removeAll ($dir.'/'.$obj, true);
}
if ($delDir){
closedir($dh);
@rmdir($dir);
}
}

Note: Please change folder permission (0777) before excuting the code

What is Crawler and Indexer

2010-03-21T15:55:00.004+05:30

Crawler and Indexer

Typically the crawler is the component of the search engine responsible for going out and retrieving
content for the indexer to catalog. It reads the list of addresses from the database and downloads a copy
of each document to queue locally to disk where the indexer can access them. Then the indexer
component processes each file in the queue. This tag - team approach works well for large search sites
with massive amounts of data continuously being indexed or if the crawler scans through the documents
in search of links to other documents to retrieve (as is the case with recursive downloading/leeching).

Difference between section and foreach loop in Smarty

2010-02-28T21:44:00.001+05:30

The main difference between SECTION and FOREACH is that

1.For SECTION you can start from a specific value, and can also set a step for the iteration, whereas for FOREACH you have to loop over all values.

2.foreach is used for associative arrays

Array Functions : How to insert an element or remove an element from an array

2010-02-25T22:10:00.000+05:30

In this process you can insert an element or remove an element from an array

$numbers = array(1,2,3,4,5,6);
print_r($numbers);
echo "

";

// shifts first element out of an array
// and returns it.
$a = array_shift($numbers);
echo "a:" . $a ."
";
print_r($numbers);
echo "

";

// prepends an element to an array,
// returns the element count.
$b = array_unshift($numbers, 'first');
echo "b: ". $b ."
";
print_r($numbers);
echo "

";

echo "

";

// pops last element out of an array
// and returns it.
$a = array_pop($numbers);
echo "a: " . $a ."
";
print_r($numbers);
echo "

";

// pushes an element onto the end of an array,
// returns the element count.
$b = array_push($numbers, 'last');
echo "b: ". $b ."
";
print_r($numbers);
echo "

";

Import mysql data to excel

2010-02-05T22:34:00.003+05:30

// Connect database.
mysql_connect("localhost","","");
mysql_select_db("import");

// Get data records from table.
$result=mysql_query("select * from name_list order by id asc");

// Functions for export to excel.
function xlsBOF() {
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
return;
}
function xlsEOF() {
echo pack("ss", 0x0A, 0x00);
return;
}
function xlsWriteNumber($Row, $Col, $Value) {
echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
echo pack("d", $Value);
return;
}
function xlsWriteLabel($Row, $Col, $Value ) {
$L = strlen($Value);
echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
echo $Value;
return;
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition: attachment;filename=orderlist.xls ");
header("Content-Transfer-Encoding: binary ");

xlsBOF();

/*
Make a top line on your excel sheet at line 1 (starting at 0).
The first number is the row number and the second number is the column, both are start at '0'
*/

xlsWriteLabel(0,0,"List of car company.");

// Make column labels. (at line 3)
xlsWriteLabel(2,0,"No.");
xlsWriteLabel(2,1,"Company");

$xlsRow = 3;

// Put data records from mysql by while loop.
while($row=mysql_fetch_array($result)){

xlsWriteNumber($xlsRow,0,$row['id']);
xlsWriteLabel($xlsRow,1,$row['name']);

$xlsRow++;
}
xlsEOF();
exit();

Calculate Visitor Counter

2010-02-05T22:32:00.001+05:30

Follow the step
1. Create a file name "visitcount.dat"
2. Upload the file in webserver
3. make file permission CHMOD *777*
Now Insert the PHP code below

$counterfile = "visitcount.dat";
if(!($fp = fopen($counterfile,"r"))) die ("cannot open counter file");
$count = (int) fread($fp, 20);
fclose($fp);
$count++;
echo "Total hit counter: $count";
$fp = fopen($counterfile, "w");
fwrite($fp , $count);
fclose($fp);

Difference between Split and Explode

2010-01-26T19:18:00.001+05:30

Split Support regular expression
Explode not support regular expression

Port Numbers

2009-12-31T13:44:00.002+05:30

Services Port Numbers
HTTP 80
FTP 21
TELNET 23
POP3 110
SMTP 25
mIRC NoneN
NTP 123
PPTP 1723

If we login more than one browser windows at the same time with same user and after that we close one window, then is the session is exist to other windows or not? And if yes then why? If no then why?

2009-12-31T00:08:00.002+05:30

Session depends on browser. If browser is closed then session is lost. The session
data will be deleted after session time out. If connection is lost and you recreate
connection, then session will continue in the browser.

What are the different functions in sorting an array?

2009-12-31T00:04:00.002+05:30

Sorting functions in PHP:
asort()
arsort()
ksort()
krsort()
uksort()
sort()
natsort()
rsort()

How many ways we can pass the variable through the navigation between the pages?

2009-12-31T00:03:00.000+05:30

At least 3 ways ways we can pass the variable through the navigation between the pages:
1. Put the variable into session in the first page, and get it back from session in the
next page.
2. Put the variable into cookie in the first page, and get it back from the cookie in
the next page.
3. Put the variable into a hidden form field, and get it back from the form in the
next page.

Sql injection

2009-12-29T22:57:00.000+05:30

SQL injection is a code injection technique that exploits a security vulnerability occurring in the database layer of an application. The vulnerability is present when user input is either incorrectly filtered for string literal escape characters embedded in SQL statements or user input is not strongly typed and thereby unexpectedly executed. It is an instance of a more general class of vulnerabilities that can occur whenever one programming or scripting language is embedded inside another. SQL injection attacks are also known as SQL insertion attacks.

Source:wikipedia.org

How do I find out the number of parameters passed into function?

2009-12-22T00:28:00.002+05:30

func_num_args()
function returns the number of parameters passed in.

What's the difference between accessing a class method via -> and via ::?

2009-12-22T00:27:00.000+05:30

:: is allowed to access methods that can perform static operations,
i.e. those, which do not require object initialization.

Are objects passed by value or by reference?

2009-12-22T00:24:00.002+05:30

Everything is passed by value.

How do you call a constructor for a parent class?

2009-12-22T00:23:00.005+05:30

parent::constructor($value)

What’s the special meaning of sleep and wakeup?

2009-12-22T00:23:00.002+05:30

__sleep returns the array of
all the variables than need to be saved, while __wakeup retrieves them.

Explain the differences echo, print and printf ?

2009-12-22T00:14:00.001+05:30

echo is the most primitive of them, and just outputs the contents following the construct to the screen. print is also a construct (so parentheses are optional when calling it), but it returns TRUE on successful output and FALSE if it was unable to print out the string.
However, we can pass multiple parameters to echo, like:

and it will output the string "Welcome to PHP MySQL Guide!"

print does not take multiple parameters. It is also generally argued that echo is faster, but usually the speed advantage is negligible, and might not be there for future versions of PHP.

printf is a function, not a construct, and allows such advantages as formatted output, but it’s the slowest way to print out data out of echo, print and printf.

What's the output of the ucwords function in this example?

2009-12-22T00:07:00.000+05:30

$formatted = ucwords("TECHINTERVIEWS IS COLLECTION OF INTERVIEW
QUESTIONS");
print $formatted;

What will be printed is TECHINTERVIEWS IS COLLECTION OF INTERVIEW
QUESTIONS.
ucwords() makes every first letter of every word capital, but it does not lower-case
anything else. To avoid this, and get a properly formatted string, it’s worth using
strtolower() first.

What’s the difference between htmlentities() and htmlspecialchars()?

2009-12-22T00:06:00.000+05:30

htmlspecialchars only takes care of <, >, single quote ‘, double quote " and ampersand.
htmlentities translates all occurrences of character sequences that have different meaning in HTML.

What’s the difference between md5(), crc32() and sha1() crypto on PHP?

2009-12-22T00:01:00.002+05:30

The major difference is the length of the hash generated.
CRC32 is, evidently, 32 bits, while sha1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions

So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()?

2009-12-21T23:47:00.000+05:30

Crypto usage in PHP is simple, but that doesn’t mean it’s free.

First off, depending on the data that you’re encrypting, you might have reasons to store a 32- bit value in the database instead of the 160-bit value to save on space. Second, the more secure the crypto is, the longer is the computation time to deliver the hash value. A high volume site might be significantly slowed down, if frequent md5() generation is required.

Write a simple program to get a row of information from a database?

2009-12-21T23:34:00.002+05:30

$myrow = mysql_query("SELECT name,email FROM visitors ORDER by name LIMIT
1");
$data = mysql_fetch_row($myrow);
$name = $data[0];
$email = $data[1];
echo "A row from the database is name $name and email $email";

How do you remove the last letter from a string?

2009-12-21T23:32:00.002+05:30

There are many ways to do this. An interviewer will be looking for you to use a compact method. Here is probably the simplest method:

$data = "One too many letterss";
$newdata = substr($data,0,-1);// now 'one too many letters'

What do you need to use the image functions in PHP?

2009-12-21T23:31:00.002+05:30

I need to have access to the GD Library in order to use the image functions in PHP.

What can be possible advantages/disadvantages of page caching? How can you prevent caching of a certain page (please give several alternate solutions)?

2009-12-20T23:39:00.000+05:30

When you use the metatag in the header section at the beginning of an HTML Web page, the Web page may still be cached in the Temporary Internet Files folder.

A page that Internet Explorer is browsing is not cached until half of the 64 KB buffer is filled. Usually, metatags are inserted in the header section of an HTML document, which appears at the beginning of the document. When the HTML code is parsed, it is read from top to bottom. When the metatag is read, Internet Explorer looks for the existence of the page in cache at that exact moment. If it is
there, it is removed. To properly prevent the Web page from appearing in the cache, place another header section at the end of the HTML document.

What changes I have to do in php.ini file for file uploading?

2009-12-20T23:29:00.002+05:30

Make the following line uncomment like:
; Whether to allow HTTP file uploads.
file_uploads = On
; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
upload_tmp_dir = C:\apache2triad\temp
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M

How can I set a cron and how can I execute it in Unix, Linux, and windows?

2009-12-20T23:27:00.000+05:30

Cron is very simply a Linux module that allows you to run commands at predetermined times or intervals.
In Windows, it's called Scheduled Tasks. The name Cron is in fact derived from the same word from which we get the word chronology, which means order of time.
The easiest way to use crontab is via the crontab command.
# crontab
This command 'edits' the crontab. Upon employing this command, you will be able to enter the
commands that you wish to run. My version of
Linux uses the text editor vi. You can find information on using vi here.
The syntax of this file is very important – if you get it wrong, your crontab will not function properly.
The syntax of the file should be as follows:
minutes hours day_of_month month day_of_week command
All the variables, with the exception of the command itself, are numerical constants. In addition to an
asterisk (*), which is a wildcard that allows any value, the ranges permitted for each field are as
follows:
Minutes: 0-59
Hours: 0-23
Day_of_month: 1-31
Month: 1-12
Weekday: 0-6
We can also include multiple values for each entry, simply by separating each value with a comma.
command can be any shell command and, as we will see momentarily, can also be used to execute a
Web document such as a PHP file.
So, if we want to run a script every Tuesday morning at 8:15 AM, our mycronjob file will contain the
following content on a single line:
15 8 * * 2 /path/to/scriptname
This all seems simple enough, right? Not so fast! If you try to run a PHP script in this manner, nothing
will happen (barring very special configurations that have PHP compiled as an executable, as
opposed to an Apache module). The reason is that, in order for PHP to be parsed, it needs to be
passed through Apache. In other words, the page needs to be called via a browser or other means of
retrieving
Web content. For our purposes, I'll assume that your server configuration includes wget, as is the
case with most default configurations. To test your configuration, log in to shell. If you're using an
RPM-based system (e.g. Redhat or Mandrake), type the following:
# wget help
If you are greeted with a wget package identification, it is installed in your system.
You could execute the PHP by invoking wget on the URL to the page, like so:
# wget http://www.example.com/file.php
Now, let's go back to the mailstock.php file we created in the first part of this article. We saved it in
our document root, so it should be accessible via the Internet. Remember that we wanted it to run at
4PM Eastern time, and send you your precious closing bell report? Since I'm located in the Eastern
timezone, we can go ahead and set up our crontab to use 4:00, but if you live elsewhere, you might
have to compensate for the time difference when setting this value.
This is what my crontab will look like:
0 4 * * 1,2,3,4,5 we get http://www.example.com/mailstock.php

What type of headers have to be added in the mail function to attach a file?

2009-12-20T23:20:00.002+05:30

$boundary = '--' . md5( uniqid ( rand() ) );
$headers = "From: \"Me\"\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"";

What is the difference between Reply-to and Return-path in the headers of a mail function?

2009-12-20T23:19:00.000+05:30

Reply-to: Reply-to is where to delivery the reply of the mail.

Return-path: Return path is when there is a mail delivery failure occurs then where to delivery the failure notification.

How to store the uploaded file to the final location?

2009-12-20T23:17:00.000+05:30

move_uploaded_file ( string filename, string destination)

This function checks to ensure that the file designated by filename is a valid upload file (meaning
that it was uploaded via PHP's HTTP POST upload mechanism). If the file is valid, it will be moved to the filename given by destination.
If filename is not a valid upload file, then no action will occur, and move_uploaded_file() will return FALSE.

If filename is a valid upload file, but cannot be moved for some reason, no action will occur, and move_uploaded_file() will return FALSE. Additionally, a warning will be issued.

jQuery's features break down accross eight major categories

2009-12-20T17:35:00.000+05:30

# Core Functionality
Implement core jQuery functions as well as commonly used functions
# Selection and Traversal
Proving functions for finding content in documents and navigating among the content of the document

What is jQuery?

2009-12-20T15:47:00.001+05:30

jQuery is great library for developing ajax based application. jQuery is great library for the JavaScript programmers, which simplifies the development of web 2.0 applications. You can use jQuery to develop cool web 2.0 applications. jQuery helps the programmers to keep code simple and concise. The jQuery library is designed to keep the things very simple and reusable.

jQuery library simplifies the process of traversal of HTML DOM tree. You can use jQuery to handle events, perform animation, and add the ajax support into your web applications with ease

#It is free, open JavaScript library
#Simplifies the task of creating highly responsive web page
#Work accross all modern browsers
#Abstract away browser-specific features, allowing you to concentrate on design
#Focusing on simplifying common scripting tasks
.Getting and manupulating page content
.Working with the modern browser event model
.Adding sophisticated effect

Download watermark script

2009-12-16T23:01:00.001+05:30

Download watermark script

Public, Protected, and Private Properties

2009-12-09T17:29:00.000+05:30

When defining a class member in the class definition, the developer
needs to specify one of these three access modifiers before declaring the member
itself. In case you are familiar with PHP 3 or 4’s object model, all class
members were defined with the var keyword, which is equivalent to public in
PHP 5. var has been kept for backward compatibility, but it is deprecated,
thus, you are encouraged to convert your scripts to the new keywords:
class MyClass {
public $publicMember = "Public member";
protected $protectedMember = "Protected member";
private $privateMember = "Private member";
function myMethod(){
// ...
}
}
$obj = new MyClass();

#Public members can be accessed both from outside an object by
using $obj->publicMember and by accessing it from inside the myMethod
method via the special $this variable (for example, $this->publicMember).
If another class inherits a public member, the same rules apply, and it
can be accessed both from outside the derived class’s objects and from
within its methods.
#Protected. Protected members can be accessed only from within an
object’s method—for example, $this->protectedMember. If another class
inherits a protected member, the same rules apply, and it can be accessed
from within the derived object’s methods via the special $this variable.
#Private. Private members are similar to protected members because they
can be accessed only from within an object’s method. However, they are
also inaccessible from a derived object’s methods. Because private properties
aren’t visible from inheriting classes, two related classes may
declare the same private properties. Each class will see its own private
copy, which are unrelated.

Constructors and Destructors

2009-12-09T15:37:00.001+05:30

Constructors and Destructors are special methods that automatically called when every object is created or destroyed. So the idea is whenever object created stop constructing it and perform the constructor method and whenever we destroy an object, stop and do the destruction method.+

Constructors is more useful,its idle for any initializations,that a object may need before its actually going to be used

In PHP4 Constructors method have the same name as the class

class table{
function Table{
//a PHP4 constructor
}
}

In PHP5 its use as
class table{
function_construct{
//a PHP5 constructor

class Table{
public $legs;

function __construct(){
$this->legs=4;
}
}

$table= new Table();
echo $table->legs;
echo "
";
?>

another example:

class Table{
public $legs;
static public $total_tables=0;

function __construct($leg_count=4){
$this->legs=$leg_count;
Table::$total_tables++;
}
function __destruct(){
Table::$total_tables--;
}
}

$table= new Table();
echo $table->legs;
echo "
";

echo Table::$total_tables . "
"; //1
$t1=new Table(5);
echo Table::$total_tables . "
";
$t2=new Table(6);
echo Table::$total_tables . "
";
?>
Constructors and destructors do not have return types nor can they return values.
References and pointers cannot be used on constructors and destructors because their addresses cannot be taken.
Constructors cannot be declared with the keyword virtual.
Constructors and destructors cannot be declared static, const, or volatile.
Unions cannot contain class objects that have constructors or destructors

Constructors and destructors obey the same access rules as member functions. For example, if you declare a constructor with protected access, only derived classes and friends can use it to create class objects.

source:lynda.com

Static modifier use in php

2009-12-09T15:36:00.001+05:30

Static method doesn't require an instance (and may return one instead) and is more or less like a global function except for it is put in class' namespace (and therefore avoid collisions with other functions) and has access to class' private members.

So, use it whenever you're interested in these properties of the function.

class Student{
static $total_students=0;

static public function add_student(){
Student::$total_students++;
}

static function welcome_students($var="Hello"){
echo "{$var} students";
}
}

echo Student::$total_students;
echo "
";
echo Student::welcome_students();
echo "
";
echo Student::welcome_students("Welcome");
echo "
";
Student::$total_students=3;
echo Student::$total_students;
echo "
";
Student::$total_students=1;
echo Student::$total_students;
echo "
";

////Static variable shared through the inherited tree

class One{
static $foo;
}
class Two extends One{

}
class Three extends One{

}

One::$foo=1;
Two::$foo=2;
Three::$foo=3;
echo One::$foo;
echo "
";
echo Two::$foo;
echo "
";
echo Three::$foo;
?>

source:lynda.com and stackoverflow.com

Setters and Getters in Access Modifiers

2009-12-09T15:35:00.001+05:30

The setter and getter method handlers agrees to read/write the values

class SetterGetterExample{
private $a=1;
public function get_a(){
//log_user_ip_address
return $this->a;
}
public function set_a($value){
$this->a=$value;
}
}

$example=new SetterGetterExample();

//echo $example->a;

echo $example->get_a();
$example->set_a(15);
echo "
";
echo $example->get_a();
?>

Dynamically set and get variable values. This is an abstract class that can be used to dynamically add variables to any class.

Access Modifiers

2009-12-09T15:34:00.002+05:30

There are 3 access modifiers: Public; Private; and Protected

'Public' is the default modifier.

Public: Use In Everywhere
Private: Use in This class only
Protected: Use in This class and subclass

class Example{
public $a=1;
protected $b=2;
private $c=3;

function show_abc(){
echo $this->a;
echo $this->b;
echo $this->c;
}

public function hello_everyone(){
return "Hello Everyone"."
";
}
protected function hello_family(){
return "Hello Family"."
";
}
private function hello_me(){
return "Hello Me"."
";
}

function hello(){
$output = $this->hello_everyone();
$output .= $this->hello_family();
$output .= $this->hello_me();

return $output;
}

}

$example= new Example();
echo "public a:{$example->a}
";
//echo "protected b:{$example->b}
";
//echo "private c:{$example->c}
";
$example->show_abc();
echo "
";
echo "hello_everyone: {$example->hello_everyone()}
";
//echo "hello_me: {$example->hello_me()}
";
echo $example->hello();
?>

source:lynda.com

Understanding Class Inheritance

2009-12-09T15:34:00.000+05:30

There are many benefits of inheritance with PHP, the most common is simplifying and reducing instances of redundant code. Class inheritance may sound complicated, but think of it this way. Consider a tree. A tree is made up of many parts, such as the roots that reside in the ground, the trunk, bark, branches, leaves, etc. Essentially inheritance is a connection between a child and its parent.

class Car{
var $wheels=4;
var $doors=4;

function wheelsdoors(){
return $this->wheels + $this->doors;
}
}

class CompactCar extends Car{
var $doors=2;
function wheelsdoors(){
return $this->wheels + $this->doors+ 100;
}
}

$car1 = new Car();
$car2 = new CompactCar();

echo $car1->wheels . "
";
echo $car1->doors . "
";
echo $car1->wheelsdoors() . "
";
echo "
";
echo $car2->wheels . "
";
echo $car2->doors . "
";
echo $car2->wheelsdoors() . "
";

echo "Car parents:".get_parent_class('Car')."
";
echo "CompactCar parents:".get_parent_class('CompactCar')."
";
echo "
";
echo is_subclass_of('Car','Car')? 'true' : 'false';
echo "
";
echo is_subclass_of('CompactCar','Car')? 'true' : 'false';
echo "
";
echo is_subclass_of('Car','CompactCar')? 'true' : 'false';

?>

Source: www.webreference.com

Would you initialize your strings with single quotes or double quotes?

2009-12-09T01:06:00.000+05:30

Since the data inside the single-quoted string is not parsed for variable substitution, it’s always a better idea speed-wise to initialize a string with single quotes, unless specifically need variable substitution.

What’s the special meaning of sleep and wakeup?

2009-12-09T01:04:00.001+05:30

__sleep returns the array of all the variables than need to be saved,
while __wakeup retrieves them.

What are the differences between DROP a table and TRUNCATE a table

2009-12-09T01:03:00.000+05:30

DROP TABLE table_name - This will delete the table and its data.
TRUNCATE TABLE table_name - This will delete the data of the table, but not the table definition.

How can we encrypt the username and password using PHP?

2009-12-09T00:47:00.000+05:30

1)
encrypt a password with the following Mysql>SET PASSWORD=PASSWORD("Password");
2)
use the MySQL PASSWORD() function to encrypt username and password. For example, INSERT into user (password, ...) VALUES (PASSWORD($password)), ...);

What is the difference between mysql_fetch_object and mysql_fetch_array?

2009-12-09T00:44:00.000+05:30

MySQL fetch object will collect first single matching record where mysql_fetch_array will collect all matching records from the table in an array

Explain the differences between echo, print and printf?

2009-12-08T22:57:00.000+05:30

Echo just outputs the contents following the construct to the screen.
print is also a construct (so parentheses are optional when calling it), but it returns TRUE on successful output and FALSE if it was unable to print out the string.
However, you can pass multiple parameters to echo, like:

echo 'Welcome ', 'to', ' ', 'php mysql guide!';

and it will output the string "Welcome to php mysql guide!"
print does not take multiple parameters.
It is also generally argued that echo is faster, but usually the speed advantage is negligible, and might not be there for future versions of PHP.
printf is a function, not a construct, and allows such advantages as formatted output, but it’s the slowest way to print out data out of echo, print and printf.

Download usersonline script

2009-12-05T18:32:00.000+05:30

Download usersonline script

Download phpaffiliate script

2009-12-05T18:30:00.001+05:30

Download phpaffiliate script

Download Hitcounter script

2009-12-05T18:21:00.000+05:30

Download Hit counter Script

Download Guest book script

2009-12-05T18:09:00.001+05:30

Download Guest book script

Download greetings cards cript

2009-12-05T18:04:00.001+05:30

Download greetings Card

Download downloadcounter script

2009-12-05T17:58:00.001+05:30

Download downloadcounter Script

Download dating script

2009-12-05T17:57:00.000+05:30

Download dating script

Download classifieds script

2009-12-05T17:55:00.001+05:30

Download classifieds script

Download calendar script

2009-12-05T17:52:00.001+05:30

Download calender script

Download bookmarks script

2009-12-05T17:50:00.000+05:30

Download Bookmarks Script

Download adrotator script

2009-12-05T17:46:00.000+05:30

Download Adrotator Script

Download Oscommerce script

2009-12-05T17:43:00.000+05:30

Download Oscommerce Script

Explain the difference between FLOAT, DOUBLE and REAL

2009-12-05T17:38:00.002+05:30

FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.

Explain the difference between BOOL, TINYINT and BIT.

2009-12-05T17:38:00.000+05:30

Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.

What does myisamchk do?

2009-12-05T17:37:00.002+05:30

It compressed the MyISAM tables, which reduces their disk usage.

Explain the difference between MyISAM Static and MyISAM Dynamic

2009-12-05T17:37:00.000+05:30

MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.

How can we know the number of days between two given dates using MySQL?

2009-12-05T17:06:00.001+05:30

SELECT DATEDIFF('2007-03-07','2005-01-01');

Learn PHP - PHP Tutorials - PHP Interview Questions and Answers - PHP with MySQL Tutorials

Display custom text in wordpress

Display a thumbnail from a Youtube using a shortcode

Automatically remove p tags on images in wordpress

Login form shortcode for WordPress

Retrieve a remote page using WordPress

Display your latest Google+ update on WordPress

Display a thumbnail of any website in wordpress

Display Custom Fields Outside Loop in WordPress

Wordpress Tricks

A Custom Read More in Wordpress

Detect visitor browser within WordPress

Display Twitter-like “time ago” on WP

How to modify size of embedded videos

Display wordpress post titles with a custom length

Set a maximum word count on post title

How to remove WordPress admin bar from front end

How to replace words in your wordpress posts

How to increase WordPress memory limit

Set An Expiration Time For Wordpress Posts

How to make capital letters with CSS style

What is Type Juggling in php

What are the functions for IMAP?

What are the database space-saving functions available in php ?

How can we save an image from a remote web server to my web server using PHP?

Is Single Quotes better then double quotes

How To Protect Special Characters in Query String?

Advantages and disadvantages of CASCADE STYLE SHEETS?

How To Read the Entire File into a Single String?

Hide .php extension or Hide PHP Usage using .htaccess

Send html mail with PHP

How to Ignore User Abort ?

How to show PHP credits?.

Create an image on the fly with the GD library

How to Save bandwidth

What is CAPTCHA?

What are the advantages of stored procedures, triggers, indexes?

How to Extract Domain name from URL ?

How to Unlink all files and folder in a particular folder?

What is Crawler and Indexer

Difference between section and foreach loop in Smarty

Array Functions : How to insert an element or remove an element from an array

Import mysql data to excel

Calculate Visitor Counter

Difference between Split and Explode

Port Numbers

If we login more than one browser windows at the same time with same user and after that we close one window, then is the session is exist to other windows or not? And if yes then why? If no then why?

What are the different functions in sorting an array?

How many ways we can pass the variable through the navigation between the pages?

Sql injection

How do I find out the number of parameters passed into function?

What's the difference between accessing a class method via -> and via ::?

Are objects passed by value or by reference?

How do you call a constructor for a parent class?

What’s the special meaning of __sleep and __wakeup?

Explain the differences echo, print and printf ?

What's the output of the ucwords function in this example?

What’s the difference between htmlentities() and htmlspecialchars()?

What’s the difference between md5(), crc32() and sha1() crypto on PHP?

So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()?

Write a simple program to get a row of information from a database?

How do you remove the last letter from a string?

What do you need to use the image functions in PHP?

What can be possible advantages/disadvantages of page caching? How can you prevent caching of a certain page (please give several alternate solutions)?

What changes I have to do in php.ini file for file uploading?

How can I set a cron and how can I execute it in Unix, Linux, and windows?

What type of headers have to be added in the mail function to attach a file?

What is the difference between Reply-to and Return-path in the headers of a mail function?

How to store the uploaded file to the final location?

jQuery's features break down accross eight major categories

What is jQuery?

Download watermark script

Public, Protected, and Private Properties

Constructors and Destructors

Static modifier use in php

Setters and Getters in Access Modifiers

Access Modifiers

Understanding Class Inheritance

Would you initialize your strings with single quotes or double quotes?

What’s the special meaning of __sleep and __wakeup?

What’s the special meaning of sleep and wakeup?

What’s the special meaning of sleep and wakeup?