Questions tagged as 'mysqli'

Tagged questions
1
answer

Problem with MySQL with PHP

I do not know how to return each value in a different variable. My code: $query = "SELECT id_tienda,id_prod from prod_tienda where id_prod='$row' "; $result = mysqli_query($con, $query); while ($mostrar = mysqli_fetch_array($...
asked by 20.01.2018 / 12:33
1
answer

Connect database site php5 to php7 [duplicated]

I'm trying to move my site to a server with php7 with mysqli: I have a conexion.php file that I modified and now looks like this: <?php $hostname_conexion = "localhost"; $database_conexion = "opentach"; $username_conexion = "root"; $p...
asked by 12.01.2018 / 12:50
0
answers

Problem when grouping data in query

I have 3 tables: "Clients" with id, client_code, c_id (client's CRM code), name, and cif. "Machines", with the fields id, id_maq (CRM code), install_date, duration, tariff_id, serial_num, customer_code, customer_id (crm code), cost_id and...
asked by 11.01.2018 / 20:07
2
answers

Having a combobox showing the data of a COLUMN of a DB, how can I fill inputs with the other values?

I have a database with a table called "sites" (phpmyadmin example): I have a form where I have a select which I already have the query to the table "sites" to show only the data in the column "Site" of this same table, what I'm looking for...
asked by 27.12.2017 / 23:19
1
answer

How can I give value to inputs depending on the value of a combobox?

Could you help me with giving a value to 4 inputs depending on the value I take from a combobox that loads the column of a table where all my data is? For example if on my page I use the combobox and I select the value "FIELD" (as it comes in...
asked by 08.01.2018 / 01:06
0
answers

Empty an array in while

I have the following problem, in an arrangement that I fill in another page I have names of fields of a bd, what I want is to make a query select but with the fields of my arrangement Here I bring the fields of the bd that I choose on the pre...
asked by 18.12.2017 / 17:21
0
answers

Delete a column if you do not add another column in php with prepared statements

I have a question, I hope you can solve it for me. First of all, I have to clarify, that the code I did works correctly, but not at all. I explain first what I want to do. I am practicing with PHP and MYSQLI, and I am creating a system of use...
asked by 19.12.2017 / 01:11
0
answers

How can I get codeigniter a COUNT () or a SUM () of the same value?

Well, that ... I'm making an application with Codeigniter, and everything is going very well, but to present a summary of data I'm looking for a solution to get the sum of the number of times that value is positive (but in this case it is litera...
asked by 15.12.2017 / 08:03
1
answer

Problem when bringing data from a base

I'm having a problem. What I want to do and I'm trying to achieve is a menu where it brings as "main link / s" the categories eg: "Video card" And that when you click, show the video plate marks. Ex: No Click: Video Plaque 1st Click: MSI...
asked by 23.12.2017 / 20:52
1
answer

Error in inserting order of the order?

When sending the data to complete order, only the data is inserted in the first table order but in the table order_details does not record data. And it is addressed to /index.php?a=orderfail The structure of my table i...
asked by 03.12.2017 / 01:46