PHP - Error Handling For Mail() On A Windows Box

I have a prepared statement that returns an Article from my database.  It then binds the results-set to variables.

Most of the fields in the query are "required", so I *assume* that I am guaranteed to always get values back for those fields...

Is that presumptuous?

Here is a snippet of my code...

// Execute query.
mysqli_stmt_execute($stmt);

// Store results.
mysqli_stmt_store_result($stmt);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt)==1){
// Article was Found.
$articleExists = TRUE;

// Bind result-set to variables.
mysqli_stmt_bind_result($stmt, $articleID, $title, $description, $keywords, 
$heading, $subHeading, $publishedOn, $author,
$body, $referenceListing, $endnoteListing);

// Fetch record.
mysqli_stmt_fetch($stmt);

// Close prepared statement.
mysqli_stmt_close($stmt); // ????



Is it sufficient to have code like this...

Code: [Select]
<title><?php echo $title; ?></title>
...or do I need more error-handling??

Hope that makes sense?!

Thanks,


Debbie

Hi
I'm completely new to error handling in PHP and wanted to ask whether I'm doing it right and, if not, what the right way would look like

class DBConnection {

public function execute($sql) {

$query = @pg_query($this->dbconn, $this->prepare($sql));

try {

if (!$query) {

throw new DBException();

}

} catch (DBException $e) {

echo "Query execution failed";

exit;

}

}
}

My script displays results until I hit an error.  I continually get fatal timeout errors that I am unable to handle or ignore.  Yes I googled and found the custom error handler AND the simpler try/catch.  Still cant figure it out...
It has been 1 hour of playing with this without success so I have to ask  .  Please help.  thanks : )

Code: [Select]
try
{
if(($result=shell_exec("$commandLine")) == false)
{
echo "------>error";
throw new Exception;
}
else
{
echo "---->good";
}
}
catch (Exception $e)
{
echo "@@@__>exception caught";
}

Hello everyone,

quick description of 'error handling' so that everyone understands the solution i am seeking. let php and the database handle the error is not an appropriate answer here.

find out what i mean: using xampp, go to a login screen of your website, then turn off the database before submitting the login data. the connection will be attempted then fail. the browser will display its own error page which is white bg with a message. this is ridiculous. i made a custom handler that allows me to ignore this failure and show my own website with an error message.

now how can i detect an error with a select or update statement? i am not a db designer, so i really don't know how to do it. what say i fetch filed['testmyerror'] and it doesn't exist or there is a problem. how do i write php code that is used to ignore this problem and display my own message. naturally i will log the error and/or log and send email to myself.

anyone able to help? just a tip in the right direction?

Thank you very much, i appreciate this forum and its members always.

Hi.

I'm trying to display all the missing fields (errors) when the user hits SUBMIT.

My logic:

IF there is NO EMAIL THAN add $errortrack array = $errormsg[EMAIL]

IF there is NO OLDPASSWORD THAN add $errortrack array = $errormsg[OLDPASS]

and so on.

At the end, Print ALL the Error messages on the form using <?php foreach ( $errortrack as $key => $value) { 
                echo "<dt>$key:</dt>"; } ?>

The only thing it prints out is "0:" ever though there should be other errors.

What am I missing? 

Site Link http://www.fusionfashionhair.com/newpassform.php
My PHP Code:

<?php
session_start();
?>
<?php
$submit = $_POST['submit'];
// Form Data
$email = $_POST['email'];
$password_old = $_POST['password_old'];
$password_new = $_POST['password_new'];
$password_new_con = $_POST['password_new_con'];
$errorcount = 0;

$errormsg['Email'] = "Email Entered is Invalid";
$errormsg['OldPass'] = "Old Password Entered is Incorrect";
$errormsg['NewPass'] = "New Password Entered is Incorrect";
$errormsg['NewPassCon'] = "New Confirmed Password Entered is Incorrect";
$errormsg['SecCode'] = "Security Code is Incorrect";
$errormsg['NoErr'] = "No Errors, Continue";

