As the title says, I would like to know how to capture the div id or value and thus be able to use it as a query in SQL server
This is my code:
<?php
define('DB_SERVER','1.2.3.4');
define('DB_NAME','database');
define('DB_USER','sa');
define('DB_PASS','');
$conectar = mssql_connect(DB_SERVER,DB_USER,DB_PASS);
$conn = mssql_select_db(DB_NAME);
if( !$conn ) {
echo "No se puede conectar a la Base de Datos.<br />";
die( print_r( sqlsrv_errors(), true));
}
/* mssql_select_db($database);*/
$query = 'SELECT EntregaRendirCodigo FROM EntregasRendir ORDER BY EntregaRendirCodigo desc';
$result = mssql_query($query);
if (!$result)
{
$message = 'ERROR: ' . mssql_get_last_message();
return $message;
}
else
{
$i = 0;
echo '<html><body><select name="listbox" size="20" onchange="setTextField(this)">';
while ($i < mssql_num_fields($result))
{
$meta = mssql_fetch_field($result, $i);
echo '<td>' . $meta->EntregaRendirCodigo . '</td>';
$i = $i + 1;
}
echo '</tr>';
while ( ($row = mssql_fetch_row($result)))
{
$count = count($row);
$y = 0;
echo '<tr>';
while ($y < $count)
{
$c_row = current($row);
echo '<option value=' . $c_row . '>' . $c_row . '</option>';
next($row);
$y = $y + 1;
}
echo '</tr>';
}
mssql_free_result($result);
echo '</select></body></html>';
}
?>
<input
<?php
$count = 0;
$query2 = "SELECT * FROM EntregasRendir where EntregaRendirCodigo LIKE '%".$c_row."%'";
$result2 = mssql_query($query2);
mssql_free_result($result2);
?>
<?php
echo '<pre>';
print_r($result2);
echo '</pre>'
?>
<input id="make_text" type = "hidden" name = "make_text" value = "" />
<script type="text/javascript">
function setTextField(ddl) {
document.getElementById('make_text').value = ddl.options[ddl.selectedIndex].text;
}
</script>
At the end, the "value" of "make_text" shows the code that you select from the list. What I want to do is a query based on the value of this div. If you could help me with this code. I would appreciate it very much.
Greetings,