Jump to content


Photo

Help Please! Edit Record Query


  • Please log in to reply
4 replies to this topic

#1 One MA

One MA
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 03 March 2006 - 09:43 AM

Hi - I'm obviously a noob to this but that's why I'm here - I've been using PHP for just over a month and I'm really enjoying it. I'm looking to create an Edit query when I click the edit submit button next to each record in a table. I'm trying to do it all in one script - viewuser.php this is what I have so far - I don't know what is wrong or why it doesn't work - I would really appreciate your help - thanks ever so much in advance - I'm already very grateful for people's help on another script.

<html><head><title>View Users</title></head>
<body>

<?php

session_start();

if (!isset($_SESSION['loggedin']) 
   || $_SESSION['loggedin'] !== true) {

   header('Location: login.php');
   exit;
}

$conn=@mysql_connect( "localhost", "alexm", "rugby" )
             or die( "Err:Conn" );

$db = @mysql_select_db( "rugby_project", $conn) or die( "Err:Db" );

if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
   if (!isset($_POST["submit"]))
   {
      $userID = $_GET["userID"];
      $sql = "SELECT * FROM phone_numbers WHERE userID=$userID";
      $result = mysql_query($sql);        
      $row = mysql_fetch_array($result);
      
echo' <form action="$self" method="post">
      <input type=hidden name="userID" value="<?php echo $row["userID"] ?>">
 
      User<INPUT TYPE="TEXT" NAME="userID" VALUE=" $row["userID"] >" SIZE=30><br>
      Number<INPUT TYPE="TEXT" NAME="number" VALUE=" $row["number"] >" SIZE=30><br>
      Password<INPUT TYPE="TEXT" NAME="password" VALUE=" $row["password] ?>" SIZE=30><br>
   
      <input type="hidden" name="cmd" value="edit">
   
      <input type="submit" name="submit" value="submit">
   
      </form> ';  
    
    echo( "<center><p><font size=\"1\" face=\"Verdana\">
<a href=\"viewdevices.php\">Back</a>&nbsp;&nbsp;|&nbsp;
<a href=\"control.php\">Return to Control Panel</a>&nbsp;&nbsp;|&nbsp;
<a href=\"logout.php\">Log out<p></a>
</body></html>" );
  }

}
else
{
 
$sql = "select userID, number, password from phone_numbers order by userID";

$rs = @mysql_query( $sql,$conn);
$self = $_SERVER['PHP_SELF'];
$rows = mysql_num_rows($rs);

echo( "<table width=\"30%\" border=\"1\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bordercolor=\"#000000\">
<tr bgcolor=\"#CCCCCC\"> 
<td colspan=\"4\"><font size=\"1\" face=\"Verdana\">
<center>User View</center></font></td></tr>" );
   echo( "<tr><td><font size=\"1\" face=\"Verdana\"><strong>User</td>" );
   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Phone Number</td>" );
   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Password</td>" );
   echo( "<td><font size=\"1\" face=\"Verdana\"><i><center>Edit</td></tr>" );


if(mysql_num_rows($rs))
{

echo( "<form name=\"editform\" method=\"post\" action=\"$self\">"); 

while( $row = mysql_fetch_array( $rs ) ){
   $userID=$row["userID"]; 
   $number=$row["number"]; 
   $password=$row["password"]; 
   echo '<tr><td><font size="2" face="Verdana">' . $userID . '</td>'; 
   echo '<td><font size="2" face="Verdana">' . $number . '</td>'; 
   echo '<td><font size="2" face="Verdana">' . $password . '</td>'; 
   echo '<td><center><input type="hidden" name="edit[]" value="' . $userID . '" /><input type="submit" name="edit" value="Edit"></td></tr>';   
}

echo( "</table><p><table width=\"30%\" border=\"1\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bordercolor=\"#000000\">
<tr bgcolor=\"#CCCCCC\"> 
<td colspan=\"2\"><font size=\"1\" face=\"Verdana\">
<center>There are $rows records in this table</center></font></td></tr></table>" );
  
   echo( "<center><p><font size=\"1\" face=\"Verdana\">
<a href=\"control.php\">Return to Control Panel</a>&nbsp;&nbsp;|&nbsp;
<a href=\"logout.php\">Log out<p></a>
</body></html>" );

}
else
{
echo( "<table width=\"30%\" border=\"1\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bordercolor=\"#000000\">
<tr bgcolor=\"#CCCCCC\"> 
<td colspan=\"2\"><font size=\"1\" face=\"Verdana\">
<center>This table has no records yet</center></font></td></tr></table>" );
} 
}

?>


#2 One MA

One MA
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 03 March 2006 - 10:32 AM

I noticed some pretty stupid mistakes which I didn't see before - I have replaced the errors but the script still doesn't function entirely - i.e. the edit button next to each record doesn't take me into the input form to edit the record... here is the amended code:

<html><head><title>View Users</title></head>
<body>

<?php

session_start();

if (!isset($_SESSION['loggedin']) 
   || $_SESSION['loggedin'] !== true) {

   header('Location: login.php');
   exit;
}

$conn=@mysql_connect( "blah", "blah", "blah" )
             or die( "Err:Conn" );

$db = @mysql_select_db( "rugby_project", $conn) or die( "Err:Db" );

if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
   if (!isset($_POST["submit"]))
   {
      $userID = $_GET["userID"];
      $sql = "SELECT * FROM phone_numbers WHERE userID=$userID";
      $result = mysql_query($sql);        
      $row = mysql_fetch_array($result);
      
echo' <form action="$self" method="post">
      <input type=hidden name="userID" value="' . $row["userID"] . '"> 
      User<INPUT TYPE="TEXT" NAME="userID" VALUE="' . $row["userID"] . '" SIZE=30><br>
      Number<INPUT TYPE="TEXT" NAME="number" VALUE="' . $row["number"] . '" SIZE=30><br>
      Password<INPUT TYPE="TEXT" NAME="password" VALUE="' . $row["password"] . '" SIZE=30><br>

      <input type="hidden" name="cmd" value="edit">
   
      <input type="submit" name="submit" value="submit">
   
      </form> ';  
    
    echo( "<center><p><font size=\"1\" face=\"Verdana\">
<a href=\"viewdevices.php\">Back</a>&nbsp;&nbsp;|&nbsp;
<a href=\"control.php\">Return to Control Panel</a>&nbsp;&nbsp;|&nbsp;
<a href=\"logout.php\">Log out<p></a>
</body></html>" );
  }

}
else
{
 
$sql = "select userID, number, password from phone_numbers order by userID";

$rs = @mysql_query( $sql,$conn);
$self = $_SERVER['PHP_SELF'];
$rows = mysql_num_rows($rs);

echo( "<table width=\"30%\" border=\"1\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bordercolor=\"#000000\">
<tr bgcolor=\"#CCCCCC\"> 
<td colspan=\"4\"><font size=\"1\" face=\"Verdana\">
<center>User View</center></font></td></tr>" );
   echo( "<tr><td><font size=\"1\" face=\"Verdana\"><strong>User</td>" );
   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Phone Number</td>" );
   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Password</td>" );
   echo( "<td><font size=\"1\" face=\"Verdana\"><i><center>Edit</td></tr>" );


if(mysql_num_rows($rs))
{

echo( "<form name=\"editform\" method=\"post\" action=\"$self\">"); 

while( $row = mysql_fetch_array( $rs ) ){
   $userID=$row["userID"]; 
   $number=$row["number"]; 
   $password=$row["password"]; 
   echo '<tr><td><font size="2" face="Verdana">' . $userID . '</td>'; 
   echo '<td><font size="2" face="Verdana">' . $number . '</td>'; 
   echo '<td><font size="2" face="Verdana">' . $password . '</td>'; 
   echo '<td><center><input type="hidden" name="edit[]" value="' . $userID . '" /><input type="submit" name="edit" value="Edit"></td></tr>';   
}

echo( "</table><p><table width=\"30%\" border=\"1\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bordercolor=\"#000000\">
<tr bgcolor=\"#CCCCCC\"> 
<td colspan=\"2\"><font size=\"1\" face=\"Verdana\">
<center>There are $rows records in this table</center></font></td></tr></table>" );
  
   echo( "<center><p><font size=\"1\" face=\"Verdana\">
<a href=\"control.php\">Return to Control Panel</a>&nbsp;&nbsp;|&nbsp;
<a href=\"logout.php\">Log out<p></a>
</body></html>" );

}
else
{
echo( "<table width=\"30%\" border=\"1\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" bordercolor=\"#000000\">
<tr bgcolor=\"#CCCCCC\"> 
<td colspan=\"2\"><font size=\"1\" face=\"Verdana\">
<center>This table has no records yet</center></font></td></tr></table>" );
} 
}

?>


#3 One MA

One MA
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 04 March 2006 - 09:15 AM

Could anyone help at all by suggesting the script? Thanks guys in advance, I'd really appreciate it.

#4 One MA

One MA
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 06 March 2006 - 12:23 PM

please?

#5 Guest_edwinsweep_*

Guest_edwinsweep_*
  • Guests

Posted 06 March 2006 - 12:28 PM

hi One Ma are you getting any error, if so what kind?
or a blank page?
you could try adding these to lines to the verry beginning of your php script.

ini_set('error_reporting', E_ALL);
ini_set('display_errors', TRUE);

this will display(most of) the error's that the php script will encounter.
ill take a look at your script in a minute.

$conn=@mysql_connect( "blah", "blah", "blah" )
             or die( "Err:Conn" );





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users