Publicado em 20 de jun.

Combo Box + PHP

Procurei pelo forum e axei como colocar o conteudo de um campo do BD no combo box, mas nao axei como se faz o contrario!

Estava querendo colocar status das pessoas nos combos e assim qe escolhesse um, ele fosse colocado num campo do meu BD

Como poderia estar fazendo isso?

PS. Um exemplo:

<form>

<select size="1" onChange="location = options[selectedIndex].value">

<option selected value="1">Waiting</option>

<option value="2">Done</option>

<option value="3">Canceled</option>

</select>

</form>

Grato pela atencao! http://forum.imasters.com.br/public/style_emoticons/default/bye1.gif

Discussão (4)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

B!oh4z4rd· 20 de jun.

Fiz isso mas num tah funcionando!

Poderia me dizer oq esta errado?

<form>

<select size="1" name="opcoes" onChange="location = options[selectedIndex].value">

<option selected value="Waiting">Waiting</option>

<option value="Done">Done</option>

<option value="Canceled">Canceled</option>

$sql ="INSERT INTO request (stats) VALUES ('$opcoes')" or die ("Erro:".mysql_error());

$q =mysql_query($sql);

?>

</select>

</form>

PS. Desculpe a ignorancia http://forum.imasters.com.br/public/style_emoticons/default/bye1.gif

B!oh4z4rd· 20 de jun.

Eu coloquei assim<?session_start();require_once('conector.php');//new Object$msg = "";$connector = new DbConnector();if ($HTTP_POST_VARS){	// Create an SQL query (MySQL version)	$insertQuery = "UPDATE request SET forwarded = '1' WHERE id = '$_POST[id]'"; // Save the form data into the database	if ($result = $connector->query($insertQuery) or die (mysql_error())){ $msg = '<center><b class="warning">Sent with sucess!</b></center><br>';	}else{ exit('<center>Sorry, there was an error</center>');	}}?>

B!oh4z4rd· 23 de jun.

session_start();

require_once('conector.php');

//new Object

$msg = "";

$connector = new DbConnector();

if ($HTTP_POST_VARS){

 

	// Create an SQL query (MySQL version)

	$insertQuery = "UPDATE request SET forwarded = '1' WHERE id = '$_POST[id]'";

 

	// Save the form data into the database

	if ($result = $connector->query($insertQuery) or die (mysql_error())){

 $msg = '<center><b class="warning">Sent with sucess!</b></center><br>';

	}else{

 exit('<center>Sorry, there was an error</center>');

	}

}

?>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link rel="stylesheet" href="palsdesk.css" type="text/css">

<title>Untitled Document</title>

<style>

body{

	margin:0px;

	background-color:#CCCCCC;

}

#conteudo {

	display:none;

}

 

.teste {

	font-size:9px;

	color:red;

}

</style>

<script language="JavaScript" type="text/JavaScript">

<!--

function MM_openBrWindow(theURL,winName,features) { //v2.0

 window.open(theURL,winName,features);

}

//-->

fecha_ultimo = 0;

function abrir(id_conteudo){

	if(id_conteudo == fecha_ultimo){

 document.getElementById("conteudo"+fecha_ultimo).style.display = "none";

 document.getElementById("figura"+fecha_ultimo).src = "closed.gif"

 fecha_ultimo = 0;

	} else {

 if(fecha_ultimo){

 document.getElementById("conteudo"+fecha_ultimo).style.display = "none";

 document.getElementById("figura"+fecha_ultimo).src = "closed.gif"

 fecha_ultimo = 0;

 }

 document.getElementById("conteudo"+id_conteudo).style.display = "inline";

 document.getElementById("figura"+id_conteudo).src = "open.gif"

 fecha_ultimo = id_conteudo;

	}

}

</script>

</head>

<body>

<?php

 

echo $msg;

// Use the query function of DbConnector to run a database query

@$connector->query("DELETE FROM request WHERE id = '$_GET[delete]' ") or die (mysql_error());

@$connector->query("DELETE FROM request_model WHERE id_group = '$_GET[delete]' ") or die (mysql_error());

$result = $connector->query("SELECT * FROM request ORDER by date DESC");

// Get the result

