Laravel SQL: Duplicate Insertion Into Table

Question

I am working on a self-learning project to learn how to use Laravel 4. At this point, I have managed to get most of it to work, but the problem I run into is I get 2 entries in the database tables rather than 1.

I had an error before about a duplicate primary key value, and it still added two entries. I thought this error was the reason behind the duplicate values, but I have since fixed this error and this still happens.

I'm sorry if my code is really messy and unorganized. I will be reorganizing it at the end.

Here's my code (I can't submit images):

Thanks for the help!

File 1: views/customer/index.blade.php

@extends('layout')

', $qty);
        $qty = str_replace("
", '
', $qty);

        $unit_price = str_replace("
", '
', $unit_price);
        $unit_price = str_replace("
", '
', $unit_price);

        $qtyArr = explode('
', $qty);
        $priceArr = explode('
', $unit_price);

        $total = array();

        for($i = 0; $i < count($qtyArr); $i++)
        {
            $total[$i] = $qtyArr[$i] * $priceArr[$i];
        }
        return $total;
    }

    $total = json_encode(line_totals());

function insert_customer()
    {
        $customerIsFilled = isset($_GET['date']) || isset($_GET['receipt']) || isset($_GET['name']) || isset($_GET['address']) || isset($_GET['city']) || isset($_GET['state']) || isset($_GET['zip']);

        if($customerIsFilled)
        {
            $id                 = "";
            $name               = $_GET['name'];
            $address            = $_GET['address'];
            $city               = $_GET['city'];
            $state              = $_GET['state'];
            $zip                = $_GET['zip'];
            $created_at         = date('Y-m-d H:i:s');
            $updated_at         = date('Y-m-d H:i:s');

            $insert_cust = array(
                                'id'                => $id,
                                'name'              => $name,
                                'address'           => $address,
                                'city'              => $city,
                                'state'             => $state,
                                'zip'               => $zip,
                                'created_at'        => $created_at,
                                'updated_at'        => $updated_at
                    );

            DB::table('customer')->insert($insert_cust);
        }
        else
            return;
    }

    function insert_work()
    {       
        $curId = 0;

        $select = DB::select('SELECT * FROM customer');

        $ids = array();

        for($i = 0; $i < count($select); $i++)
        {
            if(!empty($select))
            {
                $ids[$i] = DB::table('customer')->pluck('id');
                $curId = max($ids);
            }
        }

        $workIsFilled = isset($_GET['date']) || isset($_GET['receipt']) || isset($_GET['qty']) || isset($_GET['description']) || isset($_GET['unit_price']) || isset($_GET['line_total']) || isset($_GET['created_at']) || isset($_GET['updated_at']);

        $line_total     =   "";

        if($workIsFilled)
        {
            $cust_id        =   $curId;
            $qty            =   htmlspecialchars($_GET['qty']);
            $date           =   htmlspecialchars($_GET['date']);
            $receipt        =   htmlspecialchars($_GET['receipt']);
            $description    =   htmlspecialchars($_GET['description']);
            $unit_price     =   htmlspecialchars($_GET['unit_price']);
            $created_at     =   date('Y-m-d H:i:s');
            $updated_at     =   date('Y-m-d H:i:s');

            $tot = line_totals();

            for($i = 0; $i < count($tot); $i++)
            {
                $line_total .= $tot[$i]."
";
            }

            $insert_work = array(
                                'cust_id'       => $cust_id,
                                'qty'           => $qty,
                                'date'          => $date,
                                'receipt'       => $receipt,
                                'description'   => $description,
                                'unit_price'    => $unit_price,
                                'line_total'    => $line_total,
                                'created_at'    => $created_at,
                                'updated_at'    => $updated_at
                        );
            DB::table('work')->insert($insert_work);
        }
        else
            return;
    }

    // Store HTTP GET request parameters into $url

    $get = action('CustomerController@getResults', $url);   
 ?>

@section('content')
    
        
            
                 Name:    
                 Address:    
                 City:    
                 ST:    
                 Zip:    
            
        

        




        Work Performed


    
        
             Date:   
             Receipt#:    
        
    
        
        
             5<?php echo "
"; ?>5                              
             Job 1<?php echo "
"; ?>Job 2      
             200<?php echo "
"; ?>400       
              
        
        
        

        
    
@stop

File 2: views/layout.blade.php



@section('header')


    

    







Invoice





@stop

@yield('header')
@yield('content')

Laravel SQL: Duplicate Insertion Into Table

Answers (1)

Related Questions