Questions tagged as 'mysql'

Tagged questions
1
answer

Upload image / file with PHP and store in BLOB in MySql

Good morning! I'm trying to upload a loaded image via an input "type = file", convert the image to a BLOB and store it in my BD MySql. However, I'm having difficulty receiving the image that was sent by $ POST. Here is my view structure...
asked by 03.08.2018 / 15:17
2
answers

Error in data received in PHP

This error appeared after the hosting migration. Warning: number_format() expects parameter 1 to be float, string given in /home/bramo472/public_html/evolucamp.com.br/doutor/_app/Helpers/Orcamento.class.php on line 105 Warning: number_format(...
asked by 02.08.2018 / 14:43
1
answer

Problem using parameter in a PreparedStatement

I would like to know if there is any problem in using the "parameter" variable after the "AND", because when I tested putting the column name directly in SQL worked and when I try to pass the column name with the parameter does not return anythi...
asked by 02.08.2018 / 06:03
2
answers

How to solve the error Call to undefined function mysql_connect () [duplicate]

I'm doing an IT inventory to register and I want to connect to the database, but it's giving this error:    Fatal error: Uncaught Error: Call to undefined function   mysql_connect () in C: \ xampp \ htdocs \ xampp \ cadastrando.php: 9 Stack...
asked by 22.12.2016 / 15:20
1
answer

Recover data in the database by checkbox

Good afternoon I'm having difficulty retrieving the data in the database via checkbox. <div class="container"> <div class="row"> <form action="resultado.php" multiple method="post"> <h3>Bairro...
asked by 09.08.2018 / 17:26
0
answers

MySQL and PHP SQL_CAL_FOUND_ROWS and FOUND_ROWS ()

I'm trying to create a data display list that returns me the TOTAL of records so I can run the paging. To avoid doing 2 queries in a database with more than 5,000 records for the criteria I saw on the internet these 2 MySQL commands SQL_CAL_FOUN...
asked by 09.08.2018 / 15:30
0
answers

persistent connection mysqlDb python

Because of having to be opening and closing database connection memory consumption goes up? I would like to know if I use an open connection at all times, I will have the advantage of decreasing memory consumption. import MySQLdb dblocal = My...
asked by 01.08.2018 / 06:07
4
answers

Login condition with user or email in the same field

I am creating a system for schools, where the teacher, when registering, inserts data such as name, email, user and password. So far the teacher can log in with email, but I wish I could login with the name too (I made changes but this is giving...
asked by 09.05.2018 / 15:45
5
answers

MySQL Limit Equivalent in SQL Server

Does anyone know how to relate the differences between MySQL and SQL Server, including using LIMIT n,n ? Or if they have a link that lists the differences would be cool. Example SELECT * FROM tabela LIMIT 50, 100 What would be the...
asked by 26.03.2014 / 17:01
0
answers

Performance difference of an application with identical scenarios

This weekend we deployed an application based on the Magento framework, which was extensively tested in a number of scenarios, with a high user load making multiple database requests, such as queries, updates and insertions, the entire course of...
asked by 30.07.2018 / 13:15