Home / user-68448

Pedro's questions

Martin Hope
Pedro
Asked: 2020-10-17 19:55:59 +0800 CST
  • 5

I am doing a simple exercise but it shows me some error icons

enter image description here

Can you explain to me what is being done wrong, I am following all the correct steps, I do not observe that there are code syntax errors.

This is the code

package exampleswitch;

import javax.swing.*;

public class ExampleSwitch {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        char cuestionario;
        cuestionario = 'Tema:';
        int semana;
        semana = 1;

        switch(semana){
            case 1:
                cuestionario += 'Introducción a la programación';
                break;
            case 2:
                cuestionario += 'Secuenciación y selección';
        }

    }

}
java
Martin Hope
Pedro
Asked: 2020-01-09 19:22:22 +0800 CST
  • 2

I have the paypal payment form

<form name="form1" method="https://www.sandbox.paypal.com/cgi-bin/webscr">
<!-- Resto de input -->

<!-- Botón que ejecuta el direccionamiento al pago paypal-->

<input type="submit" value="paypal sandbox">

</form>

But I want to execute this inputtype from another action, I have a link outside the form ( ) so what I want to achieve is that when I click on the following link:submitform

<a class="checkout" onclick="proceso(2)">Continuar</a>

This executes the following action:

<input type="submit" value="paypal sandbox">

using jQuery or another control.

html5
Martin Hope
Pedro
Asked: 2020-01-02 08:50:11 +0800 CST
  • 1

This would be my biggest problem of all the work that I have been doing in updating my code in prepared statements in object-oriented procedures MySQLi.

Because when using prepared statements, the queries and those procedures are very different from normal.

For example, when wanting to pass one mysqli_real_escape_stringto oneUPDATE

$query = " UPDATE tbl_employee   
               SET name='$name',   
               address='$address',   
               gender='$gender',   
               designation = '$designation',   
               age = '$age'   
               WHERE id='".$_POST["employee_id"]."'";  
               $message = 'Data Updated';

The replacement of this if(mysqli_query($con, $query))to the sentencing procedure.

Despite being recently updated on these procedures, I have not had any major problems, perhaps it is because they are small queries without many derivatives of it.

How do I update this code correctly, explaining a little about its changes and applied procedures.

if(!empty($_POST))  
 {  
      $output = '';  
      $message = '';  
      $name = mysqli_real_escape_string($con, $_POST["name"]);  
      $address = mysqli_real_escape_string($con, $_POST["address"]);  
      $gender = mysqli_real_escape_string($con, $_POST["gender"]);  
      $designation = mysqli_real_escape_string($con, $_POST["designation"]);  
      $age = mysqli_real_escape_string($con, $_POST["age"]);  
      if($_POST["employee_id"] != '')  
      {  
           $query = "  
           UPDATE tbl_employee   
           SET name='$name',   
           address='$address',   
           gender='$gender',   
           designation = '$designation',   
           age = '$age'   
           WHERE id='".$_POST["employee_id"]."'";  
           $message = 'Data Updated';  
      }  
      else  
      {  
           $query = "  
           INSERT INTO tbl_employee(name, address, gender, designation, age)  
           VALUES('$name', '$address', '$gender', '$designation', '$age');  
           ";  
           $message = 'Data Inserted';  
      }  
      if(mysqli_query($con, $query))  
      {  
           $output .= '<label class="text-success">' . $message . '</label>';  
           $select_query = "SELECT * FROM tbl_employee ORDER BY id DESC";  
           $result = mysqli_query($con, $select_query);  
           $output .= '  
                <table class="table table-bordered">  
                     <tr>  
                          <th width="70%">Employee Name</th>  
                          <th width="15%">Edit</th>  
                          <th width="15%">View</th>  
                     </tr>  
           ';  
           while($row = mysqli_fetch_array($result))  
           {  
                $output .= '  
                     <tr>  
                          <td>' . $row["name"] . '</td>  
                          <td><input type="button" name="edit" value="Edit" id="'.$row["id"] .'" class="btn btn-info btn-xs edit_data" /></td>  
                          <td><input type="button" name="view" value="view" id="' . $row["id"] . '" class="btn btn-info btn-xs view_data" /></td>  
                     </tr>  
                ';  
           }  
           $output .= '</table>';  
      }  
      echo $output;  
 }  
 ?>
