nijatmursali

For example here. How to access to this panel for getting $dokan_settings array?
https://ibb.co/RctHVYV

the settings are like that, but it still gives error when editing the page. I saved changes once more, but still

I mean with simple sql command something like

sql = "INSERT INTO TABLE(col_1) VALUES("test")" 

it has to insert to table in the database right?

So I want to do that when user registers to the system it get dokan_settings['store_name'](or something in dokan settings array. So I want to do it like

sql = "INSERT INTO TABLE(col_1) VALUES(dokan_settings['store_name'])" 

Should not it work as well?

Anyone?

It’s time consuming version. What I wanna do is, use all the sellers(so all sellers with different IDs in a loop) and get the address, street, zip kind of information for all sellers into different array or something like that to use all these information in different plugin for map.

Thanks for the information. The type of json is weird in meta_value which is

a: 20: {s: 10: "store_name";s: 10: "Test Store";s: 6: "social";a: 7: {s: 2: "fb";s: 0: "";s: 5: "gplus";s: 0: "";s: 7: "youtube";s: 0: "";s: 7: "twitter";s: 0: "";s: 8: "linkedin";s: 0: "";s: 9: "pinterest";s: 0: "";s: 9: "instagram";s: 0: "";
    }s: 7: "payment";a: 2: {s: 4: "bank";a: 7: {s: 7: "ac_name";s: 0: "";s: 9: "ac_number";s: 0: "";s: 9: "bank_name";s: 0: "";s: 9: "bank_addr";s: 0: "";s: 14: "routing_number";s: 0: "";s: 4: "iban";s: 0: "";s: 5: "swift";s: 0: "";
        }s: 6: "paypal";a: 1: {s: 5: "email";s: 0: "";
        }
    }s: 5: "phone";s: 0: "";s: 10: "show_email";s: 2: "no";s: 7: "address";a: 6: {s: 8: "street_1";s: 15: "Via Ariosto, 25";s: 8: "street_2";s: 0: "";s: 4: "city";s: 4: "Rome";s: 3: "zip";s: 5: "00185";s: 5: "state";s: 2: "RM";s: 7: "country";s: 2: "IT";
    }s: 8: "location";s: 0: "";s: 6: "banner";s: 4: "1622";s: 4: "icon";s: 0: "";s: 8: "gravatar";s: 4: "1623";s: 14: "show_more_ptab";s: 3: "yes";s: 9: "store_ppp";s: 2: "10";s: 10: "enable_tnc";s: 3: "off";s: 9: "store_tnc";s: 0: "";s: 23: "show_min_order_discount";s: 2: "no";s: 9: "store_seo";a: 0: {}s: 24: "dokan_store_time_enabled";s: 3: "yes";s: 23: "dokan_store_open_notice";s: 0: "";s: 24: "dokan_store_close_notice";s: 0: "";s: 16: "dokan_store_time";a: 0: {}
}

How can I get the address, zip out of this one with mysql command? Thanks.

• This reply was modified 3 years, 11 months ago by nijatmursali.

Where all address type of things are stored in the database for users/vendors?

Thanks for reply.

I need to get the address, zip, city type of information from vendors and insert it to another table. So, i need to choose the columns from user table and it should work right?

But there are not address fields in users table..

• This reply was modified 3 years, 11 months ago by nijatmursali.