无法更新表中的值

发布于 2024-12-20 02:16:30 字数 861 浏览 0 评论 0原文

我可以请求您帮助解决我的代码中的问题吗？我有这个 update_client.php 作为我的功能来更新我的 edit.php 页面中的详细信息。

但当我单击“保存”时，它不会更改该值。我想知道我哪里做错了。有人可以帮我吗？我真的很感激。谢谢

这是我的 update_client.php 的代码

<?php
session_start();
if (!isset($_SESSION['user'])){
    header("location:../efeedback/login2.php"); 

}
require_once "connect_to_mysql.php"; 

$name = $_POST['name'];
$company = $_POST['company'];
$email = $_POST['email'];
$client_user = $_POST['client_user'];
$client_pass = $_POST['client_pass'];
$initials = $_POST['initials'];

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = '$id'";
$result=mysql_query($sql);

// if successfully updated.
if($result){

header("location:add_client.php");
}

else {
echo "ERROR";
}

?>

原文

Can i ask for your help with my problem in my code. i have this update_client.php as my function to update the details in my edit.php page.

but as i click on save it doesn't change the value. I wonder where did i go wrong. can somebody please help me with it. I would really appreciate it. Thank

here is the code for my update_client.php

<?php
session_start();
if (!isset($_SESSION['user'])){
    header("location:../efeedback/login2.php"); 

}
require_once "connect_to_mysql.php"; 

$name = $_POST['name'];
$company = $_POST['company'];
$email = $_POST['email'];
$client_user = $_POST['client_user'];
$client_pass = $_POST['client_pass'];
$initials = $_POST['initials'];

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = '$id'";
$result=mysql_query($sql);

// if successfully updated.
if($result){

header("location:add_client.php");
}

else {
echo "ERROR";
}

?>

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

相守太难 2024-12-27 02:16:30

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = '$id'";

从它的外观来看，您忘记设置 $id 变量的值

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = '$id'";

By the looks of it, you forgot to set value for $id variable

回复收藏 0 原文

﹉夏雨初晴づ 2024-12-27 02:16:30

您似乎尚未设置 id 的值

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = '$id'";

Seems you haven't set value for id

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = '$id'";

回复收藏 0 原文

咋地 2024-12-27 02:16:30

您需要为 $id 设置值

$name = $_POST['name'];
...
$id = //you need set value for id, ex: $_GET['id'] or $_POST['id'];

如果表中的字段 id 是数字类型，您需要执行以下操作：

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = $id";

只需 $id 而不是 '$id'。

You need set value for $id

$name = $_POST['name'];
...
$id = //you need set value for id, ex: $_GET['id'] or $_POST['id'];

If field id in your table is type number, you need do this:

$sql="UPDATE client_users SET name = '$name', company = '$company', email = '$email', client_user = '$client_user', client_pass = '$client_pass', initials = '$initials' WHERE id = $id";

Just $id not '$id'.

回复收藏 0 原文