Computer Languages

Dress up games

noreply@blogger.com (Basis-Consultant) — Mon, 17 Jan 2011 03:21:00 +0000

just found an amazing dressup games site...

General: Editors for Programming

noreply@blogger.com (Basis-Consultant) — Fri, 13 Mar 2009 21:51:00 +0000

Using a good editor helps in reducing time. IF youa coding or programming things for some custom programs like matlab is suggest you use the editor provided by them since it always have all features required. But for coding other programing languages like php,html,c ,c++ i suggest notepad++.
There are lots of attractive features that make notepad++ appealing.
I like the tabbed interface.
There are other plugins like function list and auto-completion which makes coding easy and faster.
To enable auto-completion you have to press ctrl+space.
Get Notepad++ here

How to stop iframe from scrolling

noreply@blogger.com (Basis-Consultant) — Fri, 09 Jan 2009 19:45:00 +0000

How to stop scrolling in IFRAME?
you have to add scrolling="no" in the iframe tag to stop iframe from scrolling.

Example

<iframe src="http://www.google.com" scrolling="no" width="400" height="400"> </iframe>

Here is the output

SQL: What is Null Value

noreply@blogger.com (Basis-Consultant) — Thu, 01 Jan 2009 00:59:00 +0000

In SQL a null value is undefined or inapplicable or the field has no value assigned or defined. It is not equal to zero or space. Zero is a number and space is a character. Null is undefined value. Any rows of any data type can contain a null unless the column defined has primary key or is set not null ( which means the column cannot contain null values).
If a table field is null you see a value like null when you run a query which fetches data from that table.

SQL: The Select Statement tutorial 1

noreply@blogger.com (Basis-Consultant) — Wed, 31 Dec 2008 19:22:00 +0000

SELECT statement falls under DQL (Data Query Language ) of SQL. It is used to query or retrieve data from sql. Here is a sample table for use to practise. The table name is trees.

+-----------------------------------------Table--------------------------------------+

PlotID	TreeTagNumber	SpeciesID	DBH	Height	Researcher	Date
110	461	5	3.00	4.00	Fernando	1999-01-01
110	462	51	19.30	25.73	Fernando	1999-01-01
110	465	76	4.10	5.46	Fernando	1999-01-01
110	466	76	4.50	6.00	Fernando	1999-01-01
110	467	76	4.40	5.86	Fernando	1999-01-01
110	468	76	9.50	12.66	Fernando	1999-01-01
110	469	76	5.30	7.06	Fernando	1999-01-01
110	470	62	7.20	9.60	Fernando	1999-01-01
110	471	62	3.40	4.53	Fernando	1999-01-01
110	472	62	7.10	9.46	Fernando	1999-01-01

+-------------------------------------------+------------------------------------------+

SELECT * from trees;

GENERIC SYNTAX below

SELECT * from TABLENAME

This is show all the columns and rows in table trees. If you want to see only specific columns you have to issue the sql command like this

[GENERIC FORMAT]

SELECT column1,column2 from TABLENAME

column1 & column2 are column names in the table.

SELECT PlotID,TreeTagNumber from trees;

This command displays only PlotID and TreeTagNumber from above table. The output will be like this

+------------------------------------OUTPUT------------------------------------------+

PlotID	TreeTagNumber
110	461
110	462
110	465
110	466
110	467
110	468
110	469
110	470
110	471
110	472

+-------------------------------------------+------------------------------------------+

SQL: Types of sub languages in SQL

noreply@blogger.com (Basis-Consultant) — Tue, 30 Dec 2008 20:40:00 +0000

All commands of sql fall in one of the following categories.

DDL (Data Definition Language)

These statements are used to create tables and databases and define field properties or table properties. Examples of commands that fall in this category are CREATE,ALTER and DROP statements

2. DML (Data Manipulation Language)
The statements that falls under this category are used to update data or add or remove data from tables. UPDATE, DELETE and INSERT commands fall under this category.

3. DCL (Data Control Language)
It is used to control who access the data. The commands that come under this category are GRANT and REVOKE

4. TCL (Transaction Control Language)
This language is used to commit data and restore data. COMMIT and ROLLBACK falls under this category.

5. DQL (Data Query Language)
This is to retrieve data from sql server. SELECT statement falls in this category.

All above languages are SQL. They are just categories of SQL. they are not different from SQL.

SQL:What is sql statement

noreply@blogger.com (Basis-Consultant) — Mon, 29 Dec 2008 08:52:00 +0000

To retrieve or manipulate data present in tables of a database we issue some commands to the server. They are called sql statements. One of the sql statement is

SELECT * from titles;

In above statement we are calling for all rows in the table to be displayed.

SQL: What is SQL

noreply@blogger.com (Basis-Consultant) — Mon, 29 Dec 2008 04:16:00 +0000

SQL stands for Structured Query Language. It is used to retrieve and manipulate data in database. SQL can enter data into database
SQL can update data in database
SQL can remove data from database
SQL can add tables in database
remove or add fields in a table
retrieve data using specific criteria in database etc

SQL: What is a table

noreply@blogger.com (Basis-Consultant) — Sun, 28 Dec 2008 23:54:00 +0000

