Questions tagged as 'mysqli'

Tagged questions
2
answers

Why do accumulatives accumulate in a cycle that must be presented separately in PHP?

I have a table that generates records with different values, for each record there will be a value called atenuante which represents a selection made with checkbox . These values are saved as a string de la forma 1-2 and...
asked by 26.04.2017 / 17:02
1
answer

Warning: mysqli_query () expects parameter 1 to be mysqli

I have the following code <?php function consulta () { global $conexion; $dbhost = "localhost"; $dbuser = "root"; $dbpass = ""; $bd = "alumnos"; $conexion = mysqli_connect($dbhost, $dbuser, $dbpass, $bd); $result = mysqli_query('SELECT...
asked by 28.09.2017 / 06:15
2
answers

Help with .htaccess - Url Friendly

I have a website developed in php and mysql now I want to use URL friendly to my links. I have for example the traditional link: midominio.com/portal/public/oficinas.php?seccion=24 24 is to the section: office On this page it show...
asked by 27.04.2016 / 00:35
2
answers

php - Problems inserting MYSQL data

Good, I am trying to insert data from my form, but when I press the submit button it sends me the message of: "Connection made" What is the message of my php file of connection , nothing more. The code to insert I have it in another fil...
asked by 16.06.2016 / 05:50
4
answers

Problem in count php

I do not have an error in the connection, but it does not show me correctly the number of pending tickets that I am seeing in the system, try to change the values of tipo_solicitud = 1 && status = 1 to another but it keeps showing...
asked by 17.04.2018 / 21:58
3
answers

Help with the logic of a query for MySQLi

Greetings guys I have the following sentence: $query = "SELECT * FROM pedidos WHERE usuario = '$usua AND status_pedido = 'ESPERANDO' "; Just as it works perfectly but I would like it to also select if the condition is met status_qualifie...
asked by 10.10.2018 / 16:10
2
answers

Error in showing error message when everything returns zero?

I have an error in wanting to add an error message when there are no votes for any product. When there are no votes in a product, all the variables in the query return the print value of 0 , apparently taking the value 0 as a val...
asked by 17.10.2017 / 05:22
1
answer

Problem inserting data with MySQLi

I have this database created in phpMyAdmin: The problem I have is that when I insert the data of the form where I create a user manages to connect to the database, the data sends them but does not save them, concluding with the redirect...
asked by 26.12.2015 / 07:20
2
answers

How to make SELECT Top 1 in MySQL for last registration

Good I know that in SQL Server a query is made like this to take the LAST record NOT THE FIRST SELECT TOP 1 * FROM Tabla ORDER by ID DESC This is how I get the last MSSQL table record, SQL server 2008 R2, but in MySQL I...
asked by 01.01.2017 / 18:06
2
answers

php to establish connection to the database

hello community I'm just learning the object-oriented programming for reasons of scalability in my application and well I have this code to establish connection to the database .. file config.php $host="localhost"; $user="root"; $pass="";...
asked by 09.09.2018 / 00:33