Questions tagged as 'sql'

Tagged questions
1
answer

Update oracle with different information

I'm trying to do an oracle update with completely different information and I do not know how to do it. I want all other campuses to be the same as campus 1, where this id_campu is a foreign key with another table. Example: col1.id | col2....
asked by 10.08.2017 / 00:55
1
answer

Difficulty in validating login

I have this code for an application of an online store but as I am new to php I am having some difficulty in validating the login because when submitting the form it accepts everything that has written, existing the user in the database or not....
asked by 19.08.2017 / 19:10
2
answers

php Page, Do not Save On The Bank! Because?

The code below is inside a huge page, I need the value that the person put in "email" is inserted in the variable and so to the bank. I have already reviewed thousands of different codes but always continues with the same problem Do not write t...
asked by 16.08.2017 / 20:36
0
answers

Procedure does not execute in codeigniter

function renovarEmprestimos($matricula, $livro){ $this->db = $this->load->database('biblioteca', TRUE); $query = $this->db->query("EXEC J_renovarlivroweb '$matricula', '$livro', '1' "); //$this->db->last_query(); return $quer...
asked by 16.08.2017 / 19:06
1
answer

How to use PHP variable in other pages [duplicate]

I have a script that brings the results of a sql search as follows: $sql = (...); $result = $db->query($sql); while ($obj = mysqli_fetch_object($result)) { $ids = $obj->id_prestador.","; } If I make an echo $ ids after creating...
asked by 07.08.2017 / 19:48
1
answer

Slow Query - SQL Server 2012

The query below takes an average of 30 seconds to execute. I know that most likely it will be the various or and like , but I am looking for the log table and not always the id will be the same, for I used the like . How do I adjust this q...
asked by 07.08.2017 / 21:55
1
answer

How to update a field from a Database table using a Stored Procedure?

I basically have a database table, which has a field called DESCRIÇÃO and the table is called Tabela123 I have 10 records in this table, and in the DESCRIPTION field I have the sentences: Hello, are you ok? goodbye and thank...
asked by 08.08.2017 / 13:00
2
answers

How to remove duplicate dates in sql?

Good morning, I need some help for the following problem, I have this code Whichgivesmethefollowingresult,howeverIwouldliketoremovetheduplicatedates Thanks in advance.     
asked by 08.08.2017 / 13:22
1
answer

My SQL does not find accented words [duplicate]

My SQL works perfectly when the word being searched is not accentuated, but when the word is accented, there is no search result. My database is mysql and in php admin I made the query, and it finds perfect words also accented...
asked by 26.07.2017 / 18:28
1
answer

View user information on another page

I have a login page (login.php) and one that I would like to display all the user data (profile.php), I researched it and saw that using Sessions would be possible, I made the code based on the examples that vi, but it is returning an error acce...
asked by 26.07.2017 / 17:53