Questions tagged as 'mysqli'

Tagged questions
1
answer

Perform mysql query of two tables via php

Good afternoon, guys. I have a problem that I no longer know how to solve. I have the following mysql query in php: mysql_select_db("banco", $conexao); $resultado = mysql_query("SELECT * FROM pessoa WHERE id = '" . $cod . "'"); whil...
asked by 14.05.2015 / 22:08
1
answer

Make an update of several fields and values in the same table

I'm making a very simple inventory control system, and in the edit part of the products, I'm doing it this way: I query in a database, and clear text fields with the name of the products and the respective quantity , as in the attached image: In...
asked by 15.07.2015 / 00:11
1
answer

Standardization for MySQLi use

I am researching on the use of MySQLi and I have seen many articles, but each one always has some particularities about the pattern of development, my question anyone already set a default? For example something that can be followed with best pr...
asked by 04.03.2015 / 20:09
3
answers

Search by selection field

I'm creating some filters to search for products, having the products all visible, I would like to know how I can make a selection field and through the category that the user chooses, only the products of that category would appear. I have the...
asked by 19.01.2015 / 16:33
3
answers

How to make a script in php inserted in a page through a "require" run from time to time?

In the answers to the question of the link below I posted how I was able to delete from the database the information of the user that does not activate within 24 hours your registration through the link sent to your email: How to delete the...
asked by 22.08.2014 / 01:48
3
answers

GROUP BY last record by month and year how to do?

I'm doing a query in the database, follow my table below id | valor | mes | ano | 1 39.69 3 2017 1 7.69 3 2018 3 9.69 4 2015 3 3.69 2 2016 2 5.89 3 2017 2...
asked by 18.12.2018 / 19:07
1
answer

Avoid Duplication in the PHP + MySQLi Registry

Good evening! How do I prevent registration with the same information? Currently my "processa.php" is this way, and I wanted to include the function mentioned above ... <?php session_start(); include_once ("conexao.php"); $nome = fi...
asked by 03.09.2018 / 00:21
1
answer

Syntax error in Insert Mysql

I can not solve the error below: Notice: Undefined index: HTML_cor_TAREFA in C: \ Users \ User \ Desktop \ pi Fe \ Order2 \ CadastraTarefa.php on line 14 You have an error in your SQL syntax; '', '', '', '', '', '') 'at line 1 (check the...
asked by 28.11.2017 / 12:40
1
answer

How to print the selected database ID? [closed]

Is there a function to get information from a specific ID of my database and print with domf? My code: $id = "30"; $result_usuario = "SELECT * FROM cadastro WHERE id = '$id' LIMIT 1"; $resultado_usuario = mysqli_query($conn, $result_usuario...
asked by 03.11.2017 / 15:39
1
answer

Problems with the query in the database (Search system)

I am trying to create a search system in db however it is returning only one result, the last address in the table (I had managed to get them all returned, however after changing the layout I went to test and did not give more, even deleting eve...
asked by 04.04.2017 / 01:14