Questions tagged as 'mysql'

Tagged questions
0
answers

How to do pagination using PHP and MYSQL [duplicate]

I have a simple query that brings the results and assembles a table and I wanted the table to come with a pagination: (), but I do not know how to do it. The query looks like this: $nome=$_GET['nome']; if($nome!=''){ $filtronome = " W...
asked by 06.08.2018 / 16:35
0
answers

Leverage data from a record by creating a new record

I have the following codes:     function add ($ table, $ data, $ returnId = false) { $this->db->insert($table, $data); if ($this->db->affected_rows() == '1') { if($returnId == true){...
asked by 06.08.2018 / 16:03
0
answers

How to bring the result of the clustered MYSQL query and make a foreach for each group

I have a real estate site that assembles a photo album for each type of photos: Facade, Common Area, Floor and Decor. To do this, I do 4 MYSQL queries with PHP, using the criteria for each, but I believe that I should have a one-time solution...
asked by 06.08.2018 / 15:37
0
answers

TypeError: Path must be a string

This error appears to me when I try to do UPDATE in my MySQL DB. The error only appears on this page, in the other one that also does UPDATE (different tables) not from any error. TypeError: Path must be a string. Received { id_ponto: '3', i...
asked by 26.07.2018 / 20:12
1
answer

Error: java.lang.IllegalArgumentException: id to load is required for loading

I am not able to save data in the database. I created a generated id to customize the primary key in the DB. The field is called id and it is a String . I made a test class and it is working, but when I run the program it gi...
asked by 22.07.2018 / 07:49
0
answers

Problem in creating foreign keys MySQL

I'm trying to implement a 1: 1 relationship between the Official table and the User table in the MySQL Workbench, but in generating the Diagram I see that the relationship always stays in 1: n, even with the UNIQUE constraint on the foreign key....
asked by 22.07.2018 / 19:32
1
answer

Error trying to insert - Call a member function prepare () on a non-object

I'm trying to check if a field is repeated in the database, but when I run the file, I get the following error: Fatal error: Call to a member function prepare() on a non-object in ***** on line 39 My code line 39 is as follows: $stm = $pd...
asked by 21.07.2018 / 16:35
0
answers

ERR_TOO_MANY_REDIRECTS WAMPSERVER

I have this problem ERR_TOO_MANY_REDIRECTS on localhost, the script it runs perfectly on the server. I am using Wampserver 3.0 and PHP version 7.0. Here is the script: require_once('header.php'); // Preventing the direct access of this page....
asked by 21.07.2018 / 17:03
0
answers

Manipulate array in mysql with procedures

I have a much more complex procedure than the one I'm going to post here, I use it to export to a excel sheet all my product information, but the information comes from messed up because I attach a lot of foreign keys. for summary purpose I h...
asked by 08.08.2018 / 20:31
0
answers

Send data from one bank to another

Is there any way I can send data from one bank to another? If so, how could I do it? Example: I have site 1, it sends data to bank 1, this data arrives at 1 and it is automatically sent to bank 2, and site 2 displays the data that was sent to ba...
asked by 08.08.2018 / 22:58