<?php include './ConectorBaseDatos.php'; $conn = new ConectorBaseDatos(); $codPed = $_POST["codped"]; $sql = "SELECT * FROM pedidos WHERE CodigoPedido='{$codPed}'"; $result = $conn->ejecutar($sql, "", ""); if ($result != null) { $resultado = $result->fetch_assoc(); //Esta linea se puede obviar, en el ajax de recogida, se pondria en vez de data.apellidos, se pondria data[0]['apellido']; if (is_null($resultado)) { echo false; } else { echo json_encode($resultado); } }
<?php include './ConectorBaseDatos.php'; $codClien = $_POST["codClien"]; $nombreClien = $_POST["nombreClien"]; $nombreCont = $_POST["nombreCont"]; $apellidoCont = $_POST["apellidoCont"]; $tfno = $_POST["tfno"]; $fax = $_POST["fax"]; $direccion1 = $_POST["direccion1"]; $direccion2 = $_POST["direccion2"]; $ciudad = $_POST["ciudad"]; $region = $_POST["region"]; $pais = $_POST["pais"]; $codPos = $_POST["codPos"]; $credito = $_POST["credito"]; $empleado = $_POST["empleado"]; $conn = new ConectorBaseDatos(); $text = "<table>\r\n <tr>\r\n <td>Codigo Cliente: </td>\r\n <td>{$codClien}</td>\r\n </tr>\r\n <tr>\r\n <td>Nombre Cliente: </td>\r\n <td>{$nombreClien}</td>\r\n </tr>\r\n <tr>\r\n <td>Nombre Contacto: </td>\r\n <td>{$nombreCont}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Apellido Contacto: </td>\r\n <td>{$apellidoCont}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Telefono: </td>\r\n <td>\r\n {$tfno}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Fax: </td>\r\n <td>\r\n {$fax}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Direccion1: </td>\r\n <td>{$direccion1}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Direccion2: </td>\r\n <td>{$direccion2}</td>\r\n </tr>\r\n <tr>\r\n <td>Ciudad: </td>\r\n <td>{$ciudad}</td>\r\n </tr>\r\n <tr>\r\n <td>Region: </td>\r\n <td>{$region}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Pais: </td>\r\n <td>{$pais}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Codigo Postal: </td>\r\n <td>\r\n {$codPos}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Limite Credito: </td>\r\n <td>\r\n {$credito}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Empleado: </td>\r\n <td>{$empleado}\r\n </td>\r\n </tr>\r\n </table>"; $sql = "INSERT INTO clientes (CodigoCliente,NombreCliente,NombreContacto,ApellidoContacto,Telefono,Fax,LineaDireccion1,LineaDireccion2,Ciudad,Region,Pais,CodigoPostal,CodigoEmpleadoRepVentas,LimiteCredito) VALUES " . "({$codClien},'{$nombreClien}','{$nombreCont}','{$apellidoCont}','{$tfno}','{$fax}','{$direccion1}','{$direccion2}','{$ciudad}','{$region}','{$pais}','{$codPos}',{$empleado},{$credito})"; $succesfulText = "New Client added correctly"; $datos = $conn->ejecutar($sql, $text, $succesfulText);
include './ControlSesion.php'; $sesion = new ControlSesion(); $sesion->gestiona(); ?> <!DOCTYPE html> <html> <head> <title>Listar Departamento</title> <script src="js/libs/jquery/jquery.js" type="text/javascript"></script> </head> <body> <table style="border-collapse: collapse; text-align: center"> <tr> <td style="border:1px black solid; padding:5px">Id</td><td style="border:1px black solid; padding:5px">Nombre</td><td style="border:1px black solid; padding:5px">Localizción</td> </tr> <?php include './ConectorBaseDatos.php'; $sql = "SELECT dept_no, dnombre, loc FROM departamentos"; $conn = new ConectorBaseDatos(); $text = ""; $succesfulText = ""; $result = $conn->ejecutar($sql, $text, $succesfulText); $row = mysqli_fetch_array($result); while ($row) { echo "<tr><td style='border:1px black solid; padding:5px'>" . $row['dept_no'] . "</td><td style='border:1px black solid; padding:5px'>" . $row['dnombre'] . "</td><td style='border:1px black solid; padding:5px'>" . $row['loc'] . "</td></tr>"; $row = mysqli_fetch_array($result); } ?> </table> </body> </html>
<td>Salario: </td> <td> <input type="text" name="salario" id="salario"/> </td> </tr> <tr> <td>Comision: </td> <td><input type="text" name="comision" id="comision" required/> </td> </tr> <tr> <td>Departamento: </td> <td> <select name="depto" id="depto"> <?php $conn2 = new ConectorBaseDatos(); $sql2 = "SELECT * FROM departamentos"; $result2 = $conn2->ejecutar($sql2, "", ""); if ($result2->num_rows > 0) { while ($row = $result2->fetch_assoc()) { echo "<option value='" . $row["dept_no"] . "'>" . $row["dept_no"] . "-" . $row["dnombre"] . "</option>"; } } else { echo "0 results"; } ?> </select> </td> </tr> </table> <input type="submit" id="submit" value="Modificar"/>
<?php include './ConectorBaseDatos.php'; $emp_no = $_POST["emp_no"]; $ape = $_POST["apellido"]; $dept_no = $_POST["dept_no"]; $oficio = $_POST["oficio"]; $dir = $_POST["dir"]; $fecha = $_POST["fecha"]; $salario = $_POST["salario"]; $comision = $_POST["comision"]; $text = "<table>\r\n <tr>\r\n <td>Id Empleado: </td>\r\n <td>{$emp_no}</td>\r\n </tr>\r\n <tr>\r\n <td>Apellido: </td>\r\n <td>{$ape}</td>\r\n </tr>\r\n <tr>\r\n <td>Oficio: </td>\r\n <td>{$oficio}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Dirigido (id del superior): </td>\r\n <td>{$dir}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Fecha: </td>\r\n <td>\r\n {$fecha}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Salario: </td>\r\n <td>\r\n {$salario}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Comision: </td>\r\n <td>{$comision}\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>Departamento: </td>\r\n <td>{$dept_no}\r\n </td>\r\n </tr>\r\n </table>"; $conn = new ConectorBaseDatos(); $sql = "UPDATE Empleados SET apellido='{$ape}', oficio='{$oficio}', dir={$dir}, fecha_alt='{$fecha}', salario={$salario},comision={$comision},dept_no={$dept_no} WHERE emp_no='{$emp_no}'"; $result = $conn->ejecutar($sql, $text, "Updated Employee successfully");