Table is a set of values arranged in rows and columns as shown in figure. Each values is place in an area called field and vertical list of values is called column. Horizontal List of values is called a row. In database server normally we store information in tables as shown in below figure. Table contains information in very easily presentable format. You can access information from these tables using sql commands.

JAVA: Tutorials List and Resources

noreply@blogger.com (Basis-Consultant) — Sat, 27 Dec 2008 07:01:00 +0000

1) Very Comprehensive Tutorials by the official java developers. No need for any book. Just learn all you want to know about java with ample example for each concept.

Download Them
View These Tutorials Online

2) This is a huge list of comprehensive tutorials
http://www.java2s.com/Tutorial/Java/CatalogJava.htm

3)IF you don't like ads n all go here. It just plain list of tutorials on a single page
http://www.cafeaulait.org/javatutorial.html

4)Lee point's Java Notes. This notes is useful in practical problems and you will need to refer this at least once in your project work
http://www.leepoint.net/notes-java/index.html

5)Java Boot Camp
http://www.javapassion.com/javaintro/
NO programming experience required to read this tutorials. Really good ones

6) Java Swing Tutorials.
http://java.sun.com/developer/onlineTraining/GUI/Swing1/shortcourse.html

Very Simple and Straight forward. Easy to understand with lots of examples

PHP: Software for php Development

noreply@blogger.com (Basis-Consultant) — Thu, 25 Dec 2008 19:15:00 +0000

\
I just found this XAMPP. This is preconfigured apache,php + mysql. You can just download the zip file and extract it and use it any where. No installation required. It has all configured. You can use notepad++ to edit your php files. Place you files in htdocs folder and run xampp_start. Xampp will be running after mysql and apache has started. I have been carrying this in my usb drive for one month i can use it on any computer. Just go to the xampp folder and run xampp_start.exe file and your PHP development environment is running :)

After running the xampp_start.exe file you will see the following screen if xampp starts succesfully. If the screen disappears then there must be some problem. Then run setup_xampp.bat to reconfigure xampp for that system. Now run xampp_start.exe again.

This is the quote from their website about windows version

The distribution for Windows 98, NT, 2000, 2003, XP and Vista. This version contains: Apache, MySQL, PHP + PEAR, Perl, mod_php, mod_perl, mod_ssl, OpenSSL, phpMyAdmin, Webalizer, Mercury Mail Transport System for Win32 and NetWare Systems v3.32, Ming, JpGraph, FileZilla FTP Server, mcrypt, eAccelerator, SQLite, and WEB-DAV + mod_auth_mysql.

Run xampp_control.exe to see the current status of applications running. Here apache and mysql must be running for you to create advanced applications in php that use database.

Make sure that apache is running.

Get Xampp Here
Get Notepad++ Here

PHP: Function to replace pattern of characters in a String

noreply@blogger.com (Basis-Consultant) — Thu, 25 Dec 2008 18:51:00 +0000

The functions str_replace is used to replace particular sequence of characters in a string.
Usage

str_replace(find,replace,str)
here
find --> sequence of characters to be replaced
replace --> sequence of characters with which it is to be replaced
str --> the string inwhich modifications must be done.

example

str_replace("ad","br","google ads");

the out put will be

google brs

PHP: Passing Variables from One Page to Another

noreply@blogger.com (Basis-Consultant) — Thu, 25 Dec 2008 02:08:00 +0000

There are two methods by which one can pass variables from one page to another. One is GET method and the other is POST method.
In GET method we pass the variables and their value in the url like

http://urtl.com/video.php?var1=xxx&var2=xxx2

etc and you fetch the variables using $_GET

$title = $_GET["var1"];
$title2 = $_GET["var2"];

Post method is used in form. When form is submitted the values are passed from the text fields to the destination page. We retrieve the values as

$title = $_POST["varl1"];

where var1 is the name or id of the form text element or the element of the form which contains specific data we are requesting.

JAVA: The values boolean can be assigned

noreply@blogger.com (Basis-Consultant) — Wed, 24 Dec 2008 06:06:00 +0000

Boolean is one of the data type in java.

I has only two values true and false.
True & False or TRUE and FALSE are different from true and false.

the boolean values are defined constants in java language

JAVA:Renaming Files

noreply@blogger.com (Basis-Consultant) — Mon, 22 Dec 2008 17:47:00 +0000

To rename a file in java you first declare the file variable with oldname and next one with newname and
file1.rename2(file2);


   public static void renamedirectory(String oldname,String newname){
           // File (or directory) with old name
 
   File file = new File(oldname);

   // File (or directory) with new name
   File file2 = new File(newname);
 
   // Rename file (or directory)
   boolean success =false;
   if(file.isDirectory()){
   success = file.renameTo(file2);
   } else {
   System.out.println("The file is not a directory "+oldname) ;
   }
   if (!success) {
      System.out.println("File was not successfully renamed");
   } else {
   System.out.println("File Renamed from "+oldname+" to "+newname);
   }
   }

The above function prints out if it doesnot rename succesfully.

PHP: Renaming File

noreply@blogger.com (Basis-Consultant) — Mon, 22 Dec 2008 07:56:00 +0000

