PHP - Read Line

I got a question im using izabi for me im one who loves the software. But there some quirks that they forgot to add when making the mail system. I was wondering how it would be possible to code in a peice of php where it says read after someone read the email. If you need a copy of the mail mail script let me know.

what im trying to do is take a youtube embed code find the URL code for that video and remove all other parts of the code keeping only the URL of the video
after i get the URL by it self then replace the http://www.youtube.com/ part of the URL with http://i2.ytimg.com/vi/

to do this i know that i need something like this to get the URL of the video
http://www.youtube.com/((?:v|cp)/[A-Za-z0-9\-_=]+)
but how to only return just the URL is something idk how to do

then use str_replace http://www.youtube.com/(?:v|cp)/" with  http://i2.ytimg.com/vi/

so in the end im asking if anyone know how to remove all other codes i dont want  and only keep the URL


this may have to be done using "regex" im not sure as i dont know to much about regex and what it can do but does sound like it would help lol

Dear All

           Good Day, i am new to PHP (a beautiful server side scripting language). i want to send a mail with line by line message i tried with different types like by placing the things in table and using  <br /> but the thing is the tags are also visible in the message of the mail.

Here is my code:

$message1  = "Name       :".  $_REQUEST['name']."<br />";
$message1 .= "Surname    :".  $_REQUEST['surname']."<br />";
$message1 .= "Cellphone  :".  $_REQUEST['mobileno']."<br />";
$message1 .= "Telephone  :".  $_REQUEST['landno']."<br />";
$message1 .= "Fax        :".  $_REQUEST['fax']."<br />";
$message1 .= "Company    :".  $_REQUEST['company']."<br />";
$message1 .= "Email      :".  $_REQUEST['email']."<br />";
$message1 .= "Country    :".  $_REQUEST['country']."<br />";
$message1 .= "Enquity    :".  $_REQUEST['enquiry']."<br />";
$message1 .= "Date&Time  :".  $date."<br />";

For this code if try to print/echo it it is working fine it is displaying line by line, but using this variable ($message1) in the mail these <br /> are also visible.
Can any one guide me to resolve(to remove these tags from the message part) this issue.
Thanks in Advance. :confused:

Hi.

I want a simple textbox, that when submited, will replace very every new line, with the <br> tag.

What will happen, when it submits, it will take the contents of a textbox, add the <br> tag where a new line is suposed to be, and save the string to a MySQL Database.

I think this is the easiest way of allowing a user to edit what appears on a website when logged in, but if there is a easier way, then please tell me.

What I am trying to do, is a login page, and once logged in, you enter new text into the textbox, click submit, and on the website homepage, the main text will change to what was submitted. But if there is a new line, I think the only way in HTML to make one is to put a <br> tag, so I want the PHP to but that tag wherever there is a new line.

Sorry if I am confusing, I am not that advanced at PHP, but I would be very happy if you could supply me with the correct code. Time is running out...

If you do not understand me, please tell me

--
PHPLeader (not) 

i have to read a single line from a csv,  its a really big file and i only need one column. i need the response to be a string ,i made a search and found the following code but i dont have any idea how to get a single line from a single string per run .

<?php
$row = 1;
//open the file
if (($handle = fopen("file.csv", "r")) !== FALSE)
{
    while (($data = fgetcsv($handle, 0, ",")) !== FALSE)
    {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++)
        {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

Edited by bores_escalovsk, 16 May 2014 - 06:38 PM.

I have a script that reads a .gz file into an array and prints the name of each record but will not work on larger files. Is there a way to read 1 line at a time?
Here is the code I have so far.
Code: [Select]
<?php

if ($handle = opendir('.')) {

print "<ol>";
    
    while (false !== ($file = readdir($handle))) {
if($file != '..' && $file!="." && $file!="start_update.php" && $file!="sharons_dbinfo.inc.php" && $file!="root.php" && $file!="read_directory.php" && $file!="read_dir.php" && $file!="new_category.php" && $file!="index.php" && $file!="file_count.php" && $file!="dir_loop2.php" && $file!="dir_loop1.php" && $file!=".htaccess" && $file!="Answer.txt" && $file!="Crucial_Technology-Crucial_US_Product_Catalog_Data_Feed.txt"){
$filename = $file;
$go = filesize($filename);
if($go >= 1){
$filename2 = explode("-", $filename);
$filename2 = $filename2[0];
echo str_replace("_"," ",$filename2) . ' | Filesize is: ' . filesize($filename) . ' bytes<br>';
$gz = gzopen($filename, 'r');
$lines = gzfile($filename,10000);
foreach ($lines as $line) {
$line2 = explode(",", $line);
$line2 = str_replace("," , "-" , $line2);
    echo "<li>".str_replace("," , "-" , $line2[4])."</li><br>";
}

}
}
    }

    closedir($handle);
}
?>
</ol>

How to get this echo line to display as one line?
No matter what I have done it displays as two lines.  I even tried <nobr></nobr>

Teachers Name:
John Jones

$userid = mysql_real_escape_string($_GET['user_id']);
$sql = "select * from users where `id`='$userid' ";

$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{ 
echo  "<h3>Teachers Name: </h3>" . $row["first_name"] . " " . $row["last_name"]  ;  }


Thanks for your help.

I'm so sorry to ask such a "newbee question," but believe me I have been on Google for the better part of the week trying to find an answer.   I'll start with the brief question. Then I'll give an example to show what I mean. Then, I'll give the BESTEST "pseudo-code" I could come up with (to PROVE that I've really given it my best).   Question: How do I make PHP loop through a big file, make the changes line by line, and to save the resultant file.   Example: I have a 100mb text file ("animals.txt") with 500,000 lines. If any lines have the word "cat" in it, I want to add "Be careful with cats!" to the end of the line:   From this: A fish and his tank. A cat and his toy. A bird and her cage. A frog and his lilly. A cat and her friend.   To this: A fish and his tank. A cat and his toy. Be careful with cats! A bird and her cage. A frog and his lilly. A cat and her friend. Be careful with cats!   The best "pseudo-code" I can come up with is:   <?php $data = file_get_contents("animals.txt"); $lines = explode(PHP_EOL,$data);

I want my application will send a email after 10 minutes of sending another email.

In my application

A user completes registration with payment Application sends the user a payment confirmation email

Now I want to

send another email 10 minutes After payment confirmation email with welcome tips

Below is the function where for user setup .

 

public function finishUserSetup($Sub){

    if($Sub == 0){
        $subscription = SubscriptionPlans::where('identifier', '=', "Monthly")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "monthly";
    
    } else{
        $subscription = SubscriptionPlans::where('identifier', '=', "Annually")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "annually";
    }

    $this->expiry_date = $expiry;
    $this->user_type = "SUB";
    $this->subscription_period = $sub_period;
    $this->update();

    $replaceArray = array(
        'fullname' => $this->forename . " " . $this->surname,
        'subscriptionName' => $subscription->name,
        );
    EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

  }

In the above function the last line of code is the one which sends a payment confirmation email to the user which is

EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

I want to execute the following line of code 10 minutes after the above one

 

EmailTemplate::findAndSendTemplate("WelcomeTips", $this->email, $this->forename . " " . $this->surname, $replaceArray);

 

 

How to do that. that is running the last line of code 10 minutes after  

hi,

i am requesting bookrenter.com with curl and getting back a response in something like xml format

The response is
Code: [Select]
<response>
  <book>
    <info>
      <isbn13>9780324786453</isbn13>
      <isbn10>032478645X</isbn10>
    </info>
    <prices>
      <rental_price days="45">$17.43</rental_price>
      <rental_price days="90">$24.35</rental_price>
      <rental_price days="60">$20.87</rental_price>
      <rental_price days="30">$15.87</rental_price>
      <rental_price days="125">$28.99</rental_price>
    </prices>
    <lowest_shipping_price>$0.00</lowest_shipping_price>
    <availability>In Stock</availability>
    <url>http://www.shareasale.com/r.cfm?u=&amp;b=96706&amp;m=14293&amp;urllink=www.bookrenter.com%2Fdiscovering-computers-2010-living-in-a-digital-world-complete-shelly-cashman-series-032478645X-9780324786453</url>
  </book>
</response>


Now i want to  process the response so that it will show the values in user readable form  like

45 day's rent is $17.43
90 day's rent is $24.35
60 day's rent is $20.87
30 day's rent is $15.87
125 day's rent is $28.99

Shipping price is $0.00

please help

Thanks

Good morning guys.

I am pulling data from vehicle tracking site via soap curl. but the data format that I am getting it in is unusable, maybee i am doing something wrong. please have a look.

here is the code.

<?php

//Data, connection, auth

$dataFromTheForm = $_POST['fieldName']; // request data from the form

$soapUrl = "https://fleet11.******.co.za/api/"; // asmx URL of WSDL

$soapUser = "********"; // username

$soapPassword = "********"; // password

// xml post structure

$xml_post_string = '<?xml version="1.0" encoding="utf-8"?>

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:api="fleet11.cartrack.co.za/api/">

<soapenv:Header/>

<soapenv:Body>

<api:endpoint.get_vehicle_last_positions soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<username xsi:type="xsd:string">?</username>

</api:endpoint.get_vehicle_last_positions>

</soapenv:Body>

</soapenv:Envelope>';

$headers = array(

"Content-type: application/x-www-form-urlencoded",

"Accept: text/xml",

"Cache-Control: no-cache",

"Pragma: no-cache",

"SOAPAction: fleet11.******.co.za/api/#get_vehicle_last_positions",

"Content-length: ".strlen($xml_post_string),

);

$url = $soapUrl;

// var_dump($url);

$ch = curl_init();

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);

curl_setopt($ch, CURLOPT_URL, $url);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

curl_setopt($ch, CURLOPT_USERPWD, $soapUser.":".$soapPassword);

curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY);

curl_setopt($ch, CURLOPT_TIMEOUT, 10);

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $xml_post_string);

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

        `curl_setopt($ch, CURLOPT_HEADER, true);` 


