DAN FOLKES

Web Service using JSONP from External Domain – PHP – JQuery

Posted by dan in Code, Javascript, PHP, jQuery on February 3, 2012

You may want to look at this previous post where I setup a PHP Webservice that uses JSON PDO – Accessed by JQuery AJAX

OK, so this code will use php to generate the JSON code that will get delivered over the internet to the JSONP (JSON Padding) client on an external domain. This allows your webservice to be available too whoever wants to call it.

Here is the PHP Code: (Not all of it, but enough to get the idea)

//http://SERVER_domain.com/webservice.php
private function GetTriviaTag($row) {
	$t = new Tag();
	$t->id = $row['id'];
	$t->triviaid = $row['triviaid'];
	$t->tagid = $row['tagid'];
	return $t;
}
public function GetWhere($where) {
	$retArray;
 
	$sql = "SELECT * FROM trivia_tags WHERE {$where}";
	foreach ($this->pdo->query($sql) as $row)
	{
		$retArray[] = $this->GetTriviaTag($row);
	}
	return $retArray;
}
$where = " (1 = 1)";  // THIS WILL SELECT ALL
$tarray = GetWhere($where);
 
//OUTPUT JSON:
header('Content-type: application/json');
echo $_GET['callback'];  // <-- THIS IS IMPORTANT FOR EXTERNAL DOMAIN ACCESS!!!
echo "(" . json_encode($tarray) . ")";

And now, to access it from javascript in an external domain (non – SERVER_domain.com ):

http://CLIENT_domain.com/Test.html:

<html>
	<head>
		<title>Test</title>
		<script src="http://code.jquery.com/jquery-latest.js"></script>
	</head>
	<body>
		<div id="triviaQuestions"> loading... </div>
		<script>
			$(function() {
				// THE 'callback=?' in this request is IMPORTANT FOR EXTERNAL DOMAIN ACCESS!!!
				$.getJSON('http://SERVER_domain.com/webservice.php&callback=?', function(data) {
					var items = [];
					var htmlResult = "";
					$.each(data, function(key, val) {
						htmlResult += "<br />Q: "+ val.id +", '"+ val.question +"";
					});
					$('#triviaQuestions').html(htmlResult);
				});
			});
		</script>
	</body>
</html>

?callback, AJAX, async, available, callbackName, cross site, cross site script, dataType, dataType: jsonp, Domain, External, External Domain, getJSON, javascript, jQuery, jQuery.ajax, JSON, JSONP, jsonpCallback, onJSONPLoad, PHP, script, success, Web Service, Webservice, XSS

No Comments

PHP Webservice that uses JSON PDO – Accessed by JQuery AJAX

Posted by dan in Javascript, PHP, jQuery on January 6, 2012

You may want to look at this previous post where I setup a Web Service using JSONP from External Domain – PHP – JQuery

The HTML that calls the Javascript:

<div id="taglist"></div>
<input name="searchTags" id="searchTags" type="text" />
<input type="button" name="searchtags" onclick="getTags()" value="search"/>
<div id="tagresult">
</div>

The JavaScript (JQuery) AJAX Request and Response Processing:

function getTags()
	{
		var q = $('#searchTags').val();
		$.getJSON('ws.php?type=tag&wN=name&wO=like&wV=' + q, function(data) {
			var items = [];
			var htmlResult = "";
			$.each(data, function(key, val) {
				//As you can see, you can access the JSON (at the bottom of the page) by doing val.PROPERTYNAME:
				htmlResult += "<br />Add : <a href=\"#\" onclick=\"addTag("+ val.id +", '"+ val.getfullname +"'); return false;\">"+ val.getfullname +"</a>";
			});
			$('#tagresult').html(htmlResult);
		});
	}

PHP Code that returns JSON in the PHP file called by the AJAX: (ws.php)

	$ta = new TagAccess();
	$tarray = $ta->GetTagsWhere(" {$whereName} LIKE '%{$whereVariable}%'");
	header('Content-type: application/json');
	echo "",  json_encode($tarray), "";

The GetTagsWhere Helper Function:

    public function GetTagsWhere($where) {
    	$retArray;
 
    	$sql = "SELECT * FROM tags WHERE {$where}";
    	// THE PDO Object was created previously
	foreach ($this->pdo->query($sql) as $row)
	{
		$retArray[] = $this->GetTag($row);
	}
	return $retArray;
    }

JSON Returned:

[{"id":"4","name":"FICTION","parentid":"3","getfullname":"BOOKS > FICTION"},{"id":"5","name":"NON-FICTION","parentid":"3","getfullname":"BOOKS > NON-FICTION"}]

application/json, array, Content-type, Content-type: application/json, get, getJSON, header, javascript, jQuery, json_encode, Request, Response

No Comments

Fantastic Thrift Store – Hours

Posted by dan in Thoughts on December 7, 2011

