Questions tagged as 'mysqli'

Tagged questions
0
answers

MySQL for MYSQLI connection (class) [duplicate]

I would like to make this connection in mysqli, could someone help me? I'm having some difficulties. <?php Class mysql { public $query; public $data; public $result; public $rows; protected $config; protected $ho...
asked by 28.03.2018 / 19:44
0
answers

Alternative for using UNION in mysql / php

Good morning, I'm doing the sum of the elements of a column (which I called MyColumn) in function of another, called "shift". There are three values for shift, so I need the code to return three distinct sum values. For this, I'm using the UN...
asked by 13.03.2018 / 13:03
1
answer

mysql search with only one of the selected fields

I have a question about how to organize this information, I have two selects in my code, that the user chooses the two, generates the table looking for who has the two information, but I would like the search to be done even if the user to selec...
asked by 14.03.2018 / 16:21
0
answers

Call one procedure inside another - MySql

I have to retrieve some values before running my cursor, as the MySql syntax does not allow to make select before the cursor declaration, I thought of dribbling, doing the select in a first procedure and then calling the second that will iterate...
asked by 05.03.2018 / 14:50
2
answers

Get content from a list of a site and save it to the PHP database

I want to enter the site below, save all html in a variable, clean the html and save the content I want in the MySQL database via PHP 7 . p>    The site is: link At first I "saved the HTML of the page" into a variable, as per the code...
asked by 02.03.2018 / 13:47
1
answer

Fill in a field by selecting another field

I have an order form where the customer name is chosen and I would like the discount field to be filled in from this selection, this value is in the same table where the customer's registration is. How can I make the discount field be populat...
asked by 04.03.2018 / 16:52
0
answers

List and search for records

Good afternoon, guys. if it is possible I would like your help .. I am already breaking my mind and still can not find a correct solution. Please if anyone can help thank you very much. 3 linked tables reset | id, name, uf repregiao | i...
asked by 24.02.2018 / 19:45
1
answer

php, bring multiple rows from a linked table to another table of a single id

Hello, I'm having a hard time retrieving information. EDITING TO IMPROVE THE QUESTION Below is the code, In the data for printing, I need to show in the variable $ comp when it belongs to the same id_cadastro I am querying, so far so...
asked by 15.02.2018 / 03:09
0
answers

How can I count likes in the relationship table

Need Select the posts along with the likes corresponding to each post. I selected what I want, but when I use the COUNT of the error, see the first image. Data The two tables also the post and the relationship tables to tell the likes....
asked by 12.02.2018 / 13:17
1
answer

Error Registering in the Database

I'm getting the following error when trying to insert some data into the database:    Unknown column 'F' in 'field list' In case the column is of type enum and can receive 'M', or 'F', testing directly in the database I saw that this erro...
asked by 12.02.2018 / 01:13