Technical Details and PHP Developer

how to show wifi password in windows 10

2020-05-17T09:52:00.000-07:00

how to hack wifi password using command prompt in windows 10

how to show wifi password using command prompt

how to show wifi password in windows 10

Step wise Step method:-

1. Click on Start Button, than Type CMD in search box

2. After that open command prompt (as admin by the right click) and Run following command

netsh wlan show profile “Type WIFI Name without quotation ” key=clear

After that you can find your wifi password.

how to split text in excel

2019-03-15T02:44:00.002-07:00

How to Split String or text in excel.

Formula For Result-1

=LEFT(A2, FIND("",A2,3))

A2= Cell address.

3= cut first three character

Formula for Result-2

If in excel String or text is separated by any word or character than used following formula

=LEFT(A2, FIND("p",A2,1))

A2= Cell address.

P= separated character

Text	Result -1	Result -2
abpcdefg	abp	abp
abcdpefg	abc	abcdp
abcpdefg	abc	abcp
abcpdefg	abc	abcp
abcdefpg	abc	abcdefp
apbcdefg	apb	ap

how to get free ride in jugnoo

2016-01-24T21:45:00.001-08:00

jugnoo promo code for first ride

jugnoo free ride code

To get free ride Jugnoo promo code you have flow to following the below steps:-

Download Jugnoo app from Google play store

After Downloading open the app and sign up using your details

During the SINUP Please Fill l the code RAJEEV431176

Now you have successfully Get RS 100 OR 50 for Free Ride in Jugnoo.

jugnoo free ride coupon,

coupon code for jugnoo

Thanks

how to add formula in text in excel

2014-06-02T23:54:00.000-07:00

how to add formula in text in excel

in column E ="Column B+C= " &B1+C1& " result"

type text in invert er comma and and formula in & symbol

vlookup in excel 2007 with example in excel

2013-10-30T05:03:00.001-07:00

FORMULA :-

VLOOKUP(Which Value You Want To Search, Where You Want Search value, Table Index Which Value You Want To Display, FALSE/TRUE)

=VLOOKUP(D8,A2:B7,2,FALSE)

excel group by count distinct

2013-10-30T04:08:00.003-07:00

formula :-

in C2

=IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1)

excel 2007 count unique values multiple criteria

compare two columns in excel for differences 2007

2013-10-26T01:02:00.001-07:00

compare two columns in excel for differences 2007

comparing two columns in excel

=IF(A1=B1,"MATCH","NOT MATCH")

updating two tables in a single query in mysql

2012-12-20T22:50:00.005-08:00

updating two tables in a single query in mysql

UPDATE tb1 , tb2 SET tb1.name= 'new name', tb2.name = 'tb2 name' WHERE tb1.id = '1' AND tb2.id = '5'

delete data from two tables at the same time in mysql

2012-12-20T22:26:00.000-08:00

delete record from two table in same time in mysql

it is useful when we create two related table in mysql

// with inner join

DELETE tb1, tb2 FROM tb1 inner JOIN tb2 WHERE tb1.id=tb2.tb1id and tb1.id=1

// with left or Right Join

DELETE tb1, tb2 FROM tb1 LEFT JOIN tb2 ON tb1.id=tb2.tb1id WHERE tb1.id=1

php call function within same class

2012-12-01T00:00:00.002-08:00


<?php

class a{

public function f1(){

echo 'this is a:f1 function';  

}

 

 function f3(){

 a::f1(); // call here same class method
 echo '<br>Call here f1 function ';

 }

}



class b{



function f2(){

a::f3();

echo '<br> This is b:f2 function';

}



}


$ob= new b();

$ob->f2();




?>
OutPut:

this is a:f1 function

Call here f1 function 

This is b:f2 function

how to call one class method from another in php

2012-11-30T23:58:00.002-08:00


<?php


class a{
public function f1(){

echo 'this is a:f1 function';  

}

 

}



class b{



function f2(){

a::f1(); // claa here method of another class in php

 
echo '<br> This is b:f2 function';

}



}


$ob= new b();

$ob->f2();

?>

OutPut:

this is a:f1 function

This is b:f2 function

group_concat in mysql example

2012-11-29T01:05:00.002-08:00

group_concat in mysql example

CITY_ID	CITY_NAME	STATE_NAME
1	Bhopal	MP
2	Indore	MP
3	Delhi	DELHI
4	Allahabad	UP

SELECT group_concat(concat(`city_id`,'@@', `city_name`,'@@', `state_name`),'###') as city FROM `city`

Result

1@@Bhopal@@MP###,2@@Indore@@MP###,3@@Delhi@@DELHI###,4@@Allahabad@@UP###

date between two date in php

2012-11-28T04:50:00.002-08:00


<?php

 
// check datebetween two dates 


