Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.41 KB | None | 0 0
  1. $.post("car.php",
  2. {
  3. action: "cargar_stock",
  4. cajas_dulce_de_leche: CajaDulceDeLeche,
  5. cajas_fruta: CajaFruta
  6. },
  7. function(data){
  8. alert("Data: "+data);
  9. }
  10. );
  11.  
  12. <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
  13. <script type="text/javascript">
  14. function cargar_carga() {
  15.  
  16. var CajaDulceDeLeche = document.getElementById("cajaDl").value;
  17. var CajaFruta = document.getElementById("cajaFru").value;
  18.  
  19.  
  20. if ((CajaFruta != "") || (CajaDulceDeLeche != "")){
  21. $.post("car.php",
  22. {
  23. action: "cargar_stock",
  24. cajas_dulce_de_leche: CajaDulceDeLeche,
  25. cajas_fruta: CajaFruta
  26. },
  27. function(data){
  28. alert("Data: "+data);
  29. }
  30. );
  31. }
  32. else{
  33. alert("Debe ingresar al menos algun valor");
  34. }
  35. }
  36.  
  37. <label for="cajaDl">Dulce de Leche: </label>
  38. <input type="text" id="cajaDl" />
  39.  
  40. <label for="cajaFru">Fruta: </label>
  41. <input type="text" id="cajaFru" /><br/>
  42. <input type="button" id="botonRegCaja" value="Registrar" onclick="cargar_carga()"/>
  43.  
  44. <?php
  45. include_once('helpers.php');
  46. require_once("../some_libraries/config/db.php");
  47.  
  48. $port=3306;
  49. $socket="";
  50.  
  51. $con = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME, $port, $socket)
  52. or die ('Could not connect to the database server' . mysqli_connect_error());
  53.  
  54. if (isset($_POST['action']) && ($_POST['action'] != "")) {
  55. $action = $_POST['action'];
  56. if ($action == "cargar_stock") {
  57.  
  58. if (isset($_POST['cajas_dulce_de_leche']) && ($_POST['cajas_dulce_de_leche'] != "") &&
  59. isset($_POST['cajas_fruta']) && ($_POST['cajas_fruta'] != "")) {
  60.  
  61. $boxs_to_stock_caramel = $_POST['cajas_dulce_de_leche'];
  62. $boxs_to_stock_fruit = $_POST['cajas_fruta'];
  63.  
  64. $sql_stock = "SELECT `fruta`, `dulce` FROM `stock`";
  65. $result_query_stock = mysqli_query($con, $sql_stock);
  66.  
  67. if ($result_query_stock) {
  68.  
  69. $row_result = mysqli_fetch_array($result_query_stock);
  70.  
  71. $row_dulce_stock = $row_result['dulce'];
  72. $row_fruta_stock = $row_result['fruta'];
  73.  
  74. $total_boxes_caramel = $boxs_to_stock_caramel + $row_dulce_stock;
  75. $total_boxes_fruit = $boxs_to_stock_fruit + $row_fruta_stock;
  76.  
  77. $sql_update_stock = '"UPDATE `stock` SET `fruta`='.$total_boxes_fruit.',
  78. `dulce`='.$total_boxes_caramel.' WHERE id=1"';
  79.  
  80. $result_sql_update_stock = mysqli_query($con, $sql_update_stock);
  81.  
  82. if ($result_sql_update_stock) {
  83. $result_gral = "Stock actualizado";
  84. }
  85. else{
  86. $result_gral = "Problema con la consulta, stock no actualizado";
  87. }
  88. }
  89. else{
  90. $result_gral= "Problema al acceder a los datos del stock";
  91. }
  92.  
  93. }else{echo "no llego bien el post";}
  94. }
  95.  
  96. }
  97. echo $resul_gral;
  98. ?>
  99.  
  100. $.post("car.php",
  101. {
  102. action: "cargar_stock",
  103. cajas_dulce_de_leche: CajaDulceDeLeche,
  104. cajas_fruta: CajaFruta
  105. },
  106. function(data){
  107. alert("Data: "+data.alert);
  108. }, 'json'
  109. );
  110.  
  111. $varInfo['alert'] = 'Hello';
  112. exit(json_encode($varInfo));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement