Questions tagged as 'php'

Tagged questions
1
answer

The server requested authentication method unknown to the client [caching_sha2_password]

I have installed MySQL 8 and Laravel 5.6.18; when I try to execute the migrations with: php artisan migrate An example of my migrations is: Schema::create('categories', function (Blueprint $table) { $table->increments(...
asked by 15.05.2018 / 16:06
1
answer

json php query with duplicate results

The result of my php query is shown as follows: the data is repeated in each query. <?php header('Content-type: text/html; charset=UTF-8'); include('functions.php'); $sql = "SELECT * FRO...
asked by 25.09.2018 / 18:54
1
answer

Run php in the background

- I hope my explanation is clear - I have a PHP script that takes a long time to execute, so I decided to run it in the background, what happens is that even in the file that I run the second script, wait until finish this execution to answer. I...
asked by 27.09.2018 / 00:47
1
answer

Error saving json data in MySQL

I'm trying to store this data JSON : { "ticker": { "base": "ETH", "target": "USD", "price": "689.18009232", "volume": "234831.85174911", "change": "1.48138601" }, "timestamp": 1525308422,...
asked by 03.05.2018 / 17:18
1
answer

Store query in array

Very good to everyone. I need to solve something that I can not give with it. I have a mysql query where I extract the income totals for each month of the year 2018. $sql_g=mysqli_query($con, "SELECT MONTH(fecha_factura) AS mes, SUM(total_vent...
asked by 05.05.2018 / 18:58
2
answers

Two results same column

I have a company table with the id and name columns. And another table operations with the columns send_id , recib_id . I want to get the results name of send_id and receive_id . And how do I get the two different results in php?...
asked by 16.03.2018 / 15:21
1
answer

Join in laravel

I have my in my controller: $habitaciones = DB::table('habitaciones') ->join('tipo_habitaciones', 'habitaciones.id_tipo', '=', 'tipo_habitaciones.id') ->select('habitaciones.*', 'habitaciones.id', 'habitaciones.hab_numero...
asked by 01.03.2018 / 23:52
1
answer

Problem when verifying that my user is in the ORACLE database

Is there any kind of conflict with rowCount? The sentence I understand is fine, and I'm using PDO, which also did not give me problems before. The field in the database is VARCHAR2. I attach my code: $user = 'pepito' $con = conne...
asked by 13.02.2018 / 14:41
2
answers

Array to PHP table

I have the following array: Array ( [0] => Ficha 001 [nombre] => Ficha 001 [1] => Supermercados [matriz_nombre] => Supermercados [2] => 1000 cc [columna_nombre] => 1000 cc [3] => Heineken [fila_nombre] => Heineken [4] =...
asked by 22.10.2018 / 14:17
2
answers

Error uploading file using type="file"

I have a big problem that is quite strange, I have a input type="file" on my website, in which users can upload a photo of a document. What happens to me is that sometimes from a mobile, when using the input to upload a photo from...
asked by 19.01.2018 / 16:29