Questions tagged as 'mysqli'

1
answer

How to filter explicit images when the user uploads their profile picture in php?

Well here with another doubt. We know that any person, out of simple curiosity or annoyance, when uploading their profile picture on a web page, could happen to upload images to the server with explicit content. This is where I wonder how...
asked by 03.08.2018 / 02:23
1
answer

Error in showing data when adding a where in a MySQLi query?

It does not reflect the data when adding a where in a MySQLi query, if I delete the WHERE the data is reflected. <?php $stmt = $con->prepare("SELECT id_world,hour,date_matches,local,visitor,active FROM world WHERE active=?...
asked by 05.07.2018 / 05:58
2
answers

Print button if a value is empty

I have a table that shows the records of orders delivered, and to finish the registration there is a "Add referral" button to save the referral in the database. I want to do that when the table reloads and if the referral has value that does not...
asked by 19.06.2018 / 17:20
2
answers

Format JSON

I want to give a specific format to a JSON that I do from PHP to then receive it in a variable in JS and fill a table with it, but I do not know how to do it. Here the JSON is created: <?php $conexion=mysqli_connect("localhost", "ro...
asked by 20.06.2018 / 19:14
2
answers

What is fetch () in MySQLi prepared query?

On the official PHP page there are several examples but all with different names. Searching the web is spoken but in PDO, looking for StackOverflow the same is spoken in PDO. But what does it mean in sentencing procedures prepared in MyS...
asked by 05.03.2018 / 03:54
1
answer

Error loading a text file into mysql, using array with php.

I try to load a txt, with coding format utf8 and with separators between lines Þ and between fields ¶ . I upload it with a form html e input type = file . I have the files sorted by mvc. And the version of php...
asked by 28.02.2018 / 01:51
2
answers

Show field and its mysql database content

How about! I have a detail when presenting a query This is my code where I consult and show the result: $consulta_A = mysqli_query($con,"SELECT * FROM articulo8 WHERE fraccion = 'VI'AND inciso ='Inciso H' AND ano = '2017' ORDER BY mes DE...
asked by 31.01.2018 / 19:03
1
answer

Error Only variables should be passed by reference when Inserting data by query parameterized with PHP and MySQL

I have the following code: public function nuevoUsuario($id_empleado, $username, $correo, $pass, $id_tipo_usuario) { //tiempo de espera sleep(1); try { $this->Conectar_BD(); $this->query = "INSERT INTO us...
asked by 02.02.2018 / 21:56
1
answer

Execute MySQL queries to two tables at the same time and show results

I would like to show a query of two tables that are not related to each other. they practically contain the same fields id, name, surname, avatar, date Table "content" and table "copies", the table "copies" are actually copies of the table "cont...
asked by 11.05.2018 / 18:20
2
answers

Unable to obtain mysqli PHP Error

   I'm using the global function $ with; and the error went but I do not know if   it's okay to use it in each function and if PHP5 works the same   well that in PHP7 Error:    Warning: mysqli_query (): Could not fetch mysqli in C: \ xamp...
asked by 13.09.2017 / 21:44