Questions tagged as 'mysql'

Tagged questions
1
answer

SELECT DEPENDENT PHP

I hope you can support me with this: What I want is to obtain the ID of the school that was selected in the SELECT and then depending on that, pull it in a variable and place it in my SQL QUERY, so that depending on what it appears the grade and...
asked by 19.07.2018 / 01:22
0
answers

Graph mysql data by date range with Highcharts

Hello to the whole community! I would be very grateful if someone with more experience could give me an orientation on the next topic ... I want to show data from mysql to a highcharts graphic ... But I would like you to show me the data in a ra...
asked by 24.07.2018 / 07:27
1
answer

Select dependent save id, but I need to save the variable

<code><!-- desde aca empieza select dependiente --> <?php include('db-config.php'); $query = $db->query("SELECT * FROM provincias ORDER BY provincia ASC"); $rowCount = $query->num_rows; ?>...
asked by 24.07.2018 / 03:24
0
answers

Very slow query in WordPress

My website is very slow and I have seen that it is due to the following query, which takes between 10 and 20 seconds and I still do not know why. function get_car_versions($car_id) { $args = array( 'post_type' => 'version',...
asked by 17.07.2018 / 14:25
0
answers

Error 500 on Debian 9

Good morning, I have this failure with which I woke up today, I comment that two days ago I did not have any kind of problems, comment that I'm using prepros , php , < strong> jquery , mysql , in debian 9 , and restart the services of these,...
asked by 17.07.2018 / 19:40
0
answers

MySQL Group Replication: Error with MySQL Router

I have a problem trying to instantiate the Mysql Router . When executing this command mysqlrouter --bootstrap [email protected]:3306 --directory /opt/myrouter -- user=mysqlrouter --force This error appears:    error: no result returned f...
asked by 19.07.2018 / 21:32
1
answer

LIKE %% multiples in PHP and MYSQL

I have the following code: $sql="SELECT * FROM 'jsonBuscador' WHERE 'tags' LIKE '%$bafle%' AND ('tags' LIKE '%$marca1%' OR 'tags' LIKE '%$marca2%') AND 'tags' LIKE '%$size%' AND 'tags' LIKE '%$sistema%'"; in which I try to select the res...
asked by 19.07.2018 / 23:49
1
answer

Validate Delete button, when you have not selected anything java and mysql

It works to me when deleting data from the B.D but when I do not select anything, I must leave the message that indicates that I select a row and I also get Exception. This is my Code. int fila =tbproductos.getSelectedRow(); String valor =(St...
asked by 20.07.2018 / 00:43
1
answer

How to make multiple UPDATES in a MySQL PROCEDURE?

How do I make two or more UPDATES run in the same PROCEDURE. CREATE DEFINER = root@localhost PROCEDURE sp_anularFacturaBoleta( IN idFacturaBoleta VARCHAR(11) ) BEGIN UPDATE detalle_factura_boleta SET cantidad = 0, precio_venta = 0, val...
asked by 18.07.2018 / 17:39
0
answers

Error E / JSON Parser: Error parsing data org.json.JSONException: Value br of type java.lang.String can not be converted to JSONObject

Very good to all and first of all thank you for reading this I've been pulling my hair for a couple of days because I try to create an application in android studio, but I can not get past the attempt to create the user account, I use PHP, wa...
asked by 17.07.2018 / 10:08