PHP - Simple Way To Parse Large Xml Files

Hi

I am running debian lenny, apache2 php5. My fail upload fails for large file sizes. A 6.2 MB file uploads file, but a 10.2Mb file fails. I have set the Max file size to 50MB and max_execution to 600  etc in php.ini, but still have the same problems. I  have noticed many others having similar problems. Is there a solution?

Hi

I have a function that strips out lines from files. I'm handling with large files(more than 100Mb). I have the PHP Memory with 256MB but the function that handles with the strip out of lines blows up with a 100MB CSV File.

What the function must do is this:

Originally I have the CSV like:
Code: [Select]
Copyright (c) 2007 MaxMind LLC.  All Rights Reserved.
locId,country,region,city,postalCode,latitude,longitude,metroCode,areaCode
1,"O1","","","",0.0000,0.0000,,
2,"AP","","","",35.0000,105.0000,,
3,"EU","","","",47.0000,8.0000,,
4,"AD","","","",42.5000,1.5000,,
5,"AE","","","",24.0000,54.0000,,
6,"AF","","","",33.0000,65.0000,,
7,"AG","","","",17.0500,-61.8000,,
8,"AI","","","",18.2500,-63.1667,,
9,"AL","","","",41.0000,20.0000,,

When I pass the CSV file to this function I got:
Code: [Select]
locId,country,region,city,postalCode,latitude,longitude,metroCode,areaCode
1,"O1","","","",0.0000,0.0000,,
2,"AP","","","",35.0000,105.0000,,
3,"EU","","","",47.0000,8.0000,,
4,"AD","","","",42.5000,1.5000,,
5,"AE","","","",24.0000,54.0000,,
6,"AF","","","",33.0000,65.0000,,
7,"AG","","","",17.0500,-61.8000,,
8,"AI","","","",18.2500,-63.1667,,
9,"AL","","","",41.0000,20.0000,,

It only strips out the first line, nothing more. The problem is the performance of this function with large files, it blows up the memory.

The function is:

public function deleteLine($line_no, $csvFileName) {

// this function strips a specific line from a file
// if a line is stripped, functions returns True else false
//
// e.g.
// deleteLine(-1, xyz.csv); // strip last line
// deleteLine(1, xyz.csv); // strip first line

// Assigna o nome do ficheiro
$filename = $csvFileName;

$strip_return=FALSE;

$data=file($filename);
$pipe=fopen($filename,'w');
$size=count($data);

if($line_no==-1) $skip=$size-1;
else $skip=$line_no-1;

for($line=0;$line<$size;$line++)
if($line!=$skip)
fputs($pipe,$data[$line]);
else
$strip_return=TRUE;

return $strip_return;
}


It is possible to refactor this function to not blow up with the 256MB PHP Memory?

Give me some clues.

Best Regards,

i have this code
<?php
require_once('dbconnect.php')

$user = "test";
$pass = "test";

$result=mysql_query("SELECT * FROM accounts WHERE user = '$user' AND pass = '$pass' ");

if(mysql_num_rows($result) == 0) {
$login = "&err=Login Failed.";
echo($login);
} else {
$row = mysql_fetch_array($result);
$user = $row['user'];
$pass = $row['pass'];
$login = "&user=".$user."&pass=".$pass."&err=Login Successful.";
echo($login);
}

?>


and im getting this
Parse error: parse error in C:\wamp\www\flashstuff\WTF.php on line 4

line 4 is:
$user = "test";

all the dbconnect stuff is fine


help!

Hello Freaks!

  I am having problem with following code:

<?php simplexml_load_string ('?xml version="1.0" encoding="utf-8"?>'); php?>

 This code is giving me following error

Parse error: syntax error, unexpected '<' in public_html/wp-content/plugins/pluginnamehere/whatever.php on line 665


I know there is only a minor bracket problem that causing me this error. I would be helpful to you if you can modify it for me

Thanks

I have been trying to get my files to upload onto a computer and I receive this message: Parse error: syntax error, unexpected T_STRING in /home/content/19/6550319/html/listing.php on line 27. Line 27 is how the php logs into my SQL. The problem is that I was able to log in before. I just made changes to the form by adding a dropdown menu and price and now it says it doesnt parse.

Can anyone figure this out. I will include the code without the login information because the forum is public but I did put the words left out for you to see where I took out the passcodes.

Code: [Select]
<?php




//This is the directory where images will be saved
$target = "potofiles/";
$target = $target . basename( $_FILES['photo']['name']);

//This gets all the other information from the form
$price=$_POST['price'];
$gig=$_POST['giga'];
$yesg=$_POST['yesg'];
$pic=($_FILES['photo']['name']);
$pic2=($_FILES['phototwo']['name']);
$pic3=($_FILES['photothree']['name']);
$pic4=($_FILES['photofour']['name']);
$description=$_POST['iPadDescription'];
$condition=$_POST['condition'];
$fname=$_POST['firstName'];
$lname=$_POST['lastName'];
$email=$_POST['email']



// Connects to your Database
mysql_connect ("left out", "left out", "left out") or die(mysql_error()) ;
mysql_select_db("left out") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO listing (price,giga,yesg,photo,phototwo,photothree,photofour,iPadDescription,condition,firstName,lastName,email)
VALUES ('$price', '$gig', '$yesg', '$pic', '$pic2', '$pic3', '$pic4', '$description', '$condition', '$fname', '$lname', '$email')") ;

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}

echo date("m/d/y : H:i:s", time()) 


?>

Hello, I never dealt with such a feature before but I found a small script online that I am editing that works just fine.  The problem is that it includes all of the directories in the path of my site in the zip.  So if the path of my webhost is:

/home/bob/files/

the zip will create a folder such as

/home (inside that folder) /bob (inside that folder) /files (then the zipped files I wanted).

I just want the zip files and I did store them out of the www/public_html directory to prevent people from downloading the files directly from the web but is there no way to make it not include all of those directories in the zip and only show the files?  If so I will post the code that I have.  Thanks

I made this for my site and decided to share with the community.

Depending on how you do the code and where, this can keep count of the views in different ways.

Please read the somewhat directions have in the code, make a folder called counters, and be sure to include this below function file. I named the function file index.php and belongs in the counters folder you make.

<?php
/*
name this file index.php and place it into a folder called counters

the function will create a unique text file for each unique item, good for posts or pages and store all the files in the counters folder

For the total website views,add this to your header file or top of your page
<?php
include('counters/index.php');
$website_view_url = "http://".$_SERVER['HTTP_HOST'];
}
$website_views = getViews("$website_view_url");
echo "<br />".$website_views."<br />";
?>

For the total pages or scripts views,add this to your header file or top of your page
<?php
include('counters/index.php');
$total_page_view_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'];
}
$total_page_views = getViews("$total_page_view_url");
echo "<br />".$total_page_views."<br />";
?>

For entire urls including queries,add this to your header file or top of your page
<?php
include('counters/index.php');
$page_queries_view_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'];
if (!empty($_SERVER["QUERY_STRING"])) {
$page_queries_view_url .= "?".$_SERVER['QUERY_STRING'];
}
$page_queries_views = getViews("$page_queries_view_url");
echo "<br />".$page_views."<br />";
?>

for usage in posts like by id:
if do not want the pages counted and did not do the above code,include the below somewhere near the beginning of your page

<?php include('counters/index.php');?>

Then in the posts loop, you can associate your $row['id']; or some other unique value

<?php
$post_views = $row['id'];
$post_views = getViews("$post_views");
echo "<br />Post Views ".$post_views."<br />";
?>

if would like to combine any the above or use them all, just be sure to just include include('counters/index.php'); only one time
*/


function getViews($views_count_value)
{
    $views_count_value = md5("$views_count_value");
    $views_count_file_name = "counters/$views_count_value.txt";
if (!file_exists($views_count_file_name)) {
    $views_count =0;
    $file_handle = fopen($views_count_file_name, 'w') or die("can't open file");
    fwrite($file_handle, "$views_count");
    fclose($file_handle);

}

    $file_handle = fopen($views_count_file_name, "r");
    $views_count = fread($file_handle, filesize("$views_count_file_name"));
    fclose($file_handle);
    if ($views_count <= 0){
    $views_count =1;
    } else {
    ++$views_count;
    }
    $file_handle = fopen($views_count_file_name, "w+");
    fwrite($file_handle, "$views_count");
    fclose($file_handle);
    return("$views_count");

}
?>

hi all
am new to this forum
 help me to overcome from this error
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in D:\wamp\www\quiz1\quiz1.php on line 12

Code: [Select]
<?php

include("contentdb.php");

$display = mysql_query("SELECT * FROM $table ORDER BY id",$db);

if (!$submit) {


echo "<form method=post action=$_SERVER['PHP_SELF']>";
echo "<table border=0>";

while ($row = mysql_fetch_array($display)) {

$id = $row["id"];
$question = $row["question"];
$opt1 = $row["opt1"];
$opt2 = $row["opt2"];
$opt3 = $row["opt3"];
$answer = $row["answer"];

echo "<tr><td colspan=3><br><b>$question</b></td></tr>";
echo "<tr><td>$opt1 <input type=radio name=q$id value=\"$opt1\"></td><td>$opt2 <input type=radio name=q$id value=\"$opt2\"></td><td>$opt3 <input type=radio name=q$id value=\"$opt3\"></td></tr>";

}

echo "</table>";
echo "<input type='submit' value='See how you did' name='submit'>";
echo "</form>";

}

