Search This Blog

php interview

gender status change mysql query 0 to 1 or 1 to 0 female to male/ male to female

Get link
Facebook
X
Pinterest
Email
Other Apps

May 05, 2019

UPDATE gender_change SET name = CASE WHEN name= "Male" then "Female" ELSE "Male" END

change status to 0 to 1 or 1 to 0

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

ARRAY

May 09, 2019

array() Creates an array array_change_key_case() Changes all keys in an array to lowercase or uppercase array_chunk() Splits an array into chunks of arrays array_column() Returns the values from a single column in the input array array_combine() Creates an array by using the elements from one "keys" array and one "values" array array_count_values() Counts all the values of an array array_diff() Compare arrays, and returns the differences (compare values only) array_diff_assoc() Compare arrays, and returns the differences (compare keys and values) array_diff_key() Compare arrays, and returns the differences (compare keys only) array_diff_uassoc() Compare arrays, and returns the differences (compare keys and values, using a user-defined key comparison function) array_diff_ukey() Compare arrays, and returns the differences (compare keys only, using a user-defined key comparison function) array_fill() Fills an array with values array_fill_keys() Fills an a...

generating random numbers in input box on button click javascript

June 02, 2019

<input type='text' id=" randid " name="some" value='15' /> <br/><br/> <button id=" xx ">Get new number</button> var input = document.querySelector('# randid '), btn = document.querySelector('# xx '); btn.addEventListener('click', function() { var MIN = 10000, MAX = 99999999; input.value = Math.floor(Math.random() * (MAX - MIN + 1)) + MIN; });