0

**

plz help me to implement this code in php class

**

index.php

 <?php
            $connect=mysql_connect("localhost","root","");
            mysql_select_db("crud",$connect);
            $username;
            $password;
            if(isset($_POST["insert"])){
                if($_POST["insert"]=="yes"){
                $username=$_POST["username"];
                $password=$_POST["password"];

            $query="insert into user(username, password) values('$username', '$password')";
            if(mysql_query($query))
            echo "<center>Record Inserted!</center><br>";
                }
            }

            if(isset($_POST["update"])){
                if($_POST["update"]=="yes"){
                $username=$_POST["username"];
                $password=$_POST["password"];

            $query="update user set username='$username' , password='$password' where id=".$_POST['id'];
            if(mysql_query($query))
            echo "<center>Record Updated</center><br>";
                }
            }

            if(isset($_GET['operation'])){
            if($_GET['operation']=="delete"){
            $query="delete from user where id=".$_GET['id'];   
            if(mysql_query($query))
            echo "<center>Record Deleted!</center><br>";
            }
            }
            ?>
            <html>
            <body>
            <form method="post" action="index.php">
            <table align="center" border="0">
            <tr>
            <td>username:</td>
            <td><input type="text" name="username" /></td>
            </tr>
            <tr>
            <td>password:</td>
            <td><input type="password" name="password" /></td>
            </tr>
            <tr>
            <td> </td>
            <td align="right">
            <input type="hidden" name="insert" value="yes" />
            <input type="submit" value="Insert Record"/>
            </td>
            </tr>
            </table>
            </form>
            <?php

            if(isset($_GET['operation'])){
            if($_GET['operation']=="edit"){
            ?>
            <form method="post" action="index.php">
            <table align="center" border="0">
            <tr>
            <td>username:</td>
            <td><input type="text" name="username" value="<?php echo $_GET['username']; ?>" /></td>
            </tr>
            <tr>
            <td>password:</td>
            <td><input type="text" name="password" value="<?php echo $_GET['password']; ?>"/></td>
            </tr>
            <tr>
            <td> </td>
            <td align="right">
            <input type="hidden" name="id" value="<?php echo $_GET['id'] ?>" />
            <input type="hidden" name="update" value="yes" />
            <input type="submit" value="update Record"/>
            </td>
            </tr>
            </table>
            </form>
            <?php
            }}
            ?>

            <?php
            $query="select * from user";
            $result=mysql_query($query);
            if(mysql_num_rows($result)>0){
                echo "<table align='center' border='1'>";
                echo "<tr>";
                echo "<th>Id</th>";
                echo "<th>Username</th>";
                echo "<th>Password</th>";
                echo "</tr>";
                while($row=mysql_fetch_array($result)){
                echo "<tr>";
                echo "<td>".$row['id']."</td>";   
                echo "<td>".$row['username']."</td>";   
                echo "<td>".$row['password']."</td>";
                echo "<td><a href='index.php?operation=edit&id=".$row['id']."&username=".$row['username']."&password=".$row['password']."'>edit</a></td>";
                echo "<td><a href='index.php?operation=delete&id=".$row['id']."'>delete</a></td>";   
                echo "</tr>";
                }
                echo "</table>";
            }
            else{
            echo "<center>No Records Found!</center>";   
            }

            ?>
            </body>
            </html>
2
Contributors
1
Reply
7
Views
3 Years
Discussion Span
Last Post by LastMitch
0

plz help me to implement this code in php class

@annyangel

?

What is the issue? What are you trying to do?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.