elseif ($submit) 

{

$score = 0;
$total = mysql_num_rows($display);
while ($result = mysql_fetch_array($display)) 


{

$answer = $result["answer"];
$q = $result["q"];

if ($$q == $answer) 
{
$score++; 
}

}

echo "<p align=center><b>You scored $score out of $total</b></p>";
echo "<p>";

if   ($score == $total) {
echo "Congratulations! You got every question right!";
}
elseif ($score/$total < 0.34) {
echo "Oh dear. Not the best score, but don't worry, it's only a quiz.";
}
elseif ($score/$total > 0.67) {
echo "Well done! You certainly know your stuff.";
}
else {
echo "Not bad - but there were a few that caught you out!";
}

echo "</p>";

echo "<p>Here are the answers:";

echo "<table border=0>";
$display = mysql_query("SELECT * FROM $table ORDER BY id",$db);
while ($row = mysql_fetch_array($display)) {

$question = $row["question"];
$answer = $row["answer"];
$q = $row["q"];

echo "<tr><td><br>$question</td></tr>";

if ($$q == $answer) 
{
echo "<tr><td>&raquo;you answered ${$q}, which is correct</td></tr>";
}
elseif ($$q == "") {
echo "<tr><td>&raquo;you didn't select an answer. The answer is $answer</td></tr>";
}
else {
echo "<tr><td>&raquo;you answered ${$q}. The answer is $answer</td></tr>";
}

}
echo "</table></p>";



}

?>

thanks in adavance

Hello I have one problem with fwrite() I have one script to get width and height from javascript and echo it with PHP.
echo "Screen width is: ". $_GET['width'] ."<br />\n";
echo "Screen height is: ". $_GET['height'] ."<br />\n";
It works but i want to store the result in a file
fwrite($info,"Height: $_GET['height'] <br />");
But then I get error Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING
////////////////////////
it would be even better if I don't have to print the values but directly store them in $iinfo
sorry if something similar was soved but those examples were different or i was unable to transform it to solve my problem

I am trying to put a href on a line to link me to another php module, but get an error: Parse error: parse error in C:\wamp\www\editpolicy.php on line 47
My code:
while ($row2 = mysql_fetch_array($result2) )
   {
      print "<tr><td>";
         <a href='editpayment.php?payid=$row2[PaymentID]'>$row2[PaymentID]</a> .........THIS IS LINE 47 ???
      print "</td><td>";
      print $row2['Actioned'];
      print "</td><td align='right'>";
      print $row2['PremiumPaidAmount'];
      print "</td><td align='right'>";
      print $row2['Risk'];
      print "</td></tr>";
   }

Hello


I have a simple question about file handling...


Is it possible to list all files in directories / subdirectories, and then read ALL files in those dirs,
and put the content of their file into an array?

Like this:

array:
[SomePath/test.php] = "All In this php file is being read by a new smart function!";
[SomePath/Weird/hello.txt = "Hello world. This is me and im just trying to get some help!";

and so on, until no further files exists in that rootdir.

All my attempts went totally crazy and none of them works... therefore i need to ask you for help.


Do you have any ideas how to do this?
If so, how can I be able to do it?


Thanks in Advance, pros

So far I have managed to create an upload process which uploads a picture, updates the database on file location and then tries to upload the db a 2nd time to update the Thumbnails file location (i tried updating the thumbnails location in one go and for some reason this causes failure)

But the main problem is that it doesn't upload some files

Here is my upload.php

<?php
include 'dbconnect.php';

$statusMsg = '';

$Title = $conn -> real_escape_string($_POST['Title']) ; 
$BodyText = $conn -> real_escape_string($_POST['ThreadBody']) ; 
	 

// File upload path
$targetDir = "upload/";
$fileName = basename($_FILES["file"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
$Thumbnail = "upload/Thumbnails/'$fileName'";

if(isset($_POST["submit"]) && !empty($_FILES["file"]["name"])){
    // Allow certain file formats
    $allowTypes = array('jpg','png','jpeg','gif','pdf', "webm", "mp4");
    if(in_array($fileType, $allowTypes)){

        // Upload file to server
        if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){

            // Insert image file name into database
            $insert = $conn->query("INSERT into Threads (Title, ThreadBody, filename) VALUES ('$Title', '$BodyText', '$fileName')");
            if($insert){
               $statusMsg = "The file ".$fileName. " has been uploaded successfully."; 

		$targetFilePathArg = escapeshellarg($targetFilePath);
		$output=null;
		$retval=null;
		 //exec("convert $targetFilePathArg -resize 300x200 ./upload/Thumbnails/'$fileName'", $output, $retval);
		 exec("convert $targetFilePathArg -resize 200x200 $Thumbnail", $output, $retval);
		echo "REturned with status $retval and output:\n" ; 
		if ($retval == null) { 
		echo "Retval is null\n" ;
		echo "Thumbnail equals $Thumbnail\n" ; 
		}

            }else{
                $statusMsg = "File upload failed, please try again.";
            } 
        }else{
            $statusMsg = "Sorry, there was an error uploading your file.";
        }
    }else{
        $statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, mp4, webm & PDF files are allowed to upload.';
    }
}else{
    $statusMsg = 'Please select a file to upload.';
}

//Update SQL db by setting the thumbnail column to equal $Thumbnail
$update = $conn->query("update Threads set thumbnail = '$Thumbnail' where filename = '$fileName'");
            if($update){
               $statusMsg = "Updated the thumbnail to sql correctly.";
		echo $statusMsg ;  } 
else 
{ echo "\n Failed to update Thumbnail. Thumbnail equals $Thumbnail" ; } 


// Display status message
echo $statusMsg;
?>

And this does work on most files however it is not working on a 9.9mb png file  which is named "test.png" I tested on another 3.3 mb gif file and that failed too?

For some reason it returns the following

Updated the thumbnail to sql correctly.Updated the thumbnail to sql correctly.

Whereas on the files it works on it returns

REturned with status 0 and output: Retval is null Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif' Failed to update Thumbnail. Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif'The file rainbow-trh-stache.gif has been uploaded successfully.

Any idea on why this is?

echo "</select></td>\r\n  </tr>\r\n \r\n <tr>\r\n <td align=\"right\">Total Views Allowed:</td>\r\n <td><input type=\"text\" id=\"ad_total_views\" style=\"width:50px;\" value=\"\" disabled=\"disabled\" /> <label><input type=\"checkbox\" checked=\"checked\" onclick=\"if(this.checked==true){$('#ad_total_views').val('');$('#ad_total_views').attr('disabled','disabled');}else{$('#ad_total_views').val('');$('#ad_total_views').removeAttr('disabled');$('#ad_total_views').focus()}\" />Unlimited</label></td>\r\n          </tr>\r\n            \r\n            <tr>\r\n              <td align=\"right\">Total Clicks  Allowed:</td>\r\n              <td><input type=\"text\" id=\"ad_total_clicks\" style=\"width:50px;\" value=\"\" disabled=\"disabled\" /> <label><input type=\"checkbox\" checked=\"checked\" onclick=\"if(this.checked==true){$('#ad_total_clicks').val('');$('#ad_total_clicks').attr('disabled','disabled');}else{$('#ad_total_clicks').val('');$('#ad_total_clicks').removeAttr('disabled');$('#ad_total_clicks').focus()}\" />Unlimited</label></td>\r\n          </tr>\r\n        </table></td>\r\n   </tr>\r\n    <tr bgcolor=\"#FFFFFF\">\r\n     <td class=\"td_th\" align=\"center\">Smarty Code (Developer)</td>\r\n     <td>{\$ads->getAdCode(<span id=\"smartycode\">1</span>)}</td>\r\n   </tr>\r\n    <tr bgcolor=\"#FFFFFF\">\r\n      <td class=\"td_th\" align=\"center\">&nbsp;</td>\r\n      <td><input type=\"button\" value=\"Create New Campaign\" onclick=\"new_ad()\" /></td>\r\n    </tr>\r\n    </TBODY></TABLE>\r\n<br />\r\n\r\n<TABLE cellSpacing=1 cellPadding=4 width=\"100%\"  border=0>\r\n  <TBODY>\r\n  <TR class=\"td_title\">\r\n    <TD  colSpan=7>Ad Campaigns</TD></TR>\r\n  <TR bgColor=#ffffff>\r\n  \r\n    <TD width=\"10%\" align=\"center\" class=\"td_th\">&nbsp;</TD>\r\n    <TD width=\"4%\" align=\"center\" class=\"td_th\">ID</TD>\r\n    <TD width=\"29%\" align=\"center\" class=\"td_th\">Campaign Name</TD>\r\n    <TD width=\"12%\" align=\"center\" class=\"td_th\">Start Date</TD>\r\n    <TD width=\"11%\" align=\"center\" class=\"td_th\">End Date</TD>\r\n    <TD width=\"17%\" align=\"center\" class=\"td_th\">Viewed / Views Allowed</TD>\r\n    <TD width=\"17%\" align=\"center\" class=\"td_th\">Clicked / Clicks Allowed</TD>\r\n    </TR>\r\n ";

   $BoxSize = array("smallbox" = array("length" => 12, "width" => 10, "depth" => 2.5),
      "mediumbox" = array("length" => 30, "width" => 20, "depth" => 4),
      "largebox" = array("length" => 60, "width" => 40, "depth" => 11.5));
      

I am using WPSQT plugin in my blog site .I code some files in PHP also.how to add that files in plugin files.