function chkbetweendate($chkdate='',$startdate='',$enddate=''){

$chkdate=strtotime($chkdate);
$startdate=strtotime($startdate);
$enddate=strtotime($enddate);


if($startdate <= $chkdate && $chkdate <= $enddate){

return true;

}else {

return false;

}

}

 

 

 

 // call function here 

 

 if(chkbetweendate('2012-10-10','2012-10-5','2012-10-15')){

 echo "2012-10-10 between date";

 } else {

 echo "2012-10-10 not in between date";

 }

Create Query for all table in mysql

2012-11-06T23:45:00.000-08:00

1. create query for change all tables to innodb ENGINE in mysql

SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') as ExecuteTheseSQLCommands
FROM information_schema.tables WHERE table_schema = 'database_name'
ORDER BY table_name DESC;

2. create query for TRUNCATE TABLE all database table

SELECT CONCAT('TRUNCATE TABLE ', table_name, ';')
FROM INFORMATION_SCHEMA.tables
WHERE table_schema = 'database_name'

export in mysql

2012-11-06T02:46:00.001-08:00

1. export in mysql in txt file

SELECT * FROM MyTable INTO OUTFILE 'C:\\FileName.txt'

2. export in mysql in csv file

SELECT * FROM table1 INTO OUTFILE 'c:///mytable.csv' FIELDS ESCAPED BY '""' TERMINATED

BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'

3. . export in mysql in excel file

php multidimensional array to single dimension array

2012-11-05T22:56:00.000-08:00


<?php

php convert multidimensional array to single dimension array

convert multidimensional array to single array php



function multidimensional_array_to_single_dimension_array($array) { 

   if (!$array) return false;

   $flat = array();

   $iterator  = new RecursiveIteratorIterator(new RecursiveArrayIterator($array));

  

   foreach ($iterator as $value) $singhal[] = $value;

   return $singhal;

}


$arr=array(1,2,array(4,5),6,array(7,8,array(9,10,11,array(12,13,14))));



 

 print_r(multidimensional_array_to_single_dimension_array($arr));
?>

OUTPUT:

Array ( [0] => 1 [1] => 2 [2] => 4 [3] => 5 [4] => 6 [5] => 7 [6] => 8 [7] => 9 [8] => 10 [9] => 11 [10] => 12 [11] => 13 [12] => 14 )

Regular Expression

2012-11-03T06:22:00.003-07:00

Regular Expression in JavaScript

Regular Expression in php

Regular Expression in MySql

transaction in mysql php

2012-10-31T05:45:00.001-07:00


<?php

MYISAM Not Support Transaction

/*

CREATE TABLE IF NOT EXISTS `table1` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(250) NOT NULL,

  `address` varchar(250) NOT NULL,

  PRIMARY KEY  (`id`)

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

*/

$host = 'localhost';
$user = 'rajeev';
$password = 'mypass';
$db = 'demo';



$con = mysql_connect($host, $user, $password);

mysql_select_db( $db);

mysql_query("SET AUTOCOMMIT=0");

mysql_query("START TRANSACTION");  


 $query = "INSERT INTO table1 (name,address) values ('name','bhopal')";

 $result = mysql_query($query);

if($result){

 mysql_query("COMMIT");

 }  else {

 mysql_query("ROLLBACK");

 }

 

 


mysql_close();

?>

Create New User In Mysql with permission

2012-10-27T00:31:00.000-07:00

create new user in mysql database
set user permissions mysql
delete user permissions in mysql

rajeev=User Name
mypass= Password
demo= database name

// create user
CREATE USER 'rajeev'@'localhost' IDENTIFIED BY 'mypass' ;

// set permission in demo database
GRANT SELECT, INSERT, DELETE ON demo.* TO rajeev@'localhost' IDENTIFIED BY 'mypass';

// set all permission in demo database
GRANT ALL ON demo.* to 'rajeev'@'localhost';

// remove access permission from demo database
REVOKE select, UPDATE, DELETE ON demo.* FROM 'rajeev'@'localhost';

// remove all permission
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'rajeev'@'localhost';

// select user detail from database
select * from mysql.user where User='rajeev';

Email Validation In PHP

2012-10-26T02:52:00.001-07:00

Email address Validation in PHP


<form> Email Address: <input type='text' name='email'> <input type='submit' value='Submit'> </form>

 

<?php

 $email=$_REQUEST['email'];


 $expression = "^[a-z0-9_\+-]+(\.[a-z0-9_\+-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.([a-z]{2,4})$";


 if (eregi($expression, $email)) {

 echo 'Valid Email';


 } else {


 echo 'Invalid Email';

 }

 ?>

tooltip jquery example

2012-10-17T21:42:00.000-07:00

tooltips jquery example

tooltips jquery Demo

user already exits

2012-10-02T00:14:00.001-07:00

This Code Is use for User name Already Exits or email id already exits

here this function call using Ajax Method


<?php



function ckhuserid($udetail){

$arr=explode("!@@@!",$udetail);


if($arr[1]=='edit'){

$val=executescalar("user","id","uname='".$arr[0]."' and id<>'".$arr[2]."' ", "","false","str");


} else {

$val=executescalar("user","id","uname='".$arr[0]."'", "","false","str");

 }

if($val!=''){ // alresdy exist 

 echo "yes";

}

}

