Easiest way to learn various technology: 2019

9/29/2019

How to get More Views on Youtube & earn money

How To Make Youtube Video

1) first open youtube.com ,upload make video, while upload ensure all the point cover.

2)Remember title, thumbnail, description, tag for making final upload. ensure title neat and in one language, thumbnail indicate what exact video is.
description should add all detail, download link, hashtags . ensure all keyword should involved in description .
3) tag - one to three words make one tag , do not add irrelevant, same tag, only add relevant and specific maximum 10 keywords.
4) also add keyword to channel.
5) ensure channel name proper & neat.
6) be clear with what exact video.
7) How to Monetize : - you can earn lot by showing ads on your video. but 1000 subscriber and 4000 hr watch time then only ads can start on your video. remember quality matters.
8) be regular upload video.
9) try to add translation - in one language so that more viewer get.
10) remember with youtube video should simple, clear with concept.
11) you can also make new channel with one single gmail account , for this you have to create brand account.
12) youtube also provide creator studio and beta studio . in this you can edit your video.
13) video should properly categarized and your own video.

4/07/2019

Disable a div on selecting an option from a drop down menu in HTML

1. make simple dropdown menu
<select id="selelctme">
<option>AABC</option>
<option>BDIV</option>
<option>CDFG</option>
</select>

2. add script
<script>
$(document).ready(function(){
$('#selectme').change(function(){
if($(this:selected).val()=='BDIV')
{
$('.BDIV').attr('disabled','true');
}
else
{
}

});

});

</script>

in above simplly use change function this also can be add using javascript onchange function.

Print with preview window using javascript

print preview area using simple jquery.

no need any extra api or script .

just use below code to print form or DIV part

$('#printA').click(function(){  
 
    var content = document.getElementById('printcontent').innerHTML; 
  var mywindow = window.open('', 'Print', 'height=600,width=800');
    mywindow.document.write('<html><head><title>Print Content</title>');
    mywindow.document.write('</head><body >');
    mywindow.document.write(content);
    mywindow.document.write('</body></html>');
    mywindow.document.close();
    mywindow.focus();
    mywindow.print();
    mywindow.close();
    
    return true;
 
});

to use above code do simple steps.

1. ensure jquery.min.js is use or simple use above to javascript

2. print button

3. onclick of this button above code will paste

4. simplly open print window

5. suppose after filling form or displaying data print function is needed then use above print function

2/24/2019

SQL INJECTION

SQL INJECTION is user(hacker or attacker) get information or all data or simplly delete all data

$a = "SELECT * FROM users WHERE name = '" + USERID + "';"
This SQL code is designed to pull up the records of the specified username from its table of users. However, if the "USERID" variable is assign some value by malicious user, the SQL statement may get all data . For example,

' OR '1'='1 use this in $a above statement

above you can write like this

' OR '1'='1' --
' OR '1'='1' {
' OR '1'='1' /*
if hacker use this as below

SELECT * FROM users WHERE name = '' OR '1'='1';
SELECT * FROM users WHERE name = '' OR '1'='1' -- ';

from above get all information instead of checking to specific id
This input renders the final SQL statement as follows and specified:

SELECT * FROM users WHERE name = 'a';DROP TABLE users; SELECT * FROM userinfo WHERE 't' = 't';

suppose above example will simply & delete from table.

MYSQL SELECT UPDATE QUERY & php connect

1) MYSQL Select : - is query use for getting data from mysql database.
eg: select * FROM abc;

above statement get all value from table

using where statement :


select nam, addre from abc where nam ='mayur abc'

above statement use and, or case for conditional statement writing.

select using when statement


SELECT `nam`, `addre`, `mobile`, `city` FROM `abc` WHERE nam  IN ('mayur','mayur kumar')

similarly use update

use update statement

to update one column multiple row use when statement

PHP CONNECT & INSERT

let us see below example : -
<?php
$con = mysqli_connect('$host','$id','$pass','$database');

if(!$con)
{
echo 'NOT connected';
}
else
{
$q ='insert into abc ('name','address')values('$name','$useaddress')';
$comnd = mysqli_query($con,$q);
if($comnd)
{
echo 'Data sucessfully inserted';
}

}
?>

Easiest way to learn various technology

abc