Questions tagged as 'mysql'

Tagged questions
1
answer

Doubt with Insert and Select

I'm new here and I'm having a database doubt that I've been stuck since yesterday, I tried to solve it and nothing follows the following exercise: With the Customer Table (customer_id, customer_name, new_document, child_name, etc.), the Tran...
asked by 21.09.2018 / 23:24
0
answers

How to call a foreign key?

I have a platform that has one page to add person and another page has to add a plan to a person. That is, you first create a person, and only then can you add a plan. My problem is to connect a plan with a person. I in the plan table have the f...
asked by 19.09.2018 / 15:24
1
answer

Bring multiple join values into mysql

Well, I have a question about a mysql query using the Codeigniter Framework. I have the following tables: Products Table |--------|-----------------| | id | nome_produto | |--------|-----------------| | 1 | Camisa Tal | |--...
asked by 12.09.2018 / 03:52
0
answers

php - How to set maximum execution time, using interval in each loop? [duplicate]

Good morning! I need to send some email reminders according to some conditions. I put together a script that queries the information in the database (MySQL) and triggers the emails. The script is working very well, however, from what I saw in...
asked by 12.09.2018 / 17:09
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
0
answers

Filtering data in CodeIgniter

Am I safe using only $this->input->post() ? in the case I use just this way and in queries in the database I use just something like: $this->db->query("SELECT * FROM 'usuario' WHERE 'id_usuario' = $id_usuario"); In this ca...
asked by 12.09.2018 / 19:34
0
answers

Unknown system variable 'query_cache_size'

My project has this error; java.sql.SQLException: Unknown system variable 'query_cache_size' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[mysql-connector-java-5.1.41.jar:5.1.41] at com.mysql.jdbc.MysqlIO.checkErro...
asked by 12.09.2018 / 18:15
0
answers

Unable to load authentication plugin 'caching_sha2_password'

I was running my Spring Boot project about 6 months ago, and it was working perfectly, today I decided to install the new version of mysql and suddenly there was this error message; java.sql.SQLException: Unable to load authentication plugin '...
asked by 12.09.2018 / 17:58
0
answers

How to create a form that can add new text fields within the form dynamically

I'm putting together a Real Estate site in launch, where one of the fields is "units." This drives field can have multiple drives, eg: A - 1 dormitorio - 50m² B - 2 dormitorios - 70m² Currently it is inserted in a text area field in the Tab...
asked by 10.09.2018 / 17:01
1
answer

php - login session with ajax and php

I'm having a login problem with php and ajax. I have registered a user and password in the database with columns: PROBLEMTHATALWAYSAPPEARS=USERSANDWRONGPENNIES...ANDICANNOTSEEWHEREIERRED,THEBANK'SINFORMATIONISSURE.IAMMAKINGALLLOCAL..IFYOUCAN...
asked by 20.10.2018 / 22:34