Tuesday, July 16

Basic functionality of Preg_match in PHP with various scenarios and its example

Hi All,

Basic regexps with preg_match()

syntax:


int preg_match ( string pattern, string subject [, array matches [, int flags [, int offset]]])


preg_match() and takes two parameters: the pattern to match, and the string to match it against.

Preg_match() will apply the regular expression in parameter one to the string in parameter two and see whether it finds a match - if it does, it will return 1, otherwise 0. 

 Regular expressions are formed by starting with a forward slash /, followed by a sequence of special symbols and words to match, then another slash and, optionally, a string of letters that affect the expression.  

Note:

  •   The “i” used to find  pattern delimiter indicates a case-insensitive search.

  •  The “\b”used to find pattern indicates a word boundary, so only the distinct.

 

<?php
echo "<br>Basic preg_match Functionality <br><br> ";
echo "example 1 for Case Sensitive Search <br>";
if(preg_match("/cool/", "I love to share Cool things that help others.")){
        echo "matched text<br>";
} else {
        echo "Not Matched text<br>";
}

echo "<br> example 2 for Case Insensitive  Search<br>";
if(preg_match("/bala/i", "my name is Balamurugan shortly call has a Bala")){
        echo "name found in text<br>";
}else{
        echo "name is not found in text<br>";
}


echo "<br> example 3 for Word boundary <br>";
if(preg_match("/\bkrishna\b/i",  "Krishna is a god. he kills kamsan in long long ago. and Krishna became king" )){
    echo " krishna name <br>";
}else{
    echo " krishna name not found<br>";
}

echo "<br> example 4 for Found string matched <br>";
if(preg_match("/[Ff]oo/","foo")){
    echo 'string matched<br>';
}  else {
    echo 'String not matched<br>';
}

echo "<br> example 5 for Found string unmatched <br>";
if(preg_match("/[^Ff]oo/","foo")){
    echo 'string matched<br>';
}  else {
    echo 'String not matched<br>';
}

echo "<br> example 6 for Alpha Numeric <br>";
if(preg_match("/[0-9,A-Z,a-z]/","foo")){
    echo 'It is Alphanumeric<br>';
}  else {
    echo 'It is not Alphanumeric<br>';
}

echo "<br> example 7 for Numeric <br>";
if(preg_match("/[0-9]/","foo")){
    echo 'It is Numeric<br>';
}  else {
    echo 'It is not Numeric<br>';
}

echo "<br> example 8 for Lowercase of string <br>";
if(preg_match("/[a-z]/","fo0")){
    echo 'It is Lowercase<br>';
}  else {
    echo 'It is not Lowercase<br>';
}

echo "<br> example 9 for Uppercase of string <br>";
if(preg_match("/[A-Z]/","foo")){
    echo 'It is uppercase<br>';
}  else {
    echo 'It is not Uppercase<br>';
}

echo "<br> example 10 for matched of character in string <br>";
if(preg_match("/[a-w]orld/","aorld")){
    echo 'It is matched<br>';
}  else {
    echo 'It is not matched<br>';
}

echo "<br> example 11 for matched of character & number in string <br>";
if(preg_match("/[a-t]est[0-9][0-9]/","west33")){
    echo 'It is matched<br>';
}  else {
    echo 'It is not matched<br>';
}

echo "<br> example 12 for matched of character & number in string in_casesensitive <br>";
if(preg_match("/[a-t]est[0-9][0-9]/i","West33")){
    echo 'It is matched<br>';
}  else {
    echo 'It is not matched<br>';
}

echo "<br> example 13 for not matched of character & number in string <br>";
if(preg_match("/[^a-t]est[0-9][0-9]/","Best33")){
    echo 'It is matched<br>';
}  else {
    echo 'It is not matched<br>';
}

echo "<br> example 14 for not matched of character & number in string in_casesensitive <br>";
if(preg_match("/[^a-t]est[0-9][0-9]/i","Best33")){
    echo 'It is matched<br>';
}  else {
    echo 'It is not matched<br>';
}

?>

OUTPUT

~~~~~~~~



Basic Preg_Match Functionality

example 1 for Case Sensitive Search
Not Matched text

example 2 for Case Insensitive Search
name found in text

example 3 for Word boundary
krishna name

example 4 for Found string matched
string matched

example 5 for Found string unmatched
String not matched

example 6 for Alpha Numeric
It is Alphanumeric

example 7 for Numeric
It is not Numeric

example 8 for Lowercase of string
It is Lowercase

example 9 for Uppercase of string
It is not Uppercase

example 10 for matched of character in string
It is matched

example 11 for matched of character & number in string
It is not matched

example 12 for matched of character & number in string in_casesensitive
It is not matched

example 13 for not matched of character & number in string
It is matched

example 14 for not matched of character & number in string in_casesensitive
It is not matched
 

Tuesday, July 2

What really happens when you navigate to a URL

Hi All,

I  learn the "What really happens when you navigate to a URL" in net. I really like to share this every one. it is simply and very good process going behind in each request. 


As a software developer, you certainly have a high-level picture of how web apps work and what kinds of technologies are involved: the browser, HTTP, HTML, web server, request handlers, and so on.
In this article, we will take a deeper look at the sequence of events that take place when you visit a URL.

1. You enter a URL into the browser

It all starts here:
image

2. The browser looks up the IP address for the domain name

 image
The first step in the navigation is to figure out the IP address for the visited domain. The DNS lookup proceeds as follows:

  • Browser cache – The browser caches DNS records for some time. Interestingly, the OS does not tell the browser the time-to-live for each DNS record, and so the browser caches them for a fixed duration (varies between browsers, 2 – 30 minutes).
  • OS cache – If the browser cache does not contain the desired record, the browser makes a system call (gethostbyname in Windows). The OS has its own cache.
  • Router cache – The request continues on to your router, which typically has its own DNS cache.
  • ISP DNS cache – The next place checked is the cache ISP’s DNS server. With a cache, naturally.
  • Recursive search – Your ISP’s DNS server begins a recursive search, from the root nameserver, through the .com top-level nameserver, to Facebook’s nameserver. Normally, the DNS server will have names of the .com nameservers in cache, and so a hit to the root nameserver will not be necessary.
Here is a diagram of what a recursive DNS search looks like:
500px-An_example_of_theoretical_DNS_recursion_svg
One worrying thing about DNS is that the entire domain like wikipedia.org or facebook.com seems to map to a single IP address. Fortunately, there are ways of mitigating the bottleneck:
  • Round-robin DNS is a solution where the DNS lookup returns multiple IP addresses, rather than just one. For example, facebook.com actually maps to four IP addresses.
  • Load-balancer is the piece of hardware that listens on a particular IP address and forwards the requests to other servers. Major sites will typically use expensive high-performance load balancers.
  • Geographic DNS improves scalability by mapping a domain name to different IP addresses, depending on the client’s geographic location. This is great for hosting static content so that different servers don’t have to update shared state.
  • Anycast is a routing technique where a single IP address maps to multiple physical servers. Unfortunately, anycast does not fit well with TCP and is rarely used in that scenario.
Most of the DNS servers themselves use anycast to achieve high availability and low latency of the DNS lookups.

3. The browser sends a HTTP request to the web server

