Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class DateBase {
- private $tableName;
- public function __construct($tableName){
- $this->connect();
- $this->tableName = $tableName;
- }
- public function connect(){
- $host = 'localhost';
- $charset = 'utf8';
- $db = 'nozdrevatih';
- $user = 'root';
- $pass = '';
- $dns = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = array (
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
- );
- $this->link = new PDO($dns,$user,$pass,$opt);
- }
- public function getAllRow(){
- $sql = 'SELECT * FROM users';
- $stmt = $this->link->query($sql);
- return $stmt->fetchAll();
- }
- //1 запись Массива и запись в xml - файл
- public function putXml($arr){
- $xml_user = new SimpleXMLElement('<?xml version="1.0"?><users></users>');
- foreach ($arr as $user) {
- if(is_array($user)) {
- $elem = $xml_user->addChild("user");
- $elem->addChild('id', $user['id']);
- $elem->addChild('name', $user['name']);
- $elem->addChild('surname', $user['surname']);
- $elem->addChild('age', $user['age']);
- }
- }
- $xml_user->asXml('result.xml');
- }
- //2 Из файла XML, генерировать массив и данные из этого массива вставлять в базу данных.
- public function exportFromXml(){
- $xml = simplexml_load_file('result.xml');
- $i=0;
- foreach ($xml as $key => $value) {
- foreach ($value as $val) {
- $arr[$i][] = $val;
- }
- $i++;
- }
- return $arr;
- }
- public function addUser($arr){
- foreach ($arr as $user) {
- $sql = "INSERT INTO `users` SET name=:name , surname=:surname";
- $stmt = $this->link->prepare($sql);
- $stmt->execute(array('name' => $user[1] ,'surname' => $user[2]));
- }
- }
- }
- ?>
Add Comment
Please, Sign In to add comment