update sql

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 455,974 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,766 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 2008 | Replies: 4 | Solved

•

Join Date: Nov 2007

Posts: 99

Reputation: kings is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

kings

Offline

Junior Poster in Training

update sql

Nov 28th, 2007

hi
i am not able to update my table.plz do tell me the bug in my code.....
when update link is clicked in the first page..the table should get updated
page 1
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");

$x = $_GET['name'];
$result=mysql_query("SELECT * FROM table1 where name='$x'") or die("ERROR:".mysql_error());
for ($i = 0; $i < mysql_num_rows($result); ++$i)
{
$x= mysql_fetch_row($result);

print 'Name<input type="text" maxlength="19" size="53" name="name" value="'.$x[0].'" />';
print "<a href='page2.php?name=".$x[0]."'>Update</a>";
}
mysql_close($link);

page 2

$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$name1 = $_GET['name'];
mysql_query("UPDATE table1 SET name='$name' where name='$name1'") or die("ERROR:".mysql_error());
echo "thanks";
mysql_close($link);

•

Join Date: Aug 2007

Location: Cavite,Philippines

Posts: 508

Reputation: ryan_vietnow is an unknown quantity at this point

Rep Power: 3

Solved Threads: 68

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: update sql

Nov 28th, 2007

i think it's here:

mysql_query("UPDATE table1 SET name='$name' where name='$name1'")

should be:

mysql_query("UPDATE table1 SET name='$name1' where name='$name1'")

"death is the cure of all diseases..."
http://ryantetek.wordpress.com

•

Join Date: Nov 2007

Posts: 99

Reputation: kings is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

kings

Offline

Junior Poster in Training

Re: update sql

Nov 28th, 2007

now there is no bug but it is not getting updated

•

Join Date: Aug 2007

Posts: 10

Reputation: ruman_eee is an unknown quantity at this point

Rep Power: 2

Solved Threads: 1

ruman_eee

Offline

Newbie Poster

Re: update sql

Dec 4th, 2007

I think this will help you:

$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid,$link) or die("unable to connect");

$x = $_GET['name'];
$result=mysql_query("SELECT * FROM table1 where name='$x'") or die("ERROR:".mysql_error());

$x=mysql_fetch_array($result);
if($x[0]!=null){

echo $x[0];
or,
printf($x[0]);
}

then write the update code .

•

Originally Posted by kings

hi
i am not able to update my table.plz do tell me the bug in my code.....
when update link is clicked in the first page..the table should get updated
page 1
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");

$x = $_GET['name'];
$result=mysql_query("SELECT * FROM table1 where name='$x'") or die("ERROR:".mysql_error());
for ($i = 0; $i < mysql_num_rows($result); ++$i)
{
$x= mysql_fetch_row($result);

print 'Name<input type="text" maxlength="19" size="53" name="name" value="'.$x[0].'" />';
print "<a href='page2.php?name=".$x[0]."'>Update</a>";
}
mysql_close($link);

page 2

$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$name1 = $_GET['name'];
mysql_query("UPDATE table1 SET name='$name' where name='$name1'") or die("ERROR:".mysql_error());
echo "thanks";
mysql_close($link);

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,098

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 240

nav33n

Offline

Posting Sensei

Re: update sql

Dec 4th, 2007

why would it update when you are not changing anything ? You should have a form to make the changes. Here, you are just fetching the record from the table, putting it in a textbox, then giving a link with the same value. Try this instead.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php  //page1.php
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$x = $_GET['name'];
$result=mysql_query("SELECT * FROM table1 where name='$x'") or die("ERROR:".mysql_error());
$row=mysql_fetch_array($result,MYSQL_ASSOC); //since it returns only 1 row.
print '<form method="POST" action="page2.php">';
print '<input type="hidden" name="oldname" value="'.$x.'">';
print 'Name<input type="text" maxlength="19" size="53" name="name" value="'.$row['name'].'" />';
print '<input type="submit" name="submit" value="Update">';
mysql_close($link);
?>
 
<?php //page2.php
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$old_name=$_POST['oldname'];
$new_name=$_POST['name'];
mysql_query("UPDATE table1 SET name='$new_name' where name='$old_name'") or die("ERROR:".mysql_error());
echo "thanks";
mysql_close($link);
?>
<?php  //page1.php
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$x = $_GET['name'];
$result=mysql_query("SELECT * FROM table1 where name='$x'") or die("ERROR:".mysql_error());
$row=mysql_fetch_array($result,MYSQL_ASSOC); //since it returns only 1 row.
print '<form method="POST" action="page2.php">';
print '<input type="hidden" name="oldname" value="'.$x.'">';
print 'Name<input type="text" maxlength="19" size="53" name="name" value="'.$row['name'].'" />';
print '<input type="submit" name="submit" value="Update">';
mysql_close($link);
?>

<?php //page2.php
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");
$old_name=$_POST['oldname'];
$new_name=$_POST['name'];
mysql_query("UPDATE table1 SET name='$new_name' where name='$old_name'") or die("ERROR:".mysql_error());
echo "thanks";
mysql_close($link);
?>

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*