|
|
Posted by Siong.Ong on 04/02/07 01:19
Dear all,
my PHP aims to update a MySQL database by selecting record
one by one and modify then save.
Here are my PHP, but I found that it doesnt work as it supposed to be,
for example, when Record (i) is shown and modified, the change will
come to Record (i+1).
Can anyone provide suggestion?
thanks.
<?php
$connect = mysql_connect("andy","kiong","Password")or
die("Could not connect : " . mysql_error()); ;
mysql_select_db("kiong_userinfo",$connect)or die("Could not
connect : " . mysql_error());
$result = mysql_query("SELECT * FROM putonServer where id2=1",
$connect);
printf("%s<br>\n", mysql_result($result,0,"body"));
?>
<table width="556" height="70" border="0"
align="center">
<tr>
<td width="59" height="66"> </td>
</tr>
</table>
<p align="center">
<?php
$this_id=mysql_result($result,0,"id");
$next_id=$this_id+1;
$cat=mysql_result($result,0,"category");
$newline = "<br />";
if($cat==1)
{
echo "Process".$newline;
echo $newline;
}elseif($cat==2)
{
echo "Product".$newline;
echo $newline;
}else{
echo "People".$newline;
echo $newline;
}
$ori=mysql_result($result,0,"orientation");
echo "$ori";
?>
<?php
$connect = mysql_connect("Server","kiong","Password")or
die("Could not connect : " . mysql_error());
$db_selected = mysql_select_db("kiong_userinfo",
$connect);
if (!$db_selected) {
die ('Can\'t use foo : ' . mysql_error());
}
if($_POST[B2]){
$query_B2 ="UPDATE putonServer SET
category='$_POST[R2]',orientation='$_POST[sliderinput22]' where
id='$this_id'";
echo $this_id.$newline;
$result_B2=mysql_query($query_B2,$connect);
if (!$result_B2) {
die ('Puke, Wrong2 ' . mysql_error());
}
$query_B2_1="update putonServer SET id2=4 where
id='$this_id'";
echo $this_id.$newline;
$query_B2_2="update putonServer SET id2=1 where
id='$next_id'";
echo $this_id.$newline;
$result_B2_2=mysql_query($query_B2_2,$connect);
if (!$result_B2_2) {
die ('Puke, Wrong ' . mysql_error());
}
$result_B2_1=mysql_query($query_B2_1,$connect);
if (!$result_B2_1) {
die ('Puke, Wrong2 ' . mysql_error());
}
}elseif($_POST[B0]){
$query_B0="update putonServer SET id2=7 where id='$this_id'";
$query_B0_2="update putonServer SET id2=1 where
id='$next_id'";
$result_B0=mysql_query($query_B0,$connect);
if (!$result_B0) {
die ('Puke, Wrong2 ' . mysql_error());
}
$result_B0_2=mysql_query($query_B0_2,$connect);
if (!$result_B0_2) {
die ('Puke, Wrong ' . mysql_error());
}
}elseif($_POST[B1]){
$query_B1="update putonServer SET id2=0 where id='$this_id'";
$query_B1_2="update putonServer SET id2=1 where
id='$next_id'";
$result_B1=mysql_query($query_B1,$connect);
if (!$result_B1) {
die ('Puke, Wrong2 ' . mysql_error());
}
$result_B1_2=mysql_query($query_B1_2,$connect);
if (!$result_B1_2) {
die ('Puke, Wrong ' . mysql_error());
}
}
?>
[Back to original message]
|