Advanced Database Techniques

PEAR DB is the database primitives shown earlier; it provides several shortcut functions for fetching result rows, as well as a unique row ID system and separate prepare/execute steps that can improve the performance of repeated queries.

$result_set = $db->query(SQL, values);

 Pass the query( ) function SQL with 
 in place of specific values, and add a second parameter consisting of 
the array of values to insert into the SQL 

When issuing the same query repeatedly, it can be more efficient to compile the query once and then execute it multiple times, using the prepare( ) , execute( ), and executeMultiple( ) methods.

$com = $db->prepare(SQL);

This returns a com query object. The execute( ) method fills in any placeholders in the query.

PEAR DB gives a lot of methods that perform a query and fetch the results in one step:  

getOne( ) , getRow( ), getCol( ), getAssoc( ), and getAll( ). 

$value-set = $db->getOne(SQL [, values ]);

Read More

php-static variables

A static variable retains its value between calls to a function but is visible only within that function.
IT declare a variable static with the static keyword.

function test_counter (  ) {
  static $counter = 0;
  $counter++;
  echo "Static counter is now $counter\n";
}
$counter = 5;
test_counter(  );
test_counter(  );
echo "Global counter is $counter\n";
Static counter is now 1
Static counter is now 2
Global counter is 5

Variables declared outside a function are global.

 That is, they can be accessed from any part of the script. By default, 

they are not available inside functions.

Read More

trade people use Google

Google is popular anywhere
Google's free online language translation service provides a knowledgeable support staff.
you can share a lot of  things With Google+ like  events,games, photos.
ITs  Find all businesses,online classifieds,advertising classifieds.Google takes a 67%
share of the U.S. search market.

Job growth is increased by this google even search job,employment,business grows with the
help of google.

Google’s Picasa Web Albums to store photos,and manage the photos very nice.
With these tools, you can create different versions of your profile .

Google Docs  store many things like  the latest doc,text files, more updates new files.

Gmail: Email from Google

Google Groups

 Google+

Google Translate

 Google News

Google Toolbar

 Google Docs

Google Finance

Picasa

Google - YouTube

 Google Checkout

Google Sites

Android Apps on Google

 

• Google Documents:- Share and add,edit documents , see them on the run with Google Docs mobile service, and take Google Notebook for web research.
• Google Spreadsheets:- Add live data to spreadsheets, and  charts and tables you can embed in web pages.
• Google Presentations:- See them on a mobile phone and save them as video.
• Gmail:- Send email to and from a mobile phone, adjust Gmail's layout with a style sheet, and a lot more
• iGoogle:- Create your own gadgets, program a screenscraper, add Flash games, and more.
• Google Calendar:- Add web content events, public calendars, and your Outlook Calendar to this application.
• Google Reader, Google Maps, Google Earth, and Google SketchUp:- the new 3D modeling software tool.
• Picasa, YouTube, and Google Video:-- customize and use these media management apps.

 

 

 

Read More

Php Operators

PHP Operators The following table lists the operators from highest to lowest precedence. Operators A !, ~, ++, --, @ Right *, /, % Left +, -, . Left <<, >> Left <, <=, >=, > Nonassociative ==, !=, ===, !== Nonassociative & Left ^ Left | Left && Left || Left ? : (conditional operator) Left =, +=, -=, *=, /=, %=, ^=, .=, &=, |=, <<=, >>= Left AND Left XOR Left OR Left

Read More

Php Networking Functions

There are many functions in php to convert or look up domain name, IP address,
protocol, and service information.

Domain name/IP address lookups and conversions

• gethostbynamel()
• gethostbyname()
• gethostbyaddr()
• ip2long()
• long2ip()

 Sockets

• fsockopen()
• pfsockopen()
• socket_get_status()
• socket_set_blocking()
• socket_set_timeout()
  
  
  DNS resource records
  
  
  • checkdnsrr()
  • getmxrr()
   

Read More

php-Error Control Operators

PHP gives one error control operator: the at sign (@).Any error messages that might be generated by that expression will be ignored.

If you have set a custom error handler function with set_error_handler() then it will still get called, but this custom error handler can call error_reporting() which will return 0 when the call that triggered the error was preceded by an @. 

<?php/* Intentional file error */$test_file = @file ('no_existent_file') or
    die ("Failed opening file: error was '$php_errormsg'");
// this works for any expression, not just functions:$val22 = @$cache[$key];// will not issue a notice if the index $key doesn't exist.
?> 

 

or  

add  error_reporting()  in the script

Read More

how to creating a Web Site

To create your own Web site, you need access to a Web server. Red Hat automatically installs the Apache Web server on its Linux systems. You can also rent Web page space on a remote server—a service many ISPs provide, some for free. On Red Hat systems, the directory set up by your Apache Web server for your Web site pages is /var/httpd/html. Other servers provide you with a directory for your home page. Place the Web pages you create in that directory. You place your home page here. You can make other subdirectories with their own Web pages to which these can link. Web pages are not difficult to create. Links from one page to another move users through your Web site. You can even create links to Web pages or resources on other sites. Many excellent texts are available on Web page creation and management.

Web pages are created using either HTML intro, the Hypertext Markup Language, or the newer extended version, XML, the Extended Markup Language. They are a subset of Standard Generalized Markup Language (SGML). Creating an HTML or XML document is a matter of inserting HTML or XML tags in a text file. In this respect, creating a Web page is as simple as using a tag-based word processor. You use the HTML tags to format text for display as a Web page. XML tags can include more detailed information about a particular connection such as object data or transaction characteristics. The Web page itself is a text file you can create using any text editor. If you are familiar with tag-based word processing on Unix systems, you will find it conceptually similar to nroff. Some HTML tags indicate headings, lists, and paragraphs, as well as links to reference Web resources.

Instead of manually entering HTML or XML code, you can use Web page composers. A Web page composer provides a graphical interface for constructing Web pages. Special Web page creation programs can easily help you create complex Web pages without ever having to type any HTML tags explicitly. Remember, though, no matter what tool you use to create your Web page, the Web page itself will be an HTML document.

Read More

top search-engines list

Google search
 930,000,000 -  Unique Monthly Visitors


 ask
 125,000,000 -  Unique Monthly Visitors

Aol Search
36,000,000 -  Unique Monthly Visitors


bing
 164,000,000 -  Unique Monthly Visitors

 Yahoo! Search
 166,000,000 -  Unique Monthly Visitors |


 MyWebSearch
14,000,000 -  Unique Monthly Visitors



Dogpile
 2,500,000 - Unique Monthly Visitors 


 WebCrawler
 2,600,000 -  Unique Monthly Visitors



 blekko
 9,500,000 -Unique Monthly Visitors

Lycos
4,800,000 - Unique Monthly Visitors |

 

 Info
2,900,000 - Unique Monthly Visitors




 GoodSearch
1,800,000 -  Unique Monthly Visitors


Infospace
 2,700,000 -  Unique Monthly Visitors



 Excite
 1,90,000 -  Unique Monthly Visitors

Read More

Static URLs and Dynamic URLs

The search engines treat static URLs differently than dynamic  URLs.


Static URLs 
Static URLs means  not add a query string.
By this definition, a URL referencing a PHP script without
parameters is still static.
 examples of static URLs :
http://example.com/index.html
http://www.example.com/site-map.php

Dynamic URLs
Dynamic URLs are  that add a query string, add  by ?.
 This string is used to pass various parameters to a script.

http://example.com/product.php?item_id=4&pic_id=2

Static URLs can be converted to DynamicURLs with the .htaccess

Read More

Cracker Seo Tips

b tags
Add the <b>  tags of few of  keyword  phrases  on each page.
Search engines see content in <b> tag of the  pages that instances of a
term or phrase on rankings.


Heading tag
One of the great Weapons the engines use in rankings is Heading tag.
Add H1 tag  on every page.

Title tags
Add keywords in titles, text, and meta data
As title tags are such an important tip of search engine
optimization.It will be for high ranking.


Social Media connections
Add all Social networking sites it help  your web site optimization
and increase your website linkability .tell your audience  about the site info.


Link building
Link building of the website is  very important that links coming in to as many sites.
if you do link outside then make sure there is few logical reason for redirect  visitors in that site.


Newsletters
You can connect with  customers and grow the businesses by sending newsletters with many news,info
picture.It will help you get  traffic to  your website.

Alt tag
The search engine spiders  find what your  image is about is by adding an Alt tag.
Alt tag is a string  that place texts to allow the search engine spiders to properly
index your page images.



Image name
 give a descriptive image name for your image of the website.IT will also help for
your search engine rankings.


SEO-friendly URL
 Add the main keyword in your URL,
for example http://example.com/seo-optimization-tips.
IT is uickly rankings those pages.


Google Analytics
Setup Google Analytics To find out how many visitors your site gets,
and what pages they visit,exactly what keywords your visitors searched for.


Also  See  Advanced SEO tips 2013

Read More