Questions tagged as 'mysqli'

Tagged questions
1
answer

Error in php Commands out of sync; you can not run this command now

I have already read a few articles, but I can not fix this error that I have. It is the first time I see this error, and I do not know how to solve it. Then using PHP and MYSQL to extract data from the database (use redundancy) and display them...
asked by 04.12.2017 / 05:06
1
answer

Search in mysqli with a field separated by comma

I would like to do a search on mysql using a variable that contains data separated by,. So far I have always done this with a loop, but the same is some way of looking directly using that variable. The idea would be to find all the ids stored...
asked by 22.11.2017 / 12:10
2
answers

Place field that can be left blank or not

I have a couple of fields in mysql that I want them to be blank but I miss the error that I have to enter them and the problem is that they will not always be blank this is the insert of the data $Nombre = mysqli_real_escape_string($con,(st...
asked by 16.11.2017 / 16:02
1
answer

Insert in Mysql does not execute

When I want to insert information into my database, it does not run: $sql_in = "INSERT INTO solicitudes(codsol, nro, fechacrea, rutus, banco, tipocuenta, nrocuenta, actividad, lugar, fechaact, proveedor, rutprov, factura, rex, listado, ordenco...
asked by 16.11.2017 / 10:00
2
answers

Insert data in MySQL mediating form and PHP

Good afternoon, I am trying to do an exercise that consists of a bus manager, trying to register new buses through a form. I attached the code and my doubts to see if you can help me: The form where the data is entered: <form action="fun...
asked by 09.11.2017 / 19:49
1
answer

Get a query from a table [closed]

Greetings, I have a list of names of a database in a table, to give in see details, I linked to another php file in which I would like to see the full details of that person and not leave the rest here I have the code of the details of the perso...
asked by 07.11.2017 / 19:25
1
answer

Error expanding PHP / MySQL details

In PHP / SQL, I have to show the details of some employees of a company, which are stored in the MySQL database. Right now, the code that I have developed is the following: employees.php <?php $host = "oraclepr.uco.es"; $username =...
asked by 25.10.2017 / 14:39
1
answer

Sessions in php for a certain user

Good day I'm working on WampServer php and mysql with sessions I have a problem having many users I want when I log in to show the data only of that user, my problem is how to assign an id so that when I start open with data only of that user. I...
asked by 05.11.2017 / 17:17
1
answer

Error with group by in mysql 5.7

I have the following query : SELECT count(id_estadistica) AS num_clicks, a.*, b.* FROM estadisticas AS a LEFT JOIN noticias AS b ON a.id_elemento = b.id_noticia WHERE b.id_noticia IS NOT NULL AND b.fecha_pub BETWEEN '2017-10-01 00:00:01...
asked by 08.11.2017 / 08:16
1
answer

How to validate the number of columns to import PhpExcel?

Good morning, Can someone please explain or tell me how to do it so that they do not let me import files that are passed or have fewer columns than the established ones? Let's say if my table where I'm going to import has 8 columns from th...
asked by 05.01.2018 / 21:11