Fast Technology

Make money fast with sharecash

2013-11-14T03:52:00.001-08:00

http://www.youtube.com/v/PRJ5TX6cf4Q?autohide=1&version=3&autoplay=1&attribution_tag=jN5_qqm2QAEsqMjj7aopjg&feature=share&autohide=1&showinfo=1

How You Made $500,000+ In One Year (+playlist)

2013-11-02T02:25:00.001-07:00

http://www.youtube.com/v/9JO_A3ANiUY?version=3&list=UUxdcL3x3hy9YgLwMA-4xt0w&autohide=1&showinfo=1&feature=share&autoplay=1&attribution_tag=qkmWMIdaZnp93wTKBDVBjw

how to blog and make money online

2013-11-02T01:08:00.001-07:00

http://www.youtube.com/v/bqbn7jDq9fE?version=3&autohide=1&feature=share&autoplay=1&autohide=1&attribution_tag=VehVKg0NFlKWkF1xTuWsag&showinfo=1

Different ways to refresh or reload page using jQuery

2012-07-14T00:49:00.000-07:00

different ways using which you can reload or refresh the webpage using jQuery. The first method is nothing to do with jQuery. It is a HTML tag which you need to put in the head section of your page and your page will get refreshed automatically after specified interval.

`1`	`<meta http-equiv="refresh"` `content="10">`

The meta tag with "http-equiv" is used to refresh the page. This attribute tells the browser that this meta tag is sending an HTTP command rather than a standard meta tag. Refresh is an actual HTTP header used by the web server.The content attribute in the tag is having value in seconds. As per the above code, it is set to 10, which means after 10 seconds your page will get refreshed or reloaded.

You can also use jQuery to refresh/reload the page automatically. See below jQuery code.

1function ReloadPage() { 

2   location.reload();

3};

5$(document).ready(function() {

6  setTimeout("ReloadPage()", 10000); .

7});

location.reload() will reload the page again. The advantage of location.reload() is that it works with all the major browsers.

If you want to reload the page on click of button, then you can call location.reload() on button click event. See below jQuery code.

`1`	`$(document).ready(function() {`

`2`	`$('#btnReload').click(function() {`

`3`	`location.reload();`

4 });

5 });

JQuery Mouse Events

2012-07-07T05:10:00.002-07:00

JQuery Basics Events

2012-07-06T14:07:00.001-07:00

Cloud computing

2012-07-02T14:42:00.000-07:00

Cloud computing is the delivery of computing and storage capacity as a service to a heterogeneous community of end-recipients. The name comes from the use of a cloud-shaped symbol as an abstraction for the complex infrastructure it contains in system diagrams Cloud computing entrusts services with a user's data, software and computation over a network.

There are three types of cloud computing:

Infrastructure as a Service (IaaS),
Platform as a Service (PaaS), and
Software as a Service (SaaS).

Using Infrastructure as a Service, users rent use of servers (as many as needed during the rental period) provided by one or more cloud providers. Using Platform as a Service, users rent use of servers and the system software to use in them. Using Software as a Service, users also rent application software and databases. The cloud providers manage the infrastructure and platforms on which the applications run.

End users access cloud-based applications through a web browser or a light-weight desktop or mobile app while the business software and user's data are stored on servers at a remote location. Proponents claim that cloud computing allows enterprises to get their applications up and running faster, with improved manageability and less maintenance, and enables IT to more rapidly adjust resources to meet fluctuating and unpredictable business demand.

Cloud computing relies on sharing of resources to achieve coherence and economies of scale similar to a utility (like the electricity grid) over a network (typically the Internet). At the foundation of cloud computing is the broader concept of converged infrastructure and shared services.

Characteristics

Cloud computing exhibits the following key characteristics:

Agility improves with users' ability to re-provision technological infrastructure resources.
Application programming interface (API) accessibility to software that enables machines to interact with cloud software in the same way the user interface facilitates interaction between humans and computers. Cloud computing systems typically use REST-based APIs.
Cost is claimed to be reduced and in a public cloud delivery model capital expenditure is converted to operational expenditure This is purported to lower barriers to entry, as infrastructure is typically provided by a third-party and does not need to be purchased for one-time or infrequent intensive computing tasks. Pricing on a utility computing basis is fine-grained with usage-based options and fewer IT skills are required for implementation (in-house). The e-FISCAL project's state of the art repository contains several articles looking into cost aspects in more detail, most of them concluding that costs savings depend on the type of activities supported and the type of infrastructure available in-house.
Device and location independence enable users to access systems using a web browser regardless of their location or what device they are using (e.g., PC, mobile phone). As infrastructure is off-site (typically provided by a third-party) and accessed via the Internet, users can connect from anywhere.
Virtualization technology allows servers and storage devices to be shared and utilization be increased. Applications can be easily migrated from one physical server to another.
Multitenancy enables sharing of resources and costs across a large pool of users thus allowing for:
- Centralization of infrastructure in locations with lower costs (such as real estate, electricity, etc.)
- Peak-load capacity increases (users need not engineer for highest possible load-levels)
- Utilisation and efficiency improvements for systems that are often only 10–20% utilised.
Reliability is improved if multiple redundant sites are used, which makes well-designed cloud computing suitable for business continuity and disaster recovery.
Scalability and Elasticity via dynamic ("on-demand") provisioning of resources on a fine-grained, self-service basis near real-time, without users having to engineer for peak loads.
Performance is monitored, and consistent and loosely coupled architectures are constructed using web services as the system interface.
Security could improve due to centralization of data, increased security-focused resources, etc., but concerns can persist about loss of control over certain sensitive data, and the lack of security for stored kernels. Security is often as good as or better than other traditional systems, in part because providers are able to devote resources to solving security issues that many customers cannot afford. However, the complexity of security is greatly increased when data is distributed over a wider area or greater number of devices and in multi-tenant systems that are being shared by unrelated users. In addition, user access to security audit logs may be difficult or impossible. Private cloud installations are in part motivated by users' desire to retain control over the infrastructure and avoid losing control of information security.
Maintenance of cloud computing applications is easier, because they do not need to be installed on each user's computer and can be accessed from different places.

Service Models

Cloud computing providers offer their services according to three fundamental models: Infrastructure as a service (IaaS), platform as a service (PaaS), and software as a service (SaaS) where IaaS is the most basic and each higher model abstracts from the details of the lower models.

Infrastructure as a service (IaaS)

Platform as a service (PaaS)

Main article: Platform as a service

Software as a service (SaaS)

Main article: Software as a service

In this model, cloud providers install and operate application software in the cloud and cloud users access the software from cloud clients. The cloud users do not manage the cloud infrastructure and platform on which the application is running. This eliminates the need to install and run the application on the cloud user's own computers simplifying maintenance and support. What makes a cloud application different from other applications is its elasticity. This can be achieved by cloning tasks onto multiple virtual machines at run-time to meet the changing work demand. Load balancers distribute the work over the set of virtual machines. This process is inconspicuous to the cloud user who sees only a single access point. To accommodate a large number of cloud users, cloud applications can be multitenant, that is, any machine serves more than one cloud user organization. It is common to refer to special types of cloud based application software with a similar naming convention: desktop as a service, business process as a service, Test Environment as a Service, communication as a service.

The pricing model for SaaS applications is typically a monthly or yearly flat fee per user.

Examples of SaaS include: Google Apps, Quickbooks Online and Salesforce.com.

Cloud clients

Users access cloud computing using networked client devices, such as desktop computers, laptops, tablets and smartphones. Some of these devices - cloud clients - rely on cloud computing for all or a majority of their applications so as to be essentially useless without it. Examples are thin clients and the browser-based Chromebook. Many cloud applications do not require specific software on the client and instead use a web browser to interact with the cloud application. With Ajax and HTML5 these Web user interfaces can achieve a similar or even better look and feel as native applications. Some cloud applications, however, support specific client software dedicated to these applications (e.g., virtual desktop clients and most email clients). Some legacy applications (line of business applications that until now have been prevalent in thin client Windows computing) are delivered via a screen-sharing technology.

Create MVC Website

2012-06-29T13:24:00.000-07:00

Before you can do anything with ASP.NET MVC, you have to create a website to work with. Fortunately, it is easy to do.

Step 1: Find the Project Type in Visual Studio

Open up Visual Studio 2008. Go to File > New > Project in the menu. You will get a dialog much like the following image. Pick the "Web" category.

You can, of course call the project whatever you want and put it wherever you want. Next step.

Step 2: Create a Test Project

This is not necessary but is highly recommended. After all, automating tests is a useful activity.

As you can see, there is a dropdown for selecting test frameworks other than that which comes with Visual Studio. If you have another test framework that you use, feel free to use it.

Take a Look at What You Get

You now have an MVC project. So now let's take a look at what you have.

A few things here. The content folder is the place to put images and css. Putting such things there is not necessary. That is simply the default recommendation. The controllers folder is where you put your controller classes. If you are wondering what that is, well, that will be defined soon enough. This is actually one of the two core pieces of what ASP.NET MVC really is. The models folder is potentially a place to put any "business logic" classes you want to use but it can, frankly, just be deleted. Unless you want to put code there, do not feel constrained to do so. The scripts folder is for javascript files. The views folder is the other super-important core pieces of the ASP.NET MVC framework, and contains your Html files.

In the next section we will discuss the pattern around which ASP.NET MVC is built, the Model-View-Controller pattern. After that we will come back to solution explorer and see how that pattern is applied to the project file, and how they expect code to be written using this framework.

Consumerism and its antisocial effects can be turned on—or off

2012-06-25T06:30:00.000-07:00

Money doesn't buy happiness. Neither does materialism: Research shows that people who place a high value on wealth, status, and stuff are more depressed and anxious and less sociable than those who do not. Now new research shows that materialism is not just a personal problem. It's also environmental.
"We found that irrespective of personality, in situations that activate a consumer mindset, people show the same sorts of problematic patterns in wellbeing, including negative affect and social disengagement," says Northwestern University psychologist Galen V. Bodenhausen. The study, conducted with colleagues Monika A. Bauer, James E. B. Wilkie, and Jung K. Kim, appears in Psychological Science, a journal of the Association for Psychological Science.
In two of four experiments, university students were put in a materialistic frame of mind by tasks that exposed them to images of luxury goods or words mobilizing consumerist values (versus neutral scenes devoid of consumer products or words without such connotations). Completing questionnaires afterwards, those who looked at the pictures of cars, electronics, and jewelry rated themselves higher in depression and anxiety, less interested in social activities like parties, and more in solitary pursuits than the others. Those primed to materialism by exposure to certain words evinced more competitiveness and less desire to invest their time in pro-social activities like working for a good cause.
In two other experiments, participants completed tasks that were framed as surveys—one of consumer responses, another of citizens.' The first experiment involved moving words toward or away from the participant's name on a computer screen—positive and negative emotion words and "neutral" ones that actually suggested materialism (wealth, power), self-restraint (humble, discipline), transcendence of self, or self-indulgence. The people who answered the "consumer response survey" more quickly "approached" the words that reflected materialistic values than those in the "citizen" survey. The last experiment presented participants with a hypothetical water shortage in a well shared by four people, including themselves. The water users were identified either as consumers or individuals. Might the collective identity as consumers—as opposed to the individual role—supersede the selfishness ordinarily stimulated by the consumer identity? No: The "consumers" rated themselves as less trusting of others to conserve water, less personally responsible and less in partnership with the others in dealing with the crisis. The consumer status, the authors concluded "did not unite; it divided."
The findings have both social and personal implications, says Bodenhausen. "It's become commonplace to use consumer as a generic term for people," in the news or discussions of taxes, politics, or health care. If we use term such as Americans or citizens instead, he says, "that subtle difference activates different psychological concerns." We can also take personal initiative to reduce the depressive, isolating effects of a materialist mindset by avoiding its stimulants—most obviously, advertising. One method: "Watch less TV."

Creative Activism

2012-06-25T06:26:00.003-07:00

Creative activists can be described as: 'These are the changemakers. People who turn their ideas into action. A Creative Activist is any individual or organization who uses media, the arts, and technology to create awareness of important issues in the world and affect positive change.'
I would disagree with the description above, simply because creative activists don’t limit their creativity to using arts, media and technology to create awareness. They also use ingenuity and originality to convey their message, to a sometimes unwilling and skeptical audience.
Nick Darken wrote, commenting on the video above: '‘The Return of Dictator Ben Ali’ saw one huge, imposing portrait of the former dictator reinstated in a square in newly freed Tunisia. The response was emotional. As the crowd tore down the poster in anger, the message underneath reminded people to use their vote at the upcoming elections as only half the population were expected to turn out.”
Some creative volunteers found another way to raise awareness about Israel's apartheid policies, on the streets of New York City. The BDS movement provides a prime example of creativity and spontaneity. Attendees of the Israel Jazz Festival in NYC at the Guggenheim were treated to free water bottles labeled "Israel" on one side and the words "Apartheid since 1948" on the other.
Syrian Activist Ammar Allani is quoted as saying:
“And while they (governments/authorities) can claim supremacy in force, finance and media ownership, the one thing they definitely cannot offer is creativity, freedom and innovation. That is why the young generation is using these specific tools to alter the rules of the game, leaving the regimes unable to keep pace, at least in terms of winning the audience.
In one instance, hundreds of young protestors took to the streets raising blank signs, dozens of white boards with absolutely nothing written on them, yet the security forces were exasperated by that and started shooting and beating people. For everyone watching, including some supporters of the regime, it was really silly and stupid; it was a classic example of creativity winning over force.
Take Kafranbel for instance, this is a very small village in Syria, unknown even to the average Syrian and located in a province ironically called “the forgotten cities”, these people grow olives, and recently ideas!
Every week, a few dozens of the Kafranbel inhabitants brainstorm and create the most incredibly creative and powerful punch lines, they write them on paper panels, go to the grove, photograph themselves with a phone and upload the images to Facebook, as simple as this may seem, it is literarily revolutionizing the nation.
Just to share with you some of these punch lines:
- We demand that school uniforms include a helmet, body armor and gas mask.
- Forgive me my love; I mentioned your name in the interrogation.
- Only in Syria, to get to heaven… just cross the street.”
Marianne Torres, an inspiring American activist, told me of her own small victory:
"We learned that Madeline Albright was coming to Eastern Washington University in Cheney. I was still mightily outraged about Albright's words and continued "service" in the American government so I just decided that if no one else could do anything to expose her crimes, I would.
I had a t-shirt made with her infamous quote on the back "500,000 Iraqi children killed by U.S. sanctions. Madeleine Albright says, '...The price — we think the price is worth it.', wrote up the quote and other ugliness from her on a handout and passed them out at her speaking engagement and then did a double sided sheet with William Blum's piece on her on one side and the absurd list of embargoed items on the other side, and passed them out both outside, and inside the auditorium. Most people didn't read my shirt, but assumed the flyer was something from the University, so a whole lot of people sat and read the awful truth before she spoke.
Imagine my surprise when people who were excited to see this woman asked me if they could buy a t-shirt like mine! They obviously had not actually read it but assumed I was there in support of her. I'm sure they changed their mind after they read the paper I handed to them - and several hundred others."

View In Sql Server 2005 & 2008

2012-06-25T05:39:00.004-07:00

Introduction:
In this article we are going to discuss about the Views in the sql server 2005 version. It is one of the important elements in the sql server; it eliminates the difficulties in the business process. There are lots of significant improvements in the view especially in the sql server 2005 version. They have introduced the indexed views and INSTEAD of Trigger on the permanent view. Let us discuss about the views with more practical way.

Views:
The view is a virtual table, which can have the multiple columns from the one or more table. It can be used like the normal table. Normally view cannot store the data permanently in the table. When we create the view it stores the view definition schema as object under the concern database.

Let us see the syntax of the create view

CREATE VIEW View Name [Alias name1, name2,]

WITH ENCRYPTION

WITH SCHEMA BINDING

AS

SELECT statement [WITH CHECK OPTION]

The create view can be created with the view name and the alias can be given in the view name parameter parenthesis. The view schema can be stored in the encrypted format. Here is an option like SCHEMA BINDING; this is an important mile stone in the view to allow the developers to create the permanent view.

When to use VIEW?
When you have complex queries, that use many places in the stored procedures or functions, etc..,

It will be used as security mechanism in the web applications. When we use the original table in the web applications the hackers may drop the table. That time the original data will be persist in the table.

When you want to hide the particular columns to the specific people then we can create the specialized view.

Encrypted View:
The definition of schema will be encrypted and stored as object in the database. This can be done using the ENCRYPTION option in the view creation.

IF OBJECT_ID('[DBO].Vw_SqlObjects_Encrypted') IS NOT NULLBEGIN   DROP VIEW [DBO].Vw_SqlObjects_Encrypted
   PRINT '<< [DBO].Vw_SqlObjects_Encrypted View dropped >>'ENDGOCREATE VIEW [DBO].Vw_SqlObjects_EncryptedWITH ENCRYPTIONAS   SELECT       O.Object_ID      ,O.Name
      ,'Type' = CASE O.type WHEN 'S' THEN 'Scalar Functions'                          WHEN 'F' THEN 'Functions'                          WHEN 'V' THEN 'Views'                          WHEN 'PK' THEN 'Primary keys'                          WHEN 'TR' THEN 'Triggers'                          WHEN 'P' THEN 'Procedures'                          WHEN 'U' THEN 'User Defined Functions'                          WHEN 'TF' THEN 'Table Valued Functions'                          WHEN 'IF' THEN 'Inline Functions' END      ,O.create_date
      ,O.modify_date
      ,CASE WHEN SC.encrypted = 0 THEN 'No' ELSE 'Yes' END AS [IsEncrypted]
      ,SC.text
FROM      SYS.OBJECTS O
INNER JOIN      SYSCOMMENTS SC ON SC.id = O.object_id
GOIF OBJECT_ID('[DBO].Vw_SqlObjects_Encrypted') IS NOT NULLBEGIN   PRINT '<< [DBO].Vw_SqlObjects_Encrypted View created >>'ENDGO
Now if you want to see the view schema definition for the above view is not possible. We have stored in the encrypted format. This is a significant option to hide the important calculations inside the view from the others.

In case of any alter in the view must be stored externally somewhere else.

SELECT text FROM SYSCOMMENTS WHERE id = OBJECT_ID('[DBO].Vw_SqlObjects_Encrypted')

SELECT definition FROM SYS.sql_modules WHERE object_id = OBJECT_ID('[DBO].Vw_SqlObjects_Encrypted')

sp_helptext Vw_SqlObjects_Encrypted
If you execute the above queries then it will say like view is encrypted.

There are three types of views in the sql server 2005.

They are

Normal or Standard view
Indexed or permanent view
Partitioned view

Normal or Standard view:
This view is most frequently used by the developers. When create the view the schema will be stored an object in the database. When we retrieve the content from this virtual table, it will be executed the schema and stored the data from the parent table.

Here if you have the result from the same table then it can be updated and inserted. The deleted row will be reflected in the original table.

USE [Northwind]
GOIF OBJECT_ID('[DBO].vw_ViewProducts','V') IS NOT NULLBEGIN DROP VIEW [DBO].vw_ViewProducts
PRINT '<< [DBO].vw_ViewProducts view dropped.. >>'ENDGOCREATE VIEW [DBO].vw_ViewProductsAS SELECT
    ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,
UnitsOnOrder,ReorderLevel,Discontinued
FROM Products
GOIF OBJECT_ID('[DBO].vw_ViewProducts','V') IS NOT NULLBEGIN PRINT '<< [DBO].vw_ViewProducts view created.. >>'ENDGO--O/PSELECT * FROM [DBO].vw_ViewProducts--INSERTINSERT INTO [DBO].vw_ViewProducts(ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)VALUES('Test View',1,2,'100 per bag',25.45,89,57,15,0)--DELETEDELETE FROM [DBO].vw_ViewProducts WHERE ProductID = 81
Here you can do the DML operations in the view when you have only one table.

Indexed views:
The indexed or permanent view is one of the new features introduced in the sql server 2005 version. We have seen that the view only store the schema definition and it will get execute and load the data into the virtual table at the time of view used. But this view creates the permanent view and we can create the indexes on the table. It allows us to create the instead of trigger.

The indexed view can be created with the WITH SCHEMA BINDING option while creating the view.

The indexed view has some restrictions like cannot use the TOP, DISTINCT, UNION, ORDER BY and aggregate functions.

It allows us to use the GROUP BY statement but we cannot use COUNT statement. Instead of that COUNT_BIG statement can be used.

IF EXISTS(SELECT OBJECT_ID FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].Vw_Product_Sales_Report',N'V'))BEGIN DROP VIEW [DBO].Vw_Product_Sales_Report
PRINT '<< [DBO].Vw_Product_Sales_Report view dropped >>'ENDGOCREATE VIEW [DBO].Vw_Product_Sales_ReportWITH SCHEMABINDINGAS SELECT
      O.OrderID
     ,C.CustomerID
     ,C.CompanyName
     ,C.Address+', '+C.City AS [Customer Address]
     ,OD.ProductID
     ,P.ProductName
     ,OD.UnitPrice
     ,OD.Quantity
     ,(OD.UnitPrice * OD.Quantity) AS [Total]
     ,(OD.UnitPrice * OD.Quantity) * OD.Discount/100 AS [Discount]
   FROM     [DBO].Orders O (NOLOCK)   INNER JOIN [DBO]."Order Details" OD (NOLOCK) ON OD.OrderID = O.OrderID
   INNER JOIN [DBO].Customers C (NOLOCK) ON C.CustomerID = O.CustomerID
   INNER JOIN [DBO].Products P (NOLOCK) ON P.ProductID = OD.ProductID
GOIF EXISTS(SELECT OBJECT_ID FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].Vw_Product_Sales_Report',N'V'))BEGIN PRINT '<< [DBO].Vw_Product_Sales_Report view created >>'ENDGO
Here the indexed view has created. When you retrieve the data from this table, it will execute like normal table.

There are some retrictions while creating this indexed view like the name of the view must be two part name and we cannot use select * in the view schema defintion.

Normally view cannot have the triggers but from the sql server 2005 onwards We can create the Instead of trigger on the instead of trigger.

Partitioned Views:
The partitioned view and its execution is like normal view. It will work across the database and across the server.

There are two types of Partitioned views. They are

Local Partitioned View
Global Partitioned View

1. Local Partitioned View:
The local partitioned view can be created within same server but different database.

The view schema definition will be stored in the executed database. But when we try to retrieve the data from the table, it has to execute the schema definition internally and load the data.

Let us see an example.

USE [Northwind]
GOCREATE TABLE EmployeeList( iEmployeeID INT IDENTITY(1,1), vFirstName VARCHAR(25) NOT NULL, vLastName VARCHAR(25) NOT NULL, iDeptID INT, vAddress VARCHAR(25) NOT NULL, vCity VARCHAR(25) NOT NULL, vState VARCHAR(25) NOT NULL, vCountry VARCHAR(25) NOT NULL,)GOUSE [Master]
GOCREATE TABLE Department( iDeptID INT IDENTITY(1,1) PRIMARY KEY, vDeptName VARCHAR(50), vDeptDesc VARCHAR(25), vDeptAddedBy VARCHAR(50), vPostedDate DATETIME DEFAULT GETDATE())GO--SELECT * FROM DepartmentUSE [Northwind]
GOIF OBJECT_ID('[DBO].vw_LocalPartion_View','V') IS NOT NULLBEGIN DROP VIEW [DBO].vw_LocalPartion_View
PRINT '[DBO].vw_LocalPartion_View view dropped...'ENDGOCREATE VIEW [DBO].vw_LocalPartion_ViewAS
SELECT E.iEmployeeID,E.vFirstName+SPACE(1)+E.vLastName AS [Name],       D.vDeptName,E.vAddress,E.vCity,E.vStateFROM EmployeeList E--INNER JOIN Master..Department D ON D.iDeptID = E.iDeptID --Either one of the way will be used.INNER JOIN Master.dbo.Department D ON D.iDeptID = E.iDeptID
GOIF OBJECT_ID('[DBO].vw_LocalPartion_View','V') IS NOT NULLBEGIN PRINT '[DBO].vw_LocalPartion_View view created...'ENDGO--O/pSELECT * FROM [DBO].vw_LocalPartion_View

2. Global Partitioned View
The global Partitioned view will work across the server. The view can be created to join the table across the server.

The accessing format will be like this.

[Server Name]. Database Name. Table Name

When we execute the view if it is not linked with the current server then it will ask us to link the external server.

The following system stored procedure will be used to link the server.

sp_addlinkedserver 'Server name'
The following system catalog table is used to see the list of linked servers.
SELECT * FROM SYS.SERVERS
INSTEAD OF Triggers on the Indexed View
Normally the triggers cannot be created on the view. But sql server 2005 onwards we can create the INSTEAD OF trigger on the indexed views.
USE [Northwind]
GOIF OBJECT_ID('[DBO].[VW_Trigger_Example') IS NOT NULLBEGIN   DROP VIEW [DBO].[VW_Trigger_Example]
   PRINT '[DBO].[VW_Trigger_Example view dropped..'ENDGOCREATE VIEW [DBO].[VW_Trigger_Example]WITH SCHEMABINDINGAS SELECT P.ProductID,P.ProductName,P.SupplierID,         OD.OrderID,OD.UnitPrice,OD.Quantity
FROM [DBO].Products P
INNER JOIN [DBO].[Order Details] OD ON OD.ProductID = P.ProductID
GOIF OBJECT_ID('[DBO].[VW_Trigger_Example') IS NOT NULLBEGIN   PRINT '[DBO].[VW_Trigger_Example view created..'ENDGO--SELECT * FROM VW_Trigger_ExampleIF OBJECT_ID('[DBO].Tr_Delete_TriggerExample','TR') IS NOT NULLBEGIN DROP TRIGGER [DBO].Tr_Delete_TriggerExample
PRINT '[DBO].Tr_Delete_TriggerExample trigger dropped..'ENDGOCREATE TRIGGER [DBO].Tr_Delete_TriggerExampleON [DBO].VW_Trigger_ExampleINSTEAD OF DELETEAS
BEGIN   PRINT '----------------------------------------'   PRINT 'This is an example of INSTEAD OF Trigger'   PRINT '----------------------------------------'   SELECT TOP 1 * FROM DELETEDENDGOIF OBJECT_ID('[DBO].Tr_Delete_TriggerExample','TR') IS NOT NULLBEGIN PRINT '[DBO].Tr_Delete_TriggerExample trigger created..'ENDGO--O/P
--SELECT * FROM [DBO].[VW_Trigger_Example] WHERE ProductID = 11DELETE FROM [DBO].[VW_Trigger_Example] WHERE ProductID=11
How to view the Created Views?
There are few ways to view the scehema definition of the created views.
SP_HELPTEXT vw_LocalPartion_ViewSELECT id,text FROM SYSCOMMENTS WHERE id = OBJECT_ID('[DBO].vw_LocalPartion_View')SELECT object_id,definition FROM SYS.SQL_MODULES WHERE OBJECT_ID = OBJECT_ID('[DBO].vw_LocalPartion_View')
How to drop the View?
If you want to drop the view then you can use the following statement. When you drop the table underlying view will not be deleted. But if you run that view it will thrown an error.

DROP VIEW VIEW_NAME
How to alter the view?
If you want to do changes in the created views then you can alter the view whatever you want to view the same view name.
ALTER VIEW VIEW_NAME

SELECT [Columns List]....

C++ Get CPU and Memory Utilisation

2012-06-24T11:48:00.002-07:00

Write and compile the application

While you can get Memory status fairly easlily with GlobalMemoryStatusEx, there is no equivalent function for CPU. Therefore you have to use PDH Performance Counter Interface to get CPU utilisation. Write the application and save is as check.cpp.

Also note that CPU is a difference between two PdhCollectQueryData calls, so if you call this once and try to get PdhGetFormattedCounterValue you will get an error.

 1. #include <iostream>
 2. #include <windows.h>
 3. #include <stdio.h>
 4. #include <pdh.h>
 5. #include <pdhmsg.h>
 6. 
 7. #define KB 1024
 8. void main(int argc, char *argv[]){
 9. 
10.     PDH_HQUERY hquery;
11.     PDH_HCOUNTER hcountercpu;
12.     PDH_HCOUNTER hcounterram;
13.     PDH_STATUS status;
14.     LPSTR pMessage;
15.     PDH_FMT_COUNTERVALUE countervalcpu;
16.     PDH_FMT_COUNTERVALUE countervalram;
17.     MEMORYSTATUSEX memstat;
18.     
19.     memstat.dwLength = sizeof (memstat);
20. 
21.     if((status=PdhOpenQuery(NULL, 0, &hquery))!=ERROR_SUCCESS){
22.         printf("PdhOpenQuery %lx\n", status);    
23.         goto END;
24.     }
25. 
26.     if((status=PdhAddCounter(hquery,
27.                             "\\Processor(_Total)\\% Processor Time",
28.                             0, 
29.                             &hcountercpu))!=ERROR_SUCCESS){
30.         printf("PdhAddCounter (cpu) %lx\n", status);    
31.         goto END;
32.     }
33.     if((status=PdhAddCounter(hquery,
34.                             "\\Memory\\Available Bytes",
35.                             0, 
36.                             &hcounterram))!=ERROR_SUCCESS){
37.         printf("PdhAddCounter (ram) %lx\n", status);    
38.         goto END;
39.     }
40.     
41.     /*Start outside the loop as CPU requires difference 
42.     between two PdhCollectQueryData s*/
43.     if((status=PdhCollectQueryData(hquery))!=ERROR_SUCCESS){
44.         printf("PdhCollectQueryData %lx\n", status);    
45.         goto END;
46.     }
47. 
48.     while(true){
49. 
50.         if((status=PdhCollectQueryData(hquery))!=ERROR_SUCCESS){
51.             printf("PdhCollectQueryData %lx\n", status);    
52.             goto END;
53.         }
54.         if(GlobalMemoryStatusEx(&memstat)==0){
55.             printf("GlobalMemoryStatusEx %d\n", GetLastError());
56.             goto END;
57.         }
58. 
59.         if((status=PdhGetFormattedCounterValue(hcountercpu, 
60.                                                 PDH_FMT_LONG, 
61.                                                 0, 
62.                                                 &countervalcpu))!=ERROR_SUCCESS){
63.             printf("PdhGetFormattedCounterValue(cpu) %lx\n", status);    
64.             goto END;
65.         }
66.         if((status=PdhGetFormattedCounterValue(hcounterram, 
67.                                                 PDH_FMT_LONG, 
68.                                                 0, 
69.                                                 &countervalram))!=ERROR_SUCCESS){
70.             printf("PdhGetFormattedCounterValue(ram) %lx\n", status);    
71.             goto END;
72.         }
73.         printf("cpu %3d%% \tmem %3d%% \tavail (%d mb)\n", 
74.             countervalcpu.longValue, 
75.             memstat.dwMemoryLoad, 
76.             countervalram.longValue/(KB*KB));
77. 
78.         Sleep(1000);
79. 
80.     }
81. END:
82.     ;
83. }

Open a prompt to the working directory and compile the code using the windows cl.exe compiler. You just need to include the pdh.lib.

..workspace\PerfCounter>cl check.cpp pdf.lib
Now run the program in the command prompt. You should see the cpu and memory snapshot displayed every second.

WPF Controls Progrrammatically

2012-06-24T10:57:00.000-07:00

Let’s create a sample app, and add a new window. I named mine AddControls. Here’s the XAML:

<Window x:Class=“WPFSample001.AddControls“

    xmlns=“http://schemas.microsoft.com/winfx/2006/xaml/presentation“

    xmlns:x=“http://schemas.microsoft.com/winfx/2006/xaml“

    Title=“AddControls“ Height=“114“ Width=“212“

    >

  <StackPanel Name=“splMain“>

    <Button Name=“btnAddMore“ Click=“btnAddMore_Click“>Add Another</Button>

  </StackPanel>

</Window>

And here’s what it looks like:

