Learn VBA & Macros in 1 Week!

PHP - Contact Form Driving Me Crazy

Full Excel VBA Course - Beginner to Expert

Contact Form Driving Me Crazy	View Content

return <<<EOF

<tr>

<tr>

<td class="mainrow">Manager Page</td>

</tr>

<tr>

<td>

<tr>

<td class="row1"><a href="#">Finances</a></td>

</tr>

<tr>

<td class="row2"><a href="manager.php?act=contracts">Contracts</a></td>

</tr>

<tr>

<td class="row1"><a href="#">Holiday Mode</a></td>

</tr>

</table>

</div>

</td>

</tr>

</table>

</td>

<tr>

<td class="mainrow">Manager Releases</td>

</tr>

<tr>

<td>

<tr>

<td class="rowheader" colspan="2">Singles</td>

</tr>

<tr>

</tr>

<tr>

<td class="row1" width="25%">Platinum:</td>

<td class="row1" width="75%">{$band_genre}</td>

</tr>

<tr>

<td class="row2" width="25%">Multi-Platinum:</td>

<td class="row2" width="75%">{$band_status}</td>

</tr>

<tr>

<td class="row1" width="25%">Number 1:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

<tr>

<td class="row1" width="25%">Total:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

<tr>

<td class="rowheader" colspan="2">Albums</td>

</tr>

<tr>

</tr>

<tr>

<td class="row1" width="25%">Platinum:</td>

<td class="row1" width="75%">{$band_genre}</td>

</tr>

<tr>

<td class="row2" width="25%">Multi-Platinum:</td>

<td class="row2" width="75%">{$band_status}</td>

</tr>

<tr>

<td class="row1" width="25%">Number 1:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

<tr>

<td class="row1" width="25%">Total:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

</table>

</div>

</td>

</tr>

</table>

</td>

</tr>

</table>
EOF;

} // end function show

function contract(){

global $DB, $projectx, $func;

$contracts_q = $DB->query("SELECT * FROM `contracts` RIGHT JOIN `bands` ON (contracts.contract_band = bands.band_id) LEFT JOIN `labels` ON (contracts.contract_from = labels.label_id) WHERE contracts.contract_manager='{$projectx->member['id']}'");

if($DB->get_num_rows()){

while($row = $DB->fetch_array($contracts_q)){

$pcontracts .= "<tr>";

if($style != 2){

$class = "row2";

$style = 1;

}else{

$class = "row1";

$style = 2;

}

$pcontracts .= "<td class=\"{$class}\" width=\"20%\">{$row['band_name']}</td>";

$pcontracts .= "<td class=\"{$class}\" width=\"20%\">{$row['label_name']}</td>";

$clength = explode(",", $row['contract_length']);

$csingles = explode("|", $clength[0]);

$calbums = explode("|", $clength[1]);

$pcontracts .= "<td class=\"{$class}\" width=\"30%\">{$csingles[0]} singles ({$csingles[1]}% cut), {$calbums[0]} albums ({$calbums[1]}% cut)</td>";

$pcontracts .= "<td class=\"{$class}\" width=\"10%\">{$row['contract_amount']}</td>";

$pcontracts .= "<td class=\"{$class}\" width=\"20%\">Accept / Reject</td>";

$pcontracts .= "</tr>";

}

}else{

$pcontracts = <<<EOF

<tr>

<td class="row2" colspan="5">You have no contracts.</td>

</tr>
EOF;

}

return <<<EOF

<tr>

<td class="mainrow">Contracts</td>

</tr>

<tr>

<td>

<tr>

<td class="rowheader" width="30%">Terms</td>

<td class="rowheader" width="10%">Amount</td>

<td class="rowheader" width="20%">Decision</td>

</tr>

</table>

</div>

</td>

</tr>

</table>
EOF;

} // end function contract

} // end class skin_manager

?>

Please Help, Trying To Input Data Into Db Driving Me Crazy.

Similar Tutorials

View Content

Hi People.

I am trying to insert data from a form into my database.

Now I have the following code to connect to the DB to update a table so I know that I can connect to the DB ok

Code: [Select]
<?php
// this code I got from the new boston, PHP tutorial 25 in selecting a mysql db
// opens connection to mysql server
$dbc = mysql_connect('localhost', 'VinnyG', 'thepassword');
if (!$dbc) {
die("Not Connected:" . mysql_error ());
}
// select database
$db_selected = mysql_select_db ("sitename",$dbc);
if(!$db_selected)
{
die("can not connect:" . mysql_error ());

}
// testing code

