The Dreamer!

উত্থানে যারা পতনেও তারা - প্রথম আলো

2011-04-11T11:47:00.001+06:00

উত্থানে যারা পতনেও তারা - প্রথম আলো

এ কেমন নিষ্ঠুরতা! - প্রথম আলো

2011-04-11T11:47:00.000+06:00

এ কেমন নিষ্ঠুরতা! - প্রথম আলো

আসুন, সভ্য হই! - প্রথম আলো

2011-04-11T11:41:00.000+06:00

আসুন, সভ্য হই! - প্রথম আলো

How to add date picker in joomla site…

2011-03-09T10:36:00.002+06:00

In your component html file, put the following code at the top of your function:
JHTML::_('behavior.calendar');

Then for your date field in your form:

input class="inputbox" type="text" name="startdate" id="startdate" size="25" maxlength="25" value="" &

input type="reset" class="button" value="..." onclick="return showCalendar('startdate','%Y-%m-%d');"

Show/Hide multiple DIVs with Select using jQuery

2011-03-09T10:33:00.001+06:00

Today ill discuss Show/Hide multiple DIVs with Select using jQuery. Bellow a complete example about that

How to convert rpm to deb?

2011-03-09T10:28:00.002+06:00

To convert a rpm to a deb file with alien you should first install alien

sudo apt-get install alien

Then only need to do

sudo alien
Example: sudo alien avg-10.0.1.rpm

After you run that command alien should then do its magic and create a .deb file in the same directory for you to use.

Get the width and height of an image using a function in PHP

2011-03-09T10:27:00.002+06:00

This is a very useful function in PHP. PHP provides function to get the width and height of an image. The
getimagesize() function will determine the size of image file including flash file(swf).
Syntax

list($width, $height, $type, $attr) = getimagesize(“image_name.jpg”);

Code
This is a sample code, change image_name to your image name and test it!

list($width, $height, $type, $attr) = getimagesize(“image_name.jpg”);
echo “Image width ” .$width;
echo “
”;
echo “Image height ” .$height;
echo “
”;
echo “Image type ” .$type;
echo “
”;
echo “Attribute ” .$attr;
?>

When you run this script you will see the result like this
Image width 379
Image height 344
Image type 2
Image attribute width=”379″ height=”344″
You will get the width, height, type of an image and also attribute of an image, I use this function in my image
upload form.
Type of an image you can see from table below You can read a full manual here
Type of the image
1 = GIF      5 = PSD          9 = JPC     13 = SWC
2 = JPG     6 = BMP     10 = JP2     14 = IFF
3 = PNG 7 = TIFF(intel byte order)               11 = JPX     15 = WBMP
4 = SWF 8 = TIFF(motorola byte order)     12 = JB2     16 = XBM

How to create schema for Oracle APEX Workspace?

2011-03-09T10:24:00.002+06:00

If you choose to create a schema while creating the workspace in Oracle Application Express administration service, APEX will create a brand new tablespace as well. This may not be an ideal situation. Having too many tablespaces, specially when it is not required, adds management and administrative overhead.
You can use the following script to create the schema and then just use this schema when you are creating the worksace.

– Connect as SYSTEM or DBA User
$ sqlplus system/password@XE
– Create the new Schema/User
CREATE USER APEXAPPS IDENTIFIED BY APEXAPPS
DEFAULT TABLESPACE APEXAPPS_TS
TEMPORARY TABLESPACE TEMP;
– Grant quota on assigned tablespace
ALTER USER APEXAPPS QUOTA 10M ON APEXAPPS_TS ;
– Grant Role Priviledge
GRANT “CONNECT” TO APEXAPPS ;
ALTER USER APEXAPPS DEFAULT ROLE “CONNECT”;
– Grant system privileges
GRANT CREATE JOB TO APEXAPPS ;
GRANT CREATE INDEXTYPE TO APEXAPPS ;
GRANT CREATE SYNONYM TO APEXAPPS ;
GRANT CREATE DIMENSION TO APEXAPPS ;
GRANT CREATE VIEW TO APEXAPPS ;
GRANT CREATE CLUSTER TO APEXAPPS ;
GRANT CREATE MATERIALIZED VIEW TO APEXAPPS ;
GRANT CREATE PROCEDURE TO APEXAPPS ;
GRANT CREATE ANY CONTEXT TO APEXAPPS ;
GRANT CREATE TYPE TO APEXAPPS ;
GRANT CREATE SEQUENCE TO APEXAPPS ;
GRANT CREATE OPERATOR TO APEXAPPS ;
GRANT CREATE TRIGGER TO APEXAPPS ;
GRANT CREATE TABLE TO APEXAPPS ;
– Grant Object Privileges
GRANT EXECUTE ON SYS.DBMS_RLS TO APEXAPPS ;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO APEXAPPS ;
GRANT EXECUTE ON CTXSYS.CTX_DOC TO APEXAPPS ;