// converting

$response = curl_exec($ch);

curl_close($ch);

//paul add

//echo "<pre>";

print_r($response);

What is returning is single line entries

Quote

GMT Server: [32] => Apache X-SOAP-Server: [33] => NuSOAP/0.9.5 [34] => (1.123) Content-Length: [35] => 15407 Vary: [36] => Accept-Encoding,User-Agent Access-Control-Allow-Origin: [37] => * Access-Control-Allow-Methods: [38] => POST, [39] => GET, [40] => OPTIONS Access-Control-Allow-Headers: [41] => Origin, [42] => X-Requested-With, [43] => Content-Type, [44] => Accept Access-Control-Allow-Credentials: [45] => true Content-Type: [46] => text/xml; [47] => charset=UTF-8 version="1.0" [49] => encoding="UTF-8"?> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" [51] => xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" [52] => xmlns:xsd="http://www.w3.org/2001/XMLSchema" [53] => xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" [54] => xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" [55] => xmlns:tns="fleet11.cartrack.co.za/api/"> xsi:type="SOAP-ENC:Array" [57] => SOAP-ENC:arrayType="tns:get_vehicle_last_positionsResultType0Row[20]"> xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">115687333 xsi:type="xsd:string">HG07DPGP xsi:type="xsd:string">2020-07-01 [62] => 08:03:32+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.118315 xsi:type="xsd:double">28.162389 xsi:type="xsd:string">0 xsi:type="xsd:string">Greenstone [68] => Hill, [69] => Kempton [70] => Park, [71] => Gauteng, [72] => South [73] => Africa xsi:type="xsd:string">25065631 xsi:type="xsd:string">ADNUSN1D5U0135477 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">115687485 xsi:type="xsd:string">HG07DKGP xsi:type="xsd:string">2020-07-01 [80] => 08:02:56+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.130168 xsi:type="xsd:double">28.159369 xsi:type="xsd:string">0 xsi:type="xsd:string">Diaz [86] => Avenue, [87] => Eastleigh, [88] => Edenvale, [89] => Gauteng, [90] => South [91] => Africa xsi:type="xsd:string">53844088 xsi:type="xsd:string">ADNUSN2D5U0135485 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">116851782 xsi:type="xsd:string">HH65MRGP xsi:type="xsd:string">2020-07-01 [98] => 06:46:10+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.19221 xsi:type="xsd:double">28.226617 xsi:type="xsd:string">0 xsi:type="xsd:string">Pretoria [104] => Road, [105] => Witfield, [106] => Boksburg, [107] => Gauteng, [108] => South [109] => Africa xsi:type="xsd:string">35613090 xsi:type="xsd:string">ADNUSN1D5U0139460 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">124523243 xsi:type="xsd:string">HM02SRGP xsi:type="xsd:string">2020-07-01 [116] => 07:35:45+02 xsi:type="xsd:string"> xsi:type="xsd:double">-25.75936 xsi:type="xsd:double">28.377471 xsi:type="xsd:string">0 xsi:type="xsd:string">Close [122] => to [123] => Mamelodi, [124] => Gauteng, [125] => South [126] => Africa xsi:type="xsd:string">72339064 xsi:type="xsd:string">ABNALGD22ZR114138 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">124523364 xsi:type="xsd:string">HL98BLGP xsi:type="xsd:string">2020-07-01 [133] => 08:04:54+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.111563 xsi:type="xsd:double">28.130599 xsi:type="xsd:string">98 xsi:type="xsd:string">Eastern [139] => Bypass, [140] => Lombardy [141] => East, [142] => Johannesburg, [143] => Gauteng, [144] => South [145] => Africa xsi:type="xsd:string">41388033 xsi:type="xsd:string">ADNUSN1D5U1046692 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131644752 xsi:type="xsd:string">DZ04YCGP xsi:type="xsd:string">2020-07-01 [152] => 07:12:08+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.058652 xsi:type="xsd:double">27.9626 xsi:type="xsd:string">0 xsi:type="xsd:string">Sharonlea [158] => & [159] => Exts, [160] => Randburg, [161] => Gauteng, [162] => South [163] => Africa xsi:type="xsd:string">99787541 xsi:type="xsd:string">ADNUSN1DSU018112 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131928943 xsi:type="xsd:string">CM63CKGP xsi:type="xsd:string">2020-07-01 [170] => 08:04:23+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.091137 xsi:type="xsd:double">28.136977 xsi:type="xsd:string">5 xsi:type="xsd:string">Reid [176] => Avenue, [177] => Linbro [178] => Park [179] => AH, [180] => Sandton, [181] => Gauteng, [182] => South [183] => Africa xsi:type="xsd:string">127659623 xsi:type="xsd:string">ADNUSN1D5U0062513 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131929103 xsi:type="xsd:string">CW94GBGP xsi:type="xsd:string">2020-07-01 [190] => 07:45:08+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.121185 xsi:type="xsd:double">28.037383 xsi:type="xsd:string">0 xsi:type="xsd:string">Zandfontein [196] => 42 [197] => IR [198] => Ext [199] => 42, [200] => Sandton, [201] => Gauteng, [202] => South [203] => Africa xsi:type="xsd:string">90508868 xsi:type="xsd:string">ADNUSN1D5U0072740 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">131929189 xsi:type="xsd:string">DJ17CSGP xsi:type="xsd:string">2020-07-01 [210] => 08:02:23+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.037962 xsi:type="xsd:double">28.115413 xsi:type="xsd:string">0 xsi:type="xsd:string">Auston [216] => View, [217] => Midrand, [218] => Gauteng, [219] => South [220] => Africa xsi:type="xsd:string">133138296 xsi:type="xsd:string">ADNUSN1D5U0083443 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">133862270 xsi:type="xsd:string">HR66YXGP xsi:type="xsd:string">2020-07-01 [227] => 08:03:59+02 xsi:type="xsd:string"> xsi:type="xsd:double">-29.525639 xsi:type="xsd:double">31.204625 xsi:type="xsd:string">0 xsi:type="xsd:string">Deepdene, [233] => Ballito, [234] => KwaZulu-Natal, [235] => South [236] => Africa xsi:type="xsd:string">65364399 xsi:type="xsd:string">ADNALGD22ZR115154 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">146454559 xsi:type="xsd:string">HV78BLGP xsi:type="xsd:string">2020-07-01 [243] => 07:34:51+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.085404 xsi:type="xsd:double">28.133489 xsi:type="xsd:string">0 xsi:type="xsd:string">Clulee [249] => Road, [250] => Linbro [251] => Park [252] => AH, [253] => Sandton, [254] => Gauteng, [255] => South [256] => Africa xsi:type="xsd:string">30852771 xsi:type="xsd:string">ADNUSN1DSU0156147 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">152773681 xsi:type="xsd:string">HX90JJGP xsi:type="xsd:string">2020-06-30 [263] => 17:52:53+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.130205 xsi:type="xsd:double">28.15951 xsi:type="xsd:string">0 xsi:type="xsd:string">Diaz [269] => Avenue, [270] => Eastleigh, [271] => Edenvale, [272] => Gauteng, [273] => South [274] => Africa xsi:type="xsd:string">14419677 xsi:type="xsd:string">ADNUSN1D5U0161101 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">159833291 xsi:type="xsd:string">JB31BYGP xsi:type="xsd:string">2020-07-01 [281] => 07:17:59+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.181345 xsi:type="xsd:double">28.216789 xsi:type="xsd:string">1 xsi:type="xsd:string">Jet [287] => Park [288] => Road, [289] => Witfield, [290] => Boksburg, [291] => Gauteng, [292] => South [293] => Africa xsi:type="xsd:string">30900017 xsi:type="xsd:string">ADNUSN1D5U0164185 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">167023369 xsi:type="xsd:string">HZ14SDGP xsi:type="xsd:string">2020-07-01 [300] => 08:01:53+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.13017 xsi:type="xsd:double">28.159555 xsi:type="xsd:string">0 xsi:type="xsd:string">Lucas [306] => Road, [307] => Eastleigh, [308] => Edenvale, [309] => Gauteng, [310] => South [311] => Africa xsi:type="xsd:string">17826940 xsi:type="xsd:string">KMFZB7LKU621919 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">167435050 xsi:type="xsd:string">JH04HZGP xsi:type="xsd:string">2020-07-01 [318] => 07:32:35+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.058647 xsi:type="xsd:double">27.961838 xsi:type="xsd:string">0 xsi:type="xsd:string">Sharonlea [324] => & [325] => Exts, [326] => Randburg, [327] => Gauteng, [328] => South [329] => Africa xsi:type="xsd:string">26932527 xsi:type="xsd:string">ADNAPGD222R123234 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">174261628 xsi:type="xsd:string">FF98ZWGP xsi:type="xsd:string">2020-07-01 [336] => 08:04:03+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.129867 xsi:type="xsd:double">28.164617 xsi:type="xsd:string">15 xsi:type="xsd:string">Erasmus [342] => Avenue, [343] => Eden [344] => Glen, [345] => Edenvale, [346] => Gauteng, [347] => South [348] => Africa xsi:type="xsd:string">110330236 xsi:type="xsd:string">ADNU5N1D5U0112998 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">174261922 xsi:type="xsd:string">JG94XXGP xsi:type="xsd:string">2020-06-30 [355] => 13:49:51+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.130232 xsi:type="xsd:double">28.159559 xsi:type="xsd:string">0 xsi:type="xsd:string">Diaz [361] => Avenue, [362] => Eastleigh, [363] => Edenvale, [364] => Gauteng, [365] => South [366] => Africa xsi:type="xsd:string">24696958 xsi:type="xsd:string">ADNUSN1D5U0174093 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">174262077 xsi:type="xsd:string">FX50RTGP xsi:type="xsd:string">2020-07-01 [373] => 08:03:26+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.08572 xsi:type="xsd:double">28.133629 xsi:type="xsd:string">0 xsi:type="xsd:string">Clulee [379] => Road, [380] => Linbro [381] => Park [382] => AH, [383] => Sandton, [384] => Gauteng, [385] => South [386] => Africa xsi:type="xsd:string">108068376 xsi:type="xsd:string">ADNSUN1D5U0128530 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">176362877 xsi:type="xsd:string">FJ14LJGP xsi:type="xsd:string">2020-07-01 [393] => 08:02:22+02 xsi:type="xsd:string"> xsi:type="xsd:double">-26.111907 xsi:type="xsd:double">28.151657 xsi:type="xsd:string">0 xsi:type="xsd:string">Willow [399] => Way, [400] => Greenstone [401] => Hill, [402] => Kempton [403] => Park, [404] => Gauteng, [405] => South [406] => Africa xsi:type="xsd:string">85623895 xsi:type="xsd:string">ADNUSN1D5U0115408 xsi:type="tns:get_vehicle_last_positionsResultType0Row"> xsi:type="xsd:string">176819319 xsi:type="xsd:string">JL90NYGP xsi:nil="true" [413] => xsi:type="xsd:string"/> xsi:type="xsd:string"> xsi:nil="true" [416] => xsi:type="xsd:double"/> xsi:nil="true" [418] => xsi:type="xsd:double"/> xsi:nil="true" [420] => xsi:type="xsd:string"/> xsi:nil="true" [422] => xsi:type="xsd:string"/> xsi:nil="true" [424] => xsi:type="xsd:string"/> xsi:type="xsd:string">ASNUSN1DSU0175716 )