?>

// JavaScript Code



<script>

            

function ckhuserid(x,cas,id){ // x=this; cas= case=registration or edit profile , id=user id on edit time 

uname=$(x).val();

str=uname;

if(cas=='edit'){

str=uname+"!@@@!edit!@@@!"+id;

}

$.ajax({

  type: 'POST',

  url: "admin/Ajax/functions.php?f=ckhuserid&p="+str,

  data: {},

  success: function(data12){ 

 // alert(data12);

  if(data12=='yes'){

      alert("user name already exist"); $(x).focus(); return false ;

  }   

   

  }});

    return true ;

}

</script>




// calling method 



<input type="text" onblur="return ckhuserid(this,0,0)"  /> // add time



<input type="text" onblur="return ckhuserid(this,'edit',id)"  /> // edit  time

Email Validation For Group Mail

2012-09-22T00:30:00.003-07:00

Email Address:

Example: Email1, Email2, Email3 etc

function ckhmailaddress(){

var emailPattern = /^[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$/;
var allemail = $('#txtemail').val() ;
var email = allemail.split(",");
for(i=0 ; i< email.length ; i++){
if(emailPattern.test(email[i])==false){
alert('please Enter Valid Email Id');
document.getElementById('txtemail').focus();
return false ;
}
}

return true ;
}

contact us page

2012-08-26T22:22:00.003-07:00




For Me  



<?php 
/***************** PHP Code **********************/

require_once('config/bootstrap.php');


if(isset($_POST) && ($_REQUEST["mode"]=='send')){

$name = strip($_POST['txtname']);
$email = strip($_POST['txtemail']);
$ph = strip($_POST['txtphone']);
$msg = strip($_POST['txtcomment']);

$headers = "From: ".$email."\r\n";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= "\r\nX-Mailer: PHP/" . phpversion();
$subject = "contact us: nethomes.com";

$message = "Name: " . $name ."<br> Phone No: " . $ph. "<br/>Email Id:".$email . "<br/>Message Details : " . $msg  ;

$to = "bit7bpl@gmail.com"; // "arteriors51@yahoo.com";

if(mail($to, $subject , $message ,$headers)){

redirect("projectprofile.php"," Thank you for sending your valueable feedback/ query. We will get back to you as soon as possible. ");

 }

else {
redirect("projectprofile.php"," Please Try Again  ");

 }

}

/****************   End Mail *************/
?>




/***************** JavaScript Validation ****************************/

<script>



function formvalidation(){


if(document.getElementById('txtname').value==''){

alert('Please enter name');document.getElementById('txtname').focus(); return false ;  }

if(document.getElementById('txtemail').value==''){

alert('Please enter Email id');document.getElementById('txtemail').focus(); return false ;  }

if(document.getElementById('txtemail').value!=''){

var emailPattern = /^[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$/;

email = document.getElementById('txtemail').value ;

if(emailPattern.test(email)==false){

alert('please Enter Valid Email Id');

document.getElementById('txtemail').focus();

return false ;

 }

    }    

if(document.getElementById('txtphone').value==''){

alert('Please enter Phone no');document.getElementById('txtphone').focus(); return false ;  }

if(document.getElementById('txtcomment').value==''){

alert('Please enter message');document.getElementById('txtcomment').focus(); return false ;  }

}    

</script>




/******************* HTML Code  **********************************/



<form  action="projectprofile.php?mode=send" method="post" enctype="multipart/form-data" name="form1" id="form1">

 <table width="364" height="237" align="left" cellpadding="0" cellspacing="2">

<tr>

  <td width="29%" align="left"><p>Name </p></td>

  <td width="3%"><p>:<span class="preeti">:</span></p></td>

  <td width="68%"><label>

  <input name="txtname" type="text" id="txtname"  />

   </label></td>

   </tr>

   <tr>

  <td align="left"><p class="white">Email ID </p></td>

   <td><p>:<span class="preeti">:</span></p></td>

   <td><label>

    <input name="txtemail" type="text" id="txtemail" />

       </label></td>

    </tr>

    <tr>

 <td align="left"><p><span class="white">Tel. No. </span></p></td>

   <td width="3%"><p>:<span class="preeti">:</span></p></td>

  <td><input name="txtphone" type="text" id="txtphone"  maxlength="12" onkeypress="isnumberkey(event);" /></td>

   </tr>

  <tr>

 <td align="left"><p><span class="white">your message

 </span></p></td>

   <td><p>:<span class="preeti">:</span></p></td>

  <td><textarea name="txtcomment" cols="28" rows="4" id="txtcomment" ></textarea></td>

  </tr>

    <tr>

  <td height="26">&nbsp;</td>

    <td>&nbsp;</td>

 <td><input name="Send" type="submit" value="   Send    " onclick="return formvalidation();" class="butt"></td>

  </tr>

  </table>

  </form>

add data without html editor

2012-08-25T00:07:00.003-07:00

str_replace(' ',' ',strip_tags($_POST["txtcomment"]))