PHP - How To Get The Line Number Of A Csv File?

Hi Guyz,

I need to check the variable $itemDescription to see if the client has entered a '1' before the item description(example: 1 table)

Reason, is the client would like to add sales tax to all NOn-Food related items of 6.25%

This is for a local auction house. It needs to be simple. i,e. Don't wanna add any more form fields. Just let the user type the number 1 before all items that need to be taxed.

Here's my code:
Code: [Select]
<?php
ob_start();
?>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">

</style>
</head>

<?PHP session_start();
ob_start();
# Config settings below
# Change these to whatever you want :)
#############################

$cellsPerRow = '6';

#############################
include('connect.php');

// These queries get the amount of bidders that are in the database
$getAllBidders = mysql_query("SELECT `id` FROM bidders");
$totalBidders  = mysql_num_rows($getAllBidders);


// This section is to check if the Add New Item form has been submitted
  if($_POST['addNewItem']) {
    // Retrieve Query Strings from URL
    $itemDescription = $_POST['itemDescription'];
    $itemPrice       = $_POST['itemPrice'];
    $winningBidder   = $_POST['winningBidder'];
    $totalDeals      = $_POST['totalDeals'];
    $totalPrice      = ($totalDeals*$itemPrice);

    // Check the submitted data and make sure all is correct
    if(!$itemDescription) {
      $message = 'You must enter an Item Description.';
    } else if(!$itemPrice) {
      $message = 'You must enter an Item Price.';
    } else if(!$winningBidder) {
      $message = 'You must enter a Winning Bidder ID.';
    } else if(!$totalDeals) {
      $message = 'You must enter the amount of Deals.';
    } else if(!is_numeric($winningBidder)) {
      $message = 'The Winning Bidder ID can only be numbers.';
    } else {

      // Check to see if the bidder ID already exists
      $checkBidder = mysql_query("SELECT * FROM bidders WHERE biddersId='$winningBidder' LIMIT 1");
      $checkBidder = mysql_fetch_assoc($checkBidder);

      // If the Bidder ID does not exist, we re-direct to allow us to save the Bidder ID
      if(!$checkBidder) {

        header("Location: ?action=confirmListing&iDesc=".$itemDescription."&iPrice=".$itemPrice."&wBidder=".$winningBidder."&tDeals=".$totalDeals."");

      } else {

        // If Bidder ID exists we just insert the transaction accordingly
        mysql_query("INSERT INTO transactions (`itemDescription`, `itemPrice`, `bidderId`, `itemQty`, `totalPrice`) VALUES ('$itemDescription', '$itemPrice', '$winningBidder', '$totalDeals', '$totalPrice');");
        $message1 = 'The transaction has been successfully added.';

mysql_query("SELECT owed From bidders WHERE biddersId='$winningBidder'") or die(mysql_error());
if ($row['owed']==0) {
mysql_query("UPDATE bidders SET owed='1' WHERE biddersId='$winningBidder'") or die(mysql_error()); 
}
      }

    }

  }

// This section is to check if the Add Bidder to database form has been submitted
  if($_POST['confirmBidder']) {
    $itemDescription = $_POST['itemDescription'];
    $itemPrice       = $_POST['itemPrice'];
    $winningBidder   = $_POST['winningBidder'];
    $totalDeals      = $_POST['totalDeals'];
    $totalPrice      = ($itemPrice*$totalDeals);
    $addBidder       = $_POST['addBidder'];
$checkInput= preg_match([1]+*);


if ($itemDescription== $checkInput)
$itemPrice= $itemPrice * 6.25%;

    mysql_query("INSERT INTO transactions (`itemDescription`, `itemPrice`, `bidderId`, `itemQty`, `totalPrice`) VALUES ('$itemDescription', '$itemPrice', '$winningBidder', '$totalDeals', '$totalPrice');");
    $message1 = 'The transaction has been successfully added.';

   
    if($addBidder == 'Yes') {
      mysql_query("INSERT INTO bidders (biddersId) VALUES ('$winningBidder');");
      $message1 .= '<br> The Bidder ID has also been added.';
mysql_query("SELECT owed From bidders WHERE biddersId='$winningBidder'") or die(mysql_error());
if ($row['owed']==0) {
mysql_query("UPDATE bidders SET owed='1' WHERE biddersId='$winningBidder'") or die(mysql_error()); 
}
    }
     
 if($addBidder == 'No') {
                 $message1 = '<br><font color= "red"> Bidder has NOT been logged.</font>';
               }

   // $itemDescription = '';
   // $itemPrice       = '';
   // $winningBidder   = '';
   //  $totalDeals      = '';
   // $totalPrice      = '';
   // $addBidder       = '';
      }

       

   

 

?>


<?PHP
  // This line of code will check the current task we are doing
  if($_GET['action'] == 'confirmListing') {
    $itemDescription = $_GET['iDesc'];
    $itemPrice       = $_GET['iPrice'];
    $winningBidder   = $_GET['wBidder'];
    $totalDeals      = $_GET['tDeals'];
?>

<form name="confirmBidder" method="POST" action="?">

<?PHP
// This is the hidden data from the previous form
// Better than using sessions and GET query
?>
<input type="hidden" name="itemDescription" id="itemDescription" value="<?PHP echo $itemDescription;?>">
<input type="hidden" name="itemPrice" id="itemPrice" value="<?PHP echo $itemPrice;?>">
<input type="hidden" name="winningBidder" id="winningBidder" value="<?PHP echo $winningBidder;?>">
<input type="hidden" name="totalDeals" id="totalDeals" value="1">

<table cellpadding="0" cellspacing="1" border="0" style="background: #ffffff; margin: auto;">
 <tr>
  <td colspan="2" class="formHeader"> Add New Auction Item </td>
 </tr>
 <tr>
  <td class="formField"> Add This Bidder? </td>
  <td class="formValue"> <select name="addBidder" id="addBidder" class="input" style="width: 195px;"> <option value="Yes">Yes</option> <option value="No">No</option></select> </td>
 </tr>
 <tr>
  <td colspan="2" class="formButton">
<input type="submit" name="confirmBidder" id="confirmBidder" value="Confirm Bidder Action?">
<input type="reset" name="reset" id="reset" value="Reset Form">
  </td>
 </tr>
</table>
</form>

<?PHP
  // If the action is not to confirm a listing then show add item section
  } else {
?>

<?PHP//----- Add New Item Section -----\\?>

<?PHP
  if($message) {
    echo '<div class="Error">',$message,'</div><div style="height: 10px;"></div>';
  } else if($message1) {
    echo '<div class="Success">',$message1,'</div><div style="height: 10px;"></div>';
  }
?>

<form name="addNewItem" method="POST" action="?">
<table cellpadding="0" cellspacing="1" border="0" style="background: #ffffff; margin: auto;">
 <tr>
  <td colspan="2" class="formHeader"> Add New Auction Item </td>
 </tr>
 <tr>
  <td class="formField"> Item Description </td>
  <td class="formValue"> <input type="text" name="itemDescription" class="formText" id="itemDescription" value="<?=$itemDescription;?>" style="width: 195px;"> </td>
 </tr>
<tr>
 <td class="formField"> Item Price </td>
  <td class="formValue"> <input type="text" name="itemPrice" class="formText" id="itemPrice" value="<?=$itemPrice;?>" style="width: 195px;"> </td>
 </tr>
 <tr>
  <td class="formField"> Winning Bidder ID </td>
  <td class="formValue"> <input type="text" name="winningBidder" class="formText" id="winningBidder" style="width: 195px;"> </td>
 </tr>
 <tr>
  <td class="formField"> How Many Deals? </td>
  <td class="formValue"> <input type="text" name="totalDeals" class="formText" id="totalDeals" value="1" style="width: 195px;"> </td>
 </tr>
 <tr>
  <td colspan="2" class="formButton">
<input type="submit" name="addNewItem" id="addNewItem" value="Add New Auction Item?">
<input type="reset" name="reset" id="reset" value="Reset Form">
  </td>
 </tr>
</table>
</form>

<?PHP//----- Add New Item Section -----\\?>

<?PHP } ?>


All help appreciated to the fullest...
 

I want to validate a form field for a number with two decimals (ie. 894567.29),
but my script gives me an error, asking me to correct the entry,
Following is a snippet of the script:-

elseif($field == "oil_waste_ltr")
   {
      if(!preg_match("/^[0-9]{1,10}\.{2}$/",$value) )
      {
         $bad_format[] = $field;
      }
   }

 I’ve just read several manual pages and forum comments on "Error number 1064" but I still don’t understand what’s going on with the problem I'm having now … Also, I'm surprised that the error message mentions two different line numbers (1 and 35).

  Here is the error message I get :  


And here are the contents of my "one_more_visit_to_topic.php" file :
 

<?php

include("includes/model/database_searches/see_readings.php");
include("includes/model/database_searches/see_watchings.php");

function one_more_visit_to_topic($user_id,$topic_id)
{
    global $db;
    $request_string='UPDATE forum_topic '.
    'SET topic_vu = topic_vu + 1 WHERE topic_id = :topic';
    $query=$db->prepare($request_string);
    $query->bindValue(':topic',$topic_id,PDO::PARAM_INT);
    $query->execute();
    $query->CloseCursor();
    // Remember that topic has been read by user
    if(!(see_if_user_has_read_topic($user_id,$topic_id))) {
        $request_string='INSERT INTO forum_read (fr_topic_id,fr_user_id) '.
        'VALUES (:topic,:user)';
        $query=$db->prepare($request_string);
        $query->bindValue(':topic',$topic_id,PDO::PARAM_INT);  
        $query->bindValue(':user',$user_id,PDO::PARAM_INT);  
        $query->execute();
        $query->CloseCursor();
    }
    // If user has already received a warning by mail,
    // the "alert" value needs to be toggled in the fw_watch table
    if(see_if_user_has_been_warned($user_id,$topic_id)) {
        $request_string='UPDATE forum_read SET fw_alert = :alt '.
        'WHERE fw_topic_id = :topic AND fw_user_id= :user)';
        $query=$db->prepare($request_string);
        $query->bindValue(':topic',$topic_id,PDO::PARAM_INT);  
        $query->bindValue(':user',$user_id,PDO::PARAM_INT);
        $one=(int)1;
        $query->bindValue(':alt',$one,PDO::PARAM_INT);  
        $query->execute();
        $query->CloseCursor();
    }
    return;
}


?>

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>

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?