Lowyat.NET: Latest topics by invisible_wings

Problem With Recursion

invisible_wings — Fri, 04 Jun 2010 21:41:16 +0800

Hi hi, this problem has been bugging me for the last few hours.

I had simplified the function to explain it here.

I was trying to pass in a value into the recursion until it returns me the value I want.

But it seems like the function in the function couldn't call to itself and never come back.

What did I do wrong?

CODE

<?php
function check_number($number) {
$flag = 0;

if($number == 1) $flag = 1;
elseif($number == 2) $flag = 1;

if($flag == 1) check_number(2);
else return $number;
}

print "result: " . check_number(1);
?>

How to Remove Javascript from Excel?

invisible_wings — Wed, 31 Mar 2010 09:40:48 +0800

Hi Sifus,

I have to copy-paste some reports from a web page to Excel. Any solution to remove javascript embedded within a picture (buttons) from Excel?

I had been searching for the solution for quite some time but still couldn't find.

How to use $_GET to get info from URL

invisible_wings — Tue, 25 Nov 2008 10:34:43 +0800

Hi, I'm having a problem with getting information from the URL.

I used URL encoding to encode the information and passed through the URL: http://www.mywebsite.com/test.php?message=%B5%CD%A4%A0lb

So, I used $_GET['message'] to get the information from the URL and printed it out.

Instead of getting: '%B5%CD%A4%A0lb',
I got these weird characters (in firefox): '�ͤ�lb',
(in IE): '?ͤ?lb'.

Is it got to do with PHP setting? Or which type of encoding should I use acutally?

Help: OS Can't Read HDD

invisible_wings — Tue, 04 Nov 2008 09:23:09 +0800

Hi all, is there any way to extract the data from the hard disk if the root locked up itself, ie. file system locked up?

I'm using Fedora. All important data are in the hard disk. The OS can't read the HDD now. Please help!

Fixed Deposit

invisible_wings — Fri, 10 Oct 2008 08:54:16 +0800

Hi, I'm a bit confused with the FD interest rate calculation for the tenure period of < 12 months. For example, if I save RM1000 in FD for 2 months with interest rate of 3.00% p.a., how much interest in $ can I get after 2 months?

1) Interest = RM1000 * 3% = RM30
2) Interest = 3%/12 months * RM1000 = RM2.50

Which is the correct calculation? Or both also wrong? Please enlighten me. Thanks.

[addedon]October 10, 2008, 9:08 am[/addedon]Got my answer already, it is:

Interest = 3%/12 months * RM1000 * 2 months = RM5.00

Thanks all.

Help: Joining table

invisible_wings — Thu, 28 Feb 2008 10:54:30 +0800

Hi all, provided that I have 3 tables that store Ann's job history.

job_information
==========
employee || join_date
Ann || 1-Jun-2007

job_position
========
employee || position || effective_date
Ann || Asst Manager || 1-Feb-2008
Ann || Sales Exec || 1-Jun-2007

job_salary
=======
employee || salary || effective_date
Ann || 3000 || 1-Feb-2008
Ann || 2000 || 5-Nov-2007
Ann || 1000 || 1-JUn-2007

I would like to join all the 3 tables and order them based on the join_date and effective_date to display the result as shown below to my application. Any way to do this? Thanks!

Ann Working History
=============
1-Feb-2008 salary 3000
1-Feb-2008 asst manager
5-Nov-2007 salary 2000
1-Jun-2007 salary 1000
1-Jun-2007 sales exec
1-Jun-2007 joined

YUI Drop Down Menu

invisible_wings — Fri, 23 Nov 2007 16:01:18 +0800

Hi, I'm new to the Yahoo! User Interface Library (YUI).

I'm looking for drop down menu from YUI components to add into my application. But I couldn't find that component and any example for doing that, from the YUI website itself and google. Does anyone has any example or any idea?

Thanks in advance!

Help: How to replace characters in dblink?

invisible_wings — Thu, 21 Jun 2007 17:12:02 +0800

Hi, I wanted to copy a data from table1 in db1 to table2 in db2, which has the same structure, with the PosgreSQL dblink funtion.

The fields for both the tables are: id, first_name, last_name.

However, I would like to replace the id and first_name in table1 to: 3 and 'nil' to insert into table2.

CODE

INSERT INTO table2 SELECT * FROM dblink('dbname=db1', 'SELECT 3, nil, last_name FROM table1 WHERE id = 1000') AS t1(id integer, first_name varchar, last_name varchar);

The id can be replaced but it thought "nil" is a column name, instead of the value that I wanted to replace the first_name with, thus return error.

Anyone knows how to replace characters in dblink or any solution to this problem??
Thanks in advance!

Study in Hawaii

invisible_wings — Wed, 06 Dec 2006 14:56:59 +0800

My friend planned to study in Hawaii but the university there mostly provide Business/Science course. Is there any university that provide Engineering course? How's life in Hawaii?
Thanks.