Most voted "mysqli" questions
The Mysqli extension (Mysql Improved) is a relational database driver used in the PHP programming language to provide an interface with Mysql.
Learn more…945 questions
Sort by count of
-
0
votes2
answers31
viewsMysql search with input error
Search ta returning a news and ta returning all the names of the database: "Notice: Undefined index: search_name" in the.php connection. if(isset($_POST["acao"])){ if($_POST["acao"] ==…
-
0
votes1
answer64
viewsDetermine display order of ordered queries in MYSQL
I have three types of orders in the table and need to get the result so I choose who will index first. I specify the respective indexing order: ( ORDEM_COMUM IN FIRST ) ordem_comum,…
-
0
votes2
answers44
viewsChoose the order in which items are listed in Mysql
I have a table with three types of order, ordem1, ordem2 and ordem_especial . How can I list items in that order: EXAMPLE: ordem2 ordem_especial ordem1 I tried unsuccessfully something like : REAL…
-
0
votes2
answers83
views -
0
votes0
answers61
viewsLEFT JOIN. GROUP BY. this is incompatible with sql_mode=only_full_group_by
I have a system I used in 2013. I am migrating to the latest version of php and am having this error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column…
-
0
votes1
answer70
views -
0
votes1
answer56
viewsSelect after select result
I am trying to select in a table to display a list of activities. And second select on each of the first select lines to count how many are in each status, but I’m having syntax error, which I’m…
-
0
votes0
answers46
viewsPick up data via POST
Hello, I need help to continue a project, I believe that for people who already have an advanced knowledge is something very simple, but as I am layman is very complex. I have an index page where…
-
0
votes0
answers35
viewsShow only 1 record at a time with go to next button
Good night to you all. I would like to: Show records sequentially, (1 at a time), on a web page for a set of more than 100,000 records. I can show all at once, but I would like to only 1 at a time…
-
0
votes1
answer61
viewserror while trying to log in
I’m making a login system and when I press the button to log in it displays these two errors here Warning: mysqli_query(): Couldn’t fetch mysqli in C: xampp htdocs 200cono vlogin.php on line 8…
-
0
votes0
answers88
viewsPHP error while trying to pull data from Mysql database
Good morning guys, okay? I got a problem on the next one. I hosted my PHP site on a Server where there is the DNS and the main suffix of the network, so that the site can only be accessed internally…
-
0
votes0
answers43
viewsCreation of Search with Filters
Hello, in my project I need to filter the results with the following parameters: Minimum Wage and Maximum Salary, Contract Type. But it only works if the user chooses the options, if he chooses to…
-
0
votes1
answer65
viewsPHP and Database does not update, use of UPDATE - SET - WHERE
I’m having problems with the code I’m developing, I ask you to make the change in the database, however, no changes are made to my BD. Follows the code: <?php $id = $_POST['id']; //Variável de…
-
0
votes1
answer205
viewsQuery sql to search for and a string equal to but larger than the one stored in the table
I have a table that stores screen urls from my system, I wanted to perform a query that returns me a url that comes parameterized as follows /avaliacoes-cozinha-segura/avalia-cozinha/2 to that url…
-
0
votes1
answer50
viewsmodal with data from tables other than mysql
Hello! I’m facing a problem with a dynamic modal. On an Index page, the user will select a state and a city and will be forwarded to the modals page; On this page will be presented the Branches of…
-
0
votes1
answer64
viewsUPDATE does not work with data from a POST
I am getting the data from a POST and trying to update a mysql table, but UPDATE does not work at all. If I use as described below, just replace the values with empty. <?php…
-
0
votes2
answers314
viewsReturn last entry of each product
help me. I’m in a situation where I want to bring only the last note entry of each product to create a report. I created a select, but there are products repeating where they shouldn’t. See select:…
-
0
votes1
answer36
viewsMysql characters
I am with a registration system in one of the fields I insert an html code: <iframe…
-
0
votes1
answer54
viewsHow to search for id separated by "," correctly?
I have a table called attendance, within it I have a field called forwarding, in the forwarding field I save the ID of the "routing types" I have registered in the table cad_forwarding separated by…
-
0
votes1
answer36
viewsIncorrect grouping of lines
Hello someone can help me, I’m trying to bring a company report and activity made in 12 months, a company and an activity was made during 12 months and I want to know each activity if it was made in…
-
0
votes1
answer91
viewsSubtraction of values in the same table and column
I have a table in phpMyAdmin called flow, in this table is the flow of a box (The description would tell us what each record is for) I need to have a way to achieve the net profit of each month in a…
-
0
votes0
answers113
viewsError trying to add a double column in mysqli
I need to add some columns to my mysqli that according to the wamp is the version 5.7.26 because I am doing the integration with paid market, however, I realize that regardless of the way I create…
-
0
votes0
answers19
viewsData being entered correctly only in debug mode
I’m working on an archive import .txt where the elements are separated by |. So far so good, the file is interpreted, the values are stored in an array and then I need to enter the values in the…
-
0
votes1
answer28
viewsSystem news PHP - News without error picture and do not delete
Hello! With the help of some friends here, I set up a news system. But I came across a problem. When I need to delete the news I use the following code: <?php…
-
0
votes2
answers56
viewsmysqly connection to php
hello, I am studying PHP but I have a code that is not storing in BD, I have debugged it all, the error tests n return nothing, it is only blank but n stores follows code: <?php require…
-
0
votes2
answers76
viewsSelect mysql of a ranking
Well I’m setting up a ranking of donations, the table in the database is like this: -- -- Estrutura da tabela `Doacoes` -- CREATE TABLE `Doacoes` ( `Cod` int(11) NOT NULL, `Doador` varchar(255)…
-
0
votes1
answer60
viewsTake data from two tables at the same time, just when you log in
I’m trying to get data from two tables right at the beginning of the session when the user logs in, when I use the SELECT * FROM usuarios, orders WHERE email = '$login' and senha= '$senha' I can log…
-
0
votes1
answer117
viewsHow to know if the database connection is correct PHP
I’m 16 hours away trying to make a database connection work and I’m not getting it, I don’t know what I’m doing wrong, I’m currently using shaman, and I’m working for a client who needs to access…
-
0
votes1
answer174
viewsmysql error Error updating record: You have an error in your SQL syntax;
I’m having a problem with an update. of this mistake string(42) " UPDATE files SET desc='ssss' WHERE id=131" Error updating record: You have an error in your SQL syntax; check the manual that…
-
0
votes3
answers112
viewsWHERE condition does not work
I’m trying to put a condition in a function and it’s not working... I tried to put this condition but it didn’t work $this->db->where('idUser =', $this->session->userdata('id')); Usually…
-
0
votes1
answer38
viewsGuys, I have a question with Mysql about Procedures. Is it possible to save their return in a BD variable?
I have a repetitive process in BD that is validate the user for each request, so I decided to create a process for this and call inside the others when necessary. However I have the need to save the…
-
0
votes0
answers36
viewsHow do I dynamically delete a Row with Flask?
Guys I have this code in HTML {% for row in rows %} <div class="card border-success mb-3" style="max-width: 18rem;"> <div class="card-header">{{ row['title'] }}</div> <div…
-
0
votes1
answer74
viewsInsert data into the database with foreach
I have an array that receives data from a session and I am trying to insert it into the database using foreach but nothing happens. What may be wrong? Follow an example of the array: array(3) {…
-
0
votes1
answer260
viewsFatal error: Uncaught Error: Call to Undefined method mysqli_stmt::fetch_object()
code works if it is fetch() with fetch_object() of the error public function consulta($id) { $mysqli = $this->conexao->getCon(); $sql = $mysqli->prepare("SELECT * FROM pessoa WHERE…
-
0
votes0
answers66
viewsSession does not open when logging in
I’m changing an old admin project, I was able to switch passwords from sha1 to password_hash, but the session no longer opens when logging in. What could be happening? I have searched and found no…
-
0
votes0
answers178
viewsError including in database: Duplicate entry '-1' for key 'PRIMARY'
Friends have this table, when I save a user the following error occurs Error including in database: Duplicate entry 'first name.last name -1' for key 'PRIMARY' This is the code. detail in…
-
0
votes1
answer45
viewsDoubt Mysql - Query result
Help me with a situation please, I need to get all the records of the table "buyer" and its attributes and if I have in the records of a client in the order table linked to some buyer listed it…
-
0
votes1
answer65
viewsHow not to allow the user to create HTML using input text?
I am relatively beginner in programming, I am 17 years, 2 years with programming but no experience in the job market and recently I started working more actively with HTML. My problem is with regard…
-
0
votes1
answer41
viewsSelect works perfectly, but when it is passed as function returns error
I’m facing a dilemma that seems to be simple to solve, but I can’t see where the error is. I have a SELECT COUNT(*) that works correctly, but when it is passed as a function the error occurs…
-
0
votes1
answer164
viewsSumming Values of an Array Grouping by Key
I posted a question here this week, but it was negative for lack of more information, from then on I ended up solving the problem in question, so I will leave here the solution I found and if you…
-
0
votes1
answer49
viewsSQL returning empty, if($id == "" or $id == null or $id == 0) but only falls on Else
Good afternoon guys, first thanks for helping me, I’m finishing a system and I have a problem that I believe is very simple, but I can not solve, I tried several ways to change the if, but will not…
-
0
votes1
answer58
viewsDE_PARA SQL | Change table values based on information from another table
Good morning guys. Can you help me? I have previously researched elsewhere but could not find a viable solution. I need to change the data in the table below according to the new information. Data…
-
0
votes2
answers86
viewsHow do I pull all user data from Session?
To summarize, I created a page where the user when logging in will be able to see your data, it is responsible for displaying all of them and still some options to edit (but this is not what…
-
0
votes1
answer72
viewsWhile doesn’t display if I use get id?
Can someone help me understand why this code is failing to display the genre of the bank? <div class="first_info"> <?php $vide = $_GET['i']; include "core/home/database.php"; $consultaGe =…
-
0
votes0
answers32
viewsDo you have a system to select profile equal to Netflix with different bank?
I created a table in the database with the parent user data, the one who created the account, and created a table that specifies only the child profiles, the ones that are added for each person.…
-
0
votes0
answers43
viewsHow to pass String filter in a change from Mysqli to PDO in PHP?
// Mysqli $vf = mysql_query('SELECT id, cnpj, id_erp, fantasia, razao FROM usuarios WHERE nivel="3" AND ( nome LIKE "%' . limpa($_POST['termo']) . '%" OR email LIKE "%' . limpa($_POST['termo']) .…
-
0
votes1
answer31
viewsProblems with ORDER BY in MY SQL search
Good morning guys, how are you? I have a little problem to get a more "advanced" search with my MYSQL, you can help me? I created a search as follows SELECT idproduto, descricao, vconsumidor FROM…
-
0
votes1
answer25
viewsSelection of Recipes by Specific Ingredients
Well, I’m creating a recipes website and one of the searches is a search for selected ingredients. My table in the database is this: CREATE TABLE Receita( idReceita INT NOT NULL auto_increment,…
-
-1
votes2
answers70
viewsThe inclusion of data is not occurring in the database, and the connection and variable is arriving in the function
Function gravar_task($connection, $task) { if(mysqli_connect_error($connection)){ echo 'Sem conexão com banco de dados'; die(); } $sqlGravar = " INSERT INTO tarefas (nome, descricao, prioridade)…
-
-1
votes1
answer441
viewsUpdate Mysqli Data
Staff need to make the BD update the following data of this wireframe via Mysqli, I would like some tips on how to proceed.…