Andrés Vélez's questions

I have the following migrations/tables: Languages

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateLanguagesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('languages', function (Blueprint $table) {
            $table->string('id');
            $table->string('language')->nullable();
            $table->string('location');
            $table->string('code')->nullable();
            $table->integer('state');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('languages');
    }
}

Users

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('id_style')->unsigned();            
            $table->foreign('id_style')->references('id')->on('styles');
            $table->string('username')->unique()->index();
            //$table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->string('rol');
            $table->integer('status');
            $table->string('ip')->unique();
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

So far so good but in this one that follows I get errors: Profiles

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateProfilesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('profiles', function (Blueprint $table) {
            $table->string('id');
            //falta
            //aqui deberia deicr que id es compuesta por id_user y id_langauge
            $table->integer('id_user')->unsigned();            
            $table->foreign('id_user')->references('id')->on('users');
            $table->string('id_language')->unsigned();            
            $table->foreign('id_language')->references('id')->on('languages');
            //$table->primary('id')->unique('id_user', 'id_language');//PRUEBA POR EJECUTAR
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('profiles');
    }
}

MISTAKE:

php artisan migrate 
Migration table created successfully.
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table
Migrating: 2019_02_19_201248_create_styles_table
Migrated:  2019_02_19_201248_create_styles_table
Migrating: 2019_02_19_201643_create_users_table
Migrated:  2019_02_19_201643_create_users_table
Migrating: 2019_02_19_202644_create_contacts_table
Migrated:  2019_02_19_202644_create_contacts_table
Migrating: 2019_02_19_203326_create_languages_table
Migrated:  2019_02_19_203326_create_languages_table
Migrating: 2019_02_19_204235_create_profiles_table

   Illuminate\Database\QueryException  : SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `profiles` add constraint `profiles_id_language_foreign` foreign key (`id_language`) references `languages` (`id`))

  at /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   PDOException::("SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint")
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458

  2   PDOStatement::execute()
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458

  Please use the argument -v to see more details.
MacBook-Air-de-Andres:Andr3yvlz andr3yvlz$ 

And with-v