Fan-tastic Thrift Store Hours
Monday: 10am – 6pm
Tuesday: 10am – 6pm
Wednesday: 10am – 6pm
Thursday: 10am – 6pm
Friday: 10am – 6pm
Saturday: 10am – 6pm
Sunday: CLOSED

I thought I would call and post what they said since I I couldn’t find the store hours for Fantastic Thrift anywhere online.

10am, 6pm, CLOSED, Fan Tastic Thrift Hours, Fan-tastic, Fan-tastic Thrift, Fan-tastic Thrift Store, Fantastic, Fantastic Thrift Hours, Fantastic Thrift Store, Friday, Monday, Saturday, Sunday, Thursday, Tuesday, Wednesday, Weekday, Weekend

No Comments

ASP.Net Update Panel – Javascript Event – jQuery Click

Posted by dan in .Net, Code, Javascript, jQuery on November 7, 2011

I needed to add a onclick event to a textbox in asp.net to change it to remove text from a textbox onClick when it is clicked.
The normal code would look something like this:

1	<asp:TextBox ID="txtStoreLocatorZip" ValidationGroup="CustomerServiceEmail" runat="server" Text="Enter Zip" CssClass="txtStoreLocatorZip_CssClass" />

<script>
        if ($('.txtStoreLocatorZip_CssClass').val() == 'Enter Zip') {
            $('.txtStoreLocatorZip_CssClass').click(function () {
                if ($('.txtStoreLocatorZip_CssClass').val() == 'Enter Zip') {
                    $('.txtStoreLocatorZip_CssClass').val('');
                }
            });
        }
</script>

But, this won’t quite work because my textbox is in a UpdatePanel’s ContentTemplate and the javascript is not read on postback.

So, This is what I ended up doing (a simplified version):

<asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
	<ContentTemplate>
		<asp:TextBox  ID="txtStoreLocatorZip" ValidationGroup="CustomerServiceEmail" runat="server" Text="Enter Zip" CssClass="txtStoreLocatorZip_CssClass" />
	</ContentTemplate>
</asp:UpdatePanel>

<script>
	Sys.WebForms.PageRequestManager.getInstance().add_endRequest(endRequestHandler);
	function endRequestHandler(sender, args) {
		if ($('.txtStoreLocatorZip_CssClass').val() == 'Enter Zip') {
			$('.txtStoreLocatorZip_CssClass').click(function () {
				if ($('.txtStoreLocatorZip_CssClass').val() == 'Enter Zip') {
					$('.txtStoreLocatorZip_CssClass').val('');
				}
			});
		}
	}
</script>

This will add an endRequest handler to the end of the partial page postback so that you can call a nice little function at the end of it.

Hope this helps some people!

end, end Request, endRequest, javascript, Page Request Manager, PageRequest Manager, PageRequestManager, Request

No Comments

Roasted Winter Squash Recipe

Posted by dan in Thoughts on October 12, 2011

Roasted Winter Squash

Recipe:

Winter Squash, or really anything gourd-like.

The spread on top contains:

Some of the squash seeds
Sage
Something spicy, i used jalapeno, but you can use anything with kick, or don’t.
Cinnamon
Salt
Black Pepper
A little oil (olive)

Instruction:
Cut and place squash on cooking sheet, cut/grind up the remaining ingredients, add oil. rub on top.
Cover with tin-foil to prevent burning.
Cook for ~20 min.
Uncover and cook till golden brown/not burnt. (~10)

Bonus tip: throw in the rest of the seeds to cook them too. They are a good snack.

Recipe, Roasted Pumpkin, Roasted Pumpkin Recipe, Roasted Winter Squash, Roasted Winter Squash Recipe, Spicy, squash seeds

No Comments

Birds!

Posted by dan in Photos on October 5, 2011

Birds

Google Plus Page

birds, line, pole, power, power line, powerline

No Comments

Asp.Net – Adding Parameters to CommandType.Text

Posted by dan in .Net on September 21, 2011

This is how you add parameters to a standard CommandType.Text SQL call.

This should prevent sql injection attacks.

        Using conSQL = New SqlConnection("CONNECTION STRING TO DATABASE")
            Try
                str = "SELECT * FROM TableName where customerid = @CustomerID and CartType = @CartType"
                cmdSQL = New SqlCommand(str, conSQL)
                cmdSQL.CommandType = CommandType.Text
                cmdSQL.Parameters.AddWithValue("@CustomerID", CustomerID)
                cmdSQL.Parameters.AddWithValue("@CartType", cartType)
                cartcount = cmdSQL.ExecuteScalar()
            Catch ex As Exception
                cartcount = 0
            End Try
        End Using

AddWithValue, CommandType.Text, Parameters, Parameters.AddWithValue, SELECT, SQL, where

No Comments

Free Webcam Security – Dorgem – WinSCP

Posted by dan in Software, Thoughts on September 3, 2011

