Thursday, 28 March 2013

Time-Stamp (mySQL)

 USED FOR GETTING SERVER DATE & TIME


 select DATE_FORMAT(columnName,'%d/%m/%Y') from tablename
Posted by at No comments:
Labels:

jQuery conflict 


<script>
var jQ144 = jQuery.noConflict(true);
jQ144(document).ready(function($)
{
$('.jqte-test').jqte();
});
</script>
Posted by at No comments:
Labels:

Saturday, 16 March 2013

Image upload and retrieve in a Binary method using php and mysql

Inserting Image 
<?php

// Create MySQL login values and
// set them to your login information.

$username = "root";
$password = "123";
$host = "localhost";
$database = "test";

// Make the connect to MySQL or die
// and display an error.

$link = mysql_connect($host, $username, $password);

if (!$link)
 {
    die('Could not connect: ' . mysql_error());
 }
// Select your database
mysql_select_db ($database);
// Make sure the user actually
// selected and uploaded a file
if (isset($_FILES['image']) && $_FILES['image']['size'] > 0)
 {
      // Temporary file name stored on the server
      $tmpName  = $_FILES['image']['tmp_name']; 
      // Read the file
      $fp      = fopen($tmpName, 'r');
      $data = fread($fp, filesize($tmpName));
      $data = addslashes($data);
      fclose($fp);


      // Create the query and insert
      // into our database.
      $query = "INSERT INTO tbl_images ";
      $query .= "(image) VALUES ('$data')";
      $results = mysql_query($query, $link);
      // Print results
      print "Thank you, your file has been uploaded."; 
}
else
{
     print "No image selected/uploaded";
}
// Close our MySQL Link
mysql_close($link);
?>
Displaying Images 
<?php
$username = "root";
$password = "123";
$host = "localhost";
$database = "test";
@mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());
@mysql_select_db($database) or die("Can not select the database: ".mysql_error());
$query = mysql_query("SELECT * FROM tbl_images");
while($row = mysql_fetch_array($query))
{
echo '<img src="data:image/jpg;base64,'.base64_encode($row['image']).'" /><br /><br /><br />';
}
?>

Download

Posted by at No comments:
Labels:

Thursday, 14 March 2013

jQuery-Ajax for Passing Values to Intermediate page 

<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
function searchNow() { 
$("#im").css({"display":"block"});
var a=$("#h").val();
var b=$("#hi").val();
var dataString = 'name='+ a + '&namei=' + b;
//your validation code
$.ajax( {
        type:"POST",
  async: false,
        url:"register.php",
        data: dataString,
        success: function(data) {
    //alert("test");
    $("#im").css({"display":"none"});
            $("#message").html(data);
        }
    } );
}

</script>

Posted by at No comments:
Labels:

Thursday, 7 March 2013

jQuery for calculating nights in between two dates!


Jquery :

$('#enddate').change(function()  {
<!--alert('Handler for .change() called.'); -->
var night = $("#end-date").val();
var de=$("#start-date").val();
function parseDate(str)
{
var mdy = str.split('/')
return new Date(parseInt(mdy[2], 10), // Year
parseInt(mdy[1], 10) - 1, // Month (starts with 0)
parseInt(mdy[0], 10)); // Day of month
}
function daydiff(night,de)
{
return (de-night)/(1000*60*60*24)
}
//var end=de-night;
$('#nights').val(daydiff(parseDate($('#start-date').val()), parseDate($('#end-date').val())));

var gt=$("#nights").val();
$('#dis').html(gt);
if(isNaN(gt))
{
$("#nights").css({"display":"none"});
$("#dis").css({"display":"none"});
$("#ni").css({"display":"none"});
}
else
{
$("#nights").css({"display":"block"});
$("#dis").css({"display":"block"});
$("#ni").css({"display":"block"});
}

});


$('#start-date').change(function() {
<!--alert('Handler for .change() called.'); -->
var night = $("#end-date").val();
var de=$("#start-date").val();
function parseDate(str)
{
var mdy = str.split('/')
return new Date(parseInt(mdy[2], 10), // Year
parseInt(mdy[1], 10) - 1, // Month (starts with 0)
parseInt(mdy[0], 10)); // Day of month
}
function daydiff(night,de)
{
return (de-night)/(1000*60*60*24)
}
//var end=de-night;
$('#nights').val(daydiff(parseDate($('#start-date').val()), parseDate($('#end-date').val())));

var gt=$("#nights").val();
$('#dis').html(gt);
if(isNaN(gt))
{
$("#nights").css({"display":"none"});
$("#dis").css({"display":"none"});
$("#ni").css({"display":"none"});
}
else
{
$("#nights").css({"display":"block"});
$("#dis").css({"display":"block"});
$("#ni").css({"display":"block"});
}

if(gt==0)
{
alert('start date and end date will be same pls change it!');
$("#start-date").val("");
$("#nights").val("");
$('#dis').html("");
}
if(gt<0)
{
alert("start date is greater than end date pls chage it!");
$("#end-date").val("");
$("#nights").val("");
$('#dis').html("");
}
//var end=de-night;
});

});

