使用url变量通过Php更新phpmyadmin表

im having a problem when trying to implement a edit page in php.

Getting items from the database doesent pose any problem, yet trying to update it tells me that i have missed a field and trying to skip the check just leaves me with a unedited table.

To explain more, there is a page that directs to this one while passing on a id (propertyID) veriable and from that we use it to grab the desired variables.

Can anyone look at the code and tell me what i have done wrong, i have prevously got a similar page working and am getting quite flustered trying to figure out why this one isent.

<?php


// Start sessions
include('includes/security.inc.php');
authorise();



if (!isset($_GET['propertyID']) || !is_numeric($_GET['propertyID']))
{
    header('Location:./houselist.php');
}
else
{
// Include connection file
include('includes/connection.inc.php');

    // Get  details
    connect();


    $propertyID = $_GET['propertyID'];

    $sql = "SELECT * FROM Properties WHERE propertyID='$propertyID' LIMIT 1";
    $result = @mysql_query($sql) or die('Unable to run query');
    $record = mysql_fetch_object($result);

    mysql_close();      

    // Check to see if the form has been submitted
    if (isset($_POST['submit']))
    {
        // Check to see all fields have been completed
    $address = $_POST['address'];
    $categoryID = $_POST['categoryID'];
    $price = $_POST['price'];
    $landlordName = $_POST['landlordName'];
    $img = $_POST['img'];
    $description= $_POST['description'];


    if (!empty($address) && !empty($categoryID) && !empty($price) && !empty($landlordName) && !empty($img) && !empty($description))
        {
            // Create an SQL query to add the comment


            $sql = "UPDATE property SET propertyID = '$propertyID', img = '$img', address = '$address', price = '$price', landlordName = '$landlordName', description = '$description' WHERE propertyID = $propertyID";

            // Connect to the database
            connect();

            // Run the query and store the result in a variable
            $result = mysql_query($sql) or die("Could not run query1");

            // Close connection to the database
            mysql_close();

            // Check if query was successful
            if ($result)
            {
                $message = '<div class="success"><p>You have successfully edited Article details.</p><p>Please <a href="Animal_Manage.php">Click Here</a> to view the Animal list.</p></div>';
            }
            else
            {
                $message = '<div class="error"><p>There was an error editing details, please try again</p></div>';
            }
        }
        else
        {
            $message = '<div class="error"><p>Please make sure you fill all fields in before submitting the form.</p></div>';
        }
    }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link rel="stylesheet" type="text/css" href="css/960.css"/>
    <link rel="stylesheet" type="text/css" href="css/demo.css"/>
    <link rel="stylesheet" type="text/css" href="css/960_24_col.css"/>
    <link rel="stylesheet" type="text/css" href="css/reset.css"/>
    <link rel="stylesheet" type="text/css" href="css/text.css"/>
    <link rel="stylesheet" type="text/css" href="css/style.css"/>
    <title>Complete Property Solutions</title>
<title>Homescreen - Complete Property Solutions</title>
</head>

<body>

<div class="container_24" id="container">
    <div class="grid_24" id="banner">
        <a href="home.php"><img src="img/banner.png" width="960" height="92" /></a>
    </div>
    <div class="grid_18" id="nav" align="right">
        <ul id="topnav">
            <li><a href="home.php">Home</a></li>
            <li><a href="categories.php">Properties</a></li>
            <li><a href="landloeds.php">Landlords</a></li>
            <li><a href="tenants.php">Tenants</a></li>
            <li><a href="logout.php">Logout</a></li>
        </ul>
    </div>
    <div class="grid_6" id="search" align="right">
    <form action="search.php" method="GET"> 
        <input type="text" name="term" size="15">
          <input type="submit" value="Search"> 
    </form>
    </div>

</div>
<div class="container_24" id="container" align="center">
<div id="container">
  <form id="PropertyEdit" name="PropertyEdit" method="post" action="<? echo $_SERVER['PHP_SELF'] . "?propertyID=" . $propertyID; ?>">
  <input type="hidden" name="propertyID" id="propertyID" value="<?php echo $propertyID; ?>" />

<?php
    if (isset($message))
    {
        echo $message;  
    }
    else
    {
?>


 <div class="label"><label for="propertyID"></label></div>
  <div class="input"><input type="hidden" name="propertyID" id="propertyID" tabindex="1" value="<? echo $record->propertyID; ?>" /></div>  
  <br />

     <div class="label"><label for="categoryID">Category</label></div>
  <div class="input"><input type="text" name="categoryID" id="categoryID" tabindex="1" value="<? echo $record->categoryID; ?>" /></div>  
  <br />

    <div class="label">
      <label for="address">Address:</label></div>
  <div class="input"><input type="text" name="address" id="address" tabindex="1" value="<? echo $record->address; ?>" /></div>  
  <br />

 <div class="label"><label for="price">Price:</label></div>
  <div class="input"><input type="text" name="Price" id="price" tabindex="3" value="<? echo $record->price; ?>" /></div>


  <div class="label"><label for="landlordName">Landlord</label></div>
  <div class="input"><input type="text" name="landlordName" id="landlordName" tabindex="1" value="<? echo $record->landlordName; ?>" /></div>  
  <br />
   <div class="label"><label for="img">Image</label></div>
  <div class="input"><input type="text" name="img" id="img" tabindex="1" value="<? echo $record->img; ?>" /></div>  
  <br />
<div class="label"><label for="description">Description:</label></div>
  <div class="input"><textarea name="description" id="description" cols="50" rows="10" tabindex="5"><? echo $record->description; ?></textarea></div>
  <br />
  <div class="label">&nbsp;</div>
  <div class="input">
    <input type="reset" name="reset" id="reset" value="Reset" tabindex="6" />
    <input type="submit" name="submit" id="submit" value="Submit" tabindex="7" />
  </div>
  <p class="normal"><a href="index.php">Click Here</a> to Return to the Home page</p>
<?php
    }
?>
</form> </div>
</div>

</body>
</html>
<?php
}
?>

