Re: Table contents not updated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



The function page IS included on every page so that wouldn't be what
is causing the errors.

On 1/8/07, Wikus Moller <wikus.m@xxxxxxxxx> wrote:
Hi.

I am new to uising html forms with php and I am having a problem with
database contents not being updated although it seems my coding is
correct.

It's a xhtml formatted site with html forms:

Here are my functions:

<?
function login($uid, $pwd)
{
  $pass = md5($pwd);
  $pasw = mysql_fetch_array(mysql_query("SELECT pass FROM members
WHERE name='".$uid."'"));
  $dbpw = $pasw[0];
  if($pass == $dbpw)
  {
    $banned=mysql_fetch_array(mysql_query("SELECT * FROM members WHERE
banned='1' and name='".$uid."'"));
    if($banned)
    {
      return 2;
    }else{
        return 0;
    }

  }else{
    return 1;
  }
}


function
edtsite($username,$pass,$snm,$lnk,$imgu,$catg,$uid,$dsc,$keywords,$weblnk,$sid)
        {


         if (login($username,$pass)==0)
           {
            $adds=mysql_query("UPDATE sub_sites SET
sitename='".$snm."', sitelink='".$lnk."', sitelogo='".$image."',
catid='".$catg."', uid='".$uid."', dscr='".$dsc."',
keywords='".$keywords."', weblink='".$weblnk."' WHERE id='".$sid."'");
            if ($adds) {

            return true;
            } else {

              return false ;
           }
        }else{
          return false;
        }
        }
?>

Everything seems to be correct, but the table isn't updated...

<?
  echo "<form method=\"post\"
action=\"editsitefin.php?uid=$uid&amp;pwd=$pwd&amp;sid=$sid\">";
  echo "*Site Name: <input type=\"text\" name=\"snm\" maxlength=\"30\"
size=\"10\" value=\"$sites[1]\"/><br/>";
  echo "*Wap Link: <input type=\"text\" name=\"lnk\" maxlength=\"200\"
size=\"10\" value=\"$sites[3]\"/><br/>";
  echo "Web Link: <input type=\"text\" name=\"weblnk\"
maxlength=\"200\" size=\"10\" value=\"$sites[14]\"/><br/>";
  echo "Logo URL: <input type=\"text\" name=\"imgu\" maxlength=\"200\"
size=\"10\" value=\"$sites[4]\"/><br/>";
  echo "*Description: <input type=\"text\" name=\"dsc\"
maxlength=\"200\" size=\"10\" value=\"$sites[11]\"/><br/>";
  echo "*Category:";
  echo "<select name=\"catg\" value=\"$sites[2]\">";
  echo "<option value=\"1\">Entertainment</option>";
  echo "<option value=\"2\">Portal - Search</option>";
  echo "<option value=\"3\">Messaging - Chat</option>";
  echo "<option value=\"4\">Ringtones - Logos</option>";
  echo "<option value=\"5\">Fun - Games</option>";
  echo "<option value=\"6\">Hobbies - Interests</option>";
  echo "<option value=\"7\">Services</option>";
  echo "<option value=\"8\">Personal</option>";
  echo "<option value=\"9\">Others</option>";
  echo "</select><br/>";
  echo "*Keywords: (separate by spaces)<input type=\"text\"
name=\"keywords\" maxlength=\"200\" size=\"20\"
value=\"$sites[13]\"/><br/>";
  echo "* = Denotes a required field.<br/>";
  echo "<input type=\"submit\" name=\"add\" value=\"Edit\"/>";
  echo "</form>";
?>

Theres my form, also everything seems to be correct... The correct
values are displayed when the form is loaded.

<?
$uid=$_GET["uid"];
$pwd=$_GET["pwd"];
$snm = $_POST["snm"];
$lnk = $_POST["lnk"];
$imgu = $_POST["imgu"];
$catg = $_POST["catg"];
$dsc = $_POST["dsc"];
$weblnk = $_POST["weblnk"];
$keywords = $_POST["keywords"];
$sid = $_POST["sid"];

$uidid = mysql_fetch_array(mysql_query("SELECT * from members where
name='".$uid."';"));
$res =
edtsite($uid,$pwd,$snm,$lnk,$imgu,$catg,$uidid[0],$dsc,$keywords,$weblnk,$sid);
$snm=htmlspecialchars($snm);
if ($res) {
    $stid = mysql_fetch_array(mysql_query("SELECT * from sub_sites
where sitelink='".$lnk."';"));
echo "<head>";
metatags();
echo "<title>Chilling Lounge.net</title>";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\">";
echo "</head>";
echo "<body>";
echo "<table>";
echo "<div class=\"cre\">";
echo "$snm Updated Successfully</div>";
?>

And theres my site finished page (editsitefin.php), I can't find any
errors, but I am not that clued up with html forms. Does anyone notice
any errors? It displays a success message yet when I look at the
database or when I browse again to the site, the info isn't updated.
Please check if you find any errors that could cause the database
fields not to be updated or suggest a possible fix


Thanks


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux