J. Medina's questions

I have 4 <ul>which have uneven content, I am trying to fit the 4 lists to a single size

html code of the page and the styles that I am adding

#planes {
  padding-top: 47px;
  background-color: rgba(208, 207, 207, 1);
}

.our_planes {
  padding: 71px 0 78px;
  background-color: #fff
}

span.separator {
  border: 0;
  border-top: 1px solid #999;
  border-bottom: 1px solid #333;
  height: 1px;
  padding: 0;
}

ul li a.i1,
ul li a.i2 {
  font-size: larger;
  font-weight: 600;
}

ul li.active a.i1,
ul li.active a.i2 {
  border: 1.5px solid #059279 !important;
  border-bottom: #0000 !important;
}

.sngl_pricing ul {
  /* border : #b4b4b4 solid 5px; */
  margin: 0;
  padding: 0;
  transition: all 1s ease 0s;
  -moz-transition: all 1s ease 0s;
  -webkit-transition: all 1s ease 0s
}

@media {}

.sngl_pricing ul li {
  color: #666666;
  font-family: sans-serif;
  font-size: 14px;
  list-style: none outside none;
  text-transform: capitalize;
  /* border-top : 2px solid #b4b4b4; */
  padding: 7px 0;
  text-align: center;
  font-weight: 550;
}

.sngl_pricing ul li:first-child {
  border-top: 0;
}

.our_planes .nav-tabs {
  border-bottom: 2px solid #105089;
}

.our_planes .nav-tabs>li {
  margin-bottom: -2px;
}

.sngl_pricing {
  text-align: center;
  /* border : #b4b4b4 solid 5px; */
  margin-bottom: 5px;
}

#web-dev .sngl_pricing:hover {
  border: #03c5c3 solid 5px;
  transition: all 1s ease 0s;
  -moz-transition: all 1s ease 0s;
  -webkit-transition: all 1s ease 0s
}

#social .sngl_pricing:hover {
  border: #7303a9 solid 5px;
  transition: all 1s ease 0s;
}

.sngl_pricing>h2 {
  color: #fff;
  font-size: 20px;
  font-weight: 500;
  margin: 0;
  padding: 10px;
  text-transform: uppercase;
  /* background-color: #059279; */
  /* background-image : url("../images/clean_code_bg.jpg"); */
}

.p_b_color {
  background-image: linear-gradient(to right bottom, #032bc5, #0064e5, #008ae5, #00a9d3, #03c5c3);
  background-color: none;
}

.s_b_color {
  background-image: linear-gradient(to left bottom, #7303a9, #6512b0, #541cb7, #3c24be, #032bc5);
  background-color: none;
}

div.ecommerce:hover {
  border-color: #008000;
}

.sngl_pricing>h2.ecommerce {
  background-color: #008000;
}

.title_bg_1 {
  background-image: url("../img/basic.jpg");
  ba;
  ckground-position: center center;
  background-repeat: no-repeat;
  background-size: 100% 100%;
}

.title_bg_2 {
  background-image: url("../img/standar.jpg");
  background-position: center center;
  background-repeat: no-repeat;
  background-size: 100% 100%;
}

.title_bg_3 {
  background-image: url("../img/extended.jpg");
  background-position: center center;
  background-repeat: no-repeat;
  background-size: 100% 100%;
}

.sngl_pricing>h3 {
  background: none 0 0 repeat scroll #b4b4b4;
  color: #515050;
  font-size: 33px;
  margin: 0;
  padding: 20px 0;
}

.currency {
  font-size: 18px;
  position: relative;
  top: -18px;
}

.monuth {
  font-size: 24px;
  text-transform: none;
}

.btn.pricing_btn {
  background: none 0 0 repeat scroll #105089;
  border: #666666 solid 1px;
  color: #fff;
  text-transform: uppercase;
  padding: 10px 30px;
}

.sngl_pricing ul {
  margin: 0;
  padding: 24px 0;
}

.sngl_pricing a {
  margin-top: 30px;
}

<link href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css" rel="stylesheet" />
<div id="web-dev" class="tab-pane fade in clearfix active">
  <h4 class="margtop20">Enlace su empresa a la web con nuestro servicio de desarrollo.</h4>

  <div class="col-xs-6 col-sm-6 col-md-3 col-lg-3">
    <div class="sngl_pricing">
      <h2 class="title_price p_b_color">Inicial</h2>

      <ul>
        <li>Plantilla Personalizada</li>
        <li>Hasta 3 páginas para contenido</li>
        <li>Nombre de dominio</li>
        <li>1000mb de hospedaje</li>
        <li>Integración de redes Sociales</li>
        <li>Responsive Design</li>
        <li>Formulario de Contacto</li>
        <li>Mantenimiento y Administración</li>
        <li>Publicación y Registro de la Web</li>
        <li>Correo Corporativo</li>
        <li>Publicación En Español</li>

        <li><a href="" class="margtopboton btn pricing_btn" data-toggle="modal" data-target="#p-i-form">Solicitar</a></li>
      </ul>
    </div>
  </div>

  <div class="col-xs-6 col-sm-6 col-md-3 col-lg-3">
    <div class="sngl_pricing">
      <h2 class="title_price p_b_color">Empresarial</h2>
      <ul>
        <li>Plantillas Personalizadas.</li>
        <li>8 páginas para contenido.</li>
        <li>Modulo de Registro.</li>
        <li>Nombre de dominio .com.ve</li>
        <li>2000mb de hospedaje.</li>
        <li>Integración de redes Sociales.</li>
        <li>Responsive Design.</li>
        <li>Formulario de Contacto.</li>
        <li>Mantenimiento y Administración.</li>
        <li>Publicación y Registro de la Web.</li>
        <li>Correo Corporativo.</li>
        <li>Autoadministrable.</li>
        <li>Publicación en Español.</li>
        <li><a href="" class="btn pricing_btn" data-toggle="modal" data-target="#p-e-form">Solicitar</a></li>

      </ul>
    </div>
  </div>
  <div class="col-xs-6 col-sm-6 col-md-3 col-lg-3">
    <div class="sngl_pricing">
      <h2 class="title_price p_b_color">Profesional</h2>

      <ul>
        <li>Plantillas Personalizadas.</li>
        <li>Multiples páginas para contenido</li>
        <li>Modulo administrativo y registro</li>
        <li>Nombre de dominio .com.ve</li>
        <li>3000mb de hospedaje</li>
        <li>Integración de redes Sociales</li>
        <li>Responsive Design</li>
        <li>Formulario de Contacto.</li>
        <li>Mantenimiento y Administración.</li>
        <li>Publicación y Registro de la Web.</li>
        <li>Correo Corporativo.</li>
        <li>Autoadministrable.</li>
        <li>Publicación En Ingles y Español.</li>
        <li><a href="" class="btn pricing_btn" data-toggle="modal" data-target="#p-p-form">Solicitar</a></li>
      </ul>
    </div>
  </div>
  <div class="col-xs-6 col-sm-6 col-md-3 col-lg-3">
    <div class="sngl_pricing ecommerce">
      <h2 class="title_price ecommerce">E-commerse</h2>
      <ul>
        <li>Plantillas Personalizadas.</li>
        <li> Sin limite de Productos.</li>
        <!-- <li>Modulo de Registro de Usuarios.</li> -->
        <li>Nombre de dominio .com.ve</li>
        <li>3000mb de hospedaje.</li>
        <li>Integración de redes Sociales.</li>
        <li>Responsive Design.</li>
        <li>Mantenimiento y Administración.</li>
        <li>Publicación y Registro de la Web.</li>
        <li>Correo Corporativo.</li>
        <li>Autoadministrable.</li>
        <li>Publicación en Español.</li>
        <li><a href="#" class="btn pricing_btn" data-toggle="modal" data-target="#model-web">Solicitar</a></li>

      </ul>
    </div>
  </div>

</div>
<!-- // WEB-DEV -->

Greetings, I have a problem. I am trying to enable Inputs as I select the checkbox, the problem is that the checkbox is displayed by a checkbox whilethat comes from the database. Below I show the code.

<div class="campo clearfix">
      <label for="herram" id="herra">Selecionar herramientas:</label><br/>
        <?php
          try {
            $sql = "SELECT * FROM herramienta";
            $res_herram = $conn->query($sql);
            $total_h = $res_herram->num_rows;
            $i = 0;
            while ($herram = $res_herram->fetch_assoc()) {
              echo '<div class="contenido_dia">';
            echo '<input type="checkbox" id='"checkh" . $herram['id_herra'] . ' name="herram[]"  value=' . $herram['id_herra'] . '> ' . $herram['nom_herra'] . " " ;
            echo '<input type="number" min="0" max="5" disabled="disabled" id='"canth". $herram['id_herra'] . ' size="1" name="herram_cant[]" placeholder="0">' . '<br/>';
            echo '</div>';
            $i++;
            }
          } catch (Exception $error) {
            echo "Error:" . $error->getMessage();
          }
        ?>
    </div>

I was trying with this javascript but I think this is going very wrong

for (var i = 0; i < 9; i++) {
$("#checkh" + i).change(function(){
var comentario = $( '#canth' +i, $(this).parents ('div'));
if( $(this.checked)){
  comentario.removeAttr('disabled');
  } else {
  comentario.attr('disabled', true);
  }
 });
}

I am doing my project to graduate, it is a web admin of works and I am looking for how to insert in the WORKS table the materials with the quantities (obras_cant)and the tools with their quantities (herra_cant), example: Gray paint-15 Gal, sand m2, emery 2 Unds. In this case "gray paint" I already bring it from the table materiales, as well as "emery" from the table herramientasto later show the works in lists with their materials and tools in pdf to be checked at the time of delivery. a teacher that it was better to do it by placing the LONGTEXT field and inserting everything with JSON so that it saves the one idfor each tool or material with its quantities respectively. but I have no idea how to do it. Until now I am showing the data to consult to select with checkbox ......

<?php include_once 'templates/header-internas.php';
require_once('funciones/bd_conexion.php');
?>
<section class="seccion contenedor">
<h2>Agregar Obra</h2>

<form action="validar_obras.php" class="login"  method="POST" id="obras">
    <div class="campo">
        <label for="obra">Nombre: </label>
            <input type="text" name="obra" id="obra" placeholder="Introducir obra">
    </div>
    <div class="campo">
        <label for="compra">Numero de Orden compra: </label>
            <input type="text" name="compra" id="compra" placeholder="Introducir">
    </div>
    <div class="campo">
      <label for="user">Supervisor a Cargo:</label>
        <?php
          try {

            $sql = "SELECT *  FROM usuarios WHERE status_id = 3 ";
            $res_user = $conn->query($sql);
            echo "<select name='user'>";
            while ($user = $res_user->fetch_assoc()) { ?>
              <option value="<?php echo $user['id_user'] ?> ">
                <?php echo $user['nombre_user'] . " " . $user['apellido_user']; ?>
              </option>
          <?php }
            echo "</select>";
          } catch (Exception $error) {
            echo "Error:" . $error->getMessage();
          }
        ?>
    </div>
    <div class="campo clearfix">
      <label for="client">Cliente </label>
        <?php
          try {

            $sql = "SELECT *  FROM clientes ";
            $res_client = $conn->query($sql);
            echo "<select name='client'>";
            while ($client = $res_client->fetch_assoc()) { ?>
              <option value="<?php echo $client['id'] ?> ">
                <?php echo $client['nom_cliente'] . " " . $client['planta']; ?>
              </option>
          <?php }
            echo "</select>";
          } catch (Exception $error) {
            echo "Error:" . $error->getMessage();
          }
        ?>
    </div>
    <div class="campo clearfix">
      <label for="herram">Selecionar herramientas:</label><br/>
        <?php
          try {

            $sql = "SELECT * FROM herramienta ";
            $res_herram = $conn->query($sql);
            while ($herram = $res_herram->fetch_assoc()) {
            echo '<input type="checkbox" name="herram[]"  value=' . $herram['id_herra'] . '> ' . $herram['nom_herra'] . " " ;
            echo '<input type="number" min="0" max="5" id="cant_herram" size="1" name="herram_cant" placeholder="0">' . '<br/>';
            }
          } catch (Exception $error) {
            echo "Error:" . $error->getMessage();
          }
        ?>
    </div>
    <div class="campo desplegable clearfix">
      <label for="mater">Selecionar materiales:</label><br/>
        <?php
          try {

            $sql = "SELECT * FROM materiales ";
            $res_mater = $conn->query($sql);
            while ($mater = $res_mater->fetch_assoc()) {
            echo '<label><input type="checkbox" name="mater[]"  value=' . $mater['id_mat'] . '> ' . $mater['nom_mat'] . " " ;
            echo '<input type="number" min="0" max="50" id="cant_mat" size="1" name="mat_cant[]" placeholder="0">' . '<br/>';
            }
          } catch (Exception $error) {
            echo "Error:" . $error->getMessage();
          }
        ?>
    </div>

    <div class="campo">
            <input type="submit" id="agregar" name="submit" class="button" value="Agregar">
    </div>
</form>

I need help with this:

   <?php
  error_reporting(E_ALL);
  ini_set('display_errors', '1');
   include_once 'includes/funciones/funciones.php';
  session_start();
   usuario_autenticado();
  if(isset($_POST['submit'])) {
      $nombre = $_POST['nombre'];
      $fecha = $_POST['fecha'];
      $hora = $_POST['hora'];
      $id_cat = $_POST['categorias'];
      $id_invitado = $_POST['invitado'];

      require_once('includes/funciones/bd_conexion.php');

      if ($conn){
        $strSQL="SELECT cat_evento, COUNT(DISTINCT nombre_evento) FROM eventos INNER JOIN categoria_evento ON eventos.id_cat_evento=categoria_evento.id_categoria WHERE id_cat_evento = ?";
        $stmt = $conn->prepare($strSQL);

        if ($stmt){
            $stmt->bind_param('i', $id_cat); //Si $id_cat es numérico debes cambiar la "s" por una "i"
            $stmt->execute();
            $stmt->bind_result($categoria_evento, $total);
            $stmt->store_result();
            $stmt->fetch();
            (int) $total = $total;
            $total++;
            $clave = substr($categoria_evento, 0, 5) . "_" . $total;
            echo $clave;
        }else{
          echo "Consulta errónea ".$stmt->error;
        }

    }else{

      echo "La conexión es nula";
    }

  }else{

     echo "No hay datos en submit";
  }

 ?>


 <?php include_once 'includes/templates/header.php'; ?>


                <section class="seccion contenedor">
                    <h2>Agregar Evento</h2>
                    <p>Bienvenido <?php echo $_SESSION['usuario']; ?> </p>

                <?php include_once 'includes/templates/admin-nav.php'; ?>

                <form class="invitado" action="agregar_evento.php" method="post">

                    <div class="campo">
                        <label for="nombre">Nombre Evento:</label>
                        <input type="text" name="nombre" id="nombre" placeholder="Nombre" required>
                    </div>
                    <div class="campo">
                        <label for="fecha">Fecha Evento:</label>
                        <input type="date" name="fecha" id="fecha" required>
                    </div>
                    <div class="campo">
                        <label for="hora">Hora Evento:</label>
                        <input type="time" name="hora" id="hora" required>
                    </div>
                    <div class="campo">
                      <label for="categoria">Categoria: </label><br>
                    <?php
                      try {
                        require_once('includes/funciones/bd_conexion.php');
                        $sql = "SELECT * FROM `categoria_evento`";
                        $res = $conn->query($sql);
                        while ($cat_eventos = $res->fetch_assoc()) {
                          echo '<input type="radio" name="categorias" value=' . $cat_eventos['id_categoria'] . '> ' . $cat_eventos['cat_evento'] . '<br/>';
                        }
                      } catch (Exception $e) {
                        echo "Error:" . $e->getMessage();
                      }
                      ?>
                    </div>

                    <div class="campo">
                      <label for="invitado">Invitado:</label>
                        <?php
                          try {
                            require_once('includes/funciones/bd_conexion.php');
                            $sql = "SELECT `invitado_id`, `nombre_invitado`, `apellido_invitado` FROM `invitados`";
                            $res_invitados = $conn->query($sql);
                            echo "<select name='invitado'>";
                            while ($invitados = $res_invitados->fetch_assoc()) { ?>
                              <option value="<?php echo $invitados['invitado_id'] ?> ">
                                <?php echo $invitados['nombre_invitado'] . " " . $invitados['apellido_invitado']; ?>
                              </option>
                          <?php }
                            echo "</select>";
                          } catch (Exception $e) {
                            echo "Error:" . $e->getMessage();
                          }
                        ?>
                    </div>

                  <div class="campo">
                    <input type="submit" name="submit" value="Agregar" class="button" >
                  </div>
                </form>


                <?php $conn->close(); ?>
                </section>


     <?php include_once 'includes/templates/footer.php'; ?>

this is the code without inserting your code

       <?php
  error_reporting(E_ALL);
  ini_set('display_errors', '1');
      include_once 'includes/funciones/funciones.php';
      session_start();
      usuario_autenticado();
  if(isset($_POST['submit'])):
    $nombre = $_POST['nombre'];
    $fecha = $_POST['fecha'];
    $hora = $_POST['hora'];
    $id_cat = $_POST['categorias'];
    $id_invitado = $_POST['invitado'];

    try {
      require_once('includes/funciones/bd_conexion.php');
      $stmt = $conn->prepare(" SELECT cat_evento, COUNT(DISTINCT nombre_evento) FROM eventos INNER JOIN categoria_evento ON eventos.id_cat_evento=categoria_evento.id_categoria WHERE id_cat_evento = ?");
      $stmt->bind_param('d', $id_cat);
      $stmt->execute();
      $stmt->bind_result($categoria_evento, $total);
      $stmt->store_result();
      $stmt->fetch();
      (int) $total = $total;
      $total++;
      $clave = substr($categoria_evento, 0, 5) . "_" . $total;
      echo $clave;

      header('Location:agregar_evento.php?exitoso=1');
    } catch (Exception $e) {
      echo "Error:" . $e->getMessage();
    } /**/
  endif;
  ?>

  <?php include_once 'includes/templates/header.php'; ?>


                      <section class="seccion contenedor">
                          <h2>Agregar Evento</h2>
                          <p>Bienvenido <?php echo $_SESSION['usuario']; ?> </p>

                      <?php include_once 'includes/templates/admin-nav.php'; ?>

                      <form class="invitado" action="agregar_evento.php" method="post">

                          <div class="campo">
                              <label for="nombre">Nombre Evento:</label>
                              <input type="text" name="nombre" id="nombre" placeholder="Nombre" required>
                          </div>
                          <div class="campo">
                              <label for="fecha">Fecha Evento:</label>
                              <input type="date" name="fecha" id="fecha" required>
                          </div>
                          <div class="campo">
                              <label for="hora">Hora Evento:</label>
                              <input type="time" name="hora" id="hora" required>
                          </div>
                          <div class="campo">
                            <label for="categorias">Categoria: </label><br>
                          <?php
                            try {
                              require_once('includes/funciones/bd_conexion.php');
                              $sql = "SELECT * FROM `categoria_evento`";
                              $res = $conn->query($sql);
                              while ($cat_eventos = $res->fetch_assoc()) {
                                echo '<input type="radio" name="categorias" value=' . $cat_eventos['id_categoria'] . '> ' . $cat_eventos['cat_evento'] . '<br/>';
                              }
                            } catch (Exception $e) {
                              echo "Error:" . $e->getMessage();
                            }
                            ?>
                          </div>

                          <div class="campo">
                            <label for="invitado">Invitado:</label>
                              <?php
                                try {
                                  require_once('includes/funciones/bd_conexion.php');
                                  $sql = "SELECT `invitado_id`, `nombre_invitado`, `apellido_invitado` FROM `invitados`";
                                  $res_invitados = $conn->query($sql);
                                  echo "<select name='invitado'>";
                                  while ($invitados = $res_invitados->fetch_assoc()) { ?>
                                    <option value="<?php echo $invitados['invitado_id'] ?> ">
                                      <?php echo $invitados['nombre_invitado'] . " " . $invitados['apellido_invitado']; ?>
                                    </option>
                                <?php }
                                  echo "</select>";
                                } catch (Exception $e) {
                                  echo "Error:" . $e->getMessage();
                                }
                              ?>
                          </div>

                        <div class="campo">
                          <input type="submit" name="submit" value="Agregar" class="button" >
                        </div>
                      </form>


                      <?php $conn->close(); ?>
                      </section>


      <?php include_once 'includes/templates/footer.php'; ?>

This is the error

Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in E:\Users\Bitnami\apache2\htdocs\gdlwebcamp\agregar_event.php:19 Stack trace: #0 {main} thrown in E:\Users\ Bitnami\apache2\htdocs\gdlwebcamp\add_event.php on line 19

phpMyadmin image
![query table]: https://photos.app.goo.gl/x15Yj7HcVLsKN1t13