PHP TUTORIALS FOR WEB DEVELOPERS - PHP ROCKERS

Display the custom file in cms block to frontend/backend in Magento

2012-08-08T02:35:00.000-07:00

Below coding can be used to show CMS block in Frontend.

Ref. Path : app/design/frontend/base/default/template/callouts/left_col.phtml or right_col.phtml.

<?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('block_id')->toHtml(); ?>

Setting in Backend:

First Go to CMS and create a static page. Here we take "identifier" id from static block and put this id to above coding inside setBlock_id. And inside content we have put following line for calling our own block coding file,

{{block type="core/template" name="leftnav_menu" template="menu/menu.phtml"}}

Finally we have saved the file and this file is running in frontend inside the block.

Database connection in Joomla 2.5

2012-07-30T03:14:00.000-07:00

We have easy to connect database in joomla 2.5. Using below function

we have to connect database wherever you want in joomla folder.

$db =& JFactory::getDBO();

What is MVC in Joomla?

2012-06-20T05:12:00.000-07:00

MVC - Model-View-Component

“MVC consists of three kinds of objects. The Model is the application object, the View isits screen presentation, and the Controller defines the way that the user interface reacts tothe user input.

Create a custom page template in wordpress

2012-05-30T10:45:00.002-07:00

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?

2012-03-28T06:24:00.002-07:00

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

2012-03-27T02:44:00.000-07:00

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

2012-03-27T02:37:00.000-07:00

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

2012-03-27T02:22:00.002-07:00

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

2012-03-26T06:34:00.000-07:00

How to delete checked checkbox rows in php?

2012-03-21T07:39:00.002-07:00

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