These commands will create the schema and assign the same privileges to that schema that gets assigned when you create a new schema while creating the APEX workspace (verified in Oracle APEX 4.1). Once the schema is created specify ‘Yes’ for Re-use existing schema and then specify the schema name.

About 'ROWNUM' in Oracle

2011-03-09T09:52:00.002+06:00

ROWNUM is an Oracle pseudo column which numbers the rows in a result set.
SELECT rownum, table_name
FROM user_tables;
ROWNUM TABLE_NAME
————- —————–
1 EMP
2 DEPT
3 BONUS
4 SALGRADE
5 DUMMY
5 rows selected
Here is a summary of how ROWNUM can be used.
Limiting Rows
ROWNUM can be used to limit the number of rows returned by a query in a similar way to LIMIT in Postgres and MySql, TOP in SQL Server and FETCH FIRST in DB2.
SELECT rownum, table_name
FROM user_tables
WHERE rownum <=3;
ROWNUM TABLE_NAME
————- —————–
1 EMP
2 DEPT
3 BONUS
3 rows selected
ROWNUM with DML
The use of ROWNUM is not restricted to select statements. It can be used with DML statements that update the database too.
CREATE TABLE o AS
SELECT *
FROM all_objects
WHERE rownum <= 1000;
Table created
UPDATE o
SET object_id = rownum,
created = created + INTERVAL '1' MINUTE * rownum
WHERE rownum 2;
RNUM TABLE_NAME
——– —————-
3 SALGRADE
4 DUMMY
5 DEPT
3 rows selected
You will notice that an inline view has been introduced to transform the ROWNUM pseudo column into a ‘real’ column before we do the comparison.
It is tempting to write the above SQL as follows.
SELECT table_name
FROM user_tables
WHERE rownum > 2;
TABLE_NAME
——————————
0 rows selected
However, this query will always return zero rows, regardless of the number of rows in the table.
To explain this behaviour, we need to understand how Oracle processes ROWNUM. When assigning ROWNUM to a row, Oracle starts at 1 and only only increments the value when a row is selected; that is, when all conditions in the WHERE clause are met. Since our condition requires that ROWNUM is greater than 2, no rows are selected and ROWNUM is never incremented beyond 1.
The bottom line is that conditions such as the following will work as expected.
.. WHERE rownum = 1;
.. WHERE rownum 10;
Top-n Query
Typically, a top-n query sorts data into the required sequence and then limits the output to a subset of rows.
For example, suppose we wish to retrieve the top three earners from our employee table.
SELECT ename, sal
FROM (
SELECT ename, sal
FROM emp
ORDER BY sal DESC)
WHERE rownum <=3;
ENAME SAL
———- ———
KING 5000
SCOTT 3000
FORD 3000
3 rows selected
The inline view (the inner select) sorts the rows and passes the result up to the outer select. The outer select then limits the output to three rows.
It may seem more natural to use the following SQL.
SELECT ename, sal
FROM emp
WHERE rownum <=3
ORDER BY sal DESC;
ENAME SAL
———- ———————-
ALLEN 1600
WARD 1250
SMITH 800
3 rows selected
However, this does not give us the result we want because Oracle assigns the ROWNUM values to the rows before it does the sort.
In this example, Oracle will retrieve three rows from the table, any three rows, and sort only these three rows. We really need Oracle to sort all the rows and then return the first three. The inline view will ensure that this will happen.
Sort Performance
Limiting rows on a sorted result set using ROWNUM can also provide an added performance benefit. Rather than physically sorting all the rows to retrieve just the top few, Oracle maintains an array which contains just the highest or the lowest values (depending on whether we specified ASC or DESC in the ORDER BY clause). The size of the array will be the number of rows we wish to return. As rows are processed, only the highest (or lowest) values are retained in the array. All other rows are discarded.
Pagination
Next, we will see how ROWNUM is used to select a range of rows from within a result set. This is useful if we are to provide pagination on a web screen, for example.
Suppose we are paging through the employee table in name order and we wish to display rows six to ten inclusive.
SELECT rnum, ename, job
FROM
(SELECT /*+ FIRST_ROWS(10) */ rownum rnum, ename, job
FROM
(SELECT ename, job
FROM emp
ORDER BY ename)
WHERE rownum 5;
RNUM ENAME JOB
——– ———- ———
6 JAMES CLERK
7 JONES MANAGER
8 KING PRESIDENT
9 MARTIN SALESMAN
10 MILLER CLERK
5 rows selected
We use nested inline views to retrieve and sort the data and then apply the range check using ROWNUM. We have split the upper and lower bound check, which allows Oracle to use COUNT(STOPKEY) in the execution plan when checking for ROWNUM <= 10. This is a performance optimization which, along with the sorting optimization described earlier, will ensure that our query runs efficiently as the table grows.
The FIRST_ROWS(n) hint also tells Oracle to optimize the query so that the first n rows are returned as quickly as possible.
Summary
ROWNUM provides a mechanism for returning a subset or range of rows from a query. It can be misleading at first if not properly understood but, once mastered, is invaluable for limiting result set output for pagination and top-n style queries.
For more information on ROWNUM, see Tom Kytes article on OTN.
For more information on Oracle, visit level up.

Why SEO doesn’t work?

2011-03-09T08:56:00.002+06:00

Many webmasters face the problem that their SEO campaigns don’t deliver the expected results. Why are your campaigns under performing? What can you do to make sure that search engine optimization works for you?
There can be several reasons why your SEO isn’t a success:
Wrong Goals
If your website doesn’t have many high rankings yet then you cannot expect that Google will display your site on the first result page for keywords such as “mp3″ or other very competitive one-word keywords.
You have to start with more targeted key phrases first. Optimize your pages for many different keywords with lower competition. The more high rankings your website has for keywords with lower competition, the more likely it is that your website will also get high rankings for more competitive keywords that belong to the same topic.
It’s like running a marathon. You have to run smaller distances first before you can run the full 26 miles and 385 yards.
Don’t Take SEO Seriously
Search engine optimization isn’t set-and-forget. It takes some time to make things happen. Search engine optimization is an investment into your company and it should be treated like that.
If all you do to ‘promote’ your website is to submit it to search engines then you won’t be successful. You have to invest time and effort into the optimization of your site. Tools can help you to save a lot of this time and effort but you still have to work with your site.
Focus Wrong Elements
Some webmasters are obsessed with the length of the title tag. Others submit their website every few days to search engines. Other webmasters insist that a particular part of their website links must use the rel=nofollow attribute.
You don’t have to chase the latest search engine optimization trend. These trend topics usually make the difference between position 8 and position 9. If your website isn’t listed on the first result page at all, you have to get the basics right.
The most important factors that will get your website on Google’s first result page are optimized web pages with good content with a tool and good back links with the IBP link improver.
Wrong Keywords
This is an extremely common mistake that many webmasters make. If you choose the wrong keywords, you will waste a lot of time and money.
The best keywords for your website are not the keywords with the biggest search volume. The best keywords also aren’t the keywords that will boost your ego and it’s also not the “obvious” keywords that will work best for SEO.
The best keywords for SEO are the keywords that deliver targeted visitors who will buy. It does not matter if a keyword has thousands of searches. If none of the visitors who find your site through that keyword will buy, then this keyword won’t do you any good.
Wrong Links
To get high rankings on Google, your website must have good back links. Automatic links from link building schemes don’t work. Actually, that kind of links can even get you in trouble with Google.
You must get the right kind of back links to succeed. Use professional link management tools and consider purchasing text links from a quality site.
Summary
Search engine optimization can contribute greatly to the success of your website. It’s important that you do the right things in the right order and that you focus on the right elements. If you can tick all boxes in the checklist, your website is ready to get top 10 rankings on Google for your most important keywords.

Convert Viedo to .Flv Using c#.net on Web

2010-01-24T19:06:00.002+06:00

The method to convert video to .flv is too easy. You can downlaod following files from here or .net.
1) ffmpeg.exe
2) ffplay.exe
3) pthreadGC2.dll
After dowloading all the files
Follow the steps wrtitren:-
1)Make a new .net web site or windows application.
2)Copy and paste all the 3 above written files to root location
3)Copy and Paste code written below
4)Put an upload to page and rename to “fileuploadImageVideo”
5)put and button and rename to btn_Submit
6)Make 3 folders OriginalVideo, ConvertVideo, Thumbs
7)Import Class “using System.IO;”



