www.webcheatsheet.com Tutorials

Reading the clean text from DOCX and ODT
In this article we will resolve the task of reading the plain text from the Office Open XML (more known as DOCX) and OpenDocument Format ODT using PHP. Note that we are not going to apply any third-party software.

Reading the clean text from RTF
Rich Text Format (often abbreviated as RTF), to surprise of many, is quite complex text data format. Let's read the plain text from RTF file.

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.

Reading the clean text from PDF
Portable Document Format (PDF) is a file format created for the document exchange. Let's read the plain text from PDF file.

BBCode editor
The jquery.BBCode plugin is a simple BBCode editor with preview option, which can be easily placed on any website.

Sending email using CDOSYS
In this article we demonstrate how to generate and send emails with ASP using CDOSYS. You will learn how to send text and html emails, emails with attachments, use a remote server, load recipients from a database, set the priority / importance of an email and request a read/return receipt.

Debugging PHP with Xdebug
The Xdebug is the extension for PHP that helps debugging PHP scripts by providing a lot of valuable debug information. Using the Xdebug you can debug your scripts in the Notepad++ and other PHP IDEs.

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.

Creating Word, Excel and CSV files with PHP
In this article we demonstrate several ways to create Microsoft Word and Excel documents, and also CSV files using PHP. Learn how to create files using HTTP headers, COM objects, OpenOffice templates, fputcsv function.

How to connect to MS SQL Server database
In this tutorial we will show you how to connect to MS SQL Server database.

How to set up a system DSN
This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.

How to connect to an Access database with a DSN
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table 'cars'. Everything is commented so you won't have trouble.

ADO and ADO.NET Connection Strings
This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. Connection strings are string variables which contain database connection information and then passed to ADO(ActiveX Data Objects) 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.

How to Connect to Database using a Connection String
In this tutorial we will show you how to connect to our Access database called 'examples.mdb' and retrieve all the records from the table 'cars'.

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. Each item in the Dictionary object is associated with a unique key. The key is used to retrieve an individual item. We don't have to worry about which row or column the data is in, we just access it using a unique key.

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.

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.

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.

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.

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.