
krishperl
New User
Nov 18, 2009, 1:54 AM
Post #1 of 3
(8731 views)
|
accessing XML string using regular expression
|
Can't Post
|
|
/I have clubed both my postings to a single one so its more readable query to fetch the first name,lastname,id of that particular login. Here is the string <?xml version="1.0"?><poc_list name="node"><poc notify="on" userType="login" includeHistory="off">fieldwatch</poc></poc_list> The field I am trying to read is fieldwatch which is the login name in a table called user. i need help in reg exp to read that login name and use that with a query in array to read users first_name,last_name from another table called user. ( which is accessed using DBI - mySQL) more to add here is that the items for user table id,last_name,first_name,role,login etc. what ever values I get from reading the xml string eg "fieldwatch" need to be stored in array. and use that array to read all the user last_name,first_name etc from the user table.
|