Questions tagged as 'query'

Tagged questions
3
answers

mysqli and php query does not work

I want to show a certain number of "products" on the screen, I create a series of bootstrap letters to store the information there. I generate my connection (I clarify that the connection is perfect): <?php $conexion = mysqli_connect("lo...
asked by 17.04.2018 / 06:27
2
answers

Query access keysensitive

I have a query of the style: SELECT * FROM tabla WHERE keyTabla = 'cadena'; What I want is for this query to compare the key and the string but discriminating upper case of lowercase.     
asked by 13.12.2017 / 15:32
2
answers

How to make this query in sql server 2014?

I have a problem when trying to make a query, I explain what I have: I have a schedule of X device, to calculate the hours of operation against the hours that have failures, what I need is a query to totalize the hours of operation per month....
asked by 27.09.2017 / 19:10
1
answer

Change date format Codeigniter 3 query builder

$this->db->select("DATE_FORMAT(cliente.fecha_reserva, '%M %e, %Y') as formatted_date", FALSE); This code gives me the following format: June 14, 2017 How do I get the format dd / mm / yyyy? Thanks     
asked by 20.06.2017 / 16:29
1
answer

Error with query ();

Good morning, I've been with this error for a while and I'm unable to solve it to see if anyone can help me out, I'd really appreciate it! $base=new PDO('mysql:host=localhost; dbname=pruebas', 'root', ''); $base->setAttribute(PDO::ATTR_ERRM...
asked by 06.07.2017 / 10:54
2
answers

How to show duplicate MySQL and PHP records?

How can I get duplicate records of a product? I'm developing a site to sell video games online, I have a search bar to show the titles by entering their SKU, but I want to show them the games that have their duplicate. For example: ===========...
asked by 16.01.2017 / 05:21
1
answer

Help separating values and assigning them to a variable using MySQL and PHP

Greetings I have the following case: I own this table: id monto afiliacion 1 10 BASICO 2 20 AVANZADO 3 30 PREMIUN My query is this: $plan = "SELECT monto, afiliacion FROM monto_mensualid...
asked by 17.11.2018 / 03:18
1
answer

Error in parameterized query: TypeError: list indices must be integers, not str

I am developing a GUI that manages my database in Python 2.7 that connects to a MySQL database. You can already insert, consult and delete but what you can not do yet is update with the UPDATE statement. I get the following error: Exception in...
asked by 11.10.2018 / 23:59
1
answer

Count mysqli fields

**** I have a table called places and the field I want to count is called state the values that can have states is 0 = processed, 1 = accepted, 2 = rejected I want you to print them like that, I already did count but I get row by row and don sum...
asked by 17.10.2018 / 03:01
1
answer

Decimals when editing record with modal

Good morning when doing the edition of a record that is the total of the invoice I get the price as well; 1,500.00 € which is as I want, but when editing the record as I get 1,500.00, if I do not edit it becomes 1.00 € and if I edit it but leavi...
asked by 19.09.2018 / 07:32