not updateed

Question

psathish2 -6 Junior Poster in Training

15 Years Ago

this is my code here i selected record from db and putted that 2 text box . but i modify the recored to store the db. below the code not working .

<?php

$jtitle=$_GET;
echo $jtitle;
$desc=$_GET;
echo $desc;
$hostname="localhost";
$username="cds";
$password="cds";
$dbid="cdsemplo_job";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("not connected");
$result=mysql_query("select * from job where jobtite='$jtitle'");

while($row=mysql_fetch_row($result))
{
$j1=$row[1];
$j2=$row[2];
}

if(isset($_REQUEST))
{
$jtit=$_GET;
echo $jtit;
$desc1=$_GET;
echo $desc1;
mysql_close($link);
mysql_query("update job set jobtite = '$jtitle'");
}
?>
<html>
<body align="center" left="20px" right="20px" bgcolor="#fffff">
<form method="post" action="edit.php">
<center>
<table>
<br>
<tr>
<center><tr>Employement Form</tr></center>
</tr>
<br>
<tr><td> JobTitle </td><td><input type="text" name="jobname" value="<? echo $j1; ?>"></td></tr>
<tr><td> JobDescription </td><td><input type="text" name="jdesc" value="<? echo $j2; ?>"></td></tr>
<center><tr><td> </td><td><input type="submit" name=update value="Update" width="20"></td></tr></center>
<?php

$hostname="localhost";
$username="cds";
$password="cds";
$dbid="cdsemplo_job";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("not connected");

mysql_close($link);
?>
</p>
</table>
</center>
</form>
</body>

php

3 Contributors
8 Replies
178 Views
1 Day Discussion Span
Latest Post 15 Years Ago Latest Post by nav33n

All 8 Replies

nav33n 472 Purple hazed!

15 Years Ago

mysql_close($link) before the update query.

Btw, You don't have a condition for your update query. This will update all the records in the table and set jobtite to the value that you have entered.

P.S. Next time, please wrap your codes within code-tags.

Edited 11 Years Ago by mike_2000_17 because: Fixed formatting

nav33n 472 Purple hazed!

15 Years Ago

Umm.. I guess you didn't read my post.. Wrap your code in code-tags.. AND

mysql_close($link);
mysql_query("update job set jobtite = '$jtitle'");

Edited 11 Years Ago by mike_2000_17 because: Fixed formatting

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

psathish2 -6 Junior Poster in Training · Answer 1 · 2008-06-24T13:27:57+00:00

this full code.........

<?php

$jtitle=$_GET;
echo $jtitle;
$desc=$_GET;
echo $desc;
$hostname="localhost";
$username="cds";
$password="cds";
$dbid="cdsemplo_job";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("not connected");
$result=mysql_query("select * from job where jobtite='$jtitle'");

while($row=mysql_fetch_row($result))
{
$j1=$row[1];
$j2=$row[2];
}

if(isset($_REQUEST))
{
$jtit=$_GET;
echo $jtit;
$desc1=$_GET;
echo $desc1;
mysql_close($link);
mysql_query("update job set jobtite = '$jtitle'");
}
?>
<html>
<body align="center" left="20px" right="20px" bgcolor="#fffff">
<form method="post" action="edit.php">
<center>
<table>
<br>
<tr>
<center><tr>Employement Form</tr></center>
</tr>
<br>
<tr><td> JobTitle </td><td><input type="text" name="jobname" value="<? echo $j1; ?>"></td></tr>
<tr><td> JobDescription </td><td><input type="text" name="jdesc" value="<? echo $j2; ?>"></td></tr>
<center><tr><td> </td><td><input type="submit" name=update value="Update" width="20"></td></tr></center>

</p>
</table>
</center>
</form>
</body>

R0bb0b 344 Posting Shark · Answer 2 · 2008-06-24T14:54:53+00:00

BTW: There's nothing wrong with opening a db connection at the top of the script, leaving it open for the rest of your queries and then closing it at the end of your script. It a lot less messy and you are a lot less worried about juggling connections.

psathish2 -6 Junior Poster in Training · Answer 3 · 2008-06-24T15:00:08+00:00

it not working ....

<?php

$jtitle=$_GET;
echo $jtitle;
$desc=$_GET;
echo $desc;
$hostname="localhost";
$username="cds";
$password="cds";
$dbid="cdsemplo_job";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("not connected");
$result=mysql_query("select * from job where jobtite='$jtitle'");

while($row=mysql_fetch_row($result))
{
$j1=$row[1];
$j2=$row[2];
}

mysql_close($link);

}
?>
<html>
<body align="center" left="20px" right="20px" bgcolor="#fffff">
<form method="post" action="edit.php">
<center>
<table>
<br>
<tr>
<center><tr>Employement Form</tr></center>
</tr>
<br>
<tr><td> JobTitle </td><td><input type="text" name="jobname" value="<? echo $j1; ?>"></td></tr>
<tr><td> JobDescription </td><td><input type="text" name="jdesc" value="<? echo $j2; ?>"></td></tr>
<center><tr><td> </td><td><input type="submit" name=update value="Update" width="20"></td></tr></center>
<?php

$jtitle=$_GET;
echo $jtitle;
$desc=$_GET;
echo $desc;
$hostname="localhost";
$username="cds";
$password="cds";
$dbid="cdsemplo_job";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("not connected");
if(isset($_REQUEST))
{
$jtit=$_GET;
echo $jtit;
$desc1=$_GET;
echo $desc1;
mysql_query("update job set jobtite = '$jtitle'");
?>

</p>
</table>
</center>
</form>
</body>
</html>

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 4 · 2008-06-24T15:01:08+00:00

nav33n 472 Purple hazed!

15 Years Ago

nevermind.

psathish2 -6 Junior Poster in Training · Answer 5 · 2008-06-25T10:38:12+00:00

thank you every one

i got solution below the code

<?php

$jtitle=$_GET;

$hostname="localhost";
$username="cds";
$password="cds";
$dbid="cdsemplo_job";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("not connected");
$result=mysql_query("select * from job where jobtite='$jtitle'");

while($row=mysql_fetch_row($result))
{
$j1=$row[1];
$j2=$row[2];
}

if(isset($_REQUEST))
{
$jtitle=$_REQUEST;
$jtitle1=$_REQUEST;
echo $jtitle;
echo "\n";
echo $jtitle1;
$desc=$_REQUEST;
echo $desc;
echo "\n";
mysql_query("update job set jobtite ='$jtitle',jobdesc='$desc' where jobtite='$jtitle1'");
}

mysql_close($link);

?>

<html>
<body align="center" left="20px" right="20px" bgcolor="#fffff">
<form method="post" action="edit.php">
<center>
<table>
<br>
<tr>
<center><tr>Employement Form</tr></center>
</tr>
<br>
<tr><td> JobTitle </td><td><input type="text" name="jobname" value="<? echo $j1; ?>">
<input type="hidden" name="jobname1" value="<? echo $j1; ?>"></td></tr>
<tr><td> JobDescription </td><td><input type="text" name="jdesc" value="<? echo $j2; ?>"></td></tr>
<center><tr><td> </td><td><input type="submit" name=update value="Update" width="20"></td></tr></center>

</p>
</table>
</center>
</form>
</body>
</html>

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 6 · 2008-06-25T11:23:17+00:00

nav33n 472 Purple hazed!

15 Years Ago

Phew! Congrats !

not updateed

Recommended Answers Collapse Answers

All 8 Replies

Recommended Answers