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
votes1
answer43
views -
0
votes1
answer42
viewsPHP error with Mysql
I’m making a mistake, and I don’t understand why. The mistake: Fatal error: Call to a member function fetch_assoc() on boolean the excerpt from the error: require 'conecta.php'; $sql = "SELECT…
-
0
votes1
answer927
viewsTesting a condition before UPDATE, with PHP - Mysql
I’m trying the following: I need the code below first to check that the record that is trying to be finalized (Pass status 1 to 2) is not finished. If you do not follow the NORMAL UPDATE. But what…
-
0
votes0
answers47
viewsRemove a certain value from multiple rows in a table?
I’m having trouble creating an algorithm to scan and delete certain emails from email groups. I have a table where company emails are registered that are displayed on the intranet, with these values…
-
0
votes1
answer1113
views -
0
votes4
answers1708
viewsDelete only selected PHP checkbox
I have a system that I did (I don’t know much about PHP) worked perfectly but after switching server stopped working the function of deleting only the selected checkbox, it simply deletes…
-
0
votes1
answer181
viewsUnlink is not working within loop
I have been trying for some time to delete images from a folder through an unlink within a loop,in the case while,but I’m facing the error: PHP Warning:…
-
0
votes0
answers49
viewsHow to install apache 2.2.31 in Edora?
I need to maintain a site that only runs with this configuration: Apache: 2.2.31 php: 5.4.45 mysql: 5.5.50-cll I am trying to set up in fedora23, I have already removed apache related td that was…
-
0
votes1
answer2051
viewsHow to put auto increment in php myadmin
I am using PHP my admin, but n is showing the auto increment option, what can I do?
-
0
votes0
answers941
viewsExport Table in EXCEL with PHP
I am exporting my data to excel format, but when I export the accents do not return correctly, this is my script: <?php include_once "bancodedados.php"; $table="smt_cadastro_sociedades"; $select…
-
0
votes1
answer53
viewsGoogle charts returning null in mysql query and loop
If I perform the query in the database it returns values, already in Charts it is returning null, what I am doing wrong ? <?php require("conexao.php"); //chama o arquivo de conexão ao BD…
-
0
votes1
answer46
viewsHow to mount key vaue array pair to insert into table?
$key = "id,name"; $val = "'$lastid','$autor'"; ... if ($email){ $key .= ",email"; $val .= ",'$email'"; } ... $keys = \explode(',', $key); $vals = \explode(',', $val); $arr =…
-
0
votes0
answers37
viewsMysql: Find errors using WHERE IN
I have the following situation with the tables below. I need to do some checking in "serials" (if the serial exists, if it is valid, etc, and other validations next to other tables) from several…
-
0
votes0
answers75
viewsI created a db with Wamp but when I click on the folder to see my php files n appears nothing
In phpmyadmin db is ok, but when I click on the folder that has the phps appears: It is not possible to access this site Could not find DNS address of Folder Name server. My wamp is green and…
-
0
votes2
answers526
viewsUpdate balance with revenue and expense
I have an application, where there is an option to register an ACCOUNT with initial balance equal to zero and two options to register REVENUE and EXPENSES. And when I register an IRS, the balance of…
-
0
votes1
answer193
viewsDelete a specific ID inserted as serialize in a column in Mysql
In my db I have a column called Range_ids, I do an ID insertion using the function serialize. These Ids look like an array, the problem is how I can make one DELETE of the specific ID within the…
-
0
votes0
answers172
viewsHow to insert data into two different tables with the same form?
I have a dynamic form where the questions come from a database table, some questions have multiple choice answers that also come from the database. but other questions are text questions. When doing…
-
0
votes1
answer687
viewsError while trying to execute Insert PDO function - PHP
I’m trying to create a PDO function to perform two inserts, one after the other, but I’m having difficulties. The function code is: public function double_cad(array $dados){ $pdo = parent::getDB();…
-
0
votes1
answer54
viewsProblem creating table in the database
I put these commands to create the table; CREATE TABLE pessoa ( codigo BIGINT(20) PRIMARY KEY AUTO_INCREMENT, nome VARCHAR(80) NOT NULL, codigo_condominio BIGINT(20) NOT NULL, codigo_proprietario…
-
0
votes1
answer804
viewsGet image name in mysql for id
I would like to know how to get the image name by user id, I have this comic: I would like to show only the image of the Claudiomiro, and not all that are in the comic... this way: I have this code…
-
0
votes2
answers51
viewsPHP-get the last 4 id’s inserted in the database
I have a database in which one of the tables has the designation "Products" and I would like to extract from it the last 4 items inserted in it. The column with the main key (Primary key) is…
-
0
votes2
answers216
viewsSort the largest on request
Good evening, I’m using the following command: select cliente_id, desconto, pedidos_detalhes.pedido_id, cliente_tipo from pedidos_detalhes inner join pedidos on pedidos_detalhes.pedido_id =…
-
0
votes1
answer56
viewsNullpointer Exception during registration using MVC standard
I have a ready-made application that was created procedural, but for learning purposes I decided to reprogram it using object orientation and the MVC standard. During the registration of a publisher…
-
0
votes0
answers35
viewsMysql Table XML via Access
I first need to know if Access can connect to Mysql database. From this connection, I need to generate through Access an XML that contains the data of a table of my Mysql database. Later this XML…
-
0
votes3
answers156
viewsHow to select users with the STATUS field =1 in the user table?
I have a table called USUARIOS with the fields NAME, STATUS. Suppose I have 10 registered users. How can I check if the 10 users have STATUS = 1 and if so, displays on screen one (OK). I know you…
-
0
votes0
answers92
viewsShow calendar generated with JS showing DB information
I am generating a calendar and entering the events with information taken from the database. When select brings only one result it is displayed normally, but when there is more than one the calendar…
-
0
votes1
answer329
viewsJasperreports report with multiple parameters
I have a report on JasperReports, is working properly. However, from the way it is, step only one meter each tipofrom the jsf page to the report, the screen is as per the image: What I need now is…
-
0
votes1
answer86
viewsHow to send values in a hidden way to the SQL Database within Windows with POST
Good morning guys, I have a question in PHP. I have a page on my site that contains a form that sends the information from it to a validation page that connects and sends the information to the…
-
0
votes1
answer367
viewsDo not want to save form data in POST Ionic + PHP + Mysql
It’s working the way I do on other forms, but I don’t know what mistake I’m making. I have a table "suppliers": An Ionic form, normal: <ion-view view-title="Cadastrar seu Restaurante"…
-
0
votes1
answer95
viewsSplit form to insert into rows other than Database (codeigniter)
I have a dynamic form that is filled as there are questions in the database, this form also writes text boxes, checkbox, textareas, etc according to the type of question defined in the database, the…
-
0
votes1
answer170
viewsSqlupdate does not change data in the database
Note: Several people could not solve this question and marked my question as erroneously duplicated because of an answer in a similar question but the answer does not help me at all. I am developing…
-
0
votes1
answer58
viewsCatching previous mysql database record
I have two tables, I want to get the previous record of recorded data from the second table based on the first. Tabela 1 | Tabela 2 id - hora | id - id_tabela1 - cod 1 02:30 | 1 1 1 2 02:45 | 2 2 3…
mysqlasked 8 years, 2 months ago Jefferson Hillebrecht 33 -
0
votes1
answer76
viewsHow to consult abbreviated words or not without differentiating them, as STREET and R.?
User inserts as search "STREET STOP". But in the Mysql database you may be saved as "R. Do Stop" or only "STOP". How to optimize this search to get the best result, or the closest ?…
mysqlasked 8 years, 2 months ago Pedro Augusto 2,392 -
0
votes2
answers124
viewsHow to know if a record has been made in the database?
How do I check if a certain id has been registered in the database, and if you have not registered using an Insert query and if you are already registered using an update query ?
-
0
votes1
answer232
viewsVariable returns strange characters
I am using the CPU-Z that when scanning your pc you have the option to save the log in txt or html so that it can be viewed manually. Done this I exported to html and ran INSERT INTO…
-
0
votes1
answer94
viewsRead a txt file by php and mysql and viewed by each user - PART 2
Everything was going fine until I came across a situation I couldn’t resolve so far. I couldn’t adjust the total values of the file. The example below shows how it is. And should look like this (R$…
-
0
votes1
answer111
viewsHow to create Array with BD content
I’m trying to create an array with the contents of a tabela of my banco but somehow, I tried to do this: // ATRIBUI UMA CONEXÃO PDO $pdo = Conexao::getInstance(); // ATRIBUI UMA INSTÂNCIA DA CLASSE…
-
0
votes1
answer70
viewsMysql query with column created by select in other tables
Good morning guys. Assuming a business rule where I have restaurants, and each user can follow several restaurants, I create a table, table and tabela_restaurante_usuario_seguindo. Hence, when a…
-
0
votes0
answers62
viewsinsert multiple data into mysql with while
Good night, you guys! created this code in order to insert 5 new users and passwords that follow a pattern PAM1 ... PAM5 and CP@M20161 ... CP@M20165, CREATE PROCEDURE myfunction() BEGIN DECLARE i…
mysqlasked 8 years, 1 month ago Rafael Correa 1 -
0
votes2
answers630
viewsIP Blocked remote access mysql linux debian
I’m making the following mistake: [exec] mysqladmin: connect to server at '179.111.225.163' failed [exec] error: 'Access denied for user 'rqtecnologia'@'177.21.38.34' (using password: YES)' I’ve…
-
0
votes1
answer711
viewsHow to SELECT to pick up data in different tables and with different id’s
Has 3 tables On the table entrada has the data: id_entrada, id_empresa, id_categoria and id_subcategory. On the table cat_entradas have: id_categoria and categoria. And on the table sub_cate_entrada…
-
0
votes0
answers50
viewsProblems with scope in php, can anyone help me please?
I have some classes, I will post them to you can then explain my problem which is quite simple. class connection to the database <?php /* * Gerencia conexões com bancos de dados, * usando…
-
0
votes2
answers319
viewsCheck with IF and INNER JOIN
Guys I have these queries in the database <?php $consulta = mysql_query("SELECT * FROM mesas LIMIT 50"); if (mysql_num_rows($consulta)==true) { while($lnmesas = mysql_fetch_array($consulta)){…
-
0
votes1
answer779
viewsDisplaying The Same Record Twice
This is my code that makes a list of tables <?php $consulta = mysql_query("SELECT * FROM mesas INNER JOIN pedidos WHERE pedidos.mesa = mesas.id and conta = 0"); if…
-
0
votes1
answer108
viewsErrors when inserting images in mysql
Hello, I’d like to insert images into the database for a personal project. The image is sent to the bank yes, but not without showing 3 errors, follow the code and errors : <?php $servidor =…
-
0
votes1
answer126
viewsError in Change - Java and Mysql method
Java masters, I’m working on a college project, using MVC layers, and I’m having trouble with the alterarClient method. When I click the Change button on the form, it sends a message saying that the…
-
0
votes3
answers977
viewsEmail exiting with strange characters in PHP
Guys, I use a PHP + Mysql system, but every email that searches the e-mail data in the database as a subject, etc..., in the words where there are accents, everything goes wrong, an example: it’s…
-
0
votes1
answer97
viewsJASS implementation in JSF + Tomcat
I want to create an authentication for login in my project, but when I try to log in, the error java.lang.Nullpointerexception appears Error log javax.faces.el.EvaluationException:…
-
0
votes0
answers32
viewsTIME field formatting
I have the following given in the bank 55:42:55 and I need to make it more readable this way 2d7h42m how could I do this formatting?
-
0
votes1
answer42
viewsSyntax of Mysql
I can’t see the error: UPDATE clientes SET txtEndereco=\"Rua Xingú, 823\", txtBairro=\"Val ParaÃso\", txtCEP=\"09060-050\", txtUF=\"35\", txtCidade=\"14933\", regiaos=\"\", Obs=\"Princesa fada\")…