Questions tagged as 'mysqli'

Tagged questions
0
answers

Entry query in PHPMYSQLI

Hi what happens I am making an entry for a php page, but I want that in the login form only login to the user who identifies with admin and password 12345, everything is registered in the database. $resultados = mysqli_query($conexion,"SELECT...
asked by 31.05.2018 / 17:12
0
answers

Install keyring in MySQL

I am trying to install and configure the keyring plugin to be able to encrypt an existing database in MySQL. My version of MySQL is 5.7.19-0ubuntu0.16.04.1 In the configuration file /etc/mysql/my.conf I have put the fo...
asked by 24.05.2018 / 10:32
0
answers

doubt when inserting into mysql

I try to make an insert in android but I still can not get the php code inserted correctly. <?php require_once("conexion.php"); $data = empty($_POST) ? json_decode(file_get_contents('php://input'), true) : $_POST; //$usuari...
asked by 23.05.2018 / 04:10
1
answer

ERROR Could not fetch mysqli and mysqli_fetch_assoc () expects parameter 1 to be mysqli_result

GIVE ME THIS ERROR:    Warning: mysqli :: query (): Could not fetch mysqli in C: --- on line 67   Warning: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result,   null given in C: --- on line 69 <?php if (isset($_GET['...
asked by 19.05.2018 / 11:46
2
answers

PHP Error in MySQLi search engine

I recently managed to create a mysqli search engine in php. The problem is that if you find more than 1 result simply put the same user id and name. if(!empty($_POST)){ if(isset($_POST["username"])){ if($_POST["username"] !=""){ inclu...
asked by 16.05.2018 / 21:37
0
answers

Problem with MariaDB database, InnoDB tables, queries are blocked

Since a few weeks ago I am having problems with one of my databases, all the queries made are blocked and they take a long time to execute, regardless of which table they are made in (Even queries like SHOW PROCESSLIST are slow) This a...
asked by 12.05.2018 / 21:09
1
answer

Total count add sql [duplicate]

I want to show the total registration and at the same time add that total SELECT t.empresa, COUNT(t.idespecialidad) AS count, e.nombre AS nombre_especialidad FROM tickets as t INNER JOIN especialidad AS e ON t.idespecialidad...
asked by 10.05.2018 / 21:49
0
answers

Structure of the sepomex table

I am downloading the SEPOMEX database to use it in one of my applications, the question is that they ask me to break down the structure of that database. In my first image I show the fields that I am going to take from the database (highlighte...
asked by 09.05.2018 / 17:28
0
answers

Error showing a query to the database with php

I want to show in a select tag a base table using mvc classes or model, but I do not understand why I get this error.    Notice: Trying to get property 'num_rows' of non-object in /opt/lampp/htdocs/php/projectPhp/model/Videojuegos.php on line...
asked by 28.04.2018 / 06:01
1
answer

have count php list with 2 parameters

Tengo la siguiente funcion que me cuenta los tickets donde los tipo de solicitud sean iguales a 2 o a 5. function cuentaticketspendienteempleado($conexion){ $pendientes = (mysqli_query($conexion, "SELECT COUNT(*) AS conteo FROM tic...
asked by 23.04.2018 / 21:41