PHP - Logical Database Sending Error

I have a PHP Form where users have to enter and upload a file but when they click upload everything is working except that it is only sending first character of text field to Database!

Can any one help??

Thanks

File upload.php form
Code: [Select]
<form action="add_file.php" method="post" enctype="multipart/form-data">
           <p><br>
      JobID:
        <input name="JobID" type="text" value="<?php echo $row_Recordset1['JobID']; ?>" readonly="readonly" />
    </p>
    <p>Company ID:
      <input name="CompanyID" type="text" value="<?php echo $row_Recordset1['CompanyID']; ?>" readonly="readonly" />
  </p>
    <p>UserID:
      <input name="UsersID" type="text" />
    </p>
    <p>Select File to upload:
      <input type="file" name="uploaded_file" />
  </p>
    <p>Make Sure All Details Are Correct before Submitting!</p>
    <p>
      <input type="submit" value="Submit Application" />
    </p>
        <form>   

add_file.php

// Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) {
    // Make sure the file was sent without errors
    if($_FILES['uploaded_file']['error'] == 0) {
        // Connect to the database
        $dbLink = new mysqli('localhost', 'user', 'password', 'phpsite');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $JobID = $dbLink->real_escape_string($_POST['JobID']['JobID']);
      $CompanyID = $dbLink->real_escape_string($_POST['CompanyID']['CompanyID']);
      $UsersID = $dbLink->real_escape_string($_POST['UsersID']['UsersID']);
      $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
       $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `application` (
                `JobID`, `CompanyID`, `UsersID`, `name`, `mime`, `size`, `data`, `N_DateAndTime`
            )
            VALUES (
                '{$JobID}', '{$CompanyID}', '{$UsersID}', '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 
 
        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your job application was successfully sent!';
        }
        else {
            echo 'Error! Failed to insert the file, please try again'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded, please try again. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent! Please try again!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="year1index.php">here</a> to go back</p>';
?>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi there,

I am using this code to send the users email address to the database. That works fine, but i keep getting blank info added to the database. Does anyone know how i can stop this?

<?php
$con = mysql_connect("*","*","*");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ogs_mailinglist1", $con);

$sql="INSERT INTO mailinglist (email)
VALUES
('$_POST[rec_email]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);
?>



Thanks,

I have no idea what im doing wrong but this just isnt working, theres no error messages but im not getting any of the emails. Here is all the code that i had anything to do with editing, i have removed any personal info from it.

Code: [Select]
<?php
$dbhost = 'localhost';
$dbuser = ' ';
$dbpass = ' ';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

mysql_select_db(" ", $conn);

$result = mysql_query("SELECT ****, ********** FROM **** WHERE name='*****'");

while($row = mysql_fetch_array($result))
{
$message =
"<p><u><b><font size=\"5\" color=\"#800080\">********************</font></b></u></p>
<p><b><font color=\"#800080\" size=\"4\">**************************************************</font></b></p>
<p><b><font color=\"#800080\">*********</font></b> <b><font color=\"#333333\">**********</font></b></p>
<p><b><font color=\"#800080\">********</font></b> <font color=\"#333333\"><b>***********</b></font></p>
<p><font color=\"#800080\"><b>*******</b></font> <font color=\"#333333\"><a href=\"***********************************************</a></font></p>
<p>&nbsp;</p>";
}

$query=mysql_query('SELECT `email`,`name` FROM `users`'); //grab emails and names from database
while($row = mysql_fetch_array($query)) //start a loop to send an email to each individual
{
    //mail function with $row['email'] as the email address
    //I'm using phpmailer as an example here - - >
    include_once('phpMailer/class.phpmailer.php');
    
    $mail             = new PHPMailer(); // defaults to using php "mail()"
    
    $body             = $message; //message inside the email
    
    $mail->From       = "**************"; //email address that the email is being sent from
    $mail->FromName   = "*************"; //more in depth for who the mail is from.
    
    $mail->Subject    = "***********************************"; //The subject for the message
    
    //$mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test
    
    
    $mail->AddAddress($row[email], $row['name']);
} 

mysql_close($conn);
?>

I have been working a a program to send text messages using php  but my headers containing the "From:" part of the text message keep on returning an error. Could someone please explain what i'm doing wrong. I have attached the php script and the html page I am using as a form.   
<?php
$from = $_POST['from'];
$to = $_POST['to'];
$carrier = $_POST['carrier'];
$carrierFrom = $_POST['carrierFrom']
$message = stripslashes($_POST['message']);

//From Function

 if ($carrierFrom == "verizon") 
{$formatted_from = $from."@vtext.com";}

 if ($carrierFrom == "tmobile") 
{$formatted_from = $from."@tomomail.net";}

 if ($carrierFrom == "sprint") 
{$formatted_from = $from."@messaging.sprintpcs.com";}

if ($carrierFrom == "att") {
$formatted_from = $from."@txt.att.net";

if ($carrierFrom == "gmail") {
$formatted_from = $from."@gmail.com";
}

//To Function

 if ($carrierFrom == "verizon")
{$formatted_number = $to."@vtext.com";}

 if ($carrier == "tmobile") 
{$formatted_number = $to."@tomomail.net";}

if ($carrier == "sprint") 
{$formatted_number = $to."@messaging.sprintpcs.com";}

 if ($carrier == "att") 
{$formatted_number = $to."@txt.att.net";}

 if ($carrier == "gmail") 
{$formatted_number = $to."@gmail.com";}

//Send

$sent = mail($formatted_number,$message,$formattedFrom) ; 
if($sent) 
{print "Your text was sent successfully"; }
else 
{print "We encountered an error sending your text"; }

?>

hey everyone. I'm working on a site (built almost from scratch) and i used a book which implements a design i'm not all too confident about, but i'll try it out. Anywho there is one thing that bugs me, and that is that I don't know how to properly setup error messages. For example, the login page does this:
* gather data
* send $_POST data to process.inc.php
* process.inc.php handles the object implementation, and sends you to the dashboard if your login is successful and returns you to the login page if the login attempt is unsuccessful

However, on the last one, if I have to send the user back to the page because of a failed attempt, i'd like to display an error message, but I'm not clear on the best way of doing this considering the request isn't handled by PHP_SELF.

I hope I made sense. If not, I'll gladly try to clear up any confusion, and thanks in advance

Hi,

I'm getting the below error while sending mail.

Error:
Code: [Select]
Warning: mail() [function.mail]: SMTP server response: 550 5.7.1 Unable to relay for cys@kdkd.com in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mail.php on line 39

Code:
Code: [Select]
  if (isset($_POST["submit"])) {

    $to = strip_tags($_POST["to"]);
    $sub = strip_tags($_POST["sub"]);
    $feedback = strip_tags($_POST["feedback"]);
    $from = strip_tags($_POST["from"]);
    $to= "xyz@gmail.com";
    $sendto = $to;
    $subject = $sub;
    $message = $feedback;
    $headers ="MIME-Version:1.0\r\n";
    $headers .="content-type:text/html; Charset=iso-8859-1\r\n";
    $headers .="From:     <" . "$from" . ">\r\n";
    $headers .="X-Sender: <" . "$sendto" . ">\r\n";
    $headers .="Return-Path: <" . "$sendto" . ">\r\n";
    $headers .="Error-To: <" . "$sendto" . ">\r\n";
    $sendto = trim($sendto);
     $themail= mail($sendto, $subject, $message, $headers) ;
     
   
  }

Kindly help.
Thanks,
Ramki

Here is a link to screenshots of what is happening, because I'm crappy at describing things: http://imgur.com/a/ahvPA

Of course I've messed the code up somewhere, but I can't for the life of me figure out where. I have a simple page for someone to enter text in a textbox to save in a database to display on another page. There are 10 textboxes on the page. I can enter text into any and all textboxes and it'll save the data in the database, EXCEPT if I enter text into the 2nd textbox. If there's anything in the 2nd textbox after I click submit, it will delete whatever was in the 2nd textbox and move all data in each textbox (except textbox 1, which stays in the same place) down one element. And it pushes the data in the final textbox off the page (presumably because there's no other textbox to accept its data). Here is the code to the two pages affected. Any help would be appreciated!


Code: [Select]
<?php

// start the session
session_start();

if (!session_is_registered($_SESSION['myusername'])) {
   header ('location:./login.php');
}
$i=1; 
require_once('./dbconnect.php');
$sql="SELECT `event` FROM `events`";
$result=mysql_query($sql);
mysql_close();

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
   <title>Admin Portal</title>
</head>
   <body>
      <form name="events" method="post" action="eventlogging.php">
         <table width="800" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
            <tr>
               <td>
                  <table width="100%" border="0" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF">
                     <tr>
                        <td colspan="3" bgcolor="#CCCCCC">
                           <strong><p><strong>Admin Portal</strong></p><p align="right"><small><a href="./logout.php">Logout</a></small>
                        </td>
                     </tr>
<?php
while ($i<11) {
   echo '                     <tr align="center">
                        <td align="right" width="100">Event ' . $i . '
                        </td>
                        <td width="800">
                           <textarea name=event' . $i . ' cols=40 rows=5>'; 
   $row = mysql_fetch_array($result); 
   if ($row) {
      $msg=$row[0];
      echo $msg; 
   }; 
$i++;
echo  '</textarea>
                        </td>
                     </tr>
';
} 
?>
                     <tr>
                        <td colspan="2">
                           <center><input type="submit" name="Submit" value="Submit" /></center>
                           <input type="hidden" name="submitted" value="true" />
                        </td>
                     </tr>
                        </td>
                     </tr>
                  </table>
               </td>
            </tr>
         </table>
      </form>
   </body>
</html>
<?php
$position = 1;
$dbControl = 9;
$event = array();

if (!empty($_POST['event1'])) {
   $event[] = $_POST['event1'];
}

if (!empty($_POST['event2'])) {
   $event[] = $_POST['event'];
}

if (!empty($_POST['event2'])) {
   $event[] = $_POST['event'];
}

if (!empty($_POST['event3'])) {
   $event[] = $_POST['event3'];
}

if (!empty($_POST['event4'])) {
   $event[] = $_POST['event4'];
}

if (!empty($_POST['event5'])) {
   $event[] = $_POST['event5'];
}

if (!empty($_POST['event6'])) {
   $event[] = $_POST['event6'];
}

if (!empty($_POST['event7'])) {
   $event[] = $_POST['event7'];
}

if (!empty($_POST['event8'])) {
   $event[] = $_POST['event8'];
}

if (!empty($_POST['event9'])) {
   $event[] = $_POST['event9'];
}

if (!empty($_POST['event10'])) {
   $event[] = $_POST['event10'];
}

include ('./dbconnect.php');
mysql_query("DELETE FROM `events`");
foreach ($event as $msg) {
   mysql_query("INSERT INTO `events` (`position`, `event`, `date`) VALUES ('$position', '$msg', curdate() )") or die(mysql_error());
   $position++;
}

mysql_close();


$position=1;

/* foreach ($event as $msg) {
   echo $position . '. ' . $msg . '<br />';
   $position++;
} */
header("location:./admin.php");

?>

I have an HTML form that I have a "select"  drop-down menu that is selecting the name of the person you should send to. The names are being pulled from the Database, and here is what that code for the drop-down in the form looks like:
<?php  
echo '<select name= "First_Name" , "Last_Name">'; 
while( $array = mysql_fetch_assoc($result) ) { 
    $text_for_select = $array["First_Name"] . " " . $array["Last_Name"]. " " . $array["District"]; 
$value_for_select = $array["First_Name"] . " " . $array["Last_Name"] . "_" . $array["id"]; 
echo "<option></option>\n"; 
echo "<option value=\"$value_for_select\">$text_for_select</option>\n";  
} 
echo '</select>';?>

This works perfectly. However, what I want it to do is send the form to the email address of the person that is selected in the drop-down. The email address' are already entered in each record of the database in a field called "Email". I am using the $value_for_select variable to pull the id of the record, but I am unsure how to then tell the form to send to the email address of that record? Anybody know a way that this can be done?

Here is the code of the for that should be sent:
 <?php  
    if($_POST){ 
    $to = $email; 
    $subject = "WHAT SHOULD THIS BE";     
    $message  =  "Date: $date\n\r". 
                 "Dear $First_Name, $Last_Name,\n\r". 
                 "Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah.Blah Blah BLah..\n\r". 
                 
                "Sincerely,\n". 
                "$name \n". 
                "$street \n". 
                "$city, $zip \n". 
                "$email \\n". 
    $headers = "From: $email"; 
    mail($to, $subject, $message, $headers); 
    // SUCCESS! 
    echo '<p class="notice">'. 
        'Thank you for your submission.  '. 
          '</p>'; 
    // clear out the variables for good-housekeeping 
    unset($date,$legislator,$bill,$name,$street,$city,$zip,$email); 
    $_POST = array(); 
} 
?>


Please help!
 

I handle MySQL errors like this:

function handle_error($err) {
     throw new Exception($err);
}
try {     
     $con = mysql_connect("", "", "") or handle_error("mysql_connect failed! ");
     mysql_select_db("") or handle_error("mysql_select_db failed! ");
     $sql = "SELECT blah blah blah ...";
     $result = mysql_query($sql, $con) or handle_error("mysql_query failed! ");                   
}
catch(exception $e) {                                           
     // Log error in error_log file.     
     trigger_error($e->getMessage() . mysql_error(), E_USER_WARNING);     
     // Send yourself an email.     
     error_log($e->getMessage() . "Date: " . date("l jS \of F, Y, h:i:s A") . ". File: " . $_SERVER['REQUEST_URI'], 1, "example@aol.com", "From: example@yahoo.com");
}
if(isset($result)) {
     blah blah blah ...
}

The problem is, I can receive a huge number of e-mails whenever there's a connection error.   How can I limit the number of e-mails that I send myself in the event that my database fails?   I really haven't a clue.   The only idea that I had was store the time that I sent the first e-mail in a database and then check the database before sending any other e-mails. But this obviously won't work because MySQL won't be working.   Any ideas will be much appreciated.

I made a bot, that scrapes content from a forum, i cant access the forum in work, so am trying to make something discreat to read it on my own site while at work. Anyway the links to threads are something like this.

I got help and i know how to extract the unique thread number using regex. However i have a problem. What i really need, now that i think about it, is a way of getting the thread number and the thread title (so i can make sense of what im reading.) The thread title is in the setWindowStatus function.  I cant think of a way to do it. I dont even know if it would work in an array what id basically like is something that says

1) Thread title - Thread id
2) Thread title - Thread id

etc

that is stored in a way that i can easily manipulate.

Code: [Select]
<img src="http://s2.images.proboards.com/xx.gif" alt=" " border="0"/></font></td><td class="windowbg" bgcolor="FFFFFF" width="48%" style="cursor:pointer;" onClick="if(!pb_bubble)location.href='/index.cgi?board=general&action=display&thread=13483';" onMouseOver="mouseOverHighlightCell(this);setWindowStatus('Lurkers, show your face ');return true;

Okay i'm trying to compare these sets of variables.

code looks like this..

Code: [Select]
if(
               $row->cash > $finalcash &&
               $row->core1 > $finalcore1 &&
               $row->core2 > $finalcore2 &&
               $row->core3 > $finalcore3 &&
               $row->core4 > $finalcore4
               ) {
return true;
}
else {
return false;
}
First question is this the appropriate way of doing this?

Or would a nested if statement work better?

example:

Code: [Select]
if ($row->cash > $finalcash) {
    if ($row->core1 > $finalcore1) {
        if ($row->core2 > $finalcore2) {
            if ($row->core3 > $finalcore3) {
                if ($row->core4 > $finalcore4) {
                   
                } else {
                    return false;
                }
            } else {
                return false;
            }
        } else {
            return false;
        }
    } else {
        return false;
    }
} else {
    return false;
}
I know it looks pretty messy, so i'm wondering if anybody is aware of an alternative to achieving this?

In php is there a way to shortcut logical operators... example:

Code: [Select]
if ($row['CustomerSaas'] == 'Yes' && ($row['CustomerSaasPaidStatus'] == 'Trial' || $row['CustomerSaasPaidStatus'] == 'Trial Ended')) {
to
Code: [Select]
if ($row['CustomerSaas'] == 'Yes' && ($row['CustomerSaasPaidStatus'] == 'Trial' || 'Trial Ended')) {

im trying to make a salary system which would display a month salary according to login hours so i got two different  tables storing data like   1. users table  id, name, password, salary 2.attendance table  id, user_id, Employee_Name, Remark, Login_Hours, Date   so what im looking to do is fetch all users id, name and salary from users table and then match it with attendance user_id,Employee_Name ,Login_Hours, table and then also count numbers of result for a particular year-month so that i could do the hourly wage calculation.   could someone help out i got no idea how to achieve it   apprieciate your help, thanks   i tried something like this it does output something but still dunno how to match results of both tables and get result  

$date = '2014-11';

$query1 = "SELECT COUNT(*) as num FROM attendance WHERE Date LIKE '%".$date."%' AND Employee_Name='moses'";
$total_pages = mysql_fetch_array(mysql_query($query1));
     $total_res = $total_res[num]; // total rows counting of total office days of a month
    
$result2=mysql_query("SELECT id, user_id, Employee_Name, Remark, SUM(Login_Hours), Date FROM attendance WHERE Employee_Name='moses'");
while($row = mysql_fetch_array($result2)){
     echo $sal_to_month = 9000/$total_res; //9000 is salary should be fetched from users table
     echo '<br/>';
       echo  $sal_to_month/9*$row['SUM(Login_Hours)'];
}

Hi there,   This may not be the correct space to post this - but I'm very new to all this.   I've created a page that will run a php script to output a query. I would then like to send that same query via email - however from a design perspective I don't think the correct process is to click 'submit' to view the query and then 'submit' to send the result via email?   Can you please advise on some design solutions regarding this issue?   Thanks!