This is how you setup a free home security webcam using dorgem and winscp.exe.

First Download:

Download WinSCP and install it.http://winscp.net/
Download Dorgem and install it. http://dorgem.sourceforge.net/

Next Configure Dorgem:
Most people are going to want to use the “Web Server” option. This will setup a webserver with your webcam on it…. Pretty straight forward.

But, when I was looking this up, I couldn’t find anywhere that tells you how to use WinSCP. So here I go:

First Configure WinSCP

Open WinSCP
New
Type in all the correct info in session
Make sure you set a default folder under Environment->Directories->Remote Directory
Save… and remember the name of the session
Connect and make sure you set it to remember passwords and everything

Second Configure Dorgem:

Open Dorgem
Preview the source
Click “Store Settings”
- Add
- External Program
- Name it something to remember
- Check Enable
- Command: “C:\Program Files (x86)\WinSCP\winscp.exe” name_of@winscp_session.com /upload %s /defaults
- OK
Click “Capture Now” to test it out.
You should now see a tmp file on the WinSCP server.
If you dont, then you might want to try changing the path to WinSCP in the command or double check the name of the stored WinSCP session in the command.
Then, you can enable motion detection under “options” on the main screen

Hope this helps some people!

Capture Now, Command, default, dorgem and winscp, Download Dorgem, Download WinSCP, free home security, free web cam home security, free web cam security, free webcam home security, free webcam security, home security, Store Settings, Web Server, webcam, webcam web server

No Comments

Asp DropDownList – States – ListItem Example

Posted by dan in .Net on August 9, 2011

Asp DropDownList - States - ListItem Example
Compiled List of US State Drop Downs for Asp.Net Forms:

Hope this helps!

<asp:dropdownlist ID="ddlState" runat="server">
    <asp:listitem Value="" Selected="True">Select a State</asp:listitem>
    <asp:listitem value="AL">Alabama</asp:listitem>
    <asp:listitem value="AK">Alaska</asp:listitem>
    <asp:listitem value="AZ">Arizona</asp:listitem>
    <asp:listitem value="AR">Arkansas</asp:listitem>
    <asp:listitem value="CA">California</asp:listitem>
    <asp:listitem value="CO">Colorado</asp:listitem>
    <asp:listitem value="CT">Connecticut</asp:listitem>
    <asp:listitem value="DC">D.C.</asp:listitem>
    <asp:listitem value="DE">Delaware</asp:listitem>
    <asp:listitem value="FL">Florida</asp:listitem>
    <asp:listitem value="GA">Georgia</asp:listitem>
    <asp:listitem value="HI">Hawaii</asp:listitem>
    <asp:listitem value="ID">Idaho</asp:listitem>
    <asp:listitem value="IL">Illinois</asp:listitem>
    <asp:listitem value="IN">Indiana</asp:listitem>
    <asp:listitem value="IA">Iowa</asp:listitem>
    <asp:listitem value="KS">Kansas</asp:listitem>
    <asp:listitem value="KY">Kentucky</asp:listitem>
    <asp:listitem value="LA">Louisiana</asp:listitem>
    <asp:listitem value="ME">Maine</asp:listitem>
    <asp:listitem value="MD">Maryland</asp:listitem>
    <asp:listitem value="MA">Massachusetts</asp:listitem>
    <asp:listitem value="MI">Michigan</asp:listitem>
    <asp:listitem value="MN">Minnesota</asp:listitem>
    <asp:listitem value="MS">Mississippi</asp:listitem>
    <asp:listitem value="MO">Missouri</asp:listitem>
    <asp:listitem value="MT">Montana</asp:listitem>
    <asp:listitem value="NE">Nebraska</asp:listitem>
    <asp:listitem value="NV">Nevada</asp:listitem>
    <asp:listitem value="NH">New Hampshire</asp:listitem>
    <asp:listitem value="NJ">New Jersey</asp:listitem>
    <asp:listitem value="NM">New Mexico</asp:listitem>
    <asp:listitem value="NY">New York</asp:listitem>
    <asp:listitem value="NC">North Carolina</asp:listitem>
    <asp:listitem value="ND">North Dakota</asp:listitem>
    <asp:listitem value="OH">Ohio</asp:listitem>
    <asp:listitem value="OK">Oklahoma</asp:listitem>
    <asp:listitem value="OR">Oregon</asp:listitem>
    <asp:listitem value="PA">Pennsylvania</asp:listitem>
    <asp:listitem value="RI">Rhode Island</asp:listitem>
    <asp:listitem value="SC">South Carolina</asp:listitem>
    <asp:listitem value="SD">South Dakota</asp:listitem>
    <asp:listitem value="TN">Tennessee</asp:listitem>
    <asp:listitem value="TX">Texas</asp:listitem>
    <asp:listitem value="UT">Utah</asp:listitem>
    <asp:listitem value="VT">Vermont</asp:listitem>
    <asp:listitem value="VA">Virginia</asp:listitem>
    <asp:listitem value="WA">Washington</asp:listitem>
    <asp:listitem value="WV">West Virginia</asp:listitem>
    <asp:listitem value="WI">Wisconsin</asp:listitem>
    <asp:listitem value="WY">Wyoming</asp:listitem>
