Array to String Conversion Error/Problems

Question

I am a PHP newbie, and keep on getting "PHP Notice: Array to string conversion" when I attempt this code given to me to loop through INSERTing items into a database. I need to loop through, because I am using an ajax script to dynamically read form field data as you add/remove fields, and pushing it through the php as $idx allows $idx to be incremented, allowing my dynamic addition of INSERTS.

Does anyone know how to alter this to make it work, and PLEASE tell me how/why/what you did so I can learn for future uses. THANKS!!

My PHP :

$sql = "INSERT INTO items (WID, model, description, cost, retail, qty) values(?, ?, ?, ?, ?, ?);";
        $q = $pdo->prepare($sql);
        $idx = 0;
        foreach ($Model as $model_idx) {
            $q->execute(array($wid,$model_idx, $Description[$idx], $Cost[$idx], $Retail[$idx], $Quantity[$idx]));
            $idx++;
        }

My Php/Html :

<div class="control-group <?php echo !empty($ModelError)?'error':'';?>">
                                    <div class="controls">
                                        <input type="text" data-type="model" name="model[]" id="model_1" placeholder="Model" value="<?php echo !empty($Model)?$Model:'';?>" class="form-control autocomplete_txt" autocomplete="off">
                                            <?php if (!empty($ModelError)): ?>
                                                <span class="help-inline"><?php echo $ModelError;?></span>
                                            <?php endif; ?>
                                    </div>
                            </div>

Validation/String Output :

if ( !empty($_POST)) {
        // keep track validation $

        $ModelError       = null;
        $DescriptionError = null;
        $CostError        = null;
        $RetailError      = null;
        $QuantityError    = null;

        // keep track post values

        $Model        = $_POST['model'];
        $Description  = $_POST['description'];
        $Cost         = $_POST['cost'];
        $Retail       = $_POST['retail'];
        $Quantity     = $_POST['quantity'];

        // validate input
        $valid = true;
        if (empty($Model)) {
            $ModelError = 'Please enter Model';
            $valid = false;
        }

@StuartWagner It is not, the form fields are added via ajax as needed, and as soon as the user clicks on "Submit" the items are added into the database(or are supposed to be). In that manner, you can have a form that adds 3 items to a database, or 30(think invoicing) — Steven
– Steven, Commented Jun 23, 2015 at 20:48
@anantkumarsingh What do you mean? Model is part of the table, which consists of Model, Description, Cost, Retail, etc - That div code is a sample of the whole, there is a div for each of the above. The php cycles through each of the added ajax elements by the model, because the model is mandatory in my form fields. — Steven
– Steven, Commented Jun 23, 2015 at 20:54

Death-is-the-real-truth · Accepted Answer · 2015-06-23 21:27:11Z

1

As you stated the problem is Array to String conversion that means in your code

$sql = "INSERT INTO items (WID, model, description, cost, retail, qty) values(?, ?, ?, ?, ?, ?);";
        $q = $pdo->prepare($sql);
        $idx = 0;
        foreach ($Model as $model_idx) {
            $q->execute(array($wid,$model_idx, $Description[$idx], $Cost[$idx], $Retail[$idx], $Quantity[$idx]));
            $idx++;
        }

Here $Model is not act as an array so try to print it out by echo "<pre/>";print_r($Model); or var_dump($Model); and check any array is coming or not?

If not then check your html code and try to resolve it.

Also i am not sure how's you are getting/making these variables $wid,$model_idx, $Description[$idx], $Cost[$idx], $Retail[$idx], $Quantity[$idx] .

answered Jun 23, 2015 at 21:27

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Array to String Conversion Error/Problems

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related