Questions tagged as 'mysqli'

Tagged questions
0
answers

Pick up the next line result

Hello! I'm working on a series guide and I'm looking to create a push button, in case when it's clicked, it will go to next episode ... On the screen there is an advance button that would change the episode. I just want that when I click, I a...
asked by 12.01.2018 / 01:47
1
answer

Duplicate result in MySQL no while

The table has two columns, one of user data and another of user points, user points works like the bank statement scheme, however I need to return only the last value, and I did so SELECT 'usuario'.*, 'pontos'.'ponto_valor' FROM 'usuario' INNE...
asked by 16.01.2018 / 19:39
1
answer

Problems with query in mysql

Good afternoon. I have a query in my db that has to bring the user name and id data from the users table and the commission table brings the commission, award, month, and a month field consisting of year and month ex 201801. My query is this...
asked by 22.01.2018 / 21:18
0
answers

Different results between localhost and on the server

I have the following query that works fine on localhost but when I send it to the server it does not work What can it be? SELECT CONCAT( mes, '/ ', ano ) AS data, IFNULL( SUM( total ) , 0 ) AS Total FROM lc_controle WHERE tipo_venda ='A...
asked by 12.01.2018 / 21:04
1
answer

Unexpected result in database query

<?php class Login{ public function logar($email,$senha){ $connect=new DB; $connect=$connect->conectar(); $sql="select * from usuarios where email='$email' and senha='$senha' and status='1' limit 1;"; $bu...
asked by 26.12.2017 / 23:17
1
answer

Database Error

I'm trying to make every time the user clicks a button an UPDATE happens, but for some reason gives No database selected , what's wrong with this code? Update.PHP <?php require_once 'Classes/BancoDAO.php'; $codTarefa=$_GET['codTa...
asked by 12.12.2017 / 03:33
2
answers

How to pull a data from the same field?

Personally, I know that my question may be silly ... But how can I pull data from a field only in SQL. Is that actually I'm putting together a report of the company's products ... There are products that drive it's value '1' but it when it's sol...
asked by 12.12.2017 / 13:54
1
answer

Error in selection query on social network requests [closed]

Hello, in my project I need to list the people and the requests received by the user, but when it comes to listing people, I need to list only those that have not sent or that the user has not sent requests, in this case, my friendship table save...
asked by 29.11.2017 / 16:17
0
answers

Problem mysqli_fetch_assoc () | it's nothing to do with boolean;) [duplicate]

I'm new here, I have a problem in the code below: can someone give me a light? Code.: <tbody> <?php while($linha = mysqli_fetch_assoc ($resultado)) { echo '<tr>'; echo '<td>'. $linha['ID'] .'&l...
asked by 05.12.2017 / 00:12
1
answer

problem connecting to database [duplicate]

Warning: mysqli_select_db () expects parameter 1 to be mysqli, string given in C: \ xampp \ htdocs \ lojavirtual \ connect.php on line 3 Could not connect     
asked by 27.11.2017 / 04:43