</asp:dropdownlist>

More State Drop Downs After the fold:
Read the rest of this entry »

AL, Alabama, Asp, asp:DropDownList, asp:ListItem, Drop Down List, DropDown, DropDownList, Example, Item, List, List Item, ListItem, States, United States, US States

1 Comment

Asp.Net VB – Listview – ItemCommand – DataKeys – CommandName – SQL

Posted by dan in .Net on August 1, 2011

Asp.Net VB - Listview - ItemCommand - DataKeys - CommandName - SQL

Here is a basic Listview that has an ItemCommand and ItemDataBound:

Frontend Code:

<asp:ListView ID="lvAddresses" runat="server" DataKeyNames="AddressID,BillingAddressID,ShippingAddressID">
        <LayoutTemplate>
            <asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
        </LayoutTemplate>
        <ItemTemplate>
            <table class="noborder address_book" cellpadding="0" cellspacing="0"><tbody>
                <tr>
                    <td colspan="2">
                        <%#DataBinder.Eval(Container.DataItem, "FirstName")%> <%#DataBinder.Eval(Container.DataItem, "LastName")%><br>
                        <%#DataBinder.Eval(Container.DataItem, "Address1")%><br>
                        <%#DataBinder.Eval(Container.DataItem, "City")%>, <%#DataBinder.Eval(Container.DataItem, "State")%>, <%#DataBinder.Eval(Container.DataItem, "Zip")%><br>
                        <%#DataBinder.Eval(Container.DataItem, "Phone")%><br>
                        <span class="caption"><asp:LinkButton ID="lnkMakeDefault_Billing" CommandName="MakeDefault_Billing" runat="server">Click to make Default Billing Address</asp:LinkButton></span>
                        <span class="caption"><asp:Literal ID="litMakeDefault_Billing" runat="server" Text="Default Billing Address"></asp:Literal></span>
                        <br />
                        <span class="caption"><asp:LinkButton ID="lnkMakeDefault_Shipping" CommandName="MakeDefault_Shipping" runat="server">Click to make Default Shipping Address</asp:LinkButton></span>
                        <span class="caption"><asp:Literal ID="litMakeDefault_Shipping" runat="server" Text="Default Shipping Address"></asp:Literal></span>
                    </td>
                </tr>
                <tr>
                    <td>
                        <asp:Button ID="Button1" runat="server" Text="EDIT" CommandName="EDITAddress"/>
                    </td>
                    <td>
                        <asp:Button ID="btnREMOVE" runat="server" Text="REMOVE" CommandName="REMOVEAddress"/>
                    </td>
                </tr>
            </tbody></table>
 
        </ItemTemplate>
    </asp:ListView>

Backend Code:

Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender
 
        FindIt()
 
    End Sub
    Private Sub FindIt()
 
        lblAddresses.Text = ""
 
        Dim sqlDataConnection As System.Data.SqlClient.SqlConnection = CDataAccess.OpenDatabase
        Dim conStr As String = sqlDataConnection.ConnectionString
        sqlDataConnection.Close()
 
        Dim selectCommand As String = "SELECT Address.*, Customer.BillingAddressID, Customer.ShippingAddressID"
        selectCommand &= " FROM Address INNER JOIN Customer ON Address.CustomerID = Customer.CustomerID"
        selectCommand &= " WHERE Address.CustomerID = @CustomerID AND Address.Deleted = 0"
 
        Dim sds As New SqlDataSource()
        sds.ConnectionString = conStr
        sds.SelectParameters.Clear()
 
        sds.SelectParameters.Add("CustomerID", 12345)
        sds.SelectCommand = selectCommand
 
        lvAddresses.DataSource = sds
        lvAddresses.DataBind()
    End Sub
 
    Protected Sub lvAddresses_ItemCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewCommandEventArgs) Handles lvAddresses.ItemCommand
        Dim dataItem As ListViewDataItem = e.Item
        Dim currentDataKey As DataKey = lvAddresses.DataKeys(dataItem.DataItemIndex)
        Dim AddressID As Integer = currentDataKey("AddressID")
        Dim BillingAddressID As Integer = currentDataKey("BillingAddressID")
        Dim ShippingAddressID As Integer = currentDataKey("ShippingAddressID")
 
        'MakeDefault_Billing
        'MakeDefault_Shipping
        'EDITAddress
        'REMOVEAddress
        If String.Equals(e.CommandName, "MakeDefault_Billing") Then
            MakeDefault(AddressID, True)
        ElseIf String.Equals(e.CommandName, "MakeDefault_Shipping") Then
            MakeDefault(AddressID, False)
        ElseIf String.Equals(e.CommandName, "EDITAddress") Then
            EditAddress(AddressID)
        ElseIf String.Equals(e.CommandName, "REMOVEAddress") Then
            RemoveAddress(AddressID)
        End If
    End Sub
 
    Protected Sub lvAddresses_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) Handles lvAddresses.ItemDataBound
        Dim dataItem As ListViewDataItem = e.Item
 
        If e.Item.ItemType = ListViewItemType.DataItem Then
            Dim currentDataKey As DataKey = lvAddresses.DataKeys(dataItem.DataItemIndex)
            Dim AddressID As Integer = currentDataKey("AddressID")
            Dim BillingAddressID As Integer = currentDataKey("BillingAddressID")
            Dim ShippingAddressID As Integer = currentDataKey("ShippingAddressID")
            lit = e.Item.FindControl("litMakeDefault_Billing")
            Dim lit2 As Literal = e.Item.FindControl("litMakeDefault_Shipping")
            lnk = e.Item.FindControl("lnkMakeDefault_Billing")
            Dim lnk2 As LinkButton = e.Item.FindControl("lnkMakeDefault_Shipping")
 
            lit.Visible = Not lnk.Visible
        End If
 
    End Sub

.Net, Asp, Asp.Net, CommandName, ConnectionString, DataBind, dataItem.DataItemIndex, DataKeys, e.CommandName, e.Item, e.Item.FindControl, e.Item.ItemType, FindControl, ItemCommand, ItemDataBound, Listview, ListViewItemEventArgs, Parameters, Parameters.Add, SelectCommand, SelectParameters, SQL, SqlDataSource, VB, WebControls

No Comments

Micaela’s Family

Posted by dan in Thoughts on July 19, 2011

No Comments

ASPDotNetStoreFront: Adding Topic to XML Packages or .aspx Pages

Posted by dan in .Net, Code on July 18, 2011

This is how you add a DotNetStoreFront’s Topic into a XMLPackage:

<xsl:value-of select="aspdnsf:Topic('TOPIC_NAME')" disable-output-escaping="yes"/>

Now, if you want to add it to a .aspx or .ascx page on dnsf:

<aspdnsf:Topic runat="server" ID="Topic1" TopicName="TOPIC_NAME" />

add, ASP Dot Net Store Front, aspdnsf, aspdnsf:Topic, AspDotNetStorefront, c#, DotNetStoreFront, Store Front, StoreFront, Topic, Topics, VB, Xml Package, XMLPackage, XMLPackages

No Comments

Me and Micaela at the Beach

Posted by dan in Photos, Thoughts on July 7, 2011

Me and Micaela at the Beach, originally uploaded by danfolkes.

yeah.. we cool

No Comments

Simple PHP Pseudo Proxy

Posted by dan in PHP on July 6, 2011

php proxy simple pseudo

This is the code for a simple php pseudo proxy. If you are blocked by a firewall and google cache isn’t working for some reason. You can use a url with this php file in it:

<?php
$filename = $_GET["url"];
if (isset($filename))
{
        $handle = fopen($filename, "rb");
        $contents = stream_get_contents($handle);
        print $contents;
        fclose($handle);
}
else
{
        echo "url";
?>
<form method="GET">
<input type="text" name="url" /><input type="submit"/>
</form>
<?php
}
?>

Then you can go to where the url is hosted and try something like this:

index.php?url=http%3A%2F%2Fwww.last.fm%2Fuser%2Fdanfolkes%2Fcharts%3Frangetype%3D6month%26subtype%3Dartists

cache, fopen, PHP, PHP Proxy, Proxy, Simple PHP Proxy, stream_get_contents

No Comments

FoxToPhone – Send Links from Firefox to Android – (Like ChromeToPhone)

Posted by dan in Software on June 29, 2011

Just found out about FoxToPhone.

It gives you a little button in Firefox that allows you to send it to be opened by your browser on your Android phone.

The integration is seamless and it works like a charm.
Useful Links:

Firefox Plugin: FoxToPhone
Android App: Google Chrome to Phone

No Comments

Small After Lunch Motorcycle Ride

Posted by dan in Thoughts on June 7, 2011

Google Maps Link

This was a fun little motorcycle ride after my lunch break today.
Bon Air, VA

curves
hills
train tracks
not a ton of traffic
paved

No Comments

Facebook Website Integration – HTML

Posted by dan in Code, Javascript, PHP, jQuery on May 25, 2011

To integrate Facebook on to a website without the use of a facebook app you need these things:

Facebook Page RSS Feed (can be tricky)
Feedburner Account (free,easy) (here)

Once you have both of those things you can do this in feedburner:

Add a new feed (your facebook url)
Go to the publicize tab
Go to BuzzBoost
Sroll down and fill out the form, you will be given html code.

