Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

All pages tagged IN

PHP: How to connect to MSSQL database

This tutorial describes how to connect to MSSQL database with a DSN and without a DSN. More...

Tags: PHP CONNECTION DATABASE MSSQL DSN ADODB DRIVER RETRIEVE PRINT Hits: 447860 Comments: 21

Back Up and Restore a MySQL Database

If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server. More...

Tags: MYSQL BACKUP RESTORE ZIP SHELL PHPMYADMIN HOW-TO Hits: 365210 Comments: 3

PHP: Passing Javascript variables to PHP

JavaScript is mainly used as a client side scripting language, while PHP is a server side technology. Unlike Java or ASP.Net, PHP doesn't have tools to make it work client side. That is why you need to combine JavaScript and PHP scripts to develop powerful web-applications. More...

Tags: PHP JAVASCRIPT VARIABLES PASSING SCRIPTS GET Hits: 210166 Comments: 14

PHP: How to connect to MySQL database using PHP

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running. More...

Tags: PHP CONNECTION DATABASE MYSQL FUNCTIONS RETRIEVE PRINT SQL QUERY Hits: 184267 Comments: 25

HTML: How to Control Tab Order

All elements (except hidden elements) in the HTML form are part of the form's tab order. When the user presses the Tab key, the browser shifts the input focus from element to element in order the elements appear in the HTML code. However, sometimes you want the tab order to flow a little differently. More...

Tags: HTML CONTROL ORDER TABINDEX ATTRIBUTES Hits: 166834 Comments: 1

JavaScript: How to disable the Enter key on HTML form

Normally when you have a form with several text input fields, it is undesirable that the form gets submitted when the user hits ENTER in a field. Some people are pressing the enter key instead of the tab key to get to the next field. They often do that by accident or because they are accustomed to terminate field input that way. If a browser regards hitting ENTER in a text input field as a request to submit the form immediately, there is no sure way to prevent that. More...

Tags: JAVASCRIPT FORM ENTER KEY DISABLE CONTROL INPUT Hits: 150747 Comments: 23

How to install and cofigure PHP 5 on Windows box

This article explains the steps you need to follow to configure PHP and secure its correct operation. More...

Tags: PHP INSTALLATION CONFIGURE PHP5 WINDOWS HOW-TO SETUP IIS APACHE Hits: 137888 Comments: 11

JavaScript: Arrays

Arrays can be used in many ways to store and organize data quickly and efficiently. It is one of the more useful data types available to any programming language. This article describes the basics to create and make operations with indexed, associative, and multidimensional arrays. More...

Form Processing with PHP

One of the best features of PHP is possibility to respond to user queries or data submitted from HTML forms. You can process information gathered by an HTML form and use PHP code to make decisions based off this information to create dynamic web pages. In this tutorial we will show how to create an HTML form and process the data. More...

Tags: PHP FORM PROCESSING GET POST TIPS DYNAMIC Hits: 115404 Comments: 11

PHP: Arrays

Arrays can be used in many ways to store and organize data quickly and efficiently. It is one of the more useful data types available to any programming language. This article describes the basics to create and make operations with indexed, associative, and multidimensional arrays. More...

PHP: Blocking access to the login page after three unsuccessful login attempts

Sometimes you need to add an extra protection to password-protected website. This article explains how access to the login page can be restricted after three unsuccessful login attempts. This schema uses visitors IP address to store log attempts in the database and block access to login feature for 30 minutes after third unsuccessful attempt. More...

PHP: How to Sort an Array

It is often necessary to arrange the elements in an array in numerical order from highest to lowest values (descending order) or vice versa (ascending order). If the array contains string values, alphabetical order may be needed. Sorting a one-dimensional arrays is quite easy. More...

Tags: PHP ARRAYS SORTING INDEXED ASSOCIATIVE REVERSE NUMBER STRING Hits: 63201 Comments: 2

ASP: How to connect to database using a connection string

The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this tutorial we will show you how to connect to our Access database and retrieve all the records from the table. More...

Tags: ASP CONNECTION DATABASE ADO ACCESS OLEDB ODBC SQL RETRIEVE PRINT Hits: 62275 Comments: 2

MS Access Connection Strings

MS Access ODBC and OLEDB connection strings More...

Tags: ACCESS ODBC OLEDB CONNECTION STRING Hits: 62233 Comments: 0

PHP: Variables

A variable is a holder for a type of data. So, based on its type, a variable can hold numbers, strings, booleans, objects, resources or it can be NULL. In PHP all the variables begin with a dollar sign "$" and the value can be assignes using the "=" operator. This article shows the basic idea on how to use variables in PHP, along with examples, and descriptions of the examples. More...

Access: DateDiff Function

In Access, the DateDiff function returns the number of time intervals between two dates. More...

Tags: ACCESS FUNCTION DATEDIFF TIME INTERVAL DATE Hits: 58981 Comments: 0

MS SQL Server Connection Strings

MS SQL Server ODBC and OLEDB connection strings More...

Tags: MSSQL ODBC OLEDB CONNECTION STRINGS Hits: 56862 Comments: 0

PHP: Looping Statements

PHP performs several types of repetitive operations, called "looping". Loops are set of instructions used to repeat the same block of code till a specified condition returns false or true depending on how you need it. This tutorial shows the basic idea on how to use looping statements in PHP, along with examples, and descriptions of the examples. More...

Tags: PHP LOOPING FOR WHILE DO...WHILE FOREACH BREAK CONTINUE LOOPS Hits: 55664 Comments: 1

ASP: How to process the data submitted from HTML form

The great advantage of ASP is possibility to respond to user queries or data submitted from HTML forms. You can process information gathered by an HTML form and use ASP code to make decisions based off this information to create dynamic web pages. This tutorial demonstrates how to create an HTML form and process the data. More...

JavaScript: Functions

Sometimes instead of just adding your javascript to the page and having the browser perform the tasks as soon as the script is read, you might want your javascript to be performed only upon the detection of a certain event. A function is a block of code which can be called from any point in a script after it has been declared. It is basically a compartmentalized JavaScript designed to accomplish a single task. Furthermore, JavaScript written into functions will not be performed until you specifically ask for it. This way you gain complete control of the timing. Functions are useful because they contribute to rapid, reliable, error-reducing coding, and increase legibility by tiding up complicated code sequences. More...

Javascript: Variables

A variable's purpose is to store information so that it can be used later. A variable is a name, or identifier, that represents some data that you set. This article shows the basic idea on how to use variables in JavaScript, along with examples, and descriptions of the examples. More...

SQL: IN Operator

In SQL, there are two uses of the IN keyword, and this section introduces the one that is related to the Where clause. When used in this context, we know exactly the value of the returned values we want to see for at least one of the columns. More...

Tags: SQL IN WHERE QUERY RANGE INCLUSION EXCLUSION Hits: 47340 Comments: 2

Bike - drop in phpMyAdmin replacement

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps.

Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

More...

Tags: PHP MYSQL PHPMYADMIN Hits: 46941 Comments: 0

SQL: ORDER BY

The Order By clause imposes an order on the query results. More...

JavaScript: Loops

JavaScript performs several types of repetitive operations, called "looping". Loops are set of instructions used to repeat the same block of code till a specified condition returns false or true depending on how you need it. This tutorial shows the basic idea on how to use looping statements in JavaScript, along with examples, and descriptions of the examples. More...

SQL: DISTINCT Clause

The Distinct keyword eliminates duplicate rows from the query results. More...

Tags: SQL DISTINCT DUPLICATE ELIMINATION QUERY Hits: 42235 Comments: 3

SQL: HAVING Clause

The Having clause is optional and used in combination with the Group By clause. It is similar to the Where clause, but the Having clause establishes restrictions that determine which records are displayed after they have been grouped. More...

