Questions tagged as 'mysqli'

Tagged questions
3
answers

inserts concatenated value in mysqli

good afternoon, I have a form on a page where you get values, which through a file attached to the database, well now I want the value of a field concatenated me with a fixed string and two variable data, how do I include it in the code? fiel...
asked by 12.06.2017 / 21:32
1
answer

Log in PHP7

I have a mysql bd in which I have a user with an encrypted key. The registration form is this: link I have a big mess of concepts. My script is as follows: <?php $usuario = stripslashes(trim($_POST['nombre']));; $pass = strips...
asked by 24.06.2017 / 23:51
0
answers

Error 1040 too many connection mysql / php

I have an error 1040 too many connection . I have seen that this can be solved by increasing the variable max_connection , but this variable can not be increased, the value of this variable is 101 which alternative I can use to solve this er...
asked by 06.06.2017 / 15:57
0
answers

Delete record without reloading Ajax page Mysql php

The record is deleted correctly from the database, but the change is not shown on the screen, the output of my data is through a table. **PHP donde se muestran los datos ** <?php $consulta2 = "SELECT ... ?> <script...
asked by 02.06.2017 / 06:48
2
answers

Several tables in a log with JOIN SQL query

The problem comes here in the query and the loop when displaying the records. Fichamaterial creates the autonomous PK and in the others I pick it up from it. Depending on the category of the material I show a dropdown or another with data fro...
asked by 20.05.2017 / 12:44
1
answer

Error mysqli_stmt :: bind_param ():

Install the XAMPP program and get this error message and so far I can not fix it    Warning: mysqli_stmt :: bind_param (): Number of variables does not match   number of parameters in prepared statement in   D: \ xampp \ htdocs \ server \ enc...
asked by 07.05.2017 / 20:13
0
answers

Error with mysqli_fetch_array?

Can you explain why? Next the code <?php $con = mysqli_connect("localhost", "root", "", "codigofacilito")or die("error"); ?> <html> <head> <meta charset="UTF-8"> <title>Crud</title> </head>...
asked by 31.05.2017 / 03:13
0
answers

Array sum of sales per days in php from mysql

I'm trying to perform a Mysql query to calculate the total sales made in a day and save it in an Array that contains all the days of the month and then load it into chartist.js and create a graph. for ($i = 1; $i <= 31; $i++ ) {...
asked by 21.04.2017 / 17:08
1
answer

Optimize MySQL query

I have a query that takes 0.2650 seconds to run and I would like to optimize it, I have done a lot of tests (Add new indexes, delete them, create views) but nothing has improved the performance of the following query: SELECT enlace_click.id,en...
asked by 17.04.2017 / 08:18
1
answer

How to upload several files with different inputs?

I wish that you can choose only one file for each input and upload them all and apart from inserting certain data, I have the following code: <?php session_start(); $folders = $conn->query("SELECT * FROM 'folders' ORDER BY 'i...
asked by 09.04.2017 / 07:44