Questions tagged as 'mysql'

0
answers

Enable any country in module

Hello, I have an Ebanx module that only appears in admin when I'm in the "All Stores" view. My store by default is in Portuguese view, then when I make a purchase the message appears (Payment not available for that country). My idea was to e...
asked by 06.09.2018 / 17:08
0
answers

IONIC 3 how to save image with PHP + MySQLi

I'm new to IONIC and around here. All CRUD is working normal, but when I put the codes to image in BASE64 , I choose the image and it appears in SRC of the page, but the problem is in saving in BD MySql + PHP , becau...
asked by 04.09.2018 / 18:16
4
answers

How to create a real-time notification system similar to Stack Overflow?

I am developing a Help Desk system, and would like some ideas on how to create a notification system similar to Stack Overflow itself, whenever any new support is registered. I want to use PHP, MySQL and jQuery only. Should I use window...
asked by 16.03.2014 / 20:21
1
answer

MYSQL is terminating by itself when executing a procedure

I have a problem with my mysql on localhost. I use xampp as a service and HeidiSQL to facilitate the programming process. Finally, when executing the procedure below the MYSQL service is terminating alone and the error LOG returns the informatio...
asked by 09.09.2018 / 03:43
1
answer

Combobox with MySQL

I can not get the data from the unit table and put it in a combobox. The combobox does not work and appears overwritten. I have a table named "tblutentes" with the user name and then I have a table called unit with the unit names. I wanted a com...
asked by 09.09.2018 / 15:15
2
answers

Problem with query using SQL in PHP

I have the following code: $nomeConteudo = $_POST['tipoConteudo']; echo $nomeConteudo; $id = $conteudo_fkid->cataId($nomeConteudo); echo $id; In it, the variable nameName receives the value of a form and then prints it. Until then it wor...
asked by 02.09.2018 / 00:42
1
answer

How to pull the Option value of the select HTML property that is saved in MYSQL

How do I change and save in the database, as soon as I update the saved value in the box, the way I am saving in the database, but when updating the page it leaves the box always filled with the first value. $ifs = "SELECT * FROM config WHE...
asked by 01.09.2018 / 19:22
1
answer

Error while making select

   Warning: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result, boolean given I already tested fetch_array , fetch_object , I do not know how to do it. function pegaId($nomeConteudo){ $query = "select id from...
asked by 02.09.2018 / 00:00
0
answers

Select in wordpress database and woocomerce meta data

Hello everyone, how are you? I am studying mysql and am using a wordpress database with woocommerce. I can not perform a select the way I need it. In the database I have 2 tables wp_posts and wp_postmeta and the data of the product...
asked by 16.09.2018 / 01:48
0
answers

Create Trigger to update table of BANK 2 when changing table of BANK 1

I have several databases BANK_1 (Main) BANK_2, _3, _4 ... (Companies). In every bank there is a company table, who have the same structure, in BANK_1 I have the company register of all BANK_2, _3, _4 ...! I would like to update any company infor...
asked by 07.09.2018 / 17:57