Advertisement
Guest User

Untitled

a guest
Aug 27th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1.  
  2. <?php
  3.  
  4. class database{
  5. protected $databaseLink;
  6. function __construct(){
  7. include "dbSettings.php";
  8. $this->database = $dbInfo['host'];
  9. $this->mysql_user = $dbInfo['user'];
  10. $this->mysql_pass = $dbInfo['pass'];
  11. $this->openConnection();
  12. return $this->get_link();
  13. }
  14. function openConnection(){
  15. $this->databaseLink = mysql_connect($this->database, $this->mysql_user, $this->mysql_pass);
  16. }
  17.  
  18. function get_link(){
  19. return $this->databaseLink;
  20. }
  21. }
  22.  
  23. function insertArr($tableName, $insData){
  24. $db = new database();
  25. mysql_set_charset( 'utf8');
  26. $columns = implode(", ",array_keys($insData));
  27. $escaped_values = array_map('mysql_real_escape_string', array_values($insData));
  28. foreach ($escaped_values as $idx=>$data) $escaped_values[$idx] = "'".$data."'";
  29. $values = implode(", ", $escaped_values);
  30. $query = "INSERT INTO $tableName ($columns) VALUES ($values)";
  31. mysql_query($query) or die(mysql_error());
  32. mysql_close($db->get_link());
  33. unset($db);
  34. unset($columns);
  35. unset($escaped_values);
  36. unset($values);
  37. unset($query);
  38. }
  39.  
  40. insertArr('databse.table', $assoc_array);
  41. //Важно, что ключи массива совпадали с полями в таблице
  42. // Одной строкой все данные заносятся с ассоциативнго массива в БД
  43. // Движок - MYSQL(!!!)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement