Updating table with form

idlepress

Let's see if you can help me figure out what is wrong here. I was reading a few tutorials online and got this code from those tutorials and altered it to my needs. I've read about php before and it made no sense until I started doing the actual tutorials and changing them around for something I actually need. Now it's starting to make sense to me.

After an event is submitted I need to be able to go back in and edit any field so I created edit.php, edit_data.php, and edit_form.php

edit.php - lists the events

      <?php
      include"db.inc.php";//database connection
      $order = "SELECT dateum, time, venue, location, event FROM beaded1";
      $result = mysql_query($order);
      while ($row=mysql_fetch_array($result)){
        echo ("$row[time]");
        echo "<br/>";
        echo ("$row[venue]");
        echo "<br/>";
        echo ("$row[location]");
        echo "<br/>";
        echo ("$row[event]");
        echo "<br/>";
        echo ("<a href=\"edit_form.php?id=$row[dateum]\">Edit</a>");
        echo "<br/><br/><br/>";
      }
      ?>

edit_form.php - The form to fill out to edit the field after clicking the edit link above

      <?php
      include "db.inc.php";//database connection
      $order = "SELECT dateum, time, venue, location, event FROM beaded1 WHERE dateum='$id'";
      $result = mysql_query($order);
      $row = mysql_fetch_array($result);
      ?>
      <form method="post" action="edit_data.php">
      <input type="hidden" name="id" value="<? echo "$row[id]"?>">
      Time<br/><input type="text" name="time" size="20" value="<? echo "$row[time]"?>"><br/>
      Venue<br/><input type="text" name="venue" size="20" value="<? echo "$row[venue]"?>"><br/>
      Location<br/><input type="text" name="location" size="20" value="<? echo "$row[location]"?>"><br/>
      Event<br/><textarea name="event" rows="5" cols="30" value="<? echo "$row[event]"?>"></textarea><Br/>
     <input type="submit" name="submit value" value="Edit">

edit_data.php - The file that should change what's in the edit_form fields

<?php
$time=$_POST['time'];
$venue=$_POST['venue'];
$location=$_POST['location'];
$event=$_POST['event'];

include "db.inc.php";

$id = $_GET["id"];
$order = "UPDATE beaded1 SET time='$time', venue='$venue', location='$location', event='$event' WHERE dateum='$id'";
mysql_query($order);
header("location:index.php");
?>

I don't get any errors but when I hit submit it redirects back to index.php and nothing updates.

idlepress

It sounds like I have a lot of research ahead of me. Thank you.

Weedpacket

Remember to keep referring back to the manual. The manual speaks truth.

idlepress

OK I did a revision and I got something to semi-work but I am having a few problems that I can't figure out.

<?php
$con = mysql_connect("xxx", "xxx", "xxx");
if(!$con){
die("Can not connect: " . mysql_error());
}

mysql_select_db ("beaded1",$con);

if(isset($_POST['update'])){
$UpdateQuery = "UPDATE beaded1 SET dateum='$_POST[dateum]', time='$_POST[time]', venue='$_POST[venue]', location='$_POST[location]', event='$_POST[event]' WHERE dateum='$_POST[hidden]'";
mysql_query($UpdateQuery, $con);
};


$sql = "SELECT ID, dateum, time, venue, location, event FROM beaded1 ORDER BY dateum ASC"; 
$myData = mysql_query($sql,$con);

echo "Update event information";
echo "<br/>";
while($record= mysql_fetch_array($myData)){
echo "<form action=updater.php method=post>";
echo "<input type=text name=dateum value=" . $record[dateum] . " </br>";
echo "<br/>";
echo "<input type=text name=time value=" . $record[time] . " </br>";
echo "<br/>";
echo "<input type=text name=venue value=" . $record[venue] . " </br>" ;
echo "<br/>";
echo "<input type=text name=location value=" . $record[location] . " </br>" ;
echo "<br/>";
echo "<input type=text name=event value=" . $record[event] . " </br>" ;
echo "<br/>";
echo "<input type=hidden name=hidden value=" . $record[dateum] . " </br>" ;
echo "<input type=submit name=update value=update>";
echo "<br/><br/><br/></form>";
}

?>

<html>
<head>
<title>Update Information</title>
</head>
</html>

1) The full information does not fill out in the text boxes. If my information says "The Place" or "The Location" for venue and location it only shows "The" and cuts off after the first word. Does this have something to do with the "<input" field never being closed with ">"? If so how do I fix that? I can't get it to work any other way...

2) Once hitting the update button how can I make the page redirect to go back to the events page say, events.php or bring up a message saying updated? I know how to do that but I can't figure out where to put it to make it work. I tried echoing "Updated" but it just showed that on the page instead of coming up after hitting the button.

Weedpacket

idlepress wrote:
1) The full information does not fill out in the text boxes. If my information says "The Place" or "The Location" for venue and location it only shows "The" and cuts off after the first word. Does this have something to do with the "<input" field never being closed with ">"? If so how do I fix that? I can't get it to work any other way...

No, it's because none of your HTML attributes have quotes around the values (have a look at the generated HTML source in your browser).

2) Once hitting the update button how can I make the page redirect to go back to the events page say, events.php or bring up a message saying updated? I know how to do that but I can't figure out where to put it to make it work. I tried echoing "Updated" but it just showed that on the page instead of coming up after hitting the button.

[man]header[/man]("Location: full URL of the page you want to redirect to"); exit();

Derokorian

When looking at the OUTPUT source, you should also notice NONE of the following input tags are closed, and that the line breaks immediately following the input are incorrect:

echo "<input type=text name=dateum value=" . $record[dateum] . " </br>"; 
echo "<br/>"; 
echo "<input type=text name=time value=" . $record[time] . " </br>"; 
echo "<br/>"; 
echo "<input type=text name=venue value=" . $record[venue] . " </br>" ; 
echo "<br/>"; 
echo "<input type=text name=location value=" . $record[location] . " </br>" ; 
echo "<br/>"; 
echo "<input type=text name=event value=" . $record[event] . " </br>" ; 
echo "<br/>"; 
echo "<input type=hidden name=hidden value=" . $record[dateum] . " </br>" ;