下面是我的函数
function get_products($business_id){
$sql = "SELECT
b.*, b.name as business_name, p.builder_id,
bs.*, p.price, p.name as product_name, p.description, p.image, p.per_station, p.skip_screen
FROM
builder_product bp
JOIN builder_step bs ON bp.builder_step_id = bs.builder_step_id
JOIN builder b ON bp.builder_id = b.builder_id
WHERE b.business_id = '{$business_id}'
ORDER by b.step_number, b.price";
$result = mysql_query($sql);
$steps = array();
while($row_r = mysql_fetch_assoc($result)){
$steps["all_steps"]['business_id'] = $business_id;
$steps["business_name"] = $row_r['business_name'];
$steps["builder_id"] = $row_r['builder_id'];
if (count($steps) == 0) {
$business_id = 59;
get_products($business_id);
}else{
$steps["business_id"] = $business_id;
return $steps;
}
}下面是对该函数的调用
$products = get_products($_GET['business_id']);为什么我不能从这个函数中得到返回值……我在返回值之前做了一个print_r,我有一个包含大量数据的数组,但是如果我在这个函数的调用下面做一个print_r,我什么也得不到。我正在做一个递归调用,以确保我有一个返回的array...any,知道我错过了什么
发布于 2011-12-14 23:08:40
我认为您需要在代码的if (count($steps) == 0)分支中添加一个返回语句:
if (count($steps) == 0) {
$business_id = 59;
return get_products($business_id);
}else{
$steps["business_id"] = $business_id;
return $steps;
}发布于 2011-12-14 23:06:32
if (count($steps) == 0) {
$business_id = 59;
get_products($business_id);
}else{
$steps["business_id"] = $business_id;
return $steps;
}当你点击if而不是else时,什么也不会返回。
编辑:将其更改为return get_products($business_id)。
发布于 2011-12-14 23:07:14
这是整个函数吗?看起来你遗漏了一个结束括号:
function get_products($business_id){
$sql = "SELECT
b.*, b.name as business_name, p.builder_id,
bs.*, p.price, p.name as product_name, p.description, p.image, p.per_station, p.skip_screen
FROM
builder_product bp
JOIN builder_step bs ON bp.builder_step_id = bs.builder_step_id
JOIN builder b ON bp.builder_id = b.builder_id
WHERE b.business_id = '{$business_id}'
ORDER by b.step_number, b.price";
$result = mysql_query($sql);
$steps = array();
while($row_r = mysql_fetch_assoc($result)){
$steps["all_steps"]['business_id'] = $business_id;
$steps["business_name"] = $row_r['business_name'];
$steps["builder_id"] = $row_r['builder_id'];
if (count($steps) == 0) {
$business_id = 59;
get_products($business_id);
}else{
$steps["business_id"] = $business_id;
return $steps;
}
}
}https://stackoverflow.com/questions/8506682
复制相似问题