CodeKeep PHP Feed

PHP

Mon, 21 May 2012 22:04:48 GMT

Description: php codes

Link: http://www.codekeep.net/snippets/dec8c6d5-65eb-463b-a4b3-d064d3209269.aspx

<?php
phpinfo();

Get Remote IP Address in PHP

Sat, 19 May 2012 20:47:06 GMT

Description: This code allows to get the IP address from which the user is viewing the current page.

Link: http://www.codekeep.net/snippets/155acde2-b3e5-4a2e-85ff-6de51905fbdd.aspx

<?php          
function getRemoteIPAddress(){
    $ip = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : '';
    return $ip;
}
 
/* If your visitor comes from proxy server you have use another function
to get a real IP address: */
function getRealIPAddress(){   
    if(!empty($_SERVER['HTTP_CLIENT_IP'])){
        //check ip from share internet
        $ip = $_SERVER['HTTP_CLIENT_IP'];
    }else if(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){
        //to check ip is pass from proxy
        $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
    }else{
        $ip = $_SERVER['REMOTE_ADDR'];
    }
    return $ip;
}
?>

Import a CSV File to MySQL via phpMyAdmin

Mon, 23 Apr 2012 16:37:00 GMT

Description: According to the request the task was to import a CSV file to MySQL DB.

Link: http://www.codekeep.net/snippets/d98f522d-7e3c-45e9-94c1-8dbf0e8ff0e4.aspx

So for that first, I went to the the main phpMyAdmin page. 


Next, I clicked on the database instance that I am interested. Then, I click on the table that I want to import my data and click on Import button. 


On the import form, I click Browse button to choose the CSV file on my local hard drive. Since my CSV file uses "|" to separate each fields and "\n" to separate each records, I chose the following options: 

Choose CSV using LOAD DATA 

Fields terminated by : ,
Fields enclosed by : [remove default value and leave it blank]
Fields escaped by : [remove default value and leave it blank]

Leave everything else to default value.

Finally, I clicked the Go button. This resulted the following SQL query. 


Note, I renamed values that are specific to my environment. So this is just for your reference only.

Below is the query that you will get : 

LOAD DATA LOCAL INFILE 'input_file' INTO TABLE `tablename` FIELDS TERMINATED BY ',' LINES TERMINATED

CompCalc

Tue, 07 Feb 2012 14:26:23 GMT

Description: This class calculates compounded interest on investment, saving or loan. It allows variable compounding (reinvesting) percentage Here's a page where you can see the class used: http://sharkinvestor.com/investment-calculator/

Link: http://www.codekeep.net/snippets/a697f2b5-d1fb-4c40-b376-08a66919dc73.aspx

<?php
/* This class calculates compounded interest on investment, saving or loan. 
 It allows variable compounding (reinvesting) percentage 
 To do: add different types of loan calculations. 
 Will be useful for all kind of financial calculators and apps. 
 Here's a page where you can see the class used: http://sharkinvestor.com/investment-calculator/ */
class CompCalc
{
	// calculates compounded investment
	// $num_periods - required, number of compounding periods (usually years or months)
	// $investment - required, the initial investment amount
	// $interest - required, interest in % for each period
	// $reinvest_percentage - optional, now much from the return is reinvested
	// $addition_per_period - optional, additional investment made in each period
	// @returns array of arrays - one array for each period:
	// [period, principal value, amount withdrawn so far, total return so far, total ROI]
	// the results should be read as "at the end of period X"
	function inv_calculate($num_periods, $investment, $interest, 
		$reinvest_percentage=100, $addition_per_period=0)
	{
		// validate
		if($num_periods<=0) throw new Exception("Periods should be at least 1");
		if($investment<=0) throw new Exception("Investment amount should be bigger than 0");
		if(!is_numeric($interest)) throw new Exception("Interest should be a number");
		if(!is_numeric($reinvest_percentage)) throw new Exception("Reinvest % should be a number");
		if(!is_numeric($addition_per_period)) throw new Exception("Addition should be a number");
		
		// convert interest and reinvest_percentage to decimal numbers
		$roi=$interest/100; 
		$cp=$reinvest_percentage/100;
		
		// Start the calculations
		
		// STEP 1 & 2:
		// 1. When the user input specific number of periods, you just go thru them
		// 2. for each period calculate: Profit = Principal (Invested amount) X (ROI / 100)		
		$total_withdrawn=0;
		$results=array();		
		
		for($i = 1 ; $i < ($num_periods+1) ; $i++ )
		{
			$new_principal=!empty($new_principal)?$new_principal:$investment;
			$new_principal=round($new_principal,2);
									
			$profit = $new_principal * $roi;		
			$profit=round($profit,2);
			
			// STEP 3:
			// 3. Then substract the withdrawn amount. 
			// This amount is: Withdrawn = Profit X (compounding percentage / 100)
			$addition = $profit * $cp;
		 	$withdraw=round(($profit-$addition),2);	
		 	
		 	// totoal return
			$total_withdrawn+=$withdraw;
			
			// total ROI
			$total_roi=($total_withdrawn/$investment)*100;
			$total_roi=round($total_roi);
        
        	$new_principal=$new_principal+$addition;
        
        	// period adddition
        	$investment+=$addition_per_period;
        	$new_principal+=$addition_per_period;
			
			$result=array("period"=>$i, "investment_value"=>$new_principal, 
				"return_for_the_period"=>$withdraw, "total_return"=>$total_withdrawn,
				"total_roi"=>$total_roi);
			$results[]=$result;	
		}
		
		return $results;
	}
}
?>

