Questions tagged as 'crud'

1
answer

CRUD in PHP and MYSQL - Delete

I'm having problems with a crud in php and myqsl . My code does not seem to be getting the id to perform the actions. The site has an administrative part where I view the registered users and can edit, delete and detail on each user. Here...
asked by 15.10.2018 / 22:12
0
answers

Selection does not display data on the screen (php and mysql)

<?php class categoria { public function selecao($pesquisa){ require_once 'conexao.php'; $con = new conexao(); $conn = $con->conectar(); $sql = "select * from categoria where nome LIKE '%$pesquisa%'";...
asked by 19.09.2018 / 05:47
0
answers

MySql hangs when trying to query table with many records (PHP)

I'm trying to make a filter where the query is done in a table where the id of the last record is in the number 468.466 . In the filter, I need to compare with a View, which has its last record id 5,303,345 . The query is as follows: S...
asked by 27.08.2018 / 14:13
0
answers

problems in add and update button are not working on a crud in data_table in php, my functions seem to be wrong

<script type="text/javascript" language="javascript" > $(document).ready(function(){ $('#add_button').click(function(){ $('#user_form')[0].reset(); $('.modal-title').text("Add"); $('#action').val("Add");...
asked by 16.07.2018 / 16:22
0
answers

Webslesson CRUD with PDO, Ajax and dataTable - Does not add data in Mysql after column addition in table

Hello! I'm following a CRUD tutorial with PDO, Ajax and Modal Bootstrap for implementation in a project. My database has 2 tables ( users ) and ( type_ps ). The users table has the following structure: CREATE TABLE 'users' ( 'id' int...
asked by 20.07.2018 / 04:07
1
answer

Using Select android studio

I was able to save information to my SQLite database, but I can not call them. I'm trying using the following method: private void verPessoas() { ArrayList<RespostasAguaCasa> pessoas = new Read().getLista(); for (int i = 0; i...
asked by 13.06.2018 / 19:36
1
answer

Error in select search

I'm not able to return the value inside my arry always returns 0 Read public class Read { public ArrayList<RespostasAguaCasa> getLista() { SQLiteDatabase db = Maindb.getInstancia().getReadableDatabase();...
asked by 18.06.2018 / 16:20
2
answers

Generic Method of a Generic Class C # for similar classes

I have some classes that will use a write method. I created a CRUD (Generic) class where I would have a write method, but I need this method to take classes as a parameter. There is some way to create a generic method for what I have read, bu...
asked by 23.05.2018 / 14:08
1
answer

How do I receive data from a form that has repeated field names?

My final course project, in a very brief way, is a question and answer game, in this project, I have the "Alternatives" table, when I am going to ask questions, there are four fields with the name of alternatives as follows :                 ...
asked by 24.05.2018 / 21:54
0
answers

I'm trying to update a database field, through the adapter. How I do?

... public void concluirAtividade(Atividade atividade){ ContentValues contentValues = new ContentValues(); contentValues.put("SITUACAO", atividade.situacao); String[] parametros = new String[1]; parametros[0]...
asked by 11.05.2018 / 01:45