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
-
-4
votes1
answer319
viewsMysql queries always busy
I have a task cron which obtains remote data every 2 minutes, via webservice, by entering the values obtained in a database. At the end of each day, more than 50,000 records are created. The problem…
-
-4
votes1
answer651
viewsHow do I insert variables from a select query into a database on a different server?
I would like to make a connection on php in two databases only that are in different networks, in this connection would need to do a search in a database on a server and insert in a table in a…
-
-4
votes2
answers222
viewsPDO and mysqli are the only options to work with PHP database?
And if I needed to use a database that wasn’t supported by PDO, what I could do? After all, what does PDO do underneath the scenes? It uses mysqli?
-
-4
votes1
answer63
viewsHow is a website published and hosted on the internet?
My question is how a site made with PHP and Mysql is published on the internet? And how is it hosted on an online server?
-
-4
votes1
answer108
viewsLogin screen - cannot log in a user, admin or user
users table; create table usuario( usuario_nome varchar(15) not null, usuario_senha varchar(15) not null, primary key (usuario_nome) ); permission table; create table permissao( usuario_nome…
-
-4
votes1
answer30
views -
-4
votes1
answer258
viewsWHERE clause with PHP coming from Javascript
I need to pass a variable from PHP in a clause WHERE of a SELECT, but this PHP variable gets a value from JAVASCRIPT. I ran a test passing only a native PHP value and it worked: <?php $phpNum =…
-
-4
votes1
answer178
viewsSyntax error when testing the query in phpmyadmin
Error solved . Query SELECT i.codiniciativa, te.nome as nome_tema, te.codtemaestrategico as cod_te, p.observacoes as per_obs, te.sequencia as tem_sequencia, p.sigla as per_sigla, p.nome as…
-
-4
votes1
answer34
viewsSomeone can help me I’m a little new in the matter... DATABASE
I’m setting up a quiz site... has three types of tests. FRIENDSHIPS BOYFRIENDS MARRIED each test has 15 questions, how do I save the text of these questions in the database and then generate a hit…
mysqlasked 6 years, 10 months ago Gabriel Felipe 11 -
-4
votes1
answer63
viewsLIMIT does not interpret variables
Does anyone know why variables are not interpreted? I’m passing via ajax with data:{"inicio=0&fim=2"} and when I try to return to the query I’m not getting. $.ajax({ url: 'php/teste.php', type:…
-
-4
votes2
answers3568
viewsPHP - Parse error: syntax error, Unexpected 'public' (T_PUBLIC) in
Good morning! I am with this code and I support the site, out of nowhere this error started to appear :( public function getUrlcliente($cliente_id) { $parametro = "cliente_id=" . (int)$cliente_id;…
-
-4
votes1
answer82
viewsSQL to create fk int in TABLE
Film COD (int, pk) name(varchar 20, not null) birth (datetime, not null) Obs(tinybit, not null) Obs2(int, fk, not null) I thought of something like create table filme ( COD int PRIMARY KEY…
-
-4
votes1
answer102
viewsSQL tags in query
I am starting my studies in SQL and do not know what meaning of this structure below. I would like to know what are these tags. I am using in Java. I have a file mapper.xml to create queries in…
-
-4
votes1
answer81
viewsJava Help: Save a Key-Value Arraylist in a BD
I would like to know how to save a key and value Arraylist in the database using Java; I had already made an implementation earlier in php similar, whose I created the array and used the function…
-
-4
votes3
answers1025
viewsWhat types of data exist in Mysql for storing text and integer numbers?
The attribute I want to store refers to a class, the code of this class must contain integers and letters, and it is a primary key attribute. Example of value I want to store: SI3P39
-
-4
votes1
answer53
viewsmysql description
look at my code select count(alunocursos.codAluno), alunocursos.codCurso from alunocursos join aluno on (aluno.id = alunocursos.codAluno) group by alunocursos.codCurso this will make me return the…
-
-4
votes2
answers69
viewsHow do I extract the number of orders with 5 different items? I have this query but it is coming out a different result than expected
SELECT DISTINCT(pedidos.id_pedidos),produtos.nome_produto FROM pedidos INNER JOIN itens_dopedido ON itens_dopedido.id_pedido=pedidos.id_pedidos INNER JOIN produtos ON…
-
-4
votes1
answer498
viewsSimple query of Mysql
I know very little about SQL and I’m thinking about a very simple system - but I don’t know how to set it up and it’s for a public school that doesn’t have a programmer to hire at the moment. I have…
-
-4
votes1
answer37
viewsHelp with installing php 7.0 in Ubuntu as per video tutorial
Following this tutorial video https://www.youtube.com/watch?v=onVSVC_C1GE&t=717s. Already at the beginning of the default change, made the default changes, the default Nginx index should be…
-
-4
votes1
answer75
viewsPHP - You have an error in your SQL syntax;
Hello I have an error here! I have the same code as another page but on this page it works and this one does not... error: You have an error in your SQL syntax; check the manual that Corresponds to…
-
-4
votes1
answer878
viewsSQLSTATE[08004] [1040] Too Many Connections
This is my connection class: /** * Conn.class [ CONNECTION ] * Abstract connection class. Singleton standard. * Returns a PDO object by the static getConn() method; * * @copyright (c) 2017, Horacio…
-
-4
votes1
answer237
viewsError saving to mysql
Good afternoon to all... I would like to know the reason for the error in the array below... This happens when I pass it to record in the database Array ( [arquivo] => Array ( [name] =>…
-
-4
votes1
answer47
viewsUse PHP PDO for search
Where is the error in my code. I do not know why it does not return the search result. <?php require_once('db_connect.php'); $conectar = new…
-
-4
votes1
answer135
viewsproblematic mysql query
have the following data admlogin: admin1 admpassword:admin admlogin: admin2 admpassword:admin admlogin: admin3 admpassword:admin <form action="#" method="post" id="frm_login_p"…
-
-4
votes3
answers131
viewsMake a request on the server with 2 parameters
Well, I’m making a person use a "range" and decide a value, as soon as the person modifies the range, a search is being done in the database about a game and its value, use ajax with php for this,…
-
-4
votes1
answer69
viewsHow to insert at the same time without giving duplicate key error?
<section class="content"> <div class="row"> <div class="col-md-12"> <div class="box box-primary"> <!-- form start --> <form role="form"…
-
-4
votes1
answer258
viewsNot all Arguments converted During bytes formatting Insert Python
I was trying to add python integer values to a mysql database with the following code: import MySQLdb valor1 = input("Digite o primeiro valor: ") valor2 = input("Digite o segundo valor: ")…
-
-4
votes1
answer149
viewsView photo registered in the bank
I want to display a photo registered in the database that was registered in a type blob attribute. However I do not want to display the photo through a link where you click and open the photo, on…
-
-4
votes1
answer385
viewsFatal error: Uncaught Error: Call to a Member Function bind_param() on Boolean in C: xampp Stack trace: #0 {main} thrown in C
<?php include("conecta.php"); $id = 0; $nome = $_POST['nome']; $cpf = $_POST['cpf']; $pis = $_POST['pis']; $dataCadastroPIS = $_POST['dataCadastroPIS']; …
-
-4
votes1
answer69
viewsHow do I bring an HTML code stored in the Mysql database and print it on screen using MVC Express Node.js Project?
I want to print this code that is stored in the database in my project. And this is coming up instead of the code Here is the DAO providing the database information Here is the CONTROLLER that makes…
-
-4
votes2
answers43
viewsPossibility to search in one or more columns of the same SQL table
I have a splint where several products are displayed. On the left side, there are several options for the person to make filters in the product list. I am trying to create a form if the variable has…
-
-4
votes1
answer58
viewsHow to convert date to datetime with PHP and Mysql
I am importing an Excel spreadsheet and need to convert the date to datetime for Mysql to accept saving. However, I have tried all the options on mutator of Laravel and I couldn’t make that…
-
-4
votes1
answer64
viewsphp does not update registry in bd mysql
I’m trying to update the database, it returns the message that the update was made, however, when seeing in the database, the update was not made. What should happen: When clicking the save button,…
-
-4
votes1
answer37
viewsSubquery Delete in Mysql
I have the following table (Example), where the ID user 151 has 2 records: id (Primary Key) user name 1 151 2 123 3 985 4 151 5 652 I need to delete this user’s 2 records. The problem is that as the…
-
-4
votes1
answer22
viewsShow result of a sql by group query on PHP page
Good evening, this code works exactly the way I need to run directly in sql, but as I do for it to appear in a php page, I tried several things, I even managed to print but it does not appear right.…
-
-4
votes1
answer30
viewsError importing SQL wordpress database
When trying to import database the following error occurs: Erro Comando SQL: CREATE TABLE `wpzm_actionscheduler_actions` ( `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `hook`…
-
-4
votes2
answers67
viewsPost PHP , duplicates, triples, quadruple records in Msql
I have a php form to include records in Mysql, when sending the record duplicates triples the times quadriplica records in mysql, in a topic I saw the suggestion to disable the button, preventing…
-
-4
votes1
answer21
viewsSELECT TWO COLUMNS THAT HAVE THE SAME ID IN DIFFERENT TABLES AND MAKE COMPARISONS
Good night Devs, I need to take each actor_id and film_id and check which total of movies(filme_id) has linked to actor_id and this I got : SELECT actor_id, COUNT(film_id) from film_actor group by…
-
-4
votes1
answer44
viewsDigital catalog
` <?php $result_estoque = "SELECT estoque FROM produto"; $resultado_estoque = mysqli_query($conn, $result_estoque); $result_estoque >= 1; if($result_estoque >= 0) echo "<font…
-
-5
votes1
answer2243
viewsHow to insert XML data within a MYSQL database?
Generating the file XML with PHP get the following result: I’d like to send this now to a database MYSQL by inserting the columns in the table first Imovel and then filling these columns with the…
-
-5
votes1
answer449
viewsPDO connection file. How to use?
I have a PDO connection file. To include this connection in other system files in order to make the requests in the database, I will use this???? <?php require('conexao.php'); ?>…
-
-5
votes1
answer138
viewsJava, IPVA Expiration Check According to Car Board
I have to check the IPVA maturity, but I have no idea how to do it , since every year changes and for a due date there are several end plates.
-
-5
votes1
answer252
viewsMysql Deprecated
When entering data into a table the following message appears: Deprecated: mysql_connect(): The mysql Extension is deprecated and will be Removed in the Future: use mysqli or PDO Instead in C:…
-
-5
votes1
answer761
viewsPHP - Taking values from an HTML table and inserting them into a Mysql table
I have a table that is the result of a Mysql query from a database on a server. It is shown as follows, for example: E-MAIL VALUE ------ ----- email1 P email2 P email3 C email4 P email5 C email6 P I…
-
-5
votes1
answer949
viewsCalculate date time in mysql
I have a log tab with a TIMESTAMP type column that saves the user’s login and logout time. I need a select compare the time of login and logout of the user to calculate the time that the same stayed…
-
-5
votes1
answer105
viewsMysql not creating the PHP content line
When I try to pass values to my database I don’t find them in it, I’m using php with MAMP. Follows the code: <?php error_reporting(E_ALL);ini_set('display_errors', 1); $host = "localhost:8889";…
-
-5
votes2
answers75
viewsUse Inner Join with <ul> and <li>
Hello, I’m trying to list the Sub-Categories within their respective Categories with Inner Join, but I’m not getting it, see what’s happening with the Categories menu. Below I relate the code…
-
-5
votes1
answer265
viewsHow do I Inner Join with these tables?
How would the SELECT query in Mysql from the Inf_musicas table?…
-
-5
votes1
answer476
viewsSELECT SQL WITH WHERE "DOUBLE"
I am trying to make a query in the Mysql database with the following syntax SELECT id, codigo, faca, descricao, vendedor, imagem FROM produtos WHERE sit = 1 AND descricao = ESTE Even that part works…
-
-5
votes1
answer128
viewsHow to break table row with mysql data
Hello I made a request system more would like to know how I can do to break the line after the commas . So when I print the order in the kitchen it comes as follows Tambaqui rib : 1 Tabaqui Frito :…