Questions tagged as 'mysql'

Tagged questions
9
answers

How to prevent SQL injection in my PHP code?

I developed a page in PHP for internal use of the company I work with and only very few people use it. You can use this page to do some queries, insertions, changes and deletions of a table in a MySQL database, however I believe that my PHP code...
asked by 03.02.2014 / 13:37
0
answers

Problem with CRUD in Java using Mysql

In my DAO class, I have the method to insert into the database, however on my system screen I can only update the fields if I make a change in all fields. Example: my table has 4 fields and I only change 1, the update does not work by my butt...
asked by 20.10.2018 / 23:02
0
answers

Help Returning Errors - Warning: Illegal string offset 'id'

define("HOST","localhost"); define("DB_USER","root"); define("DB_PASS",""); define("DB_NAME","cc_cond"); $conn = mysqli_connect(HOST,DB_USER,DB_PASS,DB_NAME); ini_set('display_errors', 1); if(!$conn) { die(mysqli_error()); } function list...
asked by 21.10.2018 / 03:38
1
answer

LARAVEL - Error connecting MYSQL with LARADOCK in Workspace

When I try to run the command in the laradock workspace php artisan migrate the following error occurs: Illuminate\Database\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQ...
asked by 15.09.2018 / 06:15
0
answers

Import csv to two tables MYSQL - Codeigniter

Hello, with the simple function below, I am able to import data into a mysql table. The issue is that the telefone column will be in another tabela and the way it is today, I can only import to the same tabela ....
asked by 21.10.2018 / 01:04
0
answers

Passing a string created in Windows forms to Crystal Report

I needed to add a string created in the Windows Forms Application in the Parameter Fields, shown in the first image below, inside the Crystal Report to later make a filter, as in the second image below. I'd like to know what I have to do or co...
asked by 13.09.2018 / 02:53
1
answer

How to use Jenkins to see which files were modified in the commit?

I'm working with PHP and Mysql on Windows, my repository is in GitLab. I want to use Jenkins to run a job or pipeline when performing a push to the repository. The job should check the changed files in the commit and if there are any changes...
asked by 12.09.2018 / 23:10
1
answer

How to run the same SQL Script (MySQL) on all the banks of my Server?

I have several Wordpress sites hosted inside the same server (I am an Agency) and I created a Script that creates users in the Bank of Wordpress so that each employee of the company can access each site with its individual login, since we curren...
asked by 13.09.2018 / 13:42
0
answers

How to display the result of a mysql search where it returns more than 10mil result without crashing the browser?

I'm currently using the jquery table to display the results, but it takes a long time to display all the results and while the search does not finish the browser sometimes crashes. have some better way of showing results but without crashing you...
asked by 13.09.2018 / 15:27
0
answers

How to get modal bootstrap data and send to PHP

I need to get Modal form data via Ajax My code: var url = 'fotovisita.php'; var data = $('#foto').serialize(); var type = "POST"; $(document).on('click', '#save-foto', function () { $.ajax({ url: url, method: 'POST',...
asked by 06.09.2018 / 17:18