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
votes4
answers120
viewsError using variables in a query
Good morning, I am new in PHP and am trying to make a form that puts the data in a mysql bd. HTML Code (Bootstrap): <div class="form-group"> <label for="nome" class="col-md-1…
-
0
votes1
answer142
viewsHow to use a user’s information in the mysql database on a label? iOS
I’m developing an iOS app that connects to the mysql database and logs in the user using the email and password information, this part is working well. Now I’m wanting to take other information from…
-
0
votes1
answer181
viewsHow to load data from a specific mysql user in Xcode?
My code is working, I’m getting the data I need, but I have to write the email of the user who wants the data in my php file. I wanted to receive user data that email is typed into a textField in my…
-
0
votes2
answers649
viewsPHP and Mysql: Database does not update
Good afternoon everyone, I’m making a screen for editing personal information. My code to capture the typed data is this: <?php require("../config/functions.php");…
-
0
votes0
answers54
viewsMysql conect error
I am trying to connect mysql but is giving error while connecting. Follow the error log: 22:40:11 [mysql] Error: MySQL shutdown unexpectedly. 22:40:11 [mysql] This may be due to a blocked port,…
mysqlasked 8 years, 10 months ago Renan Rodrigues 3,709 -
0
votes2
answers655
viewsMysql reserved keywords
When I enter php my admin it displays the following message The column name 'default' is a Mysql reserved keyword. referring to a field called default of my table my question is: this can bring some…
-
0
votes1
answer94
viewsUtf-8 Server Issues with Mysql
Good afternoon, I have an accents problem with my application running Ubuntu server 14.04 VPS American. All the application running on my development machine are registering normally at the base…
-
0
votes1
answer49
viewsMysql table alias or clone
I have a table on MySQL that is with a wrong name, this table is already used by many applications, so it would not be very simple to rename it. Is there any way to create a alias for that table or…
-
0
votes0
answers548
viewsPopulating Cities/Neighborhoods in jQuery with fields in Array
I have the following JS. <script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.js"></script> <script type="text/javascript"> $(document).ready(function(){…
-
0
votes3
answers50
viewsApache2 error on linux
Guys installed everything right on Linux, I played my folder in the directory www when I opened in the broswer I received the following warning: Access denied for user 'root@localhost' (using…
-
0
votes0
answers34
viewsInsert and update method does not work on Azure
Good afternoon Friends I’m starting in Asp net development and I made a web form application and put in Azure. It is a simple card registration application that accesses a mysql database created by…
-
0
votes2
answers1649
viewsHow to pull database information into a php code
Hello, I have a code in PHP, and inside it I would like to pull information. @$host = "23.98.102.87"; @$port = "9498"; Where has the number s is where I wanted to pull the data, I’ve already made…
-
0
votes1
answer134
viewsHow to set a jcombobox in a Preparedstatement?
How do I make a jcombobox in this method? The Combobox would be the type the user is supposed to choose, I tried to make one but it didn’t work out very well. And this method is in my main class and…
-
0
votes3
answers472
viewsIgnore certain values in Mysql
$query = "SELECT COUNT(status) FROM $nomeTabela WHERE status=$numeroStatus AND nomePessoa='$nomePessoa'"; Can you optimize this? There is status of 0 to 10 (in this query I need to query only in the…
-
0
votes1
answer861
viewsExport Mysql database data to Excel
I am running a post that send a string with all titles and fields of a database, but it only exports when I send up to 4 months. I wish I could send up to 1 year, how could I improve the code below…
-
0
votes0
answers70
viewsSelect Count(*) from these to run several consecutive PHP MYSQL queries
I have a routine that starts with a SELECT, and from this I trigger an email for each record found. The problem is that if I have more than 3,000 records, my program is bursting memory and the…
-
0
votes2
answers1040
viewsError connecting to Mysql database in Java
Connection code: package br.bent.jdbc; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; public class Conexao { private static Conexao conexao; public static…
-
0
votes1
answer175
viewsProblem with PHP and Mysql
I’m doing a chat (chat) using PHP and Mysql, and I’m having problems. I think it has to do with the fact that php 5.5 not accept more mysql, (now you need to use mysqli) Well, I have two files:…
-
0
votes0
answers55
viewsinsert date sequence into the bank
When you enter the date in for it sums + 1 day and inserts again. any idea ? $valores = range(1,5); $date = '2016-02-06'; for ( $i = 0, $total = count($valores); $i < $total; $i++){ $sql =…
-
0
votes1
answer137
viewsSyntax error in Mysql database
I am trying to create a Procedure in Mysql and is returning Syntax error. Follow my code for analysis: DELIMITER $$ CREATE PROCEDURE CalculaIdadeCP (IN cpcaminhaoid INT) BEGIN DECLARE…
-
0
votes2
answers1081
viewsError in mysqli: "expects Exactly 2 Parameters, 1 Given"
You’re making that mistake: Warning: mysqli_select_db() expects Exactly 2 Parameters, 1 Given in My code is this: define("HOST", "localhost"); define("USER", "meu-usuario"); define("PASS",…
-
0
votes1
answer38
viewsMysql database access design
I am investigating good implementations that allow easy adaptability for connection to my db. I would like to receive feed backs and suggestions for improvements to this design. As an example: how…
-
0
votes1
answer114
viewsCommunication between database and the Python app - mini password-taking system
Hello, I am learning python and I decided to do a mini project, a simple system of chips, while I thought about the subject came me some doubts and I could not find anything about. The program would…
-
0
votes2
answers964
viewsHow to send an email after a new mysql registration
Hello, I have a table in mysql basically in this format. id transaction_id name buyer_email transaction_date paymentstatus 1 989Y8DT8S65DS Test [email protected] 17/02/2016 Completed My intention…
-
0
votes1
answer30
viewsPaypal buyer’s email returns in incorrect format
Hello, I have an Ecommerce and am implementing some changes including the express checkout of paypal, the api I am using is the one provided by paypal. The problem is that when returning the data…
-
0
votes1
answer86
viewsphp running when giving F5 maintaining database connection
I have a function in Javascript that runs a PHP code, in this PHP I open connection to the database and send data if some entries receive 1 (waiting 1 minute to change their status). When I refresh…
-
0
votes2
answers97
viewsCan I connect to a database using JS?
I am developing a website for myself and would like to know if I can use Javascript to connect to the database and get a value. NOTE:The site is local, and the bank also and are on my machine, you…
mysqlasked 8 years, 9 months ago Thiago Silva 39 -
0
votes1
answer1223
viewsMysql - Insert multiple products in one order
I have an order table in mysql, where the total order value, the date, the customer’s id, and the products that were purchased should be informed. The problem that these products are in the product…
-
0
votes1
answer69
viewsJoomla site error: 0 Invalid controller: name='', format='' joomla Administrator
I am trying to get into the administration of my Joomla 3.0 site, but I am getting the following error: 0 Invalid controller: name=', format='' Can someone give me a clue how to solve it?…
-
0
votes2
answers155
viewsStoring data in a Rails array
I need to store data coming from a database search in an array, but with the code below it only stores a value in the array. @busca= Item.find(:all,:conditions=>{:codigo=>params[:codigo]})…
-
0
votes1
answer72
viewsMysql backup with create schema
I need to do the backup from a database (DUMP) that comes with create schema. Which command line using PUTTY (via SSH) to do such a task ? I searched and found this command but it only backup tables…
-
0
votes2
answers13878
viewsPHP error: "Fatal error: Call to a Member Function prepare()"
When I try to execute the SELECT server accuses this msg: Fatal error: Call to a member function prepare() on a non-object in blog.php on line 97 the line referred to is: $readPost =…
-
0
votes1
answer104
viewsUser login site with his name on link
I have a web system in PHP and MYSQL that has user registration. Users register and access the system, being redirected to a panel: nomedosite.com/panel. What I need is that for every user who…
-
0
votes1
answer346
viewsAccent problems with PHP and Mysql
I am making a PHP form, in which I used a javascript in a combo. So when I select the first select, the second opens different data depending on what you select first. Until then ok, it works.…
-
0
votes1
answer268
viewsDeletion with MYSQL reference integrity
The world of design is as follows: I have a client, where I register for him, errands, news, upload photos, where there are schedules too. Only when I’m about to delete it, I need to delete…
mysqlasked 9 years, 4 months ago Renan Rodrigues 3,709 -
0
votes1
answer219
viewsSort by ENUM Mysql value
I have a question and since I did not find anything on the internet I decided to ask you, well, I have a Mysql table and this table contains an ENUM field that can be 'yes' or 'no', I wonder if it…
-
0
votes1
answer164
viewsCompare varchar in Procedure
I am trying to use the following Procedure and Trigger in mysql so that when inserting a record in a table the Trigger is fired for subtraction of the given value in another table, but it turns out…
mysqlasked 9 years, 4 months ago Álesson David 35 -
0
votes2
answers199
viewsCompare the results
Dear colleagues. I’m bringing two questions from the Mysql database as follows: .... Qual sua idade? <input type="text" name="Perguntas[]" value="<?php echo $jmPerguntas->Perguntas;…
-
0
votes1
answer337
viewsList two mysql Pdo tables
$catalog = $dbh->prepare("SELECT * FROM catalogo WHERE ativo = 2 ORDER BY catalogo_view DESC LIMIT 0,5"); $catalog->execute(); I want to search between two tables, as I do?…
-
0
votes1
answer4157
viewsChange color of a <td></td> of the html table according to php condition
In a table generated from database data, you would need to change a to certain colors of a <td></td> if the field value ipaymentstatus in the database is as: completed, pending,…
-
0
votes1
answer137
viewsGoogle Chart pass ID of a bank column
I would like to know how to pass a value transparently to the graph, I have to get the ID of a column in the bank. The way I’m doing I need to pass this way: Column Title | ID <- This data comes…
-
0
votes0
answers67
viewsDoubt virtual printer
Good afternoon, I will create a password issuing system for the php support queue. Passwords will be printed on a non-Bematech tax printer. Bematech has a virtual fiscal ecf, does anyone know of any…
-
0
votes1
answer778
viewsConvert a variable to STRING in the mysql query in PHP
In the query below inside my PHP the variable $line[0] is not validating as string, but if I do var_dump($line[0]); before arriving at this query, it shows that it is a string! $result =…
-
0
votes2
answers60
viewsDoubt Data with PHP and JS
Hi I don’t know anything about JS and I wonder if I can edit a field whose value came from the database using javascript? Because I saved in the bank the date of birth and the phone of a…
-
0
votes0
answers163
viewsSmall problem with pure PHP paging
Hello, I have the following function that does the paging as per what the user typed in the search input: function pesquisar($botao, $input, $conteudo) { if(isset($_POST[$botao]) || $_GET['pagina'])…
-
0
votes1
answer1992
viewsShow profit or loss in negative percentage
Considering the following data: $despesas = 2000; $receitas = 100; $lucroprejuizo = ($receitas - $despesas) / $receitas)*100; I have a result of: -1900% But if any of the variable revenues or…
-
0
votes0
answers829
viewsDo not display null lines in mysql results
I have a simple mysql query SELECT usr_contact FROM $usr_ I use PDO to connect this table has lines that have empty fields thus ----------------------- | id |usr_contact| ----------------------- |…
-
0
votes1
answer56
viewsConvention for attributes that preserve types
A table stores data from teachers. Each teacher has a degree: specialist, master, doctor, post-doctor and others. Another table present in the base is the publications. Each publication may (or may…
-
0
votes1
answer211
viewsInsert file set into 2 different tables
I have a situation I can’t handle, and I’d like your help. I have a file type input in my form where the user selects several images at once to upload. I would like to insert 1 of these images in…
-
0
votes1
answer117
viewsrecover Datetime in Mysql between current date
In my database I have 2 fields: "data_start and data_end". From a current Datetime, I need to select all dates that are in the range that date_time >= data_start AND date_time <= data_end. I…