Tags: SQL HAVING QUERY GROUPBY RESTRICT DETERMINE DISPLAY Hits: 41948 Comments: 0

ASP: Arrays

There are two types of VBScript arrays - static and dynamic. Static arrays remain with fixed size throughout their life span. To use static VBScript arrays you need to know upfront the maximum number of elements this array will contain. If you need more flexible VBScript arrays with variable index size, then you can use dynamic VBScript arrays. VBScript dynamic arrays index size can be increased/decreased during their life span. Further in this article author explains how to create static arrays and how to create and resize dynamic arrays, giving working examples. More...

Tags: ASP ARRAYS STATIC DYNAMIC INDEX SIZE RESIZE EXAMPLES Hits: 41887 Comments: 4

Access: DateAdd Function

In Access, the DateAdd function Adds a specified time interval to a date. More...

Tags: ACCESS FUNCTION DATEADD TIME INTERVAL DATE Hits: 41385 Comments: 2

ASP: Looping Statements

ASP performs several types of repetitive operations, called "looping". Loops are set of instructions used to repeat the same block of code till a specified condition returns false or true depending on how you need it. This tutorial shows the basic idea on how to use looping statements in ASP, along with examples, and descriptions of the examples. More...

What is PHP?

PHP stands for Hypertext Preprocessor and is a server-side language. This article introduces you to PHP. You will learn basic PHP syntax, what it looks like, and possibilities that PHP provides you with. More...

ADO and ADO.NET Connection Strings

Connection strings are string variables which contain database connection information and then passed to ADO which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format. This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. More...

Oracle Connection Strings

Oracle ODBC and OLEDB connection strings More...

Tags: ORACLE ODBC OLEDB CONNECTION STRINGS DATABASE Hits: 35518 Comments: 0

Access: DateValue Function

In Access, the DateValue function returns the date represented by the date of a String argument. More...

Tags: ACCESS FUNCTION DATEVALUE DATE STRING Hits: 34454 Comments: 0

MySQL Connection Strings

MySQL ODBC and OLEDB connection strings More...

Tags: MYSQL ODBC OLEDB CONNECTION STRINGS DATABASE Hits: 34412 Comments: 0

Your first PHP Script

Now that you have installed all the support software for running PHP, you are ready to learn how to do a PHP script. Writing a PHP script is very simple. No special software is needed, except a text editor like Notepad in which the script is written. More...

Tags: PHP SYNTAX RULES PRINT OUTPUT Hits: 31408 Comments: 10

ASP: Functions and Subprocedures

You can write functions in ASP similar to the way you write them in Visual Basic. It is good programming practice to use functions to modularize your code and to better provide reuse. This article explains benefits of using functions and subprocedures, shows difference between them, and gives code for function that prints out info or takes an integer value and returns the square of that value. More...

ASP Response Object

The Response object is used to send output to the client from the web server. In this tutorial the syntax, collections, properties and methods of the ASP Response object are described. More...

Access: Int Function

In Access, the Int function returns the integer portion of a number. More...

Tags: ACCESS FUNCTION INT INTEGER NUMBER Hits: 28738 Comments: 0

SQL: Join

Single table queries are useful but they do not exploit the full power of the SQL language. SQL is relational database query language and as such, one of its most important features is its ability to retrieve information from several different related tables. In relational database terms, this process is called a join. More...

Tags: SQL JOIN QUERY RETRIEVE RELATIONSHIPS MATCHING Hits: 28703 Comments: 1

SQL: INSERT Statement

The Insert Into statement can be used to append a record to a table or to append multiple records from one table to another. More...

Tags: SQL INSERT QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 28116 Comments: 2

Access: Trim Function

In Access, the Trim function returns a copy of a string with leading and trailing spaces removed. More...

Tags: ACCESS FUNCTION TRIM LEADING TRAILING SPACE REMOVE Hits: 28087 Comments: 0

