And Miles to Go Before I Sleep

Search for Love? :P

2011-12-07T14:54:00.000+06:00

Are you searching for LOVE?
Go to www.google.com and search the following line:

(sqrt(cos(x))*cos(100 x)+sqrt(abs(x))-0.7)*(4-x*x)^0.01

enter search button.
I hope you will find love :P

Javascript: back to previous page button

2011-11-28T13:02:00.001+06:00

And the Javascript Code:

 <input type="button" id="btnPrint" onclick="window.print();" value="Print Service Order" />

Live Traffic Feed widget in HTML for Wordpress Blogs

2011-10-06T12:09:00.001+06:00

this is the link for HTML widget

A crative, wonderful, amazing website

2011-10-05T23:20:00.001+06:00

NEAVE.com

Opening a pop up window using Javascript

2011-10-04T17:56:00.003+06:00

I was in need of a JS function of opening a pop up window. I found a wonderful tutorial about this from Here Here is the Javascript Function for POP UP window named popitup()

 <script type="text/javascript">//  
 function popitup(url) {  
 newwindow=window.open(url,'name','scrollbars,height=500,width=500','scrollbars');  
 if (window.focus) {newwindow.focus()}  
 return false;  
 }  
 </script>

The interesting part is, the the window.open() function. The arguments of this function are mainly three. First one is URL, second is NAME. and in third one we can put many characteristics of the popup window. they will have to be in a single quotation mark and distinguished by comma(,) For example, see the above window.open function window.open(url,'name','scrollbars,height=500,width=500'). Here after url, name, all other scrollbars, height, width are taken in the single quotation marks.

More functionality can be added in this THIRD part of the argument of window.open() function:

dependent
directories
fullscreen
location
menubar
resizable
scrollbars
status
toolbar
top=200
left=400
width=200
height=200
screenX=400
screenY=200

 <a onclick="return popitup('popupex.html')" href="popupex.html">Link to popup</a>

sending php array variable as link to argument of javascript function

2011-10-04T17:33:00.001+06:00

I have got a javascript function popitup() which will be used for opening a pop up window. I have PHP Array variable $row_rstest['id'] which holds the ID of a data set fetched from database.
I have a page named print_data.php. To view the data of this page the url should be like print.data?id=12
I have taken this in variable $url.

 <?php $url = "print_data.php?id=".$row_rstest['id']; ?>

Then passed this $url in function popitup(). The important thing is to put the sign (') around $url variable. Otherwise the function didn't work for link.

 <?php echo "<a href=\"\" onClick=\"return popitup('$url') \">Click here to open a pop up window</a>";

jquery plugin: Autocomplete

2011-10-04T13:05:00.000+06:00

here is the link for autocomplete plugin

google code project

Hide Print Button While Printing A Page

2011-10-03T18:06:00.001+06:00

I was in a problem today. I tried to print a page which I developed in PHP. I inserted a PRINT button in it. but while I was using JS function window.print() which was printing my PRINT button too! So I took the help of CSS to solve the problem. just used 3 line codes before the button. I named the button id as "btnPrint" and in CSS it was set as display:none. So while the page was being printed, the button was not!

You can follow the code! it's simple :)

 <style type="text/css">  
 @media print {  
 input#btnPrint {  
 display: none;  
 }  
 }  
 </style>  
 <input type="button" id="btnPrint" onclick="window.print();" value="Print Page" />

Names of Images Saved in PHP Server Root Are Case Sensitive

2011-09-27T23:27:00.000+06:00

I used some images in my PHP scripts. I typed the perfect names of images (eg chair.jpg) in my PHP script. Though in my web root directory, the images are stored by the same name, in output, I didn't find the images.

Later I found that, the image was named like "checked.PNG" in my web root. But in my program, it was "checked.png".
For having lower case in my code [png] but main image was in upper case [PNG], I didn't find the image in output screen after loading.

This scenario doesn't happen always. It varies! I found output the other time though the extension was different [one was in upper case and the other in lower case]

Simple JavaScript code to print a page

2011-09-27T16:59:00.002+06:00

 <SCRIPT LANGUAGE="JavaScript">   
  if (window.print) {   
  document.write('<form><input type=button name=print value="Print" onClick="window.print()"></form>');   
  }   
  </script>

Or to put a hyperlink on an image, the following code is nice:

  <a href="javascript:window.print()"><img src="images/forward.png"></a>

how to create a php website template from scratch

2011-09-27T12:17:00.000+06:00

