Owner: Victor's Programming Aid URL:http://www.victorchen.info Join Date: Wed, 03 Sep 2008 09:14:20 -0500 Rating:0 Site Description: weblog of programming articles by a college graduate from the uc irvine Site statistics:Click here
Sql Select Statement 2008-09-02 07:00:07 General Select
Format
SELECT commaSeperatedColumnNames FROM tableName
Below, we will go over the basics of selecting from a table in various situations. Below is a standards table with various columns and various rows. This table will be used through the rest of this article.
Table: members
id
name
age
gender
state
1
Victor
18
M
CA
2
Bill
28
M
NY
3
Jill
5
F
CA
4
Bob
14
M
AL
Select Al
Creating a Class in PHP 2008-09-01 13:31:47 The object oriented programming concept is great for not only organizing code, but also easing readability. Creating
a class in PHP is easy and we will go through the basics. For starters, creating a PHP class is as easy as:
class myFirstClass {
// CLASS CONTENT GOES HERE
}
The next step is to add [...]
Convert DateTime From PHP to MySql Format 2008-08-29 09:41:59 When using web technologies PHP and MySql on a web application, you may come across the need to add the current DateTime in your database. A simple way to get the server time in PHP is to use the $_SERVER['REQUEST_TIME'] function. It will return the time in seconds since January 1, 1970. In our example, [...] Read more:Convert
Loading URL in iframe programmatically on Postback in C# 2008-08-26 09:28:58 To programmatically setup and use an iframe in C#, copy the below iframe code snippet into your aspx page. You are free to add or edit any of the iframe attributes below, but note that the id and the runat attributes are required!
<iframe id="myIframe" runat="server" scrolling="auto">
</iframe >
Now in the aspx page’s codebehind, you can access [...] Read more:Loading
Linux: File Backup From Linux To Linux 2008-08-12 09:53:39 I was given the task of setting up a nightly back up of files located on one Linux
Machine (Red Hat) to another Linux Machine (Red Hat). All the files requiring backup are located in one folder. This folder contains both files and folders (which can contain more files and folders). Each files is only [...]
Period (or Dot) in Column Name Error in C# 2008-08-11 10:31:13 In this solved challenge, I had a GridView on my C# Web Application that was dynamically creating columns based on user selections. In the general case, everything was working without any problems. The potential column names were listed in the database, which were selectable from a checkbox list.
One day, I got reports that the page [...] Read more:Column
, Period
Form Submit On Enter in Visual Studio 2008 2008-07-16 09:46:01 Until recently, I had always used javascript to allow the enter key to submit a form (as seen in a previous posting called Submit
Form On Enter Key Solution). Since then, I was queued into a GUImethod of controlling enter key form submissions in Visual
Studio 2008 (and I’m sure this works in other versions [...] Read more:Visual Studio
PHP: Easily Get Query String Variables 2008-07-15 09:35:22 One of my favorite and most heavily used PHP common functions retrieves variables from the query string. I found that without this function, I was inefficiently checking if the variable existed, and if not, I was then was manually setting a default value. The function takes in two string variables that handle the above problem. [...] Read more:Easily
, Query
, String
CS0433: The type exists in both [dll1] and [dll2] 2008-07-11 10:02:48 While migrating an old application from Visual Studio 2003 to Visual Studio 2008, I came across what seemed to be a dll mismatch error. I had to remove the original dll from the references because of conflicts with the new 3.5 framework to a new version of the dll as found in the 3rd party [...]
Auto Complete Text Field in PHP 2008-09-19 23:51:22 On a web page form, one method to accept user input is with a single line text field. This allows for a visitor the freedom to input anything. But what if you want to give the visitor a set of options to choose from in addition to the freedom of inputting anything? That is what [...] Read more:Field
Calculate Average of Double Variables in C# 2008-09-16 09:08:52 Calculating the Average
from a List of numbers is accomplished through this easy function. The average is the sum of all values in a list divided by the total number of values. In this average example, we will assume the List consists of doubles (by means of a Generic List). For this to workOur Generic [...]
PHP Foreach Loop 2008-09-12 03:10:31 There are many types of loops available in PHP. One of my favorite loops is the foreach loop. The foreach loop can loop through an entire array without the need to initialize an array counter. It is called a foreach loop because you get to define what you do to each loop element.
For the start [...]
How to Use a Generic List in C# 2008-09-10 09:21:34 Using a Generic
List in C# is an efficient method of storing a collection of variables. And probably the best part is that the List is strongly typed and casting (which degrades performance) will no longer be necessary. Your collection of variables should be of the same data type. Generic Lists were first introduced into [...]
Red Hat Enterprise Linux 5 Installation Cannot Find Devices 2008-09-08 21:10:37 In the process of installing Red Hat
Enterprise Linux
5 (RHEL 5) on a brand new Dell Optiplex 755, I came across the following error:
Unable to find any devices of the type needed for this installation type. Would you like to manually select your driver or use a driver disk?
Another symptom to this problem is [...] Read more:Devices
, Installation
What is PHP? 2008-09-06 13:59:26 PHP is an acronym for “PHP: Hypertext Preprocessor”. It is a server-side scripting language great for web development. What this means for PHP beginners is that any php file when requested by a web browser client will perform some action on the php scripts on the server. After the action is finished executing php scripts, [...]
Mount USB External Hard Drive to Linux Box 2008-09-05 03:35:28 To mount a USB External
Hard Drive to a Linux
Box, first make sure the unit is plugged in and powered on. Depending on your linux distribution, the hard drive may automatically mount. If this is not the case, mounting the external hard drive is not a very complicated tasks.
To begin, you will need to [...]
How To Change Linux Run Level 2008-09-04 09:08:48 The standard Run Level for a linux machine booting up in full GUI mode is Run Level 5. In my experience, the most common Run Level (other than 5 for standard boot up) is Run Level 3. The most common need for Run Level 3 is for debugging problems and installing graphic drivers.
If you want [...] Read more:Change
, Linux
Pause C# Web Application 2008-10-07 09:30:40 Pausing a C# Web Application
is easy and takes no more than one line of code.
Thread.Sleep(10000);
The number in RED is the number of milliseconds that the application will be paused. In the example above, the application will be paused for 10 seconds. Be sure to include at the top of your file:
using System.Threading; Read more:Pause
, Web Application
How to Create PHP Static Method 2008-10-05 12:28:06 About a couple of weeks ago, I covered the basics on how to Access PHP Class Variables and Methods. This article is different because it deals with only the creation of a static method. Before we continue, we will insure we know the difference between a non-static class method and a static method.
Non-Static Method
Static Method
1
Requires [...]
How to Create a Firefox Search Plugin (Extension) 2008-09-28 10:52:13 The Firefox
browser (as of version 3.0.2 and likely earlier versions), there is a search bar at the top right. Custom search engine plugins are available to allow easier searching. For this example, I will demonstrate how to create search engine for the search engine Scour. We will begin with a template which should be [...] Read more:Extension
, Plugin
, Search
Verify Email Address in PHP 2008-09-24 07:22:14 Nearly every interactive web application requires at some point a user to register. So generally, there exists a registration page where site visitors input basic information like username, password, and email address. Aside from the username and password, what is the easiest way for a PHP web developer to verify an email address is at [...] Read more:Address
, Email
Accessing PHP Class Variables and Functions 2008-09-23 09:21:30 So you have successfully created a PHP class and want access to the classes variables and functions. As a reminder to programming beginners, you can only access public variables and public functions. That is a function or variable that was declared with the public keyword or no keyword (as PHP functions and variables are by [...] Read more:Functions
3 Reasons to Remove Unused Using in Visual Studio 2008-10-29 01:20:44 An important programming practice is to remove unused Usings for C# (or Imports for Java). Though not removing unused “Using” will (in most cases) not cause problems, there is the small chance that future changes to a packaged “Using” may conflict. This may occur during an upgrade where two objects then contain the same function [...]
Related posts:Form Submit On Enter in Read more:Reasons
, Visual
, Visual Studio
Calculate Standard Deviation of Double Variables in C# 2008-10-15 05:59:50 To calculate the standard deviation of a List of numbers in C#, we can solve it it essentially four steps. Each of them are listed by color below:
Finding the average of a list of number.
Square the value of every number together, and add them together.
Take the result from Step 2 and divide by the number [...]
Related posts:Calculate Average of Double Variables in C# Calculating the Average fr Read more:Standard
Recommend Site To A Friend
