Questions tagged as 'mysqli'

Tagged questions
1
answer

When registering user, I need to verify in the database if this user already exists and display error message

Below is my code. It does everything but hangs on the "user already registered" message even though I enter a different user in the field! Notes: $con is the connection to the database that is correct; login is the id in the fi...
asked by 07.12.2018 / 13:53
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
0
answers

Error when registering data in the database :(

I'm trying to make a business registration system, but it does not work. I'm doing everything right to see. The bank is the same, the variables are right and the functions are as well. I do not know what's wrong. Can someone help me? (Note: I am...
asked by 28.11.2018 / 19:44
0
answers

My mysqli database does not edit data and it already falls on the else

When you click the edit button, it already drops directly into else : }else{ $_SESSION['msg']= "<p style='color:red;'>Equipamento nao Editado com Sucesso!</p>"; header("Location: Edit_equipamento.php?CODequipamento= '...
asked by 04.12.2018 / 17:49
2
answers

Error registering form in database

I have the following resolution, I am not able to register in the bank. I've changed a few things but there are always these errors: Warning: mysqli_set_charset() expects parameter 1 to be mysqli, resource given in C:\xampp\htdocs\envio\conect...
asked by 05.12.2018 / 17:29
0
answers

Loop while showing only the first record of the database

Hello, my system has a problem, I have 2 tables: alunos id | nome frequencia id | id_aluno But in the while loop where I connect the two tables by id and id_aluno , it only displays the first record of the database, and there...
asked by 30.11.2018 / 11:43
1
answer

BD registration with pre-filled fields

I am creating a registration system on top of a system I found on the net. In my system there are only 2 fields email and password, and the password will already be pre-registered, thus only the user will have to fill in the email. I am having p...
asked by 19.03.2014 / 18:14
0
answers

Delete line according to the difference of dates in MySQL

I'm trying to delete rows from a table using the difference between the current date and the date the row was registered as a reference. Here's my code: DELETE FROM lixeira WHERE diferenca > 60 IN ( SELECT DATEDIFF('2018-11-20',data_exc...
asked by 20.11.2018 / 20:59
0
answers

Charset Error - MySQL, PHP

I have a MySQL database with standard UTF8 charset (Hostinger VSP, Debian 8, MySQL View 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3), the data is inserted into the database by a app through a NodeJS REST API, and throu...
asked by 21.11.2018 / 04:33
0
answers

Search for recipes with ingredients that you enter. How can I do this?

                                  Search for recipe with the ingredients that the user entered          In this code below, I can fetch recipes that have the ingredient that it reported. But I want the user to enter the number of ingredients he...
asked by 18.11.2018 / 18:12