Dum snippets

Sat, 12 Nov 2011 05:24:06 GMT

Description: Test dummy

Link: http://www.codekeep.net/snippets/dfdefc4a-6d02-487b-8c99-7522bf534fd8.aspx

public function testdummy ( $value=\'\' ) {
/*** Description ***/
	# code...
}

Customize WordPress login logo without a plugin

Sun, 09 Oct 2011 07:31:36 GMT

Description: Customize WordPress login logo without a plugin

Link: http://www.codekeep.net/snippets/25919b01-1417-4609-9f11-31345711568e.aspx

function my_custom_login_logo() {
    echo '<style type="text/css">
        h1 a { background-image:url('.get_bloginfo('template_directory').'/images/custom-login-logo.gif) !important; }
    </style>';
}

add_action('login_head', 'my_custom_login_logo');

Custom Excerpt Length

Sun, 09 Oct 2011 07:27:12 GMT

Description: Custom Excerpt Length

Link: http://www.codekeep.net/snippets/c5364ce1-6e68-4df9-af28-1ac921459d6c.aspx

function new_excerpt_length($length) {
return 100;
}
add_filter('excerpt_length', 'new_excerpt_length');

Register Sidebar Widgets

Sun, 09 Oct 2011 07:26:14 GMT

Description: Register Sidebar Widgets

Link: http://www.codekeep.net/snippets/9ce2835c-8163-49a9-9ee3-d8747b81cff3.aspx

if ( function_exists('register_sidebar') )
register_sidebar(array('name'=>'MiddleSidebar',
'before_widget' => '<li class="widget">',
'after_widget' => '</li>',
'before_title' => '<h2 class="widgettitle">',
'after_title' => '</h3>',
));
register_sidebar(array('name'=>'FooterSidebar',
'before_widget' => '<li class="widget">',
'after_widget' => '</li>',
'before_title' => '<h2 class="widgettitle">',
'after_title' => '</h3>',
));

Register Sidebar Widgets

Sun, 09 Oct 2011 07:25:02 GMT

Description: Register Sidebar Widgets

Link: http://www.codekeep.net/snippets/a0fff1da-99e4-4ba3-85c7-ec7d3780f80b.aspx

if ( function_exists('register_sidebar') )
register_sidebar(array('name'=>'MiddleSidebar',
'before_widget' => '<li class="widget">',
'after_widget' => '</li>',
'before_title' => '<h2 class="widgettitle">',
'after_title' => '</h3>',
));
register_sidebar(array('name'=>'FooterSidebar',
'before_widget' => '<li class="widget">',
'after_widget' => '</li>',
'before_title' => '<h2 class="widgettitle">',
'after_title' => '</h3>',
));

Add Custom Dashboard Widgets in WordPress

Sun, 09 Oct 2011 07:23:32 GMT

Description: Add Custom Dashboard Widgets in WordPress

Link: http://www.codekeep.net/snippets/69e7f642-6ff1-4a3d-a791-1abf402a679f.aspx

add_action('wp_dashboard_setup', 'my_custom_dashboard_widgets');

function my_custom_dashboard_widgets() {
global $wp_meta_boxes;

wp_add_dashboard_widget('custom_help_widget', 'Theme Support', 'custom_dashboard_help');
}

