Quick Question
kan je dat gebruiken ???
want ik moet meerdere databases vernieuwen dus wil ze in een rij zetten,
dus zeg maar
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
<?
if ( @mysql_query('UPDATE kmemo SET info = \''.$memo.'\' WHERE memoid = \''.$memoid.'\'') )
and if (nog een update query)
{
dan dit
}
else
if ( @mysql_query('UPDATE kmemo SET info = \''.$memo.'\' WHERE memoid = \''.$memoid.'\'') )
and if (nog een update query)
{
dan dit
}
else
Gewijzigd op 14/06/2004 11:52:00 door P.v.Denzel
en
bij die andere dat
dan wil ik die
anders
laat dan maar zitten
Snap je het nog....???
Gebruik je dus && voor ;) Als je OF wil doen isset ||.. Super no0b maak je waar peter :D
Gewijzigd op 14/06/2004 12:40:00 door P.v.Denzel
ik denk dat peter elsif bedoeld.
Code (php)
Voor de rip-puristen onder ons: dit is gejat uit de GPL gelicenceerde handleiding van www.php.net; zie ook de copyright informatie aldaar.
Gewijzigd op 14/06/2004 12:55:00 door Arend a
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
include "connect.php";
$hard = "UPDATE khsid SET hsid = \''.$hsid.'\' WHERE hsid = \''.$hsid.'\' and relid = \''.$relid.'.'";
$comp = "UPDATE kcomponent SET hsid = \''.$hsid.'\' WHERE hsid = \''.$hsid.'\' and relid = \''.$relid.'.'";
$memo = "UPDATE kmemo SET hsid = \''.$hsid.'\' WHERE hsid = \''.$hsid.'\' and relid = \''.$relid.'.'";
if (( @mysql_query('$hard')) && ( @mysql_query('$comp')) && ( @mysql_query('$memo') ))
{
header('location: bedankt.htm');
exit;
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
include "connect.php";
$hard = "UPDATE khsid SET hsid = \''.$hsid.'\' WHERE hsid = \''.$hsid.'\' and relid = \''.$relid.'.'";
$comp = "UPDATE kcomponent SET hsid = \''.$hsid.'\' WHERE hsid = \''.$hsid.'\' and relid = \''.$relid.'.'";
$memo = "UPDATE kmemo SET hsid = \''.$hsid.'\' WHERE hsid = \''.$hsid.'\' and relid = \''.$relid.'.'";
if (( @mysql_query('$hard')) && ( @mysql_query('$comp')) && ( @mysql_query('$memo') ))
{
header('location: bedankt.htm');
exit;
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
Probleem is nu bijvoorbeeld als er geen memo aanwezig is dan wil hij hem toch updaten lijkt mij maar er zit niks in, gaat hij dan naar else???
if (( mysql_query('$hard') or die (mysql_error()))
dus nu even vragen hoe het wel moet...
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
include "connect.php";
$hard = "UPDATE khsid SET hsid = '$hsid' WHERE hsid = '$hsid' and relid = '$relid'";
$comp = "UPDATE kcomponent SET hsid = '$hsid' WHERE hsid = '$hsid' and relid = '$relid'";
$memo = "UPDATE kmemo SET hsid = '$hsid' WHERE hsid = '$hsid' and relid = '$relid'";
if (( mysql_query("$hard") or die (mysql_error())) && ( mysql_query("$comp") or die (mysql_error())) && ( mysql_query("$memo") or die (mysql_error() )))
{
header('location: bedankt.htm');
exit;
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
include "connect.php";
$hard = "UPDATE khsid SET hsid = '$hsid' WHERE hsid = '$hsid' and relid = '$relid'";
$comp = "UPDATE kcomponent SET hsid = '$hsid' WHERE hsid = '$hsid' and relid = '$relid'";
$memo = "UPDATE kmemo SET hsid = '$hsid' WHERE hsid = '$hsid' and relid = '$relid'";
if (( mysql_query("$hard") or die (mysql_error())) && ( mysql_query("$comp") or die (mysql_error())) && ( mysql_query("$memo") or die (mysql_error() )))
{
header('location: bedankt.htm');
exit;
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
weer veranderingen aan gebracht.... hij werkt bijna perfect gaat zelfs naar bedankt.htm maar hij heeft niks vernieuwt :S
zit er niks in dan weet je dat het daar door komt..
als er wel wat staat echo dan doe je nadat je de queries hebt gedefineerd:
echo "hard: " . $hard . "<P>";
echo "comp: " . $comp . "<P>";
echo "memo: " . $memo . "<P>";
Ga kijken wattie dan doet..
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?php
include "connect.php";
$hard = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$comp = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$memo = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
if (( mysql_query("$hard")) && ( mysql_query("$comp")) && ( mysql_query("$memo")))
{
echo "$hard <br> $comp <br> $memo";
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
include "connect.php";
$hard = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$comp = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$memo = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
if (( mysql_query("$hard")) && ( mysql_query("$comp")) && ( mysql_query("$memo")))
{
echo "$hard <br> $comp <br> $memo";
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
en hij spuugt uit
UPDATE khsid SET hsid = 'tekst' WHERE hsid = 'AISNB01=' and relid = '1000b'
UPDATE kcomponent SET hsid = 'tekst' WHERE hsid = 'AISNB01=' and relid = '1000b'
UPDATE kmemo SET hsid = 'tekst' WHERE hsid = 'AISNB01=' and relid = '1000b'
Gewijzigd op 14/06/2004 15:23:00 door P.v.Denzel
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?php
include "connect.php";
$sql1 = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$sql3 = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res1 = mysql_query($sql1)or die (mysql_error());
$res2 = mysql_query($sql2)or die (mysql_error());
$res3 = mysql_query($sql3)or die (mysql_error());
$resall = "$res1, $res2, $res3";
if ($resall)
{
echo "$hsid1 <br> $relid <br> $resall";
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
include "connect.php";
$sql1 = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$sql3 = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res1 = mysql_query($sql1)or die (mysql_error());
$res2 = mysql_query($sql2)or die (mysql_error());
$res3 = mysql_query($sql3)or die (mysql_error());
$resall = "$res1, $res2, $res3";
if ($resall)
{
echo "$hsid1 <br> $relid <br> $resall";
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
Nu lijkt het dat alles wel goed gaat want hij geeft dit aan
hoi
12345
1, 1, 1
wat betekend de 1???
hij veranderd dus helemaal niks in de database
Wie o wie kan me helpen
Sorry, ik dacht dat dit een quick question zou worden
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?
$sql1 = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res1 = mysql_query($sql1)or die (mysql_error());
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res2 = mysql_query($sql2)or die (mysql_error());
$sql3 = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res3 = mysql_query($sql3)or die (mysql_error());
?>
$sql1 = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res1 = mysql_query($sql1)or die (mysql_error());
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res2 = mysql_query($sql2)or die (mysql_error());
$sql3 = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res3 = mysql_query($sql3)or die (mysql_error());
?>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<? echo "<form action='hsgewijzigd.php?relid=$relid&hsid=$hsid$hsid1=$hsid1' method='post'>";
echo "<input type='text' name=hsid1 value='$_POST[hsid1]'><br><br>";
//etc
//en dan het wijzig gedeelte is
include "connect.php";
$sql1 = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res1 = mysql_query($sql1)or die (mysql_error());
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res2 = mysql_query($sql2)or die (mysql_error());
$sql3 = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res3 = mysql_query($sql3)or die (mysql_error());
$resall = "$res1, $res2, $res3";
if ($resall)
{
echo "$sql1<br>$sql2<br>$sql3<br>";
echo "$hsid1 <br> $relid <br> $resall";
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
echo "<input type='text' name=hsid1 value='$_POST[hsid1]'><br><br>";
//etc
//en dan het wijzig gedeelte is
include "connect.php";
$sql1 = "UPDATE khsid SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res1 = mysql_query($sql1)or die (mysql_error());
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res2 = mysql_query($sql2)or die (mysql_error());
$sql3 = "UPDATE kmemo SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
$res3 = mysql_query($sql3)or die (mysql_error());
$resall = "$res1, $res2, $res3";
if ($resall)
{
echo "$sql1<br>$sql2<br>$sql3<br>";
echo "$hsid1 <br> $relid <br> $resall";
}
else
{
echo "Er ging iets fout.";
echo "$hsid<br>";
echo "$relid";
}
?>
en dan komt eruit
UPDATE khsid SET hsid = 'WS03' WHERE hsid = 'WS01=' and relid = '12345'
UPDATE kcomponent SET hsid = 'WS03' WHERE hsid = 'WS01=' and relid = '12345'
UPDATE kmemo SET hsid = 'WS03' WHERE hsid = 'WS01=' and relid = '12345'
WS03
12345
1, 1, 1
Code (php)
1
2
3
4
5
2
3
4
5
<?
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
// heb ik van gemaakt
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE relid = '$relid'";
?>
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE hsid = '$hsid' and relid = '$relid'";
// heb ik van gemaakt
$sql2 = "UPDATE kcomponent SET hsid = '$hsid1' WHERE relid = '$relid'";
?>
nu doet hij het wel dus het zit hem in de hsid gedeelte maar wat???
Sorry voor de overlast