Bulk Update using join in SQL

UPDATE WITH JOIN

 UPDATE t1
  SET t1.name = t2.empname  //copy content from one table to another
 FROM table1 t1
    INNER JOIN table2 t2 ON
        t1.id = t2.t1id

how to implement Tweet snd linkedin button for each and every post in Your blog ??

how to implement Tweet snd linkedin share button for each and every post in Your blog ??

Some of the Steps we have to follow to complete the above task.

1.Go to Dashboard->Template
2.Click Edit HTML
3.Search <data:post.body/>
4.Paste the below code 
<!--TWITTER-->
<b:if cond='data:blog.pageType != &quot;static_page&quot;'> <div style='text-align:left;padding:5px 5px 5px 0;'> <a class='twitter-share-button' data-count='horizontal' data-related='' data-via='technoblaze1' expr:data-text='data:post.title' expr:data-url='data:post.url' href='http://twitter.com/share'>Tweet</a> <script src='http://platform.twitter.com/widgets.js' type='text/javascript'/> </div> </b:if>
<p>
<!--LINKEDIN-->
<script src='http://platform.linkedin.com/in.js' type='text/javascript'/> 

  <script data-counter='right' type='IN/Share'/></p>

SCREEN SHOTS:

STEP:1

STEP:2 & 3

STEP:4

STEP:5&6

Facebook like button for each post in blogger

how to implement Facebook like button for each and every post in Your blog ??

Some of the Steps we have to follow to complete the above task.

1.Go to Dashboard->Template
2.Click Edit HTML
3.Search <data:post.body/>
4.Paste the below code 
   
<p><iframe allowTransparency='true' expr:src='&quot;http://www.facebook.com/plugins/like.php?href=&quot; + data:post.url + &quot;&amp;layout=button_count&amp;show_faces=false&amp;width=100&amp; action=like&amp;font=arial&amp;colorscheme=light&quot;' frameborder='0' scrolling='no' style='border:none; overflow:hidden; width:100px; height:20px;'/></p>

5.Click Save template
6.View your blog.

Screen shots:

Step:1

Step:2 & 3

Step:4

Step: 5 & 6

Facebook like and unlike system using [php-mysql-ajax] and facebook wall post system with time calculation system for each post and display it in users wall

We have to make Facebook wall system,Face book like system and Facebook time management system  for each and every post
-In my previous post Facebook wall system will be implemented
-In this Post contains facebook like system and facebook time management system along with wall post system  will be implemented
-in this section i have created separate login system for every users 
-users can login and post their words in their wall 
-others users will like or unlike the post using their user-id
-face book time management means, users posts display the time when they   posted and how many hours,minutes or seconds ago they posted their words or quotes and all
- this are the task we have to done 
-there are several steps to complete our task
-Create database and following tables 
-there are 3 Table contains in database

      1.Login
      2.Messages
      3.message_like

1.Login table :

CREATE TABLE IF NOT EXISTS `login` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  PRIMARY KEY (`uid`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

2.Message table:

CREATE TABLE IF NOT EXISTS `messages` (

  `msg_id` int(11) NOT NULL AUTO_INCREMENT,

  `message` varchar(200) NOT NULL,

  `uid_fk` int(11) NOT NULL,

  `like_count` int(11) DEFAULT NULL,

  `created` varchar(250) DEFAULT NULL,

  PRIMARY KEY (`msg_id`),

  KEY `uid_fk` (`uid_fk`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

3.message_like table :

CREATE TABLE IF NOT EXISTS `message_like` (

  `like_id` int(11) NOT NULL AUTO_INCREMENT,

  `msg_id_fk` int(11) DEFAULT NULL,

  `uid_fk` int(11) NOT NULL,

  `created` varchar(250) NOT NULL,

  PRIMARY KEY (`like_id`),

  KEY `uid_fk` (`uid_fk`),

  KEY `msg_id_fk` (`msg_id_fk`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;

-Download the file and configure your hostname,username and password

-Live demo is available,check it 

- if any queries regarding, post your commands

Screen Shots:

A simple hotel booking software using [php-mysql-ajax]

Description:

We have to create simple hotel booking software using php,mysql
-there are several process to done the above task .
-first of all create the database for hotel booking system
-database contains 4 tables
     1.booking
     2.Customer
     3.invoice
     4.room
-booking table contains (id,arraival,checkout,room,customerid,cotrequire,satelliterequire,gamrequire,service)
-customer table contains(id,firstname,lastname,email,address,city,state,pincode,phone)
-invoice table contains(id,cusmail,chkout,roomno,roomtype,price,total etc..)
-room table contains (id,roomnum,type,price ,etc..)
-download this software
-install wamp software
-import database from download file in phpmyadmin
-configure and run it ..

screen shots:

Download

Dynamic Chat Design for android and ios

Description:

-Dynamic chat ui ll be created for android and ios mobiles.
-Dynamic chat ui created by using HTML5 and CSS3 technologies.
-It is very easy to integrate it.
-Systematic Explain will be done .
-Just download and use it. 
-Download file contains[chat.html,chatcs.css,battery.png,signal.png,wifi.png]
-If any queries please post your commands  !. 

Output will be :

Download

Dynamic Theme or background change using Colour picker

We can dynamically change the particular div background colour using javascript colour picker 
we have to follow 4 steps to done above task
step 1 :include jscolor picker file in ur file 
step 2 :create a text box and define a class color
step 3 :create javascript function for change the div background colour according to the selection by using js cookie 
step 4 :call the Js-function in text box onblur event 

picker.html

<html>
<head>
 <title>colour picker demo</title>
<script>
function pick()    //------------------------------------------>step 3
{
var elem = document.getElementById("para1").value;
var cook=document.cookie="#"+elem;
var colour=document.getElementById("change");
colour.style.background=cook;
}
</script>
</head>
<body>
<div style="height:100px; width:400px;" id="change"> 
<!--colour change-->
</div>
 <script type="text/javascript" src="jscolor.js"></script> //->step1
 Click here: <input class="color" value="" onblur="pick()" id="para1">//->step2
//---------------------------------------------------- >step 4
</body>
</html>

Video preview:

Download

cURL-tutorial startup

cURL:
         1.cURL is a Command line tool for getting and sending datas through URL 
         

Now we can display the Google webpage with search key word "technoblazze" in your server by using cURL
We have to Follow 4 steps to do the above task
1.initialize the curl session
2.set various option for the session
3.Execute the option, fetch and display the datas in your server
4.close the curl session

curl.php

<?php 
$curl = curl_init('http://www.google.com/search?q=technoblazze.blog'); //step1
curl_setopt($curl, CURLOPT_FAILONERROR, true);    //step2
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); 
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); 
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false); 
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);   
$result = curl_exec($curl);                       //step3
curl_close($curl);                                //step4
echo $result;
?>

Download

Start with XML - fetch and display the xml datas using php

books.xml :   
<?xml version="1.0"?>
<datas>
  <books>
    <book>

      <id>1</id>
      <title>PHP Undercover</title>  
      <author>Arun</author>
    </book>
    <book>
      <id>2</id>
      <title>PHP Enterprise</title>   
      <author>Vibin</author>
    </book>
  </books>
</datas>

xmlread.php :
<?php

$xml = simplexml_load_file("books.xml")
       or die("Error: Cannot create object");        //include the books.xml file
foreach($xml as $books)                                       // seperate variables, books array from xml file
{
 foreach($books as $book )                           // seperate variables, book array from books file
      {
   echo $book->id;                                        //display the id
   echo "<br />";
   echo $book->title;                                     //display the title
   echo "<br />";
   echo $book->author;                                //display the author
   echo "<br />";
 }

}
?>

Output:
1
PHP Undercover
Arun
2
PHP Enterprise
Vibin

Download

Cloud Computing

Cloud computing is a colloquial expression used to describe a variety of different computing concepts that involve a large number of computers that are connected through a real-time communication network (typically the Internet). Cloud computing is a jargon term without a commonly accepted non-ambiguous scientific or technical definition. In science, cloud computing is a synonym for distributed computing over a network and means the ability to run a program on many connected computers at the same time. The popularity of the term can be attributed to its use in marketing to sell hosted services in the sense of application service provisioning that run client server software on a remote location.

Advantages:

We can use and access the cloud from any where through internet.

Reduce the Storage capacity in your harddrive.

Cloud Storage Services :
Cloud storage services offer paid monthly subscriptions either for unlimited storage or for hundreds of gigabytes of data. Most of us do not have that much critical data to backup and therefore it would be a total waste of money. And for those of us who have data which cannot be stored using the 1 or 2GB free space offered, we have a list of four of the best free online storage services that offer free space of more than 10GB.

Best Sites for Cloud Computing :

1.Google Drive:

  Link : https://drive.google.com/‎
 

2.DROP BOX

Link:https://www.dropbox.com/

3:BOX

Link: https://www.box.com/

4:SKYDRIVE

Link: https://skydrive.live.com/‎