1
Off-Topic / fucking PHP / mysql
« on: April 07, 2014, 12:50:40 pm »
Hey guys, i've been programming a lot the last few weeks but now i've hit a bump.
i'm making a page where i can update the records. I get the info from other tables which i can select from a dropdown menu, everything works fine but the table doesn't update it. what is the problem here?
[spoiler]<?php
include("inc_login.php");
include("inc_amerijck.php");
if(ISSET($_POST['Bevestiging'])) {
//query samenstellen
$query= "UPDATE computer SET
Locatie = ' ". $_POST['computer_locatie'] . " ',
Softwarepakket = ' ". $_POST['softwarepakket'] . " ',
Moederbord = ' ". $_POST['moederbord'] . " ' ,
Geheugen = ' ". $_POST['geheugen'] . " ' ,
Processor = ' ". $_POST['processor'] . " ' ,
Harde schijf = ' ". $_POST['hardeschijf'] . " '
WHERE id=" . $_POST['id'];
$sql = "INSERT INTO computer(`computer_locatie`, `pcsoftware_id`, `m_omschrijving`, `g_omschrijving`, `p_omschrijving`, `h_omschrijving`) VALUES ([computer_locatie],[softwarepakket],[moederbord],[geheugen],[processor],[hardeschijf]) FROM pcsoftware, moederbord, geheugen, processor";
$result = mysql_query($sql);
echo ('De volgende opdracht is uitgevoerd:<br>' . $query . '<br>');
if ($result == TRUE); {
echo ('Record nummer: ' . $_POST['id'] . ' is bijgewerkt<br>');
echo("<a href = \"overzicht.php\">Terug naar het overzicht</a>");
}}
else{
//pagina heeft zichzelf niet aangeroepen
//formulier tonen om gegevens te bewerken
$query="SELECT * FROM computer WHERE computer_id= ". $_GET['id'];
$result= mysql_query($query, $db) or die ('FOUT: werkt niet');
?>
<html>
<body>
<div align=center>
<table border =1 width= 360>
<td>
<div align=center><h2> Wijzig deze gegevens </h2></div>
<hr>
<?php
//gegevens ophalen en toekennen aan tijdelijke variabelen
while ($rij = mysql_fetch_array($result)){
$clo = $rij['computer_locatie'];
}?>
<form action="<?php echo ($_SERVER['PHP_SELF']);?>" method = 'post'>
<input type="hidden" name="Bevestiging" value="1">
<input type="hidden" name="id" value="<?php echo ($_GET["id"]);?>">
<div align =center>
<table>
<tr><td>Locatie:</td><td> <input type="text" name="computer_locatie"
value="<?php echo($clo);?>" size="20"></td></tr>
<tr><td>Softwarepakket:</td><td>
<?php function softwarepakket(){
$result = mysql_query("SELECT * FROM pcsoftware");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['pcsoftware_id'] . '">'. $record['pcsoftware_id'] . '</option>';
}
}
?>
<select name="softwarepakket">
<?php softwarepakket() ?>
</select>
<?php? close() ?>
<tr><td>Moederbord:</td><td>
<?php function moederbord(){
$result = mysql_query("SELECT * FROM moederbord");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['m_omschrijving'] . '">'. $record['m_omschrijving'] . '</option>';
}
}
?>
<select name="moederbord">
<?php moederbord() ?>
</select>
<?php? close() ?>
<tr><td>Geheugen:</td><td>
<?php function geheugen(){
$result = mysql_query("SELECT * FROM geheugen");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['g_omschrijving'] . '">'. $record['g_omschrijving'] . '</option>';
}
}
?>
<select name="geheugen">
<?php geheugen() ?>
</select>
<?php? close() ?>
<tr><td>Processor:</td><td>
<?php function processor(){
$result = mysql_query("SELECT * FROM processor");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['p_omschrijving'] . '">'. $record['p_omschrijving'] . '</option>';
}
}
?>
<select name="processor">
<?php processor() ?>
</select>
<?php? close() ?>
<tr><td>Harde schijf:</td><td>
<?php function hardeschijf(){
$result = mysql_query("SELECT * FROM harde_schijf");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['h_omschrijving'] . '">'. $record['h_omschrijving'] . '</option>';
}
}
?>
<select name="hardeschijf">
<?php hardeschijf() ?>
</select>
<?php? close() ?>
</table>
</div>
<div align=center>
<?php
//if(isset($_POST[$result])){
//$sql = "INSERT INTO computer(`computer_locatie`, `pcsoftware_id`, `m_omschrijving`, `g_omschrijving`, `p_omschrijving`, `h_omschrijving`) VALUES ([computer_locatie],[softwarepakket],[moederbord],[geheugen],[processor],[hardeschijf])";
//$result = mysql_query($sql);
//}
//?>
<input type="Submit" value="Bijwerken" action="<?php $result ?>">
<input type="Button" value="Terug" onclick="javascript:history.back();">
</form>
</div>
</td>
</table>
</div>
<?php
//else blok afsluiten
}
?>
</body>
</html>[/spoiler
i'm making a page where i can update the records. I get the info from other tables which i can select from a dropdown menu, everything works fine but the table doesn't update it. what is the problem here?
[spoiler]<?php
include("inc_login.php");
include("inc_amerijck.php");
if(ISSET($_POST['Bevestiging'])) {
//query samenstellen
$query= "UPDATE computer SET
Locatie = ' ". $_POST['computer_locatie'] . " ',
Softwarepakket = ' ". $_POST['softwarepakket'] . " ',
Moederbord = ' ". $_POST['moederbord'] . " ' ,
Geheugen = ' ". $_POST['geheugen'] . " ' ,
Processor = ' ". $_POST['processor'] . " ' ,
Harde schijf = ' ". $_POST['hardeschijf'] . " '
WHERE id=" . $_POST['id'];
$sql = "INSERT INTO computer(`computer_locatie`, `pcsoftware_id`, `m_omschrijving`, `g_omschrijving`, `p_omschrijving`, `h_omschrijving`) VALUES ([computer_locatie],[softwarepakket],[moederbord],[geheugen],[processor],[hardeschijf]) FROM pcsoftware, moederbord, geheugen, processor";
$result = mysql_query($sql);
echo ('De volgende opdracht is uitgevoerd:<br>' . $query . '<br>');
if ($result == TRUE); {
echo ('Record nummer: ' . $_POST['id'] . ' is bijgewerkt<br>');
echo("<a href = \"overzicht.php\">Terug naar het overzicht</a>");
}}
else{
//pagina heeft zichzelf niet aangeroepen
//formulier tonen om gegevens te bewerken
$query="SELECT * FROM computer WHERE computer_id= ". $_GET['id'];
$result= mysql_query($query, $db) or die ('FOUT: werkt niet');
?>
<html>
<body>
<div align=center>
<table border =1 width= 360>
<td>
<div align=center><h2> Wijzig deze gegevens </h2></div>
<hr>
<?php
//gegevens ophalen en toekennen aan tijdelijke variabelen
while ($rij = mysql_fetch_array($result)){
$clo = $rij['computer_locatie'];
}?>
<form action="<?php echo ($_SERVER['PHP_SELF']);?>" method = 'post'>
<input type="hidden" name="Bevestiging" value="1">
<input type="hidden" name="id" value="<?php echo ($_GET["id"]);?>">
<div align =center>
<table>
<tr><td>Locatie:</td><td> <input type="text" name="computer_locatie"
value="<?php echo($clo);?>" size="20"></td></tr>
<tr><td>Softwarepakket:</td><td>
<?php function softwarepakket(){
$result = mysql_query("SELECT * FROM pcsoftware");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['pcsoftware_id'] . '">'. $record['pcsoftware_id'] . '</option>';
}
}
?>
<select name="softwarepakket">
<?php softwarepakket() ?>
</select>
<?php? close() ?>
<tr><td>Moederbord:</td><td>
<?php function moederbord(){
$result = mysql_query("SELECT * FROM moederbord");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['m_omschrijving'] . '">'. $record['m_omschrijving'] . '</option>';
}
}
?>
<select name="moederbord">
<?php moederbord() ?>
</select>
<?php? close() ?>
<tr><td>Geheugen:</td><td>
<?php function geheugen(){
$result = mysql_query("SELECT * FROM geheugen");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['g_omschrijving'] . '">'. $record['g_omschrijving'] . '</option>';
}
}
?>
<select name="geheugen">
<?php geheugen() ?>
</select>
<?php? close() ?>
<tr><td>Processor:</td><td>
<?php function processor(){
$result = mysql_query("SELECT * FROM processor");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['p_omschrijving'] . '">'. $record['p_omschrijving'] . '</option>';
}
}
?>
<select name="processor">
<?php processor() ?>
</select>
<?php? close() ?>
<tr><td>Harde schijf:</td><td>
<?php function hardeschijf(){
$result = mysql_query("SELECT * FROM harde_schijf");
while ($record = mysql_fetch_array($result)){
echo '<option value="' . $record['h_omschrijving'] . '">'. $record['h_omschrijving'] . '</option>';
}
}
?>
<select name="hardeschijf">
<?php hardeschijf() ?>
</select>
<?php? close() ?>
</table>
</div>
<div align=center>
<?php
//if(isset($_POST[$result])){
//$sql = "INSERT INTO computer(`computer_locatie`, `pcsoftware_id`, `m_omschrijving`, `g_omschrijving`, `p_omschrijving`, `h_omschrijving`) VALUES ([computer_locatie],[softwarepakket],[moederbord],[geheugen],[processor],[hardeschijf])";
//$result = mysql_query($sql);
//}
//?>
<input type="Submit" value="Bijwerken" action="<?php $result ?>">
<input type="Button" value="Terug" onclick="javascript:history.back();">
</form>
</div>
</td>
</table>
</div>
<?php
//else blok afsluiten
}
?>
</body>
</html>[/spoiler