A few things I’d like to point out. I’ve given a name to the StackPanel, so it can be manipulated in our C# code. I also added a handler for the Click event for the button, btnAddMore_Click. I also named the button, although it really wasn’t necessary for this sample.
OK, make sure to build the app so intellisense will work, then let’s jump to the C# code behind. (You may get an error about the click handler for the button not being found, that’s fine just ignore it.)
First, we’ll create an event handler for the button, passing in the sender and routed event args, like I discussed yesterday (http://arcanecode.wordpress.com/2007/09/05/the-wpf-button/) . Then, all we have to do is create a button control and add it to the children collection of the StackPanel, like so:

    public void btnAddMore_Click(object sender, RoutedEventArgs e)

    {

      System.Windows.Controls.Button newBtn = new Button();

      newBtn.Content = “A New Button”;

      splMain.Children.Add(newBtn);

    }

Note in this example I used the fully qualified System.Windows.Controls, I did that just to be explicit where the Button came from. After a new button is created, I set it’s Content property, which in this case will be the text on the button.
In the final line, I add it to the children collection of the StackPanel. When you run it, and press the “Add Another” Button, you will see:

Now we have a new problem. We’ve added a button to the StackPanel, but clicking on it does no good as we haven’t tied it to an event handler. Turns out that’s pretty easy too.

    public void btnAddMore_Click(object sender, RoutedEventArgs e)

    {

      System.Windows.Controls.Button newBtn = new Button();

      newBtn.Content = “A New Button”;

      newBtn.Click += new RoutedEventHandler(newBtn_Click);

      splMain.Children.Add(newBtn);

    }

What I did was use a delegate. I added a new RoutedEventHandler and tied it to the click event. The code for the event is in a method named newBtn_Click:

    private void newBtn_Click(object sender, RoutedEventArgs e)

    {

      MessageBox.Show(“New Button Clicked!”, “I got pressed.”);

    }

The signature for the event handler has to match the signature for a Click event, since that’s what we’re routing to. Here, all I do is display a message box just so you can see something got done. Run it again and press the Add Another button, and the “A New Button” should appear. Press the new button and you should see a message box.

Finally, I want to be clear you can use this technique to add any sort of control. Here I’ve added a Label as well as a button:

    public void btnAddMore_Click(object sender, RoutedEventArgs e)

    {

      System.Windows.Controls.Button newBtn = new Button();

      newBtn.Content = “A New Button”;

      newBtn.Click += new RoutedEventHandler(newBtn_Click);

      splMain.Children.Add(newBtn);

      System.Windows.Controls.Label newLbl = new Label();

      newLbl.Content = “Hi Mom!”;

      splMain.Children.Add(newLbl);

    }

I could have created the entire form in C# (or VB.Net) code, adding the StackPanel directly to the “this” object. However, that gets a bit laborious, and I wouldn’t recommend it as a general practice.

Full Text Search In Sql Server 2008

2012-06-24T10:51:00.002-07:00

The first query simply returns a list of all of the catalogs in the system.

– Get current list of full text catalogs

select [name] as CatalogName

    , path

    , is_default

  from sys.fulltext_catalogs

 order by [name];

The next query returns a list of all the StopLists.

 – Get the list of StopLists

 select stoplist_id

      , name 

   from sys.fulltext_stoplists;

This query returns a list of StopWords in the database. Note the linking to get the associated StopList name and language.

 – Get list of StopWords

 select sl.name as StopListName

      , sw.stopword as StopWord

      , lg.alias as LanguageAlias

      , lg.name  as LanguageName

      , lg.lcid  as LanguageLCID

   from sys.fulltext_stopwords sw

   join sys.fulltext_stoplists sl 

    on sl.stoplist_id = sw.stoplist_id

   join master.sys.syslanguages lg 

    on lg.lcid = sw.language_id;

This next query gets a list of all of the stopwords that ship with SQL Server 2008. This is a nice improvement, you can not do this in SQL Server 2005.

– Get a list of the System provided stopwords   

select ssw.stopword

    , slg.name

  from sys.fulltext_system_stopwords ssw

  join sys.fulltext_languages slg 

    on slg.lcid = ssw.language_id;

My next query returns a list of all the Full Text Indexes in the database.

– List full text indexes

select c.name as CatalogName

    , t.name as TableName

    , idx.name as UniqueIndexName

    , case i.is_enabled 

        when 1 then ‘Enabled’ 

        else ‘Not Enabled’ 

       end as IsEnabled

    , i.change_tracking_state_desc

    , sl.name as StopListName 

  from sys.fulltext_indexes i

  join sys.fulltext_catalogs c 

    on i.fulltext_catalog_id = c.fulltext_catalog_id

  join sys.tables t 

    on i.object_id = t.object_id

  join sys.indexes idx 

    on i.unique_index_id = idx.index_id

       and i.object_id = idx.object_id

  left join sys.fulltext_stoplists sl 

    on sl.stoplist_id = i.stoplist_id

This query returns a list of all the document types SQL Server 2008 understands when they are placed in a varbinary(max) field.

– List all of the document types SQL Server 2008 will understand in varbinary(max) field

select document_type

    , path

    , [version]

    , manufacturer 

  from sys.fulltext_document_types;

If your full text performance begins to suffer over time, you might want to check and see how many fragments exist. If you have multiple closed fragments, you should consider doing a REORGANIZE on the index (using alter fulltext index). This query will tell you how many fragments exist for your full text index.

– See how many fragments exist for each full text index.

– If multiple closed fragments exist for a table do a REORGANIZE to help performance

select t.name as TableName

    , f.data_size

    , f.row_count

    , case f.status

        when 0 then ‘Newly created and not yet used’

        when 1 then ‘Being used for insert’

        when 4 then ‘Closed ready for query’

        when 6 then ‘Being used for merge inpurt and ready for query’

        when 8 then ‘Marked for deletion. Will not be used for query and merge source’

        else ‘Unknown status code’

       end

  from sys.fulltext_index_fragments f

  join sys.tables t on f.table_id = t.object_id;

There you go, a handful of powerful queries to help you query and maintain the state of your full text indexes.

Upload File Form in php

2012-06-24T10:40:00.003-07:00

This below code allow user to upload image in web page that made in php program language ..

html code :

<html>
<body>

<form action="upload_file.php" method="post"
enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>

</body>
</html>

the following about the HTML form above:

The enctype attribute of the <form> tag specifies which content-type to use when submitting the form. "multipart/form-data" is used when a form requires binary data, like the contents of a file, to be uploaded
The type="file" attribute of the <input> tag specifies that the input should be processed as a file. For example, when viewed in a browser, there will be a browse-button next to the input field

Note: Allowing users to upload files is a big security risk. Only permit trusted users to perform file uploads.

Create The Upload Script

The "upload_file.php" file contains the code for uploading a file:

<?php
if ($_FILES["file"]["error"] > 0)
  {
  echo "Error: " . $_FILES["file"]["error"] . "<br />";
  }
else
  {
  echo "Upload: " . $_FILES["file"]["name"] . "<br />";
  echo "Type: " . $_FILES["file"]["type"] . "<br />";
  echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
  echo "Stored in: " . $_FILES["file"]["tmp_name"];
  }
?>

By using the global PHP $_FILES array you can upload files from a client computer to the remote server.
The first parameter is the form's input name and the second index can be either "name", "type", "size", "tmp_name" or "error". Like this:

$_FILES["file"]["name"] - the name of the uploaded file
$_FILES["file"]["type"] - the type of the uploaded file
$_FILES["file"]["size"] - the size in bytes of the uploaded file
$_FILES["file"]["tmp_name"] - the name of the temporary copy of the file stored on the server
$_FILES["file"]["error"] - the error code resulting from the file upload

This is a very simple way of uploading files. For security reasons, you should add restrictions on what the user is allowed to upload.

Restrictions on Upload

In this script we add some restrictions to the file upload. The user may only upload .gif or .jpeg files and the file size must be under 20 kb:

Note: For IE to recognize jpg files the type must be pjpeg, for FireFox it must be jpeg.

Saving the Uploaded File

The examples above create a temporary copy of the uploaded files in the PHP temp folder on the server.
The temporary copied files disappears when the script ends. To store the uploaded file we need to copy it to a different location:

<?php
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

    if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
      }
    }
  }
else
  {
  echo "Invalid file";
  }
?>

The script above checks if the file already exists, if it does not, it copies the file to the specified folder.

make rss feed in asp.net

2012-06-24T10:29:00.001-07:00

Using the XmlTextWrite to output an XML file that serves as an RSS feed.

using System.Data.SqlClient;
using System.Text;
using System.Xml;
...
int copyrightyear = DateTime.Now.Year;
Response.Clear();
Response.ContentType = "text/xml";
XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
writer.WriteStartDocument();
writer.WriteStartElement("rss");
writer.WriteAttributeString("version", "2.0");
writer.WriteStartElement("channel");
writer.WriteElementString("title", "Mikesdotnetting News Feed");
writer.WriteElementString("link", 
  "http://www.mikesdotnetting.com/rss.aspx");
writer.WriteElementString("description", 
  "Latest additions to the rubbish that appears on Mikesdotnetting.com.");
writer.WriteElementString("copyright", "(c) " + copyrightyear.ToString() +
  ", Mikesdotnetting. All rights reserved.");
string connectionString = Utils.GetConnString();
using (SqlConnection conn = new SqlConnection(connectionString))
{
  using (SqlCommand objCommand = new SqlCommand("GetRss", conn))
  {
    objCommand.CommandType = CommandType.StoredProcedure;
    conn.Open();
    using (SqlDataReader objReader = objCommand.ExecuteReader())
    {
      while (objReader.Read())
      {
        writer.WriteStartElement("item");
        writer.WriteElementString("title", objReader.GetString(1));
        writer.WriteElementString("description", objReader.GetString(2));
        writer.WriteElementString("link", "http://www.mikesdotnetting.com/Article.aspx?ArticleID=
          " + objReader.GetInt32(0).ToString());
        writer.WriteElementString("pubDate", 
          objReader.GetDateTime(3).ToString("R"));
        writer.WriteEndElement();
      } 
      objReader.Close();
      conn.Close();
      writer.WriteEndElement();
      writer.WriteEndElement();
      writer.WriteEndDocument();
      writer.Flush();
      writer.Close();
      Response.End();
    }
  }
}

Rss File Code Project

2012-06-24T10:23:00.004-07:00

Having an RSS feed on your website is a great way of sharing your content with the rest of the Internet. It’s not a new technology and it’s probably something that you use on a daily basis. If you have a blog or use any form of CMS, that software will most likely handle the creation of your RSS feed for you.
Sometimes, however, it might be necessary for you to create a RSS feed yourself. Perhaps you have just won a new client who’s current site has a old bespoke CMS which they like and want to keep, but you want to be able to publish their updated content via RSS. Hopefully this tutorial will help you to achieve this.

What is RSS?

RSS, in its current form, stands for Really Simple Syndication and is a family of web formats to publish frequently updated content. The RSS Feed (as it is commonly known) can then be read by the users feed reading software or by another website which wishes to ‘syndicate’ the content of that feed.

The RSS format is based on XML that is built using standardised tags. Here is an example of a basic RSS document, we will be generating something similar using PHP later in this tutorial:

<?xml version="1.0" encoding="ISO-8859-1"?>

<rss version="2.0">

    <channel>

        <title>My RSS feed</title>

        <link>http://www.mywebsite.com/</link>

        <description>This is an example RSS feed</description>

        <language>en-us</language>

        <copyright>Copyright (C) 2009 mywebsite.com</copyright>

        <item>

            <title>My News Story 3</title>

            <description>This is example news item</description>

            <link>http://www.mywebsite.com/news3.html</link>

            <pubDate>Mon, 23 Feb 2009 09:27:16 +0000</pubDate>

        </item>

        <item>

            <title>My News Story 2</title>

            <description>This is example news item</description>

            <link>http://www.mywebsite.com/news2.html</link>

            <pubDate>Wed, 14 Jan 2009 12:00:00 +0000</pubDate>

        </item>

        <item>

            <title>My News Story 1</title>

            <description>This is example news item</description>

            <link>http://www.mywebsite.com/news1.html</link>

            <pubDate>Wed, 05 Jan 2009 15:57:20 +0000</pubDate>

        </item>

    </channel>

  </rss>

As we know, RSS is made up of standardised XML tags which you would normally find in a flat XML file. What we are going to do is create this standard XML data dynamically using PHP. This means that the URL for our feed will end with the .php extension, but we will tidy this up later in the tutorial.
So, lets start building the PHP script. The first thing we are going to do is tell PHP what type of data we would like to output (I am going to break each section of the script down, but I will include it in full at the end):

<?php

    header("Content-Type: application/rss+xml; charset=ISO-8859-1");

The header() function that we have called is telling PHP to output our data using the XML MIME type as well as to use the ISO-8859-1 character set. This makes sure that our content is delivered to the users in the correct format.
Now we are going to define our database connection details and create the header XML tags for our RSS feed. I’m going to statically assign the feed information tags just to keep it simple, however, you may wish to expand on this to dynamically set these. That way, you can re-use this code as a function or even go a step further and use it to build your own PHP class. The actual feed data will be kept in a variable called $rssfeed.

DEFINE ('DB_USER', 'my_username');

DEFINE ('DB_PASSWORD', 'my_password');

DEFINE ('DB_HOST', 'localhost');

DEFINE ('DB_NAME', 'my_database'); 

$rssfeed = '<?xml version="1.0" encoding="ISO-8859-1"?>';

$rssfeed .= '<rss version="2.0">';

$rssfeed .= '<channel>';

$rssfeed .= '<title>My RSS feed</title>';

$rssfeed .= '<link>http://www.mywebsite.com </link>';

$rssfeed .= '<description>This is an example RSS feed</description>';

$rssfeed .= '<language>en-us</language>';

$rssfeed .= '<copyright>Copyright (C) 2009 mywebsite.com</copyright>';

Next, we need to extract our data by looping through our MySQL database to create the <item> tags. I’m not going to explain this part in too much details as it’s not point of this tutorial and you may do this differently. We are going to assume that our MySQL table (“mytable”) has columns called title, description, link and date which hold the relevant data:

 <?php   

 $connection = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)

        or die('Could not connect to database');

    mysql_select_db(DB_NAME)

        or die ('Could not select database');

    $query = "SELECT * FROM mytable ORDER BY date DESC";

    $result = mysql_query($query) or die ("Could not execute query");

    while($row = mysql_fetch_array($result)) {

        extract($row);

        $rssfeed .= '<item>';

        $rssfeed .= '<title>' . $title . '</title>';

        $rssfeed .= '<description>' . $description . '</description>';

        $rssfeed .= '<link>' . $link . '</link>';

        $rssfeed .= '<pubDate>' . date("D, d M Y H:i:s O", strtotime($date)) . '</pubDate>';

        $rssfeed .= '</item>';

    }

    $rssfeed .= '</channel>';

    $rssfeed .= '</rss>';

    echo $rssfeed;

 ?>

The first part of this section connects to the MySQL database using the constants which we defined at the start of the script. Then we perform a basic SQL query to pull out all our data from the database in date order. The final part of the query, DESC, ensures that the newest content will appear first in the users RSS reader.
Next, we look at each row of data from the results of the query using a while loop. In each loop cycle, the first action performed is the extract() function to create a set of variables that take the name of the columns of the database, in my case $title, $description, $link, and $date. We then add the data contained in these variables to our main $rssfeed variable. When it reaches the final row of data, the while loop ends and we apply the closing XML tags.
The final step of the script is to actually output the data we have collected. This is simply done by echoing the $rssfeed variable. Here is the code in full:

<?php

    header("Content-Type: application/rss+xml; charset=ISO-8859-1");

    DEFINE ('DB_USER', 'my_username');

    DEFINE ('DB_PASSWORD', 'my_password');

    DEFINE ('DB_HOST', 'localhost');

    DEFINE ('DB_NAME', 'my_database'); 

    $rssfeed = '<?xml version="1.0" encoding="ISO-8859-1"?>';

    $rssfeed .= '<rss version="2.0">';

    $rssfeed .= '<channel>';

    $rssfeed .= '<title>My RSS feed</title>';

    $rssfeed .= '<link>http://www.mywebsite.com</link>';

    $rssfeed .= '<description>This is an example RSS feed</description>';

    $rssfeed .= '<language>en-us</language>';

    $rssfeed .= '<copyright>Copyright (C) 2009 mywebsite.com</copyright>';

    $connection = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)

        or die('Could not connect to database');

    mysql_select_db(DB_NAME)

        or die ('Could not select database');

    $query = "SELECT * FROM mytable ORDER BY date DESC";

    $result = mysql_query($query) or die ("Could not execute query");

    while($row = mysql_fetch_array($result)) {

        extract($row);

        $rssfeed .= '<item>';

        $rssfeed .= '<title>' . $title . '</title>';

        $rssfeed .= '<description>' . $description . '</description>';

        $rssfeed .= '<link>' . $link . '</link>';

        $rssfeed .= '<pubDate>' . date("D, d M Y H:i:s O", strtotime($date)) . '</pubDate>';

        $rssfeed .= '</item>';

    }

    $rssfeed .= '</channel>';

    $rssfeed .= '</rss>';

    echo $rssfeed;

?>

I mentioned earlier that I would tidy up the .php extension of the feed. I don’t know about you, but I find this a little bit ugly. When you see RSS feeds that have been generated by WordPress for example, you don’t see the actual file name, you just get the containing folder. To do this, create a folder in the root directory of the site and call it ‘feed’. Create a file in this new folder called ‘index.php’ and copy the code above into it. This leaves us with a nicer looking feed URL, in the case of this example, http://www.mydomain.com/feed/.

Writing a Text File

2012-06-24T10:17:00.002-07:00

This short piece of code demonstrates how to write a text file in Java. The PrinterWriter class contains a number of methods for outputting text to a file. The FileWriter class is a convenience class for writing to a text file. It uses the default code page for the operating environment your virtual machine is running in. If you need to specify a specific code page, then you must use the OutputStreamWriter class instead.

 1:/** Simple Program to write a text file
   2:*/
   3:
   4: import java.io.*;
   5:
   6: public class WriteText{
   7:    public static void main(String[] args){
   8:        try {
   9:            FileWriter outFile = new FileWriter(args[0]);
  10:            PrintWriter out = new PrintWriter(outFile);
  11:            
  12:            // Also could be written as follows on one line
  13:            // Printwriter out = new PrintWriter(new FileWriter(args[0]));
  14:        
  15:            // Write text to file
  16:            out.println("This is line 1");
  17:            out.println("This is line 2");
  18:            out.print("This is line3 part 1, ");
  19:            out.println("this is line 3 part 2");
  20:            out.close();
  21:        } catch (IOException e){
  22:            e.printStackTrace();
  23:        }
  24:    }
  25: }

How to Create a JavaScript Animation

2012-06-24T09:58:00.000-07:00

JavaScript animations aren't difficult to write. Once you learn a few main ideas, you can create complex animations that take up as much or as little of the browser window as you like, including interactive content that degrades well for people who don't have JavaScript enabled. What's more, the content inside your animations will be available to search engines because the content is in machine-readable (X)HTML.
In this tutorial we'll start out with the basics of animation, how to make things move, turn animations on and off, and determine the edges of the space where you want the motion to take place. All of the code in this tutorial has been tested on Mozilla Firefox, Windows, Linux; Konquerer on Linux; and MS IE on Windows.

A Matter of Timing

At some point most of us have played with a flip book to see how animation works. The classic flip book is a little ball that bounces around the field of the page as the pages flip past. The image isn't really moving, but each page has the image placed slightly differently from the last, and our brains perceive that as movement. In TV and movies, the same thing happens, only without all the pages sitting in our hands. The images flip past our vision, one at a time, at a rate of 24, 25 or 30 images per second, depending on the medium we are viewing (film, PAL video and NTSC video respectively). This is known as the "frame rate."
To make an animation on the computer, we want to move an image in a similar way, only we don't have "frames" to work with. Instead, we have milliseconds in which we can execute commands. We can change what's on the screen every millisecond in order to create the appearance of motion. We don't have to change the screen nearly that fast, though. The human eye can only register motion at a rate of approximately 24 frames per second. Faster than that, and the brain just doesn't recognize the difference. For the ease of calculation, then, it's simple to consider an optimum image change rate or 25 frames/1000 milliseconds. That's the same as saying 1/40, or 1"frame" change every 40 milliseconds.
On the Internet, we often cheat a bit, seeing exactly how far we can push the weaknesses in human perception to use smaller files and less computer power to present the same experience to the end user. It just so happens that for most Web animations you can get away with exactly half the optimal frame rate without the movement looking too choppy. So, for this tutorial we'll use 1 frame every 80 milliseconds.
In JavaScript, we have the setTimeout() and setInterval() functions to help us count time and create our frame rate. The function setTimeout() will count the time and then run the command that you give it. The setInterval() function will repeat a function every time it reaches the time count that you have given it. Both functions count by milliseconds.

Examples:


1	setTimeout('animBall()', 80); // run the function animBall after 80 milliseconds.
2	setInterval('animBall()', 80); // run the function animBall() every 80 milliseconds.

In the case of setTimeout(),

if you want to run a single function over and over at the time count that you have set, you need to put the function inside of the function it calls. So you will end up with a function that looks something like:


1	function animBall(){
2	setTimeout('animBall()', 80); // set the timer so that this function will run again in 80 milliseconds
3	moveRight();
4	doOtherStuff();
5	}

In the case of setInterval(), the call should be made outside the function that you want to repeat. Otherwise, you end up with multiple instances of your interval, a strange acceleration of movement, and a big, fat memory leak.


1	<script language="javascript">
2	function animBall() {
3	moveRight();
4	doOtherStuff();
5	}
6	</script><a href="javascript:setIntveral('animBall()', 80)">Start Animation</a>

Chances are, at some point you'll want to stop the animation. To do so, you'll need either clearTimeout() or clearInterval(). Both of these clearing functions take a variable which represents a timing object, and clears it's timer. To make these work, you need to create the object that your clear function will stop.

Timeout Example:


1	<script language="javascript">
2	var t;
3	function animBall(){
4	t=setTimeout('animBall()', 80);
5	moveRight();
6	doOtherStuff();
7	}
8	</script><a href="javascript:animBall()">Start Animation</a> <a href="javascript:clearTimeout(t)">Stop Animation</a>

Interval Example:


1	<script language="javascript">
2	function animBall() {
3	moveRight();
4	doOtherStuff();
5	}
6	</script><a href="javascript:var t=setIntveral('animBall()', 80)">	Start Animation</a>

<a href="javascript:clearInterval(t)">Stop Animation</a>

Fast Technology: Application, Session, HttpContext, and ViewState

2012-06-23T13:49:00.001-07:00

Fast Technology: Application, Session, HttpContext, and ViewState: Application, Session, HttpContext, and ViewState

Application, Session, HttpContext, and ViewState

2012-06-23T13:30:00.001-07:00

Application, Session, HttpContext, and ViewState Caching

Using the Application, Session, HttpContext and ViewState objects for caching data is not a new technique, and while extremely simple, it shouldn't be left out or ignored because of other techniques. All three objects provide simple key based collections for storage of data through the lifetime of the object. Since this lifetime is not persistent, you should only store data that is ephemeral in nature; anything that requires long-lived storage should use a database, or perhaps the Profile object for user-related data.

Using the Application State

The Application object exists for the lifetime of the application; that is, from the moment the first request to the application is received to the moment the application is shut down. Application shutdown can occur under different circumstances, and you should be aware that it can happen while the site is being used. ASP.NET is self-monitoring and can restart an application if, for example, memory demands exceed set limits. This means that you shouldn't rely on an item automatically being stored in the Application object; you should always check for a null value.

Using the Application object for state storage is as simple as indexing the Application object. For example:

Application["Start"] = DateTime.Now;

This will add the current date and time to the Application cache, indexed by Start. To extract the value, you use the same indexing scheme; but the application stores objects, so casting is required:

DateTime appStart = (DateTime)Application["Start"];

Because object storage is supported, you can store complex types, such as data. For example, a common caching pattern is to check to see if the data is in the cache (irrespective of which form of caching is used), and if it's present, return the data. If the data isn't present in the cache, it is fetched from its original location and stored in the cache. For example, consider some data from a database that is required in all pages, which could be stored in the application, as shown in Listing 6.1.

Storing Data in the Application

DataTable cachedData = (DataTable)Application["CommonData"];
if (cachedData == null)
{
  cachedData = DataLayer.FetchCommonData();
  Application["CommonData"] = cachedData;
}

Here the data is fetched from the Application, which returns null if the item isn't present, and if it isn't present, then it is fetched from the data layer and placed in the Application for subsequent requests. When using this form of caching, you have to balance the resource use (when storing the data in the application) against the time taken to fetch it from its original location. Performance and memory monitoring tools are useful in helping you make this decision.

If you know that every single page is going to use some cached data, you can use the Application_Start event to load the data, because this event runs once when the application starts. In this situation, you wouldn't need to check for the cached item, because you know it wouldn't be present when the application is just starting. If, however, only a selected number of pages use the cached data, or if use of the cached data is dependent upon user actions, you can use the code in Listing 6.1 to lazy load the datathat is, load it only when it is first requested and then cache it for later use.

