Technical Details and PHP Developer

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 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

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 in column E ="Column B+C= "  &B1+C1&  " result" type text in invert er  comma and  and formula in  & symbol 

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)

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 comparing two columns in excel  =IF(A1=B1,"MATCH","NOT MATCH") 

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 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  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

<?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 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###

<?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" ;  }

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'

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  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] =...

Regular Expression in JavaScript Regular Expression in php Regular Expression in MySql 

<?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 ){ ...

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 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' ;  }   ?>