Archive for November 6th, 2007

  • 06
  • Nov

 
 
PHP-MySQL Logo

There might be many reasons why you may be storing data in a database. As Google has showed us, searching data is an invaluable tool that can help minimize the time that it takes to find the information you need.

I would like to show you how you can build your own PHP search engine to find the information you seek in a MySQL database.

First you will need a LAMP to work from. For Windows users a quick and dirty way is to download and install XAMPP. For Linux users try searching Google for a tutorial.

OK, now we will skip to the part where you have a working LAMP install and a database that needs searching from a web interface. I will assume that you have basic knowledge of and where to put your PHP files and also some basic SQL query syntax.

NOTE: I am not including “<?php” at the beginning of documents, nor “?>” at the end I will assume that you will know that these are the operators to signify php code within a file. You may also download the zip file that contains all of the code examples listed below at the end of this document.

Step 1: We are going to create a config.php file with our database information. Please fill in the correct information for your MySQL database and save the file:

  1. $dbhost=‘127.0.0.1′;
  2. $dbusername=‘db_username’;
  3. $dbuserpass=‘db_password’;
  4. $dbname = ‘db_name’;

Read the rest of this entry …

  • 06
  • Nov

 
 
Chumby Trio

The chumby is a compact device that displays useful and entertaining information from the web: news, photos, music, celebrity gossip, weather, box scores, blogs — using your wireless internet connection. Always on, it shows — nonstop — what’s online that matters to you.

More info. The store is currently invitation only, but get notified here. Check out details on the software at the Chumby Wiki. Download the source code. And learn some Chumby Tips and Tricks.

via LinuxDevices

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]
  • 06
  • Nov

 
 
BonkEnc Logo

BonkEnc is a CD ripper, audio encoder and converter for various formats. It can produce MP3, MP4/M4A, Ogg Vorbis, AAC, Bonk and FLAC files.

BonkEnc makes it easy to convert your audio CDs to MP3 or Ogg Vorbis files which you can use in your hardware player or with your favorite audio software. The program supports the CDDB/freedb online CD database and CDText and automatically writes song information to ID3V2 or Vorbis comment tags.

BonkEnc Screenshot
image via link

BonkEnc Homepage

 

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]