Questions tagged as 'mysqli'

Tagged questions
2
answers

Search with date range [duplicate]

In MySQL I have a table that has two DATE fields: data_inicial and data_final . In the System I have a Field (TextField) where I type a date. This date does not need to be accurate, but rather matches the range. Example:...
asked by 05.10.2015 / 23:05
0
answers

show similar product / property with php and mysql

I'm developing a feature on my site to show similar properties by title and valo9r, but my idea did not work: <?php //Armazeno o resultado do titulo da consulta anterior da tabela imoveis em um variável $titulo_semelhante = $results['titulo...
asked by 25.08.2015 / 19:20
0
answers

display list of return items in json format with php and mysql

I'm developing a website for a real estate company, at the moment I'm listing properties and paging the result with sql queries, more than 2000 properties are listed and there is a significant delay in loading the content. I'm thinking of return...
asked by 16.10.2015 / 17:18
2
answers

Data formatting error

Well it's as follows. I'm going to get certain texts from the database, then I'll list them in the web, and when I do, the accents are all square and so on. But when I write in the code with accents and such, everything is normal. And I'm usi...
asked by 09.06.2015 / 01:34
0
answers

Attempting to display rand () after inserting into db

Hello, I'm trying to display a random number with rand () after inserting it into the database. the insertion in mysql works normally, but when I try to display a message with the $ request variable nothing is shown. If I insert something...
asked by 13.03.2015 / 13:26
1
answer

Fatal error in login system

I'm doing a login system in PHP and resulted in a fatal error:    Fatal error: Call a member function num_rows () on a non-object in   C: \ xampp \ htdocs \ avulso-2 \ valid-user.php on line 10 <?php $conecta = new mysqli("loc...
asked by 01.06.2015 / 01:19
2
answers

I can not insert into related tables

I'm in trouble. I normally enter in the table "equipment" of my code and populate normally the BD mysql. However, the "dell" table is empty even though it passes the ID reference from the "equipment" table. By phpmyadmin everything is working...
asked by 24.07.2014 / 18:51
1
answer

Look for integer value in DB

Good afternoon, I'm trying to query an integer value in my DB and save it to a variable, I tried this way: $procuraPreco = mysqli_query($connect, "SELECT preco FROM infs WHERE seis='$seis' and bin='$bin' and quantidade='$qndtd'"); print_r($ret...
asked by 24.08.2018 / 21:02
1
answer

mysqli_insert_id () is returning 0 when used inside an INSERT [closed]

Every time I try to get the id of that first INSERT , by mysqli_insert_id() , it returns 0 in the second insert and returns the correct number in the header below, what can be? require_once('../connects/connection.p...
asked by 26.09.2017 / 20:42
2
answers

inner join mysql 2 tables

Good night guys, I need to link two tables and I can not fix it or find where I'm going wrong. I have two tables: Table 1: br_regiao | id - iduf - name - (1, 1, Litoral) Table 2: br_stat | id - name - (1 - Santa Catarina) Query: nam...
asked by 21.10.2017 / 04:19