Questions tagged as 'mysqli'

Tagged questions
1
answer

Mysqli - multiple help consultation

I need to consult the following id where the following is fulfilled: Values entered by the user from 1 to 5 (people per room), and I have to obtain the id's of the hotels where it is true that there is a place, for example; ROOM-1 : 2 PAS...
asked by 18.09.2018 / 14:35
1
answer

Check if "tag" is available and show it in a SELECT

I realize a system that basically is a logs of loan equipment. What I intend you to do is that users who need a computer to loan make a record, which is necessary to validate if the equipment is available or not for its use, and only appear in...
asked by 27.06.2018 / 08:50
1
answer

Array only prints last record

I have the following structure. global.php <?php define("DB_HOST","localhost"); define("DB_NAME", "prueba"); define("DB_USERNAME", "root"); define("DB_PASSWORD", ""); define("DB_ENCODE","utf8"); ?> conexion.php <?php require...
asked by 30.01.2018 / 14:32
1
answer

Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, boolean given in: [duplicate]

I get the following error:    Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result,   boolean given in C: \ Program Files   (x86) \ VertrigoServ \ www \ sdp \ search.php on line 25 <?php function nombreofcyciu(...
asked by 12.02.2018 / 17:20
1
answer

sql query with conditions

trying to solve a request from a client I ran into a problem and wanted to know if it is possible to make an sql query with conditionals. My problem is the following at the moment I have a query that allows me to bring information from 3 tabl...
asked by 19.10.2017 / 18:11
1
answer

Error with fetch_assoc MYSQLi

I come to you since I am stuck in an object-oriented MySQLi function. I try to get the ID (A_i) of the corresponding tokens of the users, in a table called Tokens. The problem is that it does not give errors and also returns an empty result....
asked by 25.10.2017 / 21:21
1
answer

Correct array format in PHP 5.3

I have the following code to have the records of a database: <?php include '__conexion.php'; require_once 'funciones/passwordLib.php'; // Libreria de PHP5.5 Hash de contraseñas ini_set('max_execution_time', 300); //300 seconds = 5 mi...
asked by 27.04.2017 / 13:40
2
answers

I do not work fetch_all (MYSQLI_ASSOC)

I am a student and in one of my video classes I realize that my code is broken by using the function fetch_all (MYSQLI_ASSOC) verify the syntax of my code again and again until I have done it practically from the beginning and not yet I can solv...
asked by 03.10.2017 / 00:19
2
answers

Id of the users table from the login

Users table: iduser, name, user, password, group In the login you must enter username, password and group <?php include('00_conn.php'); $consulta = "SELECT * FROM $t98 WHERE (98_username= '$usuario' AND 98_clave = '$clave' AND '98_grupo = '...
asked by 20.09.2017 / 00:30
1
answer

Perform cycle while from a MySQLi query in PHP

today I have fallen into the following problem, I am making a student management system in which the data is stored in a MySQL database, but when I want to list them all, I can not do it, I am using the function mysqli_fetch_array (), I've alrea...
asked by 05.10.2017 / 01:48