Advertisement
daniel7

cds vol1

May 9th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. const.php
  2. <?php
  3. $TABLE = 'imenik';
  4.  
  5. create.php
  6.  
  7. <?php
  8.  
  9. require_once('db.php');
  10. require_once('const.php');
  11. #---------------------------------------------------------------------------
  12.  
  13. $data = Array();
  14. if (!empty($_POST)) {
  15. $result = insertIntoTable($link, $TABLE, $_POST);
  16. if ($result) {
  17. $id = $link->insert_id;
  18. $_POST['id'] = $id;
  19. $json = json_encode($_POST);
  20. echo $json;
  21. }
  22. }
  23.  
  24. $link->close();
  25.  
  26. #---------------------------------------------------------------------------
  27.  
  28. function insertIntoTable($link, $table, $data) {
  29. $sql = "INSERT INTO $table";
  30. $sql .= " (`".implode("`, `", array_keys($data))."`)";
  31. $sql .= " VALUES ('".implode("', '", $data)."') ";
  32. $sql .= ';';
  33. $result = $link->query($sql);
  34. return $result;
  35. }
  36.  
  37. db.php
  38.  
  39. <?php
  40. $ERRORS = array(
  41. 'CONNECT_MYSQL' => 'Error connectiong to mysql ',
  42. 'SELECT_DB' => 'Error connectiong to db ',
  43. 'QUERRY' => 'Querry error '
  44. );
  45.  
  46. $HOST = 'localhost';
  47. $USER = 'root';
  48. $PASSWORD = '';
  49. $DATABASE = 'telefonski_imenik';
  50.  
  51.  
  52. $link = connectToMysqlDb($HOST, $USER, $PASSWORD, $DATABASE);
  53. #$db = selectDb($DATABASE, $link);
  54.  
  55. #---------------------------------------------------------------------------
  56.  
  57. function connectToMysqlDb($host, $user, $password, $database) {
  58. $link = mysqli_connect($host, $user, $password, $database);
  59. if (!$link){
  60. die($ERRORS['CONNECT_MYSQL'] . mysqli_error());
  61. }
  62. return $link;
  63. }
  64.  
  65. #---------------------------------------------------------------------------
  66.  
  67.  
  68. #---------------------------------------------------------------------------
  69.  
  70. function selectDb($database, $link) {
  71. $db = mysqli_select_db($database, $link);
  72. if (!$db){
  73. die($ERRORS['SELECT_DB'] . mysqli_error());
  74. }
  75. return $db;
  76. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement