Questions tagged as 'sql'

Tagged questions
1
answer

Question: Search with DropDownlist mvc 4 razor asp.net C # sql Server [closed]

I am having difficulty popping the dropdown with sql server, because it comes repeated sql item ... ex: when I select the cities it comes with repeated cities and so on, and I can not direct to the search page. follow the code Controller Home...
asked by 12.09.2016 / 21:09
2
answers

Wordpress - How to include new fields in the user table?

I want to include the following fields in the register of registered users in my blog: IBGE, Municipality and UF. How do I include these fields and later access them on a specific page?     
asked by 19.10.2016 / 01:09
1
answer

Query the database through a text box

Hello, I'm currently in a part of a project where I have to search the database through a text box. For example I searched for "Joseph" and returned all the data contained in the database with the name "Joseph". You could also search for "Traver...
asked by 15.05.2017 / 11:10
1
answer

Removing reserved SQL words from a Java string

I'm doing a view that has an open field ( textarea ) where the user can write SQL and then can execute the same SQL. The question is that the oracle user where it will run SQL has permissions for everything and it is not supposed to d...
asked by 22.04.2016 / 18:17
2
answers

Calculate length of a SQLServer field

Hello, I have a table in SQL with the word column and a WordSize column, I was wondering if I have any way to register the word in the database and execute a function that calculates the amount of characters in this word to save in the WordSize c...
asked by 13.11.2016 / 20:55
2
answers

Query by month and year (Php + SQL)

I have a system in PHP in which I use the datatables plugin, I can sort by date, but the user wants to set the query period, for example: Select from 01/01/2016 to 01/31/2016 and all data for that period is displayed. I have to crea...
asked by 17.06.2016 / 21:24
1
answer

Post Post Wordpress

I have the following script that returns me the status and the amount of posts it has in this state, now I would like to view these posts, does anyone know of any solutions? <?php $query=" SELECT e.id ID,e.uf UF, e.nome Es...
asked by 06.10.2015 / 15:17
1
answer

While returning duplicate data

Good morning guys, I have this query $query = "SELECT p.*, c.nomeCategoria AS categoria FROM produto AS p INNER JOIN produto_categoria AS c"; $dados = mysqli_query($con, $query) or die(mysqli_error()); and a while that returns the value in...
asked by 24.07.2016 / 17:21
1
answer

Create dynamic chart using mysql and Highcharts

Personal I'm trying to create a chart using Mysql and Highcharts on a local Xampp server. However, when running index.php only the source code of the page is displayed, not generating the graphic. Following is the database, table, connection...
asked by 14.08.2016 / 19:33
1
answer

SQL - Codeigniter - Returns only one record

Gentlemen, I have the following function: // Busca Simples public function buscando(){ // pesquisar_palavra, idCategoria, idSubCategoria if($this->input->post('pesquisar_palavra')){ $this->db->like...
asked by 14.11.2015 / 15:18