Questions tagged as 'mysqli'

Tagged questions
3
answers

How to make an INNER JOIN bringing everything from two tables and one more "max" in a specific field?

Good people, to be more specific I have two tables. table 01: ...andtable02: ...andIwouldliketodoa"select" bringing all of these two tables, but where in the "dots" field (table 02) you have the highest number of points, how to do that? Eg...
asked by 16.11.2017 / 11:50
1
answer

PHP, error making query [closed]

My problem is that I want to make an appointment, but I can not get all the records, and this is what I can not do. I will change to SQL later, so I left it to test. Can someone help me?? This is the Error    WARNING: Mysqli_query () expec...
asked by 29.11.2016 / 17:07
1
answer

Consultation with pause? [closed]

I'm doing a dynamic php menu where I would not use a query inside another, I'm currently looking at the CATEGORY table of the category name and inside it I'm searching in another table for the results that I have in the category field, in the CA...
asked by 03.01.2018 / 22:24
1
answer

Adding a foreign key in mySQL

I'm still learning how to create tables in MySQL and I'm having some difficulty. If it were to create a table with your relationship, it would create like this: CREATE TABLE estilo ( codigo BIGINT(20) PRIMARY KEY AUTO_INCREMENT, nome V...
asked by 12.09.2016 / 19:55
1
answer

how to display user data on a bootstrap card after login is validated

Hello, I'm developing a real estate site where I want to store user information after login, I'm trying to use session, but I'm not having success in storing my user information in the variables, on page after login where I was to aparecero name...
asked by 23.11.2018 / 17:28
2
answers

Database not returning any value

I have the following code: $sql="SELECT * FROM imoveis WHERE (suite LIKE '%".$suites."%' OR banheiro LIKE '%".$banheiro."%' OR quarto LIKE '%".$quarto."%' OR garagem LIKE '%".$garagens."%')...
asked by 11.12.2018 / 00:00
0
answers

How to enter more than one record in the Bank [closed]

I'm making a call list and loaded the students with While. But when I click Submit, it only sends the last record <?php require_once("../conexao/conexao.php"); ?> <?php // teste de segurança session_start(); if ( !isset($...
asked by 05.01.2019 / 17:37
1
answer

When mysql_fecth_assoc, do not you think, it kills the rest of the code, how to make it return something?

Hello, I have a problem with this function when deleting, I search for what will be compared, and I put two delete conditions, because I need it to delete two tables in one condition, and if there is nothing in the other table, delete only one,...
asked by 28.04.2018 / 15:49
1
answer

Post system

I think the title n was very clear but I will explain right here what I need and I am not getting good results. Well what I'm trying to do is the following. In the link on my page it stays that way - > "www.site.com/Teste?cadastro=1"...
asked by 08.12.2017 / 17:00
1
answer

Notice: Undefined variable: connection [closed]

Recently I changed all my code mysql to mysqli . But that gave me a lot of headache. It gives me the following errors: Notice: Undefined variable: conexao in D:\Programas\wamp64\www\admin\css\header.php on line 44 Warning: mysqli...
asked by 10.10.2017 / 02:38