Questions tagged as 'mysql'

Tagged questions
0
answers

Filter to display result in Excel report with MySQL database and PHP

I'm not able to create a filter using this query filtering a search in MySQL with PHP . I started editing it, but the problem is that I can not generate this method using a variable that is present on the screen. For example, I did the...
asked by 05.12.2017 / 23:01
2
answers

UPDATE on all records, changing autoincrement number

I have about 500 records in the database, with autoincrement on a table starting at 900,901,902 onwards, would I have to do an UPDATE on all records starting autoincrement at number 502? Then all records have ID autoincrement 502,503,504, the...
asked by 22.11.2017 / 21:49
0
answers

Insert happening several times in the database

I have a code that inserts into the database, but the database is inserting multiple records at once Follow the code below: if($_GET["act"] == ("cad_master")) { $startaction = 20; } $pega_id_viagem_unique = $_GET['id_trip_unique']; $id...
asked by 22.11.2017 / 16:56
1
answer

LARAVEL - Loss after running the MIGRATE command

On Monday I inserted a new migrate into a project where a new table was created. After running the commands in the local environment and everything works, I upgraded the git from the production server and circled PHP ARTISAN MIGRATE as usual....
asked by 06.12.2017 / 17:39
0
answers

PHP MySQL Injections

Good evening, everyone. In the context of exploiting the vulnerabilities of my code I decided to test a MySQL injection, first to escape the strings and right now without escaping them ... They do not seem to be working! Here's my query :...
asked by 07.12.2017 / 00:18
1
answer

Android Application and MySQL Database

I have an application developed in Android and I need to connect to a MySQL database that is local to a Desktop. I can easily get the IP address of the machine where the bank is. How can I make the connection between the application and the loca...
asked by 06.12.2017 / 19:44
0
answers

Synchronize MySQL and SQL SERVER through PHP script

I need to synchronize SQL Server (Master) with MySQL (Slave). I have already found some ways to do this on the internet, such as the native SQL Server feature "Linked Server" or that APP for windows DBSync. But I wanted to know if you can do...
asked by 24.11.2017 / 20:17
0
answers

How do I change only one field

When I change a data in a table, it changes all other fields: code:<?phpif($_SERVER['REQUEST_METHOD']=='POST'){$nome_produto=isset($_POST['nome_produto'])?$_POST['nome_produto']:'';$quantidade=isset($_POST['quantidade'])?$_POST['quantidad...
asked by 20.11.2017 / 19:17
0
answers

Error with DB mysql

I have a bug in my bd that I can not fix I already used the CHECK TABLE command with the EXTENDED function and it says that it has no errors in the tables. The problem is as follows: I have made some changes to my system in php / mysql and...
asked by 29.11.2017 / 14:48
0
answers

FPDF with php last blank page

I have a problem with my code, it is generating the last blank page. Follow the creation of this code with the help of the community: FPDF with MySQL and PHP - Bringing Repeated Data I have already changed the variables, but without succ...
asked by 20.11.2017 / 01:03