PHP - How Can I Get Paypal To Send Variables Back To Me Once Completed?

Hi All,

I have a table (with an ID of example) that can be seen he

http://tinyurl.com/cfla7wp

The following script calls jeditable.js and makes the Telephone & Mobile columns editable. Once edited, the table shows the new value plus a * symbol.

Code: [Select]
<script type="text/javascript">
            $(document).ready(function() {
/* Init DataTables */
var oTable = $('#example').dataTable();

/* Apply the jEditable handlers to the table */
$('td:eq(4), td:eq(5)', oTable.fnGetNodes()).editable( 'update_table_tenants.php', {
"callback": function( sValue, y ) {
var aPos = oTable.fnGetPosition( this );
oTable.fnUpdate( sValue, aPos[0], aPos[1] );
},
"submitdata": function ( value, settings ) {
return {
"row_id": this.parentNode.getAttribute("1"),
"column": oTable.fnGetPosition( this )[2]
};
},
"height": "14px"
} );
} );           
</script>

What I need to do however is add the value entered into my database, but I do not know how to do this.

I believe I need to do something like:

UPDATE my_table VALUE whatever column has been edited in the table WHERE tenID is the same as the row selected in the table

i.e. if I update the MOBILE NUMBER of the person called BILL GATES it would find his tenID, update numMobile in the table called my_table

All help appreciated

Dave

Hi,

I would like to send a value in a link and request it back in ajax and set it as a variable in php in the same page, can anyone help me here?

thanks

I made a file for updating data.
I do get the id back from the view page, but not the variable.
What do I do wrong? I'm puzzling a few days, but just don't see it.

This my code:
Code: [Select]
<?php
// init
$msg = '';
$errorMsg = '';
$rep_id = array();
$componist = '';
$repertoire = '';
$titel = '';

$formOK= false;


// + + + + + + + +  GET + + + + + + + + 
if(isset($_GET['id']))  {
$rep_id = inputControl($_GET['id']);
}
if(isset($_GET['componist'])) {
$componist = inputControl($_GET['componist']);
}

//print "session: $login_id, $login_recht"; // TEST van de sessie
// + + + + + + + + + + + + + + + + POST + + + + + + + + + +

if (isset($_POST['UpdateRepSubmit'])) {
  if (isset($_POST['componist'])) {
  $componist = inputControl($_POST['componist']);
}
if (isset($_POST['titel'])) {
   $titel = inputControl($_POST['titel']);
}

}
//print'<pre>'; print_r($repertoire); print '</pre>'; //TEST2


// + + + + + + + + + + + + + + + + + + + queries

$select_query= "SELECT *
FROM repertoire_eng
ORDER BY componist ASC
";


print $select_query; // TEST 3



// # # # # # # # # # # # database connectie # # # # # # # # # # 
$dblink = mysqli_connect($host,$user,$pass,$db) or die ('Mysql-connectie heeft gefaald.');

if (!$dblink) {
// + + + + + + fout bij met maken van databaseverbinding
$errorMsg = "Geen verbinding met de MySQL-server";
}
else {
$result = mysqli_query($dblink, $select_query);

if($result) {
$i = 0;
while ($row = mysqli_fetch_array($result)) { // uitlezen resultaat
$repertoire_ids[$i] = $row['id'];
$componisten[$i] = $row['componist'];
$titels[$i] = $row['titel'];
$i++;

}
}
else {
// + + + + + fout bij het uitvoeren van de query
$errorMsg = "De query kon niet worden uitgevoerd.";
}



// # # # # # # # # # # einde database connectie # # # # # # # # #

mysqli_close($dblink);
}
?>

In the html block:
Code: [Select]
<div id="container">
<form action="edit_repertoire.php" method="post" name="edit_repertoire" onsubmit = "return checkForm(this)">
<fieldset>
<legend>Update repertoire in your list:</legend>


<!-- # # # # # # Toevoegen van een hiddenfield om de id op te halen uit de URL # # # # # #  -->

<input type="hidden" name="id" value = "<?php echo $rep_id; ?>" >

<p>ID= <?php echo $rep_id; ?></p>
<p> Componist = <?php echo $componisten; ?></p>

<!-- + + + + + + + FORMREGELComponist + + + + + + + -->
<div class="formregel">
<div class="formkolomlinks">Composer name:</div>
<div class="formkolomrechts"><input name="componist" id="componist"  type="text"  maxlength="128"
value="<?php echo $componist; ?>"  /> Name first, then the initials! </div>
   
</div><!-- Einde formregel -->


<!-- ++ + + + + + FORMREGEL Compositie en of rol + + + + + + + -->
<div class="formregel">
<div class="formkolomlinks">Composition and or role</div>
<div class="formkolomrechts"><input name="titel" id="titel" type="text"  maxlength="128"
value="<?php echo $titel; ?>" /></div>
   
</div><!-- Einde formregel -->


 
<!-- +++++++ FORMREGEL +++++++ -->
<div class="formregel">
<div class="formkolomlinks"><input name="updateRepSubmit" type="submit" value="Update repertoire" /></div>

   
</div><!-- Einde formregel -->



</fieldset>
</form>
<div class="clear"></div>
</div><!-- einde container -->
</div><!-- einde tot_wrap -->

edit: added [code][/code] blocks

I have been banging my head against a wall for a few days over this and think that I have read so many alternative ways, I have got myself confused!
 
What I am trying to do is post some information into the database and on success, provide certain variables back to my script (for example last_insert_id) as I would like to show a success message an add an option to a select on that page.
 
I am trying to get this part working without the mysql first just so I understand it. Currently I can post the data, have that received successfully in the processing page (addDetail.php) and send back output from that page........
 
insert.php 

$("#sub").click(function() {
  var name = $("#name").val();
  var town = $("#town").val();
        
  jQuery.ajax({
    type: "POST",
    url: "postScripts/addDetail.php",
   
    data: 'name='+name+'&town='+town,
    
    success: function(html) {

      $(".modal-body").prepend(
          "Returned: " +html
        );
    }
  });
  return false
}) 

addDetail.php

$name = $_POST['name'];
$town = $_POST['town'];
 
//Check $_POST data
echo "<pre>"; print_r($_POST) ;  echo "</pre>";
 
$return["name"] = $name;
$return["town"] = $town;

echo json_encode($return); 

 
 Result in insert.php

Returned:
Array
(
    [name] => The Name
    [town] => The Town
)
{"name":"The Name","town":"The Town"}

This works fine to bring back everything on the processing page in one go but I want to bring back separated variables so I can use them individually. I thought that changing 

 "Returned: " +html

to

 "Returned: " +html.name

would allow me to bring back just that variable but it comes back undefined. This is the closest I have got as other methods I tried either brought nothing back or just [objectObject].    How would I be able to bring back both 'name' and 'town' as separated values so I can use them individually in my script?   Thanks in advance   Steve
Edited by MargateSteve, 29 September 2014 - 08:41 AM.

Hey ive been wanting to know how to make a function call another function which will then create a variable which i can send back to first function where i can use it.

I tried somthing like this
Code: [Select]
<?php
a();
function a($wall)
{
b();
echo $wall;
}
function b()
{
$wall = "test";
#a($wall);
}
?>
Thats what i tried but ofcourse didnt work, how would i go about doing this?

Thanks.

