How to apply alternate background color for rows of an HTML table using PHP Script

In some cases you may want to apply alternate background color for each row of an HTML table. Using a simple script you can solve the problem. You can just apply one color for every odd row and apply another color for every even row. Check whether current row is even or odd by using a rowcount variable and check the result of rowcount mod 2  (ie. rowcount % 2) is 0 or not and change the value of background color attribute accordingly.

If rowcount % 2 is 0 then it is a even row and apply one color for that, other wise it is odd row and apply another color.

  $bgcolor = "#ffffff";
   if ($i % 2 == 0)
              $bgcolor = "#ECD23F";

You can see the PHP implementation of the above problem here.

Reading data from an HTML table using JavaScript

This example demonstrates how data in an HTML table can be read using JavaScript which can further be used for submitting to a server side script.

In this example, we first get the reference of the table using  the function call

var table = document.getElementById('productlist'); 

Then loop through each row of the table.

Each time data read from a cell is added to a string separated by a delimiter ( here we used "," ).

Finally the data read is displayed by using alert() function.

Entire code of this example is given below:

How to upload a file using PHP script

In this article let us discuss how to upload a file to a web server using PHP script. It is implemented as a function in this example in upload.php file. To upload a file, you have to create an HTML form with a file input control by using the input tag like this: "<input type=file>". 

While creating the HTML form, enctype attribute of the form should have the value "multipart/form-data". So the form tag will be like this:

<form action="upload.php" method="post"  enctype="multipart/form-data">

HTML code to crate the form

<form action="upload.php" method="post" autocomplete="off" enctype="multipart/form-data">

        <table align="center" width="100%">

           

            <tr bgcolor="#ababee">

                <td colspan="2" align="center"><h2>Upload your file</h2></td>

            </tr>

            <tr>

                <td >Select file to upload</td>

                <td ><input type="file" name="file" id="file" style="left:0;">               

                </td>

            </tr>   

                          

           

            <tr>

                <td colspan="2">               

                <input type="submit" name="upload" value="Upload">

                </td>

            </tr>                

           

        </table>       

   </form>

Sample code for implementing "check availability option in registration form" using Ajax, PHP and MySQL

This example shows how you can include a ‘check availability’ option in a registration form using Ajax, PHP and MySQL. Using HTML input element, user enters the email id and submits to the server side PHP script ‘isavailable.php’ using Ajax. ‘isavailable.php’ script checks whether the email id is already available in the database table or not and returns the status as responseText.

checkavailability.php

This PHP file contains the form and the Ajax script to submit the email id to the server side PHP script (isavailable.php) and display the response on the page.

<!DOCTYPE html>

<html>

    <head>

        <title>Check Availability - Ajax, PHP and MySQL </title>

        <script>

        function checkavailability(){

        var xmlhttp;

        if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari

            xmlhttp=new XMLHttpRequest();

        }

        else {// code for IE6, IE5

            xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

        }

        xmlhttp.onreadystatechange=function() {

            if (xmlhttp.readyState==4 && xmlhttp.status==200) {

                document.getElementById("divInfo").innerHTML=xmlhttp.responseText;

            }

        }

        url = "isavailable.php";

        param = document.getElementById('txtemail').value;                       

        url = url + "?txtemail=" + param;

       

               

        xmlhttp.open("GET",url,true);

        xmlhttp.send();

    }

</script>

</head>

   

<body>

<form>

    <table align="center">

        <tr>

            <td colspan="2"><h2>Check Availability</h2></td>

        </tr>

        <tr>

        <td>Email</td>

        <td><input type="text" size="40" id="txtemail" name="txtemail"></td>

        </tr>

       

        <tr>

        <td></td>

        <td><input type="button" id="cmdcheck" name="cmdcheck" value="Check Availability" onclick="checkavailability()"></td>

        </tr>

       

        <tr>

            <td colspan="2"><div id="divInfo"></div></td>       

        </tr>

       

    </table>

</form>

</body>

</html>

isavailable.php

 This PHP file extracts the email id submitted to the server from $_REQUEST array and check whether this id is available in the table by using PHP mysql functions. The availability status is sends back to the requested page.

<?php

    $email = $_REQUEST['txtemail'];

    $dblink=mysql_connect("localhost","root","");

    mysql_select_db("dbcheckavailability", $dblink);

    $sql="SELECT * FROM tblmember WHERE email='" . $email . "';";

    $result=mysql_query($sql, $dblink);

    $responseText ="";

   

   

    if (mysql_num_rows($result)) {

        $responseText = "Sorry, <b>" . $email . "</b> is already in use!";

    }

    else {

        $responseText = "Congratulation, <b>" .  $email . "</b> is available!";

    }

  

    echo $responseText;

    mysql_close($dblink);  

?>

Table Structure

Thsis is the structure of the table that has to be created in MySQL for this example.

--

-- Database: `dbcheckavailability`

--

-- --------------------------------------------------------

--

-- Table structure for table `tblmember`

--

CREATE TABLE IF NOT EXISTS `tblmember` (

  `firstname` varchar(30) NOT NULL,

  `lastname` varchar(30) NOT NULL,

  `email` varchar(40) NOT NULL,

  UNIQUE KEY `email` (`email`)

);

INSERT INTO `tblmember` (`firstname`, `lastname`, `email`) VALUES

('anand', 'kumar', 'csnotes32@gmail.com');

Output