YA: Contacts Editing 20120716060409AAKUwnw

<html>
<head>
<link rel="stylesheet" href="table.css" type="text/css" media="screen" />
<style type="text/css">
    table {
        border: 3px solid #4D76B1;
    }
    th,td {
        font-family: "Arial, Helvetica, sans-serif";
        margin: 2px;
        padding: 3px;
        border: 1px solid #4D76B1;
    }
    tr:hover {
        background-color: #EEE;
    }
</style>
</head>
<body>
<?php
define ('DB_NAME','contacts');
define ('DB_USER','root');
define ('DB_PASSWORD','ewurabathompson');
define ('DB_HOST','localhost');

$con = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$con){
    die('Could not Connect: ' . mysql_error());
}

$db_selected = mysql_select_db(DB_NAME, $con);

if(!$db_selected){
    die('Could not Select: ' . mysql_error()); // Unique Error messages, allow for easier debugging
}

if( isset($_GET['cmd']) ){
    $cmd = strtolower( trim($_GET['cmd']) );
    if( $cmd === 'delete'){
        $id = mysql_real_escape_string( trim( $_GET['id'] ) );
        $query = "DELETE FROM contacts WHERE id='{$id}'";
        $result = mysql_query($query) or die('Query [<span style="font-family: monospace;">' . $query . '</span>] Failed because: ' . mysql_error($con) );
        echo '<h3>Contact "' . trim( $_GET['cName'] ) . '" Remove From Database.</h3>';
    } else if( $cmd === 'edit'){
        $id = mysql_real_escape_string( trim( $_GET['id'] ) );
        $query = "SELECT * FROM contacts WHERE id={$id} LIMIT 1";
        $result = mysql_query($query) or die('Query [<span style="font-family: monospace;">' . $query . '</span>] Failed because: ' . mysql_error($con) );
        $data = mysql_fetch_assoc($result);
        ?>
        <form method="post" action="?cmd=save">
            <input type="hidden" name="id" value="<?php echo $data['id']; ?>">
        <?php
        $fields = array_keys($data);
        unset($fields[array_search('id', $fields)]);
        foreach($fields as $field){
            echo '<label>' . $field . '</label>: <input type="text" name="fd_' . $field . '" value="' . $data[$field] . '"><br>' . PHP_EOL;
        }
        ?>
            <input type="submit" value="Save">
        </form>
        </body>
        </html>
        <?php
        exit;
    } else if ( $cmd === 'save'){
        $id = mysql_real_escape_string( trim( $_POST['id'] ) );
        $query = "UPDATE contacts SET ";
        foreach($_POST as $name=>$val){
            if( strpos($name, 'fd_') !== false){
                $query .= mysql_real_escape_string( substr( $name, 3) ) . "='" . mysql_real_escape_string($val) . "',";
            }
        }
        $query = rtrim($query, ',') . " WHERE id='{$id}'";
        $result = mysql_query($query) or die('Query [<span style="font-family: monospace;">' . $query . '</span>] Failed because: ' . mysql_error($con) );
        echo '<h3>Update Successful</h3>';
    }
}


$query = "SELECT id,cName,cNumber FROM contacts ORDER BY cName ASC"; // Alter to fit your needs.
$result = mysql_query($query) or die('Query [<span style="font-family: monospace;">' . $query . '</span>] Failed because: ' . mysql_error($con) );

?>

<table class="hovertable">
    <tr>
        <th>CLIENT NAME</th>
        <th>CLIENT NUMBER</th>
        <th>ACTIONS</th>
    </tr>

<?php

while( $row = mysql_fetch_assoc($result)){
    $id = $row['id'];
    $cName = $row['cName'];
    $cNumber = $row['cNumber'];
?>
    <tr>
        <td><?php echo $cName; ?></td>
        <td><?php echo $cNumber; ?></td>
        <td>
            <a href="?cmd=delete&id=<?php echo $id . '&cName=' . $cName; ?>">Delete</a>
            <a href="?cmd=edit&id=<?php echo $id; ?>">Edit</a>
        </td>
    </tr>
<?php
}
?>
</table>
</body>
</html>