Posts Tagged ‘php’

How to change XAMPP server port?

April 9th, 2013, posted in Microsoft, PHP
Share

How to change XAMPP server port?,port,xampp,xamp,wamp,windows,php,html,website making,website desiginning,ServerName

To Change The XAMPP Server Port Number

  1. Stop the XAMPP server, if it is running already.
  2. Open the file [XAMPP Installation Folder]/apache/conf/httpd.conf.
  3. Now search for the string *Listen 80 *(I’m assuming that your XAMPP was using the port 80. Otherwise, just search for the string ‘Listen’). This is the port number which XAMPP uses. Change this 80 to any other number which you prefer.
  4. Then search for the string ‘ServerName‘ and update the port number there also.
  5. Now save and re-start XAMPP server and you are done.

Why do we need to change the port number? Because, these days, it is very common that a web developer needs to have multiple web servers running, all at the same time. For example, an XAMPP server can be used to run the local WordPress blog, while a JBoss server also needs to be up for testing a java web applications. In such scenarios, if two or more servers are trying to use the same port number, then the late comer will fail to get the port. So, it becomes necessary to change any one server’s port number to avoid the conflict.

How to change XAMPP server port?,port,xampp,xamp,wamp,windows,php,html,website making,website desiginning,ServerName,port number

Share

PHP and HTML Marquee Tag

March 13th, 2013, posted in PHP
Share

This is one the best link to put marquee tags.
Helped mE a lot…
I hope will do to you guys as well…
Cheers..
😉

Link 1 : http://www.way2tutorial.com/html/html_marquee_tag.php

Link 2 : http://www.tutorialehtml.com/en/extras/marquee.php

Share

Link to “References & Resources For Programming “

February 19th, 2013, posted in Programming
Share

1.  Java

General

  1. Java mother site @ http://java.sun.com (or http://www.oracle.com/technetwork/java/index.html).
  2. Java Developers’ sites, in particular, http://java.net.