To rename a file in php use
rename();

you use the function like

rename("oldname", "newname");

you have to include the path to file if it is present in sub directories where your php script is present.

Matlab: Inline Functions

noreply@blogger.com (Basis-Consultant) — Mon, 22 Dec 2008 01:06:00 +0000

There are great utilities in Matlab called inline functions. These are like macros in C.
you can define a functions of two or three variables or a single variable in matlab.

this is the syntax...

f = inline('expression','arg1,'arg2')

and you call the function as

f(x,y)

now if you need to define x+y in matlab you need to write as

f = inline('x+y','x','y');

by the way single quotes are necessary.

you call the function as
f(x,y);

f(1,2) gives results 3..

just paste the following lines in matlab command windo and press enter for testing

f = inline('x+y','x','y')
f(2,3)

Njoy

MS Excel: Function to Extract Hypelinks from cells

noreply@blogger.com (Basis-Consultant) — Sat, 20 Dec 2008 23:23:00 +0000

This is function used to extract hyperlinks or urls from a cell in excel.
Open your excel sheet. Press Alt+F11. Then in the vba editor that appearrs go to menu
insert-->module. Paste the following function there and now press alt+q.

Function getURL(forThisCell As Range) As String
'VBA UDF for getting URLs from a cell if any
retVal = ""
If forThisCell.Hyperlinks(1).Address <> “” Then
retVal = forThisCell.Hyperlinks(1).Address
End If
getURL = retVal
End Function

Now if you want to extract link from the cell A1 then enter the following in any of the cell
=getURL(A1)

PHP: Function ucwords

noreply@blogger.com (Basis-Consultant) — Sat, 20 Dec 2008 10:07:00 +0000

This function ucwords capitalizes first alphabet of every word in a String and returns it. This is useful for converting or renaming files or directories..

usage:
$string = "name sake";
$stringresult = ucwords($string);

the result will be
Name Sake

PHP: Function Explode

noreply@blogger.com (Basis-Consultant) — Sat, 20 Dec 2008 09:04:00 +0000

This function is used to break or split a string in php into a number of substrings based on the criteria you give. Like if you want to break a line into substrings with ':' as delimiters

$string = "anna:johnny:maria";

$pieces = explode(":",$string);

for($num=0 ; $num< count($pieces); $num++){
echo $pieces[$num]."
";
}

?>

You will have the output as an array of strings...

anna
johnny
maria

It is really useful function when dealing with html codes or fetching files from other sites

JAVA: Deleting File

noreply@blogger.com (Basis-Consultant) — Sat, 20 Dec 2008 06:42:00 +0000

This function is to delete files in java. It first checks whether it exists or not next check for write access rights or permissions and then check if the directory is empty if the given file is a directory.


  public static void delfile(String fname){
  File f = new File(fname);
  //Check whether file exists or not
  if (!f.exists()){
      System.out.print("file doesnot exists");
  } else if (!f.canWrite()){
      System.out.print("write prtected");
  } else if (f.isDirectory()) {
    String[] files = f.list();
    if (files.length > 0){
        System.out.print("this is a directory");
    }
  }
  boolean success = f.delete();
  }

JAVA:Splitting a String

noreply@blogger.com (Basis-Consultant) — Fri, 19 Dec 2008 22:31:00 +0000

In java you can split a string into two strings based on the delimeter using function split().
Example Given below

String s1 = "You are a dog";
String[] pieces = s1.split(" ");

here we are splitting the string with " " (single space) as delimiter. The result will be a array of strings.. like

pieces[0] = You
pieces[1] = are
pieces[2] = a
pieces[3] = dog

JAVA:What is Difference between Swing and Awt?

noreply@blogger.com (Basis-Consultant) — Fri, 19 Dec 2008 22:05:00 +0000

Awt is old.
Swing is new.
Awt is heavy and slow.
Swing is Light and fast and has a lot of options.
Awt is limited in options.
Swing high performance..
So its always better to use swing than AWT

PHP:MySQL_fetch_array

noreply@blogger.com (Basis-Consultant) — Fri, 19 Dec 2008 09:35:00 +0000

This is the function used to fetch array from the query of database...
if $result is the result of query then

MySQL_fetch_array($result)

returns the row of the query as an array whose values can be accessed just like that of a normal array.

PHP: Getting List of Files in a Directory

noreply@blogger.com (Basis-Consultant) — Fri, 19 Dec 2008 09:28:00 +0000

This the function that returns you the list of files present in a directory as array...


function getlist($directory){
   $results = array();
   $handler = opendir($directory);
   while ($file = readdir($handler)) {
       if ($file != '.' && $file != '..')
           $results[] = $file;
   }
  closedir($handler);
  return $results;
}

PlotID	TreeTagNumber
110	461
110	462
110	465
110	466
110	467
110	468
110	469
110	470
110	471
110	472

PlotID	TreeTagNumber
110	461
110	462
110	465
110	466
110	467
110	468
110	469
110	470
110	471
110	472

PlotID	TreeTagNumber
110	461
110	462
110	465
110	466
110	467
110	468
110	469
110	470
110	471
110	472