Pessoal tenho o seguinte código abaixo: Preciso que ao selecionar o produto( depois da procura no banco), ele preenchesse os demais campos com os dados vindos da consulta do banco. <script type="text/javascript"> $(document).ready(function(){ $('.search-cod input[type="text"]').on("keyup input", function(){ /* Get input value on change */ var inputVal = $(this).val(); var resultDropdown = $(this).siblings(".resultcod"); if(inputVal.length){ $.get("codigo-search.php", {term: inputVal}).done(function(data){ // Display the returned data in browser resultDropdown.html(data); }); } else{ resultDropdown.empty(); } }); // Set search input value on click of result item $(document).on("click", ".resultcod p", function(){ $(this).parents(".search-cod").find('input[type="text"]').val($(this).text()); $(this).parent(".resultcod").empty(); }); }); </script> <?php /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'root' with no password) */ $link = mysqli_connect("localhost", "root", "", "table"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } if(isset($_REQUEST["term"])){ // Prepare a select statement $sql = "SELECT * FROM produtos WHERE ean LIKE ?"; if($stmt = mysqli_prepare($link, $sql)){ // Bind variables to the prepared statement as parameters mysqli_stmt_bind_param($stmt, "s", $param_term); // Set parameters $param_term = $_REQUEST["term"] . '%'; // Attempt to execute the prepared statement if(mysqli_stmt_execute($stmt)){ $result = mysqli_stmt_get_result($stmt); // Check number of rows in the result set if(mysqli_num_rows($result) > 0){ // Fetch result rows as an associative array while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){ echo "<p>" . $row["ean"] . "</p>"; } } else{ echo "<p>No matches found</p>"; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } } // Close statement mysqli_stmt_close($stmt); } // close connection mysqli_close($link); ?> Formulario Html <div class="search-cod"> <label for="nome" >Codigo</label> <input class="search-cod" type="text" for="nome" size="10" autocomplete="off" placeholder="Procura Codigo..." /> <div class="resultcod"></div> </div> <br> Aqui precisava o input do nome e abaixo o input da referencia, estes dois ("nome" e "fererencia" veem do banco. Desde já, agradeço a todos. /phorum/read.php?3,194669,194669#msg-194669 Mon, 07 Sep 2026 18:06:08 +0000 Phorum 5.2.10 /phorum/read.php?3,194669,194669#msg-194669 /phorum/read.php?3,194669,194669#msg-194669
Preciso que ao selecionar o produto( depois da procura no banco), ele preenchesse os demais campos com os dados vindos da consulta do banco.


<script type="text/javascript">
$(document).ready(function(){
$('.search-cod input[type="text"]').on("keyup input", function(){
/* Get input value on change */
var inputVal = $(this).val();
var resultDropdown = $(this).siblings(".resultcod");
if(inputVal.length){
$.get("codigo-search.php", {term: inputVal}).done(function(data){
// Display the returned data in browser
resultDropdown.html(data);
});
} else{
resultDropdown.empty();
}
});

// Set search input value on click of result item
$(document).on("click", ".resultcod p", function(){
$(this).parents(".search-cod").find('input[type="text"]').val($(this).text());
$(this).parent(".resultcod").empty();
});
});

</script>



<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "table");

// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}

if(isset($_REQUEST["term"])){
// Prepare a select statement
$sql = "SELECT * FROM produtos WHERE ean LIKE ?";

if($stmt = mysqli_prepare($link, $sql)){
// Bind variables to the prepared statement as parameters
mysqli_stmt_bind_param($stmt, "s", $param_term);

// Set parameters
$param_term = $_REQUEST["term"] . '%';

// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){
$result = mysqli_stmt_get_result($stmt);

// Check number of rows in the result set
if(mysqli_num_rows($result) > 0){
// Fetch result rows as an associative array
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
echo "<p>" . $row["ean"] . "</p>";

}
} else{
echo "<p>No matches found</p>";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
}

// Close statement
mysqli_stmt_close($stmt);
}

// close connection
mysqli_close($link);
?>



Formulario Html

<div class="search-cod">
<label for="nome" >Codigo</label>
<input class="search-cod" type="text" for="nome" size="10" autocomplete="off" placeholder="Procura Codigo..." />
<div class="resultcod"></div>
</div>
<br>



Aqui precisava o input do nome e abaixo o input da referencia,
estes dois ("nome" e "fererencia" veem do banco.



Desde já, agradeço a todos.]]> Fernando Perguntas Variadas / Não Relacionadas ao PHP Thu, 04 Oct 2018 18:53:46 +0000