$errortrack = array ($errormsg['NoErr']);

if ($_POST[submit]){
    if ($errorstop = "go") {
    $errorstop="go";
    while ($errorstop<>"stop") {
        // check for existance
      if ($email) {
            echo "True - Continue 1";
            echo "<p>----------</p>";
        } else {
            $errortrack = array ($errormsg['Email']);
            $errorcount++;
            $errorstop="stop";
        }
            
        // check for existance
      if ($password_old) {
            echo "True - Continue 2";
            echo "<p>----------</p>";
        } else {
            $errortrack = array ($errormsg['OldPass']);
            $errorcount++;
            $errorstop="stop";
        }        

        // check for existance
      if ($password_new) {
            echo "True - Continue 3";
            echo "<p>----------</p>";
        } else {
            $errortrack = array ($errormsg['NewPass']);
            $errorcount++;
            $errorstop="stop";
        }        

        // check for existance
      if ($password_new_con) {
            echo "True - Continue 4";
            echo "<p>----------</p>";
        } else {
            $errortrack = array ($errormsg['NewPassCon']);
            $errorcount++;
            $errorstop="stop";
        }            
        $errortrack = array ($errormsg="EVERYTHING IS OK");
        $errorstop="stop";
    }//End While Loop

    } else {
        while($errorcount>=0) {
            // Test display all error messages
            echo "<p>----------</p>";
            echo "<p>Error Count = '$errorcount'</p>";


        }
        die ("PLEASE FILL IN ALL FIELDS");
        
    }
}
?>


My Form Code with the PRINT ERROR:
Code: [Select]
    <form action='newpassform.php' method='post' id="regform">
      <fieldset>
        <legend>Change Password</legend>
        <p><?php foreach ( $errortrack as $key => $value) { 
                echo "<dt>$key:</dt>"; } ?></p>
        <p>
          <label for='email'>Email:</label>
          <input name='email' type='text' maxlength="25" value='<?php echo $email; ?>'/>
        </p>
        <p>
          <label for='password_old'>Old Password:</label>
          <input name='password_old' type='password' maxlength="32" />
        </p>
        <p>
          <label for='password_new'>New Password:</label>
          <input name='password_new' type='password' maxlength="32"/>
        </p>
        <p>
          <label for='password_new_con'>Confirm Password:</label>
          <input name='password_new_con' type='password' maxlength="32"/>
        </p>
        <p><span class="required">*</span> Note, username and password are case sensitive</p>
        <p>Forgot your password? <a href="forgot_password.php">Click Here</a></p>
        <p>Login <a href="login.php">Here</a></p>
       <h2>Security Check</h2>
      <p>Enter letters below exactly how they are displayed.  Letter are case sensitive. </p>
      <br />
      <img src="captcha.class.php?usefile=1" />
      <!--OR-->
      <!--<img src="image.php" />-->
     
      <input id='user_code' name='user_code' type='text' size='10' >
      <p>&nbsp;</p>
        <input class="reset" type='reset' value='Cancel' name='reset'>
                <input class="submit" type='submit' value='Continue' name='submit'>
      </fieldset>
    </form>
    <!--End of Form-->

Hey guys i was wondering if someone could help or guide me. I have been messing around with php for quite some months now to the stage where i can code pretty much what i need to. but recently i started using paypals IPN and during testing i realised some problems arise for example when testing and people buying things say the payment failed due to a line not executing in your script for what ever reason, the person has lost their money yet you have gained it and they are lost. Take this code below for example:


public function insertIntoDatabase($firstName,$lastName,$emailAddress,$merchant,$code,$database,$gameNumber)
{
$year = date("Y");
// Check what database we need to submit too::
$sql = "INSERT INTO playerGame (playerFirstName,
playerLastName,
playerEmailAddress,
playerAccountType,
playerCode,
playerGameDate,
playerGameNumber) VALUES (?,?,?,?,?,?,?)";

$stmt = $this->conn->prepare($sql);
$stmt->bind_param('ssssssi',$firstName,$lastName,$emailAddress,$merchant,$code,$year,$gameNumber);
$stmt->execute();
$stmt->close();

return true;
}


this is called on success the paypal IPN script. But what happens if this fails to execute? I suppose i could wrap it in a variable on the other side and test it

if($task)
{
    echo "code executed";
}

but what happens if this fails ? of am i just being paranoid ? hope someone can help dont want to be ripping people off =] Thanks!

Hello,

If I have an index file with:

date_default_timezone_set('GMT');
error_reporting(E_ALL | E_STRICT); 

abstract class A {
    abstract public static function YesIReallyMeanAbstractStatic();
}

class B extends A {
    public static function YesIReallyMeanAbstractStatic() {
    }
}


This will not error.

However if I have:


date_default_timezone_set('GMT');
error_reporting(E_ALL | E_STRICT); 

require('class_a_in_a_different_file.php'); // Or use __autoload() to do the same.

class B extends A {
    public static function YesIReallyMeanAbstractStatic() {
    }
}


This will throw the error:
"Static function A::YesIReallyMeanAbstractStatic() should not be abstract"

I know abstract statics are debatable...
but it makes no sense to me for it to be allowed in the first example but disallowed in other.

So I was wondering if this is a bug? Or is there something else going on here?

I assume the parser is evaluating the included file and then throwing the error which doesn't happen if both classes are in the same file as they can then be evaluated altogether.

Has anyone seen a decent database class for nicely wrapping up all the PDO functions? Ideally I'm after an example to handle database errors properly, insert/update/select queries, prepared statements and transactions. I've had a crack at writing my own and it's a bit messy with error handling everywhere. Maybe I need to put that in a separate class or something.

E.g. here's how I'd do a database update:
$db = new Database();    // In page controller
$params['type'] = $type;
$params['details'] = $details;
$query = 'insert into site_logs (type, details) values (:type, :details)';
$result = $db->preparedUpdate($query, $params);   // returns false if error or # of rows if successful

Just some examples would be great and I'll re-factor my one to make it better. Thanks!

Hi guys, I'm reviewing a piece of small web application and the current application does not have any error / exception handling capability. If there is any error, it would simply show an error message followed by die;.

I'm planning to implement a simple exception handling class to handle the errors. What I'm thinking is a simple redirect when an error is being caught together with an error code that correspond to an error message in a simple flat text file. The error page will then show an error message that corresponds to the code.

Here's what I have so far. Would appreciate if the PHP experts here would give simple pointers to enhance it.

<?php
class MyException extends Exception {}

try {
throw new MyException("error.php");
}

catch (MyException $e) {
$file = $e->getMessage();
header("Location: $file?e=1");
}

?>

This is what I have on my error.php page

<?php
$errorcode = $_GET['e'];

function getErrorMessage($errorcode) {
$errors = file("english.txt");
foreach ($errors as $error) {
list ($key,$value) = explode(",",$error,2);
$errorArray[$key] = $value;
}
return $errorArray[$errorcode];
}
echo "Test <br />";
echo getMessageMap($errorcode);
?>

As you can see here, exception class would redirect user to error.php if an error is caught together with a GET variable on the URL. On error.php page, it would GET the error code and then run it through a function to get the error message of the corresponding error code and then echos it out.

Was wondering if this is a good practice? My ultimate goal here is to avoid displaying the error message itself on private includes file.

Thank you in advance for your suggestions.

This topic has been moved to PHP Applications.

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

Dear my friends
I'm new wit PHP language,i installed WAMP5 which include Apache/2.2.6 and PHP version 5.2.5
i connect my PHP file to MSSQL to get data from this DB,when i execute this script from explorer i got the result successfully but when i want execute this script from windows CMD i got an error (Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 127488 bytes) in C:\wamp\www\smulog\smulog.php on line 8.
i changed memory_limit parameter  from 2M to 990M
also i add line in .htaccess file
php_value memory_limit=999M
and the problem still appear to me,do you have any idea to solve this problem please??

Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\xampp\htdocs\wahab_gl\register.php on line 65

