scorpions's questions

I am trying to get the name of the month by passing the number of the month as a parameter to my function. I want it to appear in Spanish and I don't want to use the deprecated strftime function, I want to update my code to php 8 functions. I have been doing a lot of research and I have found the following:

$formatter = new \IntlDateFormatter(
                'es_ES',
                \IntlDateFormatter::LONG,
                \IntlDateFormatter::LONG,
                'Europe/Madrid'
            );
            
            return $formatter->format($mes);

but I don't know how I can pass the name of the month to IntlDateFormatter so that only September appears, for example.

I hope you can guide me a bit. I use native php, nothing from composer or external libraries

Thank you and regards

I am trying to make in my jquery a link with html to a laravel route for this I am creating a variable:

var url = config.url.base_url + "event/" + eventUrl;

config.url.base_url is a variable that is in the Laravel configuration file, which returns the URL where I am, I concatenate event and the url of the event that comes from the DB.

I have created my route in web.php

/** SHOW EVENT INFO */
Route::post('event/{url}', 'Web\EventController@showEvent');

and now if in the href, I concatenate the url variable:

'<a target="_blank" id="button-event-read" href="'+url+'" class="btn color2-bg float-btn">Leer más.<i class="fal fa-angle-right"></i></a>';

when hovering over the button the URL appears perfect, but when trying to go to it, it always returns a 404 error... In the controller, I just have an echo for now:

public function showEvent($url){
        echo "llego";
    }

what am I doing wrong?? Thanks for the help in advance

I am trying to create a post counter by category. That is, category x has so many posts.

For this I am trying to use Eloquent. Almost all the posts belong to one category and there is a post that belongs to another... I attach a screenshot

I have this function that is the one that should count and group by categories. It is in the Modeloof blogand blogis related to blog_categorybyblog_category_id

/**
    * @return \Illuminate\Database\Eloquent\Collection
    */
    public function getPostCounterAttribute()
    {
        return $this->blogCategory()->orderBy('blog_category')->count();
    }

In the view I have this to get the data of the categories and the posts that each one contains:

@foreach($categories as $category)
     <li><a href="{{ url('blogs/'.$category->name) }}">{{ trans('web.blog_category_'.$category->name) }}</a><span>{{$category->postCounter}}</span></li>
@endforeach

but it always shows me 1 in all categories and it is not like that. I know I'm not doing it right.

How could I solve this??

Thank you and regards

update

I have made my query in phpmyadmin and this is the result:

SELECT blog_category.name, count(blogs.id) 
 FROM blogs 
INNER join blog_category 
 on blogs.blog_category_id = blog_category.id 
 GROUP by (blog_category.name)

In my blog model, as the answers below have said I try that:

public function getPostCounterAttribute()
{
    //return $this->blogCategory()->orderBy('blog_category')->count();
    
    return Blog::withCount('blog_category')->get();
}

result:

The totals do not appear in the view, no property associated with the counter is known

update 2

result of $categoryfor a foreach category

{"id":10,"name":"recipes","created_at":"2021-02-18 13:07:25","updated_at":"2021-02-25 10:37:38","custom_fields":[],"has_media":false,"media":[]}

$category->postCounter -> no muestra nada

content of$categories