Using the Session State

Session state is similar in use to Application state, but with one major exception: It is unique to each user of the site and is destroyed when the user leaves the site (after a timeout). Session state is therefore useful for storing data that a user would require throughout his or her use of the application. Bear in mind that Session state is intended for storage of transient datadata that doesn't need to be retained after the user leaves the site. For long-lived data, such as user preferences, you should use the Profile.

Listing 6.2 shows a common pattern for using the Session object for state storage.

Storing Data in the Session

DataTable cachedData = (DataTable)Session["UserData"];
if (cachedData == null)
{
  cachedData = DataLayer.FetchUserData();
  Session["UserData"] = cachedData;
}

Like the Application state, Session state takes resources, so you should examine your needs carefully. By default, Session state is enabled for applications and pages but can be turned off or disabled completely.

Disabling Session State

Disabling Session state is a performance optimization that you can perform at several levels. In pages, you can use the EnableSessionState attribute of the Page directive:

<% Page EnableSessionState="false" ... %>

Alternatively, if you require access to Session state but don't plan to update it, you can make it read-only for a page:

<% Page EnableSessionState="ReadOnly" ... %>

This ensures that you still have access, but don't go through the overhead of locking the state for update.

Configuring Session State

At the application level, you configure Session state in web.config, as seen in Listing 6.3.

The attributes are documented in Figure.

Attributes of SessionState Configuration
Attribute	Description
`allowCustomSqlDatabase`	Only relevant when mode is set to `SQLServer`, and indicates whether or not a custom database name can be specified in the `Initial Catalog` attribute of the SQL Server connection string. The default value is `false`, meaning the default ASP.NET session database is used.
`cookieless`	Indicates how cookies are used, and can be one of: `AutoDetect`, where ASP.NET determines whether the requesting device supports cookies. If so, then cookies are used; otherwise the query string is changed to include the session identifier. `UseCookies`, where cookies are always used. This is the default value. `UseDeviceProfile`, where ASP.NET uses the browser capabilities to determine whether cookies should be used. `UseUri`, where the query string is always used. `true`, which has the same effect as `UseUri`. `false`, which has the same effect as `UseCookies`.
`cookieName`	Defines the default cookie name used to store the session ID. The default value is `ASP.NET_SessionId`.
`customProvider`	Indicates the name of the provider when the mode is `Custom`. The `name` attribute should match one of the provider names declared in the `<Providers/>` section, and defaults to an empty string.
`mode`	Indicates how session state is being managed, and can be one of: `Custom`, which indicates that session state is stored in a custom manner. `InProc`, where session state is stored within the ASP.NET process. This is the default value. `Off`, where session state is turned off for the application. `SQLServer`, where session state is stored in a SQL Server database. `StateServer`, where session state is stored in a separate ASP.NET State Service.
`partitionResolverType`	Defines a type to be used to resolve the connection string for the request. Resolvers are used to enable session state to be partitioned to scale in Web Farm situations. If this attribute is set, the `sqlConnectionString` and `stateConnectionString` attributes are ignored. The default value is an empty string.
`regenerateExpiredSessionId`	Indicates whether or not the session identifier will be reissued when an invalid identifier is used by the client. The default value is `true`, where identifiers are only reissued when cookies aren't being used.
`sqlCommandTimeout`	Indicates, in seconds, the timeout for a SQL command when the mode is `SQLServer`. The default value is 30.
`sqlConnectionString`	Indicates the name of the connection string when using SQL Server to store session state. The default value is `"data source=127.0.0.1; Integrated Security=SSPI"`, pointing at a local, trusted SQL Server database.
`stateConnectionString`	Required when `mode` is `StateServer`, and defines the server name/address and port where session state is stored. The default value is `"127.0.0.1:42424"`.
`stateNetworkTimeout`	For when `mode` is `StateServer`, and defines the number of seconds to wait for the remote state server before the request is cancelled. The default value is `10` seconds.
`timeout`	Defines the number of minutes to wait after session activity (i.e., idle time) before the session is abandoned. The default value is `20` minutes.
`useHostingIdentity`	Indicates whether or not session state will revert to the hosting identity or use client impersonation. The default value is `true`, indicating that the identity of the hosting process (ASPNET on IIS5 or NETWORK SERVER on IIS6) or the identity specified in the process <identity> section is used. If false, the credentials of the current OS thread are used.

You can see that there are a number of ways in which Session state can be stored. By default, the ASP.NET process stores the state, because this provides the fastest storage. However, because it is process-bound, Session state would not survive an application restart, which is where the state server and database options come in. The downsides of these, however, are that performance is slower than with the in-process method. For more detailed information on session state and performance, there is an excellent article in the MSDN Magazine, available online at http://msdn.microsoft.com/msdnmag/issues/05/09/SessionState/default.aspx.

Session State Configuration

<sessionState
  allowCustomSqlDatabase="[true|false]"
  cookieless="[AutoDetect|UseCookies|UseDeviceProfile|
               UseUri|true|false]"
  cookieName="String"
  customProvider="String"
  mode="[Custom|InProc|Off|StateServer|SQLServer|]"
  partitionResolverType="String"
  regenerateExpiredSessionId="[true|false]"
  sessionIdManagerType="String"
  sqlCommandTimeout="Integer"
  sqlConnectionString="String"
  stateConnectionString="String"
  stateNetworkTimeout="Integer"
  timeout="Integer"
  useHostingIdentity="[true|false]"
  >
  <providers>
    <clear />
    <add
      Name="String"
      Type="String"
      [providerSpecificConfiguration] />
  </providers>
</sessionState>

The SessionState configuration element should not be confused with the SessionPageState element, which is used to keep a history of view state and control state within the session.

Using HttpContext

If you don't need to store data across an entire session, but perhaps require data across multiple user controls within a page, then you can use the current context of the request. Each request has an associated HttpContext object associated with it, which provides access to many objects used within pages, such as the Request, Profile, and Trace. Also available on the context is an Items collection that can be used for storage and is particularly useful when you have multiple user controls on a page that need to share data. It is important to realize that this technique is only useful between controls within a single end-to-end request and that it does not apply between separate page requests.

For example, consider two grids that use the same data. You could use the data source controls and their built-in caching, but if you have an existing code library and need to bind in code, you might have the code shown in Listing 6.4 in both user controls:

Simple Binding to a Business Layer

protected void Page_Load(object sender, EventArgs e)
{
  if (!Page.IsPostBack)
  {
    GridView3.DataSource = Shippers.GetShippers();
    GridView3.DataBind();
  }
}

This code, if used in multiple user controls, would result in the same SQL command being run multiple times. There are several ways to cure this, and we'll look at others later in the chapter, but a simple solution would be for one control to read the data and cache it in the context. Rather than explicitly putting the code into your user control (which would limit the order of the controls on the page to ensure that the one that cached the data was executed first), you could create a central class, as shown in Listing 6.5.

A Caching Class Using the HttpContext

public static class Caching
{
  public static List<Shipper> GetShippers()
  {
    List<Shipper> ships =
        (List<Shipper>)HttpContext.Current.Items["Shippers"];
    if (ships == null)
    {
      ships = Shippers.GetItems();
      HttpContext.Current.Items["Shippers"] = ships;
    }
    return ships;
  }
}

This code is extremely simple and follows the by-now familiar pattern used in caching. It first fetches the data from the Items collection, and if it's not present in the cache, gets the data from the Shippers business class and stores it in the Items collection. Subsequent calls will fetch it from the collection.

Using ViewState

Another method of caching data is to use ViewState, although this does come with the warning that ViewState is transferred to and from the client on each request. The ViewState can be accessed just like other collections:

ViewState["CachedData"] = DateTime.Now;

You should generally try to use as little ViewState caching as possible in order to reduce overheads in transferring pages, but it does provide an alternative storage mechanism for small amounts of data. For best performance, you should turn off ViewState for controls and pages that don't require it. ASP.NET 2.0 supports a new feature for state storage, Control-State, which controls use to support the minimum state requirements for the control to operate. This allows ViewState to be turned off but for the control to still operate correctly.

Asp.net User Control Concept

2012-06-23T12:23:00.004-07:00

User controls are one of ASP.NET methods to increase reusability of code, implement encapsulation and reduce maintenance. User control is similar to web page. Both web pages and user controls contain HTML elements and markup for web controls. Some tags, like <html>, <head> or <form> cannot be used in web user controls.

User controls are saved with .ascx extension, instead of .aspx for web pages. User controls can use code behind feature like web pages. Code behind file of web user controls ends with .ascx.cs. Markup code of user controls starts with @Control directive. Simplest web user control could contains only static HTML, like in this example:

<%@ Control Language="VB" AutoEventWireup="false" CodeFile="WebUserControl.ascx.vb" Inherits="WebUserControl" %>

<p>Hello, I am very simple <b>web user control</b> with static HTML only.</p>
This web user control could be used when you need to repeat same code on many pages. Good examples are page footer, header or some kind of site navigation (depending of your case, it is good idea to consider using of Master Pages for this task as well). Except static HTML code, web user controls could contain web controls. You can simply drag and drop items from toolbox to user control. Like any other control, user controls can have properties, methods and events which make them very useful.
If user control solves more general problem, like progress bar or data pager control then can be useful on many different web sites. On this way, user controls can provide more stable and tested code.

How to create web user control

All user controls are derived from the System.Web.UI.UserControl class. UserControl and Page classes both inherits from TemplateControl class. You can add web user control to existing web site project, in Visual Studio menu go to WebSite -> Add New Item..., like in image bellow

New dialog will appear. To create new web user control, select web user control template, like in next image. Choose a name for your control and click Add.

How to add web user control to ASP.NET web page

To add web user control to web page, we need two lines. First, we need to register user control with Register directive on top of the page:

<%@ Page Language="C#" AutoEventWireup="true"Â CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register tagprefix="bean" Tagname="footer" src="~/footer.ascx" %>

With Register directive we define user control on page. The important parameters are:
TagPrefix: prefix for user control tag. This prefix will be used in markup code later.
TagName: tag name of user control tag.
Src: path to .ascx file.
After registration with Register directive, you can place user control inside web form with tag formatted as <tagprefix:tagname, like this:

<bean:footer runat="server" id="MyUserControl" />

Registering user controls in web.config

If you'll use user control on many pages on web site then you can register control in web.config file. On this way you can use user control in complete web site without need to register it on every page. You can do this in <controls > section with code like this:

Dynamically loading web user controls

