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
votes0
answers22
viewsFormatting date to save
Hello, I need to convert a date that is in String to save to a variable data_inicio of the kind Date in Mysql and I did it as follows: String data = "14/11/2017"; SimpleDateFormat formataData = new…
-
0
votes0
answers35
viewsInsert data into a table from another 4
I have this code to enter data into the database, I would like to insert data from 4 tables into one. But consecutively, I tried this way only that it adds the same data to the last 3 tables and…
-
0
votes1
answer842
viewsMysql - How to make a Stored Process be activated once a day?
I need a Stored Procedure to be called every day at 11:59 pm but I’ve tried a few ways and when it arrives at that time it doesn’t perform! CREATE EVENT `ATUALIZARDADOS` ON SCHEDULE EVERY 1 DAY…
-
0
votes2
answers168
viewsSecurity failure (PHP, JS, API, MYSQL)
I made a site with login, registration and etc. I validated the login and registration with POST method, the site is on the server and everything, but when I put the link of the url already inside…
-
0
votes1
answer168
viewsSELECT with LIKE and LEFT JOIN
Hello, I’m trying to get records based on the name of the stone and the tags. Tables: ** Tabela tag ** ---------------- id nome ---------------- 1 Sem categoria 2 cs 3 weapon 4 balrog ** Tabela…
mysqlasked 7 years ago Ainsley Harriott 1 -
0
votes0
answers247
viewsFPDF with php last blank page
I’m having a little problem in my code, it’s generating the last blank page. Follow the creation of this code with the help of the community: FPDF with Mysql and PHP - Bringing Repeated Data I’ve…
-
0
votes0
answers304
viewsHow do I change only one field
When I change a table data, change all other fields: code : <?php if( $_SERVER['REQUEST_METHOD'] == 'POST') { $nome_produto = isset($_POST['nome_produto']) ? $_POST['nome_produto'] : '';…
-
0
votes0
answers91
viewsConversion to PDO
I would like your help to transform the following code to PHP PDO. I made the following conversions and commented on the front of the code, just to answer the question. It is if the conversion is…
-
0
votes0
answers110
viewsHow to update several php postgresql records?
I need to update several records at the same time with php/postgresql (also for mysql) through a checkbox and textbox but I’m not getting it. The code below only updates the sequence field of the…
-
0
votes1
answer1060
viewsHow to add columns from different tables?
I am trying to assemble an SQL command for my virtual store that returns the total order value, a table of items (pedidoitemaux) and an additional one for the items (pedidoitemadaux). I built a…
-
0
votes1
answer372
viewsError mysql_error() = "" and mysql_errno() = "0"
Times on the system where work happens to appear the following errors mysql_error() = "" and mysql_errno() = "0", but it happens very rarely . my code: // Essa função está dentro de uma class do meu…
-
0
votes1
answer240
viewsHow to update Mysql results automatically with Javascript?
How do I update Mysql queries automatically with Javascript? I was looking at the site and I found something that helped me just that I put on my site and when I went to see the server processes the…
-
0
votes0
answers38
viewsInsert happening several times in the database
I have a code that makes an entry in the database but, in the database is inserting several records at once Follows code: if($_GET["act"] == ("cad_master")) { $startaction = 20; }…
-
0
votes1
answer338
viewsWhat is the best way to store Google Maps points in the database?
I am developing a system that will store some Google Maps paths of registered users and structured my table as below: ---------------------- | trajetos | ---------------------- | id | | id_usuario |…
-
0
votes1
answer180
viewsSearch by number in Mysql table with PHP
I have a search form where the user type a number and if it is equal to the number in the database it returns the data of that number. But when I click on button enviar he shows me the page…
-
0
votes2
answers246
viewsI need to select recipes and their ingredients, without repeating the other recipe fields
I have the following scenario: Revenue Table --------------------- id name method of preparation category Ingredient Table -------------------------- id name Table Ingrediente_recipe…
-
0
votes1
answer32
viewsProblem entering data into database
A Notice appeared stating that the variable was not defined, but everything is right in my view. Page addir_categoria.php <!DOCTYPE html> <?php session_start(); ?> <html>…
-
0
votes0
answers195
viewsI cannot show the Mysql table data on the site
So, I was making a site per host site on wampserver, and it was working normally, now I put it to host on hostiger, and it’s no longer pulling the table data. Does anyone know what it could be??…
-
0
votes2
answers99
viewsMYSQL: How to make a month closure from day 26 to day 26
I have a service registration form, and at the end of the month I have to analyze the closing costs of the amount of services, and pay the service providers. But the closing of the month is every…
-
0
votes1
answer142
viewsProblem when checking if user already exists before registering
I’m starting now, and I have a question. I had done to register a category, until then ok, but I realized that I was registering even with an existing category, then I decided to add a function to…
-
0
votes1
answer158
viewsOnly the first row of a PHP dynamic table is saved in Mysql Database
Only the first row of the table is recording in the database, I notice that the problem is in the loop foreach ( $_POST['data'] as $key => $value). By clicking the "Add" button a new row of the…
-
0
votes1
answer173
viewsAjax to make select in bank does not work in new line
I am having difficulty in the following situation, when generating a new table row my Ajax code to make a select in the database does not work. Follow the image below to clarify any doubts: Page:…
-
0
votes1
answer57
viewsAdd values from a table
I have the following query: $qrysel = "select * from won_auctions w left join registration r on w.userid=r.id where payment_date!='0000-00-00 00:00:00'"; This query will show a list of users of the…
-
0
votes1
answer146
viewsScript only number
I have a script that only lets you type numbers into one input however when I type a phone number and save it to the database. The number is saved all scrambled. Example: Type in the input…
-
0
votes5
answers683
viewsHow to take input readonly
I’m trying to get that by clicking on button btnEditar release the inputs: funcionário, rca and regiao... I used this script but it didn’t work: <script language='JavaScript'>…
-
0
votes0
answers34
viewsError with mysql BD
I have an error in my comic that I can’t fix I already used the CHECK TABLE command with the EXTENDED function and it says that there are no errors in the tables. the problem is this: I made some…
-
0
votes1
answer37
viewsError in selection query about social network requests
Hello, in my project I need to list the people and requests received by the user, but when listing people, I need to list only those who did not submit or that the user did not submit requests, in…
-
0
votes1
answer464
viewsDatagridview loads the data but does not display it
I have a Datagridview, it loads the data but does not display them. private void AtualizarGrid() { //Procura no banco os registro digitado na caixa de pesquisa. AlunoDAL alunoDAL = new AlunoDAL();…
-
0
votes0
answers51
viewsReplication Does Not Work
In my configured replication, Slave does not execute Master’s instructions and also does not ignore the tables and the database I specified. I’m using the MySql 5.5 Follows the Archive my.cnf…
-
0
votes1
answer42
viewsUPDATE not working with ajax?
The problem is this, I have an editing form whose data is sent by ajax. Here’s the code: $("#edit_rua").click(function(){ var id = $(this).attr("data-id"); var nome = $("#nome_rua2").val(); var cod…
-
0
votes1
answer662
viewsInsert with Foreign Key (user + address(FK)) PHP(PDO) + Mysql
Good afternoon, you guys. I have a small question: When registering a customer (with an address field (fk)) the correct way is something like this, or has a better way? INSERT INTO…
-
0
votes1
answer41
viewsDifficulty in visualizing and paging
I have a menu with the option to view the registered phones, only the numbers that were registered without showing the rest of the data, the intention and the user clicks on the option to view in…
-
0
votes2
answers462
viewsHow to open a new window through PHP with the results of a SELECT?
I have a form in which the user will be able to select several subjects, being then selected a subject, through PHP I will pull from the database by SELECT and I will show on the screen with echo…
-
0
votes1
answer48
viewsConsulting cities without repetition and with different "WHERE"
When trying to resolve a platform bank issue hackerrank I could not understand the answer after having found in the discussion wing. The question says: Query a list of CITY Names from STATION with…
-
0
votes1
answer55
viewsConvert JSON data structure to Object
I’m using the framework Materializecss - autocomplete, and would like to feed a autocomplete field with data coming from my base. The autocomplete works with data in the following object structure:…
-
0
votes1
answer413
viewsHow to use pseudonyms in queries using Aliases along with Mysql?
I would like to be able to use the Alias 'AS' along with mysql without having to do query alignment, that is, I want the secondary queries to be named to use them in the main query, it is possible?…
-
0
votes1
answer50
viewsTriggers - I need help solving the issue below
I have the following situation : The tables described above are ger_usuario, ger_mensagem and ger_destinos. Being, the field proprietario (ger_mensagem) a FOREIGN KEY referencing the table…
-
0
votes1
answer35
viewsPHP in conjunction with Mysql in user record
I am making a user registration system and it has been presenting some errors if anyone can help me with them would be very grateful. <?php include("conexao.php"); $Email = $_POST['Email'];…
-
0
votes1
answer468
viewsMore than one cursor in the Mysql database
Do I need to run more than one cursor on the same precedent? This is possible? begin DECLARE done INT DEFAULT 0; declare v_dia, v_rotina int; declare v_hora time; declare v_saldo, v_valor…
-
0
votes1
answer79
viewsOnly save ID 0
I’m having a problem that I’ve tried many ways, but is only recording Zero id. Part of the Button to register the street in the neighborhood Listing of neighborhoods bairro_lista.php Part of the…
-
0
votes3
answers104
viewsDoubt with sql Inner Join in multiple tables
I have three tables. Usuários, Anúncios and Fotos. To query what I’m doing is to catch the id of the Ad, the Título, to Quantidade of views and the first photo of this ad from the photo table. Since…
mysqlasked 6 years, 12 months ago user60485 -
0
votes1
answer3628
viewsRecoverable error fatal error: Object of class mysqli_result could not be converted to string
I am unable to save the ID of the address in the bank, I select the address but I can’t <?php session_start(); $host = "localhost"; $user = "root"; $senha = ""; $banco = "cafeteriasp"; $conexao =…
-
0
votes1
answer186
viewsPHP data collection and inserting mysql data
I’m trying to collect data from the last section inserted via PHP in Mysql, which shows on the screen the last (id, Nome, Idade) etc. of query inserted. page after inclusion should appear this…
-
0
votes1
answer2169
viewsBest way to register two foreign keys in a table
I have 3 tables, being them: personal, pesso_juridical and addressee. Both the tebela pessoa_fisica, as for tebela pessoa_juridica use the table endereco. I would like to add two foreign keys in the…
-
0
votes1
answer187
viewsError creating a table in mysql
CREATE TABLE EPI ( CODIGO__EPI INTEGER NOT NULL, USUARIO_CODIGO_USUARIO INTEGER NOT NULL, TIPO_EPI_CODIGO_TIPO_EPI INTEGER NOT NULL, EPC_EPI VARCHAR (255) NOT NULL, DATA_CADASTRO_EPI DATE NOT NULL,…
-
0
votes0
answers123
viewsFilter to display output in Excel report with Mysql database and PHP
I can’t create a filter through this query that filters a bank search Mysql with PHP. I started editing it, but the problem is that I can’t generate this method using a variable that’s present on…
-
0
votes1
answer43
viewsUnwanted characters using jquery + php
I have a small problem, when I use the jquery append to display elements returned from a php query. Note: this is not the full append, it is a little extensive and I put only the part I need you to…
-
0
votes0
answers75
viewsFlexible search filter
I have a page with a search filter with the options "service", "state" and "city" and a Ubmit button that redirects to the page where a table will appear with already filtered entries. But currently…
-
0
votes1
answer290
viewsInsert variable in href in php with mysql
I am trying to pass on the value of Id_company in my href select, but without success. Can someone please direct me? This is my href: <div class="box-footer clearfix"> <a…
-
0
votes2
answers31
viewsError in searching the register in the comic
I made a registration page on my website, which to register needs Cpf and email. I made a SELECT to see if it already exists, if yes, do not enter, otherwise do not enter. I left Cpf as pk and email…