</script>

<script>
var gty=$("#nights").val();
if(gty!=isNaN)
{
$("#nights").css({"display":"none"});
}
else
{
$("#nights").css({"display":"block"});
}
</script>

<!--script for room management -->
<script type="text/javascript" charset="utf-8">
$(function()
{
$('#rooms').change(function() { //aading rooms
var room=$("#rooms").val();
if(room==2)
{
$("#one").css({"display":"block"});
$("#secondtr").css({"display":"block"});
$("#third").css({"display":"none"});
$("#fourth").css({"display":"none"});
$('#adult1').attr("disabled", false);
$('#adult2').attr("disabled", true);
$('#adult3').attr("disabled", true);
$('#child1').attr("disabled", false);
$('#child2').attr("disabled", true);
$('#child3').attr("disabled", true);
}
if(room==3)
{
$("#one").css({"display":"block"});
$("#secondtr").css({"display":"block"});
$("#third").css({"display":"block"});
$("#fourth").css({"display":"none"});
$('#adult1').attr("disabled", false);
$('#adult2').attr("disabled", false);
$('#adult3').attr("disabled", true);
$('#child1').attr("disabled", false);
$('#child2').attr("disabled", false);
$('#child3').attr("disabled", true);
}
if(room==4)
{
$("#one").css({"display":"block"});
$("#secondtr").css({"display":"block"});
$("#third").css({"display":"block"});
$("#fourth").css({"display":"block"});
$('#adult1').attr("disabled", false);
$('#adult2').attr("disabled", false);
$('#adult3').attr("disabled", false);
$('#child1').attr("disabled", false);
$('#child2').attr("disabled", false);
$('#child3').attr("disabled", false);
}
if(room==1)
{
$("#one").css({"display":"block"});
$("#secondtr").css({"display":"none"});
$("#third").css({"display":"none"});
$("#fourth").css({"display":"none"});
$('#adult1').attr("disabled", true);
$('#adult2').attr("disabled", true);
$('#adult3').attr("disabled", true);
$('#child1').attr("disabled", true);
$('#child2').attr("disabled", true);
$('#child3').attr("disabled", true);
}
});
/*for adding childs and adults maintain */
$('#adult').change(function() {
var adult=$("#adult").val();
if(adult==2)
{
$(".ch").css({"display":"none"});
$(".chill").css({"display":"block"});
$(".chil").css({"display":"block"});
$(".chi").css({"display":"block"});
}
if(adult==3)
{
$(".chi").css({"display":"none"});
$(".ch").css({"display":"none"});
$(".chill").css({"display":"block"});
$(".chil").css({"display":"block"});
}
if(adult==4)
{
$(".ch").css({"display":"none"});
$(".chi").css({"display":"none"});
$(".chil").css({"display":"none"});
$(".chill").css({"display":"block"});
}
if(adult==1)
{
$(".ch").css({"display":"block"});
$(".chi").css({"display":"block"});
$(".chil").css({"display":"block"});
$(".chill").css({"display":"block"});
}
});
$('#child').change(function() {
var child=$("#child").val();
if(child==1)
{
$(".a").css({"display":"none"});
$(".ad").css({"display":"block"});
$(".adu").css({"display":"block"});
$(".adul").css({"display":"block"});
}
if(child==2)
{
$(".a").css({"display":"none"});
$(".ad").css({"display":"none"});
$(".adu").css({"display":"block"});
$(".adul").css({"display":"block"});
}
if(child==3)
{
$(".a").css({"display":"none"});
$(".ad").css({"display":"none"});
$(".adu").css({"display":"none"});
$(".adul").css({"display":"block"});
}
if(child==0)
{
$(".a").css({"display":"block"});
$(".ad").css({"display":"block"});
$(".adu").css({"display":"block"});
$(".adul").css({"display":"block"});
}
});
<!--second -->
$('#adult1').change(function() {
var adult=$("#adult1").val();
if(adult==2)
{
$(".ch2").css({"display":"none"});
$(".chill2").css({"display":"block"});
$(".chil2").css({"display":"block"});
$(".chi2").css({"display":"block"});
}
if(adult==3)
{
$(".chi2").css({"display":"none"});
$(".ch2").css({"display":"none"});
$(".chill2").css({"display":"block"});
$(".chil2").css({"display":"block"});
}
if(adult==4)
{
$(".ch2").css({"display":"none"});
$(".chi2").css({"display":"none"});
$(".chil2").css({"display":"none"});
$(".chill2").css({"display":"block"});
}
if(adult==1)
{
$(".ch2").css({"display":"block"});
$(".chi2").css({"display":"block"});
$(".chil2").css({"display":"block"});
$(".chill2").css({"display":"block"});
}
});
$('#child1').change(function() {
var child=$("#child1").val();
if(child==1)
{
$(".a2").css({"display":"none"});
$(".ad2").css({"display":"block"});
$(".adu2").css({"display":"block"});
$(".adul2").css({"display":"block"});
}
if(child==2)
{
$(".a2").css({"display":"none"});
$(".ad2").css({"display":"none"});
$(".adu2").css({"display":"block"});
$(".adul2").css({"display":"block"});
}
if(child==3)
{
$(".a2").css({"display":"none"});
$(".ad2").css({"display":"none"});
$(".adu2").css({"display":"none"});
$(".adul2").css({"display":"block"});
}
if(child==0)
{
$(".a2").css({"display":"block"});
$(".ad2").css({"display":"block"});
$(".adu2").css({"display":"block"});
$(".adul2").css({"display":"block"});
}
});
<!--third -->
$('#adult2').change(function() {
var adult=$("#adult2").val();
if(adult==2)
{
$(".ch3").css({"display":"none"});
$(".chill3").css({"display":"block"});
$(".chil3").css({"display":"block"});
$(".chi3").css({"display":"block"});
}
if(adult==3)
{
$(".chi3").css({"display":"none"});
$(".ch3").css({"display":"none"});
$(".chill3").css({"display":"block"});
$(".chil3").css({"display":"block"});
}
if(adult==4)
{
$(".ch3").css({"display":"none"});
$(".chi3").css({"display":"none"});
$(".chil3").css({"display":"none"});
$(".chill3").css({"display":"block"});
}
if(adult==1)
{
$(".ch3").css({"display":"block"});
$(".chi3").css({"display":"block"});
$(".chil3").css({"display":"block"});
$(".chill3").css({"display":"block"});
}
});
$('#child2').change(function() {
var child=$("#child2").val();
if(child==1)
{
$(".a3").css({"display":"none"});
$(".ad3").css({"display":"block"});
$(".adu3").css({"display":"block"});
$(".adul3").css({"display":"block"});
}
if(child==2)
{
$(".a3").css({"display":"none"});
$(".ad3").css({"display":"none"});
$(".adu3").css({"display":"block"});
$(".adul3").css({"display":"block"});
}
if(child==3)
{
$(".a3").css({"display":"none"});
$(".ad3").css({"display":"none"});
$(".adu3").css({"display":"none"});
$(".adul3").css({"display":"block"});
}
if(child==0)
{
$(".a3").css({"display":"block"});
$(".ad3").css({"display":"block"});
$(".adu3").css({"display":"block"});
$(".adul3").css({"display":"block"});
}
});
<!--fourth -->
$('#adult3').change(function() {
var adult=$("#adult3").val();
if(adult==2)
{
$(".ch4").css({"display":"none"});
$(".chill4").css({"display":"block"});
$(".chil4").css({"display":"block"});
$(".chi4").css({"display":"block"});
}
if(adult==3)
{
$(".chi4").css({"display":"none"});
$(".ch4").css({"display":"none"});
$(".chill4").css({"display":"block"});
$(".chil4").css({"display":"block"});
}
if(adult==4)
{
$(".ch4").css({"display":"none"});
$(".chi4").css({"display":"none"});
$(".chil4").css({"display":"none"});
$(".chill4").css({"display":"block"});
}
if(adult==1)
{
$(".ch4").css({"display":"block"});
$(".chi4").css({"display":"block"});
$(".chil4").css({"display":"block"});
$(".chill4").css({"display":"block"});
}
});
$('#child3').change(function() {
var child=$("#child3").val();
if(child==1)
{
$(".a4").css({"display":"none"});
$(".ad4").css({"display":"block"});
$(".adu4").css({"display":"block"});
$(".adul4").css({"display":"block"});
}
if(child==2)
{
$(".a4").css({"display":"none"});
$(".ad4").css({"display":"none"});
$(".adu4").css({"display":"block"});
$(".adul4").css({"display":"block"});
}
if(child==3)
{
$(".a4").css({"display":"none"});
$(".ad4").css({"display":"none"});
$(".adu4").css({"display":"none"});
$(".adul4").css({"display":"block"});
}
if(child==0)
{
$(".a4").css({"display":"block"});
$(".ad4").css({"display":"block"});
$(".adu4").css({"display":"block"});
$(".adul4").css({"display":"block"});
}


});		 });

