Questions tagged as 'mysqli'

Tagged questions
1
answer

Doubt Mysql + PHP

Hello, I'm developing an online management system (fifa, pes) and I'm having a problem, now I'm doing the part where the user will post the result of the game, informing the scoreboard and the players who made the goals , for this I need to acce...
asked by 18.05.2017 / 23:27
0
answers

How do I not enter data in the database with mysqli and php?

I would like to know if anyone can help me is that I do not want to insert values into the database where the title is the same but I can not. With the code below it always inserts into the database, this filter does not allow to insert data wit...
asked by 28.05.2017 / 03:50
0
answers

pagination does not load the next records

Hello, after running a search, it delivers the amount specified in the code, so far so good ... now enter my problem, I'm using url friendly and even if the form send with "...? page = 1" I think it does not assign value to $ string, errors subm...
asked by 28.05.2017 / 06:40
1
answer

Remove data from one table from the average of notes in another table?

Tabela - lista id | nota 1 | 10 2 | 8 3 | 7 1 | 8 3 | 9 I want to average the grades of those who have the same ID, and for this I have created the following query: SELECT AVG(nota) FROM lista GROUP BY id With this query I want...
asked by 13.05.2017 / 23:29
2
answers

Difficulty in adding data in db using PHP and MYSQL

Well, I'm starting the studies in php and mysql, and I'm having a hard time doing something theoretically simple, which would be a form that sends the information provided to a local db. When pressing send, nothing happens, the db table remains...
asked by 04.05.2017 / 14:07
2
answers

Return primary key after insertion in MySQL

I need to insert two tables into my database, one of the tables has a primary key and the other one will use that value as a foreign key. My question is: How can I return the value of this primary key at the time of insertion? Or how can I do...
asked by 28.04.2017 / 05:29
1
answer

Array result returns null

I need to start from the option selected in <select> , I check with the bank what's related to this option. I made it from as follows, but in the $p_id = $result['p_id']; part, there is null return, I already used this arra...
asked by 19.04.2017 / 02:39
1
answer

Warning: mysqli_fetch_object () expects parameter 1 to be mysqli_result, boolean given in /home/omeganim/public_html/index.php on line 39

I need help solving this error !!! Warning: mysqli_fetch_object () expects parameter 1 to be mysqli_result, boolean given in /home/omeganim/public_html/index.php on line 39 The code is this: $pagCorrente = 1; if(isset($_GET['pag']))...
asked by 22.04.2017 / 02:11
2
answers

Problems when performing database search (Filtering)

I have a problem while performing a search in the database. I have 3 search fields, City, Neighborhood, and Product, I want the user to filter the 3 or just City / Product or City / Neighborhood, however only City / Product, City or Product work...
asked by 10.04.2017 / 20:29
0
answers

Difficulty with mysqli_fetch_object

I'm performing the function as follows: Through a query: <?php [...] $sql = "SELECT f_u.*, f_i.*, f_g.* FROM form_user AS f_u LEFT JOIN form_imovel AS f_i ON f_i.imovel_id = $imovel_id LEFT JOIN form_img AS f_g ON f_g.imovel_id = $imo...
asked by 18.04.2017 / 19:34