php
Martin Hope
Pedro
Asked: 2020-01-01 19:08:20 +0800 CST
  • 1

In this procedure, it only returns numeric values ​​if it exists, that is, if it exists, it returns a value true+ 1row, but it does not return the registered data from the database to ajax.

fetch.php code:

 if(isset($_POST["employee_id"]))  {
    $stmt = $con->prepare("SELECT name,address,gender,designation,age FROM tbl_employee WHERE id = '".$_POST["employee_id"]."' ");
    $stmt->execute();
    $stmt->store_result();
    $stmt->bind_result($name,$address,$gender,$designation,$age);

    while ($row = $stmt->fetch()) {

        echo json_encode($row);
    }

 }

Result:

enter image description here

As seen does not return any user data

Instead, with this procedure, it returns the registered data from the database.

fetch.php code:

 if(isset($_POST["employee_id"]))  { 
      $query = "SELECT * FROM tbl_employee WHERE id = '".$_POST["employee_id"]."'";  
      $result = mysqli_query($connect, $query);  
      $row = mysqli_fetch_array($result);  
      echo json_encode($row);  
 }

Result:

enter image description here

I carry out the var_dumpcode from A. Cedano's answer.

var_dump($arrResultado);

Result ofvar_dump

[{"name":"1","address":"1","gender":"Male","designation":"1"‌​,"age":1}]array(1) { [0]=> array(5) { ["name"]=> &string(1) "1" ["address"]=> &string(1) "1" ["gender"]=> &string(4) "Male" ["designation"]=> &string(1) "1" ["age"]=> &int(1) } }
php
Martin Hope
Pedro
Asked: 2020-12-27 19:40:16 +0800 CST
  • 7

I have made a small jQuery modal box popup script.

But noted that in the new jQuery version there are new changes, code that is already deprecated, how can I update jQuery 2.1to the version jQuery 3.2.1using the new ajax response methods doneand failinstead of the old usesuccess

Now in my code I have problems editing the user data, when I edit the user data instead of updating the edited user data what it does is add a new user instead of updating it.

enter image description here

Popup Modal Box ajax code

$(function() {
  //----- OPEN
  $('[data-modal-open]').on('click', function(e)  {
    $('#insert_form')[0].reset();
    var targeted_modal_class = jQuery(this).attr('data-modal-open');

    $('[data-modal="' + targeted_modal_class + '"]').fadeIn(350);
    e.preventDefault();
  });

  //----- CLOSE
  $('[data-modal-close]').on('click', function(e)  {
    var targeted_modal_class = jQuery(this).attr('data-modal-close');
    $('[data-modal="' + targeted_modal_class + '"]').fadeOut(350);

    e.preventDefault();
  });
});
  $(document).ready(function(){  
      $('#add').click(function(){  

                     $('#employee_id').val("");
           $('#insert_form')[0].reset();  
      });  
      $(document).on('click', '.edit_data', function(){ 

           var employee_id = $(this).attr("id");  
           $.ajax({  
                url:"fetch.php",  
                method:"POST",  
                data:{employee_id:employee_id},  
                dataType:"json",  
                success:function(data){  
                     $('#name').val(data.name);  
                     $('#address').val(data.address);  
                     $('#gender').val(data.gender);  
                     $('#designation').val(data.designation);  
                     $('#age').val(data.age);  
                     $('#employee_id').val(data.id);  
                     $('#insert').val("Update");  
                     $('[data-modal="add_data_modal"]').fadeIn(350);

      
                }  
           });  
      });  
      $('#insert_form').on("submit", function(event){  
           event.preventDefault();  

            $('[data-modal="add_data_modal"]').fadeOut(350);
      
           if($('#name').val() == "")  
           {  
                alert("Name is required");  
           }  
           else if($('#address').val() == '')  
           {  
                alert("Address is required");  
           }  
           else if($('#designation').val() == '')  
           {  
                alert("Designation is required");  
           }  
           else if($('#age').val() == '')  
           {  
                alert("Age is required");  
           }  
           else  
           {  
                $.ajax({  
                     url:"insert.php",  
                     method:"POST",  
                     data:$('#insert_form').serialize(),  
                     beforeSend:function(){  
                          $('#insert').val("Inserting");  
                     },  
                     success:function(data){  
                         
                          $('#insert_form')[0].reset();  
                              $('[data-modal="add_data_modal"]').fadeOut(350);

                          $('#employee_table').html(data);  
                     }  
                });  
           }  
      });  
      $(document).on('click', '.view_data', function(){  
           var employee_id = $(this).attr("id");  
           if(employee_id != '')  
           {  
                $.ajax({  
                     url:"select.php",  
                     method:"POST",  
                     data:{employee_id:employee_id},  
                     success:function(data){
                            $('[data-modal="empdetail"]').fadeIn(350);
                            $('#employee_detail').html(data);  
      
                     }  
                });  
           }            
      });  
 });
.content {
	max-width:800px;
	width:100%;
	margin:0px auto;
	margin-bottom:60px;
}

/* Outer */
.modal {
	width:100%;
	height:100%;
	display:none;
	position:fixed;
	top:0px;
	left:0px;
	right: 0;
	bottom: 0;
	background: rgba(0,0,0,0.2);
  z-index: 99999;
}

/* Inner */
.modal-inner {
	width: 500px;
	position: relative;
	margin: 10% auto;
	-webkit-border-radius: 5px;
	-moz-border-radius: 5px;
	border-radius: 5px;
	background: #fff;
}

/* Close Button */
.modal-close {
	width:30px;
	height:30px;
	padding-top:4px;
	display:inline-block;
	position:absolute;
	top:0px;
	right:0px;
	transition:ease 0.25s all;
	-webkit-transform:translate(50%, -50%);
	transform:translate(50%, -50%);
	border-radius:1000px;
	background:rgba(0,0,0,0.8);
	font-family:Arial, Sans-Serif;
	font-size:20px;
	text-align:center;
	line-height:100%;
	color:#fff;
}

.modal-close:hover {
	-webkit-transform:translate(50%, -50%) rotate(180deg);
	transform:translate(50%, -50%) rotate(180deg);
	background:rgba(0,0,0,1);
	text-decoration:none;
}
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<div class="container" style="width:700px;">  
                <h3 align="center">PHP Ajax Update MySQL Data Through Bootstrap Modal</h3>  
                <br />  
                <div class="table-responsive">  
                     <div align="right">  
                          <button type="button" name="add" id="add" data-toggle="modal" data-modal-open="add_data_modal" class="btn btn-warning">Add</button>  
                     </div>  
                     <br />  
                     <div id="employee_table">  
                          <table class="table table-bordered">  
                               <tr>  
                                    <th width="70%">Employee Name</th>  
                                    <th width="15%">Edit</th>  
                                    <th width="15%">View</th>  
                               </tr>  
                                <?php  
                               while ($stmt->fetch()) {
                               ?>  
                               <tr>  
                                    <td><?php echo $name; ?></td>  
                                    <td><input type="button" name="edit" value="Edit" id="<?php echo $id; ?>" class="btn btn-info btn-xs edit_data" /></td>  
                                    <td><input type="button" name="view" value="view" id="<?php echo $id; ?>" class="btn btn-info btn-xs view_data" /></td>  
                               </tr>  
                               <?php  
                               }  
                               ?>    
                          </table>  
                     </div>  
                </div>  
           </div>  
      </body>  
 </html>  
  
<div id="dataModal" class="modal" data-modal="empdetail">  
      <div class="modal-inner">  
           <div class="modal-content">  
                <div class="modal-header">  
                      <a class="modal-close" data-modal-close="empdetail" href="#">x</a>
                     <h4 class="modal-title">Employee Details</h4>  
                </div>  
                <div class="modal-body" id="employee_detail">  
                </div>  
                <div class="modal-footer">  
                     <button type="button" class="btn btn-default" data-modal-close="empdetail">Close</button> 

                </div>  
           </div>  
      </div>  
 </div>  
 <div id="add_data_Modal" class="modal"  data-modal="add_data_modal">  
      <div class="modal-inner">  
           <div class="modal-content">  
                <div class="modal-header">  
                      <a class="modal-close" data-modal-close="add_data_modal" href="#">x</a>

                     <h4 class="modal-title">PHP Ajax Update MySQL Data Through Bootstrap Modal</h4>  
                </div>  
                <div class="modal-body">  
                     <form method="post" id="insert_form">  
                          <label>Enter Employee Name</label>  
                          <input type="text" name="name" id="name" class="form-control" />  
                          <br />  
                          <label>Enter Employee Address</label>  
                          <textarea name="address" id="address" class="form-control"></textarea>  
                          <br />  
                          <label>Select Gender</label>  
                          <select name="gender" id="gender" class="form-control">  
                               <option value="Male">Male</option>  
                               <option value="Female">Female</option>  
                          </select>  
                          <br />  
                          <label>Enter Designation</label>  
                          <input type="text" name="designation" id="designation" class="form-control" />  
                          <br />  
                          <label>Enter Age</label>  
                          <input type="text" name="age" id="age" class="form-control" />  
                          <br />  
                          <input type="hidden" name="employee_id" id="employee_id" />  
                          <input type="submit" name="insert" id="insert" value="Insert" class="btn btn-success" />  
                     </form>  
                </div>  
                <div class="modal-footer">  
                     <button type="button" class="btn btn-default" data-modal-close="add_data_modal" href="#">Close</button>  
                </div>  
           </div>  
      </div>  
 </div>

php
Martin Hope
Pedro
Asked: 2020-12-20 18:07:06 +0800 CST
  • 5

I have designed a loader but how do I make it animate?

.mask {
    width: 100%;
    height: 100%;
    position: fixed;
    background: #fff;
    top: 0px;
    left: 0px;
    z-index: 99999;
}

.loader {
    width: 44px;
    height: 44px;
    text-align: center;
    line-height: 44px;
    margin: 23% auto 0 auto;
    font-size: 12px;
}

.spinner {
    border: 2px solid #eeeeee;
    font-size: 40px;
    width: 1em;
    height: 1em;
    border-radius: .5em;
    -webkit-box-sizing: border-box;
    -moz-box-sizing: border-box;
    box-sizing: border-box;
    -webkit-animation: spin 1s linear infinite;
    -moz-animation: spin 1s linear infinite;
    animation: spin 1s linear infinite;
}

.spinner {
    border-top-color: #417b03;
}
<div class="mask" style="display: block;">
  <div class="loader">
    <div class="spinner"></div>
     Procesando...
  </div>
</div>

css3
Martin Hope
Pedro
Asked: 2020-12-16 18:37:57 +0800 CST
  • 6

I found a design of some stars here . How to create three stars plus one middle star without :hover?

I'm using the same design, only the smaller stars, when changing the image to smaller ones, the design has been messed up despite having changed the values, I can't get it to be ordered correctly.

What value should I change so that it adapts in the same way as that design, only that the stars are smaller.

.c-rating {
    display: -webkit-box;
    display: -webkit-flex;
    display: -ms-flexbox;
    display: flex;
    list-style: none;
    margin: 0;
    padding: 0;
}

.c-rating__item {
    -webkit-box-flex: 0;
     -webkit-flex: 0 0 12px;
    -ms-flex: 0 0 12px; 
    flex: 0 0 12px;
    height: 18px;
    background-position: -10px 0px;
    background-image: url(http://svgshare.com/i/4U0.svg);
    cursor: pointer;
}
.c-rating__item.left {
    background-position: 0px 0px;
}
.c-rating__item.is-active,
.c-rating__item:before {
    background-position: -33px 0;
}
.c-rating__item.left.is-active,
.c-rating__item.left:before {
    background-position: -21px 0;
}
<ul class="c-rating">
  <li class="c-rating__item is-active left" data-index="0"></li>
  <li class="c-rating__item is-active" data-index="1"></li>
  <li class="c-rating__item is-active left" data-index="2"></li>
  <li class="c-rating__item is-active" data-index="3"></li>
  <li class="c-rating__item is-active left" data-index="4"></li>
  <li class="c-rating__item is-active" data-index="5"></li>
  <li class="c-rating__item is-active left" data-index="6"></li>
  <li class="c-rating__item" data-index="7"></li>
  <li class="c-rating__item left" data-index="8"></li>
  <li class="c-rating__item" data-index="9"></li>
</ul>

html