Meerder Sql gegevens aanpassen

Door Van de Putte op 16-05-2009 12:22

769 views

Hallo,

Ik zou graag meerdere gegevens tegelijkertijd kunnen aanpassen uit mijn database en heb hiervoor reeds volgend script, maar geeft steeds een parse error op <imput type="hidden"> Hopelijk kan iemand me verder helpen, ik ben evenwel nog een beginner met php.
Ik kan natuurlijk ook PhpMyEdit gebruiken, maar het mag eenvoudiger.
Alvast bedankt voor jullie professionele hulp.


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>


<?php
include("header.html");
require_once('mysql_connect.inc.php');
// Databaseverbinding openen met mysql_connect():
$verbinding = mysql_connect(MYSQL_SERVER, MYSQL_GEBRUIKERSNAAM, MYSQL_WACHTWOORD) or die("Verbinding mislukt: " . mysql_error());

// Database 'test' selecteren:
mysql_select_db("adreslijst") or die("Kon de database niet openen: " . mysql_error() );
$mysql_id=mysql_connect("$dbhost","$dbuser","$dbpass");
$sql="select * from adressen";
$res=mysql_db_query("$db","$sql",$mysql_id);
    $fout=mysql_errno($mysql_id);
        if ($fout != 0) {
        $fout=mysql_error($mysql_id);
        echo '<font color="#FF2306">' . $fout . '</font>';
        mysql_close($mysql_id);
        echo '</body></html>';
        exit;
        }
$aantal_lijnen=mysql_num_rows($res);
$aantal_velden=mysql_num_fields($res);
echo "<br><br>";
echo '<table border=2 celpadding=2 width="100%">';
for($i=0;$i<$aantal_velden;$i++) {
    printf("<th bgcolor=\"orange\">%s</th>",mysql_field_name($res,$i));
    }
    echo "<th bgcolor=\"orange\">Update</th>";        
for($i=0;$i<$aantal_lijnen;$i++) {
    $row=mysql_fetch_row($res);
    echo '<tr>';
    foreach($row as $col) {
        $upid=$row[0];                             
        if(!$col) $col="&nbsp;";
        echo "<td>$col</td>";
    }
    echo "<td><a href=\"aanpassen.php?upid=$upid\">Update</a></td></tr>"; 
    }
echo "</table>";
echo '<br><br>';
mysql_close($mysql_id);
$upid=$_GET[upid];
if(isset($upid)) {
    $mysql_id=mysql_connect("$dbhost","$dbuser","$dbpass");
    $sql="select * from adressen where id=$upid";
    $res=mysql_db_query("$db","$sql",$mysql_id);
    $row=mysql_fetch_row($res); 
	
    
	$upid=$_GET[upid];
if(isset($upid)) {
    $mysql_id=mysql_connect("$dbhost","$dbuser","$dbpass");
    $sql="select * from adressen where id=$upid";
    $res=mysql_db_query("$db","$sql",$mysql_id);
    $row=mysql_fetch_row($res); 
    ?>
    
	<form action="<?php echo $_SERVER[PHP_SELF];?>" method="post">
    <table>
    <tr><td>Naam :</td><td><input type="text" name="naam" value="<?php echo $row[1];?>"></td></tr>
    <tr><td>Vooraam :</td><td><input type="text" name="voornaam" value="<?php echo $row[2];?>"></td></tr>
    <tr><td>Straat :</td><td><input type="text" name="straat" value="<?php echo $row[3];?>"></td></tr>
    <tr><td>Nummer :</td><td><input type="text" name="nummer" value="<?php echo $row[4];?>"></td></tr>
    <tr><td>Postcode :</td><td><input type="text" name="postcode" value="<?php echo $row[5];?>"></td></tr>
    <tr><td>Plaats :</td><td><input type="text" name="plaats" value="<?php echo $row[6];?>"></td></tr>
    <tr><td>Telefoon thuis :</td><td><input type="text" name="telefoon_thuis" value="<?php echo $row[7];?>"></td></tr>
    <tr><td>Telefoon werk :</td><td><input type="text" name="telefoon_werk" value="<?php echo $row[8];?>"></td></tr>
    <tr><td>Gsm 1 :</td><td><input type="text" name="gsm_1" value="<?php echo $row[9];?>"></td></tr>
    <tr><td>Gsm 2 :</td><td><input type="text" name="gsm_2" value="<?php echo $row[10];?>"></td></tr>
    <tr><td>E-mail :</td><td><input type="text" name="email" value="<?php echo $row[11];?>"></td></tr>
<tr><td><input type="hidden" name="upid" value="<?php echo $upid;?>"></td></tr>
    <tr><td>&nbsp;</td><td>&nbsp;</td></tr>
    <tr><td><input type="submit" name="updaten" value="Gegevens updaten"></td></tr>
    </table>
    </form>
	
<?php
mysql_close($mysql_id);
}
else {

<input type="hidden">
}

mysql_close($mysql_id);

?>

   
</body>
</html>