当用户未在文本框中输入任何内容时，表格会更新空格

您将 $_POST 用于name/pos/dep/tag"，将 $_GET 用于emp"，因此您可能无法获取值.将 GET 更改为 POST - 应该这样做.由于您正在更新，我建议您使用 POST 而不是 GET.GET 更适合搜索.

此外，您可以将所有更新查询放在一个更新查询中.像这样.

$name = $_POST['name'];$pos = $_POST['pos'];$dep = $_POST['dep'];$tag = $_POST['tag'];$emp = $_POST['emp'];$qry_start = "更新 gpl_employees_list 集";$where = " WHERE emp_id = $emp";$字段 = "";$更新 = "";如果($名称){$updates .= " `emp_name` = $name,";}如果($pos){$updates .= " `emp_pos` = $pos,";}如果($dep){$updates .= " `emp_dep` = $dep,";}如果($标签){$updates .= " `emp_tag` = $tag,";}$updates = substr($updates, 0, -1);//去掉结尾的逗号.$qry = $qry_start .$更新.$哪里;

i am doing a project where one may update the name, position, department and tag of the employee.

But as i do my project, it wont update, i know there is something wrong with my code. would you guys mind checking it.

my php page has an index.php which is the main menu, if you click the employee name in the list, a pop up window will appear. that pop up is for updating.

my php code (it now updating) but errors found:

<?php
$con=mysql_connect('localhost','root','pss') or die(mysql_error());
mysql_select_db('intra',$con);

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

    $sql = "SELECT * FROM gpl_employees_list where emp_id='".$_POST['eid']."'";
    $result = mysql_query($sql) or die (mysql_error());
    if(!$result || mysql_num_rows($result) <= 0)
                            {                       
                                return false;
                            }

    $qry = "UPDATE gpl_employees_list SET emp_nme = '".$_POST['ename']."', emp_pos = '".$_POST['pos']."', emp_dep = '".$_POST['dep']."', emp_tag = '".$_POST['tag']."' WHERE emp_id = '".$_POST['eid']."' ";  

    mysql_query($qry) or die (mysql_error()); 
?><script>window.close();</script><?php 
        }       
    ?>

*NOTE : this is now updating, but if a user leaves one of the textboxes empty, it updates the table with empty spaces as well and that is my problem now. how do i avoid that? i mean if a user leaves one textbox empty,the data with empty values must still contain its old value,but how to do that with this code? thanks for those who will help

MisaChan

You use $_POST for 'name/pos/dep/tag' and $_GET for 'emp' so you're probably not getting the values. Change the GETs to POST - that should do it. Since you're updating, I'd recommend using POST over GET. GET is more appropriate for searching.

Also, you can put all your update queries into one update query. Like so.

$name = $_POST['name'];
$pos = $_POST['pos'];
$dep = $_POST['dep'];
$tag = $_POST['tag'];
$emp = $_POST['emp'];

$qry_start = "UPDATE gpl_employees_list SET ";
$where = " WHERE emp_id = $emp";
$fields = "";
$updates = "";

if($name){
  $updates .= " `emp_name` = $name,";
}
if($pos){
  $updates .= " `emp_pos` = $pos,";
}
if($dep){
  $updates .= " `emp_dep` = $dep,";
}
if($tag){
  $updates .= " `emp_tag` = $tag,";
}
$updates = substr($updates, 0, -1); //To get rid of the trailing comma.
$qry = $qry_start . $updates . $where;

这篇关于当用户未在文本框中输入任何内容时，表格会更新空格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！