Questions tagged as 'mysql'

1
answer

Transform loop while in foreach loop

I need to convert it to the foreach format $query = "SELECT id_prod FROM productos WHERE nombre_prod='$nombre' OR descrip='$caract' "; $result = mysqli_query($con, $query); while ($mostrar = mysqli_fetch_array($result)) { $id_produc...
asked by 21.01.2018 / 11:06
1
answer

Change img SRC with PHP

Well I have the img tag and when I click on a div with id="btnsiguiente" I change the path of img , doing this with javascript is easy if I create an array with the routes inside but if the routes of the I have images in a da...
asked by 19.01.2018 / 15:11
0
answers

does not store the variable $ _SESSION in php

   SESSION.php <?php session_start(); error_reporting(0); include('conexion.php'); $usuario = $_POST['usuario']; $clave = $_POST['clave']; $tabla = $_POST['tabla']; switch ($tabla) { case 'docentes': $getUsuario = mysqli_query($c...
asked by 14.12.2017 / 07:30
0
answers

How to check if there is a record on vb.net and mysql

I need to verify if the record exists in the "Product" field to make an update in the. Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim Conexion As New MySqlConnection("data source=localhost; user=root...
asked by 18.12.2017 / 23:34
1
answer

Amiagible URLs with form - submit

How can I use user-friendly URLs? form - > submit I already have the friendly URLs made in the .htaccess, they work! But pressing the SUBMIT button takes me to the normal URL (GET) http://www.mi.web/stats.php?Jugador=Abcedario Bu...
asked by 16.11.2017 / 15:00
0
answers

access to mysql access [closed]

cordial greeting. I need to convert a query that I have in acces to pass it to mysql and I managed to convert most of the query but the mathematical operation part did not leave me and I get an error ... the query is this .. Access query...
asked by 20.11.2017 / 13:39
1
answer

I get an error when importing csv

hi I'm doing the export and import in php + mysql + csv of a table with several records some 3000 records another 10 and with those of 10 records exports and imports normal, with 3000 or 2000 records exports normal but I do not care and I get th...
asked by 19.11.2017 / 10:51
1
answer

Conversion of date saved in date format ('d-m-Y')

I am saving in my Database the date of the record in a field called Date , the input is of type date . It turns out that the data is being saved as follows 2017-11-28 , that's the least of it, the problem arises in which...
asked by 25.11.2017 / 00:02
1
answer

Problems with queries in mysql 5.6 (mysql)

I have the following query: SELECT ncuenta,dcuenta, (select SUM(saldo) where saldo>0) debe, (select sum(-saldo) where saldo<0) haber FROM tabla GROUP BY NCUENTA ORDER BY NCUENTA; Which works for me but in warmserver version o...
asked by 22.03.2018 / 22:43
0
answers

How to recover the path of an image in Database?

I have a problem recovering the path of an image in my database, the image is uploaded correctly, the route is captured well, only that the word Array comes out first, and I do not have idea because, I need you not to say that in order to use...
asked by 22.03.2018 / 19:59