Questions tagged as 'mysql'

0
answers

Request returns 403, only sometimes

Good night, guys. I have a (shared) server with some tables in the database. While my main application was running, I realized that some POST requests were returning 403. To pull information from the database the application sends a post t...
asked by 16.10.2018 / 01:29
0
answers

How to save a base64 in a mysql database?

I'm creating an application using AngularJS and using webservlets with connection to the mysql database. To generate the binary, I use the following code: $scope.adicionarArquivo = function (element) { var reader = new FileReader();...
asked by 14.10.2018 / 21:55
0
answers

MySQL - LOAD DATA INFILE with conditional

I need to import txt file into a table where the data is structured by fixed column, that is, the TIPO field is identified by the first 2 digits of the record, the CBO field from 3 to 8 , and so on. The TIPO field...
asked by 22.10.2018 / 00:52
0
answers

Load database data into input after selecting id in dropdown

I have the following problem: I have a dropdown (which has as values the id's of a table of my bank) and I would like, after making the selection of one of the items of this, data related to it (present in the bank) , fill in the input values on...
asked by 21.10.2018 / 04:37
1
answer

MYSQL Data Return (Data) for HTML Tables

They could kindly help me with the following error:    Recoverable fatal error: Object of class DateTime could not be   converted to string in   C: \ xampp \ htdocs \ PortalPib \ querytransactions.php on line 118. I am trying to return da...
asked by 15.10.2018 / 21:24
1
answer

Pass mysql class to mysqli error in query

I'm having a problem passing the query (this->Query($sql)) and the others to mysqli . I do not know how to proceed ERRORS:    PHP Warning: mysqli_query () expects parameter 1 to be mysqli, null   given in /var/www/html/ma...
asked by 15.10.2018 / 19:52
1
answer

How to bring data from another table related to a userid (JOIN ???)

I have the following tables: Users Andinvestments Theinvestmenttablehastheuserid.I'malreadygettingregistered.HowdoIshowonauser'sscreentheinvestmentsmadebyhim?I'malreadyabletoregisterandhavetheuseridrecordedrightaway.Myscreenwillbethisbelow,I...
asked by 12.10.2018 / 06:18
0
answers

Send value 0 or 1 of checkbox or button along with comment

I'm a beginner in development, I have an app that lets you comment text, image and audio. However I wish there was a "send anonymously" field? with a checkbox or a button, and this comment did not display the user name and profile photo. I...
asked by 10.10.2018 / 05:19
1
answer

pull record and filter from mysql pro php [closed]

I'm trying to pull the information in MySql and show in php, with a filter in the room name $reserva = mysqli_query($connect, 'select * from reserva join curso on reserva.idCurso = curso.idCurso join professor on reserva.idProfessor = professo...
asked by 17.10.2018 / 03:46
0
answers

Control of Questions and Sectors in the Database

Today there is a question form for each sector and today I would need to inactivate some questions, the problem is that if I inactivate these questions, they will not appear in the reports of the past months, I am thinking of putting an extra co...
asked by 09.10.2018 / 16:04