Baala

Monday, November 23, 2015

How to Reset table primary key in mysql

query:-

After delete all data

place this query and run

ALTER TABLE some_table AUTO_INCREMENT=1

Friday, November 7, 2014

Simple encryption and decryption using base64

<?php
$key = "bala";
$enc = base64_encode ($key);
$dec = base64_decode ($enc);
echo 'Encrypted : '.$enc.'<br>';
echo 'Decrypted : '.$dec.'<br>';
?>

output:-

Encrypted : YmFsYQ==
Decrypted : bala

Saturday, November 1, 2014

Simple ajax checkbox using jquery

index.php

if ($('.chkNumber:checked').length) {
var chkId = '';
$('.chkNumber:checked').each(function () {
chkId += $(this).val() + ",";
});
chkId = chkId.slice(0, -1);
//alert(chkId);

var datastring='chkId='+chkId;
//alert(datastring);

$.ajax({
type: "POST",
url: "delete.php",
data:datastring,
cache:false,
beforeSend: function()
{
$("#signup_status").html("please wait....");
},
success:function(response)
{
alert(response);
$("#signup_status").html(response)

}

});
}
else {
alert('Nothing Selected');
}

}
-------------------------------------------------------------------------------------------------------------------

checkbox code:-

<input name="checkbox[]" type="checkbox" class="chkNumber" />

--------------------------------------------------------------------------------------------------------------------
retrieve checkbox :-

$chkId=$_POST['chkId'];
$count=explode(',',$chkId);
for($i=0;$i<$count[$i];$i++)
{
$del_qry="delete from gunning_3001 where id='$count[$i]'";
$res=mysql_query($del_qry) or die('Delete query does not work');
if($res)
{
echo "Delete Records Successfully";

}
else
{
echo "No Records Deleted";

}

}
---------------------------------------------------------------------------------------------------------------------

Tuesday, September 2, 2014

How to find out wamp server username and password?

Go to this file in: WampFolder\apps\phpmyadmin[phpmyadmin version]\config.inc.php

Usually wamp is in your main hard drive folder C:\wamp\

You will see something like:

$cfg['Servers'][$i]['user'] = 'YOUR USER NAME IS HERE';
$cfg['Servers'][$i]['password'] = 'AND YOU PASSWORD IS HERE';

Friday, June 27, 2014

Simple page responsive code for static websites

code:-
<html>
<head>
<title>Responsive web design</title>
<style>
.container {
width:538px;
}

table{
background-color:#c6dcfe;
}

</style>
</head>
<body>
<div id="container">
<table border="1" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td><h1>Its Responsive web design</h1></td><br>
</tr>
<tr>
<td>
<p>The goal with responsive design is to have one site with various elements that will respond correctly on different sizes of devices. No need to make several versions of the site anymore.</p>

</td>
</tr>
<tr>
<img src="Eset-Nod32-3D-Robot-HD-Wallpapers-D.jpg" style="max-width:100%;height:auto;" />
</tr>
</table>
</div>
</body>
</html>

Friday, May 23, 2014

Disable right click in website(protect your content and image) using javascript

code:-

<script>
function disableRightClick(e)
{
var message = "Right click disabled";
if(!document.rightClickDisabled) // initialize
{
if(document.layers)
{
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown = disableRightClick;
}
else document.oncontextmenu = disableRightClick;
return document.rightClickDisabled = true;
}

if(document.layers || (document.getElementById && !document.all))
{
if (e.which==2||e.which==3)
{
alert(message);
return false;
}
}
else
{
alert(message);
return false;
}
}

disableRightClick();

</script>

Wednesday, April 9, 2014

memory_limit problem in opencart or anyother website

error:-

Fatal error: Allowed memory size of 138412032 bytes exhausted (tried to allocate 71 bytes) in /home/xxxxxxx/public_html/xxxxxxxxxxxx/vqmod/vqcache/vq2-system_engine_controller.php on line 79

simple solution:-

<?php ini_set('memory_limit', '-1'); ?>

write this code on config.php in first line.its unlimited.

Tuesday, April 8, 2014

simple way to Create two primary key in one table(composite key)

simple way to Create two primary key in one table(composite key)

but auto increment only one coulmn to assign.
code:-
ALTER TABLE provider DROP PRIMARY KEY, ADD PRIMARY KEY(person, place, thing);

Sunday, March 23, 2014

Click the checkbox to mark all checkbox using javascript and php

<script type="text/javascript">

    function checkAll(checkId){

        var inputs = document.getElementsByTagName("input");

        for (var i = 0; i < inputs.length; i++) { 

            if (inputs[i].type == "checkbox" && inputs[i].id == checkId) { 

                if(inputs[i].checked == true) {

                    inputs[i].checked = false ;

                } else if (inputs[i].checked == false ) {

                    inputs[i].checked = true ;

                }

            }  

        }  

    }

</script>

<table width="70%" border="1" cellspacing="0" cellpadding="1">

    <tr>

        <th align="left">

            <input type="checkbox" id="chk_new"  onclick="checkAll('chk');" >

        </th>

        <th align="left">Name</th>

        <th align="left">Mobile</th>

   </tr>

   <tr>

       <td><input type="checkbox" id="chk" value="1" name="chk[]"  ></td>

       <td>Rony David</td>

       <td>0765-999772</td>

   </tr>

   <tr>

       <td><input type="checkbox" id="chk"  value="2" name="chk[]" ></td>

       <td>Shown Mark</td>

       <td>0765-9990772</td>

   </tr>

</table>