Questions tagged as 'mysqli'

Tagged questions
1
answer

Error when selecting data from the database with ajax [closed]

I'm doing several cases in my code, but when I enter the listar case and execute it on my localhost it fails and it throws me an error    Fatal error: Uncaught Error: Call to undefined method mysqli_result :: feth_object () my code...
asked by 01.07.2017 / 09:55
1
answer

SQLSTATE [23000]: Integrity constraint violation: 1062 Duplicate

It turns out that I have two tables: Label and Priority the fields in the tag table: id priority_tag_id name image the fields in the priority table: id name and so are my tables: And then I execute the follow...
asked by 11.05.2017 / 04:36
1
answer

How to go through PDO query in PHP

I have an application where I need to obtain the values of a query made: I tried this way and if it worked (with mysqli): //para conectarse a la Base de Datos $host = '127.0.0.1'; $user = 'root'; $pass = ''; $db = 'incidencias'; $cone...
asked by 08.05.2017 / 05:05
1
answer

Incorrect filtering in a MYSQL Conlsulta

How about, I'm developing a system where I have a database filter. I have the database with a field called "state" where I store 4 different data that are (Pending, Active, Completed, Does not Proceed) others called "depto1" and another ca...
asked by 05.04.2017 / 04:43
2
answers

How to upload different profiles on the same page?

I have a site (or I'm doing it) where I can see the profile of the user that I select from index.html . This page where the user's data is loaded is called user.php and the page where I see the profile of the current user (logged in) is ca...
asked by 26.11.2016 / 04:46
2
answers

Problem with queries in related databases

Good morning I am trying to make a query in which one 3 tables and I want to be able to list the tasks assigned to a user with their corresponding Tag, but I duplicate the tasks that contain more than one Tag . The code is as follows: *...
asked by 16.03.2017 / 13:39
1
answer

To create a mini social network, is it necessary to know POO? [closed]

Speaking of PHP. It is necessary to know what is the use of object-oriented programming. How important is it?    It makes things easier for me.     
asked by 28.08.2016 / 16:50
3
answers

Problem when inserting data in MYSQL with Codeigniter and Ajax

Good morning, What I want to do is that by pressing "Enter" I insert a new tag into the database. I created my script.js file: $(".inputTag").keypress(function(e){ if(e.which == 13) { $.ajax({ type: 'POST',...
asked by 22.03.2017 / 13:17
2
answers

Prepared statements: consequences of the absence of free_result () or close ()

In the matter of prepared sentences that problems would generate the absence of the following two functions: close() and free_result() Try the following two cases and nothing negative happens: Close the statement : $st...
asked by 06.04.2017 / 16:31
1
answer

mysql query does not work

The query does not work for me. What am I doing wrong? update users set hasCredit = 1 where users.id = (select users.id from users inner join creditRequest on (users.id = creditRequest.user_id))     
asked by 02.09.2016 / 17:42