$query="UPDATE users SET username = 'testing testing' WHERE user_id = '2'";
$result=mysql_query($query);

?>

Now here is the code from my form.

Code: [Select]
</head>

<body>
<?php
//include "connection_file.php"
//include "config01.php"

$username = "username";
$height_above = "height_above";
$mb_diff = "mb_diff";
$alternative = "alternative";

?>

<form name = 'form1' method = 'post' action='config01.php'>
<table width="700" border="1" cellspacing="5" cellpadding="5">
<caption>
Submit Your Airfield Details
</caption>
<tr>
<td width="100"> </td>
<td width="200">Your Name</td>
<td width="200"><input type='text' name='username' maxlength='30'></td>
<td width="100"> </td>
</tr>
<tr>
<td> </td>
<td>Height Above MSL</td>
<td><input type='text' name='height_above'maxlength= '30'></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Mb Difference</td>
<td><input type='text' name='mb_diff'maxlength='40'></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Alternative Airfield</td>
<td><input type='text' name='alternative' maxlength='30'></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><input type='submit' name='submit' value='post' /></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<?php
$sql01 = "INSERT INTO users SET user_id = '', username = '$username',height_above = '$height_above', mb_diff = $mb_diff, alternative = $alternative";
$result=mysql_query($sql01);
?>

</body>
</html>

here is the config01.php that the form refers to in the 'action' above.

Code: [Select]
<?php
$host = 'localhost';
$username = 'VinnyG';
$password = 'thepassword';
$db_name = 'sitename';

//connect to database
mysql_connect ("$host","$username","password")or die ("cannot connect to server");
mysql_select_db ("db_name") or die ("cannot select DB");

?>
Please could someone look at the above code and tell me where I'm going wrong. I can connect to the DB and update using the top script but I can't submit the form for some reason. I get a "cannot connect to server" message.

Please someone help. It's been driving me crazy for the past two days.

Regards
VinceG
http://www.microlightforum.com

Another Form Submission Driving Me Mad

Similar Tutorials

View Content

Hi guys, I got this form so a user can submit a care guide for different species of animal. However the script runs, but the query to SET the species information does not run and the success message is not displayed. Here is what I have got

<?php

session_start();
error_reporting(E_ALL);
ini_set('display_errors', '1');

require( 'database.php' );

include('includes/overall/header.php');

$username = $_SESSION['loggedinuser'];


if	(isset($_POST['username'], $_POST['email'], $_POST['fishtype'], $_POST['speciesCommon'], $_POST['speciesScientific'], $_POST['speciesSynonym'], $_POST['origin'], $_POST['size'], $_POST['environment'], $_POST['waterChemistry'], $_POST['temperature'], $_POST['temperature1'], $_POST['feeding'], $_POST['sexing'], $_POST['compatability'], $_POST['temperament'], $_POST['breeding'], $_POST['comments'], $_POST['reward'], $_POST['username'], $_POST['email'] ) ) {
     
    if( $_POST['fishtype'] == "" )
    {
        include('includes/overall/header.php');
        echo "You must select a species type";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['speciesCommon'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select a species type";
        include('includes/overall/footer.php');
    }
  	elseif( $_POST['speciesScientific'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select a scientific name";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['speciesSynonym'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select a species synonym";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['origin'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select the origin of this species";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['size'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select a average size";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['environment'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select the type of environment suited to this species";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['waterChemistry'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select the typeif water chemistry required for this species";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['temperature'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select a minimum temperature for this species";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['temperature1'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select a maximum temperature for this species";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['feeding'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must enter feeding information for this species";
        include('includes/overall/footer.php');
    }
     elseif( $_POST['sexing'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must enter sexing information for this species";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['compatibility'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must enter compatibility information for this species";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['temperament'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must enter temperament information for this species";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['breeding'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must enter breeding information for this species";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['comments'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must enter comments for this species";
        include('includes/overall/footer.php');
    }
    elseif( $_POST['compatibility'] == "" )
    {
        
        include('includes/overall/header.php');
        echo "You must select your reward";
        include('includes/overall/footer.php');
    }
    else
    {
    	
        require( 'database.php' );

        $fishtype = mysqli_real_escape_string($con, $_POST['fishtype']);
        $speciesCommon = mysqli_real_escape_string($con, $_POST['speciesCommon']);
        $speciesScientific = mysqli_real_escape_string($con, $_POST['speciesScientific']);
        $speciesSynonym = mysqli_real_escape_string($con, $_POST['speciesSynonym'] );
		$origin = mysqli_real_escape_string($con, $_POST['origin']);
        $size = mysqli_real_escape_string($con, $_POST['size']);
        $environment = mysqli_real_escape_string($con, $_POST['environment']);
        $waterChemistry = mysqli_real_escape_string($con, $_POST['waterChemistry']);
        $temperature = mysqli_real_escape_string($con, $_POST['temperature']);
        $temperature1 = mysqli_real_escape_string($con, $_POST['temperature1']);
        $feeding = mysqli_real_escape_string($con, $_POST['feeding']);
        $sexing = mysqli_real_escape_string($con, $_POST['sexing']);
        $compatibility = mysqli_real_escape_string($con, $_POST['compatibility']);
        $temperament = mysqli_real_escape_string($con, $_POST['temperament']);
        $breeding = mysqli_real_escape_string($con, $_POST['breeding']);
        $comments = mysqli_real_escape_string($con, $_POST['comments']);
        $reward = mysqli_real_escape_string($con, $_POST['reward']);
        $username = mysqli_real_escape_string($con, $_POST['username']);
        $email = mysqli_real_escape_string($con, $_POST['email']);
   

// Define a query to run 
$regCareGuide = "INSERT INTO species( fishtype, speciesCommon, speciesScientific, speciesSynonym, origin, size, environment, waterChemistry, temperature, temperature1, feeding, sexing, compatibility, temperament, breeding, comments ) VALUES (
                        '". $fishtype ."',
                        '". $speciesCommon ."',
                        '". $speciesScientific ."',
                        '". $speciesSynonym ."',
                        '". $origin ."',
                        '". $size ."',
                        '". $environment ."',
                        '". $waterChemistry ."',
                        '". $temperature ."',
                        '". $temperature1 ."',
                        '". $feeding ."',
                        '". $sexing ."',
                        '". $compatability ."',
                        '". $temperament ."',
                        '". $breeding ."',
                        '". $comments ."',
                        '". $reward."'
                        ) WHERE `username` = '$username' AND `email` = '$email'";
		 
// Query the database 
$result = mysqli_query($con, $regCareGuide); 


// Check if the query failed 
if( !$result ) 
{ 
   die('There was a problem executing the query ('.$regCareGuide.'):<br>('.mysqli_errno($con).') '.mysqli_error($con)); 
} 

else { 

	echo 'Your care guide has been submitted and your account has been credited.';
}    
}
}
include('includes/overall/footer.php');
        
// Close the connection 
mysqli_close($con); 
?>

Hi all, firstly thank you in advance to anyone who replies to this thread. I'll be honest I'm a newbie when I comes to PHP and really am a long way to mastering it. If someone could have a look at my code and tell me where I'm going wrong here then it would be a great help. The problem here is, when I click on the submit button it sends me to the PHP script page and doesn't actually send a email to the address. Please Help and again, thank you in advance. Below is the HTML, <section>

Contact Form Help

Similar Tutorials

View Content

Contact Form

Similar Tutorials

View Content

sir i need this contact form php code to make it work, i make thi deign for my website but dont know what have to put in send.php here i the code


                <h4>Send a Message</h4>
                <div class="contact-form" method="post" action="send.php">
                    <form role="form">
                        <div class="form-group">
                            <label for="name">Name</label>
                            <input type="text" name="name" placeholder="" id="name" class="form-control">
                        </div>
                        <div class="form-group">
                            <label for="email">Email</label>
                            <input type="text" name="email" placeholder="" id="email" class="form-control">
                        </div>
                        <div class="form-group">
                            <label for="phone">Skype</label>
                            <input type="text"name="subject" id="phone" class="form-control">
                        </div>
                        <div class="form-group">
                            <label for="phone">Message</label>
                            <textarea placeholder="" name="message" rows="5" class="form-control"></textarea>
                        </div>
                        <button class="btn btn-danger" type="submit">Submit</button>
                    </form>

Edited by soumikr, 22 December 2014 - 11:35 AM.

Contact Form Help With Php - 05.13.11

Similar Tutorials

View Content

Hello All,

I've successfully figure out how to make a form that connects to My Database, INSERTS the END USERS INFO into my database, and THEN sends a email notification back to the ME that contains the the END USERS INFO.

Is there a line of CODE in PHP to use that I can ALSO send the END USERS INFO from the form THEY FILLED OUT with all their details that was sent back to ME in the initial e-mail?

Also how do I get the date and time to post in the in my e-mail received with from the END USERS containing the date and time of the form filled out. It shows up in my Database HOWEVER, not in my RECEIVED e-mail.

Here is my code below:

<pre>

Code: [Select]
<?php
if (isset($_POST['submitted'])) {
   include('connect2myDB.php');

   $salutation = $_POST['salutation'];
   $first_name = $_POST['first_name'];
   $last_name = $_POST['last_name'];
   $email = $_POST['email'];
   $zip_code = $_POST['zip_code'];
   $newsletter = $_POST['newsletter'];
   $registation_date = $_POST['registation_date'];
   $sqlinsert = "INSERT INTO travelers (salutation, first_name, last_name, email, zip_code, newsletter, registation_date) VALUES ('$salutation', '$first_name','$last_name','$email','$zip_code','$newsletter', NOW()))";

}

?>

<?php

// ALL THE SUBJECT and EMAIL VARIABLES

   $emailSubject = 'MY TEST EMAIL SCRIPTING!!! ';
   $webMaster = 'mrjap1jobs@gmail.com';



// GATHERING the FORM DATA VARIABLES

   $salutation = $_POST['salutation'];
   $first_name = $_POST['first_name'];
   $last_name = $_POST['last_name'];
   $email = $_POST['email'];
   $zip_code = $_POST['zip_code'];
   $newsletter = $_POST['newsletter'];
   $registation_date = $_POST['registation_date'];  // THIS DATA DOES NOT SHOW UP IN MY RECEIVED E-MAIL HOWEVER, IT DOES SHOW UP IN MY DATABASE.... HOW DO I FIX THIS?

   $body = <<<EOD
<br /><hr><br />
<strong>Salutation:</strong> $salutation <br />
<strong>First Name:</strong> $first_name <br />
<strong>Last Name: </strong>$last_name <br />
<strong>Email:</strong> $email <br />
<strong>Zip Code:</strong> $zip_code <br />
<strong>Newsletter:</strong> $newsletter <br />
<strong>Registration Date:</strong> $registation_date <br />
EOD;

// THIS SHOW ALL E-MAILED DATA, ONCE IN THE E-MAILBOX AS READABLE HTML

   $headers = "From: $email\r\n";
   $headers .= "Content-type: text/html\r\n";
   $success = mail($webMaster, $emailSubject, $body, $headers);


// THE RESULTS OF THE FORM RENDERED AS PURE HTML

   $theResults = <<<EOD
<!DOCTYPE HTML>
<html lang="en">
<head>
<style type="text/css">
body {
   font-family:Arial, Helvetica, sans-serif;
   font-size:11px;
   font-weight:bold;
   }

#thankyou_block {
   width: 400px;
   height: 250px;
   text-align:center;
   border: 1px solid #666;
   padding: 5px;
   background-color: #0CF;
   border-radius:8px;
   -webkit-border-radius:8px;
   -moz-border-radius:8px;
   -opera-border-radius:8px;
   -khtml-border-radius:8px;
   box-shadow:0px 0px 10px #000;
   -webkit-box-shadow: 0px 0px 10px #000;
   -moz-box-shadow: 0px 0px 10px #000;
   -o-box-shadow: 0px 0px 10px #000;
   margin: 25px auto;
}

p {
   font-family: Arial, Helvetica, sans-serif;
   font-size: 14px;
   line-height: 18px;
   letter-spacing:1px;
   color: #333;
}

</style>
<meta charset="UTF-8">
<title>THANK YOU!!!</title>
</head>

<body>

<div id="thankyou_block">
<br><br><br>
<h1>CONGRATULATIONS!!</h1>
<h2>YOUR FORM HAS BEEN PROCESSED!!!</h2>
<p>You are now registered in our Database...<br>
we will get back to you very shortly.<br>
Please have a very wondeful day.</p>

</div>
</body>
</html>

EOD;
echo "$theResults";

?>

</pre>

thanks
mrjap1

MOD EDIT: code tags added.