Create a custom page template in wordpress

we have a sidebar on all of pages in wordpress website, but we want to have a page that doesn’t have a sidebar. Here is how we create a custom page template without a sidebar in wordpress:

1)   Create a new file in wordpress theme folder and name it withoutSidebar.php.

2)   Open page.php and copy all of the code and paste it into the newly created withoutSidebar.php.

3)   Make any changes that you would like to withoutSidebar.php. In this example we are going to remove the sidebar, so find the code that calls the sidebar (<?php include(‘sidebar.php’); ?>) and remove it.

4)   You may also want to find the div that contains the main container and add a width style to make it cover the whole page.

5)   Finally, and most importantly, add the following line of code to the top of the page. This code is used to tell WordPress that this is a custom template. Without this code, WordPress would not be able to find the template:


<?php
    /*
   Template Name: without Sidebar
   */
 ?>

6)     Save this file and upload it to your server.

Difference between Primary Key and Unique key in mysql?

Difference between Primary Key and Unique key in mysql/sql/oracle?

SNO	Primary Key	Unique Key
1	Primary Key does not allow NULLs values in a table	Unique Key allows Nulls value in a table
2	Only one primary key will be there in a table	More than one unique key will be there in a table
3	Clustered index is created in primary key in a table	Non-Clustered index is created in unique key in a table
4	Primary key allows each row in a table to be uniquely identified and ensures that no duplicate rows exist as well as does not allow the duplicates values in the rows of a table.	Unique key constraint is used to prevent the duplication of key values within the rows of a table and allow null values

By default Primary Key creates a Clustered Index on the column as same as Unique Key creates a Nonclustered Index. Another major difference is Primary Key doesn’t allow NULLs, but Unique Key allows NULLs. We can create only one primary key in a table, but a table can have the multiple unique key.

Update query in mysql

The syntax for Update the row into tables,

UPDATE
    table_name SET (colname1, colname2, colname3 ...) VALUES (value1,value2,value3,...) WHERE colname = row_values;   

<?php

$con = mysql_connect('localhost', 'root','');
mysql_select_db('dbname', $con) or die(mysql_error());

$query = "UPDATE table_name SET rank="2" WHERE sno = 2";   
$ok = mysql_query($query);

if($ok)
echo "Updated row successfully";
else
echo "Failed to update the row in the table";

?>

sno	name	marks	rank	post_of_date
2	krishnan	397	2	09-04-2001
3	PHP Developer	521	36	27-03-2012

Delete query in mysql with php

The syntax for Delete the row into tables,

DELETE FROM
    table_name WHERE colname = row_values;    

<?php

$con = mysql_connect('localhost', 'root','');
mysql_select_db('dbname', $con) or die(mysql_error());

$query = "DELETE FROM table_name WHERE sno = 1";    
$ok = mysql_query($query);

if($ok)
echo "Deleted row successfully";
else
echo "Failed to delete the row in the table";

?>

sno	name	marks	rank	post_of_date
2	krishnan	397	3	09-04-2001
3	PHP Developer	521	36	27-03-2012

Insert query in mysql with php

The syntax for inserting values into tables,

INSERT INTO
    table_name (`col1`, `col2`, `col3`,.....)
    VALUES ('val1', 'val2', 'val3',.....);    

<?php

$con = mysql_connect('localhost', 'root','');
mysql_select_db('dbname', $con) or die(mysql_error());

$query = "INSERT INTO table_name (`sno`, `name`, `marks`, `rank`,`post_of_date`) VALUES ('3', 'PHP Developer', '521', '36',now())";    
$ok = mysql_query($query);

if($ok)
echo "Inserted successfully";
else
echo "Data's are not inserted in to table";

?>

sno	name	marks	rank	post_of_date
1	Ram	407	3	09-04-2001
2	krishnan	397	3	09-04-2001
3	PHP Developer	521	36	27-03-2012

Show the content or text when mouse over the link

<style type="text/css">
<!--
.box {
background-color: #F4F4F4;
border: 1px solid #CCC;
height: 150px;
width: 225px;
padding: 5px;
display:none;
position:absolute;
}


-->
</style>
<script type="text/javascript" language="JavaScript">
var cX = 0; var cY = 0; var rX = 0; var rY = 0;
function UpdateCursorPosition(e){ cX = e.pageX; cY = e.pageY;}
function UpdateCursorPositionDocAll(e){ cX = event.clientX; cY = event.clientY;}
if(document.all) { document.onmousemove = UpdateCursorPositionDocAll; }
else { document.onmousemove = UpdateCursorPosition; }
function AssignPosition(d) {
if(self.pageYOffset) {
rX = self.pageXOffset;
rY = self.pageYOffset;
}
else if(document.documentElement && document.documentElement.scrollTop) {
rX = document.documentElement.scrollLeft;
rY = document.documentElement.scrollTop;
}
else if(document.body) {
rX = document.body.scrollLeft;
rY = document.body.scrollTop;
}

How to delete checked checkbox rows in php?

<?php
if($_REQUEST['btndelete'] != '')
{
    if(!empty($_REQUEST['checkboxstatus'])) {
        $checked_values = $_REQUEST['checkboxstatus'];
        foreach($checked_values as $val) {
            $sqldel = "delete from subscribe where id = '$val'";
            $resdel = mysql_query($sqldel);
            if($resdel)
                $error_log = 1;
            else
                $error_log = 2;
        }
    }
}