private bool ReturnVideo(string fileName)

{

string html = string.Empty;

//rename if file already exists

int j = 0;
string AppPath;
string inputPath;
string outputPath;
string imgpath;
AppPath = Request.PhysicalApplicationPath;
//Get the application path
inputPath = AppPath + "OriginalVideo";
//Path of the original file
outputPath = AppPath + "ConvertVideo";
//Path of the converted file
imgpath = AppPath + "Thumbs";
//Path of the preview file
string filepath = Server.MapPath("~/OriginalVideo/" + fileName);
while (File.Exists(filepath))
{
j = j + 1;
int dotPos = fileName.LastIndexOf(".");
string namewithoutext = fileName.Substring(0, dotPos);
string ext = fileName.Substring(dotPos + 1);
fileName = namewithoutext + j + "." + ext;
filepath = Server.MapPath("~/OriginalVideo/" + fileName);
}
try
{
this.fileuploadImageVideo.SaveAs(filepath);
}
catch
{
return false;
}
string outPutFile;
outPutFile = "~/OriginalVideo/" + fileName;
int i = this.fileuploadImageVideo.PostedFile.ContentLength;
System.IO.FileInfo a = new System.IO.FileInfo(Server.MapPath(outPutFile));
while (a.Exists == false)
{
}
long b = a.Length;
while (i != b)
{
}
string cmd = " -i \"" + inputPath + "\\" + fileName + "\" \"" + outputPath + "\\" + fileName.Remove(fileName.IndexOf(".")) + ".flv" + "\"";
ConvertNow(cmd);
string imgargs = " -i \"" + outputPath + "\\" + fileName.Remove(fileName.IndexOf(".")) + ".flv" + "\" -f image2 -ss 1 -vframes 1 -s 280x200 -an \"" + imgpath + "\\" + fileName.Remove(fileName.IndexOf(".")) + ".jpg" + "\"";
ConvertNow(imgargs);
return true;
}
private void ConvertNow(string cmd)
{
string exepath;
string AppPath = Request.PhysicalApplicationPath;
//Get the application path
exepath = AppPath + "ffmpeg.exe";
System.Diagnostics.Process proc = new System.Diagnostics.Process();
proc.StartInfo.FileName = exepath;
//Path of exe that will be executed, only for "filebuffer" it will be "flvtool2.exe"
proc.StartInfo.Arguments = cmd;
//The command which will be executed
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.CreateNoWindow = true;
proc.StartInfo.RedirectStandardOutput = false;
proc.Start();
while (proc.HasExited == false)
{
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
ReturnVideo(this.fileuploadImageVideo.FileName.ToString());
}

Now run the application select a video file, that will get converted and come to ConvertVideo Folder
Download Full Project.
Reference: http://forums.asp.net/t/1356425.aspx

CSS Positioning - Some pointers

2008-03-12T17:30:00.000+06:00

1. Absolute Absolute positioning is absolute in relation to the parent element. In this case the parent element is the whole document, so the div is positioned absolutley at 0,0 and will apear in the top left corner.

2. Relative This positions the element relative to where it would have been in the document. Useful for moving something down or across a few pixels for example. In the diagram, the black dashed outline shows where the div would have been without positioning.

3. Relative and Absolute An example of absolute and relative positioning. The outer green box is positioned relative to where it would have been, whilst the inner box is positioned absolutely in relation to the parent green box.

4. float This is where the element in question "hovers" left or right, much like aligning an image left or right works in plain HTML.

6. 3 Column layout Here's where it gets fun. Below is a classic 3 column layout with the left and right DIV floated correspondingly left and right, and the middle DIV without any positioning at all.

Link to me!

If you use any of the code on this site (and if you don't I guess) or it makes your life easier, I'd appreciate a backlink. The more traffic I get, the more people I can annoy... :-)

About Me

2008-03-12T16:14:00.000+06:00

Hello! I am S.M. Saidur Rahman (Rana) Currently i am working at Sumcynet Limited as a Senior programmer. It is my own site. The main reason which has forced me to publish this site is to expose myself to the world. I think my effort will be successful if this site benefits you a bit.

In this site you will get different type of helps concerning computer related problem. You will find different solutions of programming and other problems which are mainly encountered in developing professional software design. This site also contains different software tools designed by me. I also highly encourage you to post your different ICT (Information and Communication Technology) based queries. I will try the best to answer your queries.

Here is a comprehensive list what I am and What I am not, what I like and what I dont. I hope you will enjoy.

I dont like tell lie any more
I like to sleep too much, but I usually dont get much time for that
I love songs from Sonu Nigam and other clasical singer.
I wish that I could be a PHP Fanatic
I love eating Khichuri with fry (Fish or Meat)
I dont like lazy peoples, thought I am one of them.
I love reading classics novels
I am a Computer Engineer