Re: Problem with function

On Sep 12, 2008, at 8:44 AM, Jochem Maas wrote:

Jason Pruim schreef:

So, I am fighting with a problem function... I have used this function on a previous project and it worked just fine, so I'm not sure what changed... The only difference is that on this site, I'm using mod_rewrite to write all non-existent folder requests into a php file to process what to do with it.

so no difference in php versions, etc etc. check phpinfo() output for the current error_reporting/display_errors settings. and learn about error_log() and how to 'tail' the error log (fuck knows how you go about that on windows ... then there are reasons I have a Mac ;-))

So Do I :) The php versions are the same, they are on the same computer :) PHP Version 5.2.0www.entropy.ch Release 3 (Universal Binary) The server is a PowerPC Based comptuer running OS X Server 10.4.11

here's some code: processing file: <?PHP require("php.ini.php"); require("dbmysqliconnect.php"); require("defaults.php"); require("notify_email.php");

the echo '10'; occurs when you include notify_email.php, the other echos only when you call the function in that file.

$link = dbmysqliconnect($server, $username, $password, $database, $link);

can you output anything after this line? chances are you don't have mysqli

mysqli is up and working on the computer... I use it for all my other projects as well. And yes I can I echoed out no problem

$date = time();

       //Do NOT insert or update sales rep database through this method... Only included to be supplied to the notify_email function. JP

$salesRepID = $_POST['txtSalesRepID']; $Record= $_POST['txtRecord'];

my guess is you never reach this line.

notify_email($Record, $salesRepID); $stmt = mysqli_stmt_init($link);

       //Create the statement

mysqli_stmt_prepare($stmt, "UPDATE purl.schreur SET

                       FName = ?,
                       LName = ?,
                       email = ?,
                       phone = ?,
                       record = ?,
                       subscribed = ?,
                       date = ?,
                       IPAddress = ?,
                       Business = ?,
                       Address1 = ?,
                       City = ?,
                       State = ?,
                       Zip = ?,
                       Coffee = ?,
                       Meeting = ?,
                       time = ?")

or die("prepare error " . mysqli_error($link)); mysqli_stmt_bind_param($stmt, 'ssssssssssssssss',

                          $_POST['txtFName'],
                          $_POST['txtLName'],
                          $_POST['txtEmail'],
                          $_POST['txtPhone'],
                          $_POST['record'],
                          $_POST['subscribed'],
                          $date,
                          $_SERVER['REMOTE_ADDR'],
                          $_POST['txtBusiness'],
                          $_POST['txtAddress1'],
                          $_POST['txtCity'],
                          $_POST['txtState'],
                          $_POST['txtZip'],
                          $_POST['rdoCoffee'],
                          $_POST['rdoTime'],
                          $_POST['areaPlans'])

or die( "bind error " . mysqli_error($link)); //Add the record mysqli_stmt_execute($stmt) or die( "execute error " . mysqli_error($link));

       ?>

notify_email.php file: <?PHP

       function notify_email($Record, $salesRepID) {
       require("defaults.php");
       require("func.sendemail.php");
       require("dbmysqliconnect.php");
       $salesRep = array(1 => "tim@schreurprinting.com, jpruim@schreurprinting.com", 2 => "richardc@schreurprinting.com, jpruim@schreurprinting.com", 3 =>"jpruim@schreurprinting.com", 4=>"japruim@raoset.com");
       echo "1";
       $link1 = dbmysqliconnect($server, $username, $password, $database, $link);

echo "2";

       $sql = "SELECT * FROM schreur WHERE record='{$Record}'";
       $row[] = mysqli_query($link1, $sql) or die("Could not perform query: ".mysqli_errno($link1));

echo "3";

       $result = $row[0];
       echo "4";
          //    $dataSet = array();
          //    while ($row = mysqli_fetch_assoc($result)) {

//echo "<br>while<BR>";

//            $dataSet[] = $row;
   //        }
       $from= "No-Reply@schreurprinting.com";
       echo "5";
       $returnPath = "no-reply@schreurprinting.com";
       $replyTo = "no-reply@schreurprinting.com";
       echo $Record;
       echo "6";
   //    echo "<br>Just before while in notify_email.php<br>";
              //    echo "<br>directly above while<br>";
          //    echo "<BR>dataset print: ";
   //    print_r($dataSet);
   //    echo "<BR>";
   //    echo "<br>directly above foreach<br>";
           //foreach ( $dataSet AS $row ) {
       echo "6";
       while ($row = mysqli_fetch_assoc($result)) {               echo "inside while";
           //Build the e-mail headers
           $ID = $row['salesRep'];
           $to = $salesRep[$ID];
           $headers = "From: ".$from."\n";
           $headers .= "Return-Path: ".$returnPath."\n";
           $headers .= "Reply-To: ".$replyTo."\n";
                  $subject = "{$row['FName']} wants coffee!";
                      $message = "First Name: {$row['FName']} \n";
           $message .= "Last Name: {$row['LName']}\n";
           $message .= "Company " . $row['Business'] . "\n";
           $message .= "Email:" .$row['email'] . "\n";
           $message .= "Phone: " .$row['phone'] . "\n";
           $message .= "Address: " . $row['Address1'] . "\n";
           $message .= "City: " . $row['City'] . "\n";
           $message .= "State: " .$row['State'] . "\n";
           $message .= "Zip: ". $row['Zip'] . "\n";
           $message .= "Coffee of choice: ".$row['Coffee'] . "\n\n";
           $message .= "When a good time would be: \n".$row['Meeting'] . "\n\n";
           $message .= "Current plans: \n\n";
           $message .= $row['plans'] . "\n\n";
               send_email($to, $subject, $message, $headers);
                  }

echo "7";

       echo <<<PRE
       <pre>

Headers: $headers To: $to Subject: $subject Message:

       $message
       </pre>

PRE; echo "8";

       echo "Just after end of while in notify_email.php";
       //    header("Location: index.php");
       echo "9";

} //Function closed echo "10"; ?> yes all of the echo's in there are for testing purposes to see where it's choking. Ever since I started using mod_rewrite, I seem to have lost my error reporting from php so if someone knows a trick on how to fix that I would appreciate it :) On my page when I load it, all I see is the "10" I echo at the end of the notify_email function. I think I'm having another dense moment and it will be something simple but I have looked over the code for the past day with no break throughs.... So ANY help is greatly appreciated, and comes with a beverage of choice if you can make it to where I am! :)

consider posting example code that is a little more succinct, it also helps *you* if you take the time to write test code that strips everything not directly related to the problem it's usually easier to find it.

Normally I do much better... Usually I have a better idea where the issue is so I can boil it down to a smaller area. This time though... I'm clueless so I figured it would be better to post more :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com japruim@raoset.com