JDK
(aka Java SE)

  1. Java SE mother site @ http://java.sun.com/javase (or http://www.oracle.com/technetwork/java/javase/overview/index.html).
  2. JDK 7 API Documentation Online @ http://download.oracle.com/javase/7/docs/api/index.html.
  3. JDK 7 Documentation Online @ http://download.oracle.com/javase/7/docs/.
  4. Ken Arnold, James Gosling and David Holmes, “The Java Programming Language”, 4th Edition, 2005. (The defacto standard for Java Language, but does not seem to have been updated to cover the latest features?!)
  5. James Gosling, Bill Joy, Guy Steele and Gilad Bracha, “The Java Language Specification”, 3rd Edition, 2005. (The defacto standard for JVM, but does not seem to have been updated?!)
  6. JDK 7 Demos and Samples (to be downloaded @ http://www.oracle.com/technetwork/java/javase/downloads/index.html)

Books & Online Tutorials

  1. The online Java tutorial @ http://docs.oracle.com/javase/tutorial/. (The authoritative source.)
  2. Paul Deitel and Harvey Deitel, “Java How to Program”, 9th Edition, 2011. (A comprehensive reference for programmers.)
  3. Y. Daniel Liang, “Introduction to Java Programming”, 9th Edition, 2012. (Good text book for undergraduate Java courses.)
  4. Bruce Eckel, “Thinking in Java”, 4th edition, 2007. (Great book but has not been updated?!)


2.  HTML & CSS

Specifications

  1. HTML @ W3C (www.w3.org)
    1. HTML 4.01 Specification @ http://www.w3.org/TR/html401/.
    2. HTML 5 Draft Specification @ http://www.w3.org/TR/html5/.
  2. XHTML 1.0 Specification (W3C) @ http://www.w3.org/TR/xhtml1/.
  3. CSS Specification (W3C) @ http://www.w3.org/Style/CSS/.

Online Tutorials and Resources

  1. W3School Tutorials & References @ http://www.w3schools.com/.
  2. Mozilla Developers Network (MDN)

Books

  1. [TODO]

3.  Android

  1. Android mother site @ www.android.com.
  2. Android Developers @ developer.android.com.
  3. Andriod API Documentation @ http://developer.android.com/reference/packages.html.


4.  MySQL

MySQL Mother Site & Standards

  1. MySQL Mother Site @ www.mysql.com.
  2. MySQL 5.5 “Reference Manual” @ http://dev.mysql.com/doc/.
  3. MySQL 5.5 “SQL Statement Syntax” @ http://dev.mysql.com/doc/refman/5.5/en/sql-syntax.html.
  4. “ISO/IEC 9075 Information Technology – Database Languages SQL”: 1989 (SQL-89), 1992 (SQL-92 or SQL2), 1999 (SQL-99 or SQL3), 2003 (SQL-2003), 2006 (SQL-2006) and 2011 (SQL-2011).

Sample Databases

  1. MySQL Employees Sample Database @ http://dev.mysql.com/doc/employee/en/index.html.
  2. MySQL Sakila Sample Database @ http://dev.mysql.com/doc/sakila/en/index.html.
  3. Microsoft Nothwind Sample database @ http://www.microsoft.com/en-us/download/details.aspx?id=23654; MySQL port @ http://code.google.com/p/northwindextended.
  4. The “Classic Models” Retailer database @ http://www.mysqltutorial.org.

Books and Tutorials

  1. Codd E. F., “A Relational Model of Data for Large Shared Data Banks”, Communications of the ACM, vol. 13, issue 6, pp. 377–387, June 1970.
  2. (For Java Programmers) “JDBC Basics”, Java Online Tutorial @ http://download.oracle.com/javase/tutorial/jdbc/basics/index.html.
  3. Paul DuBois, “MySQL Developer’s Library”, 4th ed, 2009 (5th eds is probably available).
  4. http://mysqltutorial.org.
  5. Russell Dyer, “MySQL in a Nutshell”, 2nd ed, O’reilly, 2008.


5.  C Language

  1. Kernighan and Ritchie “The C Programming Language”, 2nd edition, 1988, (The “K&R”).
  2. Plauger, “The Standard C Library”, 1992, PrenticeHall.
  3. The Formal Specification of C Language:
    1. ISO/IEC 9899:2011 “Programming Languages. C” (The “C11”);
    2. ISO/IEC 9899:1999 “Programming Languages. C” (The “C99”);
    3. ISO/IEC 9899:1990 “Programming Languages. C” (The “C90”).

6.  C++ Language

  1. The Formal Specification for the C++ language:
    1. ISO/IEC 14882:2011 “Programming Language. C++” (The “C++11”);
    2. ISO/IEC 14882:2003 “Programming Language. C++” (The “C++03”);
    3. ISO/IEC 14882:1998 “Programming Language. C++” (The “C++98”).
  2. Bjarne Stroustrup (creator of C++), “The C++ Programming Language”.
  3. Bjarne Stroustrup, “The Design and Evolution of C++”.
  4. http://www.cplusplus.com (C++ documents, tutorials, library references).
  5. Stanley B. Lippman & Josee Lajoie, “C++ Primer”.
  6. Deitel & Deitel, “C++ How to Program”.
  7. Gary J. Bronson, “Program Development and Design using C++”.
Share

Link to "References & Resources For Programming "

February 19th, 2013, posted in Programming
Share

1.  Java

General

  1. Java mother site @ http://java.sun.com (or http://www.oracle.com/technetwork/java/index.html).
  2. Java Developers’ sites, in particular, http://java.net.


JDK
(aka Java SE)

  1. Java SE mother site @ http://java.sun.com/javase (or http://www.oracle.com/technetwork/java/javase/overview/index.html).
  2. JDK 7 API Documentation Online @ http://download.oracle.com/javase/7/docs/api/index.html.
  3. JDK 7 Documentation Online @ http://download.oracle.com/javase/7/docs/.
  4. Ken Arnold, James Gosling and David Holmes, “The Java Programming Language”, 4th Edition, 2005. (The defacto standard for Java Language, but does not seem to have been updated to cover the latest features?!)
  5. James Gosling, Bill Joy, Guy Steele and Gilad Bracha, “The Java Language Specification”, 3rd Edition, 2005. (The defacto standard for JVM, but does not seem to have been updated?!)
  6. JDK 7 Demos and Samples (to be downloaded @ http://www.oracle.com/technetwork/java/javase/downloads/index.html)

Books & Online Tutorials

  1. The online Java tutorial @ http://docs.oracle.com/javase/tutorial/. (The authoritative source.)
  2. Paul Deitel and Harvey Deitel, “Java How to Program”, 9th Edition, 2011. (A comprehensive reference for programmers.)
  3. Y. Daniel Liang, “Introduction to Java Programming”, 9th Edition, 2012. (Good text book for undergraduate Java courses.)
  4. Bruce Eckel, “Thinking in Java”, 4th edition, 2007. (Great book but has not been updated?!)


2.  HTML & CSS

Specifications

  1. HTML @ W3C (www.w3.org)
    1. HTML 4.01 Specification @ http://www.w3.org/TR/html401/.
    2. HTML 5 Draft Specification @ http://www.w3.org/TR/html5/.
  2. XHTML 1.0 Specification (W3C) @ http://www.w3.org/TR/xhtml1/.
  3. CSS Specification (W3C) @ http://www.w3.org/Style/CSS/.

Online Tutorials and Resources

  1. W3School Tutorials & References @ http://www.w3schools.com/.
  2. Mozilla Developers Network (MDN)

Books

  1. [TODO]

3.  Android

  1. Android mother site @ www.android.com.
  2. Android Developers @ developer.android.com.
  3. Andriod API Documentation @ http://developer.android.com/reference/packages.html.


4.  MySQL

MySQL Mother Site & Standards

  1. MySQL Mother Site @ www.mysql.com.
  2. MySQL 5.5 “Reference Manual” @ http://dev.mysql.com/doc/.
  3. MySQL 5.5 “SQL Statement Syntax” @ http://dev.mysql.com/doc/refman/5.5/en/sql-syntax.html.
  4. “ISO/IEC 9075 Information Technology – Database Languages SQL”: 1989 (SQL-89), 1992 (SQL-92 or SQL2), 1999 (SQL-99 or SQL3), 2003 (SQL-2003), 2006 (SQL-2006) and 2011 (SQL-2011).

Sample Databases

  1. MySQL Employees Sample Database @ http://dev.mysql.com/doc/employee/en/index.html.
  2. MySQL Sakila Sample Database @ http://dev.mysql.com/doc/sakila/en/index.html.
  3. Microsoft Nothwind Sample database @ http://www.microsoft.com/en-us/download/details.aspx?id=23654; MySQL port @ http://code.google.com/p/northwindextended.
  4. The “Classic Models” Retailer database @ http://www.mysqltutorial.org.

Books and Tutorials

  1. Codd E. F., “A Relational Model of Data for Large Shared Data Banks”, Communications of the ACM, vol. 13, issue 6, pp. 377–387, June 1970.
  2. (For Java Programmers) “JDBC Basics”, Java Online Tutorial @ http://download.oracle.com/javase/tutorial/jdbc/basics/index.html.
  3. Paul DuBois, “MySQL Developer’s Library”, 4th ed, 2009 (5th eds is probably available).
  4. http://mysqltutorial.org.
  5. Russell Dyer, “MySQL in a Nutshell”, 2nd ed, O’reilly, 2008.


5.  C Language

  1. Kernighan and Ritchie “The C Programming Language”, 2nd edition, 1988, (The “K&R”).
  2. Plauger, “The Standard C Library”, 1992, PrenticeHall.
  3. The Formal Specification of C Language:
    1. ISO/IEC 9899:2011 “Programming Languages. C” (The “C11”);
    2. ISO/IEC 9899:1999 “Programming Languages. C” (The “C99”);
    3. ISO/IEC 9899:1990 “Programming Languages. C” (The “C90”).

6.  C++ Language

  1. The Formal Specification for the C++ language:
    1. ISO/IEC 14882:2011 “Programming Language. C++” (The “C++11”);
    2. ISO/IEC 14882:2003 “Programming Language. C++” (The “C++03”);
    3. ISO/IEC 14882:1998 “Programming Language. C++” (The “C++98”).
  2. Bjarne Stroustrup (creator of C++), “The C++ Programming Language”.
  3. Bjarne Stroustrup, “The Design and Evolution of C++”.
  4. http://www.cplusplus.com (C++ documents, tutorials, library references).
  5. Stanley B. Lippman & Josee Lajoie, “C++ Primer”.
  6. Deitel & Deitel, “C++ How to Program”.
  7. Gary J. Bronson, “Program Development and Design using C++”.
Share

Oracle : Oracle Database Connection Strings in PHP

December 29th, 2012, posted in Oracle
Share
It’s easy to get confused as to how to specificy your Oracle database connection string, and there’s a handy new feature in Oracle 10g that makes this a whole lot easier. So here’s a little rundown of the three ways to connect to Oracle databases. You can use the:
  • tnsnames.ora file
  • Full connection string
  • Easy connect string
These examples show how to specificy an Oracle connection string using the new OCI8 functions in PHP.


tnsnames.ora File

The tnsnames.ora file is a client side
file that maps an alias used by client programs to a database service. It is used to connect to a non-default database. Here you have to have an entry in the tnsnames.ora file, and
reference the alias to that entry in your connection code.
PHP code:
oci_connect($un, $pw, ‘MYDB’);
tnsnames.ora entry
MYDB = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = mymachine.mydomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB.AU.ORACLE.COM)) )


Full Connection String

The full connection string does not require the use of a tnsnames.ora file.
You need to enter the full connection string when you connect to the database in your code.
PHP code:
oci_connect($un, $pw,
‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mymachine.mydomain)(PORT=1521))
(CONNECT_DATA=(SERVER=DEDICATED)
(SERVICE_NAME = MYDB)))’);


Easy Connect String

This is one Oracle 10g feature that I use daily. As I constantly connect to so many different databases in my day, this has saved me so much time as I don’t have to configure anything, just know the machine name and the database alias and I’m off.
The easy connect string does not require the use of a tnsnames.ora file, and is an abbreviated version of the full connection string. you must have the Oracle 10g client-side libraries to use the easy connect string.
PHP code:
oci_connect($un, $pw, ‘//mymachine.mydomain:port/MYDB’);
Share