How di i get this into a format to import into mysql

Hi everyone,

I need some help here. I don't know PHP coding and how to write custom php code for reading a XML in PHP. I have a application which updates the server status in real time and send out the data in XML format. I want to create a PHP page so that can show the data in XML to frontend user...

I am pasting the XML code that need to be converted in PHP. Any kind of help will be appreciated. If anybody can give me the code and displaying the data in table format that will be awesome....


Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
-<simplehelp_metrics builddate="20120419-123521" version="3.12">
 -<technician_metrics>
<metric value="2" name="Technicians Logged In" id="tech_logged_in"/>
<metric value="0" name="Technicians In Session" id="tech_in_session"/>
<metric value="0" name="Technicians In Remote Session" id="tech_in_remote_session"/>
</technician_metrics>
-<customer_metrics>
<metric value="0" name="Customers Logged In" id="cust_logged_in"/>
<metric value="0" name="Customers In Session" id="cust_in_session"/>
<metric value="0" name="Customers Waiting" id="cust_waiting"/>
</customer_metrics>
 -<server_metrics>
<metric value="1" name="Server Maximum Sessions" id="server_max_sessions"/>
<metric value="23" name="Server Total Number of Sessions" id="server_total_sessions"/>
<metric value="23" name="Server Total Number of Support Sessions" id="server_total_support_sessions"/>
<metric value="0" name="Server Total Number of Access Sessions" id="server_total_access_sessions"/>
<metric value="21217" name="Average Queue Time" id="server_average_queue_time"/>
<metric value="17052" name="Last Queue Time" id="server_last_queue_time"/>
<metric value="1830883" name="Average Session Duration" id="server_average_session_time"/>
<metric value="5932145" name="Last Session Duration" id="server_last_session_time"/>
</server_metrics>
-<technicians>
<technician name="tlc10271" login="tlc10271"/>
<technician name="tlc10072" login="tlc10072"/>
</technicians>
</simplehelp_metrics>