i am getting the above error on running the following code.. i am using the local host at the moment

            $password=md5($password);
            $repeatpassword=md5($repeatpassword);

            //generate random number for activation process
            $random = rand(23456789,98765432);

            $query = mysql_query("

            INSERT INTO users VALUES ('','$fullname','$username','$password','$email','$date','$random','0')

            ");
            $to = $email;
            $subject = "Activate your account!";
            $headers = "From: ayaz.haneef@gmail.com";
            $server = "mailhost.sheffield.co.uk";

            ini_set("SMTP",$server);

            $body = "

            Hello $fullname, \n\n

            You need to activate your account with the link below:
            http://localhost/register.php?id=$lastid&code=$random\n\n

            Thanks!

            ";

            $lastid = mysql_insert_id();


            mail($to, $subject, $body, $headers);

            die("You have been registered! Check your email to activate your account!");

help please

I have a notification system that notifies users of new comments, inside the email I have images, some of the logo, some of different people, everything shows up fine on my computer (yahoo email), however in the iPhones email application no images show up, there are just the blue squares with the question marks in them. I'm not sure what I'm missing.


Code: [Select]
$from = "Kithell <notifications@kithell.com>";
$headers = "From:" . $from ."\r\n";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";


$subject = name($from_id, 'fl').$action;

$message = '<html><body>
<style>@charset "utf-8";
/* CSS Document */


.e-container {
background-color: #FFF;position: relative;width: 90%;min-height:1px;margin-right: auto;margin-left: auto;
}
.e-container .e-m-header {
padding: 2px;
background-image: url(http://www.kithell.com/assets/tall-grey-header.png);
background-repeat: repeat-x;
border: 1px solid #CCC;
background-position: bottom;
display: block;
text-align: center;
}
.e-container p {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
font-weight: normal;
color: #666;
vertical-align: text-top;
display: inline-block;
}
.e-container .e-usr-photo {
display: inline-block;
margin: 10px;
float: left;
background-color: #F4F4F4;
}
.e-container p a {
font-weight: bold;
color: #3F60A3;
text-decoration: underline;
padding: 0px;
float: left;
margin-top: 0px;
margin-right: 5px;
margin-bottom: 0px;
margin-left: 0px;
}
.e-container .e-quotes {
font-size: 20px;
font-weight: bold;
color: #999;
font-family: Tahoma, Geneva, sans-serif;
display: block;
padding: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
margin-left: 75px;
margin-top:10px;

}
.e-container .e-message {
font-size: 13px;
color: #333;
padding: 0px;
margin-top: 0px;
margin-right: 10px;
margin-bottom: 0px;
margin-left: 10px;
clear: none;
display: inline;
}</style>
<div class="e-container"><div class="e-m-header"><img src="http://www.kithell.com/assets/kithell-logo.png" /></div><img class="e-usr-photo" src="http://www.kithell.com/'.photo($from_id, 55).'" /><br /><p><a target="_blank" href="http://www.kithell.com/#/profile&id='.$from_id.'">'.name($from_id, "fl").' </a> '.$action.'<div class="e-quotes">"<p class="e-message">'.nl2br(htmlentities(stripslashes($message))).'</p>"</div></p></div></body></html>';

mail($to,$subject,$message,$headers);

This topic has been moved to Other Web Server Software.

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

Hiya guys,

Have just developed a new mass mailing system for a client, they are getting some emails sent back to them saying that this error has occured: returning message to sender 500 Line too long

I've googled this and found some information on it relating to a certain amount of characters have been passed in one line, and this is something to stop hacking attempts.

What command can I use on the code to stop this?

The content contains HTML and CSS.

Hope someone can help me on this!

Thanks alot!

Glen