$openingcountry = $_REQUEST['openingcountry'];
if($_REQUEST['status'] != '') {
    $status = $_REQUEST['status'];
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<body>
<form name="frmcountry" method="post" action="">
<table align="center" cellpadding="0" cellspacing="0" border="0" width="100%">
    <tr>
        <td>
        <input type="submit" name="btndelete" value="DELETE" class="openlistdelete" onClick="javascript: return confirm('Are you sure you want to delete!')" />
        <div style="color:#FF0000;">
        <?php
                if($error_log == 2)
                    echo "Selected email id is not deleted";
                if($error_log == 1)
                    echo "Deleted successfully";

            ?>
        </div>
               </td>
        </tr>
    <tr>
            <td class="openingtitletxt">S.No. </td>
            <td class="openingtitletxt">Email </td>

        <td class="openingtitletxt">Country </td>
            <td class="openingtitletxt">Statu </td>
        <td class="openingtitletxt">Edit Status </td>
        </tr>
        <?
    $rest = '';

    if($openingcountry != "") {
        $rest .= "where country = '$openingcountry'";
    }
    if($status!='') {
        if($openingcountry != "")
        $rest.= " and status = '$status'";
        else
        $rest.= "where status = '$status'";
    }
        $sqlselopenings = "select * from subscribe ".$rest ."ORDER BY id desc";
    $resselopenings = mysql_query($sqlselopenings);
    if($resselopenings) {
        $numrowsopenings = mysql_num_rows($resselopenings);
    }

    if($numrowsopenings > 0) {
        $i = 1;
        while($rowselopenings = mysql_fetch_array($resselopenings)) {
                ?>
                <tr>
                        <td class="openingtitledetails"> <? echo $i;?></td>
                        <td class="openingtitledetails"><? echo $rowselopenings['email'];?></td>
            <td class="openingtitledetails">
                <?if($rowselopenings['country'] == 'uk')
                    echo $rowselopenings['country'] = 'UK';
                    else if($rowselopenings['country'] == 'us')
                    echo $rowselopenings['country'] = 'US';
                    else
                    echo $rowselopenings['country'] = ucfirst($rowselopenings['country']);?>
                        </td>
                        <td class="openingtitledetails">
                        <?
                if($rowselopenings['status'] == 1) {
                    echo 'Active';
                } else {
                    echo 'Inactive';
                }
            ?>
            </td>
            <td class="openingtitledetails">
            <input type="checkbox" name="checkboxstatus[<?php echo $i; ?>]" id="checkboxstatus-<?php echo $rowselopenings['id']; ?>" value="<?php echo $rowselopenings['id']; ?>" />
            </td>
        </tr>
                <? $i++;
        }
    } else { ?>
        <tr>
            <td colspan="5" align="center" class="errortxt"> No Records Found! </td>
        </tr>
        <? } ?>
</table>
</form>
</body>
</html>

How to send the email in php?

2012-03-08T02:50:00.000-08:00

Easily send the email in php, you have to follow some steps
<?php
   $mail_to = "phprockers.blogspot@gmail.com";
   $mail_subject = "Introducing New concept in PHP";
   $body_content = "Hi <br/> We are introducing new method in php as well as we are teaching php clearly. Please click here and watch <a href='http://phprockers.blogspot.in/'>php tutorial</a>";
   if(mail($mail_to, $mail_subject, $body_content)){
       echo "Email sent successfully";
   } else {
       echo "Email sending problem. Please try again.";
   }
?>

How to send the email with attachment in php?

2012-03-08T02:31:00.001-08:00

Very simple to send the email with attachment with php validation.

First we have to write html form for upload the attchement.

<form name="uploadRes" enctype="multipart/form-data" method="post" action="<?php echo $_SERVER['PHP_SELF'];" >
<input type="file" name="resume" id="resume" />
<input type="submit" name="res-submit" id="res-submit" value="Send Resume" />
</form>

Validation for attaching the file. Here we have to find the file type, then send the email to particular function.

if($_REQUEST['res-submit'] != '') {
    if(!empty($_FILES)) {
        function getExt($file) {
            $dot = strrpos($file, '.') + 1;
            return substr($file, $dot);
        }

        $resume = $_FILES['resume']['name'];
        if($resume != '')
            $resume = $resume;
        else
            $resume = 'Not Uploaded!';

        $extension = getExt($resume);

        if( $resume== 'Not Uploaded!')
            $error_flag = 1;
        else {
            if($extension != 'doc' || $extension != 'docx' || $extension != 'pdf' || $extension != 'odt' || $extension != 'txt') {
                $to = 'php.com';
                $from    = "candidate@dckap.com";
                $subject = 'Resume from candidate';

                $fileatt      = $_FILES['resume']['tmp_name'];
                $fileatt_type = $_FILES['resume']['type'];
                $fileatt_name = $_FILES['resume']['name'];
                $fileatt_size = $_FILES['resume']['size'];
                if($fileatt_size < 300000) {
                    $headers = "From: $from";
                    $message="<p> Hi, <br/><br/>Please find the attached resume. </p>";
                    $email_message .= $message;
                    $semi_rand = md5(time());
                    $mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
                    $headers .= "\nMIME-Version: 1.0\n" .
                    "Content-Type: multipart/mixed;\n" .
                    " boundary=\"{$mime_boundary}\"";

                    $email_message .= "This is a multi-part message in MIME format.\n\n" .
                    "--{$mime_boundary}\n" .
                    "Content-Type:text/html; charset=\"iso-8859-1\"\n" .
                    "Content-Transfer-Encoding: 7bit\n\n" .
                    $email_message .= "\n\n";

                    $data = chunk_split(base64_encode(file_get_contents($fileatt)));
                    $email_message .= "--{$mime_boundary}\n" .
                    "Content-Type: {$fileatt_type};\n" .
                    " name=\"{$fileatt_name}\"\n" .
                    //"Content-Disposition: attachment;\n" .
                    //" filename=\"{$fileatt_name}\"\n" .
                    "Content-Transfer-Encoding: base64\n\n" .
                    $data .= "\n\n" .
                    "--{$mime_boundary}--\n";
                    $ok = mail($to, $subject, $email_message, $headers); // Mail sending to the requested Email Id
                } else {

                    $error_flag_filesize = 3;
                }

            } else {
                $error_flag = 2;
            }
        }
    }
}
?>

Here we are showing the validation errors.

<?php if(!empty($_FILES)) { if($error_flag == 1) { ?>
<div id="result-resume" name="result-resume" >
<span style="color:red; margin-left:-245px;">please upload the file</span>
</div>
<?php } elseif ($error_flag == 2) { ?>
<div id="result-resume" name="result-resume" >
<span style="color:red; margin-left:-245px;">Please Upload Valid file Extension!</span>
</div>
<?php } elseif ($error_flag_filesize == 3) { ?>
<div id="result-resume" name="result-resume" >
<span style="color:red; margin-left:-245px;">Please upload the file less than 3MB</span>
</div>
<?php } else { ?>
<div id="result-resume" name="result-resume" >
<span style="color:red; margin-left:-245px;">Sent the resume successful</span>
</div>
<?php }?>
<script>hideResult=document.getElementById("result-resume");
setTimeout('hideResult.innerHTML=\'\'',7000); </script>
<?php }?>

How to integrate "xing" share button in your site?

2012-02-21T02:23:00.000-08:00

Steps:

1.Select The button layout as you want display in your site.

2.Provide the Url for which you are going to display the xing share count.(This is optional)

3.Select the language.

4.Copy the code in the textarea and paste it in your page.

Thats it. The All new Xing share button will be displayed in your site.

How to get the post tags by category name in wordpress?

2012-02-20T03:44:00.000-08:00

Paste this code wherever you want to get post tags for specific category name in wordpress.

<?php

$cat_name = "Test Cat";
query_posts('category_name='.$cat_name); //give the your category name here.

if (have_posts()) : while (have_posts()) : the_post();
$postTags = get_the_tags();
    if ($postTags) {
        foreach($postTags as $tag) {
            $all_tags[] = $tag -> name;
        }
    }
endwhile; endif;

if(!empty($all_tags)) {
    $unique_tags = array_unique($all_tags); //Removes the duplicates tags in the all_tags_arr array.
    echo '<pre>'.print_r($unique_tags, true).'</pre>';
} else {
    echo "No post tags are available for ".$cat_name." - category";
}

?>

How to get the posts by post tags in wordpress

2012-02-17T07:47:00.000-08:00

We have easily get the post titles from from the post Id. So We have to try to get the post Id using the post tags.

<?php

global $wpdb;

$postTags = "Accidents";

//Below query can be used to get the post id using post tags.

$querystr ="SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id = (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'post_tag' AND term_id = (SELECT term_id FROM wp_terms WHERE name ='$postTags '))";

$result= $wpdb->get_results($querystr);

//$result have the post id. Now we easily get the post title or post information using post id.

foreach($result as $postid) {

echo get_the_title($postid->object_id).'<br/>';

}

?>

What is normalization?

2012-02-15T03:07:00.000-08:00

Normalisation is a set of rules and techniques concerned with below:

    1. Identifying relationships among the attributes.
    2. Combining the attributes to form relations.
    3. Combining the relations to form a database.

Normalised relational database gives several benefits to us:

    1. Elimination of redundant data storage in the database.
    2. Close modeling of real world entities, processes, and their relationships.
    3. Structuring of data so that the model is flexible.

Strip tags in PHP

2012-02-14T02:25:00.000-08:00

strip_tags() function will return the string with stripped(removed) HTML and PHP tags.

<?php

$string = '<h2>This is PHP Rokcers blogspot.</h2> <a href="http://phprockers.blogspot.com/">phprockers</a>';

echo strip_tags($string);

?>

Output:
=======
This is PHP Rokcers blogspot. phprockers

If we want to allow some specific tags in our string, we have to given that tags as parameters in strip_tags function.

<?php

$string = '<h2>This is PHP Rokcers blogspot.</h2> <a href="http://phprockers.blogspot.com/">phprockers</a>';

echo strip_tags($string, '<h2><a>');

?>

Output:
=======
<h2>This is PHP Rokcers blogspot.</h2><a href="http://phprockers.blogspot.com/">phprockers</a>

Dynamic upload the multiple files in php with Javascript validation

2012-02-08T01:55:00.000-08:00

<?php
    $con = mysql_connection() or (mysql_error();
    mysql_db_select("phprockers", $con) or mysql_error();
?>
<html>
<script type="text/javascript" >
    function add_more() {
        var img = document.getElementById("image").value;
        img=parseInt(img)+1;
        var txt = "<br><input type = file name = images"+img+">";
        document.getElementById("image").value=img;
        document.getElementById("files").innerHTML += txt;
    }

    function validate(){
        var img = document.getElementById("image").value;
        img=parseInt(img);
        while(img > 0){
            var x=document.forms["myForm"]["images"+img].value
            if (x=="") {
            alert("please select file");
            return false;
            }
            img--;
        }
    }
</script>
<body>
    <form method="POST" name="myForm" action="" enctype="multipart/form-data" onSubmit="return validate();">
    <div id="files"> <input type="file" name='images1'/><br></div>
    <input type="hidden" value=1 id="image" name="image"/>
    <input type = "submit" name = "submit" value = "Submit" />
    <div style="cursor:pointer" onClick="add_more();">Attach File</div>
    </form>
    <?php
    if($_POST['submit']!="" ) {
        $upload_directory = 'upload/';
        for ($i = 1; $i <= $_REQUEST['image']; $i++) {
            $path=$_FILES['images'.$i]['name'];
            move_uploaded_file ($_FILES['images'.$i]['tmp_name'], $upload_directory . $_FILES['images'.$i]['name']);
            $query="INSERT INTO `browsefile`(`id`, `path`) VALUES (NULL,'$path')";
            mysql_query( $query );
        }
    }
    ?>
</body>
</html>

Multiple File uploads in PHP

2012-02-06T09:23:00.000-08:00

<?php
    $con = mysql_connection() or(mysql_error();

    mysql_db_select("phprockers", $con) or mysql_error();
?>
<form method="POST" action="" enctype="multipart/form-data">

    Images 1: <input type=file name='images1' ><br>
    Images 2: <input type=file name='images2' ><br>
    Images 3: <input type=file name='images3' ><br>
    <input type="submit" name="submit" value="Submit" />

</form>

<?php
    if($_POST['submit']!="" ) {
        $upload_directory = '/upload/';
        for ($i = 1; $i <= count($_FILES); $i++) {

            $path = $_FILES['images'.$i]['name'];
            move_uploaded_file($_FILES['images'.$i]['tmp_name'], $upload_directory . basename($_FILES['images'.$i]['name']));
            $query="INSERT INTO browsefile (id,path) values('$path')";
            mysql_query( $query );

        }
    }
?>

Important functions in Wordpres

2012-02-03T08:41:00.000-08:00

Wordpress Functions:

================

get_the_excerpt() - It can be used to get the post excerpt content in the current post.

get_post($post->ID) - It can be used to get the post details about current post. It has title,categoryid, category name, post status etc. Here post->ID is optional.

get_the_post_thumbnail($page->ID,array(150,200),'thumbnail') - It can be used for retrive the thumbnail image for the post.

the_title() - It can be used for retrive the title for current post.

get_the_title(ID) - It can be also used to get the title for the post.

get_cat_name( $cat_id ) - It can be used to get the category title for that category id.

get_post_type(ID) - get the post type for that post id.

get_the_author() - get the author name for current post.

get_categories() - get the all the categories in wp.

get_the_content() - It can be used for the get the content for current post.

Limitatin in MYSQL

2012-02-03T06:00:00.000-08:00

Table attribute names are eliminated after 31 characters in the database.

The maximum character of database and table is 122 characters in the mysql.

The maximum number of table in a mysql database is 1792.

The maximum number of database in mysql is 20320.

The maximum number of attributes (that is, columns and indexes) per table is 128 characters.

The maximum number of attributes per key is 32.

The maximum permitted size of one row in table is 8052 bytes.

Get the second highest salary from employee table in mysql

2012-02-01T07:50:00.000-08:00

We have get the second, third, fourth etc. hightest salary from the employee table very easily in mysql/sql.

Getting max highest salary:
===================

SELECT max(salary) as salary FROM employee;

Getting N th highest salary syntax:
========================

SELECT salary FROM employee as emp WHERE (n-1) = (SELECT count(*) FROM employee as emp2 WHERE emp2.salary > emp.salary)

Getting 2nd maximum salary:
=====================
Above syntax, subsitute n=2, then we have to get second max salary.

SELECT salary FROM employee as emp WHERE (2-1) = (SELECT count(*) FROM employee as emp2 WHERE emp2.salary > emp.salary)

(OR)

SELECT max(salary) as salary FROM employee WHERE salary < (SELECT max(salary) FROM employee)

(OR)

SELECT salary FROM employee ORDER BY salary DESC LIMIT 1,1

Getting First Three maximum salary:
=======================

SELECT salary FROM employee ORDER BY salary DESC LIMIT 0,3.

This is very useful for retriving the highest three maximum salary from the employee table.

mysql_escape_string in php

2012-01-31T05:11:00.001-08:00

This function escacpe the single quotes, double quotes and unwanted symbol from our passing strings.

Format :
========
mysql_escape_string(string_name);

Example:

======
$first_name = mysql_escape_string($first_name);

Keep in mind:
=============
mysql_escape_string() cann't escape the % and _.

List out all the mysql database name in php

2012-01-31T04:12:00.000-08:00

List out all the mysql database name using follwing php code.

<?php

    error_reporting(E_ALL);

    $connection = mysql_connect('localhost', 'root', '');

    $database_list = mysql_list_dbs($connection);

    $count = mysql_num_rows($database_list);

    for($i=0;$i<$count;$i++) {

        echo mysql_db_name($db_list, $i) . "<br/>";
    }

?>

How to get the mysql last inserted id using PHP?

2012-01-31T02:10:00.000-08:00

We have to easily get the last inserted id in mysql table using below code.

<?php

$connection = mysql_connect('localhost', 'MYSQL_USERNAME', 'MYSQL_PASSWORD') or mysql_error();

mysql_select_db('DATABASE_NAME', $connection) or mysql_error();

$query = "INSERT INTO emp_table (emp_id, emp_name, emp_qualification, emp_salary) VALUES ('SC70699', 'Ramakrishnan', 'MCA', '13186')";

mysql_query($query );

$last_insert_id = mysql_insert_id();

echo "Last insert id in employee table: ".$last_insert_id;

mysql_close($connection) ;