PHP - Read More... If Text More Than 600 Characters

Hi to all!! I am still new to php.. I need help in reading my text file and inserting it to mysql database.
My text file contains 5 fields and has several rows..
The format of my text file:

1 romeo 8877 2010-07-07 abc1
2 nick 7686 2010-07-07 abc2
3 mark 5456 2010-07-07 abc3
4 karm 3432 2010-07-07 abc4

The first field is an INTEGER, the second third fifth fields are VARCHAR and the fourth field is a DATE.
I am having trouble with my php code..
My code is this:

<?php
 mysql_connect("localhost","root","");
    mysql_select_db("personss");

$textFileName = $_POST['textFileName'];

    $myFile = "$textFileName";
    $fh = fopen($myFile, 'r');
    $theData = fread($fh, filesize($myFile));
    fclose($fh);
   
    $person = explode("\n", $theData);
    $count = 0;

foreach($person as $i => $line) {
    $nameParts = explode(" ", $person[$count]);

       
        $q = "insert into logged (id, name, num, datess, letters) values ('" . implode("','",$nameParts) . "')";
        $rw = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());
   
}
?>

This code can insert to the database but it only inserts the first row and it loops the insert according to how many rows there are in the text file..For example in my text file there are are 4 rows, it inserts the first row: 1 romeo 8877 2010-07-07 abc1 4times..If there are 6 rows, 6 times the first row will also be inserted..

What i need Sir's is that i need to be able to insert the rows line by line.. if there are 4 rows, i need to insert them all in the database.. Please help me to fix the code.

I need to search through a text file and output certain text.
My current script doesn't work well at all.

Code: [Select]
<?
$file = 'flist.txt';
$handle = @fopen($file, "r");
$names = array();
$func = array();
$desc = array();
$nme;
$fnc;
$dsc;
$s = -1;
$e = -1;
$n = 0;
if ($handle) {
    while (($buffer = fgets($handle, 4096)) !== false) {

if($nme == 0)
{
if(strpos($buffer,"<a name") !== false)
{
$nme = 1;
$s = strpos($buffer,"<a name");
}
}
else if($nme == 1)
{
if(strpos($buffer,"</span>") !== false)
{
$nme = 2;
$e = strpos($buffer,"</span>");
$num = $e - $s;
$names[$n] = strip_tags(substr($buffer,$s,$num));
}
}
else if($nme == 2)
{
if($fnc == 0)
{
if(strpos($buffer,"<table style") !== false)
{
$fnc = 1;
$s = strpos($buffer,"<table style");
}
}
else if($fnc == 1)
{
if(strpos($buffer,"</td>") !== false)
{
$fnc = 2;
$e = strpos($buffer,"</td>");
$num = $e - $s;
$func[$n] = strip_tags(substr($buffer,$s,$num));
}
}
else if($fnc == 2)
{
if($dsc == 0)
{
if(strpos($buffer,"<p>") !== false)
{
$dsc = 1;
$s = strpos($buffer,"<p>");
}
}
else if($dsc == 1)
{
if(strpos($buffer,"</p>") !== false)
{
$fnc = 0;
$nme = 0;
$dsc = 0;
$e = strpos($buffer,"</p>");
$num = $e - $s;
$desc[$n] = strip_tags(substr($buffer,$s,$num));
}
}
}
}
    }
    if (!feof($handle)) {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);
$n = 0;
while($n < 100)
{
echo $names[$n] . "<br>";
echo $func[$n] . "<br>";
echo $desc[$n] . "<p>";
$n ++;
}
}
?>
4096 gets the data for each line, right? Well some of my data uses two lines.

After all the searching is done I need it to output $names, $func, and $desc in plain text.

I very new to php and all I am simply trying to do is read the contents of a text file and echo it out on the screen.
I have tried many things to see what I am doing wrong but it just simply isnt working for me. I know the server I am using has php enabled as well because I have tried a simple echo and it works fine.

This is the code I am currently using.