sorry there is so much code, but how can I make it so that the flash upload piece of this will be able to send variables, such as file name, to upload-file.php.....so that things can go into my database.  does this make sense?  if you need a working example, tell me and I will send you a PM with the address (don't want too many people knowing where this happens at......

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Multiple File Upload With Progress Bar - Web Developer Plus Demos</title>
<script type="text/javascript" src="js/jquery-1.3.2.js"></script>
<script type="text/javascript" src="js/swfupload/swfupload.js"></script>
<script type="text/javascript" src="js/jquery.swfupload.js"></script>
<script type="text/javascript">

$(function(){
$('#swfupload-control').swfupload({
upload_url: "upload-file.php",
file_post_name: 'uploadfile',
file_size_limit : "9000000000000000000000000000",
file_types : "*",
file_types_description : "Image files",
file_upload_limit : 1000,
flash_url : "js/swfupload/swfupload.swf",
button_image_url : 'js/swfupload/wdp_buttons_upload_114x29.png',
button_width : 114,
button_height : 29,
button_placeholder : $('#button')[0],
debug: false
})
.bind('fileQueued', function(event, file){
var listitem='<li id="'+file.id+'" >'+
'File: <em>'+file.name+'</em> ('+Math.round(file.size/1024)+' KB) <span class="progressvalue" ></span>'+
'<div class="progressbar" ><div class="progress" ></div></div>'+
'<p class="status" >Pending</p>'+
'<span class="cancel" >&nbsp;</span>'+
'</li>';
$('#log').append(listitem);
$('li#'+file.id+' .cancel').bind('click', function(){
var swfu = $.swfupload.getInstance('#swfupload-control');
swfu.cancelUpload(file.id);
$('li#'+file.id).slideUp('fast');
});
// start the upload since it's queued
$(this).swfupload('startUpload');
})
.bind('fileQueueError', function(event, file, errorCode, message){
alert('Size of the file '+file.name+' is greater than limit');
})
.bind('fileDialogComplete', function(event, numFilesSelected, numFilesQueued){
$('#queuestatus').text('Files Selected: '+numFilesSelected+' / Queued Files: '+numFilesQueued);
})
.bind('uploadStart', function(event, file){
$('#log li#'+file.id).find('p.status').text('Uploading...');
$('#log li#'+file.id).find('span.progressvalue').text('0%');
$('#log li#'+file.id).find('span.cancel').hide();
})
.bind('uploadProgress', function(event, file, bytesLoaded){
//Show Progress
var percentage=Math.round((bytesLoaded/file.size)*100);
$('#log li#'+file.id).find('div.progress').css('width', percentage+'%');
$('#log li#'+file.id).find('span.progressvalue').text(percentage+'%');
})
.bind('uploadSuccess', function(event, file, serverData){
var item=$('#log li#'+file.id);
item.find('div.progress').css('width', '100%');
item.find('span.progressvalue').text('100%');
var pathtofile='<a href="uploads/'+file.name+'" target="_blank" >view &raquo;</a>';
item.addClass('success').find('p.status').html('Done!!! | '+pathtofile);
})
.bind('uploadComplete', function(event, file){
// upload has completed, try the next one in the queue
$(this).swfupload('startUpload');
})

});

</script>
<style type="text/css" >
#swfupload-control p{ margin:10px 5px; font-size:0.9em; }
#log{ margin:0; padding:0; width:500px;}
#log li{ list-style-position:inside; margin:2px; border:1px solid #ccc; padding:10px; font-size:12px;
font-family:Arial, Helvetica, sans-serif; color:#333; background:#fff; position:relative;}
#log li .progressbar{ border:1px solid #333; height:5px; background:#fff; }
#log li .progress{ background:#999; width:0%; height:5px; }
#log li p{ margin:0; line-height:18px; }
#log li.success{ border:1px solid #339933; background:#ccf9b9; }
#log li span.cancel{ position:absolute; top:5px; right:5px; width:20px; height:20px;
background:url('js/swfupload/cancel.png') no-repeat; cursor:pointer; }
</style>
</head>
<body>

<h3>&raquo; Multiple File Upload With Progress Bar</h3>

<div id="swfupload-control">
<p>&nbsp;</p>
<input type="button" id="button" />
<p id="queuestatus" ></p>
<ol id="log"></ol>
</div>

</body>
</html>

This will only send 1 goggles information into the database but I have a "adding" page that can actually add more than 1 goggles at once. I have no idea how to go about  saving multiple goggle's information using array or loop.


$name= $_POST['goggles_name'];
$price = $_POST['goggles_price'];
$des = $_POST['goggles_description'];
$file = $_FILES['goggles_image']['name'];
$chkbox = $_POST['upload'];
$id = $_POST['goggles_id'];
 

$query = "UPDATE goggles SET goggles_name = '$name' , goggles_price = '$price' ,goggles_description = '$des' WHERE goggles_id ='".$id."' "; 
$result = mysqli_query($link, $query) or die(mysqli_error($link));

As the topic sais i have a problem trying to send variables to a javascript popup window, i think the problem is on line 38.
I would very much appreciate some help

Code: [Select]
<html>
<head>
<script type="text/javascript">
function newPopup(url)
{
popupWindow = window.open(url,'popUpWindow','height=700,width=400,left=10,top=10,resizable=no,scrollbars=no,toolbar=yes,menubar=no,location=no,directories=no,status=yes')
}
</script>
</head>
<?php
error_reporting(E_ALL);
require_once 'GameQ.php';

