Questions tagged as 'mysql'

Tagged questions
0
answers

Multiple upload of files in PHP

I'm a beginner in PHP and I'm developing a system for real estate. The annoying thing that occurred to me was this: I need to upload 20 photos of a property using only 1 input and save the file name in the bank. I can upload the files and resize...
asked by 10.04.2016 / 03:24
0
answers

How to enter data of a form in the bank

Hello I created the code below and when I execute it inserts a record in the database, but does not enter the data entered in the form. Can anyone help me? the screen displays the message: Invalid Query: You have an error in your SQL synta...
asked by 19.03.2016 / 02:16
1
answer

Insert into does not return [closed]

I have the following table: QuerywithInsert    publicfunctionCadastrarArquivos($pdo,$arq_nome,$a_areaid,$u_userid){$ins=$pdo->prepare("INSERT INTO arq_arquivos(arq_nome, a_area_a_areaid, u_usuarios_u_useid) VALUES(:arq_nome, :a_areaid, :u_us...
asked by 19.03.2016 / 18:28
0
answers

Crystal Reports CSV Export Filtering by Date (C # MySQL)

I have a Crystal Report object that is bringing the records of a View from a MySQL database. I need these records to be exported to a CSV file and I got this with the following code: private void btnExportarCSV_Click(object sender, EventArgs e...
asked by 28.03.2016 / 00:17
1
answer

SQL to count the characters of a field if it is less than 10 [closed]

I'm having a hard time. I have the following SQL: $contardescricao = "0"; $sqlxmldescricao = "select id from imoveis where cod = '$cliente' AND (character_length(descricao)<'10')"; $rsqlxmldescricao = mysql_qu...
asked by 08.03.2016 / 15:15
2
answers

Page does not receive and does not register the data in Mysql

I'm building an application in php for user registration, but for some reason when I enter the data and click on register, it reloads the page gives no error, and does not load anything in the database. <?php $page_title = 'Registra...
asked by 08.03.2016 / 02:04
1
answer

How to create menu tree (multilevel) with PHP + MySQL?

I'm trying to make a tree menu with PHP + MySQL , however something is wrong in the code. And, the same table was used in ASP with SQLServer to make a menu: First I load in a array , my database: $menu[] = A...
asked by 29.02.2016 / 21:07
0
answers

Select days within date for work shift assembly [closed]

I need a function that inserts selected dates into Datapicker var date = new Date(); $('#pre-select-dates').multiDatesPicker({ addDates: [date.setDate(14), date.setDate(19)] });     
asked by 05.02.2016 / 12:36
0
answers

MySQL - Table is full

When I try to upload a file to a table from my mysql database the system returns the error Table is Full. However, I have other tables that are larger and heavier than this table that do not have this error. The error table has approximately 300...
asked by 03.02.2016 / 18:01
1
answer

Execute an UPDATE in MySQL only when the number of rows equals 1

How to make a UPDATE only run when the number of rows that returned is equal to 1 in a single query only with SQL syntax using the example below? Example: SELECT count(*) AS rows FROM exemplo WHERE id_usuario = 100; if (rows == 1) {...
asked by 03.02.2016 / 17:17