DZone Snippets: php code

running total in PHP

shantanuo (shantanu oak) — Fri, 08 Aug 2008 11:26:51 GMT

// output running total
// userID,posts,runningTotal|
// 2,23434,28330|
// 6,3443,4896|
// 1,422,1453|
// 3,344,1031|
// 4,344,687|
// 5,343,343|



$q = mysql_query("select * from `members` order by `posts` DESC");

echo 'userID,posts,runningTotal|
';

while($a = mysql_fetch_row($q)){

echo "$a[0],$a[1],$total|
";

$total = $total - $a[1];

}

Querystring variables

shantanuo (shantanu oak) — Sat, 05 Jan 2008 07:07:32 GMT



// Add Querystring Variable

// A PHP function that will add the querystring variable $key with a 

// value $value to $url. If $key is already specified within $url, 

// it will replace it.



function add_querystring_var($url, $key, $value) {

$url = preg_replace('/(.*)(\?|&)' . $key . '=[^&]+?(&)(.*)/i', '$1$2$4', $url . '&');

$url = substr($url, 0, -1);

if (strpos($url, '?') === false) {

return ($url . '?' . $key . '=' . $value);

} else {

return ($url . '&' . $key . '=' . $value);

}

}



// Remove Querystring Variable

// A PHP function that will remove the variable $key and its value 

// from the given $url.



function remove_querystring_var($url, $key) {

$url = preg_replace('/(.*)(\?|&)' . $key . '=[^&]+?(&)(.*)/i', '$1$2$4', $url . '&');

$url = substr($url, 0, -1);

return ($url);

}

Unicode words from online dictionary

shantanuo (shantanu oak) — Sun, 28 Oct 2007 08:55:52 GMT

// list words from unicode dictionary
// you need to add this line in the head section
//



for ( $i = 1; $i <= 45; $i++) {

$url="http://dsal.uchicago.edu/cgi-bin/romadict.pl?page=$i&table=molesworth&display=utf8";

$text=file_get_contents($url);

$myarray = preg_match_all('#(.*?)#i', $text, $matches);

echo implode(' ',$matches[1]); 

}

Password Protection

shantanuo (shantanu oak) — Thu, 04 Oct 2007 09:52:00 GMT

// Bare Bones demo of password protection



$password = "abc123";

if ($_POST[doddle] == $password) {

        $tell = 1;

} else {

        $tell = 2;

}

if (! is_string($_POST[doddle])) $tell = 0;

?>



A Page that is password protected





 

The page with all the secrets revealed 

 

This is the information that has been revealed to you because you

got the password right!

Although this is a very simple

demo it shows what you can do with just a few lines of PHP.

 



 

A Header page

 

There is a page hidden under a password at this URL. For this demo only

I will tell you that the password is "abc123" so you can try it out!


YOU GOT THE PASSWORD WRONG
"); ?>






Please enter password 





 



 



Well House Consultants, 2007

tinyurl explode

shantanuo (shantanu oak) — Tue, 02 Oct 2007 08:03:51 GMT

// check where tinyurl.com is headed to



    < ?php



    // tinyurl.php?c=



    $num = $_GET['c'];



    if($fp = fsockopen ("tinyurl.com", 80, $errno, $errstr, 30))

    {

    if ($fp) {

    fputs ($fp, "HEAD /$num HTTP/1.0\r\nHost: tinyurl.com\r\n\r\n");

    while (!feof($fp)) {$headers .= fgets ($fp,128);}

    fclose ($fp);

    }

    $arr1=explode("Location:",$headers);

    $arr=explode("\n",trim($arr1[1]));

    echo trim($arr[0]);

    }

    ?>

Display all files in a directory

shantanuo (shantanu oak) — Sun, 29 Jul 2007 05:52:10 GMT



