SoundSnap.com – Free Sound Effects and Loops

Web resources          Trackback

SoundSnap.com - Free Sound Effects and LoopsSoundsnap is the best place on the Internet for sharing free sound effects and loops. On this site you can find a collection of original sounds made or recorded by its users, which you can legally use for your projects. This project was originally started by a small group of sound enthusiasts from all over the world. This site can be useful for anyone: sound designers, sound artists, web game developers, filmmakers, music producers, hobbyists and home video makers… You can join their community and leave a recommendation or feedback in the special section of their forum.


Export MySQL To Excel better way

PHP,SQL          Trackback

I showed you how to export your MySQL tables to MS Excel file, but that wasn’t real excel files we were creating. Actually you were getting CSV and HTML files which excel can read. These were textual files, and now I am gonna show you how to create binary excel file: [SOURCE CODE]


Compare web applications

On Line Tools          Trackback

Compare StuffCompare Stuff is a network of websites that are containing comparison charts for many web applications. I would like to recomend you this sites:

CMS MatrixCMS Matrix compares content management systems, blogs, and page publishing tools. Their database currently contains 815 CMS, from small to enterprise, and you can select up to 10 content management tools to compare at once. Here you can discuss, rate, and compare the various systems available on the market today.

Forum matrixForum Matrix compares available forum softwares (currently 41 of them). You can select forum softwares you would like to compare, click on compare button and you will see comparison chart. If you are not sure where to start you can visit Choice Wizard that can help you through the first steps of narrowing down the list of available Forums matching your special needs.

On Compare Stuff website you can also find links for:

Epayment Matrix – Compares epayment solutions (PayPal, Authorize.net and Google Checkout…)

Affliate Software Review – Compares affiliate tracking systems (Commission Junction, LeadHound…)

Compare IM – Compares instant messaging clients (AIM, Gaim, Skype, GoogleTalk, MSN Messenger…)

Messaging Matrix – Compares mail servers and mail service providers (Microsoft Exchange, CommuniGate Pro, GMail…)

BI Contrast – Compares Business Intelligence Software (Crystal Reports, ProClarity…)

Compare Hangouts – Compares social networks, dating sites, and other interpersonal communication web sites ( e|Harmony, Match.com, MySpace…)

Which Poker Sites – Compares online poker sites (Absolute Poker, Party Poker, Paradise Poker…)

MMO Matrix – Compares online games (Dark Age of Camelot, Dungeons and Dragons, Wolds of Warcraft…)

Compare Canines – Compare dogs 🙂 (Poodles, Terriers, Boxers, Hounds, Bulldogs…)


Simple PHP breadcrumb navigation

PHP,Tutorials          Trackback

I was working on one application this morning and I needed breadcrumb links on the top. First thought that came to me was: ‘recursion’. That’s scary word, for memory eating functions, but at the same time that is easiest way to create breadcrumbs navigation. All you have to do is to create MySQL table, with these fields: (category_id, parent_id, category_name)
Top categories must have parent_id set to 0. And here goes that simple recursive printbreadcrumb function:

function printbreadcrumb($category_id) {
	$sql = "SELECT category_id, parent_id, category_name
				FROM categories
				WHERE category_id=$category_id";
	$result	= mysql_query($sql) or die('something is wrong here');
	$row = mysql_fetch_array($result);
	if ($row['parent_id']) { // if this node has parent
		printbreadcrumb($row['parent_id']); // make recursive call to this function
	echo $row['categories_name'].' > '; // print nodes one by one

You are calling this function like this: printbreadcrumb($category_id)

Some would say that this is slow script, because you’ll have same number of sql calls, as you have levels. What you can do is to change this function to work with arrays and to load that complete table in one array.