php - how insert data from xml to mysql with loops -

-

enter code here`hi how can me ? have problem in script

i want save xml file in mysql db

the xml file

   <?xml version="1.0" encoding="utf-8"?>   <style>     <settings><style_name>default</style_name> <style_version>1.0</style_version> </settings>    <tpl>  <tpl_name>body</tpl_name> <tpl_display_area>body</tpl_display_area> <tpl_des>body</tpl_des> <tpl_source><![cdata[< body src ]]></tpl_source>    <tpl_name>footer</tpl_name><tpl_display_area>footer</tpl_display_area><tpl_des>footer</tpl_des> <tpl_source> <![cdata[>  source footer ]]> </tpl_source> <tpl_name>closing</tpl_name><tpl_display_area>close</tpl_display_area><tpl_des>closing</tpl_des><tpl_source><![cdata[<center><h3>our website close right </h3></center>]]></tpl_source>     <tpl_name>display</tpl_name> <tpl_display_area>display</tpl_display_area> <tpl_des>display</tpl_des> <tpl_source> <![cdata[{include file='db:header'} {include file='db:body'} {include file='db:footer'}]]> </tpl_source>      <tpl_name>right block</tpl_name> <tpl_display_area>right_block</tpl_display_area> <tpl_des>right block</tpl_des> <tpl_source><![cdata[ right src ]]></tpl_source> <tpl_name>left block</tpl_name> <tpl_display_area>left_block</tpl_display_area> <tpl_des>left block</tpl_des> <tpl_source> <![cdata[<div class="left"> </div>]]> </tpl_source>   <tpl_name>header</tpl_name> <tpl_display_area>header</tpl_display_area> <tpl_des>header</tpl_des><tpl_source><![cdata[<head></head>]]></tpl_source> </tpl> </style>

there 7 templates want save settings tags in style information table 1 time table style_name varchar(255) version varchar(255)

and want save 7 template in mysql table

table map

tpl_name varchar(255) tpl_display_area varchar(255) tpl_des varchar(255) tpl_source text

please me

you use simplexml-class parse xml file , use mysqli-class write values in database.

examples , tutorials on both things can found in php-manual, comments in php-manual , on google.

step step:

  1. parse xml-file , values (save them in array)
  2. connect mysql database
  3. create preparedstatement insert
  4. loop on array , insert values in database
  5. close database connection

Comments

Post a Comment

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

delphi - ESC/P programming! -

-
why need use because printers using tprinter prints weird hieroglyph @ beginning of printable area. my problem if send commands, nothing happens. esc e (#27 #69) - sending escape sequence didn't work expected. removed first letter , rest of string made bold. eg. hello -> ello . after changed esc e esc (#27 #69 #27), worked fine. example managed figure out, but... trying select character table "esc t n" (#27 #116 n), make "õäöü" work. command doesn't work. nothing happens! , command supported esc/p, esc/p 2 , 9-pin esc/p, should work fine. manual can found here . if has ever needed use esc/p commands maybe 1 can shed light how work them! thanks in advance! edit: in previous post asked more or less same question though answers how did send commands printer. (i'll change question there according answers!) i accepted ken's answer, because claimed way transferred commands wasn't best , got work escape command. problem after t...
Read more

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more