/**

* Change the path to your folder.

* This must be the full path from the root of your

* web space. If you're not sure what it is, ask your host.

*

* Name this file index.php and place in the directory.

*/

    // Define the full path to your folder from root

    $path = "/home/content/s/h/a/shaileshr21/html/download";

 

    // Open the folder

    $dir_handle = @opendir($path) or die("Unable to open $path");

 

    // Loop through the files

    while ($file = readdir($dir_handle)) {

 

    if($file == "." || $file == ".." || $file == "index.php" )

 

        continue;

        echo "$file
";

 

    }

    // Close

    closedir($dir_handle);

?>

Alternating Row Colors

shantanuo (shantanu oak) — Sun, 08 Jul 2007 14:47:33 GMT

// tutorial from http://www.webreference.com/programming/php_color/



// TEST1: FOR - Control  

for ($k = 0; $k < 10000000; $k++) {  

$class = (1) ? "bg1" : "bg2";  

}  



// TEST2: FOR - Remainder division  

for ($k = 0; $k < 10000000; $k++) {  

$class = ($k % 2 == 1) ?"bg1" : "bg2";  

}  



// TEST3: FOR - Negation  

$b = true;  

for ($k = 0; $k < 10000000; $k++) {  

$class = ($b) ? "bg1" : "bg2";  

$b = !$b;  

}  



// TEST4: WHILE - Control  

$k = 0;  

while ($k < 10000000) {  

$class = (1) ? "bg1" : "bg2";  

$k++;  

}  



// TEST5: WHILE - Remainder division  

$k = 0;  

while ($k < 10000000) {  

$class = ($k % 2 == 1) ?"bg1" : "bg2";  

$k++;  

}  



// TEST6: WHILE - Negation  

$k = 0;  

$b = true;  

while ($k < 10000000) {  

$class = ($b) ? "bg1" : "bg2";  

$b = !$b;  

$k++;  

}  

?>

Validate email and domain

shantanuo (shantanu oak) — Tue, 15 May 2007 07:48:44 GMT

// Vlidate email and domain name





function validate_email($email){



$exp = "^[a-z\'0-9]+([._-][a-z\'0-9]+)*@([a-z0-9]+([._-][a-z0-9]+))+$";



if(eregi($exp,$email)){

	if(checkdnsrr(array_pop(explode("@",$email)),"MX")){

		print("$email is ok.
");

			}else{

			print("$email is ok. But domain is not.
");

			}

				}else{

				print("$email is not ok.
");

				}   

}



validate_email("shantanu.ok");

validate_email("shantanu.ok@gmail.com");

validate_email("shantanu.ok@fsjaldkfjlsfjsljflsfjsldk.com");



?>

FTP to get a file from within PHP

shantanuo (shantanu oak) — Sat, 03 Mar 2007 04:32:08 GMT



$conn_id = ftp_connect("www.yoursite.com");

$login_result = ftp_login($conn_id, "username", "password");



if ((!$conn_id) || (!$login_result)) {

echo "FTP connection has failed!";

exit;

} else {

echo "Connected";

}



// get the file

$local = fopen("local.txt","w");

$result = ftp_fget($conn_id, $local,"httpdocs/trlog.txt", FTP_BINARY);



// check upload status

if (!$result) {

echo "FTP download has failed!";

} else {

echo "Downloaded ";

}



// close the FTP stream

ftp_close($conn_id);

Yubnub "echoshortcut" to display text stored for alias

shantanuo (shantanu oak) — Mon, 07 Nov 2005 19:32:44 GMT

if (!$link = mysql_connect('', '', '')) {
echo 'Could not connect to mysql';
exit;
}

if (!mysql_select_db('yub', $link)) {
echo 'Could not select database';
exit;
}
$sendto1 = mysql_query("select email from yubmail where mail_alias = '$path'");
$sendto2 = mysql_result($sendto1, 0);

if (!$sendto2) {
echo "The alias does not exist! Use the command shortcut to create one.";
exit;
}
echo "$sendto2";
?>