i found this link interesting, will check later

Inserting form variables into mysql database query string

2011-09-26T22:46:00.001+06:00

I was working with a form where I need to insert some form variables in my MySQL database. Inserting data into database is not any problematic issue. But as I had to insert dynamic data contained by the form variables, I faced a little problem. The solution is very very simple! :)

 //variables will contain the data stored in the form variable id, hod, status  
 $soid = $_POST['id'];  
 $employeeid = $_POST['hod'];  
 $statusto = $_POST['status'];  
 // the is the SQL query to insert into database  
 $sql = "INSERT INTO `service_order`.`change_log` (`service_order_id`, `employee_id`, `changed_to`) VALUES ('".$soid."', '".$employeeid."', '".$statusto."')";

the most important thing is -- putting the dot(.) and double quotation(") and single quotation(') around the variables $soid, $employeeid and $satusto

For not using these three symbols properly, I found errors in my program

Be Creative Everyday!! Draw Stickman

2011-09-22T19:47:00.000+06:00

A wonderful site for few minutes. I will refer it to people to have few minutes of fun... :)

Check this link

websites of test on puzzles of analytical reasoning

2011-09-20T10:12:00.000+06:00

don't know why, puzzles seemed really unavailable in the whole internet. I tried to find some, here they go:

Puzzle Choice -- based on logic
Freshers Online: Aptitude and Puzzle Test
Best Sample Questions
Queendom : tests
questions: indiastudychannel
test preview
Indiabix: Logical reasoning test

Comparing date type variables as form inputs in PHP

2011-09-19T21:16:00.001+06:00

I was working with a search module where I needed to work upon the user "date" inputs. The form inputs of dates were string type like "2011-05-06". I had to confirm few things:
-- if both of the input fields [said as $var6 and $var7] are blank or not.
-- if first one [$var6] is filled only
-- if second date [$var7] is filled only
-- user can give two dates in any order. BUT MYSQL 'BETWEEN' command [which I used to compare two dates] expects the first argument as early number and second one as big number. so I had to swap two numbers in proper order
here goes some additional needless info,
$var6 = @$_GET['date_1'] ;
$var7 = @$_GET['date_2'] ;
$wh = "WHERE"; //initializing variable
$cond6 = ""; // initializing variable

[sourcecode language="php"]

 // this is for date variables var6 and var7 is date variable  
 if($var6 == "0000-00-00") //as blank inputs came in this format, I made them NULL  
 {  
 $var6 = "";  
 }  
 if($var7 == "0000-00-00")  
 {  
 $var7 = "";  
 }  
 if($var6 <> "") // input is given  
 {  
 if($var7 <> "") // input is given  
 {  
 if($var6 < $var7)  
 {  
 $cond6 = $wh." date BETWEEN "."'".$var6."'"." AND "."'".$var7."'";  
 }  
 if($var6 == $var7)  
 {  
 $cond6 = $wh." date = "."'".$var6."'";  
 }  
 if($var6 > $var7)  
 {  
 $var8 = $var7;  
 $var9 = $var6;  
 $cond6 = $wh." date BETWEEN "."'".$var8."'"." AND "."'".$var9."'";  
 }  
 }  
 if($var7 == "")  
 {  
 $cond6 = $wh." date = "."'".$var6."'";  
 }  
 }  
 if($var6 = "")  
 {  
 if($var7 <> "")  
 {  
 $cond6 = $wh." date = "."'".$var7."'";  
 }  
 if($var7 == "")  
 {  
 $cond6 = "";  
 }  
 }

PS: $cond6 is the variable here which I used to make a part of a whole SQL string.
Whole string was like:
[sourcecode language="sql"]

 $query = "SELECT * from Mahmud WHERE".$condition;

Here goes the $condition which I used:

[sourcecode language="php"]

 $condition = $cond1.$cond2.$cond3.$cond4.$cond5.$cond6;

Word Dynamo : by Dictionary.com

2011-09-19T09:14:00.000+06:00

Word Dynamo a new arrangement by the Dictionary.com has been introduced. There are standardized test for various exams like

Error: mysql_num_rows() expects parameter 1 to be resource

2011-09-15T20:04:00.003+06:00

I was trying to pull some values from Database using PHP. My DB is MySQL. Suddenly I found the error:

mysql_num_rows() expects parameter 1 to be resource, boolean given in

I was trying to find out the problem. I went through the forum post in Daniweb after googling

Finally I fixed it. What was TROLLING is just a [ ' ' ] sign