How to install ASP on your own computer

It's not difficult to install and run ASP on your own computer. To do that, you must install Microsoft's Personal Web Server (PWS) or Internet Information Services (IIS). More...

Tags: ASP INSTALLATION IIS PWS WINDOWS HOW-TO MICROSOFT Hits: 27708 Comments: 0

ASP Request Object

The Request object retrieves the values that the client browser passed to the server during an HTTP request. It is used to get information from the user. Using this object, you can dynamically create web pages and perform various server-side actions based on input from the user. In this tutorial the syntax, collections, properties and methods of the ASP Request object are described. More...

Show different content to search engine visitors

Perhaps, you face a task to show slightly different information to different website visitors. We decided to address this issue by implementing a generic JavaScript solution. More...

Tags: JAVASCRIPT SHOW DIFFERENT CONTENT MESSAGE SEARCH ENGINE USERS Hits: 26907 Comments: 0

ASP FileSystemObject Object

The FileSystemObject object provides access to the file system on the web server, allowing us to manipulate text files, folders and drives from within our code. In this tutorial the properties and methods of the FileSystemObject object are described. More...

ASP: Variables

Declaring variables in ASP is simple. You don't have to declare if your variable is an integer, string, or object. You just declare it, and it has the potential to be anything. To declare a variable in ASP/VBScript we use the Dim statement. If you wanted to print out the variables, you could use the ASP Response.Write command. Learn more about the rules for declaring and naming variables in ASP/VBScript and use of Option Explicit statement in our article Variables in ASP. More...

ASP: Troubleshooting Active Server Pages (ASP) on Windows 2003

This article will help you to find answers to the problems some users have with ASP on Windows 2003. More...

Tags: ASP WINDOWS TROUBLESHOOTING QUESTIONS PROBLEMS ANSWERS LINKS Hits: 25337 Comments: 0

ASP Dictionary Object

The Dictionary object is used to store name/value pairs (referred to as the key and item respectively). The Dictionary object is like an associative array, but with its own built-in functionality that looks after the basic tasks of storing and manipulating the data, and sizing for the required number of elements. More...

ASP Session Object

The Session object stores information needed for a particular user's session on the web server. It is automatically created every time when an ASP page from the web site or web application is requested by a user who does not already have a session, and it remains available until the session expires. In this tutorial the syntax, collections, properties, methods and events of the ASP Session object are described. More...

PHP: Constants

Constants just as variables are used to store information. The main difference between constants and variables is that constant value can not be changed in the process of running program. It can be mathematic constants, passwords, paths to files, etc. More...

Tags: PHP CONSTANTS VARIABLES DIFFERENCE BUILT-IN OUTPUT Hits: 24484 Comments: 3

Access: Str Function

In Access, the Str function returns string representation of a number. More...

Tags: ACCESS FUNCTION STR STRING REPRESENTATION Hits: 24318 Comments: 0

SQL: Union Clause

The Union clause allows you to combine the result sets of 2 or more individual queries. More...

Tags: SQL UNION QUERY COMBINE RESULTS SELECT Hits: 23788 Comments: 1

Access: Val Function

In Access, the Val function returns a variant indicating the sign of a number. More...

Tags: ACCESS FUNCTION VAL VARIANT INDICATE Hits: 22871 Comments: 0

Access: Day Function

In Access, the Day function returns an integer between 1 and 31, inclusive, that represents the day of the month corresponding to the date provided as an argument. More...

Tags: ACCESS FUNCTION DAY INCLUSIVE RANGE Hits: 21393 Comments: 0

SQL: UPDATE Statement

The Update statement allows you to update a single record or multiple records in a table. More...

Tags: SQL UPDATE QUERY SINGLE MULTIPLE RECORDS Hits: 21359 Comments: 0

ASP Server Object

The Server object provides access to properties and methods on the server. Much of functionality it provides is simply functionality the web server itself uses in the normal processing of client requests and server responses. In this tutorial the syntax, properties and methods of the ASP Server object are described. More...

