Questions tagged as 'mysqli'

Tagged questions
1
answer

Continue to search MySQL after a particular ID

Good evening, I would like to know how I can continue a MySQL query through PHP ( query () ), example I did a search and found a user ID 1584, and I want to search for another, but starting of ID 1584. I tried with LIMIT, but I did not get th...
asked by 09.12.2018 / 01:29
1
answer

Search by filter using mysql

Hello! I need a search with filter relative to the page of product by category, that is, when searching for products by a certain category show in the sidebar filter options like: new or used, minimum price up to maximum price, etc. for better u...
asked by 03.06.2016 / 04:16
1
answer

How to return the total value of items in a table?

I want to know how to return the total value of items, I use mysqli to connect to the bank. Table ec_despesas have the following fields: (more details of the structure in this image ) id, aba, status, nome, categoria, conta, valor...
asked by 17.11.2014 / 19:53
1
answer

Login system giving error! [closed]

I'm trying to make a login system, I made the form so that when the button was pressed it would send to a page with the following code: <body> <?php $conexao = mysqli_connect("localhost", "123456", "senha","banco") ?>...
asked by 25.09.2017 / 20:20
2
answers

php array for json will not all data

Hello, I'm having a problem with my code and I wanted your help. I need to get data from a table and send it as json, I have 10 items in my table but json just sends one. Table: Location InmycodewhereIputallPHPandMsqliinclude("connect....
asked by 16.07.2017 / 06:44
1
answer

mysql query problematic [closed]

I have the following data admlogin: admin1 admsenha: admin admlogin: admin2 admsenha: admin admlogin: admin3 admsenha: admin <form action="#" method="post" id="frm_login_p" name="frm_login_p"> <input class="form-control" type...
asked by 09.11.2018 / 21:49
1
answer

Referenced method is not found in subject class in PHPSTORM

In my code, in PHPSTORM it returns that method fetch_all was not found. <?php $conn = require 'connection.php'; $result = $conn->query('SELECT * FROM users'); $users = $result->fetch_all(MYSQLI_ASSOC); ?> As I've just...
asked by 04.09.2018 / 05:04
2
answers

PDO and mysqli are the only options for working with database in PHP? [duplicate]

And if I needed to use a database that was not supported by the PDO, what could I do? After all, what does the PDO do underneath the cloths? Does it use mysqli?     
asked by 11.07.2017 / 00:34
1
answer

Error "Warning: mysqli_query () expects parameter 1 to be mysqli, null given" [closed]

I'm developing an API in PHP, which is hosted by Hostinger. However, when I do the SQL query in MySQLi, I get the same error, no matter what changes I make in the code: Warning: mysqli_query () expects parameter 1 to be mysqli, null given and...
asked by 30.11.2015 / 20:23
1
answer

Warning: mysqli_query () expects at least 2 parameters, 1 given in C: \ wamp \ www \ ProcessWork \ proceslogin.php on line 22 [closed]

<?php // Busca as variaveis $login e $senha $login=$_POST['login']; $senha=$_POST['senha']; // Conecta ao servidor e selecione a database. $conn= new mysqli("localhost","root","","registro"); if($conn->connect_error){ die("Falhou a l...
asked by 11.03.2015 / 12:16