AJAX/PHP/MySQL/HTML Search MySQL based off of generated variable and display cell in table

Question

I am building a custom part builder and I am trying to make it search the MySQl Database by the Part Number that is generated and then output the price into cell in a table. I can't figure out how to make it search by the Part Number that is generated and output the price. The Part Number is generated by Javascript but an example part number would be 133-FTHxFTH-075-N1-00. Here is my Ajax script

var request = $.ajax({ url: "http://localhost/filenamehere.php", type: "post", data: "partnumber" }); request.done(function (response) { document.getElementById("price1").innerHTML = response; });

Here is my PHP Code

if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT 'LDS_Price_$' FROM list where 
Part_Number=**This is wher the generated part number would go** ");

echo "<table border='1'>
<tr>
<th>LDS Price $</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['LDS_Price_$'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>`

Your filenamehere.php needs to connect to the database, run the query and return the results. — user2417483
– user2417483, Commented Sep 20, 2017 at 14:40

A. Iglesias · Accepted Answer · 2017-09-20 14:46:47Z

1

If your php file si returning just the price in plain text...

myPartNumber = '133-FTHxFTH-075-N1-00';

$.ajax({
    type: 'POST',
    url: "http://localhost/filenamehere.php",
    data: { partnumber: myPartNumber },
    dataType: 'html',
    async: true,
    success: function(data) {
        $('#price').html(data);
    }
});

I hope it helps

answered Sep 20, 2017 at 14:46

A. Iglesias

2,6752 gold badges12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

AJAX/PHP/MySQL/HTML Search MySQL based off of generated variable and display cell in table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related