Saving relationships data in model

This is my store function, Laravel 5.5

Here firstly I am saving address first then account, after that I can attach account id to address id.

But if there is an error saving account data address data will be created but account is not,

Account has one to one relationship with address,

Is there any way to save if there is an error on saving account data address gets deleted or it does not save at all,

Thank you.

public function store(Request $request){

    $address_save = false;
    $account_save = false;


    ///////After Validation//////

    $address = new Address;
    $address->shipping_address1 =  $request->shipping_address1;
    $address->shipping_address2 =  $request->shipping_address2;
    $address->area_id =  $request->area_id;
    $address->city_id =  $request->city_id;
    $address->shipping_state =  $request->shipping_state;
    $address->shipping_pincode =  $request->shipping_pincode;
    $address->shipping_country =  $request->shipping_country;
    $address->billing_address1 =  $request->billing_address1;
    $address->billing_address2 =  $request->billing_address2;
    $address->billing_area =  $request->billing_area;
    $address->billing_state =  $request->billing_state;
    $address->billing_city =  $request->billing_city;
    $address->billing_pincode =  $request->billing_pincode;
    $address->billing_country =  $request->billing_country;
    $address->same_as_shipping =  $shipping;

    $address_save = $address->save();

    $address_id = $address->id;


    $account = new Account;
    $account->title = $request->title;
    $account->fullname = $request->fullname;
    $account->username = $request->username;
    $account->password = $request->password;
    $account->company = $request->company;
    $account->mobile = $request->mobile;
    $account->alt_number = $request->alt_number;
    $account->email = $request->email;
    $account->whatsapp = $request->mobile;
    $account->pan = strtoupper($request->pan);
    $account->gstin = strtoupper($request->gstin);
    $account->registered_at = date("Y-m-d h:i:sa");

    $account->address_id = $address_id;
    $account_save = $account->save();

    $account_id = $account->id;


from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2VKCtHt
via IFTTT

تعليقات

إرسال تعليق

المشاركات الشائعة من هذه المدونة

I am unable to figure out how to create payment collection request, after a form has been submitted in laravel

I have a form where I ask some questions to my user for rendering my services, each form submission has a payment that needs to be paid by the enduser. What I have already done: 1. I have created a controller/form where user provided data is captured. 2. generate orderid for each form submission. 3. the data is getting stored in the db as specified. what I want to achieve: 1. Upon successful submission of the form, user will be redirected to a thankyou page and on the thankyou page he should be given an option to make the payment. 2. I want to create a paymentcontroller so that a new record is created, based on form submission details in relationship with the orderID attached with the form submission record. 3. the payment controller should also be able to capture payment amount, orderid etc., I am not going the regular way of cart method, its just a form to be filled for service to be rendered and payment collected for each request. I am new to programming, please help me if you can. ...
قراءة المزيد

laravel, mysql transaction not working after failed one time

I am performing insertion in 4 tables simultaneously using laravel 5.8. When I Submit incomplete Form it will show me error and after that when submit proper data again it will show database error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`matrimonial_db`.`personal_details`, CONSTRAINT `personal_details_ibfk_1` FOREIGN KEY (`site_user_id`) REFERENCES `siteuser` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) (SQL: insert into `personal_details` (`site_user_id`, `updated_at`, `created_at`) values (148, 2020-04-29 05:16:53, 2020-04-29 05:16:53)) First time when i fill form it insert data successfully in all tables but when try again it will show me the error. here is a code try { $connection = DB::connection('mysql'); $connection->beginTransaction(); $userData = session()->get('registeruser_data'); $userData->user_type = 'v...
قراءة المزيد