Questions tagged as 'mysql'

Tagged questions
1
answer

Warning: mysqli_num_rows () expects parameter 1 to be mysqli_result, string given in

I can not show the data that the query brings me. I work with mySQL and a model of views and controllers. I get this error: Warning: mysqli_num_rows () expects parameter 1 to be mysqli_result, string given in . And the variable is not empt...
asked by 17.12.2018 / 16:49
0
answers

Problem with MySql query inside PHP query

I have the following query in my php code $consulta = "SELECT p.universidad, COUNT(c.cod_cita) as TOTALES, SUM(CASE WHEN p.universidad = 'Latina' THEN 1 ELSE 0 END) AS latina,...
asked by 13.12.2018 / 01:20
0
answers

$ connection-real_escape_string () or mysql_real_escape_string ()?

I'm doing a login, and in my php, to escape characters I do not know if it is advisable to do with mysql_real_escape_string() . <?php session_start(); $conexion = new mysqli("localhost","username","password","DB"); if (!$conexion) {...
asked by 14.12.2018 / 13:06
1
answer

Go through database to get me the total

Good I am taking out a message in case the client has a pending invoice but at the time to do the sum of the totals I am not able to do that I grouped them. Because if there are two products in an order, two lines are created in the database, so...
asked by 14.12.2018 / 10:28
1
answer

Problem with While (mysql_fetch_assoc)

Hi, I'm a programmer who is just starting and I have a problem with While, I'm rescuing a data from an SQL table, so all right, in fact if I do a print_r before the While rescues me without any problem, but when going through the while it does n...
asked by 14.12.2018 / 13:04
0
answers

The app stops when I click on enter

Hello, good evening, I'm trying to login but the app stops when I try to enter the username and password I guess the only thing they need is the java login class: public class Login extends AppCompatActivity { TextView tv_registrar; EditTe...
asked by 12.12.2018 / 07:40
1
answer

How to create a cycle that allows inserting hours with differences of every 15 minutes in the database?

I am using full calendar and php to fill it with events, I recive a form that I made a date and a start time and an end time, what I want to do is program it so that if I set as the initial time 8:00 am and end time 1:00 pm for example I do beli...
asked by 11.12.2018 / 16:39
0
answers

Problem with remote MySQL

Good afternoon, I hope you are well, I want to comment on the problem I'm having to see if someone happened to him and got the solution. I have a program made in visual .NET and this what it does is take information from the tables in my data...
asked by 11.12.2018 / 20:19
0
answers

after end of result set JAVA-MySQL

In the following code I try to make 2 buttons from Arduino send only 1 or 2 and when it reaches java if I press 1 with the help of MySQL it will delete only one number and if I press 2 it will add more products. My doubt is that I can not find w...
asked by 11.12.2018 / 06:49
0
answers

Concurrency and query problem BD

I'm having a problem in my project that is java web with JSF and Mysql which is the following: I have a table in mysql called consecutive that is consulted by users to consult a record that is corresponding to your company and this same reco...
asked by 11.12.2018 / 14:07