Jump to content

eskimowned

Members
 View Profile  See their activity

  • Posts

    26

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by eskimowned

    Insert record into MYSQL table as part of PHPmailer script

    in PHP Coding Help

    Posted

    Just made those changes, the mail form works fine, but nothing seems to happen with the MYSQL - I get no error message either.

    [code]<?php require_once('../../Connections/Conn1.php'); ?>
    <?php
    mysql_select_db($database_Conn1, $Conn1);
    $query_UpdateCustInfo = "SELECT * FROM Customer";
    $UpdateCustInfo = mysql_query($query_UpdateCustInfo, $Conn1) or die(mysql_error());
    $row_UpdateCustInfo = mysql_fetch_assoc($UpdateCustInfo);
    $totalRows_UpdateCustInfo = mysql_num_rows($UpdateCustInfo);

    $company = $_POST['Company'];
    $first = $_POST['FirstName'];
    $last = $_POST['LastName'];
    $event = $_POST['Event'];
    $price = $_POST['Price'];

    mysql_query("INSERT INTO CUSTOMER (Company, First Name, Last Name, Event, price) VALUES ('$Company', '$first', '$last', '$event', '$price')");
    mysql_close() or die(mysql_error());

    // Grab our config settings
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/config.php');

    // Grab the FreakMailer class
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/MailClass.inc');

    // instantiate the class
    $mailer = new FreakMailer();

    // Set the subject
    $mailer->Subject = 'This is a test';

    $mailer->isHTML(true);

    // Send the E-Mail
    // Body
    $mailer->Body = '<link href="http://www.womeninbusiness.co.uk/Templates/invoice.css" rel="stylesheet" type="text/css" />

    <table width="700" border="0">
      <tr>
        <td><span class="normalboldstyle">Women In Business </span><span class="style16"><br />
          <span class="normalboldstyle">Egerton House | 2 Tower Road | Birkenhead | Wirral | CH41 1FN <br />
    Telephone 07966 308405 <br />
    www.womeninbusiness.co.uk</span></span></td>
        <td colspan="2"><div align="right"><img src="http://www.womeninbusiness.co.uk/images/WIBsphere.jpg" width="188" height="188" alt="WIBlogo" longdesc= /></div></td>
      </tr>
      <tr>
        <td colspan="3"><div align="center" class="largetitlestyle">Invoice</div></td>
      </tr>
      <tr>
        <td class="normalboldstyle">Inv No. </td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><span class="normalboldstyle">COMPANYNAME<br />
    NAMES<br />
    ADDRESS<br />
    POSTCODE<br />
    TELEPHONE</span></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td class="normalboldstyle">Course Name </td>
        <td class="normalboldstyle">Number of People </td>
        <td class="normalboldstyle"><div align="right">Cost </div></td>
      </tr>
      <tr>
        <td class="normalboldstyle">&nbsp;</td>
        <td class="normalboldstyle">&nbsp;</td>
        <td class="normalboldstyle"><div align="right">&pound;</div></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3"><div align="center"><span class="smalltitlestyle">Payment by BACs to 12-24-81 - a/c no. 06073075 or by cheque payable to Women In Business</span></div></td>
      </tr>
    </table>

    <h2>WIB HTML test</h2>
    <p>Visit us <a href="http://www.womeninbusiness.co.uk" title="Women In Business">Women In Business.co.uk</a> for a loving community!</p>

    </p>Dear '. $first. '

    <p>Sincerely,<br>
    Shauns Web test </p>';

    // Add an address to send to.
    $mailer->AddAddress('shaun@designatedassociates.com', 'shaun');

    if(!$mailer->Send())
    {
      echo 'There was a problem sending this mail!';
    }
    else
    {
      echo 'Mail sent!';
    }
    $mailer->ClearAddresses();
    $mailer->ClearAttachments();
    ?>
    <?php
    mysql_free_result($UpdateCustInfo);
    ?>
    [/code]

    Cheers in advance for anyones help.

    Insert record into MYSQL table as part of PHPmailer script

    in PHP Coding Help

    Posted

    I'm currently trying to insert a record into a database as part of the PHPmailer. This is the code I have so far but the insert row doesn't seem to be doing anything.

    [code]<?php require_once('../../Connections/Conn1.php'); ?>
    <?php
    mysql_select_db($database_Conn1, $Conn1);
    $query_UpdateCustInfo = "SELECT * FROM Customer";
    $UpdateCustInfo = mysql_query($query_UpdateCustInfo, $Conn1) or die(mysql_error());
    $row_UpdateCustInfo = mysql_fetch_assoc($UpdateCustInfo);
    $totalRows_UpdateCustInfo = mysql_num_rows($UpdateCustInfo);

    $company = $_POST['Company'];
    $first = $_POST['FirstName'];
    $last = $_POST['LastName'];
    $event = $_POST['Event'];
    $price = $_POST['Price'];

    mysql_query("INSERT INTO CUSTOMER (Company, `First Name`, `Last Name`, Event, price) VALUES ('$Company', '$first', '$last', '$event', '$price')");
    mysql_close();

    // Grab our config settings
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/config.php');

    // Grab the FreakMailer class
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/MailClass.inc');

    // instantiate the class
    $mailer = new FreakMailer();

    // Set the subject
    $mailer->Subject = 'This is a test';

    $mailer->isHTML(true);

    // Send the E-Mail
    // Body
    $mailer->Body = '<link href="http://www.womeninbusiness.co.uk/Templates/invoice.css" rel="stylesheet" type="text/css" />

    <table width="700" border="0">
      <tr>
        <td><span class="normalboldstyle">Women In Business </span><span class="style16"><br />
          <span class="normalboldstyle">Egerton House | 2 Tower Road | Birkenhead | Wirral | CH41 1FN <br />
    Telephone 07966 308405 <br />
    www.womeninbusiness.co.uk</span></span></td>
        <td colspan="2"><div align="right"><img src="http://www.womeninbusiness.co.uk/images/WIBsphere.jpg" width="188" height="188" alt="WIBlogo" longdesc= /></div></td>
      </tr>
      <tr>
        <td colspan="3"><div align="center" class="largetitlestyle">Invoice</div></td>
      </tr>
      <tr>
        <td class="normalboldstyle">Inv No. </td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><span class="normalboldstyle">COMPANYNAME<br />
    NAMES<br />
    ADDRESS<br />
    POSTCODE<br />
    TELEPHONE</span></td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td class="normalboldstyle">Course Name </td>
        <td class="normalboldstyle">Number of People </td>
        <td class="normalboldstyle"><div align="right">Cost </div></td>
      </tr>
      <tr>
        <td class="normalboldstyle">&nbsp;</td>
        <td class="normalboldstyle">&nbsp;</td>
        <td class="normalboldstyle"><div align="right">&pound;</div></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3"><div align="center"><span class="smalltitlestyle">Payment by BACs to 12-24-81 - a/c no. 06073075 or by cheque payable to Women In Business</span></div></td>
      </tr>
    </table>

    <h2>WIB HTML test</h2>
    <p>Visit us <a href="http://www.womeninbusiness.co.uk" title="Women In Business">Women In Business.co.uk</a> for a loving community!</p>

    </p>Dear '. $first. '

    <p>Sincerely,<br>
    Shauns Web test </p>';

    // Add an address to send to.
    $mailer->AddAddress('shaun@designatedassociates.com', 'shaun');

    if(!$mailer->Send())
    {
      echo 'There was a problem sending this mail!';
    }
    else
    {
      echo 'Mail sent!';
    }
    $mailer->ClearAddresses();
    $mailer->ClearAttachments();
    ?>
    <?php
    mysql_free_result($UpdateCustInfo);
    ?>
    [/code]


    Any help is as ever - greatly appreciated.
    Peace

    Multiple Form Actions

    in PHP Coding Help

    Posted

    That worked - you are a legend! Thanks to everyone who gave me suggestions, this is a bit of a learning curve for me, so all of your advice is greatly appreciated.

    Now I know I'm pushing my luck here - but has anyone any ideas why the insert record query at the top isn't doin anything?

    Cheers

    Liverpool Eskimo

    Insert record into MYSQL table via a mailscript

    in MySQL Help

    Posted

    If there is anyone who can tell me where I'm going wrong here that would be awesome.

    [code]<?php require_once('../../Connections/Conn1.php'); ?>
    <?php
    mysql_select_db($database_Conn1, $Conn1);
    $query_UpdateCustInfo = "SELECT * FROM Customer";
    $UpdateCustInfo = mysql_query($query_UpdateCustInfo, $Conn1) or die(mysql_error());
    $row_UpdateCustInfo = mysql_fetch_assoc($UpdateCustInfo);
    $totalRows_UpdateCustInfo = mysql_num_rows($UpdateCustInfo);

    $company = $_POST['Company'];
    $first = $_POST['FirstName'];
    $last = $_POST['LastName'];
    $event = $_POST['Event'];
    $price = $_POST['Price'];

    mysql_query("INSERT INTO CUSTOMER (Company, First Name, Last Name, Event, price) VALUES ('$Company', '$first', '$last', '$event', '$price')");
    mysql_close();

    // Grab our config settings
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/config.php');

    // Grab the FreakMailer class
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/MailClass.inc');

    // instantiate the class
    $mailer = new FreakMailer();

    // Set the subject
    $mailer->Subject = 'This is a test';

    $mailer->isHTML(true);

    // Send the E-Mail
    // Body
    $mailer->Body = '<img src="http://www.womeninbusiness.co.uk/images/WIBsphere.jpg" alt="WIB logo" /><br />

    <h2>WIB HTML test</h2>
    <p>Visit us <a href="http://www.womeninbusiness.co.uk" title="Women In Business">Women In Business.co.uk</a> for a loving community!</p>
    <?php echo"Dear $first"?>

    <p>Sincerely,<br>
    Shauns Web test </p>';

    // Add an address to send to.
    $mailer->AddAddress('shaun@designatedassociates.com', 'shaun');

    if(!$mailer->Send())
    {
      echo 'There was a problem sending this mail!';
    }
    else
    {
      echo 'Mail sent!';
    }
    $mailer->ClearAddresses();
    $mailer->ClearAttachments();
    ?>
    <?php
    mysql_free_result($UpdateCustInfo);
    ?>
    [/code]

    Any help anyone can offer, is as always greatly appreciated.

    Multiple Form Actions

    in PHP Coding Help

    Posted

    Cheers for the help, I made the suggested change but this time nothing happened, the email came through but the php variable didn't come through. doh!

    I still cant get it to update the table either.

    Sorry to be a pain, but if anyone can shed any light on this it would be quality.

    Multiple Form Actions

    in PHP Coding Help

    Posted

    [code]<?php require_once('../../Connections/Conn1.php'); ?>
    <?php
    mysql_select_db($database_Conn1, $Conn1);
    $query_UpdateCustInfo = "SELECT * FROM Customer";
    $UpdateCustInfo = mysql_query($query_UpdateCustInfo, $Conn1) or die(mysql_error());
    $row_UpdateCustInfo = mysql_fetch_assoc($UpdateCustInfo);
    $totalRows_UpdateCustInfo = mysql_num_rows($UpdateCustInfo);

    $company = $_POST['Company'];
    $first = $_POST['FirstName'];
    $last = $_POST['LastName'];
    $event = $_POST['Event'];
    $price = $_POST['Price'];

    mysql_query("INSERT INTO CUSTOMER (Company, `First Name`, `Last Name`, Event, price) VALUES ('$Company', '$first', '$last', '$event', '$price')");
    mysql_close();

    // Grab our config settings
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/config.php');

    // Grab the FreakMailer class
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/MailClass.inc');

    // instantiate the class
    $mailer = new FreakMailer();

    // Set the subject
    $mailer->Subject = 'This is a test';

    $mailer->isHTML(true);

    // Send the E-Mail
    // Body
    $mailer->Body = '<img src="http://www.womeninbusiness.co.uk/images/WIBsphere.jpg" alt="WIB logo" /><br />

    <h2>WIB HTML test</h2>
    <p>Visit us <a href="http://www.womeninbusiness.co.uk" title="Women In Business">Women In Business.co.uk</a> for a loving community!</p>
    <?php "Dear ". $first. "<br/>";?>

    <p>Sincerely,<br>
    Shauns Web test </p>';

    // Add an address to send to.
    $mailer->AddAddress('shaun@designatedassociates.com', 'shaun');
    $mailer->AddAddress('darren.wirth@designatedassociates.com', 'Darren');

    if(!$mailer->Send())
    {
      echo 'There was a problem sending this mail!';
    }
    else
    {
      echo 'Mail sent!';
    }
    $mailer->ClearAddresses();
    $mailer->ClearAttachments();
    ?>
    <?php
    mysql_free_result($UpdateCustInfo);
    ?>
    [/code]

    I've also included a copy of the code to show the update record query, thats not working either, DOH!

    Any help anyone can give me on that as well would be awesome. Cheers everyone!

    Multiple Form Actions

    in PHP Coding Help

    Posted

    [code]<?php

    $company = $_POST['Company'];
    $first = $_POST['FirstName'];
    $last = $_POST['LastName'];
    $event = $_POST['Event'];
    $price = $_POST['Price'];

    // Grab our config settings
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/config.php');

    // Grab the FreakMailer class
    require_once($_SERVER['DOCUMENT_ROOT'].'/PHPdocs/phpmailer/MailClass.inc');

    // instantiate the class
    $mailer = new FreakMailer();

    // Set the subject
    $mailer->Subject = 'This is a test';

    $mailer->isHTML(true);

    // Send the E-Mail
    // Body
    $mailer->Body = '<img src="http://www.womeninbusiness.co.uk/images/WIBsphere.jpg" alt="WIB logo" /><br />

    <h2>WIB HTML test</h2>
    <p>Visit us <a href="http://www.womeninbusiness.co.uk" title="Women In Business">Women In Business.co.uk</a> for a loving community!</p>
    <?php "Dear ". $first. "<br/>";?>
    <p>Sincerely,<br>
    Shauns Web test </p>';

    // Add an address to send to.
    $mailer->AddAddress('shaun@designatedassociates.com', 'shaun');
    $mailer->AddAddress('darren.wirth@designatedassociates.com', 'Darren');

    if(!$mailer->Send())
    {
      echo 'There was a problem sending this mail!';
    }
    else
    {
      echo 'Mail sent!';
    }
    $mailer->ClearAddresses();
    $mailer->ClearAttachments();
    ?>
    [/code]

    The bit I can't get to display is the <?php "Dear ". $first. "<br/>";?>

    Any ideas?
    Any help is always greatly appreciated

    Multiple Form Actions

    in PHP Coding Help

    Posted

    Quality - Cheers geezer!

    I think I know how to get that to work.

    Just a quick question about the mail form - using PHPmailer how do you show form vairiables as part of the HTML body?

    Any help on that would be sweet.

    Cheers in advance.  PEACE

    Multiple Form Actions

    in PHP Coding Help

    Posted

    Excellent advice gents - I was hoping for a little more than "yes this can be done" :D.

    I'll clarify it a little better, I was probably a little vague: all I want to do is when the submit button is clicked it inserts a record into the database and email some information. How can this be done.

    Or would I do it by updating the database within the mail script the form action sends to.

    Any help anyone can give me is always greatly appreciated.

    Sending formated HTML email via PHP form

    in Editor Help (PhpStorm, VS Code, etc)

    Posted

    Ok - so heres my problem.

    I have a booking system that I have created using a mixture of MYSQL and PHP. Essentially you go to an event, if you would like to attend you click the book now button. From there the event details are taken accross and you fill out an online form to confirm.

    Now here's the problem I have - When you confirm this booking I need the information of event and customer to update to a table and send an invoice via email.

    How do I update table and mail at the same time when the submit button is pressed?

    How can formated HTML emails be sent via PHP?

    Any help is always greatly appreciated.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.