Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
0
votes2
answers25
viewsDifficulty mounting query for Search in multiple columns
I have 2 tables tab_user user_id | nome_user | tel_user 1 jão 888 2 mari 999 3 jão 777 4 mari 666 tab_product id_produto | user_id| carac_a | carac_b | carac_c | carac_d 1 1 aaa bbb ccc eee 2 1 mmm…
-
0
votes2
answers1376
viewsHow to make a Login and Password system secure for Mobile Apps?
I created a security system in php with mysql for my website, but through the browser on desktop computers, the session is stored in cookies, and it is easy to know which user is logged in and what…
-
0
votes3
answers866
viewsEntering numerical data in the database
I’m having trouble inserting into the database the field is formatted as DECIMAL(10,2)), when I try to insert the direct monetary value by Mysql works with the endpoint instead of the comma ex:…
-
0
votes1
answer48
viewsCustomer Grouping with LIMIT 10 per Store
Good morning guys, I have the following query, for MYSQL 8: With Empresa as (Select aurea.oi, aurea.razao, aurea.fantasia From aurea Where aurea.id in ( 1302, 791, 2496, 1681, 1203 )), CapaPedido as…
-
0
votes2
answers164
viewsPHP/Mysql Select products below a value in the table
I need to select the products with the value below 300 reais in which column situacao be equal to 2: Example: in the shopping table I have 8 products registered: 1 sapato valor 25 situacao 1 2 calça…
-
0
votes2
answers452
viewsHow to send data from an HTML page to Mysql?
I made a registration form, but when sending the values to the database, it does not fill the table and returns no error. Code I used was the following: <body> <?php $conexao =…
-
0
votes1
answer178
viewsJSP Database Connection
Hey there, guys. My problem is this : I have a JSP project, which used the Oracle SQL database. However, it came in handy that I used Mysql and installed . Mysql jar and I changed the Connection…
-
0
votes1
answer1051
viewsMysql error - phpmyadmin: Access denied!
I have this problem with phpmyadmin, it was working normal, but when I typed: "mysql" in the linux shell it did not open mysql, only when typing: mysql -h 127.0.0.1 -P 3306 -u root. Then I saw some…
-
0
votes1
answer961
viewsHighchart chart importing table values from the database
I have a system where students are enrolled in training classes, every enrolled student is "scheduled" to attend and when he attends, in addition to scheduled he "held". What I want is to make a…
-
0
votes0
answers263
viewsReset AUTO_INCREMENT without losing data
I am working with a table of offices, where the number of the craft and the year in which it was created are a composite primary key. I am generating the number of the craft through AUTO_INCREMENT…
mysqlasked 7 years, 2 months ago Lucas Ramos 321 -
0
votes0
answers345
viewsGeneric crud with phpoo and Pdo (no framework)
I want to make a kind of Generic Crud and I implemented the function of Insert, I know that the way I did is not a better way to do it and I don’t want to use any kind of frameworks and so I would…
-
0
votes1
answer682
viewsError No value specified for Parameter 4
When I execute the code by the browser appears the error quoted in the title "Error No value specified for Parameter 4". Below I will leave my DAO and my Mysql configuration if someone can help me…
-
0
votes1
answer43
viewsList the Result of a Query
I want to return in my code a list of users through a query data, I have the following model: <?php class Usuario{ public function listar($condicoes = array()){ $db = DB::criar('padrao'); $sql =…
-
0
votes2
answers38
viewsProblem with running SQL through FORM
Php code: if($_REQUEST['alterarStatus']){ $alterarStatus = trataaspas($_REQUEST['alterarStatus']);} if($alterarStatus=="aprovado"){ $SQL = "update ps set StatusTransacao='Aprovado' where Referencia…
-
0
votes0
answers38
viewsIdea for data cleaning and processing library
I need to make a library for data processing, so I can use it before calling functions like: Register, Change, Delete and etc... I am using PDO for communication with the mysql database, and the…
-
0
votes2
answers199
viewsHow to show Options (HTML) with database elements
Hello, I want to do the following: I want the elements that are registered in the database to appear within a "Select - Option (FORM - HTML)". Ex: <body> <?php include("conexa.php"); $id =…
-
0
votes0
answers73
viewsComparison with 3 tables
create table Pessoa ( id int not null primary key auto_increment, nome varchar(150) not null, cidade varchar(100) not null, cpf char(14) not null unique, rg int not null unique, INDEX idx_nome(nome)…
-
0
votes2
answers427
viewsDifficulty creating summation column in mysql
I am making a committee report, but a doubt has arisen, I want to bring some totals at the end of the report such as the gross value of all committees, which would be the vl_comis - desc_comis.…
-
0
votes1
answer40
viewsProblems to count and group fields in the database
I’m starting to study the SQL language and the interaction between the tables, and I came across an exercise in a list that I’m not able to solve. He asks the following: For each existing product…
-
0
votes2
answers2523
viewsSQL - Merge order table and products
I have the following table of REQUESTS: `PEDIDOS`(`PEDID`, `PEDIDUSUARIO`, `PEDSTATUS`, `PEDVAL`, `PEDFORMAPAG`, `PEDTROCO`, `PEDDATA`) And the following product table, where each inserted row…
mysqlasked 7 years, 2 months ago Jhonatan Pereira 537 -
0
votes0
answers96
viewsMake two or more Select with Aliases in the query to generate a separate array
I have a single column table with all the words in English. I want to do a double or triple Select and recover in each query all words with 'A' in alias Palavrascoma, and all with 'B' in Alias…
-
0
votes1
answer3711
viewsFind difference between two tables
I wanted to mount an sql statement that returns differences between two tables. For example, I have the table arquivos and the table conferencias where it has equal fields called titulo and valor,…
-
0
votes2
answers792
viewslogin with Cpf or email in php
I have a little problem when making a login system which user should be able to authenticate by your email or Cpf. I am making the comparison with the value of the login field received, if it is…
-
0
votes1
answer1783
views"SQLSTATE[HY093]: Invalid Parameter number: no Parameters Were bound"
I have a simple class that runs an Insert on a Mysql database as follows: $db = new db(); $db->exec2([0=>["Brasil","BRA","BR"]]); In the db class I have the following list of queries :…
-
0
votes0
answers227
viewsUpdate photos in php database
Good afternoon, I’m having a problem saving the image in the database. It turns out that the image I update goes to the folder where it should, but in the database neither saves her name nor the…
-
0
votes1
answer1361
viewsHow to view image stored in blob type
I have a database that has a blob field. This field is to have a photo. I need to call this photo and display it. I do not have the photos that originated the contents of the database, so it is…
-
0
votes1
answer1355
viewsError 1005 : Mysql - does not create foreign key
I have a problem with Mariadb. I created two tables tbl_estoque and tbl_adiciona. Basically, I don’t want to add data directly to tbl_estoque. I want by means of a trigger, he checks the latest…
-
0
votes2
answers292
viewsHow to recover values from two tables in Mysql
is the first time I ask a question here, and I’m having the following difficulty. I’m doing my TCC info, it’s a website for students and such... it’s like Facebook sacks? I locked in the part where…
-
0
votes2
answers195
viewsHow to list the latest message from all conversations
I’m creating a chat in android studio, so I need to list the last message between the chat user and his contacts, regardless of whether he sent or received the last message. I have selected below on…
-
0
votes1
answer450
viewsHow to send Phpmailer and values to a Mysql database
I am trying to send the form data to an email using Phpmailer (this is already working) and take advantage to include this data in a Mysql database table. It didn’t work, I imagine the error is in…
-
0
votes1
answer73
viewsProblem with subquery
Good night, I need to bring the full subquery result: (select (valor * 0.05) from tbl_exames) as 'Valor dos Exames', In a delimiter: delimiter // create procedure comissao(idmedico int) begin select…
-
0
votes2
answers2026
viewsView database data from
I have a bunch of data with information from various bands, however I would like to pull them to my front page. bank name: dados Call table : Artists where I have the information : imagem_small ( in…
-
0
votes1
answer157
viewsI am unable to authenticate user
I am not being able to do user authentication, just redirecting to the part where "it is not possible to register user". <?php $login = $_POST['login']; $senha = MD5($_POST['senha']); $connect =…
-
0
votes1
answer1200
viewsSend data without PHP refresh
I have a form with n tables involved and needed to leave all the Insert in one file only, well this I already have. But I need it sent without refresh and for that I am using ajax. Here is the…
-
0
votes1
answer82
viewsDynamically display the database record with the respective category
I have this html code that separates the records from the database according to the category. <div class="example1"> <h1>Painel do Cliente</h1> <div class="panel…
-
0
votes2
answers6501
viewsFatal error: Function name must be a string
<!DOCTYPE html> <html lang="pt-br"> <head> <meta charset="utf8_general_ci"> <title> sistema de cadastro</title> <link rel="stylesheet"…
-
0
votes2
answers1347
viewsInserting data using PHP array
I have a table and need to insert data from this table through an array. However gives this error: Notice: Array to string conversion in C:\xampp\htdocs\PhpProject1\salvar.php on line 17 My Index…
-
0
votes0
answers80
viewsUPDATE Mysql PHP
I have a website in 3 languages. PT-EN-ES. The customer always registers the information in PT first. After that add the other languages. DOUBT: In the control panel has the option to ADD these…
-
0
votes0
answers59
viewsLoop interrupts script, but does not give error
I am putting together a list that collects user data. As some data is in different tables (attachments, precisely) I have put together a query select to capture only those attachments having the…
-
0
votes0
answers62
viewsEncoding error when entering data into database
Guys, I’m starting now and I’m trying to create a small form with PHP and Mysql that sends the form information to the database, but I’m having a small problem. When entering the data in the…
-
0
votes1
answer109
viewsWhat is the relationship problem in these tables?
I’m using the Laravel and would like to make a relationship of table of municipios containing the estado_id. The estado_id will be related to the estado_id of table of estados. Just when executing…
-
0
votes2
answers46
viewsShow member with id same column
As I do to display a list of members of each post, being that some members are in more than one position. The categories where the members are, are in the same column separated by pipe (|). Follow…
-
0
votes3
answers404
viewsSQL query does not return value
Good afternoon to all. I have a question about what could be going wrong in a database query in which I use templates in PHP. Based on this project: http://raelcunha.com/template/ All right, I…
-
0
votes1
answer95
viewsDifficulties picking up values within an array
I’m making a code where I select database information and feed an array, then I’m trying to use the contents of that array to compare with other information and process the rest of the code. But I’m…
-
0
votes1
answer83
viewsSQL SUM() syntax error
I have the following scenario: A table of products (tbl_prods) that has among other fields the price of each product the type of products and the date of the transaction (dt_trns). The guys can be…
-
0
votes1
answer33
viewsReturn value grouped by date
I have a table on Mysql, which stores my customers' confirmations on my website, having as fields: id | cod_cliente | data, the date being the main. What I need is to group and return the result of…
-
0
votes1
answer118
viewsError inserting data into table!
In the student registration system has this logical scheme: How can I enter the correct student data ? SQL -- Geração de Modelo físico -- Sql ANSI 2003 - brModelo. CREATE TABLE Aluno ( idaluno…
-
0
votes2
answers153
viewsError while displaying array in PHP
I have this array in PHP and I must display the users name and email field. But php display an error message: array(4) { [0]=> object(stdClass)#25 (5) { ["idusuario"]=> string(1) "2"…
-
0
votes0
answers494
viewsCall to a Member Function method() on string
I am using Codeigniter and, while trying to do a search in my database to see if a given line really exists, it presents the error Call to a member function checarId() on string. Follow the code of…
-
0
votes2
answers954
viewsPDO Insert Record
I’m in trouble to insert bank record with PDO, below follows the tabela and script: Calendar table CREATE TABLE `calendar` ( `id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET latin1 COLLATE…