update with multiple tables in mysql.

UPDATE personal INNER JOIN social ON social.personal_id = personal.per_id SET personal.email = 'palismahendra@gmail.com', social.facebook = 'pal@facebook.com' WHERE personal.per_id = 1

Comments

Post a Comment

Popular posts from this blog

dynamic create multiple ckeditor onclick event using jquery

<!DOCTYPE html> <html> <head> <title>New Ckeditor Instance Dynamically</title> <script type="text/javascript" src="ckeditor_3.5/ckeditor/ckeditor.js"></script> <script type="text/javascript" src="scripts/jquery-1.4.4.js"></script> <script type="text/javascript" src="ckeditor_3.5/ckeditor/adapters/jquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $('.jquery_ckeditor').ckeditor(); }); </script> <script> function newCkeditor(){ $('<div><textarea><\/textarea><\/div>') .appendTo('#body').find('textarea').ckeditor(); } function clicked(){ for ( instance in CKEDITOR.instances ){ alert("ckeditor values : " + CKEDITOR.instances[instance].getData()); } } </script> </head> <body...
Read more

get lat and long from city name using jquery

<html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>     <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false"></script> </head> <body>    <?php $city='indore'; ?>     <input id="btn" type="button" value="search for miami coordinates" />     <input type="hidden" class="cityName" name="cityName" value="<?php echo $city; ?>" />     <script> jQuery(document).ready(function($){ var cityName=$('.cityName').val();             var geocoder =  new google.maps.Geocoder();     geocoder.geocode( { 'address': cityName}, function(results, status) {           if (status == google.maps.GeocoderStatus.OK) {             alert("location : " + results[0].geometry.location.lat() +...
Read more

membership registration and login system in php

<?php include_once('header.php'); ?> <?php ob_start(); $message=''; $message1=''; $error=''; $firstnameError=''; $lastnameError=''; $usernameError=''; $emailError=''; $phoneError=''; $passwordError=''; $firstname = $lastname = $username =  $password = $phone = $email = ''; if(isset($_POST['membership_registration'])) { $status=0; $date_added = date('Y-m-d H:i:s'); if(!empty($_POST['membership_firstname']))   {     $firstname = mysqli_real_escape_string($con, $_POST['membership_firstname']);   }   else   {     $firstnameError='First Name is Required';   }   if(!empty($_POST['membership_lastname']))   {     $lastname = mysqli_real_escape_string($con, $_POST['membership_lastname']);   }   else   {     $lastnameError='Last Name is Required';   } if(!empty($_POST['membership_usern...
Read more