Tuesday, 27 August 2013

MySQL Query plus Grant Privileges

MySQL Query Tutorial is about basic queries which require in day to day work. This tutorial also show you how to create user, Grant Privileges and Show Privileges of specific user. it also show hot to connect it from PHP Page on same Network. Before reading this Tutorial you must have installed XAMPP, Apache and MySQL must be Running.

  1. Open your browser and go to the link PHP Myadmin
  2. Now Type database Name in Field "Create new database" and Press Create. (For Example Database Name is Search)
  3. Now Choose Database search from Drop Down Menu and click on SQL Tab on right Side.
  4. Write Below query in SQL Box and Press GO for creating your first MySQL Table.
    • CREATE TABLE IF NOT EXISTS `country` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) )
  5. Its time to add some values in country Table. clcik on SQL Tab and write following INSERT Query to add some countries.
    • INSERT INTO `country` (`name`) VALUES ( 'Afghanistan'), ( 'Africa'), ( 'Albania'), ( 'Algeria'), ( 'Andorra'), ( 'Canada');
  6. For View click on SQL Tab and Write Below Query.
    • SELECT * FROM `country`
  7. For Update click SQL Tab and write below Query.
    • UPDATE `country` SET `name` = 'Australia' WHERE `name` = 'Afghanistan';
  8. Now if you want to grant this database access to someone else you have to write below SQL Query in SQL Box.
    • CREATE USER 'username'@'%' IDENTIFIED BY 'passwordforuser'
  9. To Grant SELECT option to specific user write below code
    • GRANT SELECT ON search.country TO 'username'@'%'
  10. To Grant UPDATE option to specific user write below code
    • GRANT UPDATE ON search.country TO 'username'@'%'
  11. To Grant INSERT option to specific user write below code
    • GRANT INSERT ON search.country TO 'username'@'%'
  12. You can check Grant option for any user by writing below code.
    • SHOW GRANTS FOR 'username'@'%';
Above tutorial Reference is from MYSQL Reference Manual.
Website Link for this tutorial is Crewow website

Monday, 26 August 2013

PHP Easy Installation Tutorial

PHP Easy Installation Tutorial is for beginners guide to install PHP with Apache and MySQL. In future this tutorial explain more about how to create database , PHP Page and make pages secure using XAMPP. This tutorial is very basic tutorial for users who want to use PHP and write their first code in PHP. There are following steps to install PHP on Windows.
  1. Open Google in your browser.
  2. Type XAMPP and Search.
  3. Click on apache friends - XAMPP.
  4. Choose XAMPP for Windows (XAMPP for other Operating systems also available.
  5. Go Down and click on XAMPP Under download Heading.
  6. Now Click on Installer.
  7. Your download will start automatically.
  8. Now open Installer Exe and choose location and press Next and Follow other steps.
  9. After Installation complete please copy XAMPP Folder in any of your secondary drive.
  10. Now Click on XAMPP Folder and choose xampp-control.exe and then Start apache and Mysql as shown below.

CreWow - Free Website Training Tutorial and Resources

Friday, 23 August 2013

PHP Mail Form Tutorial

PHP mail form Tutorial will show you how to make a feedback form on your website. you just need to make a form and use PHP Mail Function. This Tutorial is based on W3 Schools Tutorial. This tutorial will show how to send email when form is filled and how to show from when its empty. We will use isset() Function which Determine if a variable is set and is not NULL.

Below are the steps for making the PHP Mail form.

  • Create contact.php page for this tutorial.
  • Write Below Code in contact.php because Below code will check if the email address is filled or not. if its filled then it will get data from form and Send Email. otherwise it will move to last step and else condition will execute. please see last step.

  • After if condition put below code , if email address is not filled below code will show the form for Suggestion.

Tuesday, 20 August 2013

15 Best Fireworks Tutorial

Fireworks is valuable for Web Developer for making PNG Images quickly. 
There are 15 Best Tutorials available for you to learn Fireworks quickly.

Sunday, 18 August 2013

CSS Layout Basic Tutorial

CSS Basic Layout Tutorial is a very good for begineers who want to design their frist website using DIV and CSS. it will teach how to make header , content area, right side bar and footer using CSS. it contains following pages and folder in source.

Source File of This Tutorial
  • Index.php
  • cufon-yui.js
  • caviar-dreams.cufonfonts.js
  • jquery-1.10.1.js
  • Style Folder
  • Images
  • CSS Folder
After Downloading Source File, you can copy the folder in www root directory of your and then try in Browser. if you do nat have PHP then you can change the index.php file to index.html and it can be run without apache server. Enjoy!

Wednesday, 14 August 2013

PHP Ajax Live Search Tutorial

Everyone look for good live search functionality and we develop this tutorial for you. Live Search Tutorial is a PHP Ajax Based Tutorial which containts following pages and Folders.

 Source File for this Tutorial

  • Index.php
  • Search.php
  • Connection.php
  • Search.sql
  • Style Folder
  • Images
  • Scripts
After Downloading Source File, First Create MySQL Database with the Name of  search. Now Run MySQL Code in Database to Create country Table. Sample code is available in Search.sql File. Then Check your Connection File and provide your Database Password. Now Copy All File in Root Folder of your server (htdocs or www). Now Try it in the Browser. Enjoy!