Wednesday, March 30, 2016

show info php 2

<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        
        
        <?php
    
        $con = mysql_connect("localhost:3306" ,"root", "");
        
        mysql_select_db("dvdclub", $con);
        
        $i = $_GET["cust"];
        
        $result = mysql_query("select * from customers where id = '$i' ");
        
        while ($row = mysql_fetch_array($result))
        {
            echo "Customer ID : " . $row["id"] . "<br/>";
            echo "Customer first Name : " . $row["FirstName"] . "<br/>";
            echo "Customer Last Name : " . $row["LastName"] . "<br/>";

        }
        
        //step 4 = close the connection
        mysql_close($con);
        ?>
        
        <a href="index.php">Home Page</a>
    </body>
</html>

No comments

Post a Comment

follow me

All Rights Reserved by personal © 2015 - 2016
Powered By Blogger, Designed by Mohammed ARG