Questions tagged as 'mysqli'

Tagged questions
1
answer

How to use trigger in mysql so that when you delete a record change the value of a column of the other records?

Well, what I'm trying to do is a query so that when a record is deleted from the "class" table, the value of the "counter" column of the other records is subtracted 1 as long as the id of the records is greater than the id of the record that I d...
asked by 04.04.2018 / 19:54
1
answer

Help with a JOINS in 2 tables in MySQLi in PHP

I commented to them I have read several times the blog of link but I can not implement a JOINS in my project, what I have so far works perfectly but I'm doing 2 or 3 queries and the idea is to optimize the queries to my database for logical...
asked by 12.10.2018 / 18:24
1
answer

DrpZone.js I get server responded with 0 code and already modify apache

Greetings friends I'm using dropzone.js but when uploading files I get an error which says please help and modify many things and nothing    server responded with 0 code And I have already modified the php options     
asked by 23.05.2016 / 21:20
5
answers

Notice: Undefined index: PHP

I'm running a code in PHP and it works totally! It complies with what I ask, but it throws me the following error:    Notice: Undefined index: name in C: \ xampp \ htdocs \ project \ profile.php   online 12 What I did was a profile of a l...
asked by 03.02.2018 / 03:06
4
answers

How to do it in MySql?

You see, this time I do not have a code, nor do I want to be given a code, but simply the idea. I have a system of posts to which I want to add a button to give points (to the selected post). Good. But how do I make those same points that...
asked by 25.10.2016 / 00:30
1
answer

Connection error mysqli [closed]

I have a problem with the following code. It seems that the connection is not closed or gives an error. The error it shows is:    Notice: Undefined variable: mysqli_close in   C: \ xampp \ htdocs \ new \ 89_Blog1 \ insertContent.php on line 2...
asked by 06.06.2017 / 17:15
2
answers

It does not show all the data of the mysql database in my table

     Hi, how are you, I come with a doubt because it does not show me the data of my mysql database in a table that believes in my html. You skip the first user, it is worth mentioning that you already check my connection, the name of the fi...
asked by 19.09.2018 / 01:22
4
answers

filter with if php and show only if it is greater than 0

With this function I create the search for my earrings. function pendientesporrevisar($conexion){ $pendientes = (mysqli_query($conexion, "SELECT COUNT(*) AS conteo FROM ticket WHERE tipo_solicitud = 1 && status = 1 ")) or die(...
asked by 18.04.2018 / 17:55
2
answers

How to avoid the foreign key constraint error in phpmyadmin and in php?

Very good! I am doing a small practice to remember after having been studying again the php and in knowledge of the MySqli (style procedure), when creating the database and the corresponding tables. I have never seen this error after making the...
asked by 02.06.2017 / 19:30
1
answer

mysqli object-oriented

What I'm doing wrong I have this sql statement that should throw me 1 and is throwing me 0 my code with prepared query: <?php session_start(); include"conexion.php"; $me=$_SESSION["id"]; $id= $_GET["id"]; $sql=$conexion-&g...
asked by 25.08.2018 / 05:10