Category Archives: PHP

xampp apache not starting in windows7

if I m clicking on the xampp only mysql starting apche not starting its like below Please uninstall skype if skype is running in your machine. or if you are logged in with skype please logout. After doing above things and issues still exist, please change the apache server port number from 80 to 8080… Read More »

Passing more parameters from an input element to jquery function

<!DOCTYPE html>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script>
$(document).ready(function(){
    $(".mychk_box").click(function(){ 
      var loginid = $(this).data('loginid');
	  var questionid = $(this).data('questionid');
	  alert('Loginid'+loginid+'Questionid'+questionid);
	  if ($('#mycheckbox').is(":checked"))
	  {
	  alert('Checked');
	  }
    });
	
});
</script>
</head>
<body>
<input type="checkbox" id="mycheckbox" class="mychk_box" data-loginid='545' data-questionid='4343'>
<input type="checkbox" id="mycheckbox" class="mychk_box" data-loginid='100' data-questionid='111'>
<h2>Passing more than one parameters to a jquery function using checkbox</h2>

</body>
</html>

<!DOCTYPE html>

<html>

<head>

$(document).ready(function(){

$(".mychk_box").click(function(){

var loginid = $(this).data('loginid');

var questionid = $(this).data('questionid');

alert('Loginid'+loginid+'Questionid'+questionid);

if ($('#mycheckbox').is(":checked"))

{

alert('Checked');

}

});

</script>

</head>

<body>

<h2>Passing more than one parameters to a jquery function using checkbox</h2>

</body>

</html>

Show and hide checkbox using jquery

<!DOCTYPE html>
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script>
$(document).ready(function(){
    $("#disable").click(function(){ 
      $('#mycheckbox').prop('disabled', true);
    });
	$("#enable").click(function(){ 
      $('#mycheckbox').prop('disabled', false);
    });
});
</script>
</head>
<body>
<input type="checkbox" id="mycheckbox">
<h2>Hiding a check box using jquery function</h2>
<button id="disable">Click here to disable the checkbox</button>
<button id="enable">Click here to enable the checkbox</button>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

$(document).ready(function(){

$("#disable").click(function(){

$('#mycheckbox').prop('disabled', true);

});

$("#enable").click(function(){

$('#mycheckbox').prop('disabled', false);

});

</script>

</head>

<body>

<h2>Hiding a check box using jquery function</h2>

<button id="disable">Click here to disable the checkbox</button>

<button id="enable">Click here to enable the checkbox</button>

</body>

</html>

Regex validation for integers, with leading zeros

Below script will validate the numbers using regex it will allow 0 1 it will not allow 00,0000,01, 02 etc. Regex using javascript

<script language="javascript">

var text = '-1';
var thisRegex = new RegExp('^(0|[1-9][0-9]*)$');
if(!thisRegex.test(text)){
    alert('fail');
}
else
{
alert('success');
}
     
</script>

var text = '-1';

var thisRegex = new RegExp('^(0|[1-9][0-9]*)$');

if(!thisRegex.test(text)){

alert('fail');

}

else

{

alert('success');

}

</script>

Regex using PHP

<?php
$str="dfsafdsa";
if (!preg_match("/^(0|[1-9][0-9]*)$/", $str))
    {echo "invalid";
        //$this->form_validation->set_message('regex_check', 'Please enter proper value for no of projects');
        return FALSE;
    }
    else
    {echo "valid";
        return TRUE;
    }

?>

<?php

$str="dfsafdsa";

if (!preg_match("/^(0|[1-9][0-9]*)$/", $str))

{echo "invalid";

//$this->form_validation->set_message('regex_check', 'Please enter proper value for no of projects');

return FALSE;

}

else

{echo "valid";

return TRUE;

}

group_concat function not returing all values in mysql–it returns some values with one comma at the end.

If you execute the below code and try to execute the query through phpmyadmin/php script. it will return only few records not all records. you can use the below files,db sructure to check the issues database table- create a table inside the db called ‘test’

CREATE TABLE IF NOT EXISTS `tbl_data` (
`id` int(10) NOT NULL,
  `question_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL
)

CREATE TABLE IF NOT EXISTS `tbl_data` (

`id` int(10) NOT NULL,

`question_id` int(10) NOT NULL,

`user_id` int(10) NOT NULL

)

# index.php

<?php
include"connect.php";
for($i=0;$i<1500;$i++)
{

$query="insert into tbl_data(question_id,user_id) values('$i','10')";

$result=mysql_query($query,$linkfirst);
}
?>

<?php

include"connect.php";

for($i=0;$i<1500;$i++)

{

$query="insert into tbl_data(question_id,user_id) values('$i','10')";

$result=mysql_query($query,$linkfirst);

}

#connect.php

<?php
$linkfirst = mysql_connect('localhost', 'root', '');
if (!$linkfirst) {
    die('Could not connect: ' . mysql_error());
}
 mysql_select_db('test', $linkfirst) or die('Could not select database.');

?>

<?php

$linkfirst = mysql_connect('localhost', 'root', '');

if (!$linkfirst) {

die('Could not connect: ' . mysql_error());

}

mysql_select_db('test', $linkfirst) or die('Could not select database.');

To get proper values… Read More »

Removing a special character at the end of a Label using jquery/javascript

Removing the symbol * from the label using jquery

<label>Welcome text*</label>
<label>Welcome text2*</label>
<label>Welcome text3</label>
<label>Welcome text4</label>


$( "label" ).each(function() {
       
        var label_text_content=$(this).html(); 
       
        var Lengthoftext = label_text_content.length; 
        var last_char= label_text_content.charAt(Lengthoftext - 1); 
        
        if(last_char=="*")
            {
               var label_text_without_specialchar = label_text_content.substring(0, label_text_content.length-1);
               
               $(this).html(label_text_without_specialchar);
            }
       
       
});

<label>Welcome text*</label>

<label>Welcome text2*</label>

<label>Welcome text3</label>

<label>Welcome text4</label>

$( "label" ).each(function() {

var label_text_content=$(this).html();

var Lengthoftext = label_text_content.length;

var last_char= label_text_content.charAt(Lengthoftext - 1);

if(last_char=="*")

{

var label_text_without_specialchar = label_text_content.substring(0, label_text_content.length-1);

$(this).html(label_text_without_specialchar);

}

});

Disable and Enable a Div and input elements inside the div

<html>
<head>
<meta content="text/html;charset=utf-8" http-equiv="Content-Type">
<meta content="utf-8" http-equiv="encoding">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<title>Hiding a div and its Element using jquery</title>
<body>
<div id="my_div">
<div>
<label>Textbox:</label><input type="text" id="name" name="name">
</div>
<div>
<label>Radio Button:</label><input type="radio" id="radiobutton" name="radiobutton">
</div>
<div>
<label>Checkbox:</label><input type="checkbox" id="chkbutton" name="chkbutton">
</div>
<div>
<label>Textarea:</label><textarea name="address" id="address"></textarea>
</div>
<div>
<label>Dropdown:</label>
<select name="country" id="country">
<option value="india">India</option>
<option value="china">China</option>
<option value="srilanka">Srilanka</option>
</select>
</div>
<div>

</div>
</div>
<a href="#" Onclick="disablediv();">Disable</a>
<a href="#" Onclick="enablediv();">Enable</a>
</body>
<script type="text/javascript">
 
function disablediv()
	{
	$("#my_div").find("input,textarea,select").removeAttr("enabled", "enabled");
	$("#my_div").find("input,textarea,select").attr("disabled", "disabled");
	
	}
	function enablediv()
	{
	$("#my_div").find("input,textarea,select").removeAttr("disabled", "disabled");
	$("#my_div").find("input,textarea,select").attr("enabled", "enabled");
	}

    $(document).ready(function() {
	
	
	$("#my_div").find("input,textarea,select").attr("disabled", "disabled");


 });
 </script>
</head>
</html>

<html>

<head>

<title>Hiding a div and its Element using jquery</title>

<body>

<div>

<label>Textbox:</label><input type="text" id="name" name="name">

</div>

<div>

<label>Radio Button:</label><input type="radio" id="radiobutton" name="radiobutton">

</div>

<div>

<label>Checkbox:</label><input type="checkbox" id="chkbutton" name="chkbutton">

</div>

<div>

<label>Textarea:</label><textarea name="address" id="address"></textarea>

</div>

<div>

<label>Dropdown:</label>

<option value="india">India</option>

<option value="china">China</option>

<option value="srilanka">Srilanka</option>

</select>

</div>

<div>

</div>

<a href="#" Onclick="disablediv();">Disable</a>

<a href="#" Onclick="enablediv();">Enable</a>

</body>

function disablediv()

{

$("#my_div").find("input,textarea,select").removeAttr("enabled", "enabled");

$("#my_div").find("input,textarea,select").attr("disabled", "disabled");

}

function enablediv()

{

$("#my_div").find("input,textarea,select").removeAttr("disabled", "disabled");

$("#my_div").find("input,textarea,select").attr("enabled", "enabled");

}

$(document).ready(function() {

$("#my_div").find("input,textarea,select").attr("disabled", "disabled");

});

</script>

</head>

</html>

Calling an ajax function inside a function

if ajax call return data to a function we should use async:false otherwise it will not work.if we you are not giving async:false in the ajax headers it will not return any value.

var output=checkvalue();

function checkvalue()
{
var myform = document.getElementById("my_form");
            var mydata = new FormData(myform);
		
            $.ajax({ 
					 url: 'test.php',
             	     type: "POST",
                     data:  mydata,
                     contentType: false,
                     cache: false,
                     processData:false,
		     async :false,
            success: function(data){ 
			
		}
		return data;


}

var output=checkvalue();

function checkvalue()

{

var myform = document.getElementById("my_form");

var mydata = new FormData(myform);

$.ajax({

url: 'test.php',

type: "POST",

data: mydata,

contentType: false,

cache: false,

processData:false,

async :false,

success: function(data){

}

return data;

}

Submitting an entire form fields to php page using ajax

 var myform = document.getElementById("my_form");
            var mydata = new FormData(myform);
		
            $.ajax({ 
 		     url: 'test.php',
             	     type: "POST",
                     data:  mydata,
                     contentType: false,
                     cache: false,
                     processData:false,
		             
            success: function(data){ 
			
		}

var myform = document.getElementById("my_form");

var mydata = new FormData(myform);

$.ajax({

url: 'test.php',

type: "POST",

data: mydata,

contentType: false,

cache: false,

processData:false,

success: function(data){

}

Compare two arrays using php

$first_array=array("a"=>"hello","b"=>"hi","c"=>"how","d"=>"are");
$second_array=array("a"=>"hello","b"=>"hi","c"=>"how");

$result=array_diff($first_array,$second_array);
echo count($result);echo "<br>";
if((count($first_array)!=count($second_array)) or (count($result)>0)){ echo "change";}else{echo "no change";}

$first_array=array("a"=>"hello","b"=>"hi","c"=>"how","d"=>"are");

$second_array=array("a"=>"hello","b"=>"hi","c"=>"how");

$result=array_diff($first_array,$second_array);

echo count($result);echo "<br>";

if((count($first_array)!=count($second_array)) or (count($result)>0)){ echo "change";}else{echo "no change";}