Guest User

Untitled

a guest
Jan 23rd, 2019
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.62 KB | None | 0 0
  1. class Database {
  2.  
  3. private static $cont = null;
  4.  
  5. public function __construct() {
  6. exit('Init function is not allowed');
  7. }
  8.  
  9. public static function getCadena() {
  10. $ini = parse_ini_file('C:credenciales.ini', true);
  11. return "host='" . $ini['server']['host'] . "' port='" .
  12. $ini['server']['port'] . "' dbname='" . $ini['server']['database'] .
  13. "' user='" . $ini['server']['user'] . "' password='" . $ini['server']
  14. ['pass'] . "' ";
  15. }
  16.  
  17. public static function connect() {
  18. $ini = parse_ini_file('C:credenciales.ini', true);
  19. if (null == self::$cont) {
  20. try {
  21. self::$cont = new PDO("pgsql:host=" . $ini['server']['host']
  22. . ";port=" . $ini['server']['port'] . ";" . "dbname=" .
  23. $ini['server']['database'], $ini['server']['user'],
  24. $ini['server']['pass']);
  25. } catch (PDOException $e) {
  26. die($e->getMessage());
  27. }
  28. }
  29. return self::$cont;
  30. }
  31.  
  32. public static function disconnect() {
  33. self::$cont = null;
  34. }
  35.  
  36. $pdo = Database::connect();
  37. $nombrefiltrar = strtoupper($_POST['nombreconductorfiltro']);
  38. $sql = " SELECT c_cedula, c_nombre, c_activo FROM conductor WHERE c_nombre LIKE '%" . $nombrefiltrar . "%'
  39. ORDER BY c_nombre ASC";
  40. foreach ($pdo->query($sql) as $row) {
  41. echo '<tr>';
  42. echo '<td>' . $row['c_cedula'] . '</td>';
  43. echo '<td>' . $row['c_nombre'] . '</td>';
  44. if ($row['c_activo'] == TRUE) {
  45. echo '<td> ACTIVO </td>';
  46. } else {
  47. echo '<td> INACTIVO </td>';
  48. }
  49.  
  50. $conductor = "javascript:verEditarConductor(" . $row['c_cedula'] . ", '" . $row['c_nombre'] . "', " . $row['c_activo'] . ")";
  51. echo '<td><a href="' . $conductor . '" class="btn" style="background-color: #004D27" ><img src="png/edit.png" alt="x" title="Ver" style="background-color: #004D27" /></a>';
  52. echo '</tr>';
  53. }
  54. Database::disconnect();
  55. echo '</tbody>
  56. </table>';
  57. break;
  58.  
  59. :nombre
  60.  
  61. $nombrefiltrar = strtoupper($_POST['nombreconductorfiltro']);
  62.  
  63. $sql = $pdo->prepare(" SELECT c_cedula, c_nombre, c_activo FROM conductor
  64. WHERE c_nombre LIKE :nombreFiltrar
  65. ORDER BY c_nombre ASC");
  66.  
  67. $sql->bindParam(":nombreFiltrar", $nombreFiltrar, PDO::PARAM_STR);
  68.  
  69. $sql->execute();
  70.  
  71. $sql->execute(array(":valorUno" => $valorUno, ":valorDos" => $valorDos,
  72. ":valorTres" => $valorTres));
  73.  
  74. $resultado = $sql->fetchAll(PDO::FETCH_ASSOC);
  75.  
  76. foreach($resultado as $value){
  77. echo $value["nombreColumna"];
  78. }
Add Comment
Please, Sign In to add comment