SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mail/sql script does nothing ( no errors)

    hi my script wont work im not getting any errors any more bt none of the things its supposed to do are working.

    1:) it wont go to the submit page when complete
    2:) the image verification doesnt work
    3:) emails arnt sent
    4:) data not inserted in the database

    i have been looking everywhere and i can work it out? i downloaded zend and checked the code and even that had no errors??

    here is my code, i have explained the image verification in the comments, ( i know it works because im using it on another script)

    PHP Code:
    <html> 
    <head> 
    </head> 
    <body> 

    <?php 
    /* grabs the POST variables and puts them into variables that we can use */ 
    $time date("d/m/Y "time());
    $date date("d/m/Y H:i:s"time());
    $tname=$_POST['tname']; 
    $temail=$_POST['temail']; 
    $yname=$_POST['yname']; 
    $yemail=$_POST['yemail']; 
    $cat=$_POST['cat'];
    $msg=$_POST['mag']; 
    $site_name=$_POST["mysite.com"];
    $site_email=$_POST["mail@mail.com"]; 
    $site_url=$_POST["www.mysite.com"]; 
    $verif_box $_REQUEST["verif_box"];

    // check to see if verificaton code was correct
    if(md5($verif_box).'a4xn' == $_COOKIE['tntcon']){
        
    // if verification code was correct send the message and show this page 

    //---------VALIDATION--------> 
        
    if($tname){//----> CHECK input 
            

            else{ 
                
    $error.="Please, go back and fill out your there name<br>\n";//----> ERROR if no input 
                


        if(
    $temail){//----> CHECK input 
            

            else{ 
                
    $error.="Please, go back and fill out your there email<br>\n";//----> ERROR if no input 
                


        if(
    $yname){//----> CHECK input 
            

            else{ 
                
    $error.="Please, go back and fill out your name<br>\n";//----> ERROR if no input 
                


        if(
    $yemail){//----> CHECK input 
            

            else{ 
                
    $error.="Please, go back and fill out your email<br>\n";//----> ERROR if no input 
                


        if(
    $msg){//----> CHECK input 
            

            else{ 
                
    $error.="Please, go back and fill out your message<br>\n";//----> ERROR if no input 
                



    //-------->ERROR FREE?? 
        
    if($error==""){ 
            echo 
    'submit.php'
    //---------------------------------- 
    $mailContent="" 
                
    ."Hello xxxxsomeone has posted on the site.\n\n"            
                 
    ." ".$msg."\n\n\n\n" 

                
    ." ".$site_name."\n" 
                
    ."--------------------------\n" 
                
    ." ".$site_url."\n";
    //---------------------------------- 
    $toAddress="mysite@mail.com";/* this is line 70 */ 
    $subject="my subject"/* change this! */ 
    $recipientSubject="a new post"/* change this! */ 
    $receiptMessage "" 
    ."Hello ".$tname." you.nn"             ." ".$msg."nnnn" 

                
    ." ".$site_name."n" 
                
    ."--------------------------n" 
                
    ." ".$site_url."n";
    //---------------------------------- 
    mail($email$subject$receiptMessage,"From:$toAddress"); 
    //---------------------------------- 
    mail($toAddress,$recipientSubject,$mailContent,"From:$email"); 
    //--->echo $mailContent; 

    ////////////////////////////////////////  CONNECT TO MYSQL DB  //////////////////// 
    // OPEN CONNECTION ---> 
    $connection=mysql_connect("localhost","user""pass") or die("Unable to connect!"); /* change this! */ 

    mysql_select_db("database") or die("Unable to select database!"); /* change this! */ 

    //  EXECUTE QUERY ---> 
    $query="INSERT INTO name ( 
                name, 
                email, 
                msg, 
                date, 
                category, 
                yname, 
                yemail, 
                time,) 
            VALUES( 
                '"
    .$tname."', 
                '"
    .$temail."', 
                '"
    .$msg."', 
                '"
    .$date."', 
                '"
    .$cat."', 
                '"
    .$yname."', 
                '"
    .$yemail."', 
                '"
    .$time."',)"
    //////-----> 
    $result=mysql_query($query) or die("Error in query:".mysql_error()); 
    //if ($result) 
        //echo mysql_affected_rows()." row inserted into the database effectively."; 

    //  CLOSE CONNECTION ---> 
    mysql_close($connection); 

        
    // delete the cookie so it cannot sent again by refreshing this page
        
    setcookie('tntcon','');
    } else {
        
    // if verification code was incorrect then return to contact page and show error amd keep all the field fillex out
        
    header("Location:".$_SERVER['HTTP_REFERER']."?tname=$tname&temail=$temail&yname=$yname&yemail=$yemail&wrong_code=true");
        exit;

    /////////////////////////////////////////////////////////////////////////////////// 
            

        else{ 

                print 
    "Sorry, but the form cannot be sent until the fields indicated are filled out completely - <br>n"
                print 
    "$error<br>n"
                print 
    "<br>n"
                print 
    "<br>n"
                print 
    "Please use your "Back" button to return to the form to correct the omissions.  Thank you.<br>\n"
            } 

    ?> 
    </body> 
    </html>

    any help would be great thanks

  2. #2
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    17,260
    Mentioned
    196 Post(s)
    Tagged
    2 Thread(s)

    no error

    Hi farkewie, welcome to the forums,
    Try this
    PHP Code:
    .....
    echo 
    $error;
    //-------->ERROR FREE?? 
        
    if($error==""){ 


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •