Re: Re: Problem with function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jason Pruim wrote:

On Sep 12, 2008, at 8:53 AM, Nathan Rixham wrote:

Jason Pruim wrote:

nothing obvious to me.. so debug more!

<?PHP

   function notify_email($Record, $salesRepID) {
    echo "in notify_email" . PHP_EOL;
       require("defaults.php");
    echo "already loaded and required defaults loaded" . PHP_EOL;
       require("func.sendemail.php");
    echo "require func.sendemail.php loaded" . PHP_EOL;
       require("dbmysqliconnect.php");
    echo "already loaded and required dbmysqliconnect loaded" . PHP_EOL;

will tell you where it's breaking I'd assume..

Okay, when I had that in the notify_email.php file it looked like it all loaded just fine... the echo's were displayed.

When I put that in my process.php file I got this output:
already loaded and required defaults loaded Just before send_email functionjust after send_email funtion
require func.sendemail.php loaded
already loaded and required dbmysqliconnect loaded
execute error Duplicate entry '0' for key 1

So I think Jochem might be right... Problem with mysqli?


--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx





actually on closer inspection the problem looks here..

following requires 16 params:
    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));


17 params bound AND rdoTime + areaPlans are in wrong order or are just wrong..


    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));

may help; probable causing the duplciate error problem; (doesn't explain first error though)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux