Questions tagged as 'mysqli'

Tagged questions
2
answers

Error Undefined variable: mysqli_query

I do not list my data in a table, I do not know if I'm failing to call the query. The error is: Error Undefined variable: mysqli_query Code <?php include ("db/conexion.php"); $query = "SELECT * FROM infraccion"; $result =$co...
asked by 30.03.2017 / 20:05
1
answer

Place message of "No records exist" in statement prepared using search filter

Create a search filter using prepared statements (this checks which fields are empty or not in the search form and adds the variable representing that field as a AND for the query SQL , so that it builds the query: "SELECT * FROM...
asked by 06.04.2017 / 15:19
2
answers

Problem preventing registration of duplicate users PHP - MYSQL

I have an Android application where I access a MySql database by php. I am trying to make that when a user tries to register and already exists, he does not insert the data into the database. The problem is that by putting the if th...
asked by 07.09.2016 / 12:00
1
answer

add dynamic rows to a table with data from another table

Good morning, I need help to do the following: I need that from a modal with a table of data (extracted from my database), they are added to another table, dynamically. This is the design of my modal, showing information from my database:...
asked by 19.06.2016 / 15:53
2
answers

Count occurrences followed by a value in a table

Hello, I have a table that has a value ID and other values among which is nombre . ############### # ID # Nombre # ############### # 4 # Juan # ############### # 3 # Juan # ############### # 2 # Juan # ############### # 1...
asked by 17.03.2017 / 05:51
2
answers

SET statement prepared mysqli

What is the correct way to perform the following query? I have a function to which I want to assign a series, if I execute it directly in the engine it generates the div concatenated, but in the PHP it throws an error. If I decl...
asked by 09.02.2016 / 14:14
2
answers

Compare a range of dates with BETWEEN in mysql

I am creating a module in a system with PHP and MySQL, where I am making an agenda for events. I have a table with the following fields: id_evento nombre_evento fechaInicial fechaFinal id_ubicacion...
asked by 19.02.2016 / 17:35
1
answer

How to show the data of a logged in user

Good, some way to show the data of a logged in user? I need that after a user logs in, in another page show me the data of this user: I have two tables: And this is my code with which I am validating and trying to extract the user...
asked by 26.06.2016 / 10:27
2
answers

Link several tables to another to obtain groups of records

A few weeks ago I created a database to use it in my Android app. It turns out that these two weeks I've been thinking about a problem I had, and no matter how many solutions I got, they gave me errors and I do not know what to do anymore. I'...
asked by 03.06.2016 / 15:33
2
answers

Problem with login

I'm trying to make a login with a database and PHP, which made progress and it seems to work, but lets me enter with any name and password. I set the PHP of the server to 5.6 and I think the problem is using mysql_real_escape_string in...
asked by 28.09.2018 / 09:07