store array in database Wordpress

Question

I have this form with a select.

<form>[...]
<select name="quantity[]">
    <?php
    for ($i=1; $i <20; $i++) {
    ?>
   <option value="<?php echo $i ?>"><?php echo $i ?></option>
    <?php } ?>
</select>[...]
</form>

I'm trying to store the quantity data in the database using $wpdb.

global $wpdb;

    $table_name=$wpdb->prefix.'prenotazione_eventi';

    $wpdb_quantity = maybe_serialize( $_POST[ 'quantity'] );

    $query = "INSERT INTO $table_name (quantity) VALUES (%s)";

    $prepare_query = $wpdb->prepare( $query, $wpdb_quantity);

    $result = $wpdb->query( $prepare_query );

When I submit the form the data is saved in the database, but in this sintax a:1:{i:0;s:2:"10";}. What I want is that the data have only the number that I choose I the form, "10". How do that?

ok, I found the solution by myself. For everyone in need I change maybe_serialize() with implode() — Francesco Tonti
– Francesco Tonti, Commented Apr 27, 2018 at 11:20
In wordpress, adding array in database will store data in serialize format of that array. — Bhoomi
– Bhoomi, Commented Apr 27, 2018 at 11:21

Vel · Accepted Answer · 2018-04-27 11:19:05Z

1

Try this code.

use json_encode instead of maybe_serialize.

global $wpdb;

$table_name=$wpdb->prefix.'prenotazione_eventi';

$wpdb_quantity = json_encode( $_POST[ 'quantity'] );

$query = "INSERT INTO $table_name (quantity) VALUES (%s)";

$prepare_query = $wpdb->prepare( $query, $wpdb_quantity);

$result = $wpdb->query( $prepare_query );

answered Apr 27, 2018 at 11:19

Vel

9,4286 gold badges42 silver badges71 bronze badges

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

Collectives™ on Stack Overflow

store array in database Wordpress

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