My query which was giving error:

 $query = "select * from service_order where account_manager_id = $var AND primary_connection_media= $var2";

When I fixed the error by putting '' around the variables, the query is:

 $query = "select * from service_order where account_manager_id = '$var' AND primary_connection_media= '$var2'";

A wonderful Calendar for picking date in PHP Input/Update forms

2011-07-31T17:46:00.001+06:00

I was writing PHP scripts the other day where I needed a calendar to pick dates. My user needs to pick date of any month or year. Problem was -- Manual input of dates are tiresome and inefficient. On the other hand, if inputs are in string, I need to convert them to "datetime" as my datatype is such in the MySQL DB.

I found a wonderful Calendar a website. He made it in javascript and works very well. There are several layouts in the calendar from which developers can choose anyone. The more important thing is, you just need to pass the PHP variable which will store into the DB. You can have this Javascript Calendar from downloading from this link .

This code segment is for taking input and inserting into database

 /*include this section*/  
 <?php require_once('calendar/classes/tc_calendar.php'); ?>  
 <!-- calender js link-->  
 <script language="javascript" src="calendar/calendar.js"></script>  
 <!-- finished-->  
 <?php  
 $myCalendar = new tc_calendar("date5", true, false); //date5 is similar to the column name of DB  
 $myCalendar->setIcon("calendar/images/iconCalendar.gif");  
 $myCalendar->setDate(date('d'), date('m'), date('Y'));  
 $myCalendar->setPath("calendar/");  
 $myCalendar->setYearInterval(2000, 2015);  
 $myCalendar->dateAllow('2008-05-13', '2015-03-01');  
 $myCalendar->setDateFormat('j F Y');  
 $myCalendar->setAlignment('left', 'bottom');  
 $myCalendar->setSpecificDate(array("2011-04-01", "2011-04-04", "2011-12-25"), 0, 'year');  
 $myCalendar->setSpecificDate(array("2011-04-10", "2011-04-14"), 0, 'month');  
 $myCalendar->setSpecificDate(array("2011-06-01"), 0, '');  
 $myCalendar->writeScript();  
 ?>

This code segment is for Updating date into database
You need to bring out a variable ($BIRTHDAY in this example) that is used to extract data from DB. like, if you use and array like mysql_fetch_array($birthday) to extract data from DB. you can use $BIRTHDAY = mysql_fetch_array($birthday). The code segment will make clear everything I believe.

 /*include this section*/  
 <?php require_once('calendar/classes/tc_calendar.php'); ?>  
 <!-- calender js link-->  
 <script language="javascript" src="calendar/calendar.js"></script>  
 <!-- finished-->  
 <?php  
 $myCalendar = new tc_calendar("date1", true, true);  
 $myCalendar->zindex = 150; //default 1  
 $myCalendar->setIcon("calendar/images/iconCalendar.gif");  
 $myCalendar->setPath("calendar/");  
 if(isset($BIRTHDAY))  
 /*this portion works to show DB date to form*/  
 {  
 $birth_day = strtotime($BIRTHDAY); //$BIRTHDAY is the variable extracted from DB  
 $myCalendar->setDate(date('d',$birth_day), date('m',$birth_day), date('Y',$birth_day));  
 }  
 /*tricky portion ends here*/  
 $myCalendar->setYearInterval(1935, date('Y'));  
 $myCalendar->dateAllow('1935-01-01', date('Y-m-d'));  
 $myCalendar->writeScript();  
 ?>

Push Pop program for 8086 microprocessor

2011-07-14T04:49:00.001+06:00

[sourcecode language="cpp"]

 CODE SEGMENT  
 ASSUME CS:CODE,DS:CODE,SS:CODE  
 ORG 1000H  
 MOV AX,0000H  
 MOV DS,AX  
 MOV SS,AX  
 MOV AL,100  
 MOV BL,00H  
 CALL RANDOM  
 INT 3  
 RANDOM PROC NEAR  
 PUSHF  
 PUSH CX  
 PUSH DX  
 MOV CL,AL  
 MOV AX,0000H  
 MOV AL,17  
 MOV DL,SEED  
 MUL DL  
 ADD AX,0043  
 DIV CL  
 MOV BL,AH  
 MOV SEED,AH  
 POP DX  
 POP CX  
 POPF  
 RET  
 RANDOM ENDP  
 ; SEED VALUE  
 ORG 1500H  
 SEED DB 27  
 CODE ENDS  
 END

Wonderful website for CSS