$servers = array(
    'server 1' => array('cs', 'd2o.warzone.nu', '27015'),
    'server 2' => array('cs', 'd2o.warzone.nu', '27017'),
    'server 3' => array('cs', 'wc3.warzone.nu', '27017'),
'server 4' => array('cs', 'aim.warzone.nu', '27015'),
'server 5' => array('cs', '83.255.249.204', '27025'),
'server 6' => array('tf2', 'tf2.warzone.nu', '27015'),
'server 7' => array('tf2', '83.255.249.200', '27015'),
'server 9' => array('cssource', 'css.warzone.nu', '27015'),
'server 10' => array('cssource', 'css.warzone.nu', '27017')
);

$gq = new GameQ();
$gq->addServers($servers);
$gq->setOption('timeout', 200);
$gq->setFilter('normalise');
$gq->setFilter('sortplayers', 'gq_ping');

$results = $gq->requestData();

echo "<a href='steam://connect/d2o.warzone.nu:27015'>" . $results["server 1"]['gq_hostname'] . "</a><p>";
echo $results["server 1"]['gq_mapname'] . "<br>";
echo $results["server 1"]['gq_numplayers'] . "/" . $results["server 1"]['gq_maxplayers'];
?> // I think the problem is the line below this one
<a href='JavaScript:newPopup("players.php?address=<?php echo="$results['server 1']['gq_address']"; ?>&port=<?php echo="$results['server 1']['gq_port']"; ?>");'> players online </a>";
<?php
echo "<p><p>";
echo "<a href='steam://connect/d2o.warzone.nu:27017'>" . $results["server 2"]['gq_hostname'] . "</a><p>";
echo $results["server 2"]['gq_mapname'] . "<br>";
echo $results["server 2"]['gq_numplayers'] . "/" . $results["server 2"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/wc3.warzone.nu:27017'>" . $results["server 3"]['gq_hostname'] . "</a><p>";
echo $results["server 3"]['gq_mapname'] . "<br>";
echo $results["server 3"]['gq_numplayers'] . "/" . $results["server 3"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/aim.warzone.nu:27015'>" . $results["server 4"]['gq_hostname'] . "</a><p>";
echo $results["server 4"]['gq_mapname'] . "<br>";
echo $results["server 4"]['gq_numplayers'] . "/" . $results["server 4"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/83.255.249.204:27025'>" . $results["server 5"]['gq_hostname'] . "</a><p>";
echo $results["server 5"]['gq_mapname'] . "<br>";
echo $results["server 5"]['gq_numplayers'] . "/" . $results["server 5"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/tf2.warzone.nu:27015'>" . $results["server 6"]['gq_hostname'] . "</a><p>";
echo $results["server 6"]['gq_mapname'] . "<br>";
echo $results["server 6"]['gq_numplayers'] . "/" . $results["server 6"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/83.255.249.200:27015'>" . $results["server 7"]['gq_hostname'] . "</a><p>";
echo $results["server 7"]['gq_mapname'] . "<br>";
echo $results["server 7"]['gq_numplayers'] . "/" . $results["server 7"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/tf2.warzone.nu:27015'>" . $results["server 8"]['gq_hostname'] . "</a><p>";
echo $results["server 8"]['gq_mapname'] . "<br>";
echo $results["server 8"]['gq_numplayers'] . "/" . $results["server 8"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/css.warzone.nu:27015'>" . $results["server 9"]['gq_hostname'] . "</a><p>";
echo $results["server 9"]['gq_mapname'] . "<br>";
echo $results["server 9"]['gq_numplayers'] . "/" . $results["server 9"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/css.warzone.nu:27017'>" . $results["server 10"]['gq_hostname'] . "</a><p>";
echo $results["server 10"]['gq_mapname'] . "<br>";
echo $results["server 10"]['gq_numplayers'] . "/" . $results["server 10"]['gq_maxplayers'] . " players online <p>";

?>
</html>

After 13 years of laboring over this, I finally got my form fixed today. Just two issues left:   1) Upon form submission, an email is sent out to the user. How do I redirect them to a Thank-You page so they don't have to stare at the Registration screen while the email is being sent out, as this seems to be a little slow.   2) In the body of these emails is a link to click to go to the Login screen. This works fine. However, I also provide them with two email addresses. How do I make them clickable (like the web link)?

$message = $fname.":\n\n"."Thank you for subscribing to my services.\n\nYour login credentials a \n\nUsername: ".$uname."\nPassword: ".$pwd1."\n\nPlease click the link below to proceed to Login screen:\n\nwww.mySite.com/login.php\n\n\n\nTech Support: techsupport@mysite.com\nSales: sales@mysite.com";
    

Thanks for your help, Landslyde   PS: Just kidding abt the 13 years...only took 12
Edited by Landslyde, 25 January 2015 - 05:40 PM.

Hello,

I would like show entries on a list based on their PayPal status. If it is "pending" I don't want them to show on the list. only if their status is "complete". I just recently switched over to WPForms for WordPress. They offer only a basic PHP file that creates a list but they do not support any modifications to that file. What would I need to do to this code to produce the results I need?   

Please see attached files and code pasted below. Thanks for your help,

Steve

<?php
/**
 * Custom shortcode to display WPForms form entries.
 *
 * Basic usage: [wpforms_entries_table id="FORMID"].
 * 
 * Possible shortcode attributes:
 * id (required)  Form ID of which to show entries.
 * user           User ID, or "current" to default to current logged in user.
 * fields         Comma seperated list of form field IDs.
 * 
 * @link https://wpforms.com/developers/how-to-display-form-entries/
 *
 * @param array $atts Shortcode attributes.
 * 
 * @return string
 */

function wpf_entries_table( $atts ) {
 
    // Pull ID shortcode attributes.
    $atts = shortcode_atts(
        [
            'id'     => '',
            'user'   => '',
            'fields' => '',
        ],
        $atts
    );
 
    // Check for an ID attribute (required) and that WPForms is in fact
    // installed and activated.
    if ( empty( $atts['id'] ) || ! function_exists( 'wpforms' ) ) {
        return;
    }
 
    // Get the form, from the ID provided in the shortcode.
    $form = wpforms()->form->get( absint( $atts['id'] ) );
 
    // If the form doesn't exists, abort.
    if ( empty( $form ) ) {
        return;
    }
 
    // Pull and format the form data out of the form object.
    $form_data = ! empty( $form->post_content ) ? wpforms_decode( $form->post_content ) : '';
 
    // Check to see if we are showing all allowed fields, or only specific ones.
    $form_field_ids = ! empty( $atts['fields'] ) ? explode( ',', str_replace( ' ', '', $atts['fields'] ) ) : [];
 
    // Setup the form fields.
    if ( empty( $form_field_ids ) ) {
        $form_fields = $form_data['fields'];
    } else {
        $form_fields = [];
        foreach ( $form_field_ids as $field_id ) {
            if ( isset( $form_data['fields'][ $field_id ] ) ) {
                $form_fields[ $field_id ] = $form_data['fields'][ $field_id ];
            }
        }
    }
 
    if ( empty( $form_fields ) ) {
        return;
    }
 
    // Here we define what the types of form fields we do NOT want to include,
    // instead they should be ignored entirely.
    $form_fields_disallow = apply_filters( 'wpforms_frontend_entries_table_disallow', [ 'divider', 'html', 'pagebreak', 'captcha' ] );
 
    // Loop through all form fields and remove any field types not allowed.
    foreach ( $form_fields as $field_id => $form_field ) {
        if ( in_array( $form_field['type'], $form_fields_disallow, true ) ) {
            unset( $form_fields[ $field_id ] );
        }
    }
 
    $entries_args = [
        'form_id' => absint( $atts['id'] ),
    ];
 
    // Narrow entries by user if user_id shortcode attribute was used.
    if ( ! empty( $atts['user'] ) ) {
        if ( $atts['user'] === 'current' && is_user_logged_in() ) {
            $entries_args['user_id'] = get_current_user_id();
        } else {
            $entries_args['user_id'] = absint( $atts['user'] );
        }
    }
 
    // Get all entries for the form, according to arguments defined.
    $entries = wpforms()->entry->get_entries( $entries_args );
 
    if ( empty( $entries ) ) {
        return '<p>No entries found.</p>';
    }
 
    ob_start();
 
    echo '<table class="wpforms-frontend-entries">';
 
        echo '<thead><tr>';
 
            // Loop through the form data so we can output form field names in
            // the table header.
            foreach ( $form_fields as $form_field ) {
 
                // Output the form field name/label.
                echo '<th>';
                    echo esc_html( sanitize_text_field( $form_field['label'] ) );
                echo '</th>';
            }
 
        echo '</tr></thead>';
 
        echo '<tbody>';
 
            // Now, loop through all the form entries.
            foreach ( $entries as $entry ) {
 
                echo '<tr>';
 
                // Entry field values are in JSON, so we need to decode.
                $entry_fields = json_decode( $entry->fields, true );
 
                foreach ( $form_fields as $form_field ) {
 
                    echo '<td>';
 
                       foreach ( $entry_fields as $entry_field ) {
if ( absint( $entry_field['id'] ) === absint( $form_field['id'] ) ) {
$data = apply_filters( 'wpforms_html_field_value', wp_strip_all_tags( $entry_field['value'] ), $entry_field, $form_data, 'entry-frontend-table' );
if ($entry_field['id'] == 5) {
//code to break apart first and last name, then add a period
$names = explode(' ', $data);
$lastName = array_pop($names);
$data = implode(' ', $names).' '.$lastName[0].'.';
//output the name formatted as "Steve L."
} else if ($entry_field['id'] == 18)  {

    $data = preg_replace("/[^a-zA-Z' ']/", "", $data);
    $data = rtrim($data, " ");
    if ($data == "Sparring Poomsae and Freestyle Poomsae") {
        $data = "Sparring, Poomsae and Freestyle Poomsae";
    
}
echo $data;

}

break;

                            }
                            
                        }    
                   
 
                    echo '</td>';
                }
 
                echo '</tr>';
            }
 
        echo '</tbody>';
 
    echo '</table>';
 
    $output = ob_get_clean();
 
    return $output;
}
add_shortcode( 'wpforms_entries_table', 'wpf_entries_table' );
 

Please, take a look to the following code.After clicking Next it goes to overview.php.Why when I click back on my browser to return to this page again, it is not returning back? When I click back I receive "Confirm Form Resubmission" message. After refreshing page it loads page.
I guess problem is in "session_start();" part. Something to do with cookies.
Please, help me it is very urgent for me.

<?php
session_start();

echo "<html>
<head>
<title>Hello World</title>
<meta http-equiv='Content-Type' content='text/html; charset=Windows-1252'/>
</head>";

require_once ('functions.inc');

if(!isset($_POST['userid'])) {
echo "<script type='text/javascript'>";
echo "window.location = 'index.php'";
echo "</script>";

exit;
}else{

session_register("userid", "userpassword");
$username = auth_user($_POST['userid'], $_POST['userpassword']);

if(!$username) {
$PHP_SELF = $_SERVER['PHP_SELF'];
session_unregister("userid");
session_unregister("userpassword");
echo "Authentication failed " .
"Please, write correct username or password. " .
"try again ";
echo "<A HREF=\"index.php\">Login</A><BR>";
exit;
}
}


function auth_user($userid, $userpassword){
global $default_dbname, $user_tablename;
$user_tablename = 'user';
$link_id = db_connect($default_dbname);
mysql_select_db("d12826", $link_id);

$query = "SELECT username FROM $user_tablename WHERE username = '$userid' AND password = '$userpassword'";
$result = mysql_query($query) or die(mysql_error());

if(!mysql_num_rows($result)){
return 0;
}else{
$query_data = mysql_fetch_row($result);
return $query_data[0];
}
}

echo "hello";
echo "<form method='POST' name='myform' action='overview.php'>";
echo "<input type='submit' value='Next'>";
echo "</form>";

?>

I am working on a phpmailer script that sends an order confirmation email to the customer AND the client at the same time.  If I have the customer email and client email set both to the originating domain's email addresses (myname@myserver.com), then it sends fine.  However, if I try to send to an outside mail server (eg. someone@gmail.com), I get the following errors:

Code: [Select]
SMTP -> FROM SERVER:220 myserver.com ESMTP Exim 4.63 Sat, 18 Sep 2010 15:08:21 -0700
SMTP -> FROM SERVER: 250 myserver.com Hello localhost [127.0.0.1] 250-SIZE 52428800 250-PIPELINING 250-AUTH LOGIN PLAIN 250-STARTTLS 250 HELP
SMTP -> FROM SERVER:250 OK
SMTP -> FROM SERVER:250 Accepted
SMTP -> FROM SERVER:
SMTP -> ERROR: RCPT not accepted from server:
SMTP Error: The following recipients failed: someone@gmail.com Message could not be sent.
Mailer Error: SMTP Error: The following recipients failed: someone@gmail.com

SMTP server error:
I'm not sure what's going on here.  Any SMTP or phpmailer geniuses here that can shed some light on what needs to happen here for this to send to any address?

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';