SQL: GROUP BY

The Group By clause of the Select statement lets you split up the values in a column as a whole. More...

Tags: SQL GROUPBY QUERY COMBINE RECORDS AGGREGATE SUM COUNT MIN MAX Hits: 19175 Comments: 0

Frames targets. How to target a link to a window.

Targeting windows allows the document writer to assign names to specific windows, and target certain documents to always appear in the window bearing the matching name. Targeting controls where the new document will be displayed when the user follows a link. Most of the time, clicking on a link simply loads a new document in the same window where the link was. In this tutorial we will show you how to deliver the content you want in a new window, or if you are using frames, in another frame. More...

What is ASP?

ASP stands for Active Server Pages. It is a server side technology that enables you to make dynamic and interactive web pages that are not affected by the type of browser the web site visitor is using. More...

ASP Application Object

The Application object is used to control and manage all items that are available to all users of an Active Server application. The Application items can be variables needed for all users in the application, or they can be instantiated objects that provide special server-side functionality. In this tutorial the syntax, collections, methods and events of the ASP Application object are described. More...

Access: LTrim Function

In Access, the LTrim function returns a copy of a string with leading spaces removed. More...

Tags: ACCESS FUNCTION LTRIM LEADING SPACE REMOVE Hits: 18115 Comments: 0

ASP: Constants

Constants just as variables are used to store information. The main difference between constants and variables is that constant value can not be changed in the process of running program. If we attempt to re-assign the value of the constant we'll get a run time error. More...

Tags: ASP CONSTANTS VARIABLES DECLARING CONST KEYWORDS Hits: 17881 Comments: 1

Access: IsDate Function

In Access, the IsDate function returns a value indicating whether or not a variant argument can be converted to a date. More...

Tags: ACCESS FUNCTION ISDATE DATE INDICATE Hits: 17575 Comments: 0

Access: IsNumeric Function

In Access, the IsNumeric function returns a value indicating whether or not an expression can be converted to a numeric data type. More...

Tags: ACCESS FUNCTION ISNUMERIC INDICATE VALUE EXPRESSION Hits: 17558 Comments: 0

Access: Len Function

In Access, the Len function returns the length of the specified string. More...

Tags: ACCESS FUNCTION LEN LENGTH STRING Hits: 17424 Comments: 0

Your First ASP Page

This tutorial explains the basics of ASP. It demonstrates how to declare the variables, to do a comment, to output the results and display in a web page time and date on the web server. More...

ASP TextStream Object

The TextStream object provides sequential access to the contents of text files. This allows you to read, write, or append characters or lines to a text file. In this tutorial the properties and methods of the TextStream object are described. More...

Access: Fix Function

In Access, the Fix function returns the integer portion of a number. More...

Tags: ACCESS FUNCTION FIX INTEGER NUMBER Hits: 15039 Comments: 0

Access: RTrim Function

In Access, the RTrim function returns a copy of a string with trailing spaces removed. More...

Tags: ACCESS FUNCTION RTRIM TRAILING SPACE REMOVE Hits: 14587 Comments: 0

Access: Min function

In Access, the Min function returns the minimum of a set of values contained in a select query. More...

Tags: ACCESS FUNCTION MIN MINIMUM SELECT QUERY Hits: 14522 Comments: 0

Record locking in Web applications

In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user left the page or is still looking at your site. We used the lock confirmation technique combined with lock expiration to solve this problem. More...

Tags: PHP RECORD LOCKING WEB APPLICATIONS Hits: 14155 Comments: 0

Javascript: The First Script

JavaScript is a simple to comprehend and easy to use scripting language. When used in conjunction with a Web browser's Document Object Model (DOM), it can produce powerful dynamic HTML browser-based applications. In this tutorial we will print the text in a web page as well as the time and date on your computer. More...

ASP File Object

