May
19
2012

Tutorial on using Google Maps API in your Website

Google Maps API key Access

If you like to display Google maps in your website showing particular location on the maps everytime the page loads, Or if you like the user to select a point on a map to reveal his location to you, The simple way is to use free Google Maps API to display maps in your site. Sign up for an API key To display maps, or to get the maps co- ordinates from your site user,  first you [...]

May
17
2012

Jquery Popup Box to any HTML Website

Jquery Popup box to any static HTML website

In this Jquery Popup Blogger Widget, We had seen implementing jquery popup widget for blogger, In this tutorial we can see implementing the popup on any Static or Dyanmic HTML Website. To implement this popup on particular page, Open any particlar page you want the popup should appear. Before the </head> section add the following style. The CSS Style Then Just below the style add the following script Necessary Jquery Scripts   This script is [...]

May
17
2012

Setting Up Local Testing Server using Adobe Dreamweaver

Default Local Testing Server

In this previous tutorial http://www.theprogrammersguide.com/how-to-set-up-a-website-using-dreamweaver-cs5/ of setting up a website, a remote testing server is used, which is a very bad idea because, dreamweaver will connect to your webserver and upload your file each and everytime you need to test your file. You require an active internet connection to test your files. This process will be time consuming. The best approach is setting up a local webserver to test your files and then finally after developing completely [...]

May
17
2012

Setting Up a website in Dreamweaver CS5

Setting Remote server Info dreamweawer cs5

This tutorials walks you through the set up process of creating & setting up a simple website using dreamweaver cs5 including remote server info and deploying it. To set up open your dreamweaver, (Setup will be similar in all dreamweaver versions from cs3. The screenshots are made using dreamweaver cs5)   Goto SETUP -> Manage site   Now manage sites dialog box will open as shown below.   Choose any  site name you wish, Then [...]

Apr
16
2012

Submitting all Blog posts as sitemap to Google Webmaster tools

Adding all blog posts to google webmaster tools

For everyone who uses blog spot blog should do an important thing that is to submit their blog posts to google webmaster tools so that their blog posts will get indexed by Google and shows up in Google search results. For those who are unaware of Google webmaster tools, just go and sign in using this link with your google account. Once you log on to your webmaster account you can see only 26 indexed pages of [...]

Apr
16
2012
HTML // MySQL // PHP

Dynamically populating content of HTML dropdown using values of MySQL database using PHP

At many instants manually adding the contents and values of HTML drop down list is not feasible. So the most efficient way is to save the content and values of dropdown in mysql database and dynamically populating the contents of the dropdown using the values stored in mysql database using PHP. The advantage of following this techniques is, first let us consider you displayed country list as HTML dropdown at 10 different places of your website. So [...]

Apr
16
2012

Creating a javascript popup window with custom size

To open popup window add the following code in the head section Use the following <a> tag whereever you need to open popup window Samplefile.php should be replaced by your own file name. You can customize the attributes Scrollbars, resizeable, width and height to match your requirements. The advantages of using this function is, this popup will not be blocked by any popup blocker.

Apr
12
2012

Export Your MySQL data to Excel or CSV

Export Mysql data to CSV using PHP

Exporting the mysql database data to excel file using PHP can be done using the following piece of code i built. First connect to your database using your Username and password. Execute the above code you’ll get the result as a downloadable CSV file format

Apr
12
2012

Using Webservice in PHP using CURL tutorial

Web services play an important role in today’s web development process. To use webservice in PHP,  you have to use CURL with correct timeout settings. Because some webservices might be slow to respond, we have to handle in our code accordingly. Let us say the following webserivice URL creates a new record. http://www.webserviceurl.com/dispatch_ws.php?action=create We have to send two data, employee name and employee id in POST form to create the employee record using webservice. To [...]

Apr
12
2012

Mysql Join and subqueries

MySQL Join Queries Syntax

Using Mysql Join Queries  will retruns results upto 10 times faster in contrast to mysql subqueries. Let us consider some examples of mysql join queries Let us consider two tables. One table is “users” which contain user information like id, full_name etc. Other table “advads” contains ads posted by users which contain fields id,advid,title etc Users table id is stored in advads table advid for referencing the ad posted by particular user The advads table [...]

Pages:123»
Click to Subscribe

Subscribe Via Email

The Programmers Guide Logo