Developers' Island

Calender in PHP

2009-06-04T05:03:00.000-07:00

# PHP Calendar : written by Sumit Joshi

function generate_calendar($year, $month, $days = array(), $day_name_length = 3, $month_href = NULL, $first_day = 0, $pn = array())
{
$first_of_month = gmmktime(0,0,0,$month,1,$year);
#remember that mktime will automatically correct if invalid dates are entered
#for instance, mktime(0,0,0,12,32,1997) will be the date for Jan 1, 1998
# this provides a built in "rounding" feature to generate_calendar()

$day_names = array();
#generate all the day names according to the current locale
for($n=0,$t=(3+$first_day)*86400; $n<7; $n++,$t+=86400)
#January 4, 1970 was a Sunday
$day_names[$n] = ucfirst(gmstrftime('%A',$t)); #%A means full textual day name

list($month, $year, $month_name, $weekday) = explode(',',gmstrftime('%m,%Y,%B,%w',$first_of_month));
$weekday = ($weekday + 7 - $first_day) % 7;
#adjust for $first_day
$title = htmlentities(ucfirst($month_name)).' '.$year;
#note that some locales don't capitalize month and day names

#Begin calendar. Uses a real .
@list($p, $pl) = each($pn); @list($n, $nl) = each($pn);
#previous and next links, if applicable
if($p)
$p = ''.($pl ? ' href="'.htmlspecialchars($pl).'">'.$p.'' : $p).' ';
if($n)
$n = ' '.($nl ? ' href="'.htmlspecialchars($nl).'">'.$n.'' : $n).'';
$calendar = ''."\n".
'\n";

if($day_name_length)
{
#if the day names should be shown ($day_name_length > 0)
#if day_name_length is >3, the full name of the day will be printed
foreach($day_names as $d)
$calendar .= '';
$calendar .= "\n";
}

if($weekday > 0)
$calendar .= ''; #initial 'empty' days
for($day=1,$days_in_month=gmdate('t',$first_of_month); $day<=$days_in_month; $day++,$weekday++)
{
if($weekday == 7)
{
$weekday = 0; #start a new week
$calendar .= "\n";
}
if(isset($days[$day]) and is_array($days[$day]))
{
@list($link, $classes, $content) = $days[$day];
if(is_null($content))
$content = $day;
$calendar .= '' :
'>').
($link ? ''.$content.'' :
$content).'';
}
else
$calendar .= "";
}
if($weekday != 7)
$calendar .= '';
#remaining "empty" days
return $calendar."\n

'.$p.($month_href ? ''.$title.'' : $title).$n."
'.htmlentities($day_name_length < 4 ?substr($d,0,$day_name_length) : $d).'

$day

\n";
}
?>

Search Engine Optimization(Friendly) PHP Script

2009-06-04T04:49:00.000-07:00

PHP pages have a reputation of being more difficult (or at least different) to SEO than static HTML pages. Here?s an overview of the major issues encountered when trying to optimize PHP script for search engines. While this focuses on PHP much of it is still relevant to SEO'ing dynamic pages in general.
PHP Speed

While page size does affect load time, spiders run on servers connected to high bandwidth networks, so download time is less important than the latency of the PHP script?s execution time. If a search engine spider follows a link on a site and is forced to wait too long for the server to process the PHP code behind that page, it may label your page as unresponsive.

The biggest delays in a PHP script typically are the database and loop code. Avoid making "SELECT * calls", instead explicitly name all the columns you want to retrieve, and if you are using MySQL, test your queries using the EXPLAIN statement. To optimize loops consider using duplicated code instead of loops that don't repeat very many times, also use as many static values, such as count($array) values inside the loop as you can, generating their values before the loop once.
URL Cleanliness

A major goal in SEO'ing your PHP pages, is to make them look and act like static pages. If you have a large site you can use Apache to fake static looking URLs, or, with a smaller site, you can simply keep your GET variables to a useful minimum. In either case, however, never allow a spider to see links with different URL?s to the same content. If the URL is different, the page should be too.

One of the major problems most webmasters have with getting their dynamic pages to index is URL cleanliness. Since many dynamic pages are created with GET variables, lots of pages have URLs that look like:
Page.php?var=lkdjdfhv&var2=345&var3=kfjdks

Most of the search engines will be able to follow this link, because it has 3 or under get variables (a good rule of thumb is to keep the number of GET variables passed in the URL to under 3), but any more than 3 variables and you will run into problems. Try using less GET variables, and make them more relevant, rather that useless id numbers use titles, and other keyword rich bits of text.
This is an example of a better URL:
Page.php?var=category&var2=topic

If the page requires more variables you may want to consider combining the variables by delimiting them with a hyphen or another unused character, and then splitting the variable in the target page.
Disabling Trans_sid

