Getphp : a php and MySQL resource site

Random video wordpress shortcode

This is an example of a wordpress shortcode that would display a random video, not very technical as the video embed is hard coded in but nice and basic

<?php
function md_random_video() {
	$videos = array(
		'Video Embed Code Goes Here',
		'Another Video Embed Code Goes Here',
		'So on',
		'So forth'
	);
	$rand_vid = array_rand( $videos );

	echo $videos[$rand_vid];
}

//Shortcode for WordPress only!
add_shortcode( 'randvid', 'md_random_video' );
?>

CSV Parser

<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01//EN” “http://www.w3.org/TR/html4/strict.dtd”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″ />
<title>Data Import</title>
</head>

<body>

<?php

//error_reporting(E_ALL);
//ini_set(“display_errors”, 1);

$databasehost = “xxxxx”;
$databasename = “xxxxx”;
$databasetable = “xxxxxx”;
$databaseusername =”xxxxxx”;
$databasepassword = “xxxxxx”;
$fieldseparator = “\t”;
$lineseparator = “\r”;
$csvfile = “xxxxxx.txt”;
echo “vars set — “;
$addauto = 0;

$save = 0;
$outputfile = “output.sql”;

if(!file_exists($csvfile)) {
echo “File not found. Make sure you specified the correct path.\n”;
exit;
} else {
echo “$csvfile File Exist….<br />”;
}

echo “opening file<br />”;
$file = fopen($csvfile,”r”);

if(!$file) {
echo “Error opening data file.\n”;
die(“oops!”);
} else {
echo “file opened…<br />”;
}

$size = filesize($csvfile);

if(!$size) {
echo “File is empty.\n”;
exit;
} else {
echo “File Size is $size”;
}
echo “about to read…”;

if (!$csvcontent = fread($file,$size)) {

die(“Could Not Read File <br />”);

} else {

echo “File Read <br />”;

}

fclose($file);

if (isset($_GET['import'])) {

//$con = mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
//mysql_select_db($databasename) or die(mysql_error());

$lines = 0;
$queries = “”;
$linearray = array();

foreach(split($lineseparator,$csvcontent) as $line) {

$lines++;

$line = trim($line,” \t”);

$line = str_replace(“\r”,”",$line);

$line = str_replace(“‘”,”\’”,$line);

$line = str_replace(“\”",”",$line);

$linearray = explode($fieldseparator,$line);

$linemysql = implode(“|”,$linearray);
//echo “$linemysql<br /><br />”;
$fields = explode(“|”,$linemysql);
print_r($fields);

echo “<br /><br />”;

$query = “INSERT INTO $databasetable (xxxxxx,xxxxxx,xxxxxx) VALUES (‘$linemysql’);”;

//echo “$query — $lines — <br /><br />”;

//mysql_query($query);

}

} // end if is set GET_

mysql_close($con);

</body>
</html>

Scrape parts of an html page

// Scrape <div id=”scrapeme”> from a webpage
$html = new DOMDocument();
$html->loadHtmlFile(‘http://example.com/scrapepage.html’);

$xpath = new DOMXPath($html);
$items = $xpath->query(“//div[@id='scrapeme']“); // replace with your query

$dom = new DOMDocument;
foreach ($items as $item)
{
$dom->appendChild($dom->importNode($item,true));
}
// Output to screen
echo $dom->saveHTML();

Fopen using CURL

function fopenCurl($url)
{
$result = NULL;

$ch = curl_init();
$options = array
(
CURLOPT_URL => $url,
CURLOPT_HEADER => FALSE,
CURLOPT_RETURNTRANSFER => TRUE,
CURLOPT_FAILONERROR => TRUE
); curl_setopt_array($ch, $options);

$data = curl_exec($ch);
if ($data !== FALSE)
{
$result = $data;
}
curl_close($ch);

return $result;
}

# EOF

Expand googl short urls

function expandUrlGoogl($url)
{
$api_query = “https://www.googleapis.com/urlshortener/v1/url?” .
“shortUrl={$url}”;
return fopenCurl($api_query);
}

Add googlemap to post or page wordpress

// add to functions.php
//Google Maps Shortcode
function fn_googleMaps($atts, $content = null) {
extract(shortcode_atts(array(
“width” => ’640′,
“height” => ’480′,
“src” => ”
), $atts));
return ‘<iframe width=”‘.$width.’” height=”‘.$height.’” frameborder=”0″ scrolling=”no” marginheight=”0″ marginwidth=”0″ src=”‘.$src.’”></iframe>’;
}
add_shortcode(“googlemap”, “fn_googleMaps”);

// add to post/page
[googlemap width="200" height="200" src="[url]“]

Getphp : PHP and MySQL resources

Search:

Categories

Latest

Random video wordpress shortcode

CSV Parser

Scrape parts of an html page

Fopen using CURL

Expand googl short urls

Add googlemap to post or page wordpress

Translator

Tags

Links