Far Far -4 years ago 102
PHP Question

PHP ODBC : Updating Form

I have a form and successfully connect them to the database.

Now I'm trying to update the data. Unfortunately, nothing happened when I click the submit button. I'm sure I miss something. Please help me, thank you.

config.php :

<?php

$conn=odbc_connect("dsn", "", "");

if (!$conn)
{
exit("Connection Failed : " . $conn);
}

?>


This is my code :

<?php

include "config.php";

ini_set('error_reporting', E_ALL);

error_reporting(-1);

$sql = odbc_exec( $conn, "SELECT

UserId,
UserName,
UserEmail

FROM DBA.tblUser
WHERE UserId='".$_GET['UserId']."'");

if(isset($_POST['submit']))
{
$UserId=$_POST["UserId"];
$UserName=$_POST["UserName"];
$UserEmail=$_POST["UserEmail"];

//UPDATE

$stmt = odbc_exec( $conn,
"UPDATE DBA.tableUsers SET
UserName = '$UserName',
UserEmail ='$UserEmail'

WHERE UserId=$UserId");

if ($stmt) {

echo "Update Success";
echo $UserName;
echo $UserEmail;

} else {

"Error : " . odbc_errormsg();
}
}

?>


Form :

<form class="form" method="post">

<tr>
<td class = "userid">User ID</td>
<td><?php echo $UserId = odbc_result($sql,'UserId'); ?></td>
</tr>


<tr>
<td class = "name">User Name<span class="required">&nbsp; * &nbsp;</span></td>
<td><input type="text" name="UserName" value="<?php echo $UserName = odbc_result($sql,'UserName'); ?>"></td>
</tr>

<tr>
<td class = "email">Email<span class="required">&nbsp; * &nbsp;</span></td>
<td><input type="text" name="UserEmail" value="<?php echo $UserEmail = odbc_result($sql,'UserEmail'); ?>"></td>
</tr>

<button name="submit" type="submit" value ="submit" >Update</button>

</form>

Answer Source

I managed to get the answer with the same concept and variable.

config.php :

<?php

$conn=odbc_connect("dsn", "", "");

if ($conn) {

echo "Connected";

}

if (!$conn) {

exit("Connection Failed : " . $conn);

}

?>

code :

<?php

include "config.php";

$sql =  odbc_exec( $conn, "SELECT 

        UserId, 
        UserName,
        UserEmail

        FROM DBA.tblUser 
        WHERE UserId='".$_GET['UserId']."'");

if(isset($_POST['submit'])) {

        $UserName=$_POST["UserName"];
        $UserEmail=$_POST["UserEmail"];

        $stmt = odbc_exec($conn, 
        "UPDATE DBA.tblUser SET
        UserName = '$UserName',
        UserEmail ='$UserEmail'

        WHERE UserId='".$_GET['UserId']."'");

if ($stmt) {

        echo "Update Successfull";
        echo    $UserName;
        echo    $UserEmail;
} 

else {

       "Error : " . odbc_errormsg();
}
}

?>

html :

<!DOCTYPE html>
<html>
<head>
<title>Administration</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />   
<link rel="stylesheet" type="text/css" href="css/userpage.css" media="screen"/>

<body>

  <content>

  <div class="user-form">

  <div class="user-form-heading">Update User</div><br>

  <form class="form"  method="post">

  <h><table class ="user">


<!-- .................................. Updatable ....................................... -->
<tr>
<td class = "name">User Name<span class="required">&nbsp; * &nbsp;</span></td>
<td><input type="text" name="UserName" value="<?php echo $UserName = odbc_result($sql,'UserName');  ?>"></td>
</tr>

<tr>
<td class = "userid">User Id</td>
<td><?php echo $UserId = odbc_result($sql,'UserId');  ?></td>
</tr>

<tr>
<td class = "email">Email<span class="required">&nbsp; * &nbsp;</span></td>
<td><input type="text" name="UserEmail" value="<?php echo $UserEmail = odbc_result($sql,'UserEmail');  ?>"></td>
</tr>
<tr>
<td>
<f><button name="submit" type="submit" value ="submit" >UPDATE</button></f>
&nbsp;&nbsp;&nbsp;

</table>
</form>
</div>
</content>
</body>
</head>
</html>
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download