Questions tagged as 'sql'

Tagged questions
2
answers

Warning: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result, boolean given in [duplicate]

I have a simple problem when picking up a data from a table .. The error is    Warning: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result,   boolean given in Code: $sql = mysqli_query($conexao, "SELECT diasvip FROM logi...
asked by 07.03.2015 / 14:48
0
answers

Website visits

Hello friends I have this information of my visitors to make a Dashboard pretty cool, I am wanting to calculate the time of permanence of the clients in the site, every access that the person gives it writes in the database with this we ha...
asked by 12.04.2018 / 14:47
0
answers

Count records returned from a SQL procedure in PHP

Good afternoon, I'm a beginner in PHP and I'm running the code below, the records are returning correctly, however I can not count the number of records returned and print on the screen. It prints the -1 amount, before I was doing a simple se...
asked by 12.04.2018 / 20:55
1
answer

Select with pyodbc

I'm trying to use the string I get from an Entry and an OptionMenu to perform the search on SqlServer but gives the following error: TypeError: not enough arguments for format string Here is the function code that executes the call: def c...
asked by 18.04.2018 / 21:38
1
answer

Foreign key comment system "autor_coment"

It has a comments table with the following attributes: id ( int not null ), comment ( text not null ), data_coment ( timestamp not null ) and author_coment ( int not null ). > The author_coment is a FK that re...
asked by 12.04.2018 / 16:14
1
answer

Catch all data in an HTML table and insert into the database

I have an editable table in html, when I click save, I need to get all the data from the table, send it by ajax to the page that INSERT all rows in the database. My question would be: How to get all rows from the table and send via ajax....
asked by 21.04.2018 / 20:13
0
answers

Using two databases in a PHP + Codeigniter application

I know that this question has been asked before, but the ones I have been able to search for none helped me, I have a PHP + Codeigniter in> I have a select of the company I'm going to use the bank: if ($this->input->post('empresa') =...
asked by 13.04.2018 / 13:22
1
answer

How popular in database to perform tests?

I need to popular this database to conduct test queries for educational purposes. I already have about 5 students, 2 teachers, but the problem is to popular the exercises manually. Is there any more practical way?     
asked by 13.04.2018 / 13:51
0
answers

Bring the value of one column according to the condition of another

I am developing a simple script but I came across a situation that I am not able to solve, I tried through CASE but without success. With a simple select I need to bring the columns Name, RG, CPF, and the CELLULAR telephone of the client , t...
asked by 17.04.2018 / 21:13
0
answers

Play Framework 1.2.7 JPAQuerry

Hello, I'm a beginner in java, and I'm having a very difficult problem to solve, I'm trying to get the parameter usrName and write to my bank with the following querry, but the account value always gets NULL, could someone help me by kindness Fol...
asked by 17.04.2018 / 22:15