while ($row = $connector->fetchArray($result)){

?>

<form method="post">

<table width="252" border="0" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0">

 <tr>

 <td width="1"><a href="java script:abrir(<?= $row["id"] ?>);" ><img src="closed.gif" alt="user name" id="figura<?= $row["id"]?>" border="0"></a></td>

 <td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

 <tr>

 <td class="boxNotesDetails" valign="top" colspan="99"><a href="java script:abrir(<?= $row["id"] ?>);" class="boxNotesName" title="View model's details">Req:

 <?php

 $result1 = $connector->query("SELECT * FROM request_model WHERE id_group =".$row["id"]." ");

 while($row1 = $connector->fetchArray($result1)){

 $result2 = $connector->query("SELECT * FROM users WHERE id =".$row1["id_model"]." ");

 $row2 = $connector->fetchArray($result2);

 echo $row2["name"].", ";

 }

 echo "(".$row["stats"].")"

 ?>

 </a> </td>

 </tr>

 <tr>

 <td colspan="99" class="boxNotesText">

 <div id="conteudo<?= $row["id"]?>" style="display:none">

 <strong>Event Date: </strong><?= $row["date"]?><br>

 <strong>Photographer: </strong><?= $row["photographer"]?><br>

 <strong>Location: </strong><?= $row["location"]?><br>

 <strong>Stylist/Make-up: </strong><?= $row["stylist"]?><br>

 <strong>Contact: </strong><?= $row["contact"]?><br>

 <strong>Client: </strong><?= $row["client"]?><br>

 <strong>Description: </strong><?= $row["description"]?><br>

 <br>

 <?php

 if($row["forwarded"] <> 1){

 ?>

 <div align="center">

 <input name="id" type="hidden" id="fwd" value="<?= $row["id"]?>">

 <input name="send" type="submit" id="fwd" value="Forward to models">

 </div>

 <br>

 <?

 }

 $result4 = $connector->query("SELECT * FROM request_model WHERE id_group =".$row["id"]." ");

 while($row4 = $connector->fetchArray($result4)){

 $result5 = $connector->query("SELECT * FROM users WHERE id =".$row4["id_model"]." ");

 $row5 = $connector->fetchArray($result5);

 echo "<strong>".$row5["name"].":</strong> ";

 if($row4["confirm"] == 0) echo "Awaiting";

 if($row4["confirm"] == 1) echo "Confirmed";

 if($row4["confirm"] == 2) echo "Rejected";

 echo "<br><br>";

 }

 ?>

 <form>

 <select size="1" name="opcoes" onChange="location = options[selectedIndex].value">

 <option selected value="Waiting">Waiting</option>

 <option value="Done">Done</option>

 <option value="Canceled">Canceled</option>

 <?

 $sql ="INSERT INTO request (stats) VALUES ('$opcoes')" or die ("Erro:".mysql_error());

 $q =mysql_query($sql);

 ?>

 </select>

 </form>

 </div>

 

 </td>

 </tr>

 <tr>

 <td class="boxNotesDetails" valign="bottom"> From:

 <?

 $result_from = $connector->query("SELECT * FROM users WHERE id =".$row["id_user"]." ");

 $row_from = $connector->fetchArray($result_from);

 echo $row_from["name"];

 ?>

 - <?= converte_data($row["insertdate"],1)?>

 </td>

 <td class="boxNotesDetails" valign="bottom" align="right"> [<a href=requests.php?delete=<?= $row["id]?>" class="boxModelTool" title="Delete this request" onclick="return confirm('Are you sure!?')">Delete</a>] </td>

 </tr>

 </table></td>

 </tr>

</table>

</form>

<br>

}

?>

</body>

</html>

Tá ae! http://forum.imasters.com.br/public/style_emoticons/default/bye1.gif

Marcelo_nd· 3 de jun.

Por que o onchange.... se voce quiser gravar o conteudo do select no banco

De um nome para o select e inseri normalmente

 

 

<form>

<select size="1" name="opcoes" onchange="location = options[selectedIndex].value">

<option selected value="1">Waiting</option>

<option value="2">Done</option>

<option value="3">Canceled</option>

</select>

</form>

para inserir

$sql ="INSERT INTO TABELA (opcoes) VALUES ('$opcoes')" or die ("Erro:".mysql_error());

$q =mysql_query($sql);

 

echo "Inserido

Adailton

E se eu kiser, ao inves de ir para outra pagina, apenas carregar o valor recebido?!?!?