<?php
   $file = fopen(file.txt", 'r');
   $read = fread($file, '6')
   echo $read;
?>

also, I have tried this.

<?php
   $file = file_get_contents('file.txt');
   echo $file;
?>

I have a file.txt on the server I am using in the same directory as index.php, I feel like this should be working but I get no result!
Alls I have in the text file is a statement that says "hello world".

First, my goals:
- The user selects a text file on their local PC (or their local network drive) to process.
- I want to read the file into an array and process it.

I'm having trouble with this. Here is my code so far:

<?php session_start(); 
$title='Import File v.10a';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <?php 
  echo '<title>'.$title.'</title>';
  ?>
  <link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<?php
require_once('navmenu.php');
echo '<h2>'.$title.'</h2>';
?>

<!-- comment -->
<?php
// Connect to the database 
$dbc = mysqli_connect($host, $user, $password, $database);

$errcnt=0;
$models=array(); //Init array
$bullarr=array();
$model='';
$partname='';
$partsubname='';
$image='';
$ptype=''; //Product type in {type} tag.

if (isset($_POST['cmdImport'])) //Save records that were changed.
    {
    $filename=$_POST['txtFilename']; //File on user's machine.
    $s='You are importing '.$filename;
    crDebug($s); //DEBUG
    if (move_uploaded_file($_FILES['txtFilename']['tmp_name'], 'upload/'))
    {
    $filename=$_FILES['txtFilename']['name'];
    $s='Received '.$filename;
    crInfomsg($s);
    }
    else {
    $errmsg='File upload failed. Error is '.$_FILES['txtFilename']['error'];
        crError($_SERVER['PHP_SELF'].' line '.__LINE__,$errmsg,true);
    }
   
    if (!(file_exists($filename)))
     {
     $errmsg='File '.$filename.' does not exist. Cannot continue.';
        crError($_SERVER['PHP_SELF'].' line '.__LINE__,$errmsg,true);
     }
    else {
     }
    } //if isset($_POST['cmdImport']

?>

<!-------------------------------------------------------->
<form action="<?php echo $_SERVER['PHP_SELF'].'?'.SID; ?>" method="post">
<hr/>

<label for="cbxBrand">Pick one Brand</label>
<?php
$oldbrandarr=array(); //Init array.
    //Do query and loop here.
    //Show brands from zzbrands.
    $query = "SELECT bzz ".
    "FROM zzb ".
    "ORDER BY br ".
    ";";
    //crInfomsg($query); //DEBUG
    crCreateSelect($query, 'cbxBrand', 'brand')
?>

<p>Input file: <input type="file" name="txtFilename" id="txtFilename" value="" size="80" /> 

<br/><input type="submit" value="Import" name="cmdImport" />
</form>

</body>
</html>


My problem is I get an error each time "File upload failed" which is displayed above when I try to do move_uploaded_file().

I'm not experienced processing text files. Can someone help me or point me to a website?

One more thing, the subdir "upload" is located at the same level as this php file. That is where the uploaded files will go temporarily.

hi, is there a way that i can insert into a mysql text box even if there is unsupported characters in the field.

for instance, if i want to insert:

When I arrived onsite, the cable for usb to ps/2 wasn't with the pc anymore.
I need to get a usb to ps/2 cable, as well as a dvi to vga adapter.
I will return tomorrow to finish.

and i want to keep the invalid characters like the /, and i also want to keep it on 3 seperate lines.

can this be done?

I have the following text file:
Code: [Select]
09/16/2011 - 09/16/2011      323780048      FedEx Ground Shipment Detail Report      09/22/2011      CAFE2472     Page: 1
TRACKING #       RECIPIENT CD    ZIP    ZN  CARRIER   SVC BILL WGT COD        DECL VALUE C GR CHG   C SRCHG    C NET     
---------------- --------------- ------ --- ------- - --- -------- ---------- ---------- ---------- ---------- ----------
561895962528473  97913           440607 4   Ground  , RH       2.0       0.00      99.00       6.22       2.45       8.27
561895962528480  97928           352424 5   Ground  , RH      17.0       0.00      99.00       9.89       2.45      10.60
561895962528497  97943           857164 6   Ground  , RH      17.0       0.00      99.00      12.38       2.45      14.75
561895962528503  97955           193825 5   Ground  , RH       4.0       0.00      99.00       7.17       2.45       8.42
561895962528510  6792            491069 3   Ground  , RH       3.0       0.00      99.00       5.97       2.45       8.27
561895962528527  97967           030703 5   Ground  , RH       1.0       0.00      99.00       5.75       4.10      10.06
561895962528534  97978           665429 4   Ground  , RH       4.0       0.00      99.00       6.86       4.10      10.06
561895962528541  97992           371844 4   Ground  , RH       1.0       0.00      99.00       5.51       4.25      10.22
561895962528558  98005           386108 4   Ground  , RH      18.0       0.00      99.00       9.21       4.25      12.01

GRAND TOTALS
COURTESY NET CHARGE                      92.66
TOTAL WEIGHT(OF LBS)                      63.7
TOTAL WEIGHT(OF KGS)                       0.0
CSY  DECL VAL SCHG                        0.00
COURTESY DISCOUNT                        12.52
COURTESY SPECIAL FEES                    28.95
CSY FUEL SURCHARGE                        7.27
PACKAGE COUNT                                9


And I'm attempting to pull ONLY the tracking number and reference number (or order #) from this file. I've been able to get rid of the empty lines, get rid of the first few lines I don't need and grab just tracking and reference numbers , but I can' t figure out how to get rid of of the last few lines....here's my code:

Code: [Select]
$arr=file("/home/onest4/public_html/beta/fedex.txt");
$x=1;
    foreach($arr as $str)
    {
      if (trim($str) != '')
      if ($x > 3)

     
      {
        list($tracking,$ordernumber)=explode("  ",$str);

        echo $tracking;
        echo "<br />";
        echo $ordernumber;
 
        echo "<br /><br />";
      }
      else
      {
      $x++;
      continue;
      }
    }
Here's the result:
Code: [Select]
561895962528473
97913

561895962528480
97928

561895962528497
97943

561895962528503
97955

561895962528510
6792

561895962528527
97967

561895962528534
97978

561895962528541
97992

561895962528558
98005

GRAND TOTALS


COURTESY NET CHARGE


TOTAL WEIGHT(OF LBS)


TOTAL WEIGHT(OF KGS)


CSY
DECL VAL SCHG

COURTESY DISCOUNT


COURTESY SPECIAL FEES


CSY FUEL SURCHARGE


PACKAGE COUNT



Anyone help with this?

Thanks!

Hi all! I am building a website, and the users can create a pet name. I only want them to be able to use letters, numbers and underscores in the names. How can I do this? Thanks! I would also be using this for the usernames as well. Here is my pet creation code:
adopt.php:
Code: [Select]
<?php
session_start();
include("config536.php");
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>

<?php
if(!isset($_SESSION['username'])) {
echo "<banner></banner><ubar><a href=login.php>Login</a> or <a href=register.php>Register</a></ubar><content><center><font size=6>Error!</font><br><br>You are not Logged In! Please <a href=login.php>Login</a> or <a href=register.php>Register</a> to Continue!</center></content><content><center><font size=6>Messages</font><br><br></center></content>";
}

if(isset($_SESSION['username'])) {
echo "<banner></banner><nav>$shownavbar</nav><ubar>$ubear</ubar><content><center><font size=6>Adopt a Pet</font><br><br>";

$thedateis = date('F jS, Y');
$getpetid = $_GET['petid'];
$adopt = $_POST['submit'];
$petname = $_POST['petname'];
$petgen = $_POST['gender'];

$thebq = "SELECT * FROM pets WHERE petid='$getpetid'";
$theb = mysql_query($thebq);
while($prr = mysql_fetch_array($theb)) {
$pid = $prr['petid'];
$species = $prr['pname'];
$number = $prr['number'];
}

if(!isset($getpetid)) {
$pq = "SELECT * FROM pets WHERE petid != '0'";
$p = mysql_query($pq);
while($pr = mysql_fetch_array($p)) {
$pid = $pr['petid'];
$ptype = $pr['pname'];
$im = $pr['pimage'];
$number = $pr['number'];
$limited = $pr['limited'];
$types = $pr['types'];

echo "<b>$ptype</b><br><a href=?petid=$pid><img src=/images/pets/$im></a><br>Number: $number<br><br>";
}
}
if(isset($getpetid)) {
?>
<form action="<?php echo "$PHP_SELF"; ?>" method="POST">
Please select a Name: <input type="name" name="petname" maxlength="15"><br>
Pet Gender: <select name="gender"><option value="female">Female</option><option value="male">Male</option><br><br><input type="submit" name="submit" value="Adopt Pet"></form>
<?php
$checkitq = mysql_query("SELECT * FROM userpets WHERE userpetname='$petname'");
$gcheckit = @mysql_num_rows($checkitq);

$tq = "SELECT * FROM users WHERE username='$showusername'";
$t = mysql_query($tq);
while($rw = mysql_fetch_array($t)) {
$grabnum = $rw['pets'];
}
if(isset($adopt)) {
if($grabnum >= "4") {
echo "<font color=red>Error! You already have 4 pets.</font>";
}
if($petname == "") {
echo "<font color=red>Error! Please type in a name for your pet.</font>";
}
if($qcheckit == "1") {
echo "<font color=red>Error! That pet name already exists!</font>";
}
if($gcheckit == "0" && $petname != "" && $grabnum < "4") {
mysql_query("INSERT INTO userpets (owner, userpetname, userpetspecies, userpettype, petdatecreated, gender, strength, defence, health, level, booksread, smart, hunger) VALUES ('$showusername', '$petname', '$species', 'Normal', '$thedateis', '$petgen', '1', '1', '10', '1', '0', 'Normal', 'Full')");
mysql_QUERY("UPDATE users SET pets=pets+1 WHERE username='$showusername'");
echo "<font color=green>Success! Your pet has been created!</font>";
}
}


}
}
?>

</html>
Thanks in advance for the help everyone!!

I have a PHP file that is executed via batch file very frequently for live updating. This is a sort of "sync" file for reading/writing to a MySQL database. I am able to get it functioning absolutely fine when executed manually via a web browser (and my echo debug lines output the expected information), yet when I run the same PHP file via the command line, it seems to just not be capable of opening any file for reading, so the equivalent variables that are correct when executed on a web browser are blank when echoed through the command line.

Is there a different way of handling reading of files when running a php script via the command line, or should it function exactly the same as when run via a browser?

For instance:

$k = "0";
$line = file("examplefile.log")[$k];
echo $line;

Hello, I try to get website speed of some website, but i can read only ''domain.com'' i can't read website files like css , js ... why ? i use proxies for this job. here is the php code:

$options = array(
'useragent' => "Firefox (+http://www.firefox.org)", // who am i
'connecttimeout' => 120, // timeout on connect
'timeout' => 120, // timeout on response
'redirect' => 10, // stop after 10 redirects
'referer' => "http://www.google.com",
'proxyhost' =>'85.25.8.14:80'
);
$response = http_get("http://solve-ict.com/wp-content/themes/ict%20theme/js/jquery-1.7.1.min.js", $options , $info);

but it works fine with http://domain.com/ , but with files css or js it gives 404, using some free proxy servers available ? Thanks.

Trying to get this done:

Page_1 has many external links, when certain links are clicked i do not want user to go directly to page, but rather go to a special add page_2 where user must click a second time on the link to finally get there.

The add page_2 must show on screen the name of the initial link from page_1, it must change accordingly with the link it came from page_1,once on page_2 the hyperlink redirects outside the site.

So far i am thinking give an id to the div or "<a href..." on page_1 then somehow have page_2 detect that id and fill in the variable for the final external link. Other wise is there a way to detect a url from incoming?

I guess a similar example is how some domain name sellers landing page will indicate the name of the site. Such as "Thisdomain.com" is for sale. same landing page but the name changes according to the domain that was typed.

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.

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!

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