Categories
Google Google Maps MySql PHP phpMyAdmin Programming Languages

How to store Longitude/Latitude, from Google Maps in MySql?

If you are confused about the field type of longitude/latitude in the database tables and you are thinking about decimal or float then use the best way defined below.

In MySQL or SQL Server, we can save it as FLOAT( 10, 6 ) NOT NULL

This is the recommendation from google itself: https://developers.google.com/maps/articles/phpsqlajax

CREATE TABLE `markers` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 60 ) NOT NULL ,
`address` VARCHAR( 80 ) NOT NULL ,
`lat` FLOAT( 10, 6 ) NOT NULL ,
`lng` FLOAT( 10, 6 ) NOT NULL ,
`type` VARCHAR( 30 ) NOT NULL
) ENGINE = MYISAM ;

If you are using phpmyadmin then you can save the latitude and longitude shown below.

Categories
MySql PHP phpMyAdmin WAMP Server WebSites

How to install Wamp on your Computer and Run Online Websites at Local System

My life is so much hectic in Office and daily routine work. And thus i am not able to get time for writing good tips on my blog. But today i got a few minutes time to post a cool tips for my bloggers friends and newbies. Here is a trick and tips for new wordpress bloggers. Some of you may feel that if you can run your website on local computer and setup development environment on local machine then that would be such a great way to make modification in your website.
Here are the brief instructions about How to install Wamp and Run the online website at your personal Computer.

Step 1. Download the Wamp server from Official Website

Please choose the version depending on your operating system

If you are using Windows 32 bit operating system(Windows XP) then
download version Wamp version 32 bits

And if you are using Windows 64 bit operating system(Windows 7, Vista)
then download version Wamp version 64 bits

php” target=”_blank” title=”Click here to download the latest version of Wamp Server”>www.wampserver.com

Step 2. Locate the downloaded set up file and double-click on it. You will face an alert window warning saying that you do not upgrade from WAMP5 1.x. Click on Yes to continue.

Installing WAMP 2.0 - Alert Screen Image - How to Install Wamp Server

Step 3 .The Welcome setup window will load. Click on Next to proceed.

Installing WAMP 2.0 - Welcome Screen Image

Step 4 . On the License Agreement screen select the radio button for I accept the agreement then click on Next

Installing WAMP 2.0 - License Screen Image

Step 5 . The Select Destination Location screen will load. Change the default location if you desire then click on Next

Installing WAMP 2.0 - Destination Screen Image

Step 6 . Now the Select Additional Tasks screen is loaded. Select the checkboxes for any icons you want installing then click on Next

Installing WAMP 2.0 - Additional Tasks Screen Image

Step 7 . You will be faced with the Ready to Install screen. Review the settings and use the Back button to go back and change any of the settings. If the settings are correct, click on Install to install WAMP 2.0

WAMP 2.0 Installing - Review Settings Screen Image

Step 8 . If you have Mozilla Firefox installed on your PC, you may be faced with the following window that prompts whether you want FireFox to be your default browser, so select the appropriate choice.

Installing WAMP 2.0 - Firefox Screen Image

Step 9 . The PHP mail parameters screen will load. Review the default settings and change accordingly then click on Next. The default values can generally be used when installing WAMP 2.o to a local PC.

Installing WAMP 2.0 - PHP Mail Screen Image

Step 10 . The final screen to load is the installation completed screen. Click on Finish to close the window and start WAMP

Installing WAMP 2.0 - Completion Screen Image

Step 11 . WAMP 2.0 is started. The WampServer icon is loaded onto the system tray.

Installing WAMP   2.0 - System Tray Icon Image

This is the complete process of how to install Wamp server on your local computer. If you Want to know how to run the online website on your local computer then i will post the How to steps for Running an Online website on Local Computer.

Categories
MySql phpMyAdmin Wordpress

How to Backup your WordPress Database using simple steps

Today i will show you how to take backup of your wordpress database and stay happy for future issues like db lost, hacking and more.
Please backup the existing database by logging into your PHPMYADMIN. It is very necessary to backup the database before you proceed with any changes. I also backup my website database once in a week. It is a good practice to always backup your database before making any major changes(like cleaning database for spam comments and meta data and more). If anything gone wrong then you can easily be able to restore the backupd database.

If you are not a tech guy and want to backup the database in very simple steps and withuot taking much headache then you can download WP-DB-Backup or WP-DBManager plugin to backup your database through your WordPress admin panel. Alternatively, you can backup your database through phpMyAdmin manually.

If you are still reading and decide to backup your WordPress database manually then you should follow these very simple steps:

  1. Login to your phpMyAdmin(Generally phpMyAdmin can be accessed using cpanel of your website like this www.mysite.com/cpanel).
  2. Select your WordPress database(If you are more database installed on your web server).
  3. Click on Export at the top of the navigation.
  4. Select the tables you want to backup(i suggest you to backup all the tables), or select all tables to backup the whole database.
  5. Select SQL to export as .sql extension.
  6. Check the “Save as file” checkbox.
  7. Choose compression type, select gzipped to compress the database to a smaller size.
  8. Finally click Go, and a download window will prompt you to save your backup database file. Smile