Questions tagged as 'mysql'

Tagged questions
1
answer

Warning: Illegal string offset 'id_mol_comp' in

I'm having multiple errors    Warning: Illegal string offset 'id_mol_comp' in C: \ wamp \ www \ fanamol \ cart.php on line 167       Notice: Uninitialized string offset: 0 in C: \ wamp \ www \ fanamol \ cart.php on line 167 Referring to...
asked by 30.05.2018 / 17:14
2
answers

Problem creating table in MySQL

I'm trying to create a table in MYSQL : CREATE TABLE 'narguile'.'Aluguel' ( 'idAluguel' INT(255) NOT NULL , 'produto' VARCHAR(255) NOT NULL , 'qntdeProduto' INT(255) NOT NULL , 'desconto' DOUBLE(255) NOT NULL , 'descricao' VARCHAR(255) N...
asked by 22.07.2018 / 17:03
1
answer

mySQL - using SUM ()

I need to add the total value of an order with more than 1 product included with different unit values. follows tb_pedido: id_pedido | id_produto | valor_unit | qtd -------1-----|-------3-------|----10.00---|--2-- -------1-----|--...
asked by 20.07.2018 / 17:07
1
answer

I can not write information to the database (PYTHON \ MYSQL)

I am trying to insert this query, but it does not register in the MySql table, but I realize that it is accessing right, because it always uses a position of the 'cod' that is primaryKey * When I use the string in the SQL database it inserts...
asked by 27.05.2018 / 21:54
1
answer

Problem to list bank data

I'm having trouble storing the values of ORDER BY in php, I'd like to store them in an array and show it on another page. Database file with function: function buscar_rank($conexao) { $sqlBusca = 'SELECT * FROM usuario ORBER...
asked by 25.05.2018 / 22:00
1
answer

C # CRUD - Insert Error (Can not add or update child row: a foreign key constraint fails ...)

Good morning, I had been able to do everything right up to this error when inserting something into the database. localhost / phpmyadmin - xampp. It's something with id_user but I do not know what it is. I do not insert a txtbox...
asked by 25.05.2018 / 10:59
1
answer

Inner Join with repeated values

Good morning! Can anyone help me with a question? I have a select SELECT * FROM order INNER JOIN kn_status ON (kn_order.n_order = kn_status.fk_order) WHERE kn_order.fk_cliente='$id' The problem is that in the STATUS table the N_ORDER...
asked by 23.05.2018 / 15:08
1
answer

Error sending data to php with ajax in wordpress

I have this form: <select id="mudar_produto"> <option></option> <option value="#produto_1">Novo Produto Higiene</option> </select> <section class="hide-section" id="produto_1"> <form clas...
asked by 23.05.2018 / 23:01
1
answer

Put page numbers in PHP page with MYSQL [duplicate]

How could I put the page numbers in this paging script with PHP and Mysql? As it looks like this: First Prev 1 2 3 4 5 6 7 8 9 Next Last <?php if (isset($_GET['pageno'])) { $pageno = $_GET['pageno'];...
asked by 29.05.2018 / 15:11
1
answer

When sending data via POST does not insert in the database

I have this form and script on a page: <section class="hide-section" id="produto_1"> <form class="form-validate" id="feedback_form"> <div class="campo"> <fieldset> <h1> &l...
asked by 24.05.2018 / 17:55