<script src="http://feeds.feedburner.com/DanielFolkessFacebookStatusUpdates?format=sigpro" type="text/javascript" ></script>
<noscript><p>Subscribe to RSS headline updates from: 
<a href="http://feeds.feedburner.com/DanielFolkessFacebookStatusUpdates"></a>
<br/>Powered by FeedBurner</p> 
</noscript>

Preview:

And that’s it!
You can now style it up a little bit with some CSS and stuff.

a website, css, facebook, facebook app, feed, Feedburner, HTML, integrate, integrate Facebook, rss feed, website

No Comments

Java – Singleton / Global – Data Access – SQLite

Posted by dan in Code on May 20, 2011

This will make a Java global object:

import java.io.File;
import java.io.IOException;
 
import com.almworks.sqlite4java.SQLite;
import com.almworks.sqlite4java.SQLiteConnection;
import com.almworks.sqlite4java.SQLiteException;
import com.almworks.sqlite4java.SQLiteJob;
import com.almworks.sqlite4java.SQLiteQueue;
import com.almworks.sqlite4java.SQLiteStatement;
 
public final class DataAccess {
	// Singleton Stuff
	private static class SingletonHolder { 
	     public static final DataAccess INSTANCE = new DataAccess();
	}
	public static DataAccess getInstance() {
	     return SingletonHolder.INSTANCE;
	}
	// End Singleton Stuff
 
 
	private String HomePath = "";
	private File DBFile;
	private static SQLiteQueue queue;
	private boolean initalized = false;
 
	private DataAccess()
	{
		if (!initalized)
		{
			initDB();
 
			initalized = true;
		}
	}
 
	private void initDB()
	{
		DBFile = locateDBFile();
		DeleteDatabaseContents();
	}
	private File locateDBFile()
	{
		File f = null;
		try{
			HomePath = System.getProperty("user.home");
    	    System.out.println("HomePath: " + HomePath);
    	    f = new File(HomePath + "/database.sqlite");
    	    if (f.canRead())
    	    	return f;
    	    else
    	    {
        	    boolean success = f.createNewFile();
        	    if (success) {
        	        // File did not exist and was created
        	    } else {
        	        // File already exists
 
        	    }
    	    }
    	} catch (IOException e) {
    		//Maybe try a new directory.
    	}
		return f;
	}
 
	private void DeleteDatabaseContents()
	{
		queue.execute(new SQLiteJob<Object>() 
		{
		    protected Object job(SQLiteConnection connection) throws SQLiteException 
		    {
		      // this method is called from database thread and passed the connection
				StringBuilder sb = new StringBuilder();
				sb.append("DROP TABLE IF EXISTS Playlist;");
				sb.append("DROP TABLE IF EXISTS Settings;");
				//sb.append("DELETE FROM someTable;");
				//sb.append("DELETE FROM someTable;");
 
 
				connection.exec(sb.toString());
				return null;
		    }
		});
	}
	public String getHomePath()
	{
		return HomePath;
	}
}

Now you can run this from anywhere:

DataAccess da;
da = DataAccess.getInstance();

Source: http://en.wikipedia.org/wiki/Singleton_pattern

DataAccess, Global, java, JAVA Global, Java Singleton, Singleton, SingletonHolder.INSTANCE, SQLite, sqlite4java

No Comments

PHP API – Google Calendar – Updating Visibility

Posted by dan in PHP on May 13, 2011

The Privacy / Visibility Part:

$event->visibility->value = "http://schemas.google.com/g/2005#event.private";

Here it is in context: Read the rest of this entry »

Calendar, ClientLogin, event, event.private, extension, gcalendar, Gdata, http://schemas.google.com/g/2005#event.private, http://www.google.com/calendar/feeds/default/private, newEventQuery, private, save(), setVisibility, Visibility, visibility->value, Zend, Zend_Gdata, Zend_Gdata_Calendar

2 Comments

Minecraft – Script – Backup – Update Server – Restart

Posted by dan in Linux on April 11, 2011

This is the script I use that will:

Automatically backup minecraft map
Automatically update minecraft server
Automatically restart the server if it stops or dies

#!/bin/bash
while [ true ]; do
   # make md5 of current file for update check.
   md5sum minecraft_server.jar > minecraft_server.jar.md5
   wget -o updatelog.log -N --trust-server-names http://www.minecraft.net/download/minecraft_server.jar
   # display updated status
   if md5sum -c --status minecraft_server.jar.md5 
   then
    echo "Server Up to Date."
   else
    echo "Updated Server!"
   fi
   java -Xmx1024M -Xms1024M -jar minecraft_server.jar nogui
   rsync -a --delete --progress /home/dan/serv/minecraft/world "/home/dan/serv/minecraft/bak/world"`eval date +%Y%m%d`""
done

Code Explained:

This will put the server in an infinite loop. You can kill it by hitting Control+C a couple times in a row.

while [ true ]; do

This will make a hash of the current minecraft_server.jar and then download the newest copy using wget.