2011-07-12T18:01:00.000+06:00

Roger Johansson's website http://www.456bereastreet.com/ is a nice place for CSS.
I enjoyed visiting it.
Will do in future too! :)

Simple Aptitude Tests

2011-07-11T13:17:00.001+06:00

This is a good website, they provide solutions and causes for the answers after submitting the answers.

Blogger Template I loved

2011-07-11T10:20:00.000+06:00

Paradise Valley by Ray Creations.

This is kept for future :-)

Insert, Update, Delete in PHP using Dreamweaver CS5

2011-06-30T00:16:00.000+06:00

Adding data to database using input in Forms

We often need to insert data into database. We use forms to post the Data. This process is often lengthy and tiresome. You can easily insert data to Database Using Dreamweaver with almost no hand coding. If you are already familiar with DreamweaverCS5, just need to follow the steps below:

Insert a form

You can use tables to show the labels and Text fields and Lists for input

If you want to use a list Dynamic (that will show data in list items fetching somewhere from database), you need to do 2 things:

1. If menu items are from other table, create a Record set using SQL queries that will select the List Items.
2. Select the expected menu list in the form, go to: Properties > Dynamic
§ Dynamic List: Options from recordset (select your Recordset)
§ Select the Values (it is ID in most cases, you chose yours)
§ Label (selects the label of the Menu List)
§ As the value need to match any column of your existing Main recordset ( the main table where you want to insert data), select the SELECT EQUAL VALUE TO for the option.

Server Behavior > Insert Records > Select Tables (chose in which table you want to insert data)

o Try to select the primary key of that Table in the ID section that is to select
o You can select where to go back after inserting data.
Tips: If you create the names of fields of Form according to the names of DB columns, DW (Dreamweaver) finds and matches those fields automatically during Insert Options, including their datatypes

Making List of Expected Data Using Dreamweaver

Suppose I want to show a list that includes the information about the students of the class. You need to have a database.

Connect to database

Creating a record set using BINDINGS PANEL (I need to use the perfect SQL here. There are ‘Simple’ and ‘Advanced’ options)

Go To : Insert > Data Objects > Dynamic Data > Dynamic Table

o Thus a list is generated. You can select how many rows you want to show in the list.
o You can set First, Previous , Next, Last links about the list
o Write FIRST anywhere, select this text, go to: Server Behavior > Recordset Paging > First/Previous/Next/Last
o If you don’t want to show ‘First’ link in first page, go to: Server Behavior > Show Region

Updating data using input in Forms

Binding > Recordset (new) which table of data I am going to update

o Default SQL filtered by Primary Key
o Filter = URL parameter = ID **

Create the Form with text fields and lists…

o Click on the field > Properties > init value
o For list à dynamic > ID label fix > init value

In action, need to pass ‘’hidden data entry form’’

o Put cursor inside FORM.
o Insert > form > hidden field
o Click on design panel’s Hidden value à Id (which is PK ) as init value

Find the hidden value, if not there, go to FIND ALL à ID = PK

o If this is ‘’-1’’ then make it 1

Go to Server Behavior à Update Record <value> FORM.pk as id

When you make link to EDIT page:

o List page where id of specific entry is available
o Make anyplace linked for ‘’update now’’ à properties > link >update.php
o Go to Code view à <a href = “update.php?id=**here is binding panel >recordset > id**>

Deleting data list in DW

Blank page, clear everything:

Server behavior > Delete records > primary key value > id

Fist where to go after deletion

Now run the page.

o If nothing is there, go to CODE
o Find “delete go to{ …..} “ this portion out of the logical if segment and before the last brace.

Link this file where to DELETE. In this linking, the link alphabetical case is factor, so need to be careful.

In the world of Infographics

2011-06-29T16:07:00.000+06:00

The thing enchanted me suddenly. In a graphical representation, how the Huge information can be served! this is amazingly touchy. loved this.
I can present information to my readers in an info-graphics though they don't have the intention to read so many things with text ( because I don't love reading so many texts !) LOL :P

http://www.good.is/infographics

http://www.coolinfographics.com/

Video Conversion Settings Parameters

2011-06-27T17:40:00.000+06:00

I was trying to convert a video for my mobile phone which supports 320 * 240 videos
But there are some additional settings that was creating problems for the smooth running of the video by my mobile video player. Later it worked good on:

Video
Frame rate : 23.97 fps
Bit rate: 384 kbps

Audio

Sample rate: 22050 Hz
Bit rate: 64 kbps