Updating form values

phprooky

Hi everybody,
I have the following php page where I bring data from my database where a user is going to change, but after that user makes the changes he needs to click a buttom and all the information should be updated. Do I have to create another page to make the update or is it possible to it in the same page? Can anyone please help me to create the script to update the values?

require("my_database.php");
$id_fromclick=$_GET['id'];
$sql="Select * from $tbl_name where id=$id_fromclick";
$result=mysql_query($sql) or die(mysql_error());

<form id="form1" name="form1" method="post" action="edited_row.php">
<table width="90%" height="193" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td><table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="19%">&nbsp;</td>
<td width="2%">&nbsp;</td>
<td width="79%"><div align="right"><strong><a href="logout.php">Log Out</a></strong></div></td>
</tr>

while($rows=mysql_fetch_array($result)){

<tr>
<td>Event Post Title</td>
<td><div align="center">:</div></td>
<td><input name="tittle" type="text" id="tittle" size="37" value="<?PHP echo $rows['tittle']; ?>"/></td>
</tr>
<tr>
<td>Your Name</td>
<td><div align="center">:</div></td>
<td><input name="author" type="text" id="author" size="37" value="<?PHP echo $rows['author']; ?>"/></td>
</tr>
<tr>
<td valign="top">Your Post</td>
<td valign="top"><div align="center">:</div></td>
<td><textarea name="post" cols="45" rows="12" id="post"><?PHP echo $rows['post']; ?></textarea></td>
</tr>
<tr>
<td>Date</td>
<td><div align="center">:</div></td>
<td><input name="date" type="text" id="date" size="37" value="<?PHP echo $rows['date']; ?>"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="submit" id="submit" value="Update Sport" /></td>
</tr>

</table></td>
</tr>
</table>
</form>

vividona

I think no need to use while. Bcs you need specific data.

you can change your code to be like this

//require("my_database.php"); 
$id_fromclick=$_GET['id']; 
$sql= mysql_query("Select * from '".$tbl_name."' where `id`='".$id_fromclick."'") or die(mysql_error());

echo '<form id="form1" name="form1" method="post" action="edited_row.php">
<table width="90%" height="193" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td><table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="19%">&nbsp;</td>
<td width="2%">&nbsp;</td>
<td width="79%"><div align="right"><strong><a href="logout.php">Log Out</a></strong></div></td>
</tr>';

$rows=mysql_fetch_array($sql);

if(isset($_POST['submit'])){
	if(isset($_GET['update'])){
		$id = $_GET['id'];
		$sql= mysql_query("UPDATE '".$tbl_name."' SET `title`='".$_POST['tittle']."', `author`= '".$_POST['author']."', `post`='".$_POST['post']."', `date`='".time()."' WHERE `id`= '".$id_fromclick."'") or die(mysql_error());
	}else{
		echo "";
	}
	}else{
echo '<tr>
<td>Event Post Title</td>
<td><div align="center">:</div></td>
<td><input name="tittle" type="text" id="tittle" size="37" value="'.$rows['tittle'].'"/></td>
</tr>
<tr>
<td>Your Name</td>
<td><div align="center">:</div></td>
<td><input name="author" type="text" id="author" size="37" value="'.$rows['author'].'"/></td>
</tr>
<tr>
<td valign="top">Your Post</td>
<td valign="top"><div align="center">:</div></td>
<td><textarea name="post" cols="45" rows="12" id="post">'.$rows['post'].'</textarea></td>
</tr>
<tr>
<td>Date</td>
<td><div align="center">:</div></td>
<td><input name="date" type="text" id="date" size="37" value="'.$rows['date'].'"/></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="submit" id="submit" value="Update Sport" /></td>
</tr>';
}

you need to have a link like this
index.php?update&id=1

phprooky

Hi vividona and thanks for keeping in touch,
Where am I going to put that link that you are suggesting?

vividona

try it at the same page

phprooky

I think the update will never work because this option takes me to another page
<form id="form1" name="form1" method="post" action="edited_row.php">
When I click on the buttom, nothing happens.

vividona

phprooky;10970464 wrote:
I think the update will never work because this option takes me to another page
<form id="form1" name="form1" method="post" action="edited_row.php">
When I click on the buttom, nothing happens.

change this

if(isset($_GET['update'])){

if(isset($_GET['edited_row'])){

and this

index.php?update&id=1

index.php?edited_row&id=1

phprooky

Hi vividona and thanks for keeping in touch,
I made a few changes to my coding and now all the values are getting transfered to the page where I have the update, but is not updating anything. I already added an echo option to see the values that I'm sending to the other page and I can see them very well. What I don't understand is why is not updating.
I'm sending you the new code to see if you can please help me the way I have it now.
This is the form where I show the values that I bring from my database:

require("mydatabase.php");
$id_fromclick=$_GET['id'];
$sql = "Select * from $tbl_name where id=$id_fromclick";
/*$sql="Select * from $tbl_name where id=$id_fromclick";*/
$result=mysql_query($sql) or die(mysql_error());

<form action="row_toedit.php" method="post" name="form1">
        <table width="90%" height="193" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
          <tr>
            <td><table width="100%" height="29" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td width="19%">&nbsp;</td>
                <td width="2%">&nbsp;</td>
                <td width="79%"><div align="right"><strong><a href="logmeout.php">
  <input name="id" type="hidden" id="id" value="<?PHP echo $id_fromclick ?>" />
                  Log Out</a></strong></div></td>
                </tr>
                <?php $rows=mysql_fetch_array($result) ?>
              <tr>
                <td>Event Post Title</td>
                <td><div align="center">:</div></td>
                <td><input name="tittle" type="text" id="tittle" size="37" value="<?PHP echo $rows['tittle']; ?>"/></td>
                </tr>
              <tr>
                <td>Your Name</td>
                <td><div align="center">:</div></td>
                <td><input name="author" type="text" id="author" size="37" value="<?PHP echo $rows['author']; ?>"/></td>
                </tr>
              <tr>
                <td valign="top">Your Post</td>
                <td valign="top"><div align="center">:</div></td>
                <td><textarea name="post" cols="45" rows="12" id="post"><?PHP echo $rows['post']; ?></textarea></td>
                </tr>
              <tr>
                <td>Date</td>
                <td><div align="center">:</div></td>
                <td><input name="date" type="text" id="date" size="37" value="<?PHP echo $rows['date']; ?>"/></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td><input type="submit" name="submit" id="submit" value="Update Sport" /></td>
              </tr>

        </table></td>
      </tr>
    </table>
  </form>

This is the other php page where I have my update script:

require("mydatabase.php");
$id_fromclick=$_POST['id'];
$tittle=$_POST['tittle'];
$author=$_POST['author'];
$post=$_POST['post'];
$date=$_POST['date'];
$query="UPDATE mydatabase SET tittle='$tittle',author='$author',post='$post',date='$date' WHERE id = '$id_fromclick'";
mysql_query($query);
mysql_close();