<?php

include ('Connections/textcon.php');

$handle = @fopen("xyz.txt", "r"); // Open file form read.

if ($handle) {
  while (!feof($handle)) // Loop til end of file.
  {
   
     $theData = fgets($handle, 4096); // Read a line
     if (strlen($theData) > 2) {
       if (strrpos($theData, "£") === false ) {
         $carmake = substr($theData, 0, strpos($theData, " ") ); // goes from character position 0 to the first occurance of a space
         $carmodel = substr($theData, strpos($theData, " " , strlen($theData) )); // goes from first occurance of a space to end
      
         $queryinsert = "INSERT INTO carsuk.cars (makeid, model)
         VALUES ('$carmake','$carmodel')";
         $result= mysql_query($queryinsert)  or die ("error in query: $query. " . mysql_error());	 
		 
       
         }
		 
		 
		 
		 else if (strrpos($theData, "£") === true) {
		 	$lengthy = strlen($theData);
			echo "hello";
        	$carprice = substr($theData, 1,$lengthy );           
         	$getlastrowiinserted_queryn=sprintf("SELECT count(*) as rowid FROM carsuk.cars"); 
          
           $getlastrowiinserted= mysql_query($getlastrowiinserted_queryn, carsuk.cars) or die(mysql_error());
           while ($line=mysql_fetch_array($getlastrowiinserted)) 
           {
            $rowid= $line['rowid'];
            }
            mysql_query("UPDATE carsuk.cars SET price= '$carprice' WHERE rowid = '$rowid' ");
       }
     }
 
 
  }
  }
fclose($handle);


?>