md5sum minecraft_server.jar > minecraft_server.jar.md5
wget -o updatelog.log -N --trust-server-names http://www.minecraft.net/download/minecraft_server.jar

This will run minecraft in headless mode and with a limit on RAM.

java -Xmx1024M -Xms1024M -jar minecraft_server.jar nogui

This will create a backup of the minecraft world folder in a backup folder. You probably should work on this part.

rsync -a --delete --progress /path/to/minecraft/world "/path/to/minecraft/bak/world"`eval date

Well, hope this helps someone. Have a good day.

No Comments

Reading some Rousseau

Posted by dan in Thoughts on March 27, 2011

Discourse on the Origins of Inequality

No Comments

Rsync – Speed Limit – Trickle – Slow

Posted by dan in Code, Linux on March 3, 2011

Install rsync and trickle:

sudo apt-get install rsync
sudo apt-get install trickle

Now you can run rsync:
This will download at a limit of 80 KB/s from host:

rsync -auvPe "trickle -d 80 ssh" user@host:/src/ /dst/

Explanation of Commands:

-a, --archive               archive mode; equals -rlptgoD (no -H,-A,-X)
-u, --update                skip files that are newer on the receiver
-v, --verbose               increase verbosity
-P  --progress              show progress during transfer
-e, --rsh=COMMAND           specify the remote shell to use
trickle -d 80  = -d rate    Limit the download bandwidth consumption to rate KB/s.

archive, auvPe, bandwidth, decrease, download, increase, KB/s, Limit, Limit Speed, newer, Rsync, skip, Slow, Speed, Speed Limit, ssh, Trickle, upload

No Comments

Outlook Rule : Only at Specific Times

Posted by dan in Code, Software on February 18, 2011

Lets say you want to have a rule in outlook send to you only between specific times in the day.

Only after 6pm and before 8am
Only on your lunch hour
When you are not at work

I will explain this by having emails forward to my cell phone, only when I am normally not at the office. (From 6pm-8am) This way, I will be able to receive important emails that may require special outside assistance.

What I do is:

Create a special category called FWD
Use other rules to set messages into the FWD category if I want them forwarded. (Explained Below)
Then, create a rule to run last in the rules list called FWD Rule
*Important Part* This will check the time on the messages, if it’s within the specified hours, it will forward the email (Explained Below)

Creating a Rule to set the FWD Category:
Your Rule Description should look something like this. The important part is that it is assigning it to the FWD Category:

Apply this rule after the message arrives
with 'Emergency from client' in the subject
    and marked as 'high importance'
    and assigned to 'FWD' Category

The Rule that will email header* for UTC times. Make sure it’s assigned to the FWD category. And then FWD it:

Apply this rule after the message arrives
with '2011 23:' or '2011 02:' or ... '2011 10:' in the message header
    and assigned to 'FWD' category
forward it to 'email@example.com'

* This should work on most emails, but if you want to look at the email header Right-click on the message in the Inbox and select Message Options.
* I included the 2011 and the colon to make it more specific.

UTC Time for 6pm – 8am:
Email Header contained:
X-OriginalArrivalTime: 18 Feb 2011 03:23:52.0368 (UTC)
So I searched for:

2011 23:,2011 01:,2011 02:,2011 03:,2011 04:,2011 05:,2011 06:,2011 07:,2011 08:,2011 09:,2011 10:,2011 11:

2010, after, after hour, after time, certain time, create rule, creating a rule, creating a rule in outlook, forward outlook, hours, outlook email, outlook rules, receive emails, redirect emails, rule in outlook, selected days, specific time, specific times

3 Comments

jQuery – Ajax – Extra Parameters – GET, success

Posted by dan in Javascript, jQuery on February 11, 2011

Here is the standard jQuery Ajax call with success handler as well as the ability to pass another parameter to an external function:

	$.ajax({
			type: "GET",
			url: Humancurl,
			dataType: "xml",
			success: function(data){
				NameOfFunctionToParseReturnedData(data,ExtraParameter);
			}
		});

Here is the standard jquery ajax call with success handler:

$.ajax({
  url: 'ajax/test.html',
  success: function(data) {
    $('.result').html(data);
    alert('Load was performed.'+data);
  }
});

No Comments

Ubuntu Samba – Read-Write-FSTAB-Cifs-Mount

Posted by dan in Linux on January 26, 2011

This is my current setup for my two Ubuntu 10.10 (Maverick Meerkat) boxes. One shares a read/write folder to the other. This is my setup. I think the key to this is having the same username on both computers having access to the files.

You might have to run this on the the folder:
sudo chmod -R 777 /path/to/files
sudo chown -R usernameonbothcomputers:usernameonbothcomputers /path/to/files

I installed samba by doing: sudo apt-get install samba

/etc/samba/smb.conf : (on the computer serving the files)

[global]
	workgroup = WORKGROUP
	server string = %h server (Samba, Ubuntu)
	dns proxy = no
 
	interfaces = 127.0.0.0/8 eth0
	bind interfaces only = yes
 
	log file = /var/log/samba/log.%m
	max log size = 1000
	syslog = 0
 
	panic action = /usr/share/samba/panic-action %d
	encrypt passwords = true
	passdb backend = tdbsam
	obey pam restrictions = yes
	unix password sync = yes
	passwd program = /usr/bin/passwd %u
	passwd chat = *Enter\snew\s*\spassword:* %n\n *Retype\snew\s*\spassword:* %n\n *password\supdated\ssuccessfully* .
	pam password change = yes
 
	guest account = nobody
	invalid users = root
	usershare allow guests = yes
 
[MyFiles]
	path = /path/to/share
	writable = yes
	read only = no
	valid users = usernameonbothcomputers

sudo /etc/init.d/smbd reload

/etc/fstab : (on the computer accessing the files)

//SAMBASHAREsSERVERNAME/MyFiles /path/to/mount cifs users,,noatime,username=usernameonbothcomputers,password=theuserspassword 0 0

You should be able to run this to mount all things in your fstab:
sudo mount -a

/etc/fstab, /etc/samba/smb.conf, 777, allow, chmod, chown, chown cifs, Cifs, folder, FSTAB, fstab cifs mount write, fstab no cifs support, guests, invalid users = root, Maverick, Maverick Meerkat, Meerkat, Mount, noatime, password, read, read only = no, read/write, Samba, Setup, smb.conf, smbd, sudo apt-get install samba, sudo mount -a, Ubuntu, username, usershare, usershare allow guests = yes, valid users, writable, writable = yes, write

No Comments

.Net – Sending Email with In Memory Attachment

Posted by dan in .Net, Code on December 21, 2010

This VB.Net code takes the FileUpload control’s PostedFile and without saving it to the filesystem attaches it to an MailMessage and sends an email.

Advantages:

No threading, read/write permissions needed.
One line of code.

Front End:

<asp:FileUpload ID="fileUpload" runat="server" />

Code:

Dim m As New MailMessage()
m.Attachments.Add(New Attachment(fileUpload.PostedFile.InputStream, fileUpload.FileName))

.Net, attaches, attachment, Attachments, Attachments.Add, e-mail, email, file, filesystem, FileUpload, InputStream, IsBodyHtml, Mail, MailAddress, MailMessage, Message, PostedFile, read, read/write, Send, SmtpClient, subject, system, VB, vb.net, write

No Comments

Gulliver, the Christmas Elf

Posted by dan in Photos on December 13, 2010

Gulliver, the Christmas Elf, originally uploaded by danfolkes.

Gulliver is very happy because he has both a good family and an awesome new jacket.

christmas, dog, elf, house, jacket

No Comments

Apple Head

Posted by dan in Photos on December 2, 2010

IMG_4893, originally uploaded by danfolkes.

No Comments

Peanut Butter, Banana, Marshmallow

Posted by flickr in Photos on December 2, 2010

FH000016, originally uploaded by danfolkes.

This is a Peanut Butter, Banana, Marshmallow sandwhich that some friends and I made on a camping trip last year.

No Comments

Digital Bar

Posted by flickr in Photos on December 2, 2010

Digital Bar, originally uploaded by danfolkes.

Car stereo thing

No Comments

DAN FOLKES

Web Service using JSONP from External Domain – PHP – JQuery

PHP Webservice that uses JSON PDO – Accessed by JQuery AJAX

Fantastic Thrift Store – Hours

ASP.Net Update Panel – Javascript Event – jQuery Click

Roasted Winter Squash Recipe

Birds!

Asp.Net – Adding Parameters to CommandType.Text

Free Webcam Security – Dorgem – WinSCP

Asp.Net VB – Listview – ItemCommand – DataKeys – CommandName – SQL

Micaela’s Family

ASPDotNetStoreFront: Adding Topic to XML Packages or .aspx Pages

Me and Micaela at the Beach

Simple PHP Pseudo Proxy

FoxToPhone – Send Links from Firefox to Android – (Like ChromeToPhone)

Small After Lunch Motorcycle Ride

Facebook Website Integration – HTML

Java – Singleton / Global – Data Access – SQLite

PHP API – Google Calendar – Updating Visibility

Minecraft – Script – Backup – Update Server – Restart

Reading some Rousseau

Rsync – Speed Limit – Trickle – Slow

Outlook Rule : Only at Specific Times

jQuery – Ajax – Extra Parameters – GET, success

Ubuntu Samba – Read-Write-FSTAB-Cifs-Mount

.Net – Sending Email with In Memory Attachment

Gulliver, the Christmas Elf

Apple Head

Peanut Butter, Banana, Marshmallow

Digital Bar

Artists

Blogs

Programmers

Sites

Archives

Meta