mysql php update submission error

Asked Jan 16 '16 at 13:25

Active Jan 16 '16 at 13:33

Viewed 17 times

here is my update link

editprofile.php?no=abc

and link us

<a href="editprofile.php?no=<?php echo $row['no'];?>">edit</a>

I need to change the name base on this row no

the php code is

<?php
if (isset($_POST['submit']))
{
$dbhost = '';
$dbuser = '';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
   $no=$_GET['no'];
   $name=$_POST['name'];

$sql = "UPDATE tabel_name
    SET name='$name'
    WHERE no='$no'";

mysql_select_db('database_name');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not update data: ' . mysql_error());
}
echo "Updated data successfully\n";
mysql_close($conn);
}
?>

<form>
<input id="edit" name="name" value="">
<input type="submit" value="submit" name="submit">
</form>

so I need to know how to change the name with new name based on no, I mean it goes to the row, based on no and rewrite the name based on new input name and redirect to the base page. The form is ok, but when I click in the link or press submit, it gives a blank entry in mysql field of name. If there is any data before edit, it rewrite and give a blank value.

edited Jan 16 '16 at 13:33

asked Jan 16 '16 at 13:25

Shuvo Shuvo

1

*Code Full Of Errors* Dusty. – Nana Partykar Jan 16 '16 at 13:29
Where is `` ? And, please don't say it is typo mistake. – Nana Partykar Jan 16 '16 at 13:30
ow it was writing problem, sorry – Shuvo Shuvo Jan 16 '16 at 13:33
You really shouldn't use the deprecated mysql_*-functions. Your code is also wide-open for SQL-injections. There goes your database! – M. Eriksson Jan 16 '16 at 13:33
3

Where is `method="POST"` in `
` ?
– Nana Partykar Jan 16 '16 at 13:34
Please do not use `msql` functions to connect to the database. These functions are deprecated since PHP 5.5 and removed in PHP 7. Try using PDO or mysqli instead. For more info : http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php?rq=1 – YounesM Jan 16 '16 at 13:38
1

yeah, its working now.....@Nana Partykar – Shuvo Shuvo Jan 16 '16 at 13:39
*You only solved your problem.* Good. @ShuvoShuvo – Nana Partykar Jan 16 '16 at 13:40

mysql php update submission error

0 Answers0