this is what i have so far:

Code: [Select]
$var=$_POST["fname"];
$xmlDoc = new DOMDocument();
$xmlDoc->loadXML($var);


I would like to use something similar to this included in it before sql insert:
Code: [Select]
for($c = 0; $c<$node->length; $c++)
{


1 root, 4 parents and varying childs I believe?
Code: [Select]
<node>

<building>Number 65</building>

<workers><label>executive</label><names>john</names><label>cook</label><names>terry</names><label>waitress</label><names>jill</names><label>buser</label><names>4564646</names><label>Main</label><number>45564646</number><label>home fax</label><number>45964646</number></workers>


<food><label>breakfast</label><meal>eggs</meal><label>lunch</label><meal>turkey</meal><label>dinner</label><meal>steak</meal></food>


<addresses><label>Home</label><Country>usa</Country><Street>123 mulberry ln </Street><ZIP>57888</ZIP><City>teledo</City><State>Ohio</State><label>location</label><Street>turnpike east 23</Street><City>danbury</City><State>Connecticut</State><Country>USA</Country></addresses>

<building>Number 66</building> etc...

</node>


Thank you!

i have this code
Code: [Select]
<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>

    <item>
        <title> tttt1</title>
        <link>lll1</link>
        <description> dddd1
        </description>
   
       
    </item>



    <item>
        <title> tttt2</title>
        <link>lll2</link>
        <description> dddd2
        </description>
   
       
    </item>


    <item>
        <title> tttt3</title>
        <link>lll3</link>
        <description> dddd3
        </description>
   
       
    </item>

and i want go get to array all the details

tttt1
lll1
dddd1

tttt2
lll2
dddd2

tttt3
lll3
dddd3

how can i do that simple?
I SEE THIS
http://il2.php.net/xml_parse
but
1)i dont understand this how can i do what i want
2) it is too long and class code i need short and simple

please help

hi,
there is a script or something that can read this file?
http://ical.imac.com/ical/portuguese32holidays.ics

the ideia is to save all days and holidays for a mysql and
then update time to time.
thanks for your help