Questions tagged as 'mysql'

Tagged questions
0
answers

MySQL: Insert with conditional

I need to do the following situation, but when I run I get the error: / * SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use 'INTO producto_seria...
asked by 17.10.2015 / 20:46
1
answer

Query mysql according to Array unserialize

In this select down how can I make it just return the rows with ids that are in this variable ($ range) this variable is returning data from the various database ids // estou utlizando a função unserialize $range = unserialize ($linha["range_i...
asked by 19.10.2015 / 03:28
0
answers

Limits to update with BufferedReader in mysql

Hello everyone, good morning, I'm having problems with an update routine in the mysql database, I'm reading a BufferedReader containing more than 3,000,000 records and doing the update in mysql, but when I'm near the first 1,200 records the syst...
asked by 11.09.2015 / 14:01
2
answers

Use ID generated from one FORM on another and do UPDATE on bd

IsavedthisimageinthedatabaseandgeneratedtheID:20.Formtowrite:INICIAL.PHP(Codetorecordimage)<html><head><title></title></head><body><formenctype="multipart/form-data" method="post"> <input typ...
asked by 01.10.2015 / 04:51
1
answer

Doubt on mySQL - Write, Update and Show Data

Talk the guys! I have a doubt. I've created a static page that will show some data. For example, I want to show the live score of a specific football game. I thought about creating a static page with: "Championship Name" "Team A Nam...
asked by 28.09.2015 / 16:28
0
answers

Save image along with form to the database by PHP

Good afternoon people, please help me, I found a tutorial on the internet that teaches to save the image in the database with php and jquery, but it teaches to send only the image already tried in every possible way so I can put with form with n...
asked by 03.10.2015 / 18:33
0
answers

How to do image UPDATE mysql php [closed]

I have this code and need to update the image that is already saved in the database, but it does not work. Codes <?php require 'conexao.php'; //Pega o id da url if ( isset( $_GET['id'] ) && ! empty( $_GET['id'] ) ) {...
asked by 05.10.2015 / 05:27
0
answers

Recover database in Mysql

I had a server with multiple databases, but an error occurred and the server had to be formatted and I was able to recover the data through the backup that is done daily by the company. I was able to recover the entire Mysql fol...
asked by 04.09.2015 / 13:22
1
answer

PHP-MySQL-Dialog

I'm doing a page, where I have a mySQL database connecting to PHP. What I wanted is the following, I have a form with: pais(combo); nome(text);empresa(text) , and I want it: When you fail to complete any of the fields, please let m...
asked by 03.09.2015 / 14:37
0
answers

How to do PHP and MYSQL credentials

I'm developing an event system that will consist of a web system and a mobile application. One of the main points will be the accreditation (check-in and check-out) of the users in the lectures. After registering on the website and registering f...
asked by 21.08.2015 / 15:08