image
You can be pretty sure that Facebook’s homepage will not be served from the browser cache because dynamic pages expire either very quickly or immediately (expiry date set to past).
So, the browser will send this request to the Facebook server:
GET http://facebook.com/ HTTP/1.1
Accept: application/x-ms-application, image/jpeg, application/xaml+xml, [...]
User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; [...]
Accept-Encoding: gzip, deflate
Connection: Keep-Alive
Host: facebook.com
Cookie: datr=1265876274-[...]; locale=en_US; lsd=WW[...]; c_user=2101[...]
The GET request names the URL to fetch: “http://facebook.com/”. The browser identifies itself (User-Agent header), and states what types of responses it will accept (Accept and Accept-Encoding headers). The Connection header asks the server to keep the TCP connection open for further requests.
The request also contains the cookies that the browser has for this domain. As you probably already know, cookies are key-value pairs that track the state of a web site in between different page requests. And so the cookies store the name of the logged-in user, a secret number that was assigned to the user by the server, some of user’s settings, etc. The cookies will be stored in a text file on the client, and sent to the server with every request.
There is a variety of tools that let you view the raw HTTP requests and corresponding responses. My favorite tool for viewing the raw HTTP traffic is fiddler, but there are many other tools (e.g., FireBug) These tools are a great help when optimizing a site.
In addition to GET requests, another type of requests that you may be familiar with is a POST request, typically used to submit forms. A GET request sends its parameters via the URL (e.g.: http://robozzle.com/puzzle.aspx?id=85). A POST request sends its parameters in the request body, just under the headers.
The trailing slash in the URL “http://facebook.com/” is important. In this case, the browser can safely add the slash. For URLs of the form http://example.com/folderOrFile, the browser cannot automatically add a slash, because it is not clear whether folderOrFile is a folder or a file. In such cases, the browser will visit the URL without the slash, and the server will respond with a redirect, resulting in an unnecessary roundtrip.

4. The facebook server responds with a permanent redirect

image
This is the response that the Facebook server sent back to the browser request:
HTTP/1.1 301 Moved Permanently
Cache-Control: private, no-store, no-cache, must-revalidate, post-check=0,
      pre-check=0
Expires: Sat, 01 Jan 2000 00:00:00 GMT
Location: http://www.facebook.com/
P3P: CP="DSP LAW"
Pragma: no-cache
Set-Cookie: made_write_conn=deleted; expires=Thu, 12-Feb-2009 05:09:50 GMT;
      path=/; domain=.facebook.com; httponly
Content-Type: text/html; charset=utf-8
X-Cnection: close
Date: Fri, 12 Feb 2010 05:09:51 GMT
Content-Length: 0
The server responded with a 301 Moved Permanently response to tell the browser to go to “http://www.facebook.com/” instead of “http://facebook.com/”.
There are interesting reasons why the server insists on the redirect instead of immediately responding with the web page that the user wants to see.
One reason has to do with search engine rankings. See, if there are two URLs for the same page, say http://www.igoro.com/ and http://igoro.com/, search engine may consider them to be two different sites, each with fewer incoming links and thus a lower ranking. Search engines understand permanent redirects (301), and will combine the incoming links from both sources into a single ranking.
Also, multiple URLs for the same content are not cache-friendly. When a piece of content has multiple names, it will potentially appear multiple times in caches.

5. The browser follows the redirect

image
The browser now knows that “http://www.facebook.com/” is the correct URL to go to, and so it sends out another GET request:
GET http://www.facebook.com/ HTTP/1.1
Accept: application/x-ms-application, image/jpeg, application/xaml+xml, [...]
Accept-Language: en-US
User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; [...]
Accept-Encoding: gzip, deflate
Connection: Keep-Alive
Cookie: lsd=XW[...]; c_user=21[...]; x-referer=[...]
Host: www.facebook.com
The meaning of the headers is the same as for the first request.

6. The server ‘handles’ the request

image
The server will receive the GET request, process it, and send back a response.
This may seem like a straightforward task, but in fact there is a lot of interesting stuff that happens here – even on a simple site like my blog, let alone on a massively scalable site like facebook.
  • Web server softwareThe web server software (e.g., IIS or Apache) receives the HTTP request and decides which request handler should be executed to handle this request. A request handler is a program (in ASP.NET, PHP, Ruby, …) that reads the request and generates the HTML for the response. In the simplest case, the request handlers can be stored in a file hierarchy whose structure mirrors the URL structure, and so for example http://example.com/folder1/page1.aspx URL will map to file /httpdocs/folder1/page1.aspx. The web server software can also be configured so that URLs are manually mapped to request handlers, and so the public URL of page1.aspx could be http://example.com/folder1/page1.
  • Request handlerThe request handler reads the request, its parameters, and cookies. It will read and possibly update some data stored on the server. Then, the request handler will generate a HTML response.
One interesting difficulty that every dynamic website faces is how to store data. Smaller sites will often have a single SQL database to store their data, but sites that store a large amount of data and/or have many visitors have to find a way to split the database across multiple machines. Solutions include sharding (splitting up a table across multiple databases based on the primary key), replication, and usage of simplified databases with weakened consistency semantics.
One technique to keep data updates cheap is to defer some of the work to a batch job. For example, Facebook has to update the newsfeed in a timely fashion, but the data backing the “People you may know” feature may only need to be updated nightly (my guess, I don’t actually know how they implement this feature). Batch job updates result in staleness of some less important data, but can make data updates much faster and simpler.

7. The server sends back a HTML response

image
Here is the response that the server generated and sent back:
HTTP/1.1 200 OK
Cache-Control: private, no-store, no-cache, must-revalidate, post-check=0,
    pre-check=0
Expires: Sat, 01 Jan 2000 00:00:00 GMT
P3P: CP="DSP LAW"
Pragma: no-cache
Content-Encoding: gzip
Content-Type: text/html; charset=utf-8
X-Cnection: close
Transfer-Encoding: chunked
Date: Fri, 12 Feb 2010 09:05:55 GMT

2b3
��������T�n�@����[...]
The entire response is 36 kB, the bulk of them in the byte blob at the end that I trimmed.
The Content-Encoding header tells the browser that the response body is compressed using the gzip algorithm. After decompressing the blob, you’ll see the HTML you’d expect:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"   
      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" 
      lang="en" id="facebook" class=" no_js">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-language" content="en" />
...
In addition to compression, headers specify whether and how to cache the page, any cookies to set (none in this response), privacy information, etc.
Notice the header that sets Content-Type to text/html. The header instructs the browser to render the response content as HTML, instead of say downloading it as a file. The browser will use the header to decide how to interpret the response, but will consider other factors as well, such as the extension of the URL.

8. The browser begins rendering the HTML

Even before the browser has received the entire HTML document, it begins rendering the website:
 image

9. The browser sends requests for objects embedded in HTML

image
As the browser renders the HTML, it will notice tags that require fetching of other URLs. The browser will send a GET request to retrieve each of these files.
Here are a few URLs that my visit to facebook.com retrieved:
  • Imageshttp://static.ak.fbcdn.net/rsrc.php/z12E0/hash/8q2anwu7.gif
    http://static.ak.fbcdn.net/rsrc.php/zBS5C/hash/7hwy7at6.gif
  • CSS style sheetshttp://static.ak.fbcdn.net/rsrc.php/z448Z/hash/2plh8s4n.css
    http://static.ak.fbcdn.net/rsrc.php/zANE1/hash/cvtutcee.css
  • JavaScript files
    http://static.ak.fbcdn.net/rsrc.php/zEMOA/hash/c8yzb6ub.js
    http://static.ak.fbcdn.net/rsrc.php/z6R9L/hash/cq2lgbs8.js
Each of these URLs will go through process a similar to what the HTML page went through. So, the browser will look up the domain name in DNS, send a request to the URL, follow redirects, etc.
However, static files – unlike dynamic pages – allow the browser to cache them. Some of the files may be served up from cache, without contacting the server at all. The browser knows how long to cache a particular file because the response that returned the file contained an Expires header. Additionally, each response may also contain an ETag header that works like a version number – if the browser sees an ETag for a version of the file it already has, it can stop the transfer immediately.
Can you guess what “fbcdn.net” in the URLs stands for? A safe bet is that it means “Facebook content delivery network”. Facebook uses a content delivery network (CDN) to distribute static content – images, style sheets, and JavaScript files. So, the files will be copied to many machines across the globe.
Static content often represents the bulk of the bandwidth of a site, and can be easily replicated across a CDN. Often, sites will use a third-party CDN provider, instead of operating a CND themselves. For example, Facebook’s static files are hosted by Akamai, the largest CDN provider.
As a demonstration, when you try to ping static.ak.fbcdn.net, you will get a response from an akamai.net server. Also, interestingly, if you ping the URL a couple of times, may get responses from different servers, which demonstrates the load-balancing that happens behind the scenes.

10. The browser sends further asynchronous (AJAX) requests

image

In the spirit of Web 2.0, the client continues to communicate with the server even after the page is rendered.

For example, Facebook chat will continue to update the list of your logged in friends as they come and go. To update the list of your logged-in friends, the JavaScript executing in your browser has to send an asynchronous request to the server. The asynchronous request is a programmatically constructed GET or POST request that goes to a special URL. In the Facebook example, the client sends a POST request to http://www.facebook.com/ajax/chat/buddy_list.php to fetch the list of your friends who are online.

This pattern is sometimes referred to as “AJAX”, which stands for “Asynchronous JavaScript And XML”, even though there is no particular reason why the server has to format the response as XML. For example, Facebook returns snippets of JavaScript code in response to asynchronous requests..

Conclusion

Hopefully this gives you a better idea of how the different web pieces work together.

Converting CSV File in to Excel File Using JAVA

Hi ALL,

Here I write a program for Convert the CSV file to MS Excel file using JAVA.


/*Import  file declaration*/

import java.io.DataInputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.StringTokenizer;
import java.util.*;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import java.io.*;

public class csvTOexcel {

    public static void main(String args[]) throws IOException {
        ArrayList arrayList = null;
        ArrayList al = null;

        String FileName = "C:\\Documents and Settings\\SKitech\\Desktop\\bala\\auto_reg.csv"; //Source file name & path
        String CLine;
        int count = 0;

        FileInputStream fis = new FileInputStream(FileName);
        DataInputStream dis = new DataInputStream(fis);
        int i = 0;
        arrayList = new ArrayList();
        while ((CLine = dis.readLine()) != null) {
            al = new ArrayList();
            String strar[] = CLine.split(",");
            for (int j = 0; j < strar.length; j++) {
                al.add(strar[j]);
            }
            arrayList.add(al);
            System.out.println(al); // Write a values in console
            i++;
        }

        try {
            HSSFWorkbook hwb = new HSSFWorkbook();
            HSSFSheet sheet = hwb.createSheet("My Sheet");
            for (int k = 0; k < arrayList.size(); k++) {
                ArrayList ardata = (ArrayList) arrayList.get(k);
//System.out.println("ardata " + ardata.size());
                HSSFRow row = sheet.createRow((short) 0 + k);
                for (int p = 0; p < ardata.size(); p++) {
//System.out.print(ardata.get(p));
                    HSSFCell cell = row.createCell((short) p);
                    cell.setCellValue(ardata.get(p).toString());
                }
                System.out.println();
            }
            FileOutputStream fileOut = new FileOutputStream("C:\\xls\\auto_reg1.xls");
            hwb.write(fileOut);
            fileOut.close();
            System.out.println("Your excel file has been generated");
        } catch (Exception ex) {
        } //main method ends
    }
}

OUTPUT:

~~~~~~~~~


[00079584, 00052705, The Five C's of Writing in Today's Business Environment, AYDINBE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BASAREV1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BEEREBA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BEIJEED1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BENTRO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BEZEMRI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BLOKHAR1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BOESSNA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BOLRO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BOMHOVA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BONNIPA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BOSCHPE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BOUKHSA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BRANDKA4]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BRESHA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BRUENFR1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BRUGTHI2]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, BUITEAP1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, CLAASRE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DAALMDA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DAAMEIN1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DACHAHE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DEBETPE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DEKKECA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DIJKHHA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, DUNNIFL1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, EDELSEL1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, EIMERFR1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, ENGERSA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, ENTINHA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, ERMERAN1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, FAOUZJA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, FRANKST5]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, FREEHA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, GILSAD1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, GRAAFHA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, GRAAFMA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, GRAAFSI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, GRAATKA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, GREFTWI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HAANDA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HALIESA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HARTOBR1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HAVELWE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HEERDLI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HILTECA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HOGARAL1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HORDIAA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, HULTEDE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, IJZERCA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, IMHOFLI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, JANSSRO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, JURAWRA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, KEMPEAN3]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, KETELMA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, KLAWEIN1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, KLEINAN4]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, KUENEEL1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, KUNSTVI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, LATERSU1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, LEMOUMO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, LIEASMO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, LIERELO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, LOHBEMI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, LOOHUEL1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, MARIVI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, MOKHTAH1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, NEUMAPA2]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, NIEUWKA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, NOBELSU2]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, PENNIHA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, PERUMDE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, PLUIMWI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, RAADDE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, RAADPI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, RAVELLE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, RENETNA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, RIETVJO1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, ROOYLI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, ROSBE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, RUISBNI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, SCHONJA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, SCHRADA3]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, SILVEJU1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, STOLTLE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, SWINKRA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, TAHAPSU2]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, THOBEED1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, VALKCH1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, VANDEEV3]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, VERHORE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, VERKOCA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, VRIESGI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, VRIESMA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, WESTEPI1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, WILKSA1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, WILTEFE1]
[00079584, 00052705, The Five C's of Writing in Today's Business Environment, WITLOME1]



this Data write in Excel File.


Your excel file has been generated

PHP Search Engine using Ajax,Jquery Technologies


Hi All,

Here I write a simple project for Search Engine using PHP, Ajax, Jquery and MySql.


1. This is a very simple search engine to search the records in single tables within the database. If you want you can add more tables according to your request.


2. The Search Engine shows tables values in the table format by clicking the Search button.


 Requirements details:


    Go to Site: http://jquery.com/download/

    And select then download the "Download the uncompressed, development jQuery 1.10.1" .

    Place it inside in your project JS folder. 


 Steps details:


Database details:


 1. create new database in MySQL.


2. in side the database create new table.


Example Db Structure:

/* Create DB Code*/

DROP DATABASE IF EXISTS `balabms`;

CREATE DATABASE IF NOT EXISTS `balabms` ;

USE `balabms`;

/*Create Table Code*/

DROP TABLE IF EXISTS `bmsbook`;

CREATE TABLE IF NOT EXISTS `bmsbook` (

  `bid` int(11) NOT NULL,

  `bname` varchar(32) NOT NULL,

  `auth` varchar(32) NOT NULL,

  `pub` varchar(32) NOT NULL,

  `cat` varchar(32) NOT NULL,

  `qty` int(11) NOT NULL,

  `price` double NOT NULL,

  KEY `bid` (`bid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/* Insert value to the Table*/

INSERT INTO `bmsbook` (`bid`, `bname`, `auth`, `pub`, `cat`, `qty`, `price`) VALUES

    (0, 'Programming in c', 'Dennis Rechie', 'At&t', 'Computers', 60, 499),

   (1, 'java', 'bala', 'Skitech', '3', 50, 150),

   (2, 'C++', 'SRI', 'Skitech', '26', 15, 120),

   (3, 'PHP', 'RAJA', 'Skitech', '30', 20, 220),

   (4, 'AJAX', 'KRISH', 'Skitech', '11', 30, 450),

   (5, 'JQUERY', 'ROCK', 'Skitech', '15', 45, 650);

Index.PHP
~~~~~~~~~~


<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>
        <script src="js/jquery-1.10.1.js"></script>
       
        <!-- Ajax and Jquery Call for Search -->
       
        <script type="text/javascript">
            $(document).ready(function() {

                function search() {

                    var title = $("#search").val();

                    if (title != "") {

                        $.ajax({
                            type: "get",
                            url: "search.php",   <!-- Redirect Function  -->
                            data: "title=" + title,
                            success: function(data) {
                                $("#result").html(data);
                                $("#search").val("");
                            }
                        });
                    }
                }

                $("#button").click(function() {
                    search();
                });

                $('#search').keyup(function(e) {
                    if (e.keyCode == 13) {
                        search();
                    }
                });
            });
        </script> 
       
<!-- Internal style sheet for Search textbox and button -->

        <style type="text/css">
            #container{
                width:800px;
                margin:0 auto;
            }

            #search{
                width:350px;
                padding:10px;
            }

            #button{
                display: block;
                width: 100px;
                height:30px;
                border:solid #366FEB 1px;
                background: #d4e3e5;
            }

            ul{
                margin-left:-40px;
            }

            ul li{
                list-style-type: none;
                border-bottom: dotted 1px black;
                height: 50px;
            }

            li:hover{
                background: #A592E8;
            }

            a{
                text-decoration: none;
                font-size: 18px;
            }
        </style>
    </head>

    <!-- Define Search textbox and button -->


    <body>
        <div id="container">
            <input type="text" id="search" placeholder="Search Books name Here..."/>
            <input type="button" id="button" value="Search" />
           
        <!-- Result place -->   
       
            <ul id="result"></ul>
        </div>
    </body>
</html>

Search.php

~~~~~~~~~~~


<!-- Style sheet for fancy Table Format -->

 <style type="text/css">
table.hovertable {
    font-family: verdana,arial,sans-serif;
    font-size:11px;
    color:#333333;
    border-width: 1px;
    border-color: #999999;
    border-collapse: collapse;
}
table.hovertable th {
    background-color:#c3dde0;
    border-width: 1px;
    padding: 8px;
    border-style: solid;
    border-color: #a9c6c9;
}
table.hovertable tr {
    background-color:#d4e3e5;
}
table.hovertable td {
    border-width: 1px;
    padding: 8px;
    border-style: solid;
    border-color: #a9c6c9;
}
</style>

<?php

/* Database Connection Method*/

  mysql_connect("localhost","root","") or die("Unable to connect Database");
  mysql_select_db("balabms") or die("error in Database name");

/*Fetching Search result Query*/

$result = "select * from bmsbook where bname like '%".$_GET['title']."%' or auth like '%".$_GET['title']."%' or
                bid like '%".$_GET['title']."%' or pub like '%".$_GET['title']."%' or cat like '%".$_GET['title']."%'";
    $res = mysql_query($result);
    $rec_count = mysql_num_rows($res);      

/*Checking the query contains value or Not */
    
if($rec_count>0){
    ?>
<table class="hovertable">
<tr>
    <th>Book ID</th>
    <th>Book Name</th>
    <th>Author</th>
    <th>Publisher</th>
    <th>Catagory</th>  
</tr>

<!-- IF contanis  records (Result) It will Display in fancy Table Format -->

<?php while ($row =mysql_fetch_row($res)){ ?>
<tr onmouseover="this.style.backgroundColor='#ffff66';" onmouseout="this.style.backgroundColor='#d4e3e5';">
    <td><?php echo $row[0]; ?></td>
        <td><?php echo $row[1]; ?></td>
        <td><?php echo $row[2]; ?></td>
        <td><?php echo $row[3]; ?></td>
        <td><?php echo $row[4]; ?></td>
</tr>
        <?php } } else{ ?>

<!-- IF contanis not records (No Result) It will Display in fancy Table Format -->

       
</table>
        <table class="hovertable">
  <tr onmouseover="this.style.backgroundColor='#ffff66';" onmouseout="this.style.backgroundColor='#d4e3e5';">
    <td style="padding: 8px 140px;"><?php echo "No Records Found"; ?></td>
    
</tr>
        <?php }?>
</table>

 

OUTPUT

~~~~~~~~~


Result found:
 


Result not found:




  

Backup files to google drive using PHP coding

 Dear All, To backup files to Google Drive using PHP coding, you can use the Google Drive API and the Google Client Library for PHP. Here...