Mysql查询执行数组并插入javascript值

Question

我需要从数据库中获取数据，我使用PHP代码来做到这一点，但是当我需要在这部分设置一个数组值new_article_query->execute( array(article, manufacturer) );
我怎么能使用javascript值如果article和manufacturer在javascript

中定义

<script>
//Javascript function code part 1...
//Then I insert PHP code in the javascript function
<?php
$new_article_query = $db_link->prepare('SELECT * FROM `shop_prices_data` WHERE `article` = ? AND `manufacturer` = ?;');
$new_article_query->execute( array(article, manufacturer) );
$new_article = $new_article_query->fetch();
$reg_invoice_value = $new_article["$new_article"];
?>  
//Then javascript function continue

return start_wrap_div + '<td class="td_manufacturer">'+ manufacturer + show_hide_button +'</td><td class="td_article">'+ article_show +'</td><td class="td_name">'+ name +'</td><td class="td_exist">'+ exist +'</td><td class="td_time_to_exe"><span onclick="openInfoWindow(null, null, 1, ''+ supply_info_json +'');">'+ time_to_exe +'</span></td><td class="td_info">'+ info +'</td><td class="td_price">'+ price +'</td><td class="td_add_to_cart">'+ cart_html +'</td>'+ '<td class="td_color" style="background:'+color+'"></td>' + end_wrap_div;
}
</script>

Answer 1

可以使用ajax。像下面的

<script>
function function_name(){
let article = 'article';
let manufacturer = 'manufacturer';
$.ajax({
type: "post",
url: 'php_file_name/getData',
data: {'article':article, 'manufacturer':manufacturer },
succuess: function(msg){
// your javascript 
}
})
}
</script>

和php_file_name.php文件

function getData(){
$article= $_POST['article'];
$manufacturer= $_POST['manufacturer'];
$new_article_query = $db_link->prepare('SELECT * FROM shop_prices_data WHERE article = ? AND manufacturer = ?;');
$new_article_query->execute( array(article, manufacturer) );
$new_article = $new_article_query->fetch();
$reg_invoice_value = $new_article["$new_article"];
//return data
}