[insert_php]
$link = mysqli_connect(“localhost”, “audax_param”, “hqikCi3ici7P”, “audax_param”);
// Check connection
if($link === false){
die(“ERROR: Could not connect. ” . mysqli_connect_error());
}
// Attempt select query execution
$sql = “SELECT * FROM BUSCA_PARAMETRICA WHERE IMG like ‘1234.jpg’ order by LEDS ASC”;
if($result = mysqli_query($link, $sql)){
$linha = mysql_fetch_assoc($result);
// calcula quantos dados retornaram
$total = mysql_num_rows($result);
if($total > 0) {
// inicia o loop que vai mostrar todos os dados
$linha[‘PROD_DESCRICAO’]
do {
}
}
if(mysqli_num_rows($result) > 0){
echo “
| PART_NUMBER | FLUXO_FINAL | POTENCIA | VIN | TCOLOR | IRC | LEDS |
|---|---|---|---|---|---|---|
| ” . $row[‘PART_NUMBER’] . “ | ” . $row[‘FLUXO_FINAL’] . “ | ” . $row[‘POTENCIA’] . “ | ” . $row[‘VIN’] . “ | ” . $row[‘TCOLOR’] . “ | ” . $row[‘IRC’] . “ | ” . $row[‘LEDS’] . “ |
“;
// Free result set
mysqli_free_result($result);
} else{
echo “No records matching your query were found.”;
}
} else{
echo “ERROR: Could not able to execute $sql. ” . mysqli_error($link);
}
// Close connection
mysqli_close($link);
###############################
[/insert_php]