Although web user controls looks like a parts of web page, they are still "controls". You can add them to web page at design time, and also you can add web user controls at run time by using ASP.NET server side code and by using of some container. Container is usually PlaceHolder or Panel control. We can add user control dynamically with simple code like this:
[ C# ]

protected void Page_Load(object sender, EventArgs e)
{
// Declare user control variable
Control MyUserControl;
// Load user control dynamically
MyUserControl = LoadControl("UserControl1.ascx");
// Place user control in PlaceHolder control
MyPlaceHolder.Controls.Add(MyUserControl);
}

[ VB.NET ]

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' Declare user control variable
Dim MyUserControl As Control
' Load user control dynamically
MyUserControl = LoadControl("UserControl1.ascx")
' Place user control in PlaceHolder control
myPlaceHolder.Controls.Add(MyUserControl)
End Sub

On this way, you can choose when and which control to load, based on user preferences, user or role rights etc. In detail guide how to load user controls dynamically you can read on Working with Web User Controls at Run-time tutorial.

Web user control properties and methods

We can add properties and methods to user control class like in code bellow:
[ C# ]

public void DoSomething()
{
  // Public method that do something great
}
// Public property
public string FirstName
{
   get
   {
     return lblFirstName.Text;
  }
set
   {
     lblFirstName.Text = value;
  }
}

[ VB.NET ]

Public Sub DoSomething()
  ' Public method that do something great
End Sub

' Public property
Public Property FirstName() As String
   Get
    Return lblFirstName.Text
   End Get
  Set(ByVal value As String)
     lblFirstName.Text = value
   End Set
End Property

Web user control events

User control has predefined events like web page, so you don't need to learn anything new. There are Load, Init, PreRender, Error etc. events, used on the same way like in common web page:

[ C# ]

protected void Page_Load(object sender, EventArgs e) {

   // You can add code for user control events,
   // it looks like procedure for web page load
   // so you don't need to learn anything new
}

[ VB.NET ]

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' You can add code for user control events,
' it looks like procedure for web page load
' so you don't need to learn anything new
End Sub

Custom events in user controls

Except predefined events, it is possible to declare your own events so your user control can notify the rest of application when something happen. Every event procedure use two parameters. First parameter is sender, the control that sent an event, and the second parameter is EventArgs object, or the custom class that inherits from System.EventArgs class. If we use custom class, we can add additional information that can be used in event procedure. But, in case that we have simple event, we can use generic EventArgs class.
You can create your own event in two simple steps. First, declare an event with code like this:

[ C# ]

public event EventHandler TitleChanged;

[ VB.NET ]

Public Event TitleChanged(ByVal sender As Object, ByVal e As EventArgs)

Second, inside some property or procedure, when certain circumstances occurs, you can raise an event with code like this:

[ C# ]
TitleChanged(this, EventArgs.Empty);

[ VB.NET ]

RaiseEvent TitleChanged(sender, e)

Web user control examples

Ok, enough about theory, we created two pretty useful examples of user controls. Maybe you can find them useful in some of your web projects.
First example is A simple Month Calendar Control which could be used for month selection when using of classic calendar control is inappropriate.

Second example explains How to create ProgressBar user control when visitor expects to know a progress or current state of some operation.

Conclusion

User controls could be very useful to save your time and avoid confusion. ASP.NET provides other types of controls, including custom server controls, components and web parts. Also there are a number of third party controls from independent software vendors. These controls are already well tested on many web sites and for small price can save you a lot of work. Third party controls are rarely created as user controls. Usually, they are compiled as custom server controls. Although user controls are easier to create, custom controls are easier to use. They can be placed on Visual Studio toolbox and act as standard built-in controls.

create your first mvc in php

2012-06-23T10:58:00.000-07:00

Write your own PHP MVC Framework

What is MVC?

From Wikipedia-

Model–View–Controller (MVC) is an architectural pattern used in software engineering. Successful use of the pattern isolates business logic from user interface considerations, resulting in an application where it is easier to modify either the visual appearance of the application or the underlying business rules without affecting the other. In MVC, the model represents the information (the data) of the application; the view corresponds to elements of the user interface such as text, checkbox items, and so forth; and the controller manages the communication of data and the business rules used to manipulate the data to and from the model.

In simpler words-

1. Model handles all our database logic. Using the model we connect to our database and provide an abstraction layer.
2. Controller represents all our business logic i.e. all our ifs and else.
3. View represents our presentation logic i.e our HTML/XML/JSON code.

Why should I write my own framework?

This tutorial is by no means a comprehensive/definitive solution to your framework needs. There are a lot of good php frameworks out there.

So why should you write your own framework? Firstly, it is a great learning experience. You will get to learn PHP inside-out. You will get to learn object-oriented programming, design patterns and considerations.

More importantly, you have complete control over your framework. Your ideas can be built right into your framework. Although always not beneficial, you can write coding conventions/functions/modules the way you like.

Lets dive right in

The Directory Structure

Click Read More Below To show more information about mvc in php ..

Although we will not be a couple of directories mentioned above for this tutorial, we should have them in place for future expansion. Let me explain the purpose of each directory:

application - application specific code
config - database/server configuration
db - database backups
library - framework code
public - application specific js/css/images
scripts - command-line utilities
tmp - temporary data

Once we have our directory structure ready, let us understand a few coding conventions.

Coding Conventions

1. mySQL tables will always be lowercase and plural e.g. items, cars
2. Models will always be singular and first letter capital e.g. Item, Car
3. Controllers will always have “Controller” appended to them. e.g. ItemsController, CarsController
4. Views will have plural name followed by action name as the file. e.g. items/view.php, cars/buy.php

We first add .htaccess file in the root directory which will redirect all calls to the public folder

<IfModule mod_rewrite.c>

RewriteEngine on

RewriteRule    ^$    public/    [L]

RewriteRule    (.*) public/$1    [L]

</IfModule>

We then add .htaccess file to our public folder which redirect all calls to index.php. Line 3 and 4 make sure that the path requested is not a filename or directory. Line 7 redirects all such paths to index.php?url=PATHNAME

<IfModule mod_rewrite.c>

RewriteEngine On

 

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

 

RewriteRule ^(.*)$ index.php?url=$1 [PT,L]

 

</IfModule>

This redirection has many advantages-
a) we can use it for bootstrapping i.e. all calls go via our index.php except for images/js/cs.
b) we can use pretty/seo-friendly URLS
c) we have a single entry point

Now we add index.php to our public folder

<?php    

 

define('DS', DIRECTORY_SEPARATOR);

define('ROOT', dirname(dirname(__FILE__)));

 

$url = $_GET['url'];

 

require_once (ROOT . DS . 'library' . DS . 'bootstrap.php');

Notice that I have purposely not included the closing ?>. This is to avoid injection of any extra whitespaces in our output. For more, I suggest you view Zend’s coding style.

Our index.php basically set the $url variable and calls bootstrap.php which resides in our library directory.

Now lets view our bootstrap.php

<?php

 

require_once (ROOT . DS . 'config' . DS . 'config.php');

require_once (ROOT . DS . 'library' . DS . 'shared.php');

Yes these requires could be included directly in index.php. But have not been on purpose to allow future expansion of code.

Now let us have a look at shared.php, finally something that does some real work

<?php

 

/** Check if environment is development and display errors **/

 

function setReporting() {

if (DEVELOPMENT_ENVIRONMENT == true) {

error_reporting(E_ALL);

ini_set('display_errors','On');

} else {

error_reporting(E_ALL);

ini_set('display_errors','Off');

ini_set('log_errors', 'On');

ini_set('error_log', ROOT.DS.'tmp'.DS.'logs'.DS.'error.log');

}

}

 

/** Check for Magic Quotes and remove them **/

 

function stripSlashesDeep($value) {

$value = is_array($value) ? array_map('stripSlashesDeep', $value) : stripslashes($value);

return $value;

}

 

function removeMagicQuotes() {

if ( get_magic_quotes_gpc() ) {

$_GET    = stripSlashesDeep($_GET   );

$_POST   = stripSlashesDeep($_POST  );

$_COOKIE = stripSlashesDeep($_COOKIE);

}

}

 

/** Check register globals and remove them **/

 

function unregisterGlobals() {

if (ini_get('register_globals')) {

$array = array('_SESSION', '_POST', '_GET', '_COOKIE', '_REQUEST', '_SERVER', '_ENV', '_FILES');

foreach ($array as $value) {

foreach ($GLOBALS[$value] as $key => $var) {

if ($var === $GLOBALS[$key]) {

unset($GLOBALS[$key]);

}

}

}

}

}

 

/** Main Call Function **/

 

function callHook() {

global $url;

 

$urlArray = array();

$urlArray = explode("/",$url);

 

$controller = $urlArray[0];

array_shift($urlArray);

$action = $urlArray[0];

array_shift($urlArray);

$queryString = $urlArray;

 

$controllerName = $controller;

$controller = ucwords($controller);

$model = rtrim($controller, 's');

$controller .= 'Controller';

$dispatch = new $controller($model,$controllerName,$action);

 

if ((int)method_exists($controller, $action)) {

call_user_func_array(array($dispatch,$action),$queryString);

} else {

/* Error Generation Code Here */

}

}

 

/** Autoload any classes that are required **/

 

function __autoload($className) {

if (file_exists(ROOT . DS . 'library' . DS . strtolower($className) . '.class.php')) {

require_once(ROOT . DS . 'library' . DS . strtolower($className) . '.class.php');

} else if (file_exists(ROOT . DS . 'application' . DS . 'controllers' . DS . strtolower($className) . '.php')) {

require_once(ROOT . DS . 'application' . DS . 'controllers' . DS . strtolower($className) . '.php');

} else if (file_exists(ROOT . DS . 'application' . DS . 'models' . DS . strtolower($className) . '.php')) {

require_once(ROOT . DS . 'application' . DS . 'models' . DS . strtolower($className) . '.php');

} else {

/* Error Generation Code Here */

}

}

 

setReporting();

removeMagicQuotes();

unregisterGlobals();

callHook();

Let me explain the above code briefly. The setReporting() function helps us display errors only when the DEVELOPMENT_ENVIRONMENT is true. The next move is to remove global variables and magic quotes. Another function that we make use of is __autoload which helps us load our classes automagically. Finally, we execute the callHook() function which does the main processing.

First let me explain how each of our URLs will look - yoursite.com/controllerName/actionName/queryString

So callHook() basically takes the URL which we have received from index.php and separates it out as $controller, $action and the remaining as $queryString. $model is the singular version of $controller.

e.g. if our URL is todo.com/items/view/1/first-item, then
Controller is items
Model is item (corresponding mysql table)
View is delete
Action is delete
Query String is an array (1,first-item)

After the separation is done, it creates a new object of the class $controller.”Controller” and calls the method $action of the class.

Now let us create a few classes first namely our base Controller class which will be used as the base class for all our controllers, our Model class which will be used as base class for all our models.

First the controller.class.php

<?php

class Controller {

 

protected $_model;

protected $_controller;

protected $_action;

protected $_template;

 

function __construct($model, $controller, $action) {

 

$this->_controller = $controller;

$this->_action = $action;

$this->_model = $model;

 

$this->$model =&amp; new $model;

$this->_template =&amp; new Template($controller,$action);

 

}

 

function set($name,$value) {

$this->_template->set($name,$value);

}

 

function __destruct() {

$this->_template->render();

}

 

}

The above class is used for all communication between the controller, the model and the view (template class). It creates an object for the model class and an object for template class. The object for model class has the same name as the model itself, so that we can call it something like $this->Item->selectAll(); from our controller.

While destroying the class we call the render() function which displays the view (template) file.

Now let us look at our model.class.php

<?php

class Model extends SQLQuery {

protected $_model;

 

function __construct() {

 

$this->connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);

$this->_model = get_class($this);

$this->_table = strtolower($this->_model)."s";

}

 

function __destruct() {

}

}

The Model class extends the SQLQuery class which basically is an abstraction layer for the mySQL connectivity. Depending on your requirements you can specify any other DB connection class that you may require.

Now let us have a look at the SQLQuery.class.php

<?php

 

class SQLQuery {

protected $_dbHandle;

protected $_result;

 

/** Connects to database **/

 

function connect($address, $account, $pwd, $name) {

$this->_dbHandle = @mysql_connect($address, $account, $pwd);

if ($this->_dbHandle != 0) {

if (mysql_select_db($name, $this->_dbHandle)) {

return 1;

}

else {

return 0;

}

}

else {

return 0;

}

}

 

/** Disconnects from database **/

 

function disconnect() {

if (@mysql_close($this->_dbHandle) != 0) {

return 1;

}  else {

return 0;

}

}

 

function selectAll() {

$query = 'select * from `'.$this->_table.'`';

return $this->query($query);

}

 

function select($id) {

$query = 'select * from `'.$this->_table.'` where `id` = \''.mysql_real_escape_string($id).'\'';

return $this->query($query, 1);

}

 

/** Custom SQL Query **/

 

function query($query, $singleResult = 0) {

 

$this->_result = mysql_query($query, $this->_dbHandle);

 

if (preg_match("/select/i",$query)) {

$result = array();

$table = array();

$field = array();

$tempResults = array();

$numOfFields = mysql_num_fields($this->_result);

for ($i = 0; $i < $numOfFields; ++$i) {

array_push($table,mysql_field_table($this->_result, $i));

array_push($field,mysql_field_name($this->_result, $i));

}

 

while ($row = mysql_fetch_row($this->_result)) {

for ($i = 0;$i < $numOfFields; ++$i) {

$table[$i] = trim(ucfirst($table[$i]),"s");

$tempResults[$table[$i]][$field[$i]] = $row[$i];

}

if ($singleResult == 1) {

mysql_free_result($this->_result);

return $tempResults;

}

array_push($result,$tempResults);

}

mysql_free_result($this->_result);

return($result);

}

 

}

 

/** Get number of rows **/

function getNumRows() {

return mysql_num_rows($this->_result);

}

 

/** Free resources allocated by a query **/

 

function freeResult() {

mysql_free_result($this->_result);

}

 

/** Get error string **/

 

function getError() {

return mysql_error($this->_dbHandle);

}

}

The SQLQuery.class.php is the heart of our framework. Why? Simply because it can really help us reduce our work while programming by creating an SQL abstraction layer. We will dive into an advanced version of SQLQuery.class.php in the next tutorial. For now lets just keep it simple.

The connect() and disconnect() functions are fairly standard so I will not get into too much detail. Let me specifically talk about the query class. Line 48 first executes the query. Let me consider an example. Suppose our SQL Query is something like:

SELECT table1.field1 , table1.field2, table2.field3, table2.field4 FROM table1,table2 WHERE ….

Now what our script does is first find out all the output fields and their corresponding tables and place them in arrays - $field and $table at the same index value. For our above example, $table and $field will look like

$field = array(field1,field2,field3,field4);
$table = array(table1,table1,table2,table2);

The script then fetches all the rows, and converts the table to a Model name (i.e. removes the plural and capitalizes the first letter) and places it in our multi-dimensional array and returns the result. The result is of the form $var['modelName']['fieldName']. This style of output makes it easy for us to include db elements in our views.

Now let us have a look at template.class.php

<?php

class Template {

 

protected $variables = array();

protected $_controller;

protected $_action;

 

function __construct($controller,$action) {

$this->_controller = $controller;

$this->_action = $action;

}

 

/** Set Variables **/

 

function set($name,$value) {

$this->variables[$name] = $value;

}

 

/** Display Template **/

 

function render() {

extract($this->variables);

 

if (file_exists(ROOT . DS . 'application' . DS . 'views' . DS . $this->_controller . DS . 'header.php')) {

include (ROOT . DS . 'application' . DS . 'views' . DS . $this->_controller . DS . 'header.php');

} else {

include (ROOT . DS . 'application' . DS . 'views' . DS . 'header.php');

}

 

include (ROOT . DS . 'application' . DS . 'views' . DS . $this->_controller . DS . $this->_action . '.php');       

 

if (file_exists(ROOT . DS . 'application' . DS . 'views' . DS . $this->_controller . DS . 'footer.php')) {

include (ROOT . DS . 'application' . DS . 'views' . DS . $this->_controller . DS . 'footer.php');

} else {

include (ROOT . DS . 'application' . DS . 'views' . DS . 'footer.php');

}

}

 

}

The above code is pretty straight forward. Just one point- if it does not find header and footer in the view/controllerName folder then it goes for the global header and footer in the view folder.

Now all we have to add is a config.php in the config folder and we can begin creating our first model, view and controller!

<?php

 

/** Configuration Variables **/

 

define ('DEVELOPMENT_ENVIRONMENT',true);

 

define('DB_NAME', 'yourdatabasename');

define('DB_USER', 'yourusername');

define('DB_PASSWORD', 'yourpassword');

define('DB_HOST', 'localhost');

Phew! Now let us create our first mini-todo application. We first create a database “todo” and execute the following SQL queries

CREATE TABLE `items` (

`id` int(11) NOT NULL auto_increment,

`item_name` varchar(255) NOT NULL,

PRIMARY KEY  (`id`)

);

 

INSERT INTO `items` VALUES(1, 'Get Milk');

INSERT INTO `items` VALUES(2, 'Buy Application');

Once that is done, we add item.php to our model folder with the following contents

<?php

 

class Item extends Model {

 

}

Write it is empty, but will have more information when we expand our framework in Part 2.

Now create a file called itemscontroller.php in the controller folder

<?php

 

class ItemsController extends Controller {

 

function view($id = null,$name = null) {

 

$this->set('title',$name.' - My Todo List App');

$this->set('todo',$this->Item->select($id));

 

}

 

function viewall() {

 

$this->set('title','All Items - My Todo List App');

$this->set('todo',$this->Item->selectAll());

}

 

function add() {

$todo = $_POST['todo'];

$this->set('title','Success - My Todo List App');

$this->set('todo',$this->Item->query('insert into items (item_name) values (\''.mysql_real_escape_string($todo).'\')'));

}

 

function delete($id = null) {

$this->set('title','Success - My Todo List App');

$this->set('todo',$this->Item->query('delete from items where id = \''.mysql_real_escape_string($id).'\''));

}

 

}

Finally create a folder called items in the views folder and create the following files in it-

view.php

<h2><?php echo $todo['Item']['item_name']?></h2>

 

<a class="big" href="../../../items/delete/<?php echo $todo['Item']['id']?>">

<span class="item">

Delete this item

</span>

</a>

viewall.php

<form action="../items/add" method="post">

<input type="text" value="I have to..." onclick="this.value=''" name="todo"> <input type="submit" value="add">

</form>

<br/><br/>

<?php $number = 0?>

 

<?php foreach ($todo as $todoitem):?>

<a class="big" href="../items/view/<?php echo $todoitem['Item']['id']?>/<?php echo strtolower(str_replace(" ","-",$todoitem['Item']['item_name']))?>">

<span class="item">

<?php echo ++$number?>

<?php echo $todoitem['Item']['item_name']?>

</span>

</a><br/>

<?php endforeach?>

delete.php

1.<a class="big" href="../../items/viewall">Todo successfully deleted. Click here to go back.</a>

add.php

1.<a class="big" href="../items/viewall">Todo successfully added. Click here to go back.</a>

header.php

<html>

<head>

<title><?php echo $title?></title>

<style>

.item {

width:400px;

 

}

 

input {

color:#222222;

font-family:georgia,times;

font-size:24px;

font-weight:normal;

line-height:1.2em;

color:black;

}

 

a {

color:#222222;

font-family:georgia,times;

font-size:24px;

font-weight:normal;

line-height:1.2em;

color:black;

text-decoration:none;

 

}

 

a:hover {

background-color:#BCFC3D;

}

h1 {

color:#000000;

font-size:41px;

letter-spacing:-2px;

line-height:1em;

font-family:helvetica,arial,sans-serif;

border-bottom:1px dotted #cccccc;

}

 

h2 {

color:#000000;

font-size:34px;

letter-spacing:-2px;

line-height:1em;

font-family:helvetica,arial,sans-serif;

 

}

</style>

</head>

<body>

<h1>My Todo-List App</h1>

footer.php

</body>

</html>

Now assuming you have uploaded the directory structure to the todo folder, point your browser to:
http://localhost/todo/items/viewall

create your own config file in php

2012-06-23T10:39:00.000-07:00

create a new MySQL database using phpMyAdmin and a config.php file in the site root with connection's parameters for the database (database name, database host, username, password).

Open config.php and copy and paste the code replacing the value of variables $db_host, $db_name, $username, $password, with correct parameters.

<?php
// Connection's Parameters
$db_host="localhost";
$db_name="database_name";
$username="database_username";
$password="database_password";
$db_con=mysql_connect($db_host,$username,$password);
$connection_string=mysql_select_db($db_name);
// Connection
mysql_connect($db_host,$username,$password);
mysql_select_db($db_name);
?>

Now, in the site root, create index.php file and use PHP include() function to include config.php into the page.

<?php include ('config.php') ?>

This is a simple way to enstablish a connection with your database MySQL to be used when you need to execute a SQL query.

Create View in Oracle

2012-06-23T10:33:00.000-07:00

set pagesize 500
alter session set nls_date_format = 'DD.MM.YYYY';

create table prices_ (
  sku        varchar2(38),
  price      number,
  valid_from date
);

insert into prices_ values ('4711', 18, '08.01.2003');
insert into prices_ values ('4711', 19, '01.05.2000');
insert into prices_ values ('4711', 20, '18.01.2001');
insert into prices_ values ('4711', 21, '09.01.2000');

insert into prices_ values ('beer', 14, '07.03.2000');
insert into prices_ values ('beer', 15, '10.01.2003');
insert into prices_ values ('beer', 16, '18.01.2001');
insert into prices_ values ('beer', 19, '16.11.2001');
insert into prices_ values ('beer', 17, '19.02.2002');


create view prices_today_ as 
  select 
    sku,
    price,
    valid_from
  from
    (select
       sku,
       price,
       valid_from,
       rank() over (partition by sku order by valid_from desc) r
     from
       prices_
    )
  where r=1;


select * from prices_today_;

drop table prices_;
drop view prices_today_;

Fast Technology

Make money fast with sharecash

How You Made $500,000+ In One Year (+playlist)

how to blog and make money online

Different ways to refresh or reload page using jQuery

JQuery Mouse Events

JQuery Basics Events

Cloud computing

Characteristics

Service Models

Infrastructure as a service (IaaS)

Platform as a service (PaaS)

Software as a service (SaaS)

Cloud clients

Create MVC Website

Step 1: Find the Project Type in Visual Studio

Step 2: Create a Test Project

Take a Look at What You Get

Consumerism and its antisocial effects can be turned on—or off

Creative Activism

View In Sql Server 2005 & 2008

C++ Get CPU and Memory Utilisation

WPF Controls Progrrammatically

Full Text Search In Sql Server 2008

Upload File Form in php

This below code allow user to upload image in web page that made in php program language ..

Create The Upload Script

Restrictions on Upload

Saving the Uploaded File

make rss feed in asp.net

Rss File Code Project

What is RSS?

Writing a Text File

How to Create a JavaScript Animation

A Matter of Timing

Examples:

Timeout Example:

Interval Example:

Fast Technology: Application, Session, HttpContext, and ViewState

Application, Session, HttpContext, and ViewState

Application, Session, HttpContext, and ViewState Caching

Application, Session, HttpContext, and ViewState Caching

Using the Application State

Storing Data in the Application

Using the Session State

Storing Data in the Session

Disabling Session State

Configuring Session State

Attributes of SessionState Configuration

Session State Configuration

Using HttpContext

Simple Binding to a Business Layer

A Caching Class Using the HttpContext

Using ViewState

Asp.net User Control Concept

How to create web user control

How to add web user control to ASP.NET web page

Registering user controls in web.config

Dynamically loading web user controls

Web user control properties and methods

Web user control events

Custom events in user controls

Web user control examples

Conclusion

create your first mvc in php

Write your own PHP MVC Framework

create your own config file in php

Create View in Oracle