Author Topic: fucking PHP / mysql  (Read 1689 times)

0 Members and 1 Guest are viewing this topic.

Offline broodjehamburger

  • Posts: 64
    • View Profile
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
« Last Edit: April 07, 2014, 02:25:17 pm by broodjehamburger »