Stored procedure in MYSQL PHP / MYSQLi

Before proceeding with stored procedure, just confirm whether your server is having all the enough latest versions, please check with MYSQL for the same

While trying i found MYSQLi works well when compared to MYSQL.

Know the status of your email in php

This is my requesting php file

This is my response php file

CRON Path and settings in server

@minute - * * * * *


And paths that you need to try

/web/cgi-bin/php5 "$HOME/html/public_html/my.php"

php /home/*******/public_html/my.php

/home/*******/public_html

/web/cgi-bin/php5 -q /home/*******/public_html/my.php

/web/cgi-bin/php5 -q /home/*******/public_html/my.php

/web/cgi-bin/php5 $HOME/html/home/*******/public_html/html/my.php

/web/cgi-bin/php5 “$HOME/*******/public_html/my.php?

------------------------------------------------------------------------------
/usr/bin/php /home/*******/public_html/my.php
-----------------------------------------------------------------------------

Creating multiple like in a dynamic php page

Creating multiple like in a dynamic php page

1) Create the FB like code

2) Two formats

<.script src="http://connect.facebook.net/en_US/all.js#xfbml=1"><.fb:like href="http://*****/fb_like.php" show_faces="true" width="450" font="verdana">

<.iframe src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2F*******%2F******%2Ffb_like.php&layout=standard&show_faces=true&width=450&action=like&font=verdana&colorscheme=light&height=80" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:450px; height:80px;" allowTransparency="true">

3) I just used the first method

<.script src="http://connect.facebook.net/en_US/all.js#xfbml=1">

<.fb:like href="http://*****/fb_like.php?id=1" show_faces="true" width="450" font="verdana">

<.fb:like href="http://*****/fb_like.php?id=2" show_faces="true" width="450" font="verdana">

<.fb:like href="http://*****/fb_like.php?id=3" show_faces="true" width="450" font="verdana">

<.fb:like href="http://*****/fb_like.php?id=4" show_faces="true" width="450" font="verdana">



=========================

the above one is a XFBML (script code) that is non iframe code

group by order by

select * from ".DB_table." Where id IS NOT NULL GROUP BY blog_date ORDER BY id DESC

Add Search form in wordpress

have the code where ever you want

<...........form method='get' id='searchform' action='<.....?php bloginfo('home'); ........?..>/'>
<......div>
<........input type='text' size='18' value=' ' name='s' id='s' />
<.....input type='submit' id='searchsubmit' value='Search' class='btn' />
<....../div>

Wordpress add small description in the index page or the page you want to show

This is the function in your template function.php

if(!function_exists('getPageContent'))
{
function getPageContent($pageId,$max_char)
{
if(!is_numeric($pageId))
{
return;
}
global $wpdb;
$nsquery = 'SELECT DISTINCT * FROM ' . $wpdb->posts .
' WHERE ' . $wpdb->posts . '.ID=' . $pageId;
$post_data = $wpdb->get_results($nsquery);
if(!empty($post_data))
{
foreach($post_data as $post)
{
$text_out=nl2br($post->post_content);
$text_out=str_replace(']]>', ']]>', $text_out);
$text_out = strip_tags($text_out);
return substr($text_out,0,$max_char);

}
}
}
}


and just have the code where ever you want to have

<....?php echo getPageContent(39,65); .....?>
39 is the page ID

and 65 is the character set