[{"id":10,"name":"recipes","created_at":"2021-02-18 13:07:25","updated_at":"2021-02-25 10:37:38","custom_fields":[],"has_media":false,"media":[]},

update 3

my relationship within BLOG

public function blogCategory()
    {
        return $this->belongsTo(\App\Models\BlogCategory::class, 'blog_category_id', 'id');
    }

update 4

in controller

$postCategories = BlogCategory::withCount('blogs')->get();
        
        return view('web.blog')
            ->with('data', $data)
            ->with('posts', $posts)
            ->with('categories', $categories)
            ->with('popular', $this->popularPostToday())
            ->with('postCategories', $postCategories[0]);

I am trying in my laravel 5.8 to make all my routes end with / and also to remove the www. from the beginning of the URL. those of the www I think I have achieved it this way:

# drop www in url
     RewriteCond %{HTTP_HOST} ^www\.(.*)$ [NC]
     RewriteRule ^(.*)$ http://%1/$1 [R=301,L]

But I can't get it to put the /at the end of my url. From what I have read, Laravel by default removes it because it understands that it is a directory. But I would like to force it to be put, for SEO

I'm trying to put it this way:

RewriteRule ^(.*)/$ $1 [L,R=301]

But without success.

Update

<IfModule mod_rewrite.c>
    <IfModule mod_negotiation.c>
        Options -MultiViews
    </IfModule>

    RewriteEngine On

    # drop www in url
    # www.guiapaladar.com
    # RewriteEngine on
    # RewriteCond %{HTTP_HOST} ^www.guiapaladar.com [NC] 
    # RewriteRule ^(.*)$ https://guiapaladar.com/$1 [L,R=301]

    # Force Trailing Slash
    # RewriteBase /
    # RewriteRule ^(.*)/$ /$1 [L,R=301]

    # Redirect Trailing Slashes If Not A Folder...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)/$ /$1 [L,R=301]

    # Handle Front Controller...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^ index.php [L]
</IfModule>

Thanks in advance and greetings

After giving a thousand turns to my problem, to my E/R that I had supposedly badly assembled. It hasn't, I just needed to create a proper query, but I run into the following problem:

I have this query:

 Select * 
FROM contratan c
RIGHT join asistencia a
ON a.usuario = c.usuario
RIGHT JOIN actuacion ac
ON a.codAsistencia = ac.asistencia
WHERE c.usuario = 17
AND c.codContrato in (select MAX(codContrato) from contratan where usuario = 17)
order by c.usuario

This query makes me a history of all the data referenced to that user. but I also need to calculate the remaining minutes that user has left on their voucher. I would do it with this other query:

Select sum(minutos) FROM bonos, contratan where contratan.bono = bonos.codBono and contratan.usuario = 17

but I also need to check the minutes that have been used in each attendance, I do it with this other query.

Select sum(tiempoEmpleado) FROM actuacion, asistencia where actuacion.asistencia = asistencia.codAsistencia and asistencia.usuario = 17

The question is, how could I add these other two in the first query??. What is this for? It is to make a complete history of the user, what he buys, the minutes he has left, how he has spent those minutes and the assistance he has requested.

I've tried with subqueries in the select, but I can't... I appreciate any help. Attached the structure of my database:

users table:

    CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nif` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `perfil` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'usuario',
  `telefono` int(11) DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `users`
--

INSERT INTO `users` (`id`, `nif`, `nombre`, `email`, `email_verified_at`, `password`, `direccion`, `perfil`, `telefono`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, '45921676z', 'David Serrano Alonso', '[email protected]', NULL, '$2y$10$nZcz5O3MaE/F/ML0QSC7M.1/fe.6QYdd11Faa1Wnsh.E4TiZR3xcW', NULL, 'usuario', 652138927, NULL, '2020-11-20 09:19:46', '2020-11-20 09:19:46'),
(2, '45921676z', 'Admin', '[email protected]', '2020-11-20 10:29:35', '$2y$10$wxOoOy1hlc8JYnozGKy.ReNwT3Q24akiltSyfrGYJ39wjud72lH7a', NULL, 'tecnico', NULL, NULL, NULL, NULL);

contract table

--
-- Base de datos: `bonosat`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `contratan`
--

CREATE TABLE `contratan` (
  `codContrato` int(10) UNSIGNED NOT NULL,
  `fecha` datetime NOT NULL,
  `bono` int(10) UNSIGNED NOT NULL,
  `tiempoRestanteBono` int(10) UNSIGNED NOT NULL,
  `bonoSolicitado` int(10) UNSIGNED NOT NULL,
  `tiempoSolicitado` int(10) UNSIGNED NOT NULL,
  `activo` tinyint(4) NOT NULL DEFAULT 0,
  `usuario` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `contratan`
--

INSERT INTO `contratan` (`codContrato`, `fecha`, `bono`, `tiempoRestanteBono`, `bonoSolicitado`, `tiempoSolicitado`, `activo`, `usuario`) VALUES
(11, '2020-11-23 11:38:20', 6, 10, 1, 30, 0, 1);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `contratan`
--
ALTER TABLE `contratan`
  ADD PRIMARY KEY (`codContrato`),
  ADD KEY `contratan_usuario_foreign` (`usuario`),
  ADD KEY `contratan_bono_foreign` (`bono`),
  ADD KEY `contratanBonoSoli_bono` (`bonoSolicitado`);

bonuses

    CREATE TABLE `bonos` (
  `codBono` int(10) UNSIGNED NOT NULL,
  `tipo` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minutos` int(10) UNSIGNED NOT NULL,
  `precio` double(5,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `bonos`
--

INSERT INTO `bonos` (`codBono`, `tipo`, `minutos`, `precio`, `created_at`, `updated_at`) VALUES
(1, '1/2H', 30, 20.00, NULL, NULL),
(2, '1H', 60, 40.00, NULL, NULL),
(3, '5H', 300, 175.00, NULL, NULL),
(4, '10H', 600, 330.00, NULL, NULL),
(5, '24H', 1200, 600.00, NULL, NULL),
(6, '10Min', 10, 9.00, NULL, NULL);

attendance

CREATE TABLE `asistencia` (
  `codAsistencia` int(10) UNSIGNED NOT NULL,
  `fecha` datetime NOT NULL,
  `mensaje` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `usuario` bigint(20) UNSIGNED NOT NULL,
  `estado` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendiente',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `asistencia`
--

INSERT INTO `asistencia` (`codAsistencia`, `fecha`, `mensaje`, `usuario`, `estado`, `created_at`, `updated_at`) VALUES
(2, '2020-11-23 11:25:29', 'Prueba Histórico', 1, 'pendiente', NULL, NULL),
(3, '2020-11-23 12:32:03', 'prueba', 1, 'pendiente', NULL, NULL);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `asistencia`
--
ALTER TABLE `asistencia`
  ADD PRIMARY KEY (`codAsistencia`),
  ADD KEY `asistencia_usuario_foreign` (`usuario`);

When executing my first query

If I add the other two queries:

Select (Select sum(minutos)FROM bonos, contratan where contratan.bono = bonos.codBono and contratan.usuario = 17), (Select sum(tiempoEmpleado) FROM actuacion, asistencia where actuacion.asistencia = asistencia.codAsistencia and asistencia.usuario = 17) 
FROM contratan c 
RIGHT join asistencia a ON a.usuario = c.usuario 
RIGHT JOIN actuacion ac ON a.codAsistencia = ac.asistencia 
WHERE c.usuario = 17 
AND c.codContrato in (select MAX(codContrato) from contratan where usuario = 17) order by c.usuario

The result of joining these two select is this:

As you can see, it duplicates my data, and apart from that, well, it doesn't get the other data I need, but that's adding the columns I need, what I need is to see the time spent per performance and the remaining time of the bonus after

Database execution

fiddle

I am modifying a relational database and in the E/R model, I find that I have the table users contract (relationship) bonds.

But here comes the problem, I need to know what bonus each user contracts and a bonus is applied to an action (that is, to a contract) this is where I have my problem.

Could I get a contract-to-acting relationship?? the bonus table is only used to store bonus types.

the relationship between users and bonuses is M:N but if a user hires a new bonus, I have to know what bonus he had previously, what bonus he wants now, the remaining time of the previous bonus and the actions on that previous bonus... But if the user contracts a new voucher, the remaining time is added with the time he had and the type of voucher he had is updated for the one he wants now, whether it is the same or not

I had thought of adding contract to the relationship, since a new table appears there, the attributes user, dateContractFirstBono, the bonus, TimeRemaining, if it is active, if you request a new one, then which one, the time you request to update the previous bonus and How should I know the previous bonus, another column BonoPrevious and DateBonoPrevious. All this would go in the contract relationship (That's what I had thought)

Now it would be related through applies with action (an action is applied to a contract) and it would be related to a 1:N cardinality and in action record the contract code

I'm not asking you to solve it for me, it's just knowing how I could do it better, because I need to generate a history

Thanks for the help and I hope you understand.

All the best

I am trying to create this query:

    select bonos.codBono, users.nombre, bonos.tipo, bonos.minutos, bonos.precio, 
    contratan.tiempoRestanteBono, contratan.bonoSolicitado as bonoSolicitado, 
    contratan.tiempoSolicitado
    from contratan
    INNER join users on contratan.usuario = users.id
    INNER join bonos on contratan.bono = bonos.codBono
    where activo = 0
    and (SELECT tipo from bonos, contratan where contratan.bonoSolicitado = bonos.codBono )

And I need it to show the type of bonus requested. In contratan I save the requested bonus code and I am trying to get it to show me the type of that bonus... but the code always appears. This is to update a table, so that when the user changes the voucher, the type is changed.

The output result should be something like this:

codBono nombre tipo minutos precio tiempoRestanteBono bonoSolicitado tiempoSolicitado
   6    David Serrano Alonso 10Min 10 9.00 1(aquí es donde debe aparecer el tipo) 30

It's that later, I make a dynamic table with vueJS and I can't access the bonusRequested property and for the name of the new bonus that the client requests to appear, I need that query or something similar. I don't know if I'm explaining myself correctly. I attach the structure of my DB

users table:

    CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nif` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `perfil` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'usuario',
  `telefono` int(11) DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `users`
--

INSERT INTO `users` (`id`, `nif`, `nombre`, `email`, `email_verified_at`, `password`, `direccion`, `perfil`, `telefono`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, '45921676z', 'David Serrano Alonso', '[email protected]', NULL, '$2y$10$nZcz5O3MaE/F/ML0QSC7M.1/fe.6QYdd11Faa1Wnsh.E4TiZR3xcW', NULL, 'usuario', 652138927, NULL, '2020-11-20 09:19:46', '2020-11-20 09:19:46'),
(2, '45921676z', 'Admin', '[email protected]', '2020-11-20 10:29:35', '$2y$10$wxOoOy1hlc8JYnozGKy.ReNwT3Q24akiltSyfrGYJ39wjud72lH7a', NULL, 'tecnico', NULL, NULL, NULL, NULL);

--

Bonus History Table:

    CREATE TABLE `historialbonos` (
  `codHistorial` int(10) UNSIGNED NOT NULL,
  `bono` int(10) UNSIGNED NOT NULL,
  `usuario` bigint(20) UNSIGNED NOT NULL,
  `fecha` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `historialbonos`
--

INSERT INTO `historialbonos` (`codHistorial`, `bono`, `usuario`, `fecha`) VALUES
(2, 1, 1, '2020-11-20 12:52:29'),
(3, 1, 1, '2020-11-23 10:24:58'),
(4, 6, 1, '2020-11-23 10:54:54'),
(5, 1, 1, '2020-11-23 10:55:46'),
(6, 1, 1, '2020-11-23 10:58:22'),
(7, 6, 1, '2020-11-23 11:00:11'),
(8, 6, 1, '2020-11-23 11:01:15'),
(9, 6, 1, '2020-11-23 11:16:19'),
(10, 6, 1, '2020-11-23 11:30:23'),
(11, 1, 1, '2020-11-23 11:31:28'),
(12, 6, 1, '2020-11-23 11:43:28');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `historialbonos`
--
ALTER TABLE `historialbonos`
  ADD PRIMARY KEY (`codHistorial`),
  ADD KEY `historialbonos_usuario_foreign` (`usuario`),
  ADD KEY `historialbonos_bono_foreign` (`bono`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `historialbonos`
--
ALTER TABLE `historialbonos`
  MODIFY `codHistorial` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `historialbonos`
--
ALTER TABLE `historialbonos`
  ADD CONSTRAINT `historialbonos_bono_foreign` FOREIGN KEY (`bono`) REFERENCES `bonos` (`codBono`),
  ADD CONSTRAINT `historialbonos_usuario_foreign` FOREIGN KEY (`usuario`) REFERENCES `users` (`id`);

Hire Table

--
-- Base de datos: `bonosat`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `contratan`
--

CREATE TABLE `contratan` (
  `codContrato` int(10) UNSIGNED NOT NULL,
  `fecha` datetime NOT NULL,
  `bono` int(10) UNSIGNED NOT NULL,
  `tiempoRestanteBono` int(10) UNSIGNED NOT NULL,
  `bonoSolicitado` int(10) UNSIGNED NOT NULL,
  `tiempoSolicitado` int(10) UNSIGNED NOT NULL,
  `activo` tinyint(4) NOT NULL DEFAULT 0,
  `usuario` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `contratan`
--

INSERT INTO `contratan` (`codContrato`, `fecha`, `bono`, `tiempoRestanteBono`, `bonoSolicitado`, `tiempoSolicitado`, `activo`, `usuario`) VALUES
(11, '2020-11-23 11:38:20', 6, 10, 1, 30, 0, 1);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `contratan`
--
ALTER TABLE `contratan`
  ADD PRIMARY KEY (`codContrato`),
  ADD KEY `contratan_usuario_foreign` (`usuario`),
  ADD KEY `contratan_bono_foreign` (`bono`),
  ADD KEY `contratanBonoSoli_bono` (`bonoSolicitado`);

bonuses

    CREATE TABLE `bonos` (
  `codBono` int(10) UNSIGNED NOT NULL,
  `tipo` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minutos` int(10) UNSIGNED NOT NULL,
  `precio` double(5,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `bonos`
--

INSERT INTO `bonos` (`codBono`, `tipo`, `minutos`, `precio`, `created_at`, `updated_at`) VALUES
(1, '1/2H', 30, 20.00, NULL, NULL),
(2, '1H', 60, 40.00, NULL, NULL),
(3, '5H', 300, 175.00, NULL, NULL),
(4, '10H', 600, 330.00, NULL, NULL),
(5, '24H', 1200, 600.00, NULL, NULL),
(6, '10Min', 10, 9.00, NULL, NULL);

Attendance

CREATE TABLE `asistencia` (
  `codAsistencia` int(10) UNSIGNED NOT NULL,
  `fecha` datetime NOT NULL,
  `mensaje` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `usuario` bigint(20) UNSIGNED NOT NULL,
  `estado` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendiente',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `asistencia`
--

INSERT INTO `asistencia` (`codAsistencia`, `fecha`, `mensaje`, `usuario`, `estado`, `created_at`, `updated_at`) VALUES
(2, '2020-11-23 11:25:29', 'Prueba Histórico', 1, 'pendiente', NULL, NULL),
(3, '2020-11-23 12:32:03', 'prueba', 1, 'pendiente', NULL, NULL);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `asistencia`
--
ALTER TABLE `asistencia`
  ADD PRIMARY KEY (`codAsistencia`),
  ADD KEY `asistencia_usuario_foreign` (`usuario`);

I'm making a small application in android with kotlin, I'm pretty new at this... I've already created the database, the table, I do the insert, but I would like to make a select from that table in an activity and show the data. .. I do not get it...

This is my code to get the users

//función para obtener usuarios
fun getUsers(): ArrayList<User> {
        val usuarios = ArrayList<User>()
        val db = writableDatabase
        val selectQuery = "SELECT  * FROM NOMBRE_TABLA"
        val cursor = db.rawQuery(selectQuery, null)
        if (cursor != null) {
            cursor.moveToFirst()
            while (cursor.moveToNext()) {
                val nombre  = cursor.getString(cursor.getColumnIndex(COL_NOMBRE))
                val apellidos  = cursor.getString(cursor.getColumnIndex(COL_APELLIDOS))
                val usuario = User(nombre, apellidos)
                usuarios.add(usuario)
            }
        }
        cursor.close()
    return usuarios
    }
}

I think it returns them correctly, but now I don't know how to return them to the view... This is my method in my activity

fun listado(){
    var db = Database(this, "pacDesarrollo", null, 1)
    db.getUsers()
}

I've managed not to fail me, but I don't know how I should show them...

I think I have found the solution to display them. a listView

but when trying to display my data there, the LogCat returns the following error:

java.lang.IllegalStateException: ArrayAdapter requires the resource ID to be a TextView

And since I am creating the adapter, it is:

fun listado() {
    var db = Database(this, "pacDesarrollo", null, 1)
    val users = db.getUsers()

    adaptador1 = ArrayAdapter(this, android.R.layout.activity_list_item, users)
    vista.setAdapter(adaptador1)
}

Thank you and regards

I am creating a vueJS component which contains a dataList with dynamic options, since it is filled from the database. I need to get the value of the selected option, but I can't. Attached is the code of my component:

    <template>

    <div>
        <input list="usuarios" class="form-control mt-3">

        <datalist id="usuarios">

          <option v-for="data in usuarios" :val="data.id" @click="seleccionado($data.id)">{{data.nombre}}</option>

        </datalist>
    </div>

</template>

<script>
    export default {

        data() {
            return {
                usuarios: [],
            };

        },
        created: function () {
            this.cargar();
        },
        methods: {
            cargar: function () {
                let url = "/getUsers";
                axios
                    .get(url)
                    .then((response) => {
                        this.usuarios = response.data;
                    })
                    .catch((error) => console.error(error));
            },
            seleccionado: function(event){
                console.log(event.value);
            }
            
        },
    };
</script>

I am trying to create a stopwatch in JavaScript , this works correctly, but I need it to add the minutes starting from 5, I have a counter initialized to 5 and another one that controls the minutes, but I need it to establish a span with minutes equal to 5 when the second counter is equal to the first and from there continue counting minutes...

I hope I have explained myself clearly. I attach my current code, since I can't get it to add the minutes after 5 min.

counters

var contador_segundos = 0;
var contador_minutos = 0;
var contador = 5;
var cronometro;
var tiempoContratado;

function(){
    if(contador_segundos == 60){
        contador_segundos = 0;
        contador_minutos++;
        contador++;
        
        if(contador == contador_minutos){
            minutos.innerHTML = contador;
            minutos.innerHTML = contador_minutos;
        }

        
        if(contador_minutos == 60){
            contador_minutos = 0;
        }
    }

    segundos.innerHTML = contador_segundos;

    contador_segundos++;

},1000);

UPDATE

cronometro = setInterval(function (){
                    if(cronometro >= startMin){
                        sec++;
                        if(sec == 60){
                            min++;
                            sec = 0;
                            if(min == 60){
                                hour++;
                                min = 0;
                            }
                        }
                    }
                    console.log(sec);
                    minutos.innerHTML = min
                }, 1000);

Thanks in advance.

I am trying to create a search engine for a website, but I need to search for specific words in that search engine, such as "i5 laptop".

I've tried with LIKEbut it doesn't do it right. I have to say that maybe the string I'm looking for is not at the beginning or at the end, but rather it is contained.

I have tried this MySQL function:

SELECT * FROM comparador WHERE MATCH (titulo) AGAINST ('+"portatil i5"' IN BOOLEAN MODE)

It does not return anything, but if I put a 14, it does it well.

And also this one:

SELECT * FROM comparador WHERE MATCH (titulo) AGAINST ('+portatil +i5' IN BOOLEAN MODE)

The one that returns similar results is the first one, but putting i5it annoys the query.

Then aside, this travels from a post with ajax.

EDITION

Records in the Example DB

(34528, 0, '', '', 0, '', '', 0, 0, '', '', 0, '', 'PORTATIL ASUS X509JA-BR491T i3-1005G1 15.6HD 8GB 512SSD W10 COLOR PLATA', '', '', '', '', '90NB0QE1-M10120', 'DESYMAN', '', 369, 0, '0', '', 0, 'https://desyman.com/articulos/artporta asus x509ja-br491t_1.jpg\r', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0000-00-00 00:00:00', 0, 0, '2020-10-08 07:10:40'),
    (34529, 0, '', '', 0, '', '', 0, 0, '', '', 0, '', 'PORTATIL ASUS X509JA-BR252T i3-1005G1 15.6HD 8GB 256SSD W10 COLOR PLATA', '', '', '', '', '90NB0QE1-M09760', 'DESYMAN', '', 339, 0, '0', '', 0, 'https://desyman.com/articulos/artporta asus x509ja-br252t_1.jpg\r', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '0000-00-00 00:00:00', 0, 0, '2020-10-08 07:10:40'),

Table in DB

CREATE TABLE `comparador` (


`id` int(11) NOT NULL,
  `id_categoria` int(11) NOT NULL,
  `categoria` text COLLATE utf8_spanish2_ci NOT NULL,
  `ruta_categoria` text COLLATE utf8_spanish2_ci NOT NULL,
  `id_subcategoria` int(11) NOT NULL,
  `subcategoria` text COLLATE utf8_spanish2_ci NOT NULL,
  `marca` text COLLATE utf8_spanish2_ci NOT NULL,
  `id_marca` int(11) NOT NULL,
  `id_proveedor` int(11) NOT NULL,
  `tipo` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `ruta` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `estado` int(11) NOT NULL,
  `url_producto` text COLLATE utf8_spanish2_ci NOT NULL,
  `titulo` text COLLATE utf8_spanish2_ci NOT NULL,
  `titular` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `youtube` text COLLATE utf8_spanish2_ci NOT NULL,
  `multimedia` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `proveedor` text COLLATE utf8_spanish2_ci NOT NULL,
  `ean` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float NOT NULL,
  `canon` int(11) NOT NULL,
  `stock` text COLLATE utf8_spanish2_ci NOT NULL,
  `detalles` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `precio` float NOT NULL,
  `portada` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `vistas` int(11) NOT NULL,
  `ventas` int(11) NOT NULL,
  `vistasGratis` int(11) NOT NULL,
  `ventasGratis` int(11) NOT NULL,
  `ofertadoPorCategoria` int(11) NOT NULL,
  `ofertadoPorSubCategoria` int(11) NOT NULL,
  `oferta` int(11) NOT NULL,
  `precioOferta` float NOT NULL,
  `descuentoOferta` int(11) NOT NULL,
  `imgOferta` text CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `finOferta` datetime NOT NULL,
  `peso` float NOT NULL,
  `entrega` float NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

php code of the application

// Incluimos nuestro archivo CONEXION
require_once "../app/conexion.php";

$articuloAbuscar = $_POST["articulo"];


$articulo = DB::queryExecute("SELECT * 
                                FROM comparador
                                WHERE MATCH (titulo)
                                AGAINST ('".$articuloAbuscar."' IN NATURAL LANGUAGE MODE)
                                LIMIT 50;
                            ");



echo "<div class='row'>";
    for($i=0; $i<count($articulo); $i++){

        echo "<div class='col-md-2'>";

            if($articulo[$i]["portada"] != null){
                echo "<img class='imagenProducto' src='".$articulo[$i]['portada']."'/>" . "<br/>";
            }else{
                echo "No tiene imagen" ."<br/>" ;
            }

            $id = $articulo[$i]['id'];

            echo "<br/>";
            echo "<span> Titulo: ".$articulo[$i]["titulo"] ."</span>". "<br/>";
            echo "<span> Proveedor: ".$articulo[$i]["proveedor"] ."</span>". "<br/>";
            echo "<span> PN: " . $articulo[$i]["codigo"] . "</span>" . "<br/><br/>";
            echo "<span class='bg-danger text-white'> Costo: " . $articulo[$i]["costo"] . "</span>" . "<br/><br/>";
            echo "<span class='bg-danger text-white'> Stock: " . $articulo[$i]["stock"] . "</span>" . "<br/><br/>";
            echo "<a href='controladores/generarOfertaEmseel.php?id=$id'>
                    <button class='btn btn-success mb-5'>Crear Oferta EMSEEL</button>
                  </a>";
            echo "<a href='controladores/generarOfertaIntegra.php?id=$id'>
                    <button class='btn btn-success mb-5'>Crear Oferta Informatica</button>
                  </a>";
            
        echo "</div>";
    }
echo "</div>";

json_encode($articulo);

class connection

class DB {


public static function connect() {
    try{
        $connection = new PDO("mysql:host=10.48.0.19;dbname=bbdd-tienda-integra","root","pass");
        $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }catch(PDOException $e){
        echo "Error: ". $e->getMessage();
    }

return $connection;
}


// EXECUTE QUERY MYSQL TYPE SELECT
public static function queryExecute($sql){
    $arrayData = array();

    try{

        $connection = DB::connect();

        $stmt = $connection->query($sql);
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $stmt->execute();

        // SAVE THE DATA IN ARRAY
        $arrayData = $stmt->fetchAll();


    }catch(PDOException $e){
        echo 'Error: '. $e->getMessage();
    }
return $arrayData;
}

INDEX query

//generamos la consulta
$resultado = DB::queryExecute("SELECT DISTINCT id, titulo, codigo, proveedor, costo, stock, portada FROM comparador ORDER BY id ASC LIMIT 10");

I have to say that it is an application made with pure php, no MVC, and I am only modifying it, I have not made it myself and I am going crazy with many things....

Thanks in advance

Hello everyone, I am trying to upload a file, with a form to a folder for later email sending. My problem is that from pure html and php I get it without problems, but I need to capture client IDs in datalist filled with ajax and that cannot be done with PHP, I have to do it with javascript (jquery) therefore I had to take a step back in my development and go back to a previous version where if I inserted without problems in the DB, the problem is capturing the input type file with the name of the file (the path is saved in the DB) I am working with Laravel and using $request- >file('attached') but it always comes back empty... How should I capture the input file to pass it to the controller??

JS:

// función para insertar la incidencia
function insertarIncidencia(codigoCliente){

    var fechaSolicitud = $("#fechaSolicitud").val();
    var categoria = $("#categoria").val();
    var solicitante = $("#idSolicitante").val();

    var prioridad = $("#Abrirprioridad").val();
    var asunto = $("#asunto").val();
    var mensaje = $("#cuerpoMensaje").val();
    var adjunto = $("#adjunto").val();
    var token = $("#token").val();


    $.ajax({
        url: '/setIncidencia',
        type: 'POST',
        data: {
            "fechaSolicitud": fechaSolicitud,
            "categoria": categoria,
            "solicitante": solicitante,
            "prioridad": prioridad,
            "cliente": codigoCliente,
            "asunto": asunto,
            "mensaje": mensaje,
            "adjunto": adjunto,
            "_token": token
        },

        success:function (data) {
            $("#correcto").show();
            $("#correcto").append("Incidencia Generada");

            console.log(data);
            
            // ENVIAMOS EL ID DE LA ULTIMA INCIDENCIA INSERTADA Y TAMBIÉN
            // CUANDO ENVIEMOS EL EMAIL, NOS DEVOLVERÁ A LA PÁGINA DE LAS INCIDENCIAS
            //enviarEmailTecnicos(data);
        },
        error:function(xhr, ajaxOptions, thrownError){
            $("#error").append(xhr.status);
            console.log(xhr.status);
        }
    });
}

PHP:

public function setIncidenciaPost(Request $request){

    $uploadedFile = "";
    $filename = "";

    echo "fichero: " . $request['adjunto'];
    exit();

    if($request->file('adjunto') != ""){
        $uploadedFile = $request["adjunto"];
        $filename = $uploadedFile->getClientOriginalName();

        \Storage::disk('local')->putFileAs(
            'subidas/'.$filename,
            $uploadedFile,
            $filename
        );
    }else{
        echo "viene vacio";
    }


    $resultado = \DB::table('incidencias')->insert([
                                        'fecha_solicitud' => $request["fechaSolicitudAbrir"],
                                        'fecha_respuesta' => $request["fechaRespuesta"],
                                        'categoria' => $request["categoria"],
                                        'solicitante' => $request["solicitante"],
                                        'prioridad' => $request["prioridad"],
                                        'estado' => "pendiente",
                                        'asunto' => $request["asunto"],
                                        'cuerpo' => $request["mensaje"],
                                        'cliente' => $request["cliente"],
                                        'adjunto' => $request->file('adjunto')
                                    ]);

    $idIncidencia = \DB::getPdo()->lastInsertId();

    // ENVIA EMAIL A LOS TÉCNICOS CUANDO SE GENERA LA INCIDENCIA
    //$this->enviarEmail($request);

return \Redirect::to('/mostrarIncidencias');

}

As you can see, there is test code, but neither with file nor with the pure request do I get the file... The request returns the full path... And with File it is always empty...

HTML FORM

<form action="" method="POST" class="mt-5 pl-5 pr-5" id="formularioAlta" enctype="multipart/form-data">
                    <div class="row offset-md-1">
                        <div class="form-group">
                            <label for="fechaSolicitud">Fecha de solicitud</label>
                            <div class="col-xs-12 pb-5">
                                <input type="text" name="fechaSolicitudAbrir" id="fechaSolicitud" class="form-control">
                            </div>
                        </div>
                        <div class="form-group pl-5">
                            <label for="fechaSolicitud">Categoria</label>
                            <div class="col-xs-12">
                                <select class="browser-default custom-select" name="categoria" id="categoria">
                                    <option selected>Selecione unca categoria</option>
                                    <option value="Comercial">Comercial</option>
                                    <option value="Técnico">Técnico</option>
                                </select>
                            </div>
                        </div>
                    </div> <!-- FIN PRIMER ROW -->
                    <div class="row">
                        <div class="form-group">
                            <div class="row">
                                <div class="col-xs-12 col-md-4">
                                    <label for="fechaSolicitud">Solicitante</label>
                                    <br/>
                                    <!-- ESCRIBIMOS EL NOMBRE DE QUIEN SOLICITA LA INCIDENCIA -->
                                    <input type="text" name="solicitante" id="solicitante" value="{{auth()->user()->nombre}}"/>

                                    <!-- ESCRIBIMOS LA ID DEL USUARIO QUE HA INICIADO LA SESIÓN, PARA HACER OPERACIONES POSTERIORMENTE-->
                                    <input type="hidden" name="idSolicitante" id="idSolicitante" value="{{auth()->user()->cod_usuario}}"/>
                                </div>
                                <div class="col-xs-12 col-md-4">
                                    <label for="fechaSolicitud">Prioridad</label>
                                    <div class="col-xs-12">
                                        <select class="browser-default custom-select" id="Abrirprioridad" name="Abrirprioridad">
                                            <option selected>Seleccione una prioridad</option>
                                            <option value="Urgente">Urgente</option>
                                            <option value="Inmediato">Inmediato</option>
                                            <option value="Normal">Normal</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="col-xs-12 col-md-4 pb-3">
                                    <div class="col-xs-12">
                                        <label for="cliente">Cliente:</label><br>
                                        <input type="text" list="clientes" id="nombreClienteAbrir" name="cliente"/>
                                            <datalist id="clientes"></datalist>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div><!-- FIN SEGUNDO ROW -->
                    <div class="row">
                        <div class="col-xs-12 col-md-6">
                            <label for="asunto">Persona Contacto:</label>
                            <div class="col-xs-12">
                                <input type="text" class="form-control" id="nombreContacto" name="nombre">
                            </div>
                        </div>
                        <div class="col-xs-12 col-md-6">
                            <label for="asunto">Telefono Contacto:</label>
                            <div class="col-xs-12">
                                <input type="text" class="form-control" id="telefonoContacto" name="telefono">
                            </div>
                        </div>

                    </div>
                    <div class="form-group">
                        <div class="col-xs-12">
                            <label for="asunto">Asunto</label>
                            <div class="col-xs-12">
                                <input type="text" class="form-control" list="asuntosAbrir" name="asunto" id="asunto"/>
                                <datalist id="asuntosAbrir"></datalist>
                            </div>
                        </div>
                        <div class="col-xs-12">
                            <label for="mensaje">Mensaje</label>
                            <textarea class="form-control" rows="5" id="cuerpoMensaje" name="mensaje"></textarea>
                        </div>
                        <div class="col-xs-12 mt-3">
                            <label for="mensaje">Adjunto</label>
                            <input type="file" name="adjunto" id="adjunto">
                        </div>
                    </div>
                    <!-- input para el token -->
                    <input type="hidden" name="_token" id="token" value="{{ csrf_token() }}">
                    <div class="col-xs-12 col-md-4">
                        <input type="submit" class="btn btn-success" id="enviarIncidencia" value="Enviar incidencia">
                    </div>
                </form>

I appreciate all help.

RESOLVED

Controller:

// FUNCIÓN PARA ABRIR UNA INCIDENCIA

public function setIncidenciaPost(Request $request){

    $uploadedFile = "";
    $filename = "";




    if($request->file('adjunto') != ""){
        $uploadedFile = $request->file('adjunto');
        $filename = $uploadedFile->getClientOriginalName();

        //$subido = \Storage::disk('local')->putFileAs(public_path(), $uploadedFile, $filename);
        $destino = 'subidas';
        $uploadedFile->move($destino, $uploadedFile->getClientOriginalName());

    }else{
        echo "archivo vacio";
        exit();
    }


    //consulta para obtener el ID del cliente, a traves del nombre que se eligió en el datalist
    $cliente = \DB::table('usuarios')->where("nombre", '=', $request["cliente"])->first();

    

    $resultado = \DB::table('incidencias')->insert([
                                        'fecha_solicitud' => $request["fechaSolicitudAbrir"],
                                        'fecha_respuesta' => $request["fechaRespuesta"],
                                        'categoria' => $request["categoria"],
                                        'solicitante' => $request["idSolicitante"],
                                        'prioridad' => $request["Abrirprioridad"],
                                        'estado' => "pendiente",
                                        'asunto' => $request["asunto"],
                                        'cuerpo' => $request["mensaje"],
                                        'cliente' => $cliente->cod_usuario,
                                        'adjunto' => $filename
                                    ]);

    $idIncidencia = \DB::getPdo()->lastInsertId();

    // ENVIA EMAIL A LOS TÉCNICOS CUANDO SE GENERA LA INCIDENCIA
    $this->enviarEmail($request);

return \Redirect::to('/mostrarIncidencias');

JS

   // función para insertar la incidencia
function insertarIncidencia(codigoCliente){

    var fechaSolicitud = $("#fechaSolicitud").val();
    var categoria = $("#categoria").val();
    var solicitante = $("#idSolicitante").val();

    var prioridad = $("#Abrirprioridad").val();
    var asunto = $("#asunto").val();
    var mensaje = $("#cuerpoMensaje").val();
    var token = $("#token").val();
    var adjunto = $('#adjunto').prop('files')[0];


    $.ajax({
        url: '/setIncidencia',
        type: 'POST',
        data: {
            "fechaSolicitud": fechaSolicitud,
            "categoria": categoria,
            "solicitante": solicitante,
            "prioridad": prioridad,
            "codigoCliente": codigoCliente,
            "asunto": asunto,
            "mensaje": mensaje,
            "adjunto": adjunto,
            "_token": token
        },
        success:function (data) {
            $("#correcto").show();
            $("#correcto").append("Incidencia Generada");

            console.log(data);
            
            // ENVIAMOS EL ID DE LA ULTIMA INCIDENCIA INSERTADA Y TAMBIÉN
            // CUANDO ENVIEMOS EL EMAIL, NOS DEVOLVERÁ A LA PÁGINA DE LAS INCIDENCIAS
            //enviarEmailTecnicos(data);
        },
        error:function(xhr, ajaxOptions, thrownError){
            $("#error").append(xhr.status);
            console.log(xhr.status);
        }

});

}

I am having trouble generating an image from PHP. My problem is that the file is generated perfectly with the structure I need, but when I open the image file I get the following message: "It seems that the format of this file is not supported." I am doing it with Laravel

I enclose code of how I generate the image and save it in the DB (the name of the image)

HTML:

<div class="col-md-5">
    <div class="card-header">Firma</div>
    <input type="color" class="js-color-picker  color-picker">
    <input type="range" class="js-line-range" min="1" max="72" value="1">
    <label class="js-range-value">1</label>Px
    <canvas class="js-paint paint-canvas" id="canvas" name="firma" width="400" height="300"></canvas>
    <input type="hidden" name="_token" id="token" value="{{ csrf_token() }}">
</div>

Controller:

public function crearPaciente(Request $request){

    $nombre = $request->get('nombre');
    $apellidos = $request->get('apellidos');
    $dni = $request->get('dni');
    $fechaNacimiento = $request->get('fechaNacimiento');
    $lugarNacimiento = $request->get('lugarNacimiento');
    $direccion = $request->get('direccion');
    $codigoPostal = $request->get('codigoPostal');

    $telefonoFijo = $request->get('telefonoFijo');
    $telefonoMovil = $request->get('telefonoMovil');
    $compania = $request->get('compania');

    

    //obtenemos la fecha de firma
    $fecha = \Carbon\Carbon::now();
    $fechaFinal = $fecha->toDateString();

    $firma = $request->get('dataURL');

    $this->generateImage($firma, $nombre, $apellidos);

    $pacienteFirma = $nombre.$apellidos.".png";

    $guardarFirma = str_replace(' ', '', $pacienteFirma);

    
    $data = array('nombre'=>$nombre,
                  "apellidos"=>$apellidos,
                  "dni"=>$dni,
                  "fecha_nacimiento"=>$fechaNacimiento,
                  "lugar_nacimiento"=>$lugarNacimiento,
                  "direccion"=>$direccion,
                  "cod_postal"=>$codigoPostal,
                  "tlf1"=>$telefonoFijo,
                  "tlf2"=>$telefonoMovil,
                  "compania"=>$compania,
                  );

    $consentimiento = array('fechaFirma' => $fechaFinal,
                            'firma' => $guardarFirma
                           );


    \DB::table('pacientes')->insert($data);
    \DB::table('lopds')->insert($consentimiento);

I capture the resquest of the canvas

$firma = $request->get('dataURL');

$this->generateImage($firma, $nombre, $apellidos);

function "generateImage"

public function generateImage($img, $nombre, $apellidos){

    $cadenaNombre = $nombre.$apellidos;
    
    $nombreApellidos = str_replace(' ', '', $cadenaNombre);

    $path = "images/".$nombreApellidos.".png";
    
    $imgTran1 = str_replace('data:image/png;base64,', '', $img);
    $imgTran2 = str_replace(' ', '+', $img);
    $data = base64_decode($imgTran2);

    $success = file_put_contents($path, $data);
}

I have to say, that before transforming the image, the resulting canvas string is a base64 string, as you can see in the $imgTran1 variable.

Thanks in advance for the help, since I don't know what could be wrong so that the image is not displayed. When returning it in html again, it doesn't show either.

cheers and thank you again

How could I add the link to my cart page to my cart icon in WooCommerce?

<div class="unit unit-spacing-xs-4 align-items-center">
  <div class="unit-body">
    <a href="<?php// $cart_url = $woocommerce->cart->get_cart_url(); ?>">
      <i class="fas fa-shopping-cart fa-2x"> </i>
    </a>
   </div>
 </div>

All the PHP, I add code that I was using, but it doesn't work

I have my cart.php template but I don't know how to make this template.

Can you give me a cable?

in functions.php I have given support for this

add_filter('woo_cart_but', 'woo_cart_but');
function woo_cart_but() {
    ob_start();

        $cart_count = WC()->cart->cart_contents_count; // Set variable for cart item count
        $cart_url = wc_get_cart_url();  // Set Cart URL

        ?>
        <li><a class="menu-item cart-contents" href="<?php echo $cart_url; ?>" title="My Basket">
        <?php
            if ( $cart_count > 0 ) {
                ?>
                    <span class="cart-contents-count"><?php echo $cart_count; ?></span>
                <?php
            }
        ?>
        </a>
        </li>
        <?php

return ob_get_clean();
}

I appreciate all help

I'm trying to loop through a CSV with PHP, I've already done that, but now I need to keep the URLs of the images as they are from a reseller catalog so I can upload them to woocommerce.

The thing is that I can't find the way to find the path of the image inside an array, which I have created to store all the CSV info, I have used some PHP functions but without result. I attach code and image of what I need.

1st CSV image and routes:

I have an HTML form that allows me to select the CSV to process it and I'm interested in doing it in a generic way because this script can be used in more situations.

My current php script is like this:

<?php

$fila = 1;
$array = array();
$buscar = 'https://';
$resultadoBusqueda;

if (($gestor = fopen("Productos-Euromoto-20-09-2018.csv", "r")) !== FALSE) {

    while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
        $numero = count($datos);
        echo "<p> $numero de campos en la línea $fila: <br /></p>\n";
        $fila++;
        for ($i=0; $i < $numero; $i++) {
            //echo $datos[$i] . "<br />\n";
            $array = $datos[$i];
            echo 'contenido array: ' . $array;
            echo "<br>";

            //echo 'foto: ' . strstr($array[$i], 'https://', true);
        }

    }

    $resultadoBusqueda = array_filter($array, function($var) use ($buscar) { return stristr($var, $buscar) } );
        if($resultadoBusqueda){
            echo 'se ha encontrado el termino "' . $buscar .'" en la posicion <br>';
            foreach($resultados as $resultadoBusqueda){
                echo $resultados . "<br>";
            }
        }else{
            echo 'El termino "' . $buscar . '" no se ha encontrado en el array ';
        }

}

But it returns me that an argument is missing. Anyway, I don't know if it will be the best way to do this. What I need is that, within the array, look for the string that begins with "http://" and ends with ".jpg"

I appreciate all help.

All the best

I'm trying to create a bottom-up overlay effect for an image by hovering over it and displaying centered text, but I can't. I have read a lot, I have seen many tutorials, but I cannot apply it, since my image container is flex and I need to create this effect. I appreciate all help. I attach my html and css code

.containerFotos{
    display: flex;
    flex-wrap: wrap;
    justify-content: space-around;
    flex-direction: row;
    overflow: hidden;
}


.containerFotos img{
    margin-top: -150px;
    width: 650px;
    height: 400px;
    padding: 100px;
    z-index: 0;
}

.comida{
    position: absolute;
    left: 7.9%;
    background-color: red;
    width: 34.2%;
    text-align: center;
    top: 184%;
    z-index: 3;
}

.comida:hover .overlay{
   background-color: yellow;
   /*height: 100px;*/
}

.overlay{
    transition: height 10s;
    background-color:rgba(43, 34, 68, 0.9);
}

.overlay:hover{
    height: 20em;
}

<div class="containerFotos">
		<img src="../img/descarga.jpg" />

	    <div class="comida">
	       <div class="overlay">
	       		<p> prueba </p>
	       	</div>	
	    </div>			
			
		
		<img src="../img/MATUMBO-STEW-800x510.jpg"/>
		<img src="../img/IMG_20170817_151825_mini-1024x576.jpg"/>
		<img src="../img/150304102311-irio-cnn-super-169-1024x576.jpg"/>
		<img  src="../img/maharagwe-poa-pinterest-1024x538.jpg"/>
		<img src="../img/tanzaniasafariprivatetours_wali-wa-nazi_riso-al-cocco-1024x629.jpg"/>
		
	</div>

i am trying to command a ul with javascript. But I run into the problem that it doesn't order it and part of it only captures two li, my current code is as follows:

function ordenarLista(){

    var vaciar = '';
    var ul = document.getElementById("listaCanciones");
    var li = document.createElement("li");
    var arrayCanciones = new Array();
    var lista = ul.getElementsByTagName("li");

    //lista la transformamos en un array
    for(var i=0; i<lista.length;i++){
        //para añadir elementos a un array push
        arrayCanciones.push(lista[i]);
        //ordenamos el array
        console.log(arrayCanciones.sort());
        //agragamos las canciones a la lista
        li.appendChild(arrayCanciones[i]);
    }

    //pinchamos li en el DOM
    ul.appendChild(li);
}

The first image shows the data entry of a simple form.

the second the result of clicking sort and the resulting console.log.

I do not know why it only captures two li and does not order.

I appreciate all help.

I am developing an application in html, php and some javascript, surely someone has already read my doubts here. I have a canvas where I make a signature for the users and I have in my form, a button in which I convert the canvas into a png image and the windows box automatically appears to select the folder to download, but I don't want that. I want the signature to be automatically downloaded to a folder. Attached html code and JavaScript

Canvas definition:

<canvas id="canvas"> 
        Su navegador no soporta canvas
</canvas>

This is the code snippet for the transform button:

<script type="text/javascript">
    function guardar() {        
      var link = document.createElement('a')
      link.download = "firma";

      link.href = canvas.toDataURL("image/png").replace("image/png", "image/octet-stream");
      link.click();
    }
</script>

Canvas events:

<script type="text/javascript">
    var limpiar = document.getElementById("limpiar");
    var canvas = document.getElementById("canvas");
    var ctx = canvas.getContext("2d");
    var cw = canvas.width = 150, cx = cw / 2;
    var ch = canvas.height = 150, cy = ch / 2;

    var dibujar = false;
    var factorDeAlisamiento = 5;
    var trazados = [];
    var puntos = [];
    ctx.lineJoin = "round";


    limpiar.addEventListener('click', function(evt){
        dibujar = false;
        ctx.clearRect(0, 0, cw, ch);
        trazados.length = 0;
        puntos.length = 0;
    }, false);


    canvas.addEventListener('mousedown', function(evt) {
         dibujar = true;
         //ctx.clearRect(0, 0, cw, ch);
         ctx.beginPath();
    }, false);

    canvas.addEventListener('mouseup', function(evt) {
        dibujar = false;
    }, false);

    canvas.addEventListener("mouseout", function(evt) {
          dibujar = false;
    }, false);

    canvas.addEventListener("mousemove", function(evt) {
        if (dibujar) {
            var m = oMousePos(canvas, evt);
            puntos.push(m);
            ctx.lineTo(m.x, m.y);
            ctx.stroke();
          }
    }, false);

    function reducirArray(n,elArray) {
        var nuevoArray = [];
         nuevoArray[0] = elArray[0];
         for (var i = 0; i < elArray.length; i++) {
            if (i % n == 0) {
              nuevoArray[nuevoArray.length] = elArray[i];
            }
          }
        nuevoArray[nuevoArray.length - 1] = elArray[elArray.length - 1];
        Trazados.push(nuevoArray);
    }

    function calcularPuntoDeControl(ry, a, b) {
        var pc = {}
        pc.x = (ry[a].x + ry[b].x) / 2;
        pc.y = (ry[a].y + ry[b].y) / 2;
        return pc;
    }

    function alisarTrazado(ry) {
        if (ry.length > 1) {
        var ultimoPunto = ry.length - 1;
        ctx.beginPath();
        ctx.moveTo(ry[0].x, ry[0].y);
        for (i = 1; i < ry.length - 2; i++) {
            var pc = calcularPuntoDeControl(ry, i, i + 1);
            ctx.quadraticCurveTo(ry[i].x, ry[i].y, pc.x, pc.y);
        }
        ctx.quadraticCurveTo(ry[ultimoPunto - 1].x, ry[ultimoPunto - 1].y, ry[ultimoPunto].x, ry[ultimoPunto].y);
        ctx.stroke();
          }
    }

    function redibujarTrazados(){
        dibujar = false;
        ctx.clearRect(0, 0, cw, ch);
        reducirArray(factorDeAlisamiento,puntos);
        for(var i = 0; i < Trazados.length; i++){
          alisarTrazado(Trazados[i]);
        }
    }

    function oMousePos(canvas, evt){
        var ClientRect = canvas.getBoundingClientRect();
        return { //objeto
            x: Math.round(evt.clientX - ClientRect.left),
            y: Math.round(evt.clientY - ClientRect.top)
          }
    }       
</script>

I would be missing the code or part of the code, to know how to save the image in a specific path, a specific folder.

A greeting and thanks in advance.

I have managed to save a canvas as an image, using javaScript and Ajax, but I want or would like a dialog box not to appear to choose the destination folder, but rather to save it in a pre-established path.

Code block attached:

<script type="text/javascript">
    function guardar() {        
      var link = document.createElement('a')
      link.download = "firma";

      link.href = canvas.toDataURL("image/png").replace("image/png", "image/octet-stream");
      link.click();
    }
</script>
<button onclick="guardar()" id="convertir">Convertir</button>

In that code block, I define the function to convert to image, but I need to further automate this process, by saving the image to a preset path on a server using PHP and the function call will be made at the same time the administrator gives register a user.

I also have the question of how can I upload the image to the server? I need to save the signature in a database, I have the doubt of whether to upload the image to the database or in the database to save the path of the image.

I have the problem that my program returns an error, which I don't know why it occurs, when collecting data from a JTableselected row and passing it to a series of JTextField, the error produced is this:

java.lang.ArrayIndexOutOfBoundsException: 0 >= 0

I attach code where I load the data in the textField

private void btModificarActionPerformed(java.awt.event.ActionEvent evt) {                                            

        int rowIndex = tabla.getSelectedRow();
        dni = String.valueOf(tabla.getValueAt(rowIndex,0));
        nombre = String.valueOf(tabla.getValueAt(rowIndex,1));
        ciudad = String.valueOf(tabla.getValueAt(rowIndex,2));


        tfDni.setText(dni);
        tfNombre.setText(nombre);
        tfCiudad.setText(ciudad);

        btInsertar.setEnabled(false);
        btBorrar.setEnabled(false);
        btListado.setEnabled(false);

    } 

Here I call the modification:

 private void btAceptarActionPerformed(java.awt.event.ActionEvent evt) {                                          
        modificar();  
    } 

Here if I make the modification:

public void modificar(){
       int rowIndex = tabla.getSelectedRow();

       try{      
       String dni = String.valueOf(tabla.getValueAt(rowIndex, 0));
       String nombre = String.valueOf(tabla.getValueAt(rowIndex, 1));
       String ciudad = String.valueOf(tabla.getValueAt(rowIndex, 2));
       String sql = "update clientes set nombre='"+nombre+"',ciudad='"+ciudad+"' where dni='"+dni+"'";
       /*PARA HACER QUE EL UPDATE COJA LOS VALORES DEL CAMPO DE TEXTO, HABRÍA QUE PASARLE EL tf.getText() que corresponda*/
       mysql.ejecutar(sql);
       }catch(Exception e){
           JOptionPane.showMessageDialog(null, "Error al Modificar");
       }
    }

The constructor of the application is like this, I think the fault may be there.

public class Ventana extends javax.swing.JFrame {
    MySQL mysql;
    Connection con;
    PreparedStatement pst;
    Statement st;
    DefaultTableModel modelo;
    String dni;
    String nombre;
    String ciudad;
    ResultSet rs;

public Ventana(MySQL mysql) throws SQLException {
    /*INSTANCIAMOS MYSQL*/
    this.mysql = new MySQL();
    initComponents();
    this.setVisible(true);
    con = mysql.MySQLConnection("pedidos", "root", "1234");
    modelo = new DefaultTableModel();
    tabla.setModel(modelo);

}

Here is the photo so you can see everything

Here I attach another photo that shows all the code

Finally I attach the method where I show what is in the database and get the metadata of the columns

when choosing the row it returns me that

It returns -1, that means, in my opinion, that it has not been updated, and indeed it is.

I'm sorry for answering delay