my best guess for the problem would revolve around

// Check to see if the form has been submitted
    if (isset($_POST['submit']))
    {
        // Check to see all fields have been completed
    $address = $_POST['address'];
    $categoryID = $_POST['categoryID'];
    $price = $_POST['price'];
    $landlordName = $_POST['landlordName'];
    $img = $_POST['img'];
    $description= $_POST['description'];


    if (!empty($address) && !empty($categoryID) && !empty($price) && !empty($landlordName) && !empty($img) && !empty($description))
        {
            // Create an SQL query to add the comment


            $sql = "UPDATE property SET propertyID = '$propertyID', img = '$img', address = '$address', price = '$price', landlordName = '$landlordName', description = '$description' WHERE propertyID = $propertyID";

            // Connect to the database
            connect();

            // Run the query and store the result in a variable
            $result = mysql_query($sql) or die("Could not run query1");

            // Close connection to the database
            mysql_close();

            // Check if query was successful
            if ($result)
            {
                $message = '<div class="success"><p>You have successfully edited Article details.</p><p>Please <a href="Animal_Manage.php">Click Here</a> to view the Animal list.</p></div>';
            }
            else
            {
                $message = '<div class="error"><p>There was an error editing details, please try again</p></div>';
            }
        }
        else
        {
            $message = '<div class="error"><p>Please make sure you fill all fields in before submitting the form.</p></div>';
        }
    }

And the below section, my problem is that im not sure where exactly

<div class="container_24" id="container" align="center">
<div id="container">
  <form id="PropertyEdit" name="PropertyEdit" method="post" action="<? echo $_SERVER['PHP_SELF'] . "?propertyID=" . $propertyID; ?>">
  <input type="hidden" name="propertyID" id="propertyID" value="<?php echo $propertyID; ?>" />

