Questions tagged as 'mysql'

Tagged questions
2
answers

consume a PHP service on Android

I am trying to consume a Service from Android, and it does not mark me error but it does not show me the records My PHP Code I changed my PHP Code and I still can not get the records. <?php $consulta=$_GET["Code"] try{...
asked by 06.03.2017 / 23:34
0
answers

Problem connecting mysql database on vb.net

Greetings, I have wanted to connect a mysql database in an easy way to a DataGridView, but when I want to connect it in Visual Studio I always get an error. I have reviewed everything and it does not have any error, the MySql connector...
asked by 12.03.2017 / 20:24
3
answers

How can I change the name of an image when I save the image in a folder and in the database?

What I want to know is how to change the name of an image that I will ask in an html form to save its name and extension in the database and the image in a corresponding folder. What I do not want is that if a user uploads an image with the s...
asked by 13.03.2017 / 00:28
2
answers

MySQL: Query depending on the value, not the name of the column

My question is this: I have a Mysql table of 500 columns and I want to get all the records whose values are different from 100, and despise the columns with that value. For example: Columna1 = 100, Columna2 = 60, Columna3 = 100, Columna4 =...
asked by 04.03.2017 / 18:26
0
answers

Undefined offset: 245 phpmyadmin when inserting json

I have the following json in a mysql column { "links_normales": [{ "item_submenu": "01" }, { "item_submenu": "02" }] } When I enter I get Some errors were detected on the server! Check the footer of this window....
asked by 08.03.2017 / 06:27
0
answers

Connection Refused when trying to connect to MySql database

I'm trying to access a MySQL Database from a Java class with the JDBC Driver, but it always gives me the exception java.net.ConnectException: Connection refused. This would be my Java class (javaSQL.java): package javasql; import java....
asked by 24.03.2017 / 12:29
2
answers

Terminal number script in php [closed]

I have tried to create a script that will help me to carry the code of each person and the variant is that it is not an auto increment of it, that is, Axis: The number terminal is filled in the following way 0 0 0 which the increase will be seen...
asked by 24.02.2017 / 00:48
1
answer

Add range of BD values in PHP

I'm doing a project in which the user can select a range of months (eg January-May) and I select the data available in my database to add them using PHP. This I must do for five different venues. The algorithm is like this: +seleccione meses:...
asked by 23.02.2017 / 15:54
1
answer

Divisions in consultation to table

I'm starting with MySQL and Highcharts , to show graphs of some sensors. The first thing I do is a query to save the data in a array . I do it like this: <?php $con = mysql_connect("localhost", "", ""); if (!$con)...
asked by 03.03.2017 / 21:20
1
answer

Concatenate two columns and add their quantities mysql

'function table_format_formation ($ ven_id) { $sql = "SELECT SUM(vd.tb_ventadetalle_can) as cantidad,cg.tb_categoria_nom, m.tb_marca_nom,GROUP_CONCAT(DISTINCT pr.tb_presentacion_nom) AS talla,vd.tb_ventadetalle_preunilin, (SUM(vd.tb_ventadetall...
asked by 02.03.2017 / 16:13