The File object represents a specified file on the local machine or on a network share. To work with the File object's properties and methods, you need to create an instance of the FileSystemObject object first and then instantiate the File object through the GetFile method. Also you can get a File object reference from the Folder object, by using the Files Collection. More...

Tags: ASP FILE SCRIPTING OBJECTS FILESYSTEMOBJECT FOLDER REFERENCE Hits: 13624 Comments: 0

ASP Folder Object

The folder object represents a specified file folder on the current machine. We can use the properties and methods of the Folder object to traverse directories on the drive, and to get at all the properties of this or any other folder. To work with the Folder object's properties and methods, you need to create an instance of the FileSystemObject object first and then instantiate the Folder object through the GetFolder method. Also you can get a Folder object reference from the Drive object, by using the RootFolder property. More...

SQL: DELETE Statement

The Delete statement allows you to delete a single record or multiple records from a table. More...

Tags: SQL DE;ETE QUERY SINGLE MULTIPLE RECORDS TABLE Hits: 12727 Comments: 0

What is Javascript?

JavaScript is a cross-platform, object-oriented scripting language invented in web browsers to make web pages more dynamic and give feedback to your user. Adding JavaScript to your HTML code allows you to change completely the document appearance, from changing text, to changing colors, or changing the options available in a drop-down list, or switching one image with another when you roll your mouse over it and much more. More...

Access: TimeSerial Function

In Access, the TimeSerial function returns the time for a specific hour, minute, and second. More...

Tags: ACCESS FUNCTION TIMESERIAL TIME SPECIFIC MINUTE SECOND Hits: 11253 Comments: 0

ASP ASPError Object

The ASPError object is a new in ASP 3.0, and is available in IIS5 and later. It provides a range of detailed information about the last error that occurred in script in an ASP page. The ASPError object is only available through the GetLastError method of the Server object. In this tutorial the syntax and properties of the ASPError object are described. More...

Access: Sgn Function

In Access, the Sgn function returns a variant indicating the sign of a number. More...

Tags: ACCESS FUNCTION SGN VARIANT INDICATE SIGN Hits: 8502 Comments: 0

Access: Second Function

In Access, the Second function returns a number between 0 and 59, inclusive, representing the second of the minute of the hour. More...

Access: Minute Function

In Access, the Minute function returns an Integer specifying a whole number between 0 and 59, inclusive, representing the minute of the hour. More...

Tags: ACCESS FUNCTION MINUTE RANGE REPRESENTATION Hits: 7789 Comments: 0

Access: Cos Function

In Access, the Cos function returns a double containing the cosine of an angle. More...

Tags: ACCESS FUNCTION COS COSINE ANGLE Hits: 7549 Comments: 0

ASP Drive Object

The Drive object represents a physical drive. This drive can exist on your machine, or it can be a drive shared by another machine. To work with the Drive object's properties, you need to create an instance of the FileSystemObject object first and then instantiate the Drive object through the GetDrive method or the Drives property of the FileSystemObject object. More...

Access: Sin Function

In Access, the Sin function returns the sine of an angle. More...

Tags: ACCESS FUNCTION SIN SINE ANGLE Hits: 6149 Comments: 0

Better PHP developer

Many web developers consider PHP as a second class language. The truth is, as DHH puts it: "You can build the best web application in the world with any language you want". We are here not to start a religious war but to help beginner PHP developers get better. Here is the some of the best advice from season PHP programmers.

First steps

  1. Get into the habit of commenting your code thoroughly from the outset, your future self will thank you https://www.phpdoc.org/
  2. Ignore any online tutorials, stack-overflow solutions or any other PHP code snippets on the internet that are older than 3 or 4 years (use Google's advanced search date tools to filter out older content). PHP had evolved dramatically in the last few years, and much of what is out there is wrong, insecure and bad practice. More...

    Tags: PHP,DEVELOPER,BEGINNER Hits: 3544 Comments: 0



Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.