Html:

<divid="container">
<form name="chooseDateForm" id="chooseDateForm" action="" method="post">
<fieldset class="fi">
<legend>Test date picker form</legend>
<label for="start-date" >Start date:</label><p>
<input name="start-date" id="start-date" class="date-pick dp-applied"><a href="#" class="dp-choose-date" title="Choose date" style="display:none;">Choose date</a></p><br><br>
<label for="end-date" >End date:</label><p>
<input name="end-date" id="end-date" class="date-pick dp-applied"><a href="#" class="dp-choose-date" title="Choose date" style="display:none;">Choose date</a></p><br><br>
<input type="hidden" id="nights" name="nights" readonly="true"/>
<label id="dis"></label><label id="ni" style="display:none;">nights</label>
<br><br>


<div id="peop">
<div class="al">
<label>Rooms</label>
<select id="rooms" name="rooms">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
</div>
<div class="al">
<table width="125" height="40" border="0" id="ser" >
<!--first room -->
<tr id="one">
<td width="6">&nbsp;</td>
<td width="51" align="right" valign="top">
<label>adults</label>
<select id="adult" name="adult[]">
<option value="1" class="adul" >1</option>
<option value="2" class="adu">2</option>
<option value="3" class="ad">3</option>
<option value="4" class="a">4</option>
</select>
</td>
<td width="2">&nbsp;</td>
<td width="38" align="left" valign="top">
<label>child</label>
<select id="child" name="child[]">
<option value="0" class="chill">0</option>
<option value="1" class="chil">1</option>
<option value="2" class="chi">2</option>
<option value="3" class="ch">3</option>
</select>
</td>
</tr>
<!--second room -->
<tr id="secondtr" style="display:none;">
<td width="6">&nbsp;</td>
<td width="51" align="right" valign="top"> <label>adults</label>
<select id="adult1" name="adult[]" disabled="disable">
<option value="1" class="adul2" >1</option>
<option value="2" class="adu2">2</option>
<option value="3" class="ad2">3</option>
<option value="4" class="a2">4</option>
</select>
</td>
<td width="2">&nbsp;</td>
<td width="38" align="left" valign="top"> <label>child</label>
<select id="child1" name="child[]" disabled="disable">
<option value="0" class="chill2">0</option>
<option value="1" class="chil2">1</option>
<option value="2" class="chi2">2</option>
<option value="3" class="ch2">3</option>
</select>
</td>
</tr>
<!--third room -->
<tr style="display:none;" id="third">
<td width="6">&nbsp;</td>
<td width="51" align="right" valign="top"> <label>adults</label>
<select id="adult2" name="adult[]" disabled="disable">
<option value="1" class="adul3" >1</option>
<option value="2" class="adu3">2</option>
<option value="3" class="ad3">3</option>
<option value="4" class="a3">4</option>
</select>
</td>
<td width="2">&nbsp;</td>
<td width="38" align="left" valign="top"> <label>child</label>
<select id="child2" name="child[]" disabled="disable">
<option value="0" class="chill3">0</option>
<option value="1" class="chil3">1</option>
<option value="2" class="chi3">2</option>
<option value="3" class="ch3">3</option>
</select>
</td>
</tr>
<!--fourth room -->
<tr style="display:none;" id="fourth">
<td width="6">&nbsp;</td>
<td width="51" align="right" valign="top"> <label>adults</label>
<select id="adult3" name="adult[]" disabled="disable">
<option value="1" class="adul4" >1</option>
<option value="2" class="adu4">2</option>
<option value="3" class="ad4">3</option>
<option value="4" class="a4">4</option>
</select>
</td>
<td width="2">&nbsp;</td>
<td width="38" align="left" valign="top"> <label>child</label>
<select id="child3" name="child[]" disabled="disable">
<option value="0" class="chill4">0</option>
<option value="1" class="chil4">1</option>
<option value="2" class="chi4">2</option>
<option value="3" class="ch4">3</option>
</select>
</td>
</tr>


</table>

</div>
</div>
<input type="submit" value="submit" name="sub">
</fieldset>
</form>
</div>
<tt id="results"></tt>
</div>




Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)