PHP mysql error

[amcf1992]

My code as per your code fix: Still stuck at send.php


Code:

PHP Code:

<?php
$con = mysql_connect("localhost","friendko_admin","Macbookpro17#");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }
 
mysql_select_db("friendko_text", $con);
 
$to = $row['cell'];
$carrier = $row['carrier'];
$message = stripslashes($_POST['message']);
$keycode = $_POST['keycode'];
 
$query = "SELECT id, email, keycode, carrier, cell FROM users WHERE keycode = '{$_POST['keycode']}'";
$result = mysql_query($query) or die(mysql_error().'<br>'.$query);  
while($row = mysql_fetch_array($result, MYSQL_ASSOC))  

$carrierto = array();
$carrierto['ATT'] = '@txt.att.net';
$carrierto['DT']  = '@tomomail.net';
$carrierto['S']   = '@messaging.sprintpcs.com';
$carrierto['VM']  = '@vmobl.com';
$cc = $row['carrier']
if ( isset($carrierto[$cc]) )
{
   $formatted_number = $to . $carrierto[$cc];
   mail("$formatted_number", "SMS", "$message");
   header ("Location: sms_success.php");
}
else
   die("Oh crap... I don't know who that is!<br>\n");  
 
?>

Originally Posted by vroom

Alright, before my head explodes... how about creating either a carrierto array or some other way of avoiding the big redirect list... I've taken the liberty of using stock symbols for the phone carriers:

PHP Code:

$carrierto = array();
$carrierto['ATT'] = '@txt.att.net';
$carrierto['DT']  = '@tomomail.net';
$carrierto['S']   = '@messaging.sprintpcs.com';
$carrierto['VM']  = '@vmobl.com';
 
$cc = $row['carrier']
if ( isset($carrierto[$cc]) )
{
   $formatted_number = $to . $carrierto[$cc];
   mail("$formatted_number", "SMS", "$message");
   header ("Location: sms_success.php");
}
else
   die("Oh crap... I don't know who that is!<br>\n"); 


P.S. Is this just a learning experience project?

[amcf1992]

Its part of several PHP projects im doing to be able to better understanding PHP

[amcf1992]

Any help is greatly appreciated.

[Fou-Lu]

Do you get an error or just no send on the mail?

[amcf1992]

It stays stuckk on send.php, It may be something with array or the select statement.
Thanks

[Fou-Lu]

I don't understand what you mean by stuck.
Syntactically there is no infinite loop here to jam it. It is logically incorrect since you are missing braces which means you'll only ever have the last $row record to work with.

The end result should either be an error message by the die calls, or a redirect to sms_success.php assuming that this page is not sms_success.php. If it is, it will attempt to redirect cyclically, but most modern browsers will detect this and issue a stop.

[AndrewGSW]

I'm not sure if you caught my previous post: who is the email From?

[amcf1992]

Originally Posted by AndrewGSW

I'm not sure if you caught my previous post: who is the email From?

The server will send a text anonymously. There is to from, just a $to variable

[Fou-Lu]

Originally Posted by amcf1992

The server will send a text anonymously. There is to from, just a $to variable

From is a required field to send email. If its not configured on the server end, you must provide a from header in the email.