php artisan migrate -v
Migration table created successfully.
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table
Migrating: 2019_02_19_201248_create_styles_table
Migrated:  2019_02_19_201248_create_styles_table
Migrating: 2019_02_19_201643_create_users_table
Migrated:  2019_02_19_201643_create_users_table
Migrating: 2019_02_19_202644_create_contacts_table
Migrated:  2019_02_19_202644_create_contacts_table
Migrating: 2019_02_19_203326_create_languages_table
Migrated:  2019_02_19_203326_create_languages_table
Migrating: 2019_02_19_204235_create_profiles_table

   Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 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 near 'unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) def' at line 1 (SQL: create table `profiles` (`id` varchar(255) not null, `id_user` int unsigned not null, `id_language` varchar(255) unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

  at /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   PDOException::("SQLSTATE[42000]: Syntax error or access violation: 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 near 'unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) def' at line 1")
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:452

  2   PDO::prepare("create table `profiles` (`id` varchar(255) not null, `id_user` int unsigned not null, `id_language` varchar(255) unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:452

  3   Illuminate\Database\Connection::Illuminate\Database\{closure}("create table `profiles` (`id` varchar(255) not null, `id_user` int unsigned not null, `id_language` varchar(255) unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'", [])
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657

  4   Illuminate\Database\Connection::runQueryCallback("create table `profiles` (`id` varchar(255) not null, `id_user` int unsigned not null, `id_language` varchar(255) unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'", [], Object(Closure))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624

  5   Illuminate\Database\Connection::run("create table `profiles` (`id` varchar(255) not null, `id_user` int unsigned not null, `id_language` varchar(255) unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'", [], Object(Closure))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Connection.php:459

  6   Illuminate\Database\Connection::statement("create table `profiles` (`id` varchar(255) not null, `id_user` int unsigned not null, `id_language` varchar(255) unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:97

  7   Illuminate\Database\Schema\Blueprint::build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:264

  8   Illuminate\Database\Schema\Builder::build(Object(Illuminate\Database\Schema\Blueprint))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:165

  9   Illuminate\Database\Schema\Builder::create("profiles", Object(Closure))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:237

  10  Illuminate\Support\Facades\Facade::__callStatic("create")
      /Applications/MAMP/htdocs/Andr3yvlz/database/migrations/2019_02_19_204235_create_profiles_table.php:26

  11  CreateProfilesTable::up()
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:360

  12  Illuminate\Database\Migrations\Migrator::Illuminate\Database\Migrations\{closure}()
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:367

  13  Illuminate\Database\Migrations\Migrator::runMigration(Object(CreateProfilesTable), "up")
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:178

  14  Illuminate\Database\Migrations\Migrator::runUp("/Applications/MAMP/htdocs/Andr3yvlz/database/migrations/2019_02_19_204235_create_profiles_table.php")
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:147

  15  Illuminate\Database\Migrations\Migrator::runPending([])
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:96

  16  Illuminate\Database\Migrations\Migrator::run([])
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:71

  17  Illuminate\Database\Console\Migrations\MigrateCommand::handle()
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29

  18  call_user_func_array([])
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29

  19  Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:87

  20  Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Object(Closure))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:31

  21  Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), [])
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Container/Container.php:572

  22  Illuminate\Container\Container::call()
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Console/Command.php:183

  23  Illuminate\Console\Command::execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/symfony/console/Command/Command.php:255

  24  Symfony\Component\Console\Command\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Console/Command.php:170

  25  Illuminate\Console\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/symfony/console/Application.php:901

  26  Symfony\Component\Console\Application::doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/symfony/console/Application.php:262

  27  Symfony\Component\Console\Application::doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/symfony/console/Application.php:145

  28  Symfony\Component\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Console/Application.php:89

  29  Illuminate\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
      /Applications/MAMP/htdocs/Andr3yvlz/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:122

  30  

Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
          /Applications/MAMP/htdocs/Andr3yvlz/artisan:37

I want to show the following from a date, that is, I want it to tell me

Monday 2, Tuesday 31,

and so on, but I don't know how, the language is PHP right now I have this

ucfirst(strtolower(strftime("%B", 
       DateTime::createFromFormat('m', $fila['month'])->getTimestamp())))

And that converts the month to the name of the month, but I don't know how to do it with the day of the week,

I have this data

$fila['month']
$fila['year']
$fila['day']

Hello, how do I eliminate the sort to a jquery dataTable, but to a specific column.

I have tried this:

Option 1

Option 2

In the following image I want to remove the sor only from the column#

Here I pass the code:

<table id="tableBirthdays" class="table display">
        <thead>
            <tr>
                <th scope="col">#</th>
                <th scope="col">Nombre</th>
                <th scope="col">Apellido</th>
                <th scope="col">Cargo</th>
                <th scope="col">Fecha de Nacimiento</th>
                <th scope="col">Inicio del cargo</th>
                <th scope="col">Imagen</th>
            </tr>
        </thead>
        <tfoot style="display: contents;">
            <tr>
                <th>Id</th>
                <th>Nombre</th>
                <th>Apellido</th>
                <th>Cargo</th>
                <th>Fecha de Nacimiento</th>
                <th>Inicio del cargo</th>
                <th>Imagen</th>
            </tr>
        </tfoot>
        <tbody class="contentTable">
<?php
    while ($fila = mysqli_fetch_array($result)){
        $estado="";
        $col_name=$fila['name'];
        $col_surname=$fila['surname'];
        $col_job=$fila['job'];
        $col_id=$fila['id']; 
        $col_start=$fila['start'];
        $col_cumple=$fila['day']."/".$fila['month']."/".$fila['year'];
        $col_image=($fila['image']==NULL) ? "default.png" : $col_id."/".$fila['image'] ;
        $delete .= '<option class="opcionBirthdays" data-src="birthday" value="'.$col_id.'" title="'.$col_name." ".$col_surname.'">';
        $delete .= $col_id.". ";
        $delete .= $col_name." ".$col_surname;
        $delete .= '</option>';
?>
            <tr>
                <td>
                    <label class="d-none"><?php echo $col_id; ?></label>
                    <div class="row">
                        <div class="col">
                            <label><?php echo $col_id; ?></label>
                        </div>
                        <div class="col">
                            <button type="button" value="Guardar" name="detail" class="botonIQ btnGuardar" data-id="<?php echo $col_id; ?>" data-action='controller/uploadBirthday.php?tipo=0&code=<?php echo $col_id; ?>'>Guardar</button>
                        </div>
                    </div>

                </td>
                <td>
                    <input class="form-control" type="text" name="name" value="<?php echo $col_name; ?>" width="150" id="birthdaysName-<?php echo $col_id; ?>" required/>
                    <label class="d-none"><?php echo $col_name; ?></label>
                </td>
                <td>
                    <input class="form-control" type="text" name="surname" value="<?php echo $col_surname; ?>" width="150" id="birthdaysSurname-<?php echo $col_id; ?>" required/>
                    <label class="d-none"><?php echo $col_surname; ?></label>
                </td>
                <td>
                    <input class="form-control" type="text" name="job" value="<?php echo $col_job; ?>" width="150" id="birthdaysJob-<?php echo $col_id; ?>"required/>
                    <label class="d-none"><?php echo $col_job; ?></label>
                </td>
                <td>
                    <input id="birthdaysBirthday-<?php echo $col_id; ?>" class="datepicker form-control" data-elemento="birthdays" width="150" value="<?php echo $col_cumple; ?>" name="birthday" readonly required/>
                    <label class="d-none"><?php echo $col_cumple; ?></label>
                </td>
                <td>
                    <input id="birthdaysStart-<?php echo $col_id; ?>" class="datepicker form-control" data-elemento="birthdays" width="150" value="<?php echo $col_start; ?>" name="start" readonly required/>
                    <label class="d-none"><?php echo $col_start; ?></label>
                </td>
                <td>
                    <form action='controller/uploadBirthday.php?tipo=1&code=<?php echo $col_id; ?>' class='dropzone' data-elemento="birthdays" enctype='multipart/form-data' id='birthdaysImage-<?php echo $col_id; ?>' style="height: 150px; width: 100px; font-size: 10px">
                        <img class='img-l miniImagen' width="40px" height="40px" src='images/<?php echo $col_image; ?>' />
                    </form>
                    <label class="d-none"><?php echo $col_image; ?></label>
                </td>
            </tr>
<?php
        $contador++;
    } 
?>
        </tbody>
    </table>

And this is the js that builds the table

$('#tableBirthdays').DataTable({
          "paging":         false,
          language: {
            "decimal":        "",
            "emptyTable":     "No hay datos",
            "info":           "Mostrando de _START_ a _END_ felicitaciones de un total de _TOTAL_ felicitaciones",
            "infoEmpty":      "Mostrando de 0 a 0 felicitaciones de un total de 0 felicitaciones",
            "infoFiltered":   "(Filtro de _MAX_ total felicitaciones)",
            "infoPostFix":    "",
            "thousands":      ",",
            "lengthMenu":     "Mostrar _MENU_ felicitaciones",
            "loadingRecords": "Cargando...",
            "processing":     "Procesando...",
            "search":         "Buscar:",
            "zeroRecords":    "No se encontraron coincidencias",
            "paginate": {
              "first":      "Primero",
              "last":       "Ultimo",
              "next":       "Próximo",
              "previous":   "Anterior"
                        },
            "aria": {
              "sortAscending":  ": Activar orden de columna ascendente",
              "sortDescending": ": Activar orden de columna desendente"
            }
        }
      }).columns().every( function () {
        var that = this;
        $('input', this.footer()).on('keyup change', function() {
          if ( that.search() !== this.value ) {
              that
                  .search( this.value )
                  .draw();
          }
        });
      });

I'm doing a bootstrap fade carousel but when passing the image it sort of fits, I've tried to delete divs, change different styles and nothing works, I'm going to pass you the url since it's not possible to upload videos, I appreciate it if you can help me. http://seadoglabs.com/iq/pru/

It's on the right side, those images rotate.

Here are two screenshots to see the same in the url it looks better.

I don't know if it can be seen here but in this image it will barely fit after changing the carousel image.

And in this he already settled

codes: view:

<div id="carouselExampleSlidesOnly" class="carousel slide" data-ride="carousel" data-interval="8350">
    <div class="carousel-fade carousel-congratulations">
      <!-- AQUI VAN LAS FELICITACIONES -->
      <div id="contenedor">
        <div class="loader" id="loader">Loading...</div>
      </div>
    </div>
  </div>

Js(upload what is obtained from the controller)

function realizaProceso(){
  var parametros = {};
  $.ajax({
    data:  parametros,
    url:   'controller/index.php',
    type:  'post',
    dataType: 'json',
    beforeSend: function () {
    },
    error: function (request, status, error) {
         console.log(request);
         console.log(status);
         console.log(error);
    },
    success:  function (response) {
      $(".loader").hide();
      $(".carousel-congratulations").html(response.congratulations);
      window.history.pushState("", "", '/iq/pru/');
    }
  });
}

Controller:

       $sentencia = $con->prepare("SELECT * FROM congratulations ORDER BY id ASC;");
    $sentencia->execute([1]);
    $result = $sentencia->fetchAll(PDO::FETCH_OBJ);
    $estado ="active";
    $congratulations = "<div class='container'>";
    /*$congratulations = '<div class="carousel-item '.$estado.'">';
    $congratulations .= '<div class="not-item">';
    $congratulations .= '<img src="admin/images/congratulation/'.$picture->congratulation.'" />';
    $congratulations .= '</div></div>';*/
    $contador=0;
    //$estado="";
    foreach($result as $fila) {
        $congratulations .= '<div class="carousel-item '.$estado.'" style="background: transparent;">';
        $estado="";
        $col_image=($fila->image==NULL) ? "default.png" : "felicitaciones/homenajeado".$fila->id."/".$fila->image ;
        $col_title=$fila->title;
        $col_detail=$fila->detail;
        $congratulations .= '<div class="card" style="background: transparent;">';
        $congratulations .= '<div class="card-body">';
        $congratulations .= '<p class="card-title">'.$col_title.'</p>';
        if( $col_title!=="<!--Empty-->")
            $congratulations .= '<p class="card-card-text">'.$col_detail.'</p>';
        $congratulations .= '<div class="img-cum fleft sin-border"><img class="img-l" src="admin/images/'.$col_image.'" style="'.$fila->css.'"/></div>';
        $congratulations .= '</div></div></div>';
        $contador++;
    }
    $congratulations .= '</div>';
header("Content-type: application/json; charset=utf-8");

//Guardamos los datos en un array
$datos = array(
'congratulations' => $congratulations
);

echo json_encode($datos, JSON_FORCE_OBJECT);

In the images look that the container has a black border with that it is seen when the image is being accommodated, on the site it is noticeable.

what I want is to load a playlist from youtube through ajax and for it to play automatically

   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" id="content">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=2, shrink-to-fit=no">
    <meta name="robots" content="noindex, nofollow" />
    <meta name="google" content="noindex, nofollow" />
    <meta name=”robots” content=”noimageindex”>
    <title>IQ para todos</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    <link rel="stylesheet" href="css/main.css"/>
    <link rel="stylesheet" href="css/cargando.css"/>
    <link href="https://fonts.googleapis.com/css?family=Nunito:200,300,400,600,700" rel="stylesheet">

    <script>


    var tag = document.createElement('script');
      tag.src = "https://www.youtube.com/iframe_api";
      var firstScriptTag = document.getElementsByTagName('script')[0];
      firstScriptTag.parentNode.insertBefore(tag, firstScriptTag);
      var player;


      function onYouTubeIframeAPIReady() {
            player = new YT.Player('player', {
              events: {
                'onReady': onPlayerReady,
                'onStateChange': onPlayerStateChange
              }
            });
          }

          function onPlayerReady(event) {

           $.ajax({
    data:  parametros,
    url:   'controller/changeVideo.php?opcion=leer',
    dataType: "json",
    success:  function (response) {
        $("#player").attr("src", response[1]);
       event.target.playVideo();

    }
});
          }


           var done = false;
          function onPlayerStateChange(event) {
            if (event.data == YT.PlayerState.PLAYING && !done) {
              //setTimeout(stopVideo, 6000);
              done = true;
            }
          }
          function stopVideo() {
            player.stopVideo();
          }
    </script>
    </head>

    <body >
    <div class="pantalla">
      <div class="mod-left fleft">
        <div class="video fleft">
          <!--<iframe src="https://www.youtube.com/embed/RQMAn68hvYY?rel=0&amp;controls=0&amp;showinfo=0&amp;&autoplay=0" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>-->
          <iframe id="player" type="text/html" width="640" height="360"
      src="http://www.youtube.com/embed/M7lc1UVf-VE?enablejsapi=1&origin=http://example.com"
      frameborder="0"></iframe>
      <!---<div id=player"></div>-->

      </div>
      </div>
      </div>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.js" ></script> 
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script> 
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
    <script src="https://www.youtube.com/player_api"></script>
      </body>

Look what happens to me is that I am returning an html by json and it arrives empty if I stop returning it by json and I receive it normal, then if it arrives well and I don't know why or what the error is:

These are the codes:

ajax

  function realizaProceso(){
  var parametros = {};
  $.ajax({
    data:  parametros,
    url:   '../controllers/index.php',
    type:  'post',
    dataType: 'json',//esta linea la quito cuando no uso el json
    beforeSend: function () {
    },
    error: function (request, status, error) {
       console.log(3);
         console.log(request);
         console.log(status);
         console.log(error);
          console.log(4);
    },
    success:  function (response) {
      alert("4");

      /*var randomColor = '#'+ ('000000' + Math.floor(Math.random()*16777215).toString(16)).slice(-6);
      $('#resultado').css({
        'background-color' : randomColor,
      });*/
      console.log(response);
      $(".loader").hide();
      $(".carousel-congratulations").html(response.congratulations);
      $(".carousel-birthdays").html(response.birthdays);
      $(".carousel-events").html(response.events);
      window.history.pushState("", "", '/iq/tv');
    }
  });
   $.ajax({
        data:  parametros,
        url:   '../controllers/changeVideo.php?opcion=leer',
        dataType: "json",
        success:  function (response) {
            $(".urlVideo").attr("src", response[1]);
        }
    });

}

this is the controller or where the query is made

   <?php
//fecha del dia de hoy
setlocale(LC_TIME, 'es_ES');
$hoy = getdate();
$day=$hoy['mday'];
$month=$hoy['mon'];
$year=$hoy['year'];
// Conectando, seleccionando la base de datos
include_once "con.php";
$sentencia = $con->prepare("SELECT * FROM congratulations WHERE id= ?;");
$sentencia->execute([1]);
$result = $sentencia->fetchAll(PDO::FETCH_OBJ);
$estado ="active";
$congratulations = "";
$contador=0;
foreach($result as $fila) {
    $congratulations .= '<div class="carousel-item '.$estado.'">';
    $estado="";
    $col_image=($fila->image==NULL) ? "default.png" : "felicitaciones/homenajeado".$fila->id."/".$fila->image ;
    $col_title=$fila->title;
    $col_detail=$fila->detail;
    $congratulations .= '<div class="not-item">';
    $congratulations .= '<div class="item-t ">'.$col_title.'</div>';
    $congratulations .= '<div class="row">';
    $congratulations .= '<div class="card sin-border">';
    $congratulations .= '<div class="card-body">';
    $congratulations .= '<div class="col" style="border-color: transparent;"><img class="img-l" src="../images/'.$col_image.'" /></div>';
    $congratulations .= '</div></div>';
    $congratulations .= '<div class="col" style="border-color: transparent;">';
    $congratulations .= '<div class="card sin-border">';
    $congratulations .= '<div class="card-body">';
    $congratulations .= '<p class="card-text text-left"> Ciudad: '.$col_detail.'</p>';
    $congratulations .= '</div></div></div></div></div></div>';
    $contador++;
}
$congratulations .= ($contador>0) ? "" : "<div class='carousel-item active'><div class='cum-item'><div class='name fleft'>No hay cumpleaños el dia de hoy</div></div></div>";





$sentencia = $con->prepare("SELECT * FROM birthdays WHERE day= ? AND month= ?;");
$sentencia->execute([$day, $month]);
$result = $sentencia->fetchAll(PDO::FETCH_OBJ);
$estado ="active";
$birthdays = "";
$contador=0;
foreach($result as $fila) {
    $birthdays .= '<div class="carousel-item '.$estado.'">';
    $estado="";
    $birthdays .= '<div class="cum-item">';
    $col_image=($fila->image==NULL) ? "default.png" : $fila->id."/".$fila->image ;
    $col_name=$fila->name;
    $col_surname=$fila->surname;
    $col_job=$fila->job;
    $birthdays .= '<div class="img-cum fleft sin-border"><img class="img-l" src="../images/'.$col_image.'" /></div>';
    $birthdays .= '<div class="col sin-border">';
    $birthdays .= '<div class="row">';
    $birthdays .= '<div class="name fleft">'.$col_name.'<br/>'.$col_surname.'</div></div>';
    $birthdays .= '<div class="row">';
    $birthdays .= '<div class="cargo fel "> '.$col_job.'</div>';
    $birthdays .= '</div></div></div></div>';
    $contador++;
}
$birthdays .= ($contador>0) ? "" : "<div class='carousel-item active'><div class='cum-item'><div class='name fleft'>No hay cumpleaños el dia de hoy</div></div></div>";
$sentencia = $con->prepare("SELECT * FROM events WHERE year>= ?");
$sentencia->execute([2018]);
$result = $sentencia->fetchAll(PDO::FETCH_OBJ);
$estado ="active";
$events = "";
foreach($result as $fila) {
    $events .= '<div class="carousel-item '.$estado.'">';
    $estado="";
    $events .= '<div class="event-item">';
    $events .= '<div class="row">';
    $col_name = $fila->name;
    $col_description = $fila->description;
    $col_city = $fila->city;
    $col_place = $fila->place;
    $col_day = $fila->day;
    $col_month = strftime("%B", DateTime::createFromFormat('m', $fila->month)->getTimestamp()); 
    $col_month = ucwords(strtolower($col_month));
    $col_hour = strftime("%I", DateTime::createFromFormat('H', $fila->hour)->getTimestamp());
    $col_minute = $fila->minute;
    $col_format = DateTime::createFromFormat("H", $col_hour);
    $col_format = $col_format->format("a");
    $events .= '<div class="card sin-border">';
    $events .= '<div class="card-body">';
    $events .= '<div class="col sin-border"><h3 class="text-truncate text-center">'.$col_day.'<small> '.$col_month.'</small></h3></div>';
    $events .= '</div></div>';
    $events .= '<div class="col sin-border">';
    $events .= '<div class="card sin-border" style="border-left-color: rgba(0, 0, 0, .10) !important;">';
    $events .= '<div class="card-body">';
    $events .= '<h2 class="card-title text-left">'.$col_name.'</h2>';
    $events .= '<p class="card-text text-left"> Ciudad: '.$col_city.'</p>';
    $events .= '<p class="card-text text-left">Lugar: '.$col_place.'</p>';
    $events .= '<p class="card-text text-left">Hora: '.$col_hour.':'.$col_minute.' '.$col_format.'</p>';
    $events .= '<p class="card-text text-left"><small>Interesados escribir a [email protected]</small></p>';
    $events .= '</div></div></div></div></div></div>';
    $contador++;
}

if to the controller I add:

echo $congratulations.$birthdays.$events;


?>

In the console I get this:

As you can see, it shows me the html code of the queries that I need.

but on the contrary I add to the controller this:

header('Content-Type: application/json');

//Guardamos los datos en un array
$datos = array(
'estado' => 'ok',
'congratulations' => $congratulations,
'birthdays' => $birthdays,
'events' => $events
);
//Devolvemos el array pasado a JSON como objeto
echo json_encode($datos, JSON_FORCE_OBJECT);

?>

I get this:

is that I have a site that downloads the databases in an excel file but the thing is that I already reach so much data that the excel file arrives damaged, for which it occurred to me that I could only upload let's say a thousand data and that when it is the thousand and one data, save it in another excel file, I don't know if that is possible.

this is my code

 error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');

if (PHP_SAPI == 'cli')
    die('This example should only be run from a Web Browser');

/** Include PHPExcel */
require_once "PHPExcel-1.8/Classes/PHPExcel.php";


// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
ini_set("memory_limit","2048M");

$link = mysqli_connect("localhost", "", "");
mysqli_select_db($link, "");
$tildes = $link->query("SET NAMES 'utf16'"); //Para que se muestren las tildes correctamente
// Set document properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
                             ->setLastModifiedBy("Maarten Balliauw")
                             ->setTitle("Office 2007 XLSX Test Document")
                             ->setSubject("Office 2007 XLSX Test Document")
                             ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
                             ->setKeywords("office 2007 openxml php")
                             ->setCategory("Test result file");
$result0 = mysqli_query($link, "SELECT * FROM quote_new_users ORDER BY id DESC");//que carro cotizo
$result1 = mysqli_query($link, "SELECT * FROM workshop_users ORDER BY id DESC");
$result2 = mysqli_query($link, "SELECT * FROM soat_users ORDER BY id DESC");
$result3 = mysqli_query($link, "SELECT * FROM democar_users ORDER BY id DESC");
$result4 = mysqli_query($link, "SELECT * FROM contact_users ORDER BY id DESC");
$result5 = mysqli_query($link, "SELECT * FROM use_users ORDER BY id DESC");
$result6 = mysqli_query($link, "SELECT * FROM chevy_users ORDER BY id DESC");
$result7 = mysqli_query($link, "SELECT * FROM spares_users ORDER BY id DESC");

//$result12 = mysqli_query($link, "SELECT * FROM quote_new_users ORDER BY id DESC");
//$result13 = mysqli_query($link, "SELECT * FROM quote_new_users ORDER BY id DESC");

$i=5;
while ($fila = mysqli_fetch_array($result0)){
    $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
// $titulosColumnas = array('Codigo', 'Nombre', 'Correo', 'Telefono', 'Fecha de creacion');
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('C3', 'Correo')
            ->setCellValue('D3', 'Telefono ')
            ->setCellValue('E3', 'Fecha de creacion')
            ;
 // Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Cotizador');
for($i = 'A'; $i <= 'E'; $i++){
                $objPHPExcel->setActiveSheetIndex(0)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(0)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);







$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result1)){
    $objPHPExcel->setActiveSheetIndex(1)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['plate'])
            ->setCellValue('F'.$i, $fila['model'])
            ->setCellValue('G'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(1)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('C3', 'Correo')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Placa')
            ->setCellValue('F3', 'Modelo')
            ->setCellValue('G3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Taller');
for($i = 'A'; $i <= 'G'; $i++){
                $objPHPExcel->setActiveSheetIndex(1)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(1)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(1);





$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result2)){
    $objPHPExcel->setActiveSheetIndex(2)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['plate'])
            ->setCellValue('F'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(2)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('A3', 'Correo')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Placa')
            ->setCellValue('F3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Soat');
for($i = 'A'; $i <= 'F'; $i++){
                $objPHPExcel->setActiveSheetIndex(2)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(2)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(2);






$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result3)){
    $objPHPExcel->setActiveSheetIndex(3)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(3)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Codigo - Nombre')
            ->setCellValue('C3', 'Correo')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Demos');
for($i = 'A'; $i <= 'E'; $i++){
                $objPHPExcel->setActiveSheetIndex(3)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(3)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(3);







$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result4)){
    $objPHPExcel->setActiveSheetIndex(4)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(4)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('C3', 'Correo')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Contacto');
for($i = 'A'; $i <= 'E'; $i++){
                $objPHPExcel->setActiveSheetIndex(4)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(4)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(4);





$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result5)){
    $objPHPExcel->setActiveSheetIndex(5)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(5)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('C3', 'Email')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Usados');
for($i = 'A'; $i <= 'E'; $i++){
                $objPHPExcel->setActiveSheetIndex(5)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(5)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(5);





$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result6)){
    $objPHPExcel->setActiveSheetIndex(6)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(6)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('C3', 'Correo')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('ChevyPlan');
for($i = 'A'; $i <= 'D'; $i++){
                $objPHPExcel->setActiveSheetIndex(6)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(6)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(6);







$i=5;
$objPHPExcel->createSheet();
while ($fila = mysqli_fetch_array($result7)){
    $objPHPExcel->setActiveSheetIndex(7)
            ->setCellValue('A'.$i, $fila['id'])
            ->setCellValue('B'.$i, $fila['name'])
            ->setCellValue('C'.$i, $fila['email'])
            ->setCellValue('D'.$i, $fila['tel'])
            ->setCellValue('E'.$i, $fila['date_created'])
            ;
    $i++;
}
// Add some data
$objPHPExcel->setActiveSheetIndex(7)
            ->setCellValue('A1', 'USUARIOS REGISTRADOS')
            ->setCellValue('A3', 'Codigo')
            ->setCellValue('B3', 'Nombre')
            ->setCellValue('C3', 'Correo')
            ->setCellValue('D3', 'Telefono')
            ->setCellValue('E3', 'Fecha de creacion')
            ;
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Repuestos');
for($i = 'A'; $i <= 'D'; $i++){
                $objPHPExcel->setActiveSheetIndex(7)->getColumnDimension($i)->setAutoSize(TRUE);
            }
            $objPHPExcel->getActiveSheet(7)->freezePaneByColumnAndRow(0,4);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(7);













$objPHPExcel->setActiveSheetIndex(0);

// Redirect output to a client’s web browser (Excel2007)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="Autolarte.xlsx"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed
header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header ('Pragma: public'); // HTTP/1.0

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;

This is the error that comes out:

And it is by memory since when I remove some of the tables it already downloads it well.

In cakephp they told me that there was something that did it but in pure mysql I don't know how to do it.

class PostsController extends AppController {

    public $components = array('Paginator');

    public $paginate = array(
        'limit' => 25,
        'order' => array(
            'Post.title' => 'asc'
        )
    );
}

Hello I am using this library https://phpspreadsheet.readthedocs.io/en/develop/

and I want to add a date and time filter that looks like this:

and in the DB the info is in the next structure: 2018-06-19 12:13:21but when you put it in the cell it reads it as text and not as a date

what have i tried?

$worksheet->setCellValue('I'.$i, $user->created);
$this->longitudCeldas('I', $user->created,  $worksheet);

$worksheet->getCell('I'.$i)->setValueExplicit("'".$user->created."'",\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC);

If I add the previous line, it reads it as a number, so I think the solution is on this side.

$worksheet->getStyle('I'.$i)->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME);

I have this js, and this html:

$(document).on('click', '.validar', function (event) {
        event.preventDefault();
        var cantidad = 0;

        var obj = {
            "correo": $(".txtEmail").attr("id")
        };
        $.each(obj, function (identificador, value) {
            cantidad = ($.onlyData("#" + value));
            if (cantidad > 0) {
                toastr["error"]("Este " + identificador + " ya se encuentra registrado!");
            } else {
                $("#msform").submit();
            }
        });
    });

<div class="modal fade" id="modalNewClient" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
    <div class="modal-content">
        <div class="modal-header">
            <h5 class="modal-title" id="exampleModalLabel">Nuevo cliente</h5>
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
            </button>
        </div>
        <div class="modal-body">
            <?php
            echo $this->Form->create('Client', array('class' => '', 'id' => 'msform'));
            ?>
            <div class="input-group">
                <?php
                echo $this->Form->input('contact', array('label' => array('text' => " "),
                    'placeholder' => 'Danos tu nombre', 
                    "required" => "true", 
                    "minlength" => "5", 
                    "maxlength" => "", 
                    'class' => 'form-control-custom color-input validLength txtContact lang prettyName', 
                    'key' => 'txtContact'));
                ?>
            </div>
            <div class="input-group">
                <?php
                echo $this->Form->input('company', array('label' => array('text' => " "),
                    'placeholder' => '¿Para que marca vamos a trabajar?', "required" => "true", 
                    "minlength" => "3", 
                    "maxlength" => "",
                    'data-sql' => "company-Client",
                    'class' => 'form-control-custom color-input validLength txtClient lang prettyName', 
                    'key' => 'txtClient'));
                ?>
            </div>
            <div class="input-group mb-3">
                <?php
                echo $this->Form->input('email', array('label' => array('text' => " "),
                    'placeholder' => 'Correo electronico', 
                    "data-DB" => "email", 
                    "required" => "true", 
                    "minlength" => "5", 
                    'data-sql' => "username-User",
                    "maxlength" => "", 
                    'class' => 'form-control-custom color-input validLength prettyName txtEmail lang validEmail', 
                    'key' => 'txtEmail'));
                ?>
            </div>
            <div class="input-group mb-3">
                <?php
                echo $this->Form->input('phone', array('label' => array('text' => " "),
                    'placeholder' => 'Celular', "minlength" => "7", "required" => "true", "maxlength" => "10", 'class' => 'form-control-custom color-input validLength txtPhone blockLetter lang', 'key' => 'txtPhone'));
                ?>
            </div>
            <?php echo $this->Form->end(array('label' => 'Guardar cliente', 'class' => 'validar')) ?>
        </div>
    </div>
</div>

The thing is that this js, validates if a field already exists in the DB, but I don't know if there is any way to activate the automatic validations of html5 from the js, on the internet I found this: $("#elemento").checkValidity(); but it didn't work, I was thinking of something $("#formId").checkRequired();or something like that, but I couldn't find anything

Those are the html5 validations and what I want is to activate them from jquery, that is, with some function to tell it to do the validations that html5 normally does when giving a submit

Hello I have the following jquery function

  (function ($) { 
$.onlyData = function (id) {
        var respuesta;
        var datos =$(id).data("sql");
        datos=datos.split("-")
        var campoBD = datos[0];
        var tableModel = datos[1];
        var arr = $(id).val();
        var parametros = {
            "Field": {
                "Data": arr
            }
        };
        $.ajax({
            data: parametros,
            url: '/Desarrollo/consultar_existencia/' + campoBD + "/" + tableModel,
            type: 'post',
            dataType: "json",
            success: function (response) {
                console.log(response);
                respuesta=(response);
            },
            error: function (jqXHR, textStatus, errorThrown) {
                console.log(jqXHR);
            }
        });

        return "chap"+respuesta;
    }
})(jQuery);

And when I click a button

enter here:

var unico = 0;
        alert($.onlyData("#" + $(".txtEmail").attr("id")));

but the alert arrives like this:

and I need the ajax response for a validation and the thing is that the console does show the response bn:

public function consultar_existencia($campo) {
        if ($this->request->is('post')) {
            $this->autoRender = false;
            $this->layout = false;
            $this->loadModel('Client');
            $existe = $this->Client->find('count', array(
                'conditions' => array($campo => $this->request->data('Field')['Data'])));
        }
        echo json_encode($existe);
    }

Hi, I have this function in the controller, I'm going to use it to check if a data already exists in the database, the idea is to make some changes, but I've had some problems, I'm going to show you:

public function consultar_existencia($campo)//field is for the field that is going to be compared in the DB, and the idea would also be to send the model to the one that is going to be consulted by adding something like $modelin the parameters, and in this line it would be loaded like this: $this->loadModel($model);, and through there I think that We would go well, the problem comes in this line:

$existe = $this->Client->find('count', array(
                    'conditions' => array($campo => $this->request->data('Field')['Data']))); 

since in that line a specific model is called, and my question is, is there any way to tell it to consult the currently loaded model? Something like

$this->getLoadModel()->find('count',  array(
                    'conditions' => array($campo => $this->request->data('Field')['Data']))); 

I have a web page to which I created the translation function, but I created some alternative pages which are loaded by js, it does not translate and I do not know why.

Those pages are cakephp templates, I really don't think that affects it.

These are the codes:

(function ($) {
 $.traducir = function () {
        $('.lang').each(function (index, element) {

            if ($(this).attr('key').indexOf("txt") === 0) {
                $(this).attr("placeholder", arrLang[lang][$(this).attr('key')]);
            } else if ($(this).attr('key').indexOf("btn") === 0) {
                $(this).val(arrLang[lang][$(this).attr('key')]);
            } else if ($(this).attr('key').indexOf("img") === 0) {
                $(this).attr("alt", arrLang[lang][$(this).attr('key')]);
            } else {
                $(this).text(arrLang[lang][$(this).attr('key')]);
            }
            alert(arrLang[lang][$(this).attr('key')]);
        });
    }

})(jQuery);

That is the function to translate:

(function ($) {
$.mostrar = function (id) {
        $.wizard(0, id);
        $(".xMenu").removeClass("cerrarMenu");
        $(".menuContenido").removeClass("verMenu");
        $(".xMenu").removeClass("mostrarElemento");
        $(".xMenu").addClass("ocultarElemento");
        $(".circle").css({"z-index": "100"});
        if ($("#div" + id).attr("id") !== $('div.principal').children('div').attr("id")) {
            $(".principal").css({'position': 'absolute'});
            $(".secundario").css({'position': 'absolute', "left": "1500px"});

            $(".principal").height($(window).height() - 100);
            $(".principal").width($(window).width() - 100);
            $(".secundario").height($(window).height() - 100);
            $(".secundario").width($(window).width() - 100);
            $(".principal").animate({
                left: "-=1500",
                width: "100%",
                opacity: "toggle"
            }, {
                duration: 2000,
                queue: false
            });
            $(".secundario").animate({
                left: "-=1480",
                width: "100%",
                opacity: "toggle"
            }, {
                duration: 2000,
                queue: false
            }).promise().done(function () {
                $(".principal").css({'position': '', 'left': '20px', 'display': ''});
                $(".principal").height("");
                $(".principal").width("");
                $(".principal").html($(".secundario").html());
                $(".secundario").height("");
                $(".secundario").width("");
                $(".secundario").css({'left': '1500px', 'position': '', 'display': ''});
                $(".secundario").hide();
                $(".secundario").html("");
            });
        }
        $.wizard(1, id);
        url = (id === "Home") ? "" : "Form/"+id;
        window.history.pushState("", "", '/Desarrollo/' + url);
    }
 })(jQuery);

This is the function with which I show one divthat is a template and hide another:

$(document).ready(function () {
    $(".linkMenuHome").on('click', function (event) {
        event.preventDefault();
        $('.secundario').load(this.href);
        $.mostrar("Home");
    });
    $(".linkMenuNeeds").on('click', function (event) {
        event.preventDefault();
        $('.secundario').load(this.href);
$.traducir();
        $.mostrar("Needs");

    });
});

There it is supposed to translate but it doesn't.

I was sent the following sketches, and the colors of the images change when the menu is opened.

As you can see there the images of the social networks and contact us is fuchsia.

But when the menu is opened the colors change to white, I know I can change by loading different images but they ask me with styles, and I don't know how I do it without using photoshop...

Good morning I have a problem I created the administrator user but the page does not work for me, here are the codes:

These codes are copied from the cake book 2.x

If I do this it works fine:

App::uses('Controller', 'Controller');
    class AppController extends Controller {
          public $components = array(
            'Session' ,
             'Auth' => array(
                 'loginRedirect' => array('controller' => 'users', 'action' => 'index'),
                 'logoutRedirect' => array('controller' => 'users', 'action' => 'login')
             )
          );

          public function beforeFilter() {
              $this->Auth->allow('index', 'view');
          }
    }

The thing is that it asks me from the main page and that is not what I want, if my main page is Index , I want it to ask me in Idex/Admin

These are the codes that I have UsersController

<?php

// app/Controller/UsersController.php

App::uses('AppController', 'Controller');

class UsersController extends AppController {

    // app/Controller/UsersController.php

    public function beforeFilter() {
        parent::beforeFilter();
        // Allow users to register and logout.
        $this->Auth->autoRedirect = false;
    }

    public function login() {
        if ($this->request->is('post')) {
            if ($this->Auth->login()) {
                return $this->redirect($this->Auth->redirectUrl());
            } else {
                $this->Session->setFlash(__('Invalid username or password, try again'));
            }
        }
    }

    public function logout() {
        return $this->redirect($this->Auth->logout());
    }

    public function index() {
        $this->User->recursive = 0;
        $this->set('users', $this->paginate());
    }

    public function view($id = null) {
        $this->User->id = $id;
        if (!$this->User->exists()) {
            throw new NotFoundException(__('Invalid user'));
        }
        $this->set('user', $this->User->findById($id));
    }

    public function add() {
        if ($this->request->is('post')) {
            $this->User->create();
            if ($this->User->save($this->request->data)) {
                $this->Session->setFlash(__('The user has been saved'));
                return $this->redirect(array('action' => 'index'));
            }
            $this->Session->setFlash(
                    __('The user could not be saved. Please, try again.')
            );
        }
    }

    public function edit($id = null) {
        $this->User->id = $id;
        if (!$this->User->exists()) {
            throw new NotFoundException(__('Invalid user'));
        }
        if ($this->request->is('post') || $this->request->is('put')) {
            if ($this->User->save($this->request->data)) {
                $this->Session->setFlash(__('The user has been saved'));
                return $this->redirect(array('action' => 'index'));
            }
            $this->Session->setFlash(
                    __('The user could not be saved. Please, try again.')
            );
        } else {
            $this->request->data = $this->User->findById($id);
            unset($this->request->data['User']['password']);
        }
    }

    public function delete($id = null) {
        // Prior to 2.5 use
        // $this->request->onlyAllow('post');

        $this->request->allowMethod('post');

        $this->User->id = $id;
        if (!$this->User->exists()) {
            throw new NotFoundException(__('Invalid user'));
        }
        if ($this->User->delete()) {
            $this->Session->setFlash(__('User deleted'));
            return $this->redirect(array('action' => 'index'));
        }
        $this->Session->setFlash(__('User was not deleted'));
        return $this->redirect(array('action' => 'index'));
    }

}

user model

<?php
App::uses('AppModel', 'Model');

class User extends AppModel {
    public $validate = array(
        'id' => array(
            'rule' => 'notBlank'
        ),
        'user' => array(
            'required' => array(
                'rule' => 'notBlank',
                'message' => 'A username is required'
            )
        ),
        'key' => array(
            'required' => array(
                'rule' => 'notBlank',
                'message' => 'A password is required'
            )
        ),
        'rol' => array(
            'valid' => array(
                'rule' => array('inList', array('admin', 'author')),
                'message' => 'Please enter a valid role',
                'allowEmpty' => false
            )
        ),
        'created' => array(
            'rule' => 'notBlank'
        )
    );
}

login view

//app/View/Users/login.ctp

<div class="users form">
<?php echo $this->Session->flash('auth'); ?>
<?php echo $this->Form->create('User'); ?>
    <fieldset>
        <legend>
            <?php echo __('Please enter your username and password'); ?>
        </legend>
        <?php echo $this->Form->input('username');
        echo $this->Form->input('password');
    ?>
    </fieldset>
<?php echo $this->Form->end(__('Login')); ?>
</div>

I even routed to see if with that I could do what I mentioned in www.../admin but that doesn't do it.

Router::connect('/admin', array('controller' => 'Users', 'action' => 'display', 'Users/login'));

This is how it works, but if the AppController document stays like this:

App::uses('Controller', 'Controller');
class AppController extends Controller {
//      public $components = array(
//        'Session' ,
//         'Auth' => array(
//             'loginRedirect' => array('controller' => 'users', 'action' => 'index'),
//             'logoutRedirect' => array('controller' => 'users', 'action' => 'login')
//         )
//      );
//      
//      public function beforeFilter() {
//          $this->Auth->allow('index', 'view');
//      }
}

ps this comes out:

Ps this is the index as it should be, now if I go to www.../admin Now siven in admin pulls that up, and even though it brings up errors it brings up the default layout and I want to change it or at least not show me the menu (stripes on the right side) ps that menu is only for new customers

I have the following question: how to convert this basic php code to cakephp:

Controller

public function politics_index($active_pill = null)
{
    $this->layout = 'politics';
    $user = $this->Auth->user();

    $doctor = $user['Doctor'];
    $doctorId = $user['Doctor']['id'];

    if ($this->request->is('post')) {
        $link = mysqli_connect("localhost", "bd", "user", "clave");

            // Check connection
            if($link === false){
                //echo("ERROR: Could not connect. " . mysqli_connect_error());
            }

            // Attempt update query execution
            $sql = "UPDATE doctors SET acepto='Si' WHERE id=$doctorId";
            if(mysqli_query($link, $sql)){
                echo "<div hidden>respuestaAceptoDoctorQueIngreso=Si</div>";
            } else {
                echo "<div hidden>respuestaAceptoDoctorQueIngreso=No</div>";
            }

            // Close connection
            mysqli_close($link);
        //mysqli_close($conexion);
    } 
    else {
        $link = mysqli_connect("localhost", "bd", "user", "clave");

        mysql_select_db("interqui_web",$conexion);
        $sql = "SELECT * FROM doctors where id=$doctorId";
        if($result = mysqli_query($link, $sql)){
            $row = mysqli_fetch_array($result);
            $acepto=$row['acepto'] ;
            if($acepto==="Si"){
                echo "<div hidden>respuestaAceptoDoctorQueIngreso=Si</div>";
            } else {
                echo "<div hidden>respuestaAceptoDoctorQueIngreso=No</div>";
            }
        }
        mysqli_close($link);
    }

}

Model

class Doctor extends AppModel {
  public $belongsTo = array('Doctitle');
    public $hasAndBelongsToMany = array(
        'Education' =>
            array(
                'className' => 'Specialty',
                'joinTable' => 'doctor_education',
                'foreignKey' => 'doctor_id',
                'associationForeignKey' => 'specialty_id',
                'unique' => true,
            ), 
    );

    public $validate = array(
        'name' => array(
            'rule' => 'notBlank'
            ),
        'image' => array(
            'rule' => array(
              'isValidMimeType', 
               array('image/jpeg', 'image/png', 'image/gif'),
               false
            ),
            'allowEmpty' => true,
            'message' => 'File is not an image',
        ), 
    );



    /* using the upload plugin */
     public $actsAs = array(
        'Upload.Upload' => array(
            'image' => array(
              'path' => '{ROOT}webroot{DS}img{DS}uploads{DS}',
                'thumbnailSizes' => array(
                    'thumb' => '150w'
                ),
              // uncoment next if "imagick not found"
              'thumbnailMethod' => 'php', 
            ),             
        )
    );

}

?>

Ajax

$(document).ready(function () {
$("input[type=checkbox]").on( "click", function(){
    if( $('.input-check-borrado').is(':checked') ) {
        var parametros = {
            "doctorName" : $(".doctorTitle").text(),
            "loActivo" : "Si"
        };
        console.log($(".doctorTitle").text());
        $.ajax({
            data:  parametros,
            url:   '/politics/config',
            type:  'post',
            /*dataType: "json",*/
            beforeSend: function () {
                    $("#resultado").html("Procesando, espere por favor...");
            },
            success:  function (response) {
                    if(response.indexOf("respuestaAceptoDoctorQueIngreso=Si")> -1){
                        $('input.input-check-borrado').attr("disabled", true);
                    }
                    else {
                        $("input.group1").removeAttr("disabled");
                    }
            }
        });
    }
});});

If you detailed yourself in the ajax, I have a documented line, it's because I don't know how to return a simple yes or no by json encode, ps when receiving it in the ajax the response was empty, I don't know if you know what I'm missing ps I had the data type of the js in 'json' and in the controller string json_encode("yes"); at first i thought i had to return an array so i returned the $user variable which i know is an array

I have a little problem, actually there are two but I think I can't ask two questions on this same page.

I am not creating a new button, on one page, I literally copied it from another and the changes do not work, here I show you the codes:

Codes of the button on which I am basing ConfigController.php

public function assesor_index($active_pill = null)
    {
        $this->layout = 'assesor';

        $user = $this->Auth->user();

        $doctor = $user['Doctor'];

        $pendings = $this->AppointmentUser->find('all', array(
            'conditions' => array('appointment_state_id' => '1', 'doctor_id' => $user['Doctor']['id']),
            'order' => array('date_created DESC')));
        $appointments = $this->AppointmentUser->find('all', array(
            'conditions' => array('appointment_state_id' => '2', 'doctor_id' => $user['Doctor']['id']),
            'order' => array('date_created DESC')));
        $effectives = $this->AppointmentUser->find('all', array(
            'conditions' => array('appointment_state_id' => '3', 'doctor_id' => $user['Doctor']['id']),
            'order' => array('date_created DESC')));
        $todoctor = $this->AppointmentUser->find('all', array(
            'conditions' => array('appointment_state_id' => '4', 'doctor_id' => $user['Doctor']['id']),
            'order' => array('date_created DESC')));
        $noteffective = $this->AppointmentUser->find('all', array(
            'conditions' => array('appointment_state_id' => '5', 'doctor_id' => $user['Doctor']['id']),
            'order' => array('date_created DESC')));

        $this->set(compact('appointments', 'pendings', 'effectives', 'todoctor', 'doctor', 'noteffective', 'active_pill'));
    }

Here is located the menu which is in elements and is called assessor_menu.ctp, the second li was the one I created, and I based on the first to create it but it doesn't work

<li>
        <?php
            echo $this->Html->link('<div><i class="fa fa-user-md fa-fw"></i> Consultas </div>', 
                            array('controller' => 'config', 'action' => 'index', 'assesor' => true), 
                            array('escape' => false));
        ?>
        </li>
           <li>
        <?php
            echo $this->Html->link('<div class="clickPoliticasWeb"><i class="fa fa-user-md fa-fw"></i> Politicas del sitio web</div>', 
                            array('controller' => 'config', 'action' => 'index', 'politics' => true), 
                            array('escape' => false));
        ?>
        </li>
        <li>
                <?php
                    echo $this->Html->link('<i class="fa fa-sign-out fa-fw"></i> Salir', 
                            array('controller' => 'users', 'action' => 'logout', 'admin' => true), 
                            array('escape' => false)
                    );
                ?>
                </li>

The strange thing is that in the source code you can see another path The path should be policies/config ps the one for the button that already existed is assessor/config

Layouts: Assesors.ctp and Politics.ctp for now have the same thing, but Politics doesn't load for me, it's as if it couldn't find it. The only difference is that I put an input text on one of the two, and if that input is in politics it doesn't show it, if it's in advisors, ps if it shows it.

<?php



$pageDescription = __d('seadog_base', 'SEADOG Base');
$pageName = __d('seadog_base', 'IQ Administración');
?>

<!DOCTYPE html>
<html lang="es-ES">
<head>
    <?php echo $this->Html->charset(); ?>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <title>
        <?php echo $pageName.' :'; ?>
        <?php echo $title_for_layout; ?>
    </title>

    <?php 
        echo $this->Html->meta('keywords','SEADOG, dessign, creativity, lab, Endor inc');
        echo $this->Html->meta('description', 'Seadog base template');
        echo $this->Html->meta('language', 'es');

        echo $this->Html->meta('favicon.ico', '/img/favicon.ico', array('type' => 'icon')); 

        /* CSS */
        echo $this->Html->css(array(
            'bootstrap.min',
            'metisMenu.min',
            'admin', 
            'https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css',
        ));

        /* JS */
        echo $this->Html->script(array(
            'jquery.min',   
             '../ckeditor/ckeditor', '../ckeditor/config', /* ckeditor */ 
        ));
        //this is loaded at the end of the page.
        echo $this->Html->script(array(
            'metisMenu.min',
            'bootstrap.min',
            'admin', 
            ), array('async' => 'async', 'block' => 'scriptBottom') 
        );

        echo $this->fetch('meta');
        echo $this->fetch('css');
        echo $this->fetch('script');
    ?>

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->

</head>

<body>

<div id="wrapper">

    <!-- Navigation -->
    <?php echo  $this->element('assesor_menu'); ?>

    <!--nocache-->  
    <!-- display session messaging -->
    <div id="flassMessage" class="container">
        <?php $flashMessage = $this->Session->flash();
            if($flashMessage){
                echo '<div class="alert alert-warning alert-dismissable">
                                 <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>';
                echo $flashMessage;
                echo '</div>';  
            }

            $flash_auth = $this->Session->flash('auth'); 
            if($flash_auth){
                echo '<div class="alert alert-warning alert-dismissable">
                                 <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>';
                echo $flash_auth;
                echo '</div>';
            }
        ?>
    </div> <!-- end flash -->
    <!--/nocache-->     

    <!-- display page content -->
    <input type="text" name="vlr">
    <?php echo $this->fetch('content'); ?>

</div> <!-- end wrapper -->

<?php echo $this->fetch('scriptBottom'); //header scripts ?>    
<?php echo $this->element('sql_dump'); ?>
<?php echo $this->Js->writeBuffer(); // Write cached scripts ?>


</body>
</html>

policy controller

public function politics_index($active_pill = null)
    {
        $this->set(compact());
    }

photo change 1:

It's like when trying to enter:

 <a href="/politics/config"><div><i class="clickPoliticasWeb fa fa-user-md fa-fw"></i> Politicas del sitio web</div></a>        </li>

wont let me

I have two attributes in the html, but one is above the other and I want the one above to be the other.

I'll show you the photo

This is how it should stay

That's how it goes

Code

Default.ctp (Menu)

<div class="menuPrincipal">
                    <div class="">
                        <button class="dropbtn">Dropdown</button>                  
                        <div class="menuContenido">
                            <a href="#" class="separador"></a>
                            <a href="#" class="separador"></a>
                            <a href="#" class="separador"></a>
                            <a href="#" class="linkMenuHome separador lang" key="linkHome">Laboratorio estratégico</a>
                            <a href="#" class="linkMenuNeeds separador lang" key="linkNeeds">Descubrir necesidades</a>
                            <a href="#" class="linkMenuStrategies separador lang" key="linkStrategies">Definir estrategias</a>
                            <a href="#" class="linkMenuTools separador lang" key="linkTools">Herramientas</a>
                            <a href="#" class="linkMenuExecution separador lang" key="linkExecution">Ejecución</a>
                            <a href="#" class="linkMenuResults separador lang" key="linkResults">Resultados</a>
                            <a href="#" class="linkMenuExplore separador lang" key="linkExplore">Explora resultados</a>
                            <a href="#" class="linkMenuTeam separador lang" key="linkTeam">Equipo Seadog</a>
                            <a href="#" class="linkMenuContact separador lang" key="linkContact">Contáctenos</a>
                        </div>
                    </div>
                </div>

Default.ctp(wizard/circles)

<div class="circle" style="cursor: pointer;">
                    <ul class="nav navbar-nav navbar-right">
                        <li class="linkBrowserHome activado scroller">
                        </li>
                        <li class="linkBrowserNeeds desactivado scroller">
                        </li>
                        <li class="linkBrowserStrategies desactivado scroller">
                        </li>
                        <li class="linkBrowserTools desactivado scroller">
                        </li>
                        <li class="linkBrowserExecution desactivado scroller">
                        </li>
                        <li class="linkBrowserResults desactivado scroller">
                        </li>
                    </ul>
                </div>

myStyle.css(menu)

.separador{
    margin-left: 500px;
    margin-right: 150px;
    margin-top: 5px;
    float: right;
    font-size: 25px;
}
.menuOpciones{
    cursor: pointer;
    height: 870px;
    width: 700px;
    opacity: 0.96;
}
.dropbtn {
    background-color: #4CAF50;
    color: white;
    padding: 16px;
    font-size: 16px;
    border: none;
    cursor: pointer;
    /*margin-left: 890px;*/
    margin-left: 600px;
    position: absolute;
}
.menuContenido {
    /*display: none;*/
    position: absolute;
    background-color: #E42090;
    min-width: 160px;
    /*box-shadow: -20px 1px 16px 0px rgba(0,0,0,0.2);*/
    z-index: 1;
    left: 50%;
    top: -100px;
    width: 960px;
    height: 923px;
    opacity: 0.96;
}
.menuContenido a {
    color: #f5BDD6;
    padding: 12px 16px;
    text-decoration: none;
    display: block;
}

.menuPrincipal{
    position: absolute;
    left: 40%;  

}
.menuContenido a:hover {
    /*background-color: greenyellow*/
    color: #fffeff;
    text-decoration: none;
}

.menuPrincipal:hover .menuContenido {
    display: block;
}
.menuPrincipal:hover .dropbtn {
    /*background-color: brown;*/
}

myStyle.css(wizard/circles)

.circle {
    background-color: transparent;
    position: fixed;
    top: 90%;
    right: 60%;
    z-index: 200;
}
.circle ul{
    list-style: none;
    cursor:pointer; 
    cursor: hand;
    display: inline-block;

}
.circle ul li {
    float: none;
    content: '';
    position: relative;
    float: left;
    width: 15px;
    height: 15px;
    border-radius: 15px;
    background-color: #FEFEFE;
    margin: 20px 30px;
    z-index: 10;
    border: solid 1px #B7B7B7;
    left: 50%;
    box-sizing: content-box;
}
.desactivado:hover {
    -webkit-transform:scale(1.3);transform:scale(1.3);
}

.activado{
    box-shadow: 0 0 0em 13px #EA0B8C;
}

PS: how do I publish with online execution? I've seen some people do it

I use boootstrap 4, cakephp 2 and I don't know what version of js

I explain the problem, the user fills out the form and if he presses f5 or refreshes the page, the data he has just entered is re-inserted exactly the same, one of the options would be to validate that the id is not repeated, but in this case it is not valid since it is an autoincrement.

View

<div class="col-md-6">
    <?php
    echo $this->Form->create('Need', array('class' => '', 'id' => 'msform'));
    ?>
    <label class="lang" key="h1NeedForm">Aprovechemos el tiempo y comencemos</label>
    <?php
    echo $this->Form->input('client', array('label' => array('text' => "¿Para que marca vamos a trabahar?",
            'key' => 'lblClient', 'class' => 'lang'), 'placeholder' => 'Dinos el nombre de tu empresa',
        'class' => 'validador txtClient lang', 'key' => 'txtClient'));
    echo $this->Form->input('need', array('label' => array('text' => "Escríbenos acerca de tu necesidad",
            'key' => 'lblNeed', 'class' => 'lang'), 'placeholder' => 'Agradecemos nos detalles muy bien la necesidad, '
        . 'es nuestro punto de partida para generar ideas quer fortalezcan la estrategia para resolverla.',
        'rows' => '4', 'class' => 'validador txtNeed lang', 'key' => 'txtNeed', 'style' => 'resize: none;'));
    echo $this->Form->input('objective', array('label' => array('text' => "¿Cuál es el objetivo?",
            'key' => 'lblObjective', 'class' => 'lang'), 'placeholder' => 'Que se quiere alcanzar con la'
        . 'solución de la necesidad, ¿Adquirir usuario? ¿Mejorar ventas? ¿Posicionar la marca? ... entre otros.'
        . ' Agradecemos nos detalles muy bien el objetivo.', 'rows' => '4',
        'class' => 'validador txtObjective lang', 'key' => 'txtObjective', 'style' => 'resize: none;'));
    ?>
    <?php
    $options = array(
        'class' => 'lang',
        'label' => 'Enviar y continuar',
        'key' => 'btnFormNeed'
    );
    echo $this->Form->end($options);
    ?>
</div>

Controller

 public function home() {
        if ($this->request->is('post'))
        { 
             if(!empty($this->request->data))
             {
                $this->Flash->error(__("Emty"));
                $this->loadModel('Need');
                $this->Need->create();
                if ($this->Need->save($this->request->data)) {
                    $this->Need->save(array(
                            'date' => date("Y/m/d")
                        ));
                   //$this->request->data = array(); este código me lo sugirieron pero no hacia absolutamente nada 
                    return false;
                }
            }
            else{
                 $this->Flash->error(__("No empty"));
            }
        }
        else {
            $this->Flash->error(__("Sino post"));
        }
    }

Previously I had this code in the controller inside the home function and it always entered through the post

//return false;
     // 
     /*unset($post);
     if($this->request->is('redirect')){
        $this->Flash->error(__("redirect"));
        return false;
     }
     else if($this->request->is('get')){
         $this->Flash->error(__("get"));
        return false;
     }
     else if($this->request->is('post')){
 $this->Flash->error(__("post")); //siempre entraba p
        return false; 
     }*/
     // 

Full ModelNeed.php

   App::uses('AppModel', 'Model');
class Need extends AppModel {
    public $validate = array(
        'client' => array(
            'rule' => 'notBlank'
        ),
        'date' => array(
            'rule' => 'notBlank'
        ),
        'id' => array(
            'rule' => 'notBlank'
        ),
        'need' => array(
            'rule' => 'notBlank'
        ),
        'objective' => array(
            'rule' => 'notBlank'
        ),
        'process' => array(
            'rule' => 'notBlank'
        )
    );
}

routes.php

Router::connect('/Practica', array('controller' => 'pages', 'action' => 'home', 'home'));
Router::connect('/pages/*', array('controller' => 'pages', 'action' => 'display'));
CakePlugin::routes();
require CAKE . 'Config' . DS . 'routes.php';

I'm going to share the routes, the controller function, the model, the form, and an image of the repeated data in the database.

I was researching on the internet and I saw that the same thing happened in Laravel, that the form was forwarded, but for cake I did not find a solution but I know there must be one, I am working on version 2.x but next week I will migrate my data to the 3.x

Thanks for all the help given.

PS: I have attached all the controller and the deafult, although I don't think they will interfere, I am going to paste them in case they serve to answer my problem.

pagecontroller.php

    <?php
/**
 * Static content controller.
 *
 * This file will render views from views/pages/
 *
 * CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 * @link          https://cakephp.org CakePHP(tm) Project
 * @package       app.Controller
 * @since         CakePHP(tm) v 0.2.9
 * @license       https://opensource.org/licenses/mit-license.php MIT License
 */
App::uses('AppController', 'Controller');
/**
 * Static content controller
 *
 * Override this controller by placing a copy in controllers directory of an application
 *
 * @package       app.Controller
 * @link https://book.cakephp.org/2.0/en/controllers/pages-controller.html
 */
class PagesController extends AppController {
    /**
     * This controller does not use a model
     *
     * @var array
     */
    public $helpers = array('Html', 'Form', 'Flash', 'Js' => array('Jquery'));
    public $components = array('Flash', 'RequestHandler');
    public function index() {
        $this->set('posts', $this->Post->find('all'));
    }  
    public function prueba(){
        return "hola";
    }    
    public function home() {        
     //return false;
     // 
     /*unset($post);
     if($this->request->is('redirect')){
        $this->Flash->error(__("redirect"));
        return false;
     }
     else if($this->request->is('get')){
         $this->Flash->error(__("get"));
        return false;
     }
     else if($this->request->is('post')){
 $this->Flash->error(__("post"));
        return false;
     }*/
     // 
        //return false;
        if ($this->request->is('post'))
        {
                          if(!empty($this->request->data))
             {
                $this->Flash->error(__("Emty"));
                $this->loadModel('Need');

                $this->Need->create();
                if ($this->Need->save($this->request->data)) {
                    $this->Need->save(array(
                            'date' => date("Y/m/d")
                        ));                    
                    return false;                                      
                }
            }
            else{
                 $this->Flash->error(__("No empty"));
            }
        }
        else {
 $this->Flash->error(__("Sino post"));
        }
    }
        public function fullClient() {

        if ($this->request->is('post')) {
            //        $information = $this->data['Cliente']['informacio'];
            $client = $this->data['Client']['cliente'];
            $user = $this->data['Client']['usuario'];
            $password = $this->data['Client']['clave'];
            $password = password_hash($password, PASSWORD_DEFAULT);
            //$posicion_coincidencia = strrpos($cadena_de_texto, $cadena_buscada, -20);
//        $this->Flash->error(__($hola));
            $this->loadModel('Client');
            $consult = $this->Client->find('count', array(
                'fields' => array('usuario'),
                'conditions' => array('usuario LIKE ' => $user)));
//            $aaa= $aaa['Client'];
            if ($consult == 0) {
                $this->Client->create();
                if ($this->Client->save($this->request->data)) {
                    $this->Client->save(array(
                        'rol' => 'Cliente',
                        'clave' => $password
                    ));
                    $consult = $this->Client->find('all', array(
                        'fields' => array('usuario'),
                        'conditions' => array('usuario LIKE ' => $user)));
                    $id_client = $consult[0];
                    $this->loadModel('Need');
                    $data = array(
                        array('procesos_id' => 11112,
                            'clientes_id' => $id_client['Client']['usuario'],
                            'fecha' => date("Y/m/d")),
                    );
                    $this->Need->saveMany($data);
                    $this->Need->save();
                    //$this->loadModel('Need');
//                $this->Need->create();
//                $this->Need->save($data);
                    $this->Flash->error(__('Your informatio was save'));
                    return $this->request->data;
                }
                $this->Flash->error(__('Your informatio wasn`t save'));
            } else {
                $this->Flash->success(__("El nombre de usuario que elgiste ya existe"));
            }
          }
    }
    public $uses = array();
    /**
     * Displays a view
     *
     * @return CakeResponse|null
     * @throws ForbiddenException When a directory traversal attempt.
     * @throws NotFoundException When the view file could not be found
     *   or MissingViewException in debug mode.
     */
    public function display() {
        $path = func_get_args();
        $count = count($path);
        if (!$count) {
            return $this->redirect('/');
        }
        if (in_array('..', $path, true) || in_array('.', $path, true)) {
            throw new ForbiddenException();
        }
        $page = $subpage = $title_for_layout = null;

        if (!empty($path[0])) {
            $page = $path[0];
        }
        if (!empty($path[1])) {
            $subpage = $path[1];
        }
        if (!empty($path[$count - 1])) {
            $title_for_layout = Inflector::humanize($path[$count - 1]);
        }
        $this->set(compact('page', 'subpage', 'title_for_layout'));

        try {
            $this->render(implode('/', $path));
        } catch (MissingViewException $e) {
            if (Configure::read('debug')) {
                throw $e;
            }
            throw new NotFoundException();
        }
    }
}

Default.ctp

 <?php
/**
 * CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 * @link          https://cakephp.org CakePHP(tm) Project
 * @package       app.View.Layouts
 * @since         CakePHP(tm) v 0.10.0.1076
 * @license       https://opensource.org/licenses/mit-license.php MIT License
 */
$cakeDescription = __d('cake_dev', 'Seadog Creative Labs');
$cakeVersion = __d('cake_dev', 'CakePHP %s', Configure::version());
?>
<!DOCTYPE html>
<!--<html oncontextmenu="return false"> -->
<html>
    <head>
        <?php echo $this->Html->charset(); ?>
        <title>
            <?php echo $cakeDescription ?>:
            <?php echo $this->fetch('title'); ?>
        </title>
        <?php
        echo $this->Html->meta('icon', '/favicon.ico', ['type' => 'image/ico']);
        echo $this->Html->meta(['name' => 'robots', 'content' => 'noindex']);
        echo $this->Html->meta(['name' => 'googlebot', 'content' => 'noindex']);
        echo $this->Html->meta(['http-equiv' => 'Pragma', 'content' => 'no-cache']);
        echo $this->Html->css('navigatePage');
        echo $this->Html->css('myStyle');
        echo $this->Html->css('bootstrap.min'); //problema
        echo $this->Html->css('bootstrap-datepicker3'); //problema
//        echo $this->Html->css('reset.min');
//        echo $this->Html->css('bootstrap-formhelpers.min');
        echo $this->Html->css('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.6.2/css/bootstrap-select.min.css');
        echo $this->Html->css('https://cdnjs.cloudflare.com/ajax/libs/flag-icon-css/0.8.2/css/flag-icon.min.css');
//        echo $this->Html->css('jquery.timepicker.min');
        echo $this->Js->writeBuffer();
        echo $this->fetch('css');
        echo $this->fetch('script');
        ?>
    </head>
    <body>
        <div id="container">

            <div id="header">
                <div class="circle" style="cursor: default;">
                    <ul class="navbar-right">
                        <li>
                            <a class="active linkBrowserHome"><span></span></a> 
                        </li>
                        <li>
                            <a class="linkBrowserNeeds"><span></span></a>
                        </li>
                        <li>
                            <a class="linkBrowserStrategies"><span></span></a>
                        </li>
                        <li>
                            <a class="linkBrowserTools"><span></span></a>
                        </li>
                        <li>
                            <a class="linkBrowserExecution"><span></span></a>
                        </li>
                        <li>
                            <a class="linkBrowserResults"><span></span></a>
                        </li>
                    </ul>
                </div>
                <br>
                <div class="navbar-header">
                    <a class="navbar-brand" href="#">
                        <?php
                        echo $this->Html->image('cont-.png', array('alt' => '',
                            "width" => "100", "height" => "25", 'title' => 'h'));
                        ?>
                    </a>
                </div>
                <div class="navbar-collapse navbar-ex1-collapse in" style="height: auto;">
                    <ul class="nav navbar-nav navbar-right">
                        <li class="dropdown">
                            <a href="#" class="dropdown-toggle glyphicon glyphicon-list-alt" data-toggle="dropdown">
                                <b class="caret"></b>
                            </a>
                            <ul class="dropdown-menu" style="cursor: pointer;">
                                <li><a class="linkMenuHome" key="linkHome">Laboratorio estratégico</a></li>
                                <li><a class="linkMenuNeeds" key="linkNeeds">Descubrir necesidades</a></li>
                                <li><a class="linkMenuStrategies" key="linkStrategies">Definir estrategias</a></li>
                                <li><a class="linkMenuTools" key="linkTools">Herramientas</a></li>
                                <li><a class="linkMenuExecution" key="linkExecution">Ejecución</a></li>
                                <li><a class="linkMenuResults" key="linkResults">Resultados</a></li>
                                <li class=""></li>
                                <li><a class="linkMenuExplore lang" key="linkExplore">Explora resultados</a></li>
                                <li class=""></li>
                                <li><a class="linkMenuTeam lang" key="linkTeam">Equipo</a></li>
                                <li class="divider"></li>
                                <li><a class="linkMenuContact lang" key="linkContact">Contáctenos</a></li>
                            </ul>
                        </li>
                    </ul>
                </div>
                <br>
            </div>
            <div id="content">
                <?php
                $here = $this->request->here(true);
                if (strpos($here, "?") !== false) {
                    $hola = explode('?', $here);
                    $hola[1] = str_replace('=', '', $hola[1]);
                    if (strpos($hola[1], 'publicidad') !== false) {
                        echo "publicidad";
                    } else if (strpos($hola[1], 'marca') !== false) {
                        echo "Marca";
                    } else if (strpos($hola[1], 'experiencia') !== false) {
                        echo "Experiencia de usuario";
                    }
                } else {
                    echo "";
                }
                ?>
                <?php echo $this->Flash->render(); ?>
                <?php echo $this->fetch('content'); ?>
                                <select class="selectpicker" data-width="fit">
                    <option  data-content='<span class="flag-icon flag-icon-co" value="es"></span> Español'>Español</option>
                    <option data-content='<span class="flag-icon flag-icon-us" value="en"></span> English'>English</option>
                </select>
                <?php // echo $this->Html->script('jquery.timepicker.min'); ?>
                <?php echo $this->Html->script('jquery-3.3.1'); ?>
                <?php echo $this->Html->script('bootstrap.min'); ?>
                <?php // echo $this->Html->script('bootstrap-datepicker.min'); ?>
                <?php echo $this->Html->script('myScript'); ?>
                <?php // echo $this->Html->script('jquery.easing.min'); ?>
                <?php //echo $this->Html->script('bootstrap-formhelpers.min'); ?>
                <?php echo $this->Html->script('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.6.2/js/bootstrap-select.min.js'); ?>
                <?php echo $this->Html->script('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.6.2/js/bootstrap-select.min.js'); ?>
            </div>
            <div id="footer">
                <div class="form-inline row">

                    <div class="form-group col-xs-6 col-sm-3 col-md-3">
                        <br/>
                        <?php // echo $this->Html->link($cakeDescription, '#');    ?>
                        <ul id="menu" class="navlist">
                            <li class="contenedor">
                                Social network:
                            </li>
                            <li onclick="window.open('https://www.facebook.com', '_blank');" class="contenedor">
                                <img src="https://www.google.com/s2/favicons?domain=https://facebook.com" title="Facebook" class="imagen"/>
                            </li>
                            <li onclick="window.open('https://www.instagram.com', '_blank');" class="contenedor">
                                <img src="https://www.google.com/s2/favicons?domain=https://instagram.com" title="Instagram" class="imagen"/>
                            </li>
                            <li onclick="window.open('https://www.linkedin.com', '_blank');" class="contenedor">
                                <img src="https://www.google.com/s2/favicons?domain=https://linkedin.com" title="Linkedin" class="imagen"/>
                            </li>
                        </ul>
                    </div>
                    <div class="form-group col-xs-6 col-sm-3 col-md-3">
                        <br/>
                        <a  class="tip">
                            <label>
                                Designed by
                            </label>
                            <span class="by">
                                Leader:
                                Brand:
                                Communication:
                                Development:
                            </span>
                        </a>
                    </div>
                    <div class="form-group col-xs-6 col-sm-3 col-md-3">
                    </div>
                </div>
            </div>
        </div>
        <?php echo $this->element('sql_dump'); //muestra consultas sql ?>
    </body>
</html>

I'm creating a dropdown menu and it doesn't show me, I don't know why, look here the code: 

Default.ctp

<?php
/**
 * CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
 * Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
 * @link          https://cakephp.org CakePHP(tm) Project
 * @package       app.View.Layouts
 * @since         CakePHP(tm) v 0.10.0.1076
 * @license       https://opensource.org/licenses/mit-license.php MIT License
 */
$cakeDescription = __d('cake_dev', 'Seadog Creative Labs');
$cakeVersion = __d('cake_dev', 'CakePHP %s', Configure::version());
?>
<!DOCTYPE html>
<!--<html oncontextmenu="return false"> -->
<html>
    <head>
        <?php echo $this->Html->charset(); ?>
        <title>
            <?php echo $cakeDescription ?>:
            <?php echo $this->fetch('title'); ?>
        </title>
        <?php
        echo $this->Html->meta('icon', '/favicon.ico', ['type' => 'image/ico']);
        echo $this->Html->meta(['name' => 'robots', 'content' => 'noindex']);
        echo $this->Html->meta(['name' => 'googlebot', 'content' => 'noindex']);
        echo $this->Html->meta(['http-equiv' => 'Pragma', 'content' => 'no-cache']);



        echo $this->Html->css('navigatePage');
        echo $this->Html->css('myStyle');
        echo $this->Html->css('bootstrap.min'); //problema
        echo $this->Html->css('bootstrap-datepicker3'); //problema
//        echo $this->Html->css('reset.min');
//        echo $this->Html->css('bootstrap-formhelpers.min');

        echo $this->Html->css('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.6.2/css/bootstrap-select.min.css');
        echo $this->Html->css('https://cdnjs.cloudflare.com/ajax/libs/flag-icon-css/0.8.2/css/flag-icon.min.css');

//        echo $this->Html->css('jquery.timepicker.min');

        echo $this->Js->writeBuffer();

        echo $this->fetch('css');
        echo $this->fetch('script');
        ?>
    </head>
    <body>
        <div id="container">

            <div id="header">
                hola

                <div class="dropdown">
                    <button class="btn dropdown-toggle sr-only" type="button"
                            id="dropdownMenu1" data-toggle="dropdown">
                        Menú desplegable
                        <span class="caret"></span>
                    </button>

                    <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu1">
                        <li role="presentation">
                            <a role="menuitem" tabindex="-1" href="#">Acción</a>
                        </li>
                        <li role="presentation">
                            <a role="menuitem" tabindex="-1" href="#">Otra acción</a>
                        </li>
                        <li role="presentation">
                            <a role="menuitem" tabindex="-1" href="#">Otra acción más</a>
                        </li>
                        <li role="presentation" class="divider"></li>
                        <li role="presentation">
                            <a role="menuitem" tabindex="-1" href="#">Acción separada</a>
                        </li>
                    </ul>
                </div>
            </div>

            <div id="content">


                <?php
                $here = $this->request->here(true);
                if (strpos($here, "?") !== false) {
                    $hola = explode('?', $here);
                    $hola[1] = str_replace('=', '', $hola[1]);
                    if (strpos($hola[1], 'publicidad') !== false) {
                        echo "publicidad";
                    } else if (strpos($hola[1], 'marca') !== false) {
                        echo "Marca";
                    } else if (strpos($hola[1], 'experiencia') !== false) {
                        echo "Experiencia de usuario";
                    }
                } else {
                    echo "";
                }
                ?>
                <?php echo $this->Flash->render(); ?>
                <?php echo $this->fetch('content'); ?>
                <div class="scroll-pointer hidden-sm hidden-xs">
                    <ul class="nav navbar-nav">
                        <li>
                            <?= $this->Html->link('<span>Home</span>', '#', ['escape' => false, 'class' => 'scrollable ']);
                            ?>
                        </li>
                        <li>
                            <?= $this->Html->link('<span>Menu1</span>', '#Necesidades', ['escape' => false, 'class' => 'scrollable ']);
                            ?>
                        </li>

                        <li>
                            <?= $this->Html->link('<span>Menu2</span>', '#Estrategias', ['escape' => false, 'class' => 'scrollable ']);
                            ?>
                        </li> 
                        <li>
                            <?= $this->Html->link('<span>Menu3</span>', '#Herramientas', ['escape' => false, 'class' => 'scrollable ']);
                            ?>
                        </li> 
                        <li>
                            <?= $this->Html->link('<span>Menu4</span>', '#Ejecucion', ['escape' => false, 'class' => 'scrollable ']);
                            ?>
                        </li> 
                        <li>
                            <?= $this->Html->link('<span>Menu5</span>', '#Resultados', ['escape' => false, 'class' => 'scrollable ']);
                            ?>
                        </li> 
                    </ul>
                </div>


                <?php // echo $this->Html->script('jquery.timepicker.min'); ?>
                <?php echo $this->Html->script('jquery-3.3.1'); ?>
                <?php echo $this->Html->script('bootstrap.min'); ?>
                <?php // echo $this->Html->script('bootstrap-datepicker.min'); ?>
                <?php echo $this->Html->script('myScript'); ?>
                <?php // echo $this->Html->script('jquery.easing.min'); ?>
                <?php //echo $this->Html->script('bootstrap-formhelpers.min'); ?>

                <?php echo $this->Html->script('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.6.2/js/bootstrap-select.min.js'); ?>
                <?php echo $this->Html->script('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.6.2/js/bootstrap-select.min.js'); ?>



            </div>

            <div id="footer">
                <div class="form-inline row">
                    <select class="selectpicker" data-width="fit">
                        <option  data-content='<span class="flag-icon flag-icon-co" value="es"></span> Español'>Español</option>
                        <option data-content='<span class="flag-icon flag-icon-us" value="en"></span> English'>English</option>
                    </select>

                    <div class="form-group col-xs-6 col-sm-3 col-md-3">
                        <br/>
                        <?php // echo $this->Html->link($cakeDescription, '#');    ?>
                        <ul id="menu" class="navlist">
                            <li class="contenedor">
                                Social network:
                            </li>
                            <li onclick="window.open('https://www.facebook.com/seadoglabs', '_blank');" class="contenedor">
                                <img src="https://www.google.com/s2/favicons?domain=https://facebook.com" title="Facebook" class="imagen"/>
                            </li>
                            <li onclick="window.open('https://www.instagram.com/seadoglabs', '_blank');" class="contenedor">
                                <img src="https://www.google.com/s2/favicons?domain=https://instagram.com" title="Instagram" class="imagen"/>
                            </li>
                            <li onclick="window.open('https://www.linkedin.com/company/seadog-creative-labs', '_blank');" class="contenedor">
                                <img src="https://www.google.com/s2/favicons?domain=https://linkedin.com" title="Linkedin" class="imagen"/>
                            </li>
                        </ul>
                    </div>
                    <div class="form-group col-xs-6 col-sm-3 col-md-3">
                        <br/>
                        <a  class="tip">
                            <label>
                                Designed by
                            </label>
                            <span class="by">
                                Leader:
                                Brand:
                                Communication:
                                Development:
                            </span>
                        </a>
                    </div>
                    <div class="form-group col-xs-6 col-sm-3 col-md-3">

                    </div>
                </div>
            </div>
        </div>
        <?php echo $this->element('sql_dump'); //muestra consultas sql ?>
    </body>
</html>

I don't know why it doesn't show anything

I want to know how to do the following:

When the page comes from google, I want to change the page if the page is found from the google search engine, and show another if the url is entered manually