PHP - Script To Count And Remove Duplicate Lines In File

My current code (which works):

Code: [Select]
<?php

$body = explode("\n", $body);
$body = array_slice($body, 3);
$body = implode("\n", $body);

?>

Is there a better way of doing this, so I dont have to explode and implode an array just to accomplish this?

 I have written code in php to connect and insert rows into a MSSQL database. i used odbc to connect database.user can enter his details through the form. after submitting the form the details are getting stored into a database. while inserting rows into a database am not trying to insert duplicate values . for this i have given if conditions.these conditions are able to notice the user cname and name exist in the database if the same name exist. but the else part after these conditions are not working i.e rows are not getting inserted. i put everything inside the while loop. how can i correct it? This is my php code.

          $connect = odbc_connect('ServerDB','sa', 'pwd');
          //connects database 
         $query2="select count(*) from company";//this is needer for loop through 
         $result2=odbc_exec($connect,$query2);   
        while(odbc_fetch_row($result2));   
        {     $count=odbc_result($result2,1); 
           echo "</br>","$count";     } 
          $query1="select * from company";     
          $result1 = odbc_exec($connect, $query1);
          # fetch the data from the database         
          while(odbc_fetch_row($result1))
           {          $compar[$count] = odbc_result($result1, 1);     
           $namearray[$count] = odbc_result($result1, 2);
          if($compar[$count]==$_POST['cname'])   
          {          echo "<script> alert(\"cname Exists\") </script>";   
          }         
          else   if($namearray[$count]==$_POST['name'])     
         {        echo "<script> alert(\"Name Exists\") </script>";        }   
         else
         {     
         $query=("INSERT INTO company(cname,name) VALUES ('$_POST[cname]','$_POST[name]') ");   
          $result = odbc_exec($connect, $query);   
          echo "<script> alert(\"Row Inserted\") </script>"; 
         } 
         }

Dear all,
I want to remove all lines less than 3 words longs so I can stuff the rest into a db.
Can somebody help me?
Thank you in advance

Hi, i got help earlier with the this code-- exploding a field and getting an array, then inserting the array into a multiselect box-- That part is easy and works fine.

Now the explode function gives an array of words with duplicate words in it:
I tried several ways most either give a blank option/value, or the array word..

here is the code:


$query = "SELECT DISTINCT property_functionsexperience FROM #__users_profiles WHERE published = '1' ORDER BY property_functionsexperience ASC";
      $functionsexperiencelistgeneral=doSelectSql($query);      
        foreach($functionsexperiencelistgeneral as $words)
      $property_funcexperilist=$words->property_functionsexperience;      
        $wording = explode(', ', $property_funcexperilist);
        foreach($wording as $funciex)
      $funcexi=array_unique($funciex);
      $funcexpList .= "<option value=\"".$funcexi.','."\">".$funcexi."</option>";
      $funcexpList .= "</optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         


this code is adapted slightly from the working original that gives the double words-- this code gives a blank, but i think its on the correct track!?

I've got a script where the client can upload pictures. The pictures are then resized, thumbnailed, and added to the database. In the process I'm trying to search the database for a duplicate file name and create a new name if necessary:

Code: [Select]
$userfile = 'userfile' . $i;
$tmpLoc = $_FILES[$userfile]['tmp_name'];
$name = $_FILES[$userfile]['name'];
$error = $_FILES[$userfile]['error'];
$type = $_FILES[$userfile]['type'];
$temp = 'album' . $i;
$album = $_POST[$temp];

if($error > 0) {
echo "Error on $name: ";
switch ($error) {
case 1: echo "File exceeded upload_max_filesize"; break;
case 2: echo "File exceeded max_file_size"; break;
case 3: echo 'File only partially uploaded'; break;
case 4: echo 'No file uploaded'; break;
}
echo "</div>";
exit;
}       

// Check for name duplicates and deal with
$query = "SELECT * FROM pictures WHERE src = $name";
$result = mysql_query($query);
if($result)
$dup = true;
while($dup) {
                                                echo "Duplicate file name $name <br />";
$ext;
if($type == 'image/gif')
$ext = '.gif';
else if($type == 'image/jpeg')
$ext = '.jpg';
else if($type == 'image/png')
$ext = '.png';
else
die("Error: Unsupported file type");

$x = 0;
$name = $x . $ext;
                                                echo "Checking $name <br />";
$query = "SELECT * FROM pictures WHERE src = $name";
$result = mysql_query($query);
if(!$result) {
$dup = false;
echo "File successfully renamed to $name to avoid duplicate <br />";
}

$x++;
}


I don't get any errors of any sort, it just never enters the loop

Hello there

Really new by in PHP,  I find out your forums and look really professional, so I'm dropping in some questions.
Maybe can have some help.

I'm setting an old  plugin of WP and got some issues.
The plugin is really nice and dedicated to create a directory inside a website in WP but regretfully no one take care of that code, so no one to ask for.

There are some errors.

Example, lets go with the first one.

When I (or someone) add a new website in the directory the script does not manage correctly a duplicate submissions. I can submit more times the same url.

It is supposed to manage that problem,  here is the code that take care of all the errors.


Code: [Select]
     


 if($title == "" || $url == " " || $url == "http://" || $description == "" || $description == " " || $keyword == "" || $contact_name == "" || $contact_email == "" || !$cat_id)
  {
    if($title == "")
      $error_msg .= "- " . 'Please insert the title of the website!' . " - <br />";
    if($url == " " || $url == "http://" )
      $error_msg .= "- " . 'Please insert the URL of the website!' . " - <br />";
    if(!$cat_id)
      $error_msg .= "- " . 'Please select a category for the website!' . " - <br />";
    if($description == " ")
      $error_msg .= "- " . 'Please write the description of the website!' . " - <br />";
if($description == "")
      $error_msg .= "- " . 'Please write the description of the website!' . " - <br />";
    if($keyword == "")
      $error_msg .= "- " . 'Please write the keywords of the website!' . " - <br />";
    if($contact_name == "")
      $error_msg .= "- " . 'Please insert your name!' . " - <br />";
    if($contact_email == "")
      $error_msg .= "- " . 'Please insert your email address!' . " - <br />";
  }
  else
  {
    $link_id = $class_link->GetLinkId($cat_id, $url, $title);
    if ($link_id != "")
    {
      $error_msg .= "- " . 'This link currently exist!' . " - <br /> ";
    }
  }




It is working fine for all the errors but NOT for the last one...  is not working, no message ""This link currently exist"" and no error come out after the submission that go in smoothly.


So here is the problem.... but can't solve it.

Code: [Select]
  }
  else
  {
    $link_id = $class_link->GetLinkId($cat_id, $url, $title);
    if ($link_id != "")
    {
      $error_msg .= "- " . 'This link currently exist!' . " - <br /> ";
    }
  }



Any idea?

 Thanks ahead of time, I have been working this all week end but get lost....
    a.  I want to insert all the lines from file1.txt into file2.txt .
    b.  I want the all lines in file1.txt to be inserted in file2.txt starting at "<image>"   tag label in file2.txt.
    c. I would like to overwrite all lines that start with the "<image>" tag in file2.txt with the insert (text in file1.txt contains <image> tag also).
 
 file2.txt has lines above  and below the insert point <image>.   The insert text (file1.txt) could be as many as twenty lines (records) all/each beginning with the<image>tag.
Here is what I have done so far.
<?
$key = '<image>';  //a text tag in $file1  and $file2

//copy file 
$file = "file1.txt";
$file2= 'file2.txt";
$newfile = "filetemp.txt";
copy($file, $newfile) or exit("could not copy $file");

//load file array
 $fc = fopen ($file, "r");
 while (!feof ($fc)) 
 {
    $buffer = fgets($fc, 4096);
    $lines[] = $buffer;
 }

fclose ($fc);

//open same file and use "w" to clear file  ,not sure this is needed
$f=fopen($newfile,"w") or die("$file did not open");

/* uncomment to debug
print_r($lines);
print "<br>\n";
*/

//loop through array 'foreach
foreach($lines as $line)
{
       fwrite($f,$line); //rewrite $line in file     
    if (strstr($line,$key)){ //find $key in each line
    fwrite($f,$newline."\n");
    } //rewrite $line in file 
}
fclose($f);

copy($newfile, $file2) or exit("could not copy $newfile");
?>


Again thanks ahead of time,  I just keep losing the flow,  old I guess.

Tom

Hi!

What i can't figure out, is how to delete between 2 given strings in another file.

Explanation:
I have a file, it contains following:
Code: [Select]
### Start of content 0 ###
Some
Radom
Lines with text 1
### End of content 0 ###

### Start of content 1 ###
Some
Radom
Lines with text 2
### End of content 1 ###

### Start of content 2 ###
Some
Radom
Lines with text 3
### End of content 2 ###
And so on, now i need code, which can find line i give and delete between.

Something like this:

If, i give string:
Code: [Select]
### Start of content 0 ###

Then it will delete this line to the

Code: [Select]
### End of content 0 ###

Hope you can help!

All the best:
Mart L.

I have a .txt file containing hundreds of lines of Names (e.g. Brad, Jennifer, etc.)
What coding can I use to only echo the first 20?

I need to read all the rows from a text file between two specific lines into an array where I can process them. I then need to do the same thing again until the end of the file. The file is too large to read the entire file into an array. The number of rows that are between the key lines are variable.

This is what I have so far to read the first set of rows into the array but it is only reading the first row when in fact in this case there are 15. Any pointers as to where I am going wrong please?

if ($_POST['srch']=="Import") {
                            //open file for reading
                            $family_rec=[];
                            $file_handle = fopen($fn, "r");
                            if(!$file_handle){echo "Could not open file";}
                            while(!feof($file_handle)) {
                                $line = fgets($file_handle);
                                if ((strpos($line, "0 @") !== false) && (strpos($line, "FAM") !== false)) {
                                    $famref = explode("@", $line);
                                    $line = fgets($file_handle);
                                    //echo $line."<br>";
                                    do{
                                        $family_rec[]=$line;
                                        $line = fgets($file_handle);
                                        //echo $line."<br>";
                                    }
                                    while((strpos($line, "0 @") !== false) && (strpos($line, "FAM") !== false));
                                    print_r($family_rec);
                                }//end of family

                            }//end of while not eof

                        }//end of import

 

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!

If I want to read in and process a CSV of a 1000 lines how easy is it to do without a database?

By process, I mean read in the data and do simple manipulations + compare each line with a line from another file, that maybe have 50 lines

I was just concerned that I might start hogging the CPU and memory of the server trying to process 1000 lines of data
It's VERY important that I can do WITHOUT a database

I'd only consider a database if it proves that not using will take too much CPU and memory

I've only just began considering making the application - can't give full details - as I've got to figure them out myself!

Any general advice would be great

Thanks


OM

Hey all need some help with the subject title.

Have a user text file with all information(Name, address, passwords, etc..) Need to be able to select the user based on Checkbox selection then hit delete button and all users checked will be removed from the txt file and thus removed from HTML page. Im using PHP to show contents of the txt file into my HTML page.

So far i have:


<?php
                  $file = fopen("user.txt","r");
                     
                  echo '<table border="0" width="100%">
                     <tr>
                     <th>Select</th>
                     <th>Username</th>
                     <th>Password</th>
                     <th>FirstName</th>
                     <th>LastName</th>
                     <th>Email</th>
                     <th>Address</th>
                     </tr>
                  ';
                  while(!feof($file)) {
                     $user = explode(":", fgets($file));
                        
                     echo '<tr>
                        <td><input type="checkbox" name="chkDelete" id = "chkDelete" value="select" /></td>
                        <td>' . $user[0] . '</td>
                        <td>' . $user[1] . '</td>
                        <td>' . $user[2] . '</td>
                        <td>' . $user[3] . '</td>
                        <td>' . $user[4] . '</td>
                        <td>' . $user[5] . '</td>
                     </tr>';
            
                  echo '</table>';
                  fclose($file);
               ?>

Am unsure as to how i would go about doing this, help would be greatly appreciated!

Thanks in advanced,

Daniel.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=343070.0

I've been trying to come up with a way to accurately count a word string which includes punctuation marks. I've got close but the white-space is causing a problem. I have used a couple of functions such as str_replace and explode and I can now get an accurate count for texts with most punctuation and 'normal' white space. BUT.. If I put in three extra spaces between words the count adds 1 to the total.

$words2 = str_replace("-", "", $string); // strips a hypen
$words3 = str_replace('  ', ' ', $words2); // strips double spaces
$words = explode(' ', $words3);

This is obviously NOT a script - rather a string of text being passed through three functions to cleanse it. But as you can see it will strip two white spaces when they occur but no more. So three, four, five etc. will be counted as extra words.

What else could I try to give me an accurate count?

I am very raw at php. 

thanks

Richard