function custom_dashboard_help() {
echo '<p>Welcome to Custom Blog Theme! Need help? Contact the developer <a href="mailto:yourusername@gmail.com">here</a>. For WordPress Tutorials visit: <a href="http://www.wpbeginner.com" target="_blank">WPBeginner</a></p>';
}

Change the Footer in WordPress Admin Panel

Sun, 09 Oct 2011 07:23:01 GMT

Description: Change the Footer in WordPress Admin Panel

Link: http://www.codekeep.net/snippets/a602014e-47ca-4f02-ab71-88b9b182fd29.aspx

function remove_footer_admin () {
echo 'Fueled by <a href="http://www.wordpress.org" target="_blank">WordPress</a> | Designed by <a href="http://www.uzzz.net" target="_blank">Uzzz Productions</a> | WordPress Tutorials: <a href="http://www.wpbeginner.com" target="_blank">WPBeginner</a></p>';
}

add_filter('admin_footer_text', 'remove_footer_admin');

Add a Custom Dashboard Logo

Sun, 09 Oct 2011 07:22:16 GMT

Description: Add a Custom Dashboard Logo

Link: http://www.codekeep.net/snippets/cd302fb2-c7a2-4c98-b3f8-7162c338943e.aspx

//hook the administrative header output
add_action('admin_head', 'my_custom_logo');

function my_custom_logo() {
echo '
<style type="text/css">
#header-logo { background-image: url('.get_bloginfo('template_directory').'/images/custom-logo.gif) !important; }
</style>
';
}

Remove WordPress Version Number

Sun, 09 Oct 2011 07:21:39 GMT

Description: Remove WordPress Version Number

Link: http://www.codekeep.net/snippets/55726987-b821-4793-b3d0-aaa3c75fce57.aspx

function wpbeginner_remove_version() {
return '';
}
add_filter('the_generator', 'wpbeginner_remove_version');

Display any Number of Posts in a Loop

Sun, 09 Oct 2011 07:16:53 GMT

Description: Display any Number of Posts in a Loop

Link: http://www.codekeep.net/snippets/17ac6490-ea67-41b2-a0f6-5c9bc4a32fd8.aspx

// if everything is in place and ready, let's start the loop

// to display 'n' number of posts, we need to execute the loop 'n' number of times
// so we define a numerical variable called '$count' and set its value to zero
// with each iteration of the loop, the value of '$count' will increase by one
// after the value of '$count' reaches the specified number, the loop will stop
// *USER: change the 'n' to the number of posts that you would like to display

if ($count == "n") { break; }
else { ?>

// for CSS styling and layout purposes, we wrap the post content in a div
// we then display the entire post content via the 'the_content()' function
// *USER: change to '' to display post excerpts instead

// here, we continue with the limiting of the number of displayed posts
// each iteration of the loop increases the value of '$count' by one
// the final two lines complete the loop and close the if statement

How to Display any External RSS Feed on Your Site

Sun, 09 Oct 2011 07:15:36 GMT

Description: How to Display any External RSS Feed on Your Site

Link: http://www.codekeep.net/snippets/788773b1-3703-41e4-acd5-ee9363e5011d.aspx

<?php include_once(ABSPATH.WPINC.'/feed.php');
$rss = fetch_feed('http://feeds.feedburner.com/wpbeginner');
$maxitems = $rss->get_item_quantity(5);
$rss_items = $rss->get_items(0, $maxitems);
?>
<ul>
<?php if ($maxitems == 0) echo '<li>No items.</li>';
else
// Loop through each feed item and display each item as a hyperlink.
foreach ( $rss_items as $item ) : ?>
<li>
<a href='<?php echo $item->get_permalink(); ?>'
title='<?php echo 'Posted '.$item->get_date('j F Y | g:i a'); ?>'>
<?php echo $item->get_title(); ?></a>
</li>
<?php endforeach; ?>
</ul>

DBO snippets

Thu, 15 Sep 2011 11:55:51 GMT

Description: DBObject Class

Link: http://www.codekeep.net/snippets/6e63a810-18d3-4abc-96d0-8a05be3cb856.aspx

/* WORKS IN PHP5 ONLY */

class DBObject
{
private $id;
private $id_field;
private $table_name;
private $fields = array();

function __construct($table_name, $id_field, $fields)
{
$this->table_name = $table_name;
$this->id_field = $id_field;

foreach($fields as $key)
$this->fields[$key] = null;
}

function __get($key)
{
return $this->fields[$key];
}

function __set($key, $value)
{
if(array_key_exists($key, $this->fields))
{
$this->fields[$key] = $value;
return true;
}
return false;
}

function select($id)
{
global $db;

$db->query("SELECT * FROM " . $this->table_name . " WHERE " . $this->id_field . " = '$id'");
if(mysql_num_rows($db->result) == 0)
return false;
else
{
$this->id = $id;
$row = mysql_fetch_array($db->result, MYSQL_ASSOC);
foreach($row as $key => $val)
$this->fields[$key] = $val;
}
}

function insert()
{
global $db;

unset($this->fields[$this->id_field]);
$fields = join(", ", array_keys($this->fields));
$values = "'" . join("', '", $this->fields) . "'";

$db->query("INSERT INTO " . $this->table_name . " ($fields) VALUES ($values)");

$this->id = mysql_insert_id($db->db);
return $this->id;
}

function update()
{
global $db;

unset($this->fields[$this->id_field]);
$arrStuff = array();
foreach($this->fields as $key => $val)
$arrStuff[] = "$key = '$val'";
$stuff = implode(", ", $arrStuff);

$db->query("UPDATE " . $this->table_name . " SET $stuff WHERE " . $this->id_field . " = '" . $this->id . "'");
return mysql_affected_rows($db->db); // Not always correct due to mysql update bug/feature
}

function delete()
{
global $db;
$db->query("DELETE FROM " . $this->table_name . " WHERE " . $this->id_field . " = '" . $this->id . "'");
return mysql_affected_rows($db->db);
}

function empty_table()
{
global $db;
$db->query("DELETE FROM " . $this->table_name);
}
}

//
// 	class Person extends DBObject
// 	{
// 		function __construct()
// 		{
// 			parent::__construct('person', 'person_id', array('name', 'eye_color', 'hair_color'));
// 		}
// 	}
//

Soap snippets

Thu, 25 Aug 2011 05:18:57 GMT

Description: Soap Fault

Link: http://www.codekeep.net/snippets/898d9e1b-8002-4928-b61e-b38b3d4b5c79.aspx

$client = new SoapClient("http://services.stage.theignitionnetwork.com/risk/1_1_0/riskservice.asmx?wsdl",array('trace' => 1, 'exceptions' => 0));

  $response =  $client->SubmitEntrant(array('authorizationToken' => $token, 'Optin1' => 0, 'OptIn2' => 0));
  if(is_soap_fault($response)) {
      trigger_error("SOAP Fault: (faultcode: {$result->faultcode}, faultstring: {$result->faultstring})", E_USER_ERROR);
  }

own rss function

Sun, 16 Jan 2011 19:06:39 GMT

Description: own rss function

Link: http://www.codekeep.net/snippets/39a26ffa-4eb8-4b33-8fe0-a48333b9009e.aspx

<?php 

function ownRSS () {

//configuration
   $dbServer = "localhost";  //database server (mostly localhost)
   $dbName = "myDB";         //name of database
   $dbUser = "me";           // user name
   $dbPassword="myPassword"; // user password
   $tableName="myTable";     // name of the table
   $lines="10";              // count of data set
   $filename="myFile";       //without extension
   $title="name of myDomain.net";     //title of rss
   $description="bla bla here ";     //site description
   $language="de";           //country
   $link="http://www.mydomain.net/links.html"; //Link
   $itemTitle="..."; //rowname of the table for the title from the item
   $itemText="...";  //rowname of the table for the description from the item
   $itemLink="...";//rowname of the table for the link from the item

//the SQL-Statement must be customized what u need
   $sql="SELECT * FROM ".$tableName." Where ... ORDER BY ... DESC/ASC LIMIT 0,$lines";
 
  $siteRoot= substr_replace ($_SERVER[DOCUMENT_ROOT].$_SERVER["PHP_SELF"],
              "",strrpos ($_SERVER[DOCUMENT_ROOT].$_SERVER["PHP_SELF"], "/")+1);

//to make the rss content
   $rssHeader="<?xml version="1.0" encoding="ISO-8859-1"?>
              <rss version="0.91">
              <channel>
              <title>".$title."</title>
              <description>".$description."</description>
              <language>".$language."</language>
              <link>$link</link>
              ";
   $rssFooter="</channel>
              </rss>";
   $dbLink = mysql_connect ($dbServer,$dbUser,$dbPassword) or die (mysql_error());
   $setdb = mysql_select_db($dbName,$dbLink) or die (mysql_error());
   $result=mysql_query($sql,$dbLink) or die(mysql_error());
   $content=$rssHeader;
   while($row=mysql_fetch_array($result)){
      $titel=substr ($row[$itemTitle], 0, 150);  
      $text=substr ($row[$itemText], 0, 500); 
      $iLink=($row[$itemLink], 0, 500);   
      $content.="<item>
                <title>".$titel."</title>
                <description>".$text."</description>
                <link>".$iLink."</link>
                </item>
                ";
   }
   $content.=$rssFooter;

//write file
   $fh=fopen ($siteRoot.$filename.".rss", "w");
   fputs ( $fh, $content);
   fclose($fh);

//rename file
   rename ($siteRoot.$filename.".rss", $siteRoot.$filename.".xml");
   return;
}
?>

random picture from directory

Sun, 16 Jan 2011 19:04:57 GMT

Description: random picture from directory

Link: http://www.codekeep.net/snippets/afc60d18-af57-4d9b-a930-fce2c8456aba.aspx

<?php
  $pic_dir = 'mypictures/';
  $counter = 0;

  $d = dir($pic_dir);
  while($entry=$d->read()) {
    if ($entry != "." && $entry != "..") {
      $array[] = $entry;
      $counter++;
    }
  }
  $d->close();
  $counter--;
  $which = rand(0, $counter);
?>

<? echo '<img src="'.$pic_dir.$array[$which].'" title="'.$array[$which].'" alt="'.$array[$which].'" border="0">'; ?>

replace url to link

Sun, 16 Jan 2011 19:02:50 GMT

Description: replace url to link

Link: http://www.codekeep.net/snippets/05343095-e9cd-4ff0-aeeb-b69d9a618ebb.aspx

<?php
    $text = ereg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]", "<a href=\"\\0\">\\0</a>", $text);
?>

random txt from file

Sun, 16 Jan 2011 19:02:10 GMT

Description: random txt from file

Link: http://www.codekeep.net/snippets/531479e4-d9a8-4983-b909-d665bc6aa5b2.aspx

<?php   
    $textfile = "random.txt";   
    $quotes = file("$textfile");   
    $quote = rand(0, sizeof($quotes)-1);   
    echo $quotes[$quote];   
 ?>

wget, unzip and delete a File per Shell via PHP

Sun, 16 Jan 2011 19:01:02 GMT

Description: wget, unzip and delete a File per Shell via PHP

Link: http://www.codekeep.net/snippets/999d8ae1-97cd-4add-bc86-afd9d71592cf.aspx

<?php
    $url = "http://www.url.net/file.zip";
    $file = "file.zip";
    $esc = escapeshellarg($url);
    exec("wget " . $esc);

//use ur extension and remove the //comandlines
    //$shell = "tar -xzvf $file"; //tar
    //$shell = "unzip $file"; //zip

    $shell = escapeshellcmd($shell);
    exec($shell,$nu);

//del file
    $del = "rm $file";
    $del = escapeshellcmd($del);
    exec($del,$nu);
    print_r("done");
?>

referer

Sun, 16 Jan 2011 19:00:27 GMT

Description: referer

Link: http://www.codekeep.net/snippets/63f77540-32e0-468b-bfe6-0f6f4eab081d.aspx

<?php
    echo "Referer:" . $_SERVER["HTTP_REFERER"];
?>

rotate banner

Sun, 16 Jan 2011 18:59:47 GMT

Description: rotate banner

Link: http://www.codekeep.net/snippets/7e25d9dd-cf5c-4880-967e-4f15deedbab5.aspx

<?php
       $ads = array(
       array("Banner" => "<a href=\"http://website1.net\"><img src=\"pic1.jpg\"></a>"),
       array("Banner" => "<a href=\"http://website2.net\"><img src=\"pic2.jpg\"></a>"),
       array("Banner" => "<a href=\"http://website3.net\"><img src=\"pic3.jpg\"></a>")
       );
    srand ((double)microtime()*10000);
       $maxvalue = count($ads)-1;
       $nr = rand(0,$maxvalue);
       echo  $ads[$nr][Banner];
?>

get extension of file

Sun, 16 Jan 2011 18:15:01 GMT

Description: get extension of file

Link: http://www.codekeep.net/snippets/f7e0cd84-7da8-4827-ac31-d7d30af3ef53.aspx

echo substr($filename, strripos($filename, '.'),strlen($filename));