Possibly the biggest cause of webmaster frustration when SEO?ing php pages is PHP?s tendency to add session id numbers to links if cookies are rejected by the browser (Search engine spiders reject cookies). This will happen by default if your PHP installation was compiled with the ?enable-trans-sid option (and this is the default from version 4.2 onward), and it creates links with an additional, long nonsense looking GET variable.
In addition to making the links clunky this gives spiders different URLs with the same content, which makes them less likely to treat the pages individually, and possibly not even index them at all. A quick way to fix this is to disable the trans-id feature, if you have access, in php.ini by setting ?session.use_trans_sid? to false. If you don?t have access to change php.ini you can add this line to the .htaccess file in your root directory:
php_flag session.use_trans_sid off
Masking dymamic URLs

However the mere presence of a question mark in the URL will introduce a delay in google?s indexing of the page. This from Mike Grehan?s Interview with Daniel Dulitz of Google:

?So the mere presence of a question mark in the URL doesn't throw us for a loop at all. We will crawl those pages more slowly than we do with pages without question marks in the URL. Purely because they've identified themselves as being dynamic and we certainly don't want to bring anyone's site down because we're hitting the database too hard.?

Small sites will not need to worry much about this delay as it means your server is hit every few minutes, not a few times a second, but for larger sites this can slow down your site?s inclusion into the index.
Making dynamic pages look static without mod_rewrite

A way to mask bulky dynamic page URLs (and avoid the question mark delay) is Apache?s ForceType in combination with a PHP command to interpret URLs like: www.example.com/books/computers.html as referring to a page called ?books? which is executed as a PHP script (I usually make a link on the linux server from ?books.php? to ?book? to make editing the script easier). The function will return an array of the additional values, including the category ?computers?. This can be accomplished by inserting a line like this into the .htaccess file in the root of your web documents directory:
ForceType application/x-httpd-php

*Directory Handle Name Here* should be replaced with the alias name you are giving to the fake directory you are creating. In this example:
www.example.com/books/computers.html

your .htaccess line would look like this:
ForceType application/x-httpd-php

You can then log into your server and create a link to the file ?books? or whatever directory alias you have choosen. This is done with the linux command "ln", or link, like this:
$ Ln books.php books

This creates a link between the existing PHP script books.php and the non-existant ?books?. This way all requests for the directory "books" will be given to books.php, ie www.example.com/books/computers.html would be handled by books.php

Inside books.php you can use this function (available here) to extract values from the static-looking request URI?s:

function processURI()
{
$request = explode("/",$_SERVER["REQUEST_URI"]);
$count = count($request);
for ($i = 1 ; $i < $count ; $i++) {
$values["arg".$i] = $request[$i];
}
return $values;
}
?>
1

So the above example of: www.example.com/books/computer.html would be processed like this:

$vals = processURI();
$_GET[$vals[1]] = str_replace(".html", "", $vals[2]);
?>
1

With this, $_GET['books'] would equal "computer" similar to www.example.com/index.php?books=computer
PHP?s SEO Advantages

A great advantage to using dynamic pages as opposed to static pages is the ability to create content that is constantly changing and updated in real time. RSS headlines, randomly circulating content and other automatically ?fresh? content can boost your ranks in Google, and many other engines.

Another advantage to using PHP is that you can make simple modifications to many scripts to create relevant and fresh page titles. Since this is the most important on page factor in SEO special attention should be given to creating title tags that accurately reflect the page?s current content. Any html templates or used in PHP pages can be altered to contain this line:

With this, $page_title can be set to a keyword rich test describing the page. Title text is also important in improving the click-through from SERP?s, so be sure that the title tags doesn?t read like spam, but more like a human created title.

You can contact me at macrosoftsolutions@ymail.com
Also see our website http://www.themacrosoft.com

PHP Login Page with Entryption

2009-06-04T04:36:00.000-07:00

One of the most popular uses of PHP is to secure acess to various portions of a website based on a user's login name and password. This is a failry simple thing to do and in this tutorial I will show you how to construct a PHP login form using the functions in PHP.

The first step to building a simple user authentication system is to create the table in your database that stores the login information. In this script we use one mysql table called"'logins", and the login name and password fields are stored in a hashed (md5) and encrypted state for security reasons. The function that issues the SQL command to create this table looks like this:
function MakeTableLogins($database, $host, $db_user, $db_pass)
{
//create the logins table
$linkID = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($database, $linkID);
mysql_query("create table logins (user char(32), pasword char(32))", $linkID);
}

This should be called by passing the name of the database, database server host and the username password for that database server.

We only use one way encryption because our script never needs to know the actual plaintext of the username or password, its only must decide if the supplied information matches the information from the table. This is done by performing the same hash/encrypt routine on the inputted data and then comparing those values to the database. The function this script uses to return the encrypted data looks like this:

function Encrypt($string)
{
//hash then encrypt a string
$crypted = crypt(md5($string), md5($string));
return $crypted;
}

The next thing our script will have to be able to do is to add the requried users records to the table. We cannot do this by hand because the data is encrypted so there is a function that handles this also:

