PHPhulp.nl PHPhulp.nl
35k+ leden Over PHPhulp Offerte opdracht Contact
r

update query met dropdown menu

Door ruud op 10-08-2007 18:24
231 views
ik heb een tabel gemaakt met daarin gegevens van foto's. Elke foto heeft als standaardwaarde bij 'status' een 'nee' staan, zodat die niet weergegeven wordt op mijn site. Nou ben ik bezig met een admin pagina waarmee ik de foto's kan bekijken voordat ze zichtbaar zijn op mijn site. Ik heb een dropdown menu gemaakt waarin je kan kiezen tussen 'ja' en 'nee'. Nou moet ik er nog een update query bij hebben zodat ik als ik 'ja' kies en dan op de knop 'wijzig' klik de status van de foto kan wijzigen. Ik heb al heel wat dingen op internet gezocht hierover, maar ik snap er niets van. Zou iemand kunnen helpen?

Hier het script: 

<?php 
    mysql_connect( "******", "******", "******" ); 
    mysql_select_db( "******" ); 
    
        error_reporting( E_ALL ^ E_NOTICE ); 
        
        $sql         = mysql_query( "SELECT * FROM foto ORDER BY id DESC" ); 
        $hoeveel    = mysql_num_rows( $sql );        
        $max        = 20; 
        $filter        = $hoeveel / $max;        
        $round        = ceil( $filter ); 
        $begin        = $_GET['page']; 
        
        
        
        if( !isset( $_GET['page'] ) or !$_GET['page'] ) 
            $begin = 0; 
        
        // begin bij de volgende $max foto's 
        $begin = $begin * $max; 
        
           $sql_ophalen = mysql_query( "SELECT 
                                        * 
                                     FROM 
                                         foto 
                                    WHERE status = 'nee' 

                                    ORDER BY id DESC 
                                    
                                     LIMIT ".$begin.", ".$max." 
                                    " ) or die( mysql_error() ); 
  

        
        $i = 0;        
            
            //$SelectLeden = mysql_query( "SELECT * FROM foto ORDER BY id DESC" ); 
            
            if( mysql_num_rows( $sql_ophalen ) > 0 ) 
            {    
                echo'<BR><table border="0" cellpadding="0" cellspacing="0">'; 
                
                while( $ObLid = mysql_fetch_assoc( $sql_ophalen ) ) 
                { 
                        echo'   <tr> 
    <td width="200" height="12" bgcolor="7b8a8f" class="style3" id="table_border8">ID '.$ObLid['id'].'</td> 
    <td height="12" bgcolor="7b8a8f"><div align="center" class="style3" id="table_border3">Toestel</div></td> 
    <td height="12" bgcolor="7b8a8f" class="style3"><div align="center" id="table_border2">Locatie en Datum</div></td> 
        <td rowspan="9" border="1" id="table_border2"><b>Status:</b><FONT color="red"><b> '.$ObLid['status'].'</b></FONT> 
        <p> 
        <select name="toestel" size="1" id="toestel" class="style9"> 
            <option>nee</option> 
                        <option>ja</option> 
</select> 
        
        
        
        </td> 
  </tr> 
  <tr> 
    <td rowspan="7" id="table_border4"><a href="http://www.jetphotosonline.nl/images/queue/'.$ObLid['bestandsnaam'].'" target="_blank" border="0" ><img src="http://www.jetphotosonline.nl/images/queue/'.$ObLid['bestandsnaam'].'" width="200" border="0"</a></td> 
    <td class="style5"><div align="left"><a href="index.php?p=zoek&trefwoord='.$ObLid['maat'].'">'.$ObLid['maat'].'</a></td> 
    <td class="style5" id="table_border7"><div align="left"><a href="index.php?p=zoek&trefwoord='.$ObLid['plaats'].'">'.$ObLid['plaats'].'</a></td> 
  </tr> 
  <tr> 
    <td height="19" class="style5"><div align="left"><a href="index.php?p=zoek&trefwoord='.$ObLid['toestel'].'">'.$ObLid['toestel'].'</a></td> 
    <td class="style5" id="table_border7"><div align="left">'.$ObLid['datum'].'</td> 
  </tr> 
  <tr> 
    <td></td> 
    <td id="table_border7"></td> 
  </tr> 
  <tr> 
    <td height="19" bgcolor="7b8a8f" class="style3" id="table_border5" height="12">Commentaar en Registratie </td> 
    <td bgcolor="7b8a8f" id="table_border5">&nbsp;</td> 
  </tr> 
  <tr> 
    <td height="41" colspan="2" valign="top" class="style6" id="table_border7"><div align="left"><b><a href="index.php?p=zoek&trefwoord='.$ObLid['reg'].'">'.$ObLid['reg'].'</a></B> -  '.$ObLid['commentaar'].'</td> 
  </tr> 
  <tr> 
    <td height="18" bgcolor="7b8a8f" class="style3" id="table_border6">Fotograaf:</td> 
    <td bgcolor="7b8a8f" id="table_border5">&nbsp;</td> 
  </tr> 
  <tr> 
    <td height="19" class="style5" ><div align="left">&copy; <a href="index.php?p=zoek&trefwoord='.$ObLid['naam'].'">'.$ObLid['naam'].'</a></td> 
    <td id="table_border7">&nbsp;</td> 
  </tr> 
    <tr> 
    <td bgcolor="7b8a8f" id="table_border">&nbsp;</td> 
    <td bgcolor="7b8a8f" id="table_border3">&nbsp;</td> 
    <td bgcolor="7b8a8f" id="table_border5">&nbsp;</td> 
  </tr> 
    <tr> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
  </tr>  <tr> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
    <td>&nbsp;</td> 
  </tr>'; 
                } 
                
                echo'</table>'; 
            } 
            else 
            { 
                echo'Er zijn geen fotos geplaatst.'; 
            } 
        
        
        $i    =    0; 
                
        while( $i <= $filter ) 
        { 
            echo "<a href='index.php?p=foto&page=".$i."'>" . $i . "</a> "; 
            
            $i++; 
        } 
            

 ?>
R
Rob
10-08-2007 19:41
Deze heb ik pas gebruikt voor zo'n zelfde toepassing:


if($_SERVER['REQUEST_METHOD'] == "POST"){
    if(isset($_POST['nummer']) != NULL){
        $sql="UPDATE
			foto
        SET
            status='ja'
        WHERE 
			nummer 
		IN (". implode(",",$_POST['ja']).")"; 

 if(!mysql_query($sql)){
           echo 'Er is een fout opgetreden: '.mysql_error();
           }
        else{
          if(mysql_affected_rows() > 1){
           echo 'Er zijn '.mysql_affected_rows().' rijen aangepast.';
           }
          else{
            echo 'Er is 1 rij aangepast.';
                }
            }


je zult misschien nog wat moeten spelen hiermee omdat ik wat variabelen heb aangepast.
r
ruud
10-08-2007 21:41
Ik heb nou een stukje toegevoegt, maar het werkt niet. Wat doe ik fout?


<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
#table_border8
{	border-left-style: solid;
	border-left-color: #000000;
	border-left-width: 1px;
	border-top-style: solid;
	border-top-color: #000000;
	border-top-width: 1px;
}

#table_border7
{
	border-right-style: solid;
	border-right-color:#000000;
	border-right-width: 1px;
}
#table_border6
{
	border-top-style: solid;
	border-top-color: #000000;
	border-top-width: 1px;
	border-bottom-style:solid;
	border-bottom-color:#000000;
	border-bottom-width: 1px;

}
#table_border5
{
	border-top-style: solid;
	border-top-color: #000000;
	border-top-width: 1px;
	border-bottom-style:solid;
	border-bottom-color:#000000;
	border-bottom-width: 1px;
		border-right-style: solid;
	border-right-color:#000000;
	border-right-width: 1px;

}
#table_border4
{
	border-left-style: solid;
	border-left-color: #000000;
	border-left-width: 1px;
	border-top-style: solid;
	border-top-color: #000000;
	border-top-width: 1px;
	border-right-style: solid;
	border-right-color:#000000;
	border-right-width: 1px;
	border-bottom-style:solid;
	border-bottom-color:#000000;
	border-bottom-width: 1px;

}
#table_border
{
	border-left-style: solid;
	border-left-color: #000000;
	border-left-width: 1px;
	border-bottom-style:solid;
	border-bottom-color:#000000;
	border-bottom-width: 1px;

}
#table_border2
{
	border-top-style: solid;
	border-top-color: #000000;
	border-top-width: 1px;
	border-right-style: solid;
	border-right-color:#000000;
	border-right-width: 1px;
		border-bottom-style:solid;
	border-bottom-color:#000000;
	border-bottom-width: 1px;

}
#table_border3
{
	border-top-style: solid;
	border-top-color: #000000;
	border-top-width: 1px;
		border-bottom-style:solid;
	border-bottom-color:#000000;
	border-bottom-width: 1px;
}
.style3 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
	color: #FFFFFF;
	font-weight: bold;
}
.style5 {font-size: 10px; color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif;}
.class1 {font-size: 10px; color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif;}
.class1 a:link {
	color: #000000;
	text-decoration: none;
}
.class1 a:visited {
	text-decoration: none;
	color: #000000;
}
.class1 a:hover {
	text-decoration: underline;
	color: #993333;
}
.class1 a:active {
	text-decoration: none;
	color: #000000;
}
-->
</style>
</head>

<body>
<span class="class1">
<table>
</table>
</span>
<?php
	mysql_connect( "localhost", "jetphotosonline", "shimanoro75" );
	mysql_select_db( "jetphotosonline" );
	
		error_reporting( E_ALL ^ E_NOTICE );
		
		$sql 		= mysql_query( "SELECT * FROM foto ORDER BY id DESC" );
		$hoeveel	= mysql_num_rows( $sql );		
		$max		= 20;
		$filter		= $hoeveel / $max;		
		$round		= ceil( $filter );
		$begin		= $_GET['page'];
		
		
		
		if( !isset( $_GET['page'] ) or !$_GET['page'] )
			$begin = 0;
		
		// begin bij de volgende $max foto's
		$begin = $begin * $max;
		
   		$sql_ophalen = mysql_query( "SELECT 
										* 
									 FROM 
									 	foto 
									WHERE status = 'nee'

									ORDER BY id DESC
									
									 LIMIT ".$begin.", ".$max."
									" ) or die( mysql_error() ); 
	
$query = "UPDATE 'foto' SET 'status' = '".$_POST['status1'] ."' WHERE id = '".$_POST['id']."'";
	
 

echo $query; 

  

		
		$i = 0;		
			
			//$SelectLeden = mysql_query( "SELECT * FROM foto ORDER BY id DESC" );
			
			if( mysql_num_rows( $sql_ophalen ) > 0 ) 
			{	
				echo'<BR><table border="0" cellpadding="0" cellspacing="0">';
				
				while( $ObLid = mysql_fetch_assoc( $sql_ophalen ) )



      mysql_query($query) or die (mysql_error());
				{
						echo'   <tr>
    <td width="200" height="12" bgcolor="7b8a8f" class="style3" id="table_border8">ID '.$ObLid['id'].'</td>
    <td height="12" bgcolor="7b8a8f"><div align="center" class="style3" id="table_border3">Toestel</div></td>
    <td height="12" bgcolor="7b8a8f" class="style3"><div align="center" id="table_border2">Locatie en Datum</div></td>
		<td rowspan="9" border="1" id="table_border2"><b>Status:</b><FONT color="red"><b> '.$ObLid['status'].'</b></FONT>
		<p>
   
						
<select name="toestel" size="1" id="status1" class="style9">
<option>nee</option>
<option>ja</option>
</select><BR>
<input type="submit" name="submit" value="Wijzigen">

	
		
		</td> 
  </tr>
  <tr>
    <td rowspan="7" id="table_border4"><a href="http://www.jetphotosonline.nl/images/queue/'.$ObLid['bestandsnaam'].'" target="_blank" border="0" ><img 

src="http://www.jetphotosonline.nl/images/queue/'.$ObLid['bestandsnaam'].'" width="200" border="0"</a></td>
    <td class="style5"><div align="left"><a href="index.php?p=zoek&trefwoord='.$ObLid['maat'].'">'.$ObLid['maat'].'</a></td>
    <td class="style5" id="table_border7"><div align="left"><a href="index.php?p=zoek&trefwoord='.$ObLid['plaats'].'">'.$ObLid['plaats'].'</a></td>
  </tr>
  <tr>
    <td height="19" class="style5"><div align="left"><a href="index.php?p=zoek&trefwoord='.$ObLid['toestel'].'">'.$ObLid['toestel'].'</a></td>
    <td class="style5" id="table_border7"><div align="left">'.$ObLid['datum'].'</td>
  </tr>
  <tr>
    <td></td>
    <td id="table_border7"></td>
  </tr>
  <tr>
    <td height="19" bgcolor="7b8a8f" class="style3" id="table_border5" height="12">Commentaar en Registratie </td>
    <td bgcolor="7b8a8f" id="table_border5">&nbsp;</td>
  </tr>
  <tr>
    <td height="41" colspan="2" valign="top" class="style6" id="table_border7"><div align="left"><b><a 

href="index.php?p=zoek&trefwoord='.$ObLid['reg'].'">'.$ObLid['reg'].'</a></B> -  '.$ObLid['commentaar'].'</td>
  </tr>
  <tr>
    <td height="18" bgcolor="7b8a8f" class="style3" id="table_border6">Fotograaf:</td>
    <td bgcolor="7b8a8f" id="table_border5">&nbsp;</td>
  </tr>
  <tr>
    <td height="19" class="style5" ><div align="left">&copy; <a href="index.php?p=zoek&trefwoord='.$ObLid['naam'].'">'.$ObLid['naam'].'</a></td>
    <td id="table_border7">&nbsp;</td>
  </tr>
	<tr>
    <td bgcolor="7b8a8f" id="table_border">&nbsp;</td>
    <td bgcolor="7b8a8f" id="table_border3">&nbsp;</td>
    <td bgcolor="7b8a8f" id="table_border5">&nbsp;</td>
  </tr>
	<tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>';
				}
				
				echo'</table>';
			}
			else
			{
				echo'Er zijn geen fotos geplaatst.';
			}
		
		
		$i	=	0;
				
		while( $i <= $filter )
		{
			echo "<a href='index.php?p=foto&page=".$i."'>" . $i . "</a> ";
			
			$i++;
		}
			

 ?>

Reageren

Inloggen om te reageren