<?php
    if (isset($message))
    {
        echo $message; 
    }
    else
    {
?>


 <div class="label"><label for="propertyID"></label></div>
  <div class="input"><input type="hidden" name="propertyID" id="propertyID" tabindex="1" value="<? echo $record->propertyID; ?>" /></div>  
  <br />

     <div class="label"><label for="categoryID">Category</label></div>
  <div class="input"><input type="text" name="categoryID" id="categoryID" tabindex="1" value="<? echo $record->categoryID; ?>" /></div>  
  <br />

    <div class="label">
      <label for="address">Address:</label></div>
  <div class="input"><input type="text" name="address" id="address" tabindex="1" value="<? echo $record->address; ?>" /></div>  
  <br />

 <div class="label"><label for="price">Price:</label></div>
  <div class="input"><input type="text" name="Price" id="price" tabindex="3" value="<? echo $record->price; ?>" /></div>


  <div class="label"><label for="landlordName">Landlord</label></div>
  <div class="input"><input type="text" name="landlordName" id="landlordName" tabindex="1" value="<? echo $record->landlordName; ?>" /></div>  
  <br />
   <div class="label"><label for="img">Image</label></div>
  <div class="input"><input type="text" name="img" id="img" tabindex="1" value="<? echo $record->img; ?>" /></div>  
  <br />
<div class="label"><label for="description">Description:</label></div>
  <div class="input"><textarea name="description" id="description" cols="50" rows="10" tabindex="5"><? echo $record->description; ?></textarea></div>
  <br />
  <div class="label">&nbsp;</div>
  <div class="input">
    <input type="reset" name="reset" id="reset" value="Reset" tabindex="6" />
    <input type="submit" name="submit" id="submit" value="Submit" tabindex="7" />

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

报告相同问题？

关注问题

只使用php从phpmyadmin表中获取单行 mysql php
2017-02-27 09:08

回答 5 已采纳 Try this: $sql1= "SELECT book FROM vi_views ORDER BY total DESC LIMIT 3"; $query1= mysqli_query($
通过phpMyAdmin更改表中的URL mysql php
2015-01-19 17:58

回答 1 已采纳 In the sql tab you can enter an update statement, which would look something like this: UPDATE cg
使用php将excel / csv文件导入phpmyadmin php
2019-03-10 17:36

回答 2 已采纳 There is an error in the line $query = "INSERT INTO `student`(`student_id`, `student_login`, `stu
【粉丝福利社】PHP从入门到精通（第6版）（软件开发视频大讲堂）（文末送书-完结）
2024-03-18 09:58

愚公搬代码的博客 PHP（全称为Hypertext Preprocessor）是一种开源的服务器端脚本语言。它被设计用于开发动态的互联网应用...PHP的语法简单易懂，学习和使用也比较容易。它广泛应用于Web开发领域，并且是最流行的服务器端脚本语言之一。
更新查询不能在php和phpmyadmin中工作 mysql php
2019-04-05 17:27

回答 2 已采纳 user is a keyword, better use backticks around it. See: https://dev.mysql.com/doc/refman/8.0/en/ke
在linux使用lamp环境安装phpmyadmin php
2023-03-14 11:30

回答 2 已采纳出现403错误代表没有权限访问该目录或者文件。这很可能是因为目录或者文件的权限问题导致的。因此可以按照以下步骤解决：首先确认你已经在Linux系统中以root用户身份登录。使用命令行工具进入apa
通过使用php上传文件将excel文件导入phpmyadmin php
2014-01-11 15:49

回答 1 已采纳 I have found my solution. Now allz working perfectly fine. I am posting my full code. upload.php:
大数据技术之数据安全与网络安全——CMS靶场(文章管理系统)实训
2023-11-25 00:25

星川皆无恙的博客数据与网络安全作为保障大数据系统正常运行的基石，同样备受关注。...本文通过CMS靶场实训，深入分析CMS系统的安全漏洞，探讨防范措施，提供实战经验和攻防能力，有助于加强大数据与网络安全意识。
如何使用php在phpmyadmin中插入数组数组 mysql php
2016-04-14 09:53

回答 1 已采纳 Use single insert query for three insert operations like this: <?php $insert = "INSERT INTO `m
PHP执行MYSQL语句成功，但是数据库里面没有更新 mysql php
2022-04-18 00:01

回答 3 已采纳 $sql = "UPDATE `plan` SET `gz`='$gz',`gzff`='$gzff',`ffren`='$chaozuo' WHERE `id` ='$id'"; 问题可能在于
{完成} Mysql查询无法处理php脚本但正在使用PhpMyAdmin mysql php
2018-12-24 23:08

回答 2 已采纳 I found the error: $sql = 'UPDATE `login_D` SET `active`= 1 WHERE email="'.$email.'" and code=\'
图解windows 下apache+php+mysql+phpmyadmin+Zend Optimizer
2014-11-08 17:10

打杂人的博客很多想在windows2003系统下搭配apache+php+mysql+phpmyadmin+ZendOptimizer的服务器环境都失败了，这主要是首先搭配这个服务器环境非常麻烦，其次是网上关于这方面的教程不多，能够搜索到的教程也都写得很肤浅，而且...
php代码没有使用bootstrap表单插入我的phpmyadmin表中的所有内容 php sql
2014-03-27 16:58

回答 1 已采纳 Try changing the names in your query. Change "$_POST[name]" to "$_POST[Name]", "$_POST[email]" to
PHP的威胁函数与PHP代码审计实战
2022-07-09 00:18

wespten的博客下面列举一些经常使用的函数，也就是下文说的字典（暂略）。咱们面对不少工具以及大牛扫描过n遍的代码，有不少的安全人员有点悲观，而有的官方安全人员也很是的放心本身的代码，可是不要忘记了“没有绝对的安全”，...
配置phpstudy2018
2022-07-01 11:57

時-宇的博客文件管理器文件路径地址栏敲：%APPDATA% 快速进入 C:Users电脑用户AppDataRoaming 文件夹中; 新建 pip 文件夹并在... index-url = http://pypi.douban.com/simple [install] use-mirrors =true mirrors =http://p
PHP面试题大全
2019-12-20 09:54

Rudon滨海渔村的博客系统限制，只显示了2902行，请下载完整版： ...回答：PHP全称：Hypertext Preprocessor，是一种用来开发动态网站的服务器脚本语言。问题：什么是MVC？回答：MVC由Model（模型）, View（视图...
amh一键升级php54apc_国产LNMP面板 AMH4.0发布
2020-12-22 01:31

weixin_39953673的博客 AMH使用GPL开源授权协议、所有源码开放，目前已有较为丰富的使用说明、开发学习文档，与有良好的用户群，您使用、学习AMH都是一没错的选择，AMH希望用户使用面板同时也有所学习与收获、与您共同进步、发展。...
图解win2003下apache+php+mysql+phpmyadmin+Zend Optimizer
2013-07-07 17:37

幽幽野草香的博客很多想在windows2003系统下搭配apache+php+mysql+phpmyadmin+ZendOptimizer的服务器环境都失败了，这主要是首先搭配这个服务器环境非常麻烦，其次是网上关于这方面的教程不多，能够搜索到的教程也都写得很肤浅，而且...
没有解决我的问题, 去提问

悬赏问题

¥15 使用C#，asp.net读取Excel文件并保存到Oracle数据库
¥15 C# datagridview 单元格显示进度及值
¥15 thinkphp6配合social login单点登录问题
¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场部分对应不上
¥15 如何在scanpy上做差异基因和通路富集？
¥20 关于#硬件工程#的问题，请各位专家解答！
¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
¥30 截图中的mathematics程序转换成matlab
¥15 动力学代码报错，维度不匹配

码龄粉丝数原力等级 --

使用url变量通过Php更新phpmyadmin表

0条回答默认最新

悬赏问题

使用url变量通过Php更新phpmyadmin表

0条回答 默认 最新

悬赏问题

0条回答默认最新