function AddUser($database, $host, $db_user, $db_pass, $username, $password)
{
//add user to table logins
$linkID = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($database, $linkID);
$password = encrypt($password);
$username = encrypt($username);
mysql_query("insert into logins values ('$username', '$password')", $linkID);
}

The next and final piece to our script is the actual login function. This function is passed arguments of the database login information, and the username and password the user supplied. The function returns true if the user information matches the data in the table exactly and false if they do no match.

function Login($database, $host, $db_user, $db_pass, $user, $password)
{
//attempt to login false if invalid true if correct
$auth = false;
$user = Encrypt($user);

$linkID = mysql_connect($host, $db_user, $db_pass);
mysql_select_db("$database", $linkID);
$result = mysql_query("select password from logins where user = '$user'", $linkID);
$pass = mysql_fetch_row($result);
mysql_close($linkID);

if ($pass[0] === (Encrypt($password)))
{
$auth = true;
}
return $auth;
}

Encryption and Decryption function in PHP

2009-05-28T07:40:00.001-07:00

/*
Description : A function with a very simple but powerful xor method to encrypt
and/or decrypt a string with an unknown key. Implicitly the key is
defined by the string itself in a character by character way.
There are 4 items to compose the unknown key for the character
in the algorithm
1.- The ascii code of every character of the string itself
2.- The position in the string of the character to encrypt
3.- The length of the string that include the character
4.- Any special formula added by the programmer to the algorithm
to calculate the key to use
*/
FUNCTION ENCRYPT_DECRYPT($Str_Message)
{
//Function : encrypt/decrypt a string message v.1.0 without a known key
//Author : Sumit Joshi
//Email : joshisumitnet@yahoo.com
//Date : 28-May-2009
$Len_Str_Message=STRLEN($Str_Message);
$Str_Encrypted_Message="";
FOR ($Position = 0;$Position<$Len_Str_Message;$Position++)
{
// long code of the function to explain the algoritm
//this function can be tailored by the programmer modifyng the formula
//to calculate the key to use for every character in the string.
$Key_To_Use = (($Len_Str_Message+$Position)+1); // (+5 or *3 or ^2)
//after that we need a module division because can´t be greater than 255
$Key_To_Use = (255+$Key_To_Use) % 255;
$Byte_To_Be_Encrypted = SUBSTR($Str_Message, $Position, 1);
$Ascii_Num_Byte_To_Encrypt = ORD($Byte_To_Be_Encrypted);
$Xored_Byte = $Ascii_Num_Byte_To_Encrypt ^ $Key_To_Use; //xor operation
$Encrypted_Byte = CHR($Xored_Byte);
$Str_Encrypted_Message .= $Encrypted_Byte;

//short code of the function once explained
//$str_encrypted_message .= chr((ord(substr($str_message, $position, 1))) ^ ((255+(($len_str_message+$position)+1)) % 255));
}
RETURN $Str_Encrypted_Message;
}
//end function

//Usage of above function

$Str_Test="This is a sample text which shows an Encryped and Decrypted code.";
ECHO $Str_Test."
";
$Str_Test2 = ENCRYPT_DECRYPT($Str_Test);
ECHO $Str_Test2."

";
$Str_Test3 = ENCRYPT_DECRYPT($Str_Test2);
ECHO "
".$Str_Test3."
";
?>

Convert Digits to Word in C#.NET 2008

2009-05-28T02:33:00.000-07:00

//This methos converts Digits to Words
//Implementation is to just copy this method and use it.
//Pass any number and will get string in return.
//Example: 120345
//Output is :One Lac(s) Twenty Thousands Fourty Five Only

private string DigitToWord(long n)
{
string[] list = new string[] { "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Ninteen", "Twenty", "Thirty", "Fourty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninty" };
string[] pos = new string[] { "Arab", "Crore", "Lac(s)", "Thousand", "Hundred" };
int[] arr = new int[10];
int i = 0, j, k, count, opt = 1;
string strWord = "";
count = 0;
if (n == 0)
strWord = "zero";
else
{
j = 0;
while (n != 0)
{
arr[j] = (int)n % 10;
n = n / 10;
count++;
j++;
}
for (i = count - 1; i >= 0; i--)
{
k = (9 - i) / 2;
j = arr[i];
if (j == 0)
continue;
else
{
if (i > 2)
{
if (i % 2 != 0)
{
strWord += " " + list[j - 1];
strWord += " " + pos[k];
}
if (i % 2 == 0)
{
if (j < 2)
arr[i - 1] = (j * 10) + arr[i - 1];
else if (j != 1)
strWord += " " + list[17 + j];
}
}
else
{
if (i == 2)
strWord += " " + list[j - 1] + " hundred ";
else if (i == 1)
{
if (j == 1)
arr[i - 1] = (j * 10) + arr[i - 1];
else if (j != 1)
strWord += " " + list[17 + j];
}
else if (i == 0)
strWord += " " + list[j - 1];
}
}
}
}
return (strWord + " Only");
}
//End of Method