Questions tagged as 'mysql'

Tagged questions
2
answers

Error Querying in MYSQL [duplicate]

I am trying to query and return to the user via Ajax and the following errors are being displayed:    Warning: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result, boolean given in line 77 - > while($experiencia = mysqli_fe...
asked by 21.06.2016 / 02:51
2
answers

Mysql query with PHP brings duplicate results

I'm trying to create a code in php to build a ranking, I was able to make the data appear, the problem is that it's duplicating the results. $rank = mysql_query("SELECT * FROM user_quizzes ORDER BY pass_score_point DESC") or die(mysql_error())...
asked by 20.06.2016 / 19:30
1
answer

PHP - Display BD MySQL Images

I want to display the images that are stored in the MySql database, I'm only able to bring 1 image! But in fact I want to display all the image ... I ran this query, which is the query I'm doing in the project.    WHERE WHERE / em>...
asked by 07.07.2016 / 16:00
1
answer

I doubt how to use the IF in a TRIGGER in mysql

Hello! My problem is the following I have two tables, one table called Notes and another called Students . I need to make a comparison with the child_id in the notes table and the id in the students table to only if the < in table in...
asked by 06.07.2016 / 00:31
1
answer

Error importing csv with fopen

I am trying to do a csv import with PHP to insert directly into MySql database, I am using the fopen function, which returns me the following error. Parse error: syntax error, unexpected ' ' (T_STRING) in ... on line 6 Follow the code below...
asked by 11.07.2016 / 03:05
1
answer

Search in mysql by Javascript

Good morning, I'm trying to make a check if the cpf typed already exists in the bank, I'm using laravel, could anyone help me in this function please? In my controller, I search and ready all cpfs of the bank: $cpfduplicado = UsuarioEsi...
asked by 11.07.2016 / 15:41
1
answer

Add sql query value to variable dynamically

I have a table (officials), where I want to get the value of the id_funcao, id_porcentage and put in that variable $ percentual. I do not want to just put the 30%, but rather the values in the Percentage table. $datainicio = $_POST["inicio...
asked by 22.07.2016 / 20:43
1
answer

PHP System to cure user x in x minutes

Good morning everyone! I'm creating a rpg game and I'm not figuring out how to get it to cure the user of x in x minutes. I was able to do it via ajax, but it is not safe right? Easily the user can circumvent and heal his whole life if he wants...
asked by 11.06.2016 / 13:37
1
answer

Input type file with pre-selected image

I have the path of an image in the ex database: admin / conteudo_admin / imagem_noticia / atletas.jpg I have this input type="file" and I wanted this image to be selected <input type="file" id="imagem" name="imagem" >     
asked by 06.06.2016 / 17:39
1
answer

Hibernate shows ddl but does not create the tables in the database

When I started the wildfly I expected the tables to be created in the database but on the console it shows a create tables log, but nothing happens in the database. Below I show this: 14:15:00,462 INFO [org.jboss.modules] (main) JBoss Mod...
asked by 03.06.2016 / 19:21