ajax展示存储,通过Ajax返回存储过程输出

在您的createCampaign中

function createCampaign($campaignName, $attribute){

$stmt = \DB::connection('odbc')->getPdo()->prepare('CALL PROCEDURES.INSERT_CAMPAIGN(?,?,?)');

$stmt->bindValue(1,$campaignName, PDO::PARAM_STR);

$stmt->bindValue(2,$attribute, $attribute==0 ? PDO::PARAM_NULL : PDO::PARAM_INT);

$stmt->bindParam(3,$out2, PDO::PARAM_INT);

$stmt->execute();

return $out2;

}

在您的控制器中

使用这些类：

use Illuminate\Support\Facades\Response;

use Illuminate\Http\Response as HttpResponse;

返回JSON响应：

public function createCampaign(Request $request)

{

$campaignName = $request->campaignName;

$attribute = $request->attribute;

$campaignService = new CampaignService();

$createdCampaignId = $campaignService->createCampaign($campaignName, (int) $attribute);

return Response::json(["campaign_id" => $createdCampaignId)

->setStatusCode(HttpResponse::HTTP_OK);

}

在您的刀片模板中

$.ajax({

type:'POST',

url:'campaigns/createCampaign',

data:{campaignName:campaignName, attribute:attribute},

_token: '{{ csrf_token() }}',

success:function(data){

intro_modal.hide();

// data.campaign_id will contains the new campain id

}

});

例如，您只需要在data.campaign_id后面插入jQuery的值即可。