0

i have this code to create a contact directory and my instructor wants me to create a function for database connect to minimize the coding and if an instance to change the server it is easy to change.

<?php
if(isset ($_POST ["add"])){
$name = $_POST['name'];
$address = $_POST['address'];
$email = $_POST['email'];
$tel = $_POST['tel'];
$mobile = $_POST['mobile'];
}   
class contactdirectory{
    function db_connect(){ //database connection
    $connect = mysql_connect("localhost", "root", "") or die ("Check your connection." . mysql_error());
        mysql_select_db("contactdirectory");

    }
    function form(){
        echo    "<form name=contact  method=post action=index.php>";
        echo    "Name:"."<input type=text name=name /><br />";
        echo    "Address:"."<input type=text name=address /><br />";
        echo    "Email"."<input type=text name=email /><br />";
        echo    "Tel No:"."<input  type=text name=tel /><br />";
        echo    "Mobile No:"."<input type=text name=mobile /><br />";
        echo    "<input type=submit name=add value=Add />";
        echo    "</form>";

    }

function add($name,$address,$email,$tel,$mobile){
        $connectto -> db_connect();     
        $query = "INSERT INTO contact VALUES(0, '$name','$address','$email','$tel','$mobile')";
        mysql_query($query,$connect);
        $directory = new contactdirectory();
        $directory -> form();
    }

function delete($idno){
        $connectto->db_connect();
        $query="DELETE FROM contact WHERE idno=$idno";
        mysql_query($query,$connect);
        $directory = new contactdirectory();
        $directory -> form();
        }
function edit($idno){
        $connect = mysql_connect("localhost", "root", "") or die ("Check your connection." . mysql_error());
        mysql_select_db("contactdirectory");

        $query = "SELECT * FROM contact WHERE idno=$idno";
        $rs = mysql_query($query,$connect) or die (mysql_error());
        if(mysql_num_rows($rs) > 0) {
            while($row = mysql_fetch_assoc($rs)){

            ?>

            <form name="contact" action="index.php" method="post">
                Name:<input type="text" name="name1" value="<?php echo $row[name] ?>" /><br />
                Address:<input type="text" name="address1" value="<?php echo $row[address] ?>" /><br />
                Email:<input type="text" name="email1" value="<?php echo $row[email] ?>" /><br />
                Tel No:<input type="text" name="tel1" value="<?php echo $row[tel] ?>" /><br />
                Mobile No:<input type="text" name="mobile1" value="<?php echo $row[mobile] ?>" /><br />
                    <input type="hidden" name="idno" value="<?php echo $row[idno] ?>" />
                    <input type="submit" name="update" value="Update" />
            </form>

            <?php
            }
        }

    }
    function update(){
        $connect = mysql_connect("localhost", "root", "") or die ("Check your connection." . mysql_error());
        mysql_select_db("contactdirectory");
        $query="UPDATE contact SET name='$_POST[name1]', address='$_POST[address1]', email='$_POST[email1]', tel='$_POST[tel1]', mobile='$_POST[mobile1]' WHERE idno='$_POST[idno]'";
        $recordset=mysql_query($query,$connect) or die ('Update info error!' . mysql_error());
        $directory = new contactdirectory();
        $directory -> form();
    }
}   
?>  

tnx.

Edited by Nick Evan: Fixed formatting

2
Contributors
1
Reply
3
Views
6 Years
Discussion Span
Last Post by vibhaJ
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.