Posts

Showing posts from June, 2013

Organize Your Movie Collection Using MeD's Movie Manager

You love movies? You downloaded a lot? :P
MeD's Movie Manager is a simple to use, yet customizable, movie manager. Info is automatically retrieved from IMDb and tv.com.
Technical info can also be retrieved from media files like AVI, OGM, MPEG and DVD (ifo). It's written in Java and should therefore run on most desktop systems supporting Java. 
This software will organize your movie collection with its detailed information from IMDB.
Have a tour here:

CSS Way: Horizontal Rule

Definition and Usage
The <hr> tag defines a thematic break in an HTML page (e.g. a shift of topic).
The <hr> element is used to separate content (or define a change) in an HTML page. Default hr tag is ugly. So, let's use CSS instead. :P

Smooth Scrolling using JQuery

So far, this is the best(for me) smooth scrolling "piece of code" using JQuery. It will use ID as the destination.
Here's the code for demo:

Create Form without Using Table

The easiest way to do it is to use "p" or the paragraph html tag because browsers automatically add some space (margin) before and after each <p> element which can be a replacement for table rows and  css property to style/define it.

Disable Submit/Save Button if Value Exists from MySQL Database

Image
As shown below:

Download Source Code
First you need to create a database and name it as "syllabus" then import the sql file from the source code.

Here are the codes below for reference:

Showing and Hiding MySQL error in PHP

You might ask why we hide an error, 'cause it should be fixed right? Anyway, there are instances that we just need to hide it. Let's say for example, "undefined index" error/warning in this case:

I have this table with unique attribute names in every "input" elements:
IDName1Eds2Matt




We don't know how many value that the user will input, so I assume that he/she will always input eight(8) values. I must fetch the value from that table by assigning them to a variable. If the user will  input less than eight(8), a warning or error will show "undefined index..". In this case, I just hide it.


Pass Value from Checkbox in Child Window to the Parent Window

Image
This will populate you textarea based on the selected item on child window.
I hope the image above can be the explanation. :P Anyway here's the code:

Delete Duplicate Values but Retain One in MySQL

I'm not good at explaining so, let's just demonstrate it. Say for example (although this is some sort of explanation) we have this table in our database:

Table Name: tag
NAMEIDtest1test2test3again4again5nodup6

with this query,

DELETE a FROM tag a LEFT JOIN ( SELECT MIN(id) AS id, name FROM tag GROUP BY name ) b ON a.id = b.id AND a.name = b.